Interfaces

User Tools

Site Tools

Trace: • Payroll Transmittal File Layout • Import Cash Receipt Transactions File Layout • External Gradebook Absences Import • Registration Import Guidelines
student:registration_import
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book (0 page(s))
 Help

This is an old revision of the document!

Registration Import

Student ID6 char for existing students; longer for newStudent ID
School Year4 charSchool Year
Campus3 charCampus ID
date entryYYYYMMDD (8 Char)Entry Date
Social Security Number999999999 (9 Char)State Student ID
Last Name25 charLast Name
First Name17 charFirst Name
Middle Name14 charMiddle Name
Gen CodeValid values from ET_C012_ Generationtable (1 char)Generation
Street Nbr6 charStreet Number
Street Direction2 charStreet Direction
Street Name19 charStreet Name
Apt Number7 charApartment Number
City17 charCity
State2 charState
ZIP Code5 charZIP Code
ZIP Code+44 charZIP Code4
Date of BirthYYYYMMDD (8 Char)Date of Birth
Sex1 char (M or F)Sex
Physical Street Nbr6 charStreet Number
Physical Street Direction2 charStreet Direction
Physical Street Name19 charStreet Name
Physical Apt Nbr7 charApartment Number
Physical City17 charCity
Physical ZIP Code5 charZIP Code
Physical ZIP Code+44 charZIP Plus Four
Student Home AC3 charStudent Phone Area Code
Student Home Phone Nbr7 char (no hyphen)Phone Number
Ethnicity HispanicY or NHispanic
Race BlackY or NAfrican American
Race WhiteY or NWhite
Race Pacific IslanderY or NPacific Islander
Race Am. Ind/AlaskanY or NNative American/Alaskan
Race AsianY or NAsian
Student Previous District Name13 charPrevious District
Student Previous Campus Name34 charPrevious District
Student Birth StateThis is a place holder .We are sending spaces now and the data received from ZippSlip is not uploaded to any tables.
Student Birth CityThis is a place holder .We are sending spaces now and the data received from ZippSlip is not uploaded to any tables.
Contact1 LAST NAME25 charLast Name
Contact1 FIRST NAME17 charFirst Name
Contact1 MIDDLE NAME14 charMiddle Name
Contact1 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact1 RelationshipIONSHIP 12 charRelationship
Contact1 Primary Flag1 charPrimary Contact
Contact1 Emergency Flag1 charEmergency Contact
Contact1 Migrant Flag1 char Migrant
Contact1 STREET NBR6 charStreet Number
Contact1 STREET NAME19 charStreet Name
Contact1 APT NBR7 charApartment Number
Contact1 City17 charCity
Contact1 STATE2 charState
Contact1 ZIP Code5 charZIP
Contact1 ZIP Code+44 charZIP Plus Four
Contact1 HOME PHONE AC3 charPhone Area Code
Contact1 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact1 WORK PHONE AC3 charPhone Area Code
Contact1 WORK PHONE NBR7 charPhone Number
Contact1 WORK PHONE EXT4 charBusiness Phone Extension
Contact1 CELL AREA CODE3 charCell Phone Area Code
Contact1 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact1 CELL PHONE EXT4 char Cell Phone Extension
Contact1 Occup25 char Occupation
Contact1 Email64 charEmail
Contact1 Date of BirthYYYYMMDDDate of Birth
Contact1 Social Security Number9 char (no hyphens)Social Security Number
CONT1 MIL IND1 charMilitary
Contact1 MIL BRANCH1 charMilitary Branch
Contact1 MIL RANK5 char Military Rank
Contact1 TRANSPORT IND1 charTransportation
Contact1 VEH MAKE15 charVehicle Make
Contact1 VEH MODEL15 charVehicle Model
Contact1 VEH COLOR10 charVehicle Color
Contact1 VEH LIC8 charLicense Plate Number
Contact1 VEH LIC STR2 char License Plate State
Contact1 DRV LIC NBR21 charDrivers License Number
Contact1 DRV LIC ST2 charDrivers License State
Contact1 SCH YR4 charSchool Year
Contact1 SEQ NBRIntegerPriority
Contact1 LANG CD2 char Language
Contact1 CELL PHN10 char Cell Phone Number
Contact1 PHN PREF1 char Phone Preference
Contact1 RCV MAILOUTS1 charReceives Mailouts
Contact2 LAST NAME25 charLast Name
Contact2 FIRST NAME17 charFirst Name
Contact2 MIDDLE NAME14 charMiddle Name
Contact2 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact2 RelationshipIONSHIP 12 charRelationship
Contact2 Primary Flag1 charPrimary Contact
Contact2 Emergency Flag1 charEmergency Contact
Contact2 Migrant Flag1 char Migrant
Contact2 STREET NBR6 charStreet Number
Contact2 STREET NAME19 charStreet Name
Contact2 APT NBR7 charApartment Number
Contact2 City17 charCity
Contact2 STATE2 charState
Contact2 ZIP Code5 charZIP
Contact2 ZIP Code+44 charZIP Plus Four
Contact2 HOME PHONE AC3 charPhone Area Code
Contact2 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact2 WORK PHONE AC3 charPhone Area Code
Contact2 WORK PHONE NBR7 charPhone Number
Contact2 WORK PHONE EXT4 charBusiness Phone Extension
Contact2 CELL AREA CODE3 charCell Phone Area Code
Contact2 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact2 CELL PHONE EXT4 char Cell Phone Extension
Contact2 Occup25 char Occupation
Contact2 Email64 charEmail
Contact2 Date of BirthYYYYMMDDDate of Birth
Contact2 Social Security Number9 char (no hyphens)Social Security Number
CONT2 MIL IND1 charMilitary
Contact2 MIL BRANCH1 charMilitary Branch
Contact2 MIL RANK5 char Military Rank
Contact2 TRANSPORT IND1 charTransportation
Contact2 VEH MAKE15 charVehicle Make
Contact2 VEH MODEL15 charVehicle Model
Contact2 VEH COLOR10 charVehicle Color
Contact2 VEH LIC8 charLicense Plate Number
Contact2 VEH LIC STR2 char License Plate State
Contact2 DRV LIC NBR21 charDrivers License Number
Contact2 DRV LIC ST2 charDrivers License State
Contact2 SCH YR4 charSchool Year
Contact2 SEQ NBRIntegerPriority
Contact2 LANG CD2 char Language
Contact2 CELL PHN10 char Cell Phone Number
Contact2 PHN PREF1 char Phone Preference
Contact2 RCV MAILOUTS1 charReceives Mailouts
Contact3 LAST NAME25 charLast Name
Contact3 FIRST NAME17 charFirst Name
Contact3 MIDDLE NAME14 charMiddle Name
Contact3 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact3 RelationshipIONSHIP 12 charRelationship
Contact3 Primary Flag1 charPrimary Contact
Contact3 Emergency Flag1 charEmergency Contact
Contact3 Migrant Flag1 char Migrant
Contact3 STREET NBR6 charStreet Number
Contact3 STREET NAME19 charStreet Name
Contact3 APT NBR7 charApartment Number
Contact3 City17 charCity
Contact3 STATE2 charState
Contact3 ZIP Code5 charZIP
Contact3 ZIP Code+44 charZIP Plus Four
Contact3 HOME PHONE AC3 charPhone Area Code
Contact3 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact3 WORK PHONE AC3 charPhone Area Code
Contact3 WORK PHONE NBR7 charPhone Number
Contact3 WORK PHONE EXT4 charBusiness Phone Extension
Contact3 CELL AREA CODE3 charCell Phone Area Code
Contact3 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact3 CELL PHONE EXT4 char Cell Phone Extension
Contact3 Occup25 char Occupation
Contact3 Email64 charEmail
Contact3 Date of BirthYYYYMMDDDate of Birth
Contact3 Social Security Number9 char (no hyphens)Social Security Number
CONT3 MIL IND1 charMilitary
Contact3 MIL BRANCH1 charMilitary Branch
Contact3 MIL RANK5 char Military Rank
Contact3 TRANSPORT IND1 charTransportation
Contact3 VEH MAKE15 charVehicle Make
Contact3 VEH MODEL15 charVehicle Model
Contact3 VEH COLOR10 charVehicle Color
Contact3 VEH LIC8 charLicense Plate Number
Contact3 VEH LIC STR2 char License Plate State
Contact3 DRV LIC NBR21 charDrivers License Number
Contact3 DRV LIC ST2 charDrivers License State
Contact3 SCH YR4 charSchool Year
Contact3 SEQ NBRIntegerPriority
Contact3 LANG CD2 char Language
Contact3 CELL PHN10 char Cell Phone Number
Contact3 PHN PREF1 char Phone Preference
Contact3 RCV MAILOUTS1 charReceives Mailouts
Contact4 LAST NAME25 charLast Name
Contact4 FIRST NAME17 charFirst Name
Contact4 MIDDLE NAME14 charMiddle Name
Contact4 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact4 RelationshipIONSHIP 12 charRelationship
Contact4 Primary Flag1 charPrimary Contact
Contact4 Emergency Flag1 charEmergency Contact
Contact4 Migrant Flag1 char Migrant
Contact4 STREET NBR6 charStreet Number
Contact4 STREET NAME19 charStreet Name
Contact4 APT NBR7 charApartment Number
Contact4 City17 charCity
Contact4 STATE2 charState
Contact4 ZIP Code5 charZIP
Contact4 ZIP Code+44 charZIP Plus Four
Contact4 HOME PHONE AC3 charPhone Area Code
Contact4 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact4 WORK PHONE AC3 charPhone Area Code
Contact4 WORK PHONE NBR7 charPhone Number
Contact4 WORK PHONE EXT4 charBusiness Phone Extension
Contact4 CELL AREA CODE3 charCell Phone Area Code
Contact4 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact4 CELL PHONE EXT4 char Cell Phone Extension
Contact4 Occup25 char Occupation
Contact4 Email64 charEmail
Contact4 Date of BirthYYYYMMDDDate of Birth
Contact4 Social Security Number9 char (no hyphens)Social Security Number
CONT4 MIL IND1 charMilitary
Contact4 MIL BRANCH1 charMilitary Branch
Contact4 MIL RANK5 char Military Rank
Contact4 TRANSPORT IND1 charTransportation
Contact4 VEH MAKE15 charVehicle Make
Contact4 VEH MODEL15 charVehicle Model
Contact4 VEH COLOR10 charVehicle Color
Contact4 VEH LIC8 charLicense Plate Number
Contact4 VEH LIC STR2 char License Plate State
Contact4 DRV LIC NBR21 charDrivers License Number
Contact4 DRV LIC ST2 charDrivers License State
Contact4 SCH YR4 charSchool Year
Contact4 SEQ NBRIntegerPriority
Contact4 LANG CD2 char Language
Contact4 CELL PHN10 char Cell Phone Number
Contact4 PHN PREF1 char Phone Preference
Contact4 RCV MAILOUTS1 charReceives Mailouts
Contact5 LAST NAME25 charLast Name
Contact5 FIRST NAME17 charFirst Name
Contact5 MIDDLE NAME14 charMiddle Name
Contact5 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact5 RelationshipIONSHIP 12 charRelationship
Contact5 Primary Flag1 charPrimary Contact
Contact5 Emergency Flag1 charEmergency Contact
Contact5 Migrant Flag1 char Migrant
Contact5 STREET NBR6 charStreet Number
Contact5 STREET NAME19 charStreet Name
Contact5 APT NBR7 charApartment Number
Contact5 City17 charCity
Contact5 STATE2 charState
Contact5 ZIP Code5 charZIP
Contact5 ZIP Code+44 charZIP Plus Four
Contact5 HOME PHONE AC3 charPhone Area Code
Contact5 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact5 WORK PHONE AC3 charPhone Area Code
Contact5 WORK PHONE NBR7 charPhone Number
Contact5 WORK PHONE EXT4 charBusiness Phone Extension
Contact5 CELL AREA CODE3 charCell Phone Area Code
Contact5 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact5 CELL PHONE EXT4 char Cell Phone Extension
Contact5 Occup25 char Occupation
Contact5 Email64 charEmail
Contact5 Date of BirthYYYYMMDDDate of Birth
Contact5 Social Security Number9 char (no hyphens)Social Security Number
CONT5 MIL IND1 charMilitary
Contact5 MIL BRANCH1 charMilitary Branch
Contact5 MIL RANK5 char Military Rank
Contact5 TRANSPORT IND1 charTransportation
Contact5 VEH MAKE15 charVehicle Make
Contact5 VEH MODEL15 charVehicle Model
Contact5 VEH COLOR10 charVehicle Color
Contact5 VEH LIC8 charLicense Plate Number
Contact5 VEH LIC STR2 char License Plate State
Contact5 DRV LIC NBR21 charDrivers License Number
Contact5 DRV LIC ST2 charDrivers License State
Contact5 SCH YR4 charSchool Year
Contact5 SEQ NBRIntegerPriority
Contact5 LANG CD2 char Language
Contact5 CELL PHN10 char Cell Phone Number
Contact5 PHN PREF1 char Phone Preference
Contact5 RCV MAILOUTS1 charReceives Mailouts
Contact6 LAST NAME25 charLast Name
Contact6 FIRST NAME17 charFirst Name
Contact6 MIDDLE NAME14 charMiddle Name
Contact6 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact6 RelationshipIONSHIP 12 charRelationship
Contact6 Primary Flag1 charPrimary Contact
Contact6 Emergency Flag1 charEmergency Contact
Contact6 Migrant Flag1 char Migrant
Contact6 STREET NBR6 charStreet Number
Contact6 STREET NAME19 charStreet Name
Contact6 APT NBR7 charApartment Number
Contact6 City17 charCity
Contact6 STATE2 charState
Contact6 ZIP Code5 charZIP
Contact6 ZIP Code+44 charZIP Plus Four
Contact6 HOME PHONE AC3 charPhone Area Code
Contact6 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact6 WORK PHONE AC3 charPhone Area Code
Contact6 WORK PHONE NBR7 charPhone Number
Contact6 WORK PHONE EXT4 charBusiness Phone Extension
Contact6 CELL AREA CODE3 charCell Phone Area Code
Contact6 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact6 CELL PHONE EXT4 char Cell Phone Extension
Contact6 Occup25 char Occupation
Contact6 Email64 charEmail
Contact6 Date of BirthYYYYMMDDDate of Birth
Contact6 Social Security Number9 char (no hyphens)Social Security Number
CONT6 MIL IND1 charMilitary
Contact6 MIL BRANCH1 charMilitary Branch
Contact6 MIL RANK5 char Military Rank
Contact6 TRANSPORT IND1 charTransportation
Contact6 VEH MAKE15 charVehicle Make
Contact6 VEH MODEL15 charVehicle Model
Contact6 VEH COLOR10 charVehicle Color
Contact6 VEH LIC8 charLicense Plate Number
Contact6 VEH LIC STR2 char License Plate State
Contact6 DRV LIC NBR21 charDrivers License Number
Contact6 DRV LIC ST2 charDrivers License State
Contact6 SCH YR4 charSchool Year
Contact6 SEQ NBRIntegerPriority
Contact6 LANG CD2 char Language
Contact6 CELL PHN10 char Cell Phone Number
Contact6 PHN PREF1 char Phone Preference
Contact6 RCV MAILOUTS1 charReceives Mailouts
Contact7 LAST NAME25 charLast Name
Contact7 FIRST NAME17 charFirst Name
Contact7 MIDDLE NAME14 charMiddle Name
Contact7 GenerationERATION CODEValid values from ET_C012_ Generationtable 1 charGeneration
Contact7 RelationshipIONSHIP 12 charRelationship
Contact7 Primary Flag1 charPrimary Contact
Contact7 Emergency Flag1 charEmergency Contact
Contact7 Migrant Flag1 char Migrant
Contact7 STREET NBR6 charStreet Number
Contact7 STREET NAME19 charStreet Name
Contact7 APT NBR7 charApartment Number
Contact7 City17 charCity
Contact7 STATE2 charState
Contact7 ZIP Code5 charZIP
Contact7 ZIP Code+44 charZIP Plus Four
Contact7 HOME PHONE AC3 charPhone Area Code
Contact7 HOME PHONE NBR7 char (no hyphens)Phone Number
Contact7 WORK PHONE AC3 charPhone Area Code
Contact7 WORK PHONE NBR7 charPhone Number
Contact7 WORK PHONE EXT4 charBusiness Phone Extension
Contact7 CELL AREA CODE3 charCell Phone Area Code
Contact7 CELL PHONE NBR7 char (no hyphens)Cell Phone Number
Contact7 CELL PHONE EXT4 char Cell Phone Extension
Contact7 Occup25 char Occupation
Contact7 Email64 charEmail
Contact7 Date of BirthYYYYMMDDDate of Birth
Contact7 Social Security Number9 char (no hyphens)Social Security Number
CONT7 MIL IND1 charMilitary
Contact7 MIL BRANCH1 charMilitary Branch
Contact7 MIL RANK5 char Military Rank
Contact7 TRANSPORT IND1 charTransportation
Contact7 VEH MAKE15 charVehicle Make
Contact7 VEH MODEL15 charVehicle Model
Contact7 VEH COLOR10 charVehicle Color
Contact7 VEH LIC8 charLicense Plate Number
Contact7 VEH LIC STR2 char License Plate State
Contact7 DRV LIC NBR21 charDrivers License Number
Contact7 DRV LIC ST2 charDrivers License State
Contact7 SCH YR4 charSchool Year
Contact7 SEQ NBRIntegerPriority
Contact7 LANG CD2 char Language
Contact7 CELL PHN10 char Cell Phone Number
Contact7 PHN PREF1 char Phone Preference
Contact7 RCV MAILOUTS1 charReceives Mailouts
student/registration_import.1602289049.txt.gz · Last modified: 2020/10/09 19:17 (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.