student:registration_export
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help This is an old revision of the document!
Registration Export
Used with ZippSlip.
| Student ID | 6 char for existing students; longer for new | Student ID |
| ZippSlip Stu Id | This is the Student ID sent from ZippSlip in the import file. It starts with ZS and can be upto 24 Characters | STU_KEY |
| School Year | 4 char | School Year |
| Campus | 3 char | Campus ID |
| date entry | YYYYMMDD (8 Char) | Entry Date |
| Social Security Number | 999999999 (9 Char) | State Student ID |
| Last Name | 25 char | Last Name |
| First Name | 17 char | First Name |
| Grade Level | 2 char | GRD_LVL |
| Middle Name | 14 char | Middle Name |
| Gen Code | Valid values from ET_C012_Generation table (1 char) | Generation |
| Street Nbr | 6 char | Street Number |
| Street Direction | 2 char | Street Direction |
| Street Name | 19 char | Street Name |
| Apt Number | 7 char | Apartment Number |
| City | 17 char | City |
| State | 2 char | State |
| ZIP Code | 5 char | ZIP Code |
| ZIP Code+4 | 4 char | ZIP Code4 |
| Date of Birth | YYYYMMDD (8 Char) | Date of Birth |
| Sex | 1 char (M or F) | Sex |
| Physical Street Nbr | 6 char | Street Number |
| Physical Street Direction | 2 char | Street Direction |
| Physical Street Name | 19 char | Street Name |
| Physical Apt Nbr | 7 char | Apartment Number |
| Physical City | 17 char | City |
| Physical ZIP Code | 5 char | ZIP Code |
| Physical ZIP Code+4 | 4 char | ZIP Plus Four |
| Student Home AC | 3 char | Student Phone Area Code |
| Student Home Phone Nbr | 7 char (no hyphen) | Phone Number |
| Ethnicity Hispanic | Y or N | Hispanic |
| Race Black | Y or N | African American |
| Race White | Y or N | White |
| Race Pacific Islander | Y or N | Pacific Islander |
| Race Am. Ind/Alaskan | Y or N | American Indian/Alaskan |
| Race Asian | Y or N | Asian |
| Student Previous District Name | 13 char | Previous District |
| Student Previous Campus Name | 34 char | Previous District |
| Student Birth State | This is a place holder .We are sending spaces now and the data received from ZippSlip is not uploaded to any tables. | |
| Student Birth City | This is a place holder .We are sending spaces now and the data received from ZippSlip is not uploaded to any tables. | |
| Contact1 LAST NAME | 25 char | Last Name |
| Contact1 FIRST NAME | 17 char | First Name |
| Contact1 MIDDLE NAME | 14 char | Middle Name |
| Contact1 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact1 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact1 Primary Flag | 1 char | Primary Contact |
| Contact1 Emergency Flag | 1 char | Emergency Contact |
| Contact1 Migrant Flag | 1 char | Migrant |
| Contact1 STREET NBR | 6 char | Street Number |
| Contact1 STREET NAME | 19 char | Street Name |
| Contact1 APT NBR | 7 char | Apartment Number |
| Contact1 City | 17 char | City |
| Contact1 STATE | 2 char | State |
| Contact1 ZIP Code | 5 char | ZIP |
| Contact1 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact1 HOME PHONE AC | 3 char | Phone Area Code |
| Contact1 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact1 WORK PHONE AC | 3 char | Phone Area Code |
| Contact1 WORK PHONE NBR | 7 char | Phone Number |
| Contact1 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact1 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact1 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact1 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact1 Occup | 25 char | Occupation |
| Contact1 Email | 64 char | |
| Contact1 Date of Birth | YYYYMMDD | Date of Birth |
| Contact1 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT1 MIL IND | 1 char | Military |
| Contact1 MIL BRANCH | 1 char | Military Branch |
| Contact1 MIL RANK | 5 char | Military Rank |
| Contact1 TRANSPORT IND | 1 char | Transportation |
| Contact1 VEH MAKE | 15 char | Vehicle Make |
| Contact1 VEH MODEL | 15 char | Vehicle Model |
| Contact1 VEH COLOR | 10 char | Vehicle Color |
| Contact1 VEH LIC | 8 char | License Plate Number |
| Contact1 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact1 DRV LIC NBR | 21 char | Drivers License Number |
| Contact1 DRV LIC ST | 2 char | Drivers License State |
| Contact1 SCH YR | 4 char | School Year |
| Contact1 SEQ NBR | Integer | Priority |
| Contact1 LANG CD | 2 char | Language |
| Contact1 CELL PHN | 10 char | Cell Phone Number |
| Contact1 PHN PREF | 1 char | Phone Preference |
| Contact1 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact1 PRTY | Integer | Priority |
| Contact2 LAST NAME | 25 char | Last Name |
| Contact2 FIRST NAME | 17 char | First Name |
| Contact2 MIDDLE NAME | 14 char | Middle Name |
| Contact2 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact2 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact2 Primary Flag | 1 char | Primary Contact |
| Contact2 Emergency Flag | 1 char | Emergency Contact |
| Contact2 Migrant Flag | 1 char | Migrant |
| Contact2 STREET NBR | 6 char | Street Number |
| Contact2 STREET NAME | 19 char | Street Name |
| Contact2 APT NBR | 7 char | Apartment Number |
| Contact2 City | 17 char | City |
| Contact2 STATE | 2 char | State |
| Contact2 ZIP Code | 5 char | ZIP |
| Contact2 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact2 HOME PHONE AC | 3 char | Phone Area Code |
| Contact2 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact2 WORK PHONE AC | 3 char | Phone Area Code |
| Contact2 WORK PHONE NBR | 7 char | Phone Number |
| Contact2 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact2 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact2 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact2 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact2 Occup | 25 char | Occupation |
| Contact2 Email | 64 char | |
| Contact2 Date of Birth | YYYYMMDD | Date of Birth |
| Contact2 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT2 MIL IND | 1 char | Military |
| Contact2 MIL BRANCH | 1 char | Military Branch |
| Contact2 MIL RANK | 5 char | Military Rank |
| Contact2 TRANSPORT IND | 1 char | Transportation |
| Contact2 VEH MAKE | 15 char | Vehicle Make |
| Contact2 VEH MODEL | 15 char | Vehicle Model |
| Contact2 VEH COLOR | 10 char | Vehicle Color |
| Contact2 VEH LIC | 8 char | License Plate Number |
| Contact2 VEH LIC STR | 2 char | License Plate Number |
| Contact2 DRV LIC NBR | 21 char | Drivers License Number |
| Contact2 DRV LIC ST | 2 char | Drivers License State |
| Contact2 SCH YR | 4 char | School Year |
| Contact2 SEQ NBR | Integer | Priority |
| Contact2 LANG CD | 2 char | Language |
| Contact2 CELL PHN | 10 char | Cell Phone Number |
| Contact2 PHN PREF | 1 char | Phone Preference |
| Contact2 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact2 PRTY | Integer | Priority |
| Contact3 LAST NAME | 25 char | Last Name |
| Contact3 FIRST NAME | 17 char | First Name |
| Contact3 MIDDLE NAME | 14 char | Middle Name |
| Contact3 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact3 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact3 Primary Flag | 1 char | Primary Contact |
| Contact3 Emergency Flag | 1 char | Emergency Contact |
| Contact3 Migrant Flag | 1 char | Migrant |
| Contact3 STREET NBR | 6 char | Street Number |
| Contact3 STREET NAME | 19 char | Street Name |
| Contact3 APT NBR | 7 char | Apartment Number |
| Contact3 City | 17 char | CITY |
| Contact3 STATE | 2 char | State |
| Contact3 ZIP Code | 5 char | ZIP |
| Contact3 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact3 HOME PHONE AC | 3 char | Phone Area Code |
| Contact3 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact3 WORK PHONE AC | 3 char | Phone Area Code_BUS |
| Contact3 WORK PHONE NBR | 7 char | Phone Number_BUS |
| Contact3 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact3 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact3 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact3 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact3 Occup | 25 char | Occupation |
| Contact3 Email | 64 char | |
| Contact3 Date of Birth | YYYYMMDD | Date of Birth |
| Contact3 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT3 MIL IND | 1 char | Military |
| Contact3 MIL BRANCH | 1 char | Military Branch |
| Contact3 MIL RANK | 5 char | Military Rank |
| Contact3 TRANSPORT IND | 1 char | Transportation |
| Contact3 VEH MAKE | 15 char | Vehicle Make |
| Contact3 VEH MODEL | 15 char | Vehicle Model |
| Contact3 VEH COLOR | 10 char | Vehicle Color |
| Contact3 VEH LIC | 8 char | License Plate Number |
| Contact3 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact3 DRV LIC NBR | 21 char | Drivers License Number |
| Contact3 DRV LIC ST | 2 char | Drivers License State |
| Contact3 SCH YR | 4 char | School Year |
| Contact3 SEQ NBR | Integer | Priority |
| Contact3 LANG CD | 2 char | Language |
| Contact3 CELL PHN | 10 char | Cell Phone Number |
| Contact3 PHN PREF | 1 char | Phone Preference |
| Contact3 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact3 PRTY | Integer | Priority |
| Contact4 LAST NAME | 25 char | Last Name |
| Contact4 FIRST NAME | 17 char | First Name |
| Contact4 MIDDLE NAME | 14 char | Middle Name |
| Contact4 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact4 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact4 Primary Flag | 1 char | Primary Contact |
| Contact4 Emergency Flag | 1 char | Emergency Contact |
| Contact4 Migrant Flag | 1 char | Migrant |
| Contact4 STREET NBR | 6 char | Street Number |
| Contact4 STREET NAME | 19 char | Street Name |
| Contact4 APT NBR | 7 char | Apartment Number |
| Contact4 City | 17 char | CITY |
| Contact4 STATE | 2 char | State |
| Contact4 ZIP Code | 5 char | ZIP |
| Contact4 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact4 HOME PHONE AC | 3 char | Phone Area Code |
| Contact4 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact4 WORK PHONE AC | 3 char | Phone Area Code_BUS |
| Contact4 WORK PHONE NBR | 7 char | Phone Number_BUS |
| Contact4 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact4 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact4 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact4 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact4 Occup | 25 char | Occupation |
| Contact4 Email | 64 char | |
| Contact4 Date of Birth | YYYYMMDD | Date of Birth |
| Contact4 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT4 MIL IND | 1 char | Military |
| Contact4 MIL BRANCH | 1 char | Military Branch |
| Contact4 MIL RANK | 5 char | Military Rank |
| Contact4 TRANSPORT IND | 1 char | Transportation |
| Contact4 VEH MAKE | 15 char | Vehicle Make |
| Contact4 VEH MODEL | 15 char | Vehicle Model |
| Contact4 VEH COLOR | 10 char | Vehicle Color |
| Contact4 VEH LIC | 8 char | License Plate Number |
| Contact4 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact4 DRV LIC NBR | 21 char | Drivers License Number |
| Contact4 DRV LIC ST | 2 char | Drivers License State |
| Contact4 SCH YR | 4 char | School Year |
| Contact4 SEQ NBR | Integer | Priority |
| Contact4 LANG CD | 2 char | Language |
| Contact4 CELL PHN | 10 char | Cell Phone Number |
| Contact4 PHN PREF | 1 char | Phone Preference |
| Contact4 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact4 PRTY | Integer | Priority |
| Contact5 LAST NAME | 25 char | Last Name |
| Contact5 FIRST NAME | 17 char | First Name |
| Contact5 MIDDLE NAME | 14 char | Middle Name |
| Contact5 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact5 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact5 Primary Flag | 1 char | Primary Contact |
| Contact5 Emergency Flag | 1 char | Emergency Contact |
| Contact5 Migrant Flag | 1 char | Migrant |
| Contact5 STREET NBR | 6 char | Street Number |
| Contact5 STREET NAME | 19 char | Street Name |
| Contact5 APT NBR | 7 char | Apartment Number |
| Contact5 City | 17 char | City |
| Contact5 STATE | 2 char | State |
| Contact5 ZIP Code | 5 char | ZIP |
| Contact5 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact5 HOME PHONE AC | 3 char | Phone Area Code |
| Contact5 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact5 WORK PHONE AC | 3 char | Phone Area Code_BUS |
| Contact5 WORK PHONE NBR | 7 char | Phone Number_BUS |
| Contact5 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact5 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact5 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact5 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact5 Occup | 25 char | Occupation |
| Contact5 Email | 64 char | |
| Contact5 Date of Birth | YYYYMMDD | Date of Birth |
| Contact5 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT5 MIL IND | 1 char | Military |
| Contact5 MIL BRANCH | 1 char | Military Branch |
| Contact5 MIL RANK | 5 char | Military Rank |
| Contact5 TRANSPORT IND | 1 char | Transportation |
| Contact5 VEH MAKE | 15 char | Vehicle Make |
| Contact5 VEH MODEL | 15 char | Vehicle Model |
| Contact5 VEH COLOR | 10 char | Vehicle Color |
| Contact5 VEH LIC | 8 char | License Plate Number |
| Contact5 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact5 DRV LIC NBR | 21 char | Drivers License Number |
| Contact5 DRV LIC ST | 2 char | Drivers License State |
| Contact5 SCH YR | 4 char | School Year |
| Contact5 SEQ NBR | Integer | Priority |
| Contact5 LANG CD | 2 char | Language |
| Contact5 CELL PHN | 10 char | Cell Phone Number |
| Contact5 PHN PREF | 1 char | Phone Preference |
| Contact5 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact5 PRTY | Integer | Priority |
| Contact6 LAST NAME | 25 char | Last Name |
| Contact6 FIRST NAME | 17 char | First Name |
| Contact6 MIDDLE NAME | 14 char | Middle Name |
| Contact6 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact6 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact6 Primary Flag | 1 char | Primary Contact |
| Contact6 Emergency Flag | 1 char | Emergency Contact |
| Contact6 Migrant Flag | 1 char | Migrant |
| Contact6 STREET NBR | 6 char | Street Number |
| Contact6 STREET NAME | 19 char | Street Name |
| Contact6 APT NBR | 7 char | Apartment Number |
| Contact6 City | 17 char | City |
| Contact6 STATE | 2 char | State |
| Contact6 ZIP Code | 5 char | ZIP |
| Contact6 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact6 HOME PHONE AC | 3 char | Phone Area Code |
| Contact6 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact6 WORK PHONE AC | 3 char | Phone Area Code_BUS |
| Contact6 WORK PHONE NBR | 7 char | Phone Number_BUS |
| Contact6 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact6 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact6 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact6 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact6 Occup | 25 char | Occupation |
| Contact6 Email | 64 char | |
| Contact6 Date of Birth | YYYYMMDD | Date of Birth |
| Contact6 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT6 MIL IND | 1 char | Military |
| Contact6 MIL BRANCH | 1 char | Military Branch |
| Contact6 MIL RANK | 5 char | Military Rank |
| Contact6 TRANSPORT IND | 1 char | Transportation |
| Contact6 VEH MAKE | 15 char | Vehicle Make |
| Contact6 VEH MODEL | 15 char | Vehicle Model |
| Contact6 VEH COLOR | 10 char | Vehicle Color |
| Contact6 VEH LIC | 8 char | License Plate Number |
| Contact6 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact6 DRV LIC NBR | 21 char | Drivers License Number |
| Contact6 DRV LIC ST | 2 char | Drivers License State |
| Contact6 SCH YR | 4 char | School Year |
| Contact6 SEQ NBR | Integer | Priority |
| Contact6 LANG CD | 2 char | Language |
| Contact6 CELL PHN | 10 char | Cell Phone Number |
| Contact6 PHN PREF | 1 char | Phone Preference |
| Contact6 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact6 PRTY | Integer | Priority |
| Contact7 LAST NAME | 25 char | Last Name |
| Contact7 FIRST NAME | 17 char | First Name |
| Contact7 MIDDLE NAME | 14 char | Middle Name |
| Contact7 GenerationERATION CODE | Valid values from ET_C012_GEN table 1 char | Generation |
| Contact7 RelationshipIONSHIP 1 | 2 char | Relationship |
| Contact7 Primary Flag | 1 char | Primary Contact |
| Contact7 Emergency Flag | 1 char | Emergency Contact |
| Contact7 Migrant Flag | 1 char | Migrant |
| Contact7 STREET NBR | 6 char | Street Number |
| Contact7 STREET NAME | 19 char | Street Name |
| Contact7 APT NBR | 7 char | Apartment Number |
| Contact7 City | 17 char | City |
| Contact7 STATE | 2 char | State |
| Contact7 ZIP Code | 5 char | ZIP |
| Contact7 ZIP Code+4 | 4 char | ZIP Plus Four |
| Contact7 HOME PHONE AC | 3 char | Phone Area Code |
| Contact7 HOME PHONE NBR | 7 char (no hyphens) | Phone Number |
| Contact7 WORK PHONE AC | 3 char | Phone Area Code_BUS |
| Contact7 WORK PHONE NBR | 7 char | Phone Number_BUS |
| Contact7 WORK PHONE EXT | 4 char | Business Phone Extension |
| Contact7 CELL AREA CODE | 3 char | Cell Phone Area Code |
| Contact7 CELL PHONE NBR | 7 char (no hyphens) | Cell Phone Number |
| Contact7 CELL PHONE EXT | 4 char | Cell Phone Extension |
| Contact7 Occup | 25 char | Occupation |
| Contact7 Email | 64 char | |
| Contact7 Date of Birth | YYYYMMDD | Date of Birth |
| Contact7 Social Security Number | 9 char (no hyphens) | Social Security Number |
| CONT7 MIL IND | 1 char | Military |
| Contact7 MIL BRANCH | 1 char | Military Branch |
| Contact7 MIL RANK | 5 char | Military Rank |
| Contact7 TRANSPORT IND | 1 char | Transportation |
| Contact7 VEH MAKE | 15 char | Vehicle Make |
| Contact7 VEH MODEL | 15 char | Vehicle Model |
| Contact7 VEH COLOR | 10 char | Vehicle Color |
| Contact7 VEH LIC | 8 char | License Plate Number |
| Contact7 VEH LIC STR | 2 char | License Plate Number_ST |
| Contact7 DRV LIC NBR | 21 char | Drivers License Number |
| Contact7 DRV LIC ST | 2 char | Drivers License State |
| Contact7 SCH YR | 4 char | School Year |
| Contact7 SEQ NBR | Integer | Priority |
| Contact7 LANG CD | 2 char | Language |
| Contact7 CELL PHN | 10 char | Cell Phone Number |
| Contact7 PHN PREF | 1 char | Phone Preference |
| Contact7 RCV MAILOUTS | 1 char | Receives Mailouts |
| Contact7 PRTY | Integer | Priority |
student/registration_export.1602289138.txt.gz · Last modified: 2020/10/09 19:18 (external edit)