This is an old revision of the document!
This on-demand interface will import Charter School Waitlists in .csv format.
| 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. |
| 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