Charter School Waitlist Import

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

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	One digit Generation Code (see below) must be used if not blank.	Generation Code.
DOB	YYYYMMDD	Date of Birth.
SEX	F or M	Gender.
GRD_LVL	Two-character Grade Level Code must be used: EE, PK, KG, 01-12	Grade Level.
STU_ID_NUM	Up to 10 characters and provided by the parent/guardian.	Student ID.
UNIQUE_STU_ID	Ten, numeric.	Unique Student ID.
OTH_CHILD_ATTEND_CHART	Use 0 or 1: 0 - No, 1 -Yes.	Other Child Attending.
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 six characters.	Street Number.
STR_NAME	Up to 19 characters.	Street Name.
APT_NBR	Up to seven characters.	Apartment Number.
CITY	Up to 17 characters.	City.
STATE_CD	Two characters, state abbreviation.	State Code.
ZIP	Five, numeric.	ZIP Code.
ZIP4	Four, numeric.	Plus-Four ZIP Code.
PHONE_AREA_CD	Three, numeric.	Area Code.
PHONE_NBR	Seven, 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_CHILD	Up to 300 characters and should only have a value if the Other Child Attending is 1.	Other Child Name.
NAME_STAFF_BRDMEM	Up to 300 characters should only have a value if Staff/Board Member Child is 1.	Name of Staff/Board Member.
CAMPUS_ID	Three, numeric. Campus number zero-pad (ex: 001 101).	Campus ID.
STATE_STU_ID	Nine, numeric. Social Security or S number	State Student ID.
APP_DT	YYYYMMDD	Application date.

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 including headers:

NAME_L	NAME_F	NAME_M	NAME_GEN_CD	DOB	SEX	GRD_LVL	STU_ID_NUM	UNIQUE_STU_ID	OTH_CHILD_ATTEND_CHART	GUARDIAN_NAME_L	GUARDIAN_NAME_F	STR_NBR	STR_NAME	APT_NBR	CITY	STATE_CD	ZIP	PHONE_AREA_CD	PHONE_NBR	EMAIL	LAST_FOUR_SSN	NAME_OTHER_CHILD	CAMPUS_ID	STATE_STU_ID	APP_DT
Martinez	Emily		1	20050615	F	10	1234567891	8331766831	1	Guardian	Mother	1234	Any Street		ASCENDER	TX	78123	210	1234567	contactme@gmail.com	1234	Billy Martinez	001	111223333	20210801
Mills	Spencer		2	20090515	M	06	CSW000001	7874467339	0	Guardian	Father	1235	Any Street		ASCENDER	TX	78234	210	2345678				041	222334444	20210804
Stevenson	Christina	A		20110425	F	04	112233	7247788353	0	Guardian	Grandma	2345	Any Street	1515	ASCENDER	TX	78345	210	3456789				101	555667777	20210729

Interfaces

Charter School Waitlist Import

Americans with Disabilities Act (ADA) and Web Accessibility

Interfaces

User Tools

Site Tools

Charter School Waitlist Import

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility