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/14 12:44] – 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 to ASCENDER/TxEIS.</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 ^ +
-|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/guardian.| Student ID.| +
-|UNIQUE_STU_ID|Ten, 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 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, 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 1.|Other Child Name.| +
-|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, numeric. Campus number zero-pad (ex: 001 101).| Campus ID.| +
-|STATE_STU_ID|Nine, numeric. Social Security or S number| State Student ID.| +
- +
-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 +
- +
  
 +<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^
 +|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.1602679474.txt.gz · Last modified: 2020/10/14 07:44 (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.