User Tools

Site Tools


student:charter_school_waitlist_import

This is an old revision of the document!


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_CDOne digit Generation Code 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_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 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 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 1Other 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

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