Used with external registration systems.
Notes:
Student Id | 6 Char | Student ID (6 characters for existing students; longer for new student). |
Third Party Stu Id | Up to 24 Char | Student Key (this is the Student ID sent from the third-party vendor in the import file). |
School Year | 4 Char | School Year. |
Campus | 3 Char | Campus ID. |
Date Entry | 8 Char | Student Entry Date (YYYYMMDD). |
Social Security Number | 9 Char | State Student ID. Accepts the “S” State Student ID numbers. |
Last Name | 25 Char | Student Last Name. |
First Name | 17 Char | Student First Name. |
Grade Level | 2 Char | Student Grade Level. |
Middle Name | 14 Char | Student Middle Name. |
Gen Code | 1 Char | Student Generation (valid values from ET_C012_Generation table). |
Street Nbr | 6 Char | Student Street Number. |
Street Direction | 2 Char | Student Street Direction. |
Street Name | 19 Char | Student Street Name. |
Apt Number | 7 Char | Student Apartment Number. |
City | 17 Char | Student City. |
State | 2 Char | Student State. |
ZIP Code | 5 Char | Student ZIP Code. |
ZIP Code+4 | 4 Char | Student ZIP Code plus 4. |
Date of Birth | 8 Char | Student Date of Birth (YYYYMMDD ). |
Sex | 1 Char | Student Sex (M or F). |
Physical Street Nbr | 6 Char | Student Street Number. |
Physical Street Direction | 2 Char | Student Street Direction. |
Physical Street Name | 19 Char | Student Street Name. |
Physical Apt Nbr | 7 Char | Student Apartment Number. |
Physical City | 17 Char | Student City. |
Physical ZIP Code | 5 Char | Student ZIP Code. |
Physical ZIP Code+4 | 4 Char | Student ZIP Code Plus Four. |
Student Home AC | 3 Char | Student Student Area Code. |
Student Home Phone Nbr | 7 Char | Student Phone Number (no hypen). |
Ethnicity Hispanic | 1 Char | Hispanic (Y or N). |
Race Black | 1 Char | African American (Y or N). |
Race White | 1 Char | White (Y or N). |
Race Pacific Islander | 1 Char | Pacific Islander (Y or N). |
Race Am. Ind/Alaskan | 1 Char | American Indian/Alaskan (Y or N). |
Race Asian | 1 Char | Asian (Y or N). |
Student Previous District Name | 13 Char | Student's Previous District Name, if any. |
Student Previous Campus Name | 34 Char | Student's Previous District Name, if any. |
Student Birth State | ||
Student Birth City | ||
Contact1 Last Name | 25 Char | Last Name. |
Contact1 First Name | 17 Char | First Name. |
Contact1 Middle Name | 14 Char | Middle Name. |
Contact1 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact1 Relationship 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 Code. |
Contact1 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact1 Home Phone AC | 3 Char | Phone Area Code. |
Contact1 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact1 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact1 Occup | 25 Char | Occupation. |
Contact1 Email | 64 Char | Email. |
Contact1 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact1 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact1 Military Indicator | 1 Char | Military. |
Contact1 Military Branch | 1 Char | Military Branch. |
Contact1 Military Rank | 5 Char | Military Rank. |
Contact1 Transport Indicator | 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 Street. |
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 | Contact 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact2 Relationship 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 Code. |
Contact2 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact2 Home Phone AC | 3 Char | Phone Area Code. |
Contact2 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact2 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact2 Occup | 25 Char | Occupation. |
Contact2 Email | 64 Char | Email. |
Contact2 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact2 Social Security Number | 9 Char | Contact 2 Social Security Number (no hyphens). |
Contact2 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact3 Relationship 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 Code. |
Contact3 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact3 Home Phone AC | 3 Char | Phone Area Code. |
Contact3 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact3 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact3 Occup | 25 Char | Occupation. |
Contact3 Email | 64 Char | Email. |
Contact3 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact3 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact3 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact4 Relationship 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 Code. |
Contact4 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact4 Home Phone AC | 3 Char | Phone Area Code. |
Contact4 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
Contact4 Work Phone AC | 3 Char | Business Phone Area Code. |
Contact4 Work Phone Nbr | 7 Char | Business Phone Number. |
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 | Cell Phone Number (no hyphens). |
Contact4 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact4 Occup | 25 Char | Occupation. |
Contact4 Email | 64 Char | Email. |
Contact4 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact4 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact4 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact5 Relationship 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 Code. |
Contact5 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact5 Home Phone AC | 3 Char | Phone Area Code. |
Contact5 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact5 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact5 Occup | 25 Char | Occupation. |
Contact5 Email | 64 Char | Email. |
Contact5 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact5 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact5 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact6 Relationship 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 Code. |
Contact6 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact6 Home Phone AC | 3 Char | Phone Area Code. |
Contact6 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact6 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact6 Occup | 25 Char | Occupation. |
Contact6 Email | 64 Char | Email. |
Contact6 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact6 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact6 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 Generation Code | 1 Char | Generation (valid values from ET_C012_GEN table). |
Contact7 Relationship 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 Code. |
Contact7 ZIP Code+4 | 4 Char | ZIP Code Plus Four. |
Contact7 Home Phone AC | 3 Char | Phone Area Code. |
Contact7 Home Phone Nbr | 7 Char | Phone Number (no hyphens). |
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 | Cell Phone Number (no hyphens). |
Contact7 Cell Phone Ext | 4 Char | Cell Phone Extension. |
Contact7 Occup | 25 Char | Occupation. |
Contact7 Email | 64 Char | Email. |
Contact7 Date of Birth | 8 Char | Date of Birth (YYYYMMDD). |
Contact7 Social Security Number | 9 Char | Social Security Number (no hyphens). |
Contact7 Mli 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. |