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	Grade Level.
STU_ID_NUM	Up to 10 characters Parent provided number	Student ID.
UNIQUE_STU_ID	10 numeric	Unique Student ID.
OTH_CHILD_ATTEND_CHART	Use 0 or 1 0 - No 1 -Yes	Other Child Attendance.
CHILD_STF_BOARD_MEMB	Use 0 or 1 0 - No 1 -Yes	Staff/Board Member Child.
GUARDIAN_NAME_L	Up to 60 Characters	Guardian Last Name.
GUARDIAN_NAME_F	Up to 60 Characters	Guardian First Name.
STR_NBR	Up to 6 characters	Street Number.
STR_NAME	Up to 19 characters	Street Name.
APT_NBR	Up to 7 characters	Apartment Number.
CITY	Up to 17 characters	City.
STATE_CD	2 character state abbreviation	State Code.
ZIP	5 numeric	ZIP Code.
ZIP4	4 numeric	Plus-Four ZIP Code.
PHONE_AREA_CD	3 numeric	Area Code.
PHONE_NBR	7 numeric	Phone Number.
EMAIL	Up to 64 characters	Email.
LAST_FOUR_SSN	4 numeric Parent provided	Last Four of Social Security Number.
NAME_OTHER_CHILD	Up to 300 characters should only have a value if oth_child_attend_chart is 1	Other Child Name.
NAME_STAFF_BRDMEM	Up to 300 characters should only have a value if child_stf_boarrd_memb is 1	Name of Staff/Board Member.
CAMPUS_ID	3 numeric campus number zero-pad (ex: 001 101)	Campus ID.
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