Charter School Waitlist Import

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_CD	1 digit GEN_CD must be used if not blank	Generation Code.
DOB	YYYYMMDD	Date of Birth.
SEX	F or M	Gender.
GRD_LVL	2 character GRD_LVL_CD must be used EE PK KG 01-12
STU_ID_NUM	Up to 10 characters Parent provided number
UNIQUE_STU_ID	10 numeric
OTH_CHILD_ATTEND_CHART	Use 0 or 1 0 - No 1 -Yes
CHILD_STF_BOARD_MEMB	Use 0 or 1 0 - No 1 -Yes
GUARDIAN_NAME_L	Up to 60 Characters
GUARDIAN_NAME_F	Up to 60 Characters
STR_NBR	Up to 6 characters
STR_NAME	Up to 19 characters
APT_NBR	Up to 7 characters
CITY	Up to 17 characters
STATE_CD	2 character state abbreviation
ZIP	5 numeric
ZIP4	4 numeric
PHONE_AREA_CD	3 numeric
PHONE_NBR	7 numeric
EMAIL	Up to 64 characters
LAST_FOUR_SSN	4 numeric Parent provided
NAME_OTHER_CHILD	Up to 300 characters should only have a value if oth_child_attend_chart is 1
NAME_STAFF_BRDMEM	Up to 300 characters should only have a value if child_stf_boarrd_memb is 1
CAMPUS_ID	3 numeric campus number zero-pad (ex: 001 101)
STATE_STU_ID	9 numeric Social Security or S number

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

Interfaces