Interfaces

User Tools

Site Tools

Trace: • Charter School Waitlist Import
student:charter_school_waitlist_import
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book (0 page(s))
 Help

This is an old revision of the document!

Charter School Waitlist Import

This on-demand interface will import Charter School Waitlists in .csv format to ASCENDER/TxEIS.

Column Name Column Width Notes
NAME_L Up to 60 characters. Last Name.
NAME_F Up to 60 characters. First Name.
NAME_M Up to 60 characters. Middle Name.
NAME_GEN_CDOne digit Generation Code (see below) must be used if not blank. Generation Code.
DOBYYYYMMDD Date of Birth.
SEXF or M Gender.
GRD_LVLTwo-character Grade Level Code must be used: EE, PK, KG, 01-12 Grade Level.
STU_ID_NUMUp to 10 characters and provided by the parent/guardian. Student ID.
UNIQUE_STU_IDTen, numeric. Unique Student ID.
OTH_CHILD_ATTEND_CHARTUse 0 or 1: 0 - No, 1 -Yes. Other Child Attending.
CHILD_STF_BOARD_MEMBUse 0 or 1: 0 - No, 1 -Yes. Staff/Board Member Child.
GUARDIAN_NAME_LUp to 60 characters. Guardian Last Name.
GUARDIAN_NAME_FUp to 60 characters. Guardian First Name.
STR_NBRUp to six characters. Street Number.
STR_NAMEUp to 19 characters. Street Name.
APT_NBRUp to seven characters. Apartment Number.
CITYUp to 17 characters. City.
STATE_CDTwo characters, state abbreviation. State Code.
ZIPFive, numeric. ZIP Code.
ZIP4Four, numeric. Plus-Four ZIP Code.
PHONE_AREA_CDThree, numeric. Area Code.
PHONE_NBRSeven, numeric. Phone Number.
EMAIL Up to 64 characters. Email.
LAST_FOUR_SSN Four, numeric and provided by the parent/guardian Last Four of Social Security Number.
NAME_OTHER_CHILDUp to 300 characters and should only have a value if the Other Child Attending is 1.Other Child Name.
NAME_STAFF_BRDMEMUp to 300 characters should only have a value if Staff/Board Member Child is 1. Name of Staff/Board Member.
CAMPUS_IDThree, numeric. Campus number zero-pad (ex: 001 101). Campus ID.
STATE_STU_IDNine, numeric. Social Security or S number State Student ID.

Generation Codes: 1 = JR, 2 = SR, 3 = II, 4 = III, 5 = IV, 6 = V, 7 = VI, 8 = VII, 9 = VIII, A = I, B = IX, C = X

Example file with header row:

NAME_LNAME_FNAME_MNAME_GEN_CDDOBSEXGRD_LVLSTU_ID_NUMUNIQUE_STU_IDOTH_CHILD_ATTEND_CHARTCHILD_STF_BOARD_MEMBGUARDIAN_NAME_LGUARDIAN_NAME_FSTR_NBRSTR_NAMEAPT_NBRCITYSTATE_CDZIPZIP4PHONE_AREA_CDPHONE_NBREMAILLAST_FOUR_SSNNAME_OTHER_CHILDNAME_STAFF_BRDMEMCAMPUS_IDSTATE_STU_ID
MartinezTest 20050718F10CSW00000018941156831 001645965123
TestJose 20090728M06CSW00000027853267339 001639210123
OrtegaMia 20110613F04CSW00000037241988353 001636312123
FarrEllijah 20070716M08CSW00000043977268295 001650466123
PerezClaire 20170422FPKCSW00000051769862595 001398553123
GeorgeTiwadola 20170822FPKCSW00000067558243262 001720610123
MichayaMorris 20170123FPKCSW00000084134265762 001S25499123
MartinezMayely 20161114FPKCSW00000098277862253 001499434123
NunoJonathan 20100823F05CSW00000104687127924 001634272123
MataLuis 20150113MKGCSW00000113519452944 001S22686124
MataBrianna 20150113FKGCSW00000123191733523 001S22686123
student/charter_school_waitlist_import.1602676087.txt.gz · Last modified: 2020/10/14 06:48 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.