User Tools

Site Tools


student:charter_school_waitlist_import

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

student/charter_school_waitlist_import.1602631845.txt.gz · Last modified: 2020/10/13 18:30 (external edit)