User Tools

Site Tools


student:registration_export

Registration Export

Used with external registration systems.

Notes:

  • The file is a .csv. ASCENDER has no requirement for naming this file.
Student Id6 CharStudent ID (6 characters for existing students; longer for new student).
Third Party Stu IdUp to 24 CharStudent Key (this is the Student ID sent from the third-party vendor in the import file).
School Year4 CharSchool Year.
Campus3 CharCampus ID.
Date Entry8 CharStudent Entry Date (YYYYMMDD).
Social Security Number9 CharState Student ID. Accepts the “S” State Student ID numbers.
Last Name25 CharStudent Last Name.
First Name17 CharStudent First Name.
Grade Level2 CharStudent Grade Level.
Middle Name14 CharStudent Middle Name.
Gen Code1 CharStudent Generation (valid values from ET_C012_Generation table).
Street Nbr6 CharStudent Street Number.
Street Direction2 CharStudent Street Direction.
Street Name19 CharStudent Street Name.
Apt Number7 CharStudent Apartment Number.
City17 CharStudent City.
State2 CharStudent State.
ZIP Code5 CharStudent ZIP Code.
ZIP Code+44 CharStudent ZIP Code plus 4.
Date of Birth8 CharStudent Date of Birth (YYYYMMDD ).
Sex1 CharStudent Sex (M or F).
Physical Street Nbr6 CharStudent Street Number.
Physical Street Direction2 CharStudent Street Direction.
Physical Street Name19 CharStudent Street Name.
Physical Apt Nbr7 CharStudent Apartment Number.
Physical City17 CharStudent City.
Physical ZIP Code5 CharStudent ZIP Code.
Physical ZIP Code+44 CharStudent ZIP Code Plus Four.
Student Home AC3 CharStudent Student Area Code.
Student Home Phone Nbr7 CharStudent Phone Number (no hypen).
Ethnicity Hispanic1 CharHispanic (Y or N).
Race Black1 CharAfrican American (Y or N).
Race White1 CharWhite (Y or N).
Race Pacific Islander1 CharPacific Islander (Y or N).
Race Am. Ind/Alaskan1 CharAmerican Indian/Alaskan (Y or N).
Race Asian1 CharAsian (Y or N).
Student Previous District Name13 CharStudent's Previous District Name, if any.
Student Previous Campus Name34 CharStudent's Previous District Name, if any.
Student Birth State
Student Birth City
Contact1 Last Name25 CharLast Name.
Contact1 First Name17 CharFirst Name.
Contact1 Middle Name14 CharMiddle Name.
Contact1 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact1 Relationship 12 CharRelationship.
Contact1 Primary Flag1 CharPrimary Contact.
Contact1 Emergency Flag1 CharEmergency Contact.
Contact1 Migrant Flag1 CharMigrant.
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 Code.
Contact1 ZIP Code+44 CharZIP Code Plus Four.
Contact1 Home Phone AC3 CharPhone Area Code.
Contact1 Home Phone Nbr7 CharPhone Number (no hyphens).
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 CharCell Phone Number (no hyphens).
Contact1 Cell Phone Ext4 CharCell Phone Extension.
Contact1 Occup25 CharOccupation.
Contact1 Email64 CharEmail.
Contact1 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact1 Social Security Number9 CharSocial Security Number (no hyphens).
Contact1 Military Indicator1 CharMilitary.
Contact1 Military Branch1 CharMilitary Branch.
Contact1 Military Rank5 CharMilitary Rank.
Contact1 Transport Indicator1 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 CharLicense Plate Number Street.
Contact1 Drv Lic Nbr21 CharDrivers License Number.
Contact1 Drv Lic St2 CharDrivers License State.
Contact1 Sch Yr4 CharSchool Year.
Contact1 Seq NbrIntegerContact Priority.
Contact1 Lang Cd2 CharLanguage.
Contact1 Cell Phn10 CharCell Phone Number.
Contact1 Phn Pref1 CharPhone Preference.
Contact1 Rcv Mailouts1 CharReceives Mailouts.
Contact1 PrtyIntegerPriority.
Contact2 Last Name25 CharLast Name.
Contact2 First Name17 CharFirst Name.
Contact2 Middle Name14 CharMiddle Name.
Contact2 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact2 Relationship 12 CharRelationship.
Contact2 Primary Flag1 CharPrimary Contact.
Contact2 Emergency Flag1 CharEmergency Contact.
Contact2 Migrant Flag1 CharMigrant.
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 Code.
Contact2 ZIP Code+44 CharZIP Code Plus Four.
Contact2 Home Phone AC3 CharPhone Area Code.
Contact2 Home Phone Nbr7 CharPhone Number (no hyphens).
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 CharCell Phone Number (no hyphens).
Contact2 Cell Phone Ext4 CharCell Phone Extension.
Contact2 Occup25 CharOccupation.
Contact2 Email64 CharEmail.
Contact2 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact2 Social Security Number9 CharContact 2 Social Security Number (no hyphens).
Contact2 Mil Ind1 CharMilitary.
Contact2 Mil Branch1 CharMilitary Branch.
Contact2 Mil Rank5 CharMilitary 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 CharLicense Plate Number.
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 CharLanguage.
Contact2 Cell Phn10 CharCell Phone Number.
Contact2 Phn Pref1 CharPhone Preference.
Contact2 Rcv Mailouts1 CharReceives Mailouts.
Contact2 PrtyIntegerPriority.
Contact3 Last Name25 CharLast Name.
Contact3 First Name17 CharFirst Name.
Contact3 Middle Name14 CharMiddle Name.
Contact3 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact3 Relationship 12 CharRelationship.
Contact3 Primary Flag1 CharPrimary Contact.
Contact3 Emergency Flag1 CharEmergency Contact.
Contact3 Migrant Flag1 CharMigrant.
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 Code.
Contact3 ZIP Code+44 CharZIP Code Plus Four.
Contact3 Home Phone AC3 CharPhone Area Code.
Contact3 Home Phone Nbr7 CharPhone Number (no hyphens).
Contact3 Work Phone AC3 CharPhone Area Code_BUS.
Contact3 Work Phone Nbr7 CharPhone Number_BUS.
Contact3 Work Phone Ext4 CharBusiness Phone Extension.
Contact3 Cell Area Code3 CharCell Phone Area Code.
Contact3 Cell Phone Nbr7 CharCell Phone Number (no hyphens).
Contact3 Cell Phone Ext4 CharCell Phone Extension.
Contact3 Occup25 CharOccupation.
Contact3 Email64 CharEmail.
Contact3 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact3 Social Security Number9 CharSocial Security Number (no hyphens).
Contact3 Mil Ind1 CharMilitary.
Contact3 Mil Branch1 CharMilitary Branch.
Contact3 Mil Rank5 CharMilitary 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 CharLicense Plate Number_ST.
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 CharLanguage.
Contact3 Cell Phn10 CharCell Phone Number.
Contact3 Phn Pref1 CharPhone Preference.
Contact3 Rcv Mailouts1 CharReceives Mailouts.
Contact3 PrtyIntegerPriority.
Contact4 Last Name25 CharLast Name.
Contact4 First Name17 CharFirst Name.
Contact4 Middle Name14 CharMiddle Name.
Contact4 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact4 Relationship 12 CharRelationship.
Contact4 Primary Flag1 CharPrimary Contact.
Contact4 Emergency Flag1 CharEmergency Contact.
Contact4 Migrant Flag1 CharMigrant.
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 Code.
Contact4 ZIP Code+44 CharZIP Code Plus Four.
Contact4 Home Phone AC3 CharPhone Area Code.
Contact4 Home Phone Nbr7 CharPhone Number (no hyphens).
Contact4 Work Phone AC3 CharBusiness Phone Area Code.
Contact4 Work Phone Nbr7 CharBusiness Phone Number.
Contact4 Work Phone Ext4 CharBusiness Phone Extension.
Contact4 Cell Area Code3 CharCell Phone Area Code.
Contact4 Cell Phone Nbr7 CharCell Phone Number (no hyphens).
Contact4 Cell Phone Ext4 CharCell Phone Extension.
Contact4 Occup25 CharOccupation.
Contact4 Email64 CharEmail.
Contact4 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact4 Social Security Number9 CharSocial Security Number (no hyphens).
Contact4 Mil Ind1 CharMilitary.
Contact4 Mil Branch1 CharMilitary Branch.
Contact4 Mil Rank5 CharMilitary 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 CharLicense Plate Number_ST.
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 CharLanguage.
Contact4 Cell Phn10 CharCell Phone Number.
Contact4 Phn Pref1 CharPhone Preference.
Contact4 Rcv Mailouts1 CharReceives Mailouts.
Contact4 PrtyIntegerPriority.
Contact5 Last Name25 CharLast Name.
Contact5 First Name17 CharFirst Name.
Contact5 Middle Name14 CharMiddle Name.
Contact5 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact5 Relationship 12 CharRelationship.
Contact5 Primary Flag1 CharPrimary Contact.
Contact5 Emergency Flag1 CharEmergency Contact.
Contact5 Migrant Flag1 CharMigrant.
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 Code.
Contact5 ZIP Code+44 CharZIP Code Plus Four.
Contact5 Home Phone AC3 CharPhone Area Code.
Contact5 Home Phone Nbr7 CharPhone Number (no hyphens).
Contact5 Work Phone AC3 CharPhone Area Code_BUS.
Contact5 Work Phone Nbr7 CharPhone Number_BUS.
Contact5 Work Phone Ext4 CharBusiness Phone Extension.
Contact5 Cell Area Code3 CharCell Phone Area Code.
Contact5 Cell Phone Nbr7 CharCell Phone Number (no hyphens).
Contact5 Cell Phone Ext4 CharCell Phone Extension.
Contact5 Occup25 CharOccupation.
Contact5 Email64 CharEmail.
Contact5 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact5 Social Security Number9 CharSocial Security Number (no hyphens).
Contact5 Mil Ind1 CharMilitary.
Contact5 Mil Branch1 CharMilitary Branch.
Contact5 Mil Rank5 CharMilitary 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 CharLicense Plate Number_ST.
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 CharLanguage.
Contact5 Cell Phn10 CharCell Phone Number.
Contact5 Phn Pref1 CharPhone Preference.
Contact5 Rcv Mailouts1 CharReceives Mailouts.
Contact5 PrtyIntegerPriority.
Contact6 Last Name25 CharLast Name.
Contact6 FirsT Name17 CharFirst Name.
Contact6 Middle Name14 CharMiddle Name.
Contact6 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact6 Relationship 12 CharRelationship.
Contact6 Primary Flag1 CharPrimary Contact.
Contact6 Emergency Flag1 CharEmergency Contact.
Contact6 Migrant Flag1 CharMigrant.
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 Code.
Contact6 ZIP Code+44 CharZIP Code Plus Four.
Contact6 Home Phone AC3 CharPhone Area Code.
Contact6 Home Phone Nbr7 CharPhone Number (no hyphens).
Contact6 Work Phone AC3 CharPhone Area Code_BUS.
Contact6 Work Phone Nbr7 CharPhone Number_BUS.
Contact6 Work Phone Ext4 CharBusiness Phone Extension.
Contact6 Cell Area Code3 CharCell Phone Area Code.
Contact6 Cell Phone Nbr7 CharCell Phone Number (no hyphens).
Contact6 Cell Phone Ext4 CharCell Phone Extension.
Contact6 Occup25 CharOccupation.
Contact6 Email64 CharEmail.
Contact6 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact6 Social Security Number9 CharSocial Security Number (no hyphens).
Contact6 Mil Ind1 CharMilitary.
Contact6 Mil Branch1 CharMilitary Branch.
Contact6 Mil Rank5 CharMilitary 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 CharLicense Plate Number_ST.
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 CharLanguage.
Contact6 Cell Phn10 CharCell Phone Number.
Contact6 Phn Pref1 CharPhone Preference.
Contact6 Rcv Mailouts1 CharReceives Mailouts.
Contact6 PrtyIntegerPriority.
Contact7 Last Name25 CharLast Name.
Contact7 First Name17 CharFirst Name.
Contact7 Middle Name14 CharMiddle Name.
Contact7 Generation Code1 CharGeneration (valid values from ET_C012_GEN table).
Contact7 Relationship 12 CharRelationship.
Contact7 Primary Flag1 CharPrimary Contact.
Contact7 Emergency Flag1 CharEmergency Contact.
Contact7 Migrant Flag1 CharMigrant.
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 Code.
Contact7 ZIP Code+44 CharZIP Code Plus Four.
Contact7 Home Phone AC3 CharPhone Area Code.
Contact7 Home Phone Nbr7 CharPhone Number (no hyphens).
Contact7 Work Phone AC3 CharPhone Area Code_BUS.
Contact7 Work Phone Nbr7 CharPhone Number_BUS.
Contact7 Work Phone Ext4 CharBusiness Phone Extension.
Contact7 Cell Area Code3 CharCell Phone Area Code.
Contact7 Cell Phone Nbr7 CharCell Phone Number (no hyphens).
Contact7 Cell Phone Ext4 CharCell Phone Extension.
Contact7 Occup25 CharOccupation.
Contact7 Email64 CharEmail.
Contact7 Date of Birth8 CharDate of Birth (YYYYMMDD).
Contact7 Social Security Number9 CharSocial Security Number (no hyphens).
Contact7 Mli Ind1 CharMilitary.
Contact7 Mil Branch1 CharMilitary Branch.
Contact7 Mil Rank5 CharMilitary 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 CharLicense Plate Number_ST.
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 CharLanguage.
Contact7 Cell Phn10 CharCell Phone Number.
Contact7 Phn Pref1 CharPhone Preference.
Contact7 Rcv Mailouts1 CharReceives Mailouts.
Contact7 PrtyIntegerPriority.
student/registration_export.txt · Last modified: 2021/08/06 18:03 by lrosdahl