student:charter_school_waitlist_import
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| student:charter_school_waitlist_import [2021/12/16 15:11] – emoreno | student:charter_school_waitlist_import [2025/09/08 18:46] (current) – lrosdahl | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Charter School Waitlist Import====== | ======Charter School Waitlist Import====== | ||
| - | <div intro round> | + | Use this record layout to import Charter School |
| - | + | ||
| - | ^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/ | + | |
| - | |UNIQUE_STU_ID|Ten, | + | |
| - | |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, | + | |
| - | |PHONE_NBR|Seven, | + | |
| - | |EMAIL |Up to 64 characters.| Email. | | + | |
| - | |LAST_FOUR_SSN |Four, | + | |
| - | |NAME_OTHER_CHILD|Up to 300 characters and should only have a value if the Other Child Attending | + | |
| - | |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, | + | |
| - | |STATE_STU_ID|Nine, | + | |
| - | |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 | + | |
| - | + | ||
| - | ^NAME_L^NAME_F^NAME_M^NAME_GEN_CD^DOB^SEX^GRD_LVL^STU_ID_NUM^UNIQUE_STU_ID^OTH_CHILD_ATTEND_CHART^CHILD_STF_BOARD_MEMB^GUARDIAN_NAME_L^GUARDIAN_NAME_F^STR_NBR^STR_NAME^APT_NBR^CITY^STATE_CD^ZIP^ZIP4^PHONE_AREA_CD^PHONE_NBR^EMAIL^LAST_FOUR_SSN^NAME_OTHER_CHILD^NAME_STAFF_BRDMEM^CAMPUS_ID^STATE_STU_ID^APP_DT^ | + | |
| - | |Martinez|Emily| |1|20050615|F|10|1234567891|8331766831|1|0|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|0|Guardian|Father|1235|Any Street| |ASCENDER|TX|78234| |210|2345678| | | | |041|222334444|20210804| | + | |
| - | |Stevenson|Christina|A| |20110425|F|04|112233|7247788353|0|0|Guardian|Grandma|2345|Any Street|1515|ASCENDER|TX|78345| |210|3456789| | | | |101|555667777|20210729| | + | |
| + | <WRAP box> | ||
| + | Each field needs to be accounted for in the input record.</ | ||
| + | ^Description^Length^Notes^ | ||
| + | |Student Last Name|60| | | ||
| + | |Student First Name|60| | | ||
| + | |Student Middle|60|Add a space if no middle initial.| | ||
| + | |Generation|1|1 = JR, 2 = SR, 3 = II, 4 = III, 5 = IV, 6=V, 7 = VI, 8=VII, 9 = VIII, A = I, B = IX, C = X| | ||
| + | |Date of Birth|8|YYYYMMDD| | ||
| + | |Sex|1|F or M| | ||
| + | |Grade Level|2|EE, PK, KG, or 01-12| | ||
| + | |Student ID|10|Parent provided number.| | ||
| + | |Unique Student ID|10| | | ||
| + | |Other Child(ren) Attending Charter School|1| Y or N| | ||
| + | |Child of Staff or Board Member|1|Y or N| | ||
| + | |Guardian Last Name|60 | | | ||
| + | |Guardian First Name|60| | | ||
| + | |Street Number|6| | | ||
| + | |Street Name|19| | | ||
| + | |Apartment Number|7| | | ||
| + | |City|17| | | ||
| + | |State|2|Use abbreviation| | ||
| + | |Zip Code|5| | | ||
| + | |Zip Code 4|4|Plus-four digits| | ||
| + | |Contact Area Code|3| | | ||
| + | |Contact Phone Number|7| | | ||
| + | |Email Address|64| | | ||
| + | |Last 4 digits SSN|4|Parent provided number.| | ||
| + | |Name(s) of Other Child(ren) Attending Charter School|300| | | ||
| + | |Name of Staff or Board Member|300| | | ||
| + | |Campus ID|3|Ex. 001| | ||
| + | |State Student ID|9|Social Security or S-Number| | ||
| + | |Application Date|8|YYYYMMDD| | ||
| + | |DTS| | | | ||
| + | |Ethnicity Hispanic|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Race American Indian|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Race Asian|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Race Black|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Race Pacific Islander|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Race White|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Campus of Residence Name|300| | | ||
| + | |Campus of Residence Address|9| | | ||
| + | |Never enrolled in a public school|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Another child applying to charter school|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Name of child(ren) applying to charter school|300| | | ||
| + | |Preferred time of day is A.M.|1|0 or 1 must be entered. (0 = No, 1 = Y)| | ||
| + | |Preferred time of day is P.M.|1|0 or 1 must be entered. (0 = No, 1 = Y)| | ||
| + | |Child qualifies for free PK|1|0 or 1 (0 = No, 1 = Y)| | ||
| + | |Preferred method of contact|1|1 = Phone, 2 = Text Message, 3 = Email| | ||
student/charter_school_waitlist_import.1639667490.txt.gz · Last modified: 2021/12/16 10:11 (external edit)