User Tools

Site Tools


student:charterschoolwaitlist_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
student:charterschoolwaitlist_import [2023/08/02 18:18] – created lrosdahlstudent:charterschoolwaitlist_import [2023/10/25 18:59] (current) lrosdahl
Line 1: Line 1:
 ======Charter School Waitlist Import====== ======Charter School Waitlist Import======
  
-Use this record layout to import cafeteria data into ASCENDER. The import file is a comma-delimited text file.+Use this record layout to import Charter School Waitlist data into ASCENDER. The import file is a comma-delimited text file.
  
-<WRAP box>**NOTE:** Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.</WRAP>+<WRAP box>**NOTE:** Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.\\  
 +Each field needs to be accounted for in the input record.</WRAP>
  
 ^Description^Length^Notes^ ^Description^Length^Notes^
-|Record ID|6|CAFIMP+|Student Last Name|60| | 
-|County/District/Campus|9| | +|Student First Name|60| | 
-|Student ID|6| |+|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| |Date of Birth|8|YYYYMMDD|
-|Student Last Name|25| | +|Sex|1|F or M| 
-|Student First Name|17| | +|Grade Level|2|EE, PK, KG, or 01-12| 
-|Student Middle Initial|1|Add a space if no middle initial.+|Student ID|10|Parent provided number.| 
-|Economic Disadvantage Status|2| | +|Unique Student ID|10| | 
- +|Other Child(ren) Attending Charter School|1| Y or N| 
-Example: CAFIMP,030902041,003018,20041010,LOPEZ,MICHAEL,L,00+|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 = No1 = Y)| 
 +|Race Pacific Islander|1|0 or 1 (0 = No1 = Y)| 
 +|Race White|1|0 or 1 (0 = No1 = Y)| 
 +|Campus of Residence Name|300| | 
 +|Campus of Residence Address|9| | 
 +|Never enrolled in a public school|1|0 or 1 (0 = No1 = Y)| 
 +|Another child applying to charter school|1|0 or 1 (0 = No1 = 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 = No1 = Y)| 
 +|Preferred time of day is P.M.|1|0 or 1 must be entered. (0 = No1 = 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/charterschoolwaitlist_import.1691000302.txt.gz · Last modified: 2023/08/02 18:18 by lrosdahl