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:20] – lrosdahlstudent: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 to import Charter School Waitlist data into ASCENDER. The import file is a comma-delimited text file. 
-|NAME_L |Up to 60 characters.| Last Name.| + 
-|NAME_F |Up to 60 characters.| First Name.| +<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_M |Up to 60 characters.| Middle Name.| +Each field needs to be accounted for in the input record.</WRAP> 
-|NAME_GEN_CD|One digit Generation Code must be used if not blank.| Generation Code.| + 
-|DOB|YYYYMMDD| Date of Birth.| +^Description^Length^Notes^ 
-|SEX|F or M| Gender. | +|Student Last Name|60| | 
-|GRD_LVL|Two character Grade Level Code must be used: EE, PK, KG, 01-12| Grade Level.| +|Student First Name|60| | 
-|STU_ID_NUM|Up to 10 characters and provided by the parent/guardian.| Student ID.| +|Student Middle|60|Add a space if no middle initial.| 
-|UNIQUE_STU_ID|Ten, numeric.| Unique Student ID.| +|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| 
-|OTH_CHILD_ATTEND_CHART |Use 0 or 1: 0 - No 1 -Yes. | Other Child Attending.| +|Date of Birth|8|YYYYMMDD| 
-|CHILD_STF_BOARD_MEMB |Use 0 or 1: 0 - No 1 -Yes. | Staff/Board Member Child.| +|Sex|1|F or M| 
-|GUARDIAN_NAME_L |Up to 60 characters.| Guardian Last Name.| +|Grade Level|2|EE, PK, KG, or 01-12| 
-|GUARDIAN_NAME_F |Up to 60 characters.| Guardian First Name.| +|Student ID|10|Parent provided number.| 
-|STR_NBR |Up to 6 characters.| Street Number.| +|Unique Student ID|10| | 
-|STR_NAME |Up to 19 characters.| Street Name. | +|Other Child(ren) Attending Charter School|1| Y or N| 
-|APT_NBR |Up to 7 characters.| Apartment Number.| +|Child of Staff or Board Member|1|Y or N| 
-|CITY |Up to 17 characters.| City.| +|Guardian Last Name|60 | | 
-|STATE_CD |Two characters, state abbreviation.| State Code.| +|Guardian First Name|60| | 
-|ZIP |Five, numeric.| ZIP Code.| +|Street Number|6| | 
-|ZIP4 |Four, numeric.| Plus-Four ZIP Code.| +|Street Name|19| | 
-|PHONE_AREA_CD |Three, numeric.| Area Code.| +|Apartment Number|7| | 
-|PHONE_NBR |Seven, numeric.| Phone Number.| +|City|17| | 
-|EMAIL |Up to 64 characters.| Email. | +|State|2|Use abbreviation| 
-|LAST_FOUR_SSN |Four, numeric and provided by the parent/guardian| Last Four of Social Security Number.| +|Zip Code|5| | 
-|NAME_OTHER_CHILD |Up to 300 characters and should only have a value if the Other Child Attending is 1|Other Child Name.| +|Zip Code 4|4|Plus-four digits| 
-|NAME_STAFF_BRDMEM |Up to 300 characters should only have a value if child_stf_boarrd_memb is 1| Name of Staff/Board Member.| +|Contact Area Code|3| | 
-|CAMPUS_ID |3 numeric campus number zero-pad (ex: 001 101)| Campus ID.| +|Contact Phone Number|7| | 
-|STATE_STU_ID |9 numeric Social Security or S number| State Student ID.+|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|
  
-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 
student/charter_school_waitlist_import.1602631250.txt.gz · Last modified: 2020/10/13 18:20 (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.