Interfaces

User Tools

Site Tools

Trace: • Charter School Waitlist Import
student:charter_school_waitlist_import

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:charter_school_waitlist_import [2020/10/13 23:26] – lrosdahlstudent: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>This on-demand interface will import Charter School Waitlists in .csv format.</div>+Use this record layout to import Charter School Waitlist data into ASCENDER. The import file is a comma-delimited text file.
  
-^Column Name^ Column Width ^ Notes ^ +<WRAP box>**NOTE:** Each field has a fixed length, except the name fields. The name fields are truncated, so no additional spaces are needed.\\  
-|NAME_L |Up to 60 characters.| Last Name.| +Each field needs to be accounted for in the input record.</WRAP> 
-|NAME_F |Up to 60 characters.| First Name.| + 
-|NAME_M |Up to 60 characters.| Middle Name.| +^Description^Length^Notes^ 
-|NAME_GEN_CD|One digit Generation Code (see below) must be used if not blank.| Generation Code.| +|Student Last Name|60| | 
-|DOB|YYYYMMDD| Date of Birth.| +|Student First Name|60| | 
-|SEX|F or M| Gender. | +|Student Middle|60|Add a space if no middle initial.| 
-|GRD_LVL|Two-character Grade Level Code must be used: EE, PK, KG, 01-12| Grade Level.| +|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| 
-|STU_ID_NUM|Up to 10 characters and provided by the parent/guardian.| Student ID.| +|Date of Birth|8|YYYYMMDD| 
-|UNIQUE_STU_ID|Ten, numeric.| Unique Student ID.| +|Sex|1|F or M| 
-|OTH_CHILD_ATTEND_CHART|Use 0 or 1: 0 - No, 1 -Yes. | Other Child Attending.| +|Grade Level|2|EE, PK, KG, or 01-12| 
-|CHILD_STF_BOARD_MEMB|Use 0 or 1: 0 - No, 1 -Yes. | Staff/Board Member Child.| +|Student ID|10|Parent provided number.| 
-|GUARDIAN_NAME_L|Up to 60 characters.| Guardian Last Name.| +|Unique Student ID|10| | 
-|GUARDIAN_NAME_F|Up to 60 characters.| Guardian First Name.| +|Other Child(ren) Attending Charter School|1| Y or N| 
-|STR_NBR|Up to six characters.| Street Number.| +|Child of Staff or Board Member|1|Y or N| 
-|STR_NAME|Up to 19 characters.| Street Name. | +|Guardian Last Name|60 | | 
-|APT_NBR|Up to seven characters.| Apartment Number.| +|Guardian First Name|60| | 
-|CITY|Up to 17 characters.| City.| +|Street Number|6| | 
-|STATE_CD|Two characters, state abbreviation.| State Code.| +|Street Name|19| | 
-|ZIP|Five, numeric.| ZIP Code.| +|Apartment Number|7| | 
-|ZIP4|Four, numeric.| Plus-Four ZIP Code.| +|City|17| | 
-|PHONE_AREA_CD|Three, numeric.| Area Code.| +|State|2|Use abbreviation| 
-|PHONE_NBR|Seven, numeric.| Phone Number.| +|Zip Code|5| | 
-|EMAIL |Up to 64 characters.| Email. | +|Zip Code 4|4|Plus-four digits| 
-|LAST_FOUR_SSN |Four, numeric and provided by the parent/guardian| Last Four of Social Security Number.| +|Contact Area Code|3| | 
-|NAME_OTHER_CHILD|Up to 300 characters and should only have a value if the Other Child Attending is 1|Other Child Name.| +|Contact Phone Number|7| | 
-|NAME_STAFF_BRDMEM|Up to 300 characters should only have a value if child_stf_boarrd_memb is 1| Name of Staff/Board Member.| +|Email Address|64| | 
-|CAMPUS_ID|3 numeric campus number zero-pad (ex: 001 101)| Campus ID.| +|Last 4 digits SSN|4|Parent provided number.| 
-|STATE_STU_ID|9 numeric Social Security or S number| State Student ID.+|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|
  
-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 
student/charter_school_waitlist_import.1602631563.txt.gz · Last modified: 2020/10/13 18:26 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.