student:charter_school_waitlist_import
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| student:charter_school_waitlist_import [2020/10/13 22:51] – lrosdahl | student:charter_school_waitlist_import [2025/09/08 18:46] (current) – lrosdahl | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======Charter School Waitlist Import====== | ======Charter School Waitlist Import====== | ||
| - | |Column Name| Column Width | Notes | | + | Use this record layout |
| - | |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 | + | |
| - | |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 | + | |
| - | |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| State Student ID. | + | |
| - | + | ||
| - | 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 | + | |
| + | <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.1602629488.txt.gz · Last modified: 2020/10/13 17:51 (external edit)