This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
student:registration_export [2020/10/05 13:33] – created lrosdahl | student:registration_export [2021/08/06 18:03] (current) – lrosdahl | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======Registration | + | ======Registration Export====== |
+ | |||
+ | Used with external registration systems. | ||
+ | |||
+ | **Notes**: | ||
+ | * The file is a .csv. ASCENDER has no requirement for naming this file. | ||
+ | |||
+ | |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 " | ||
+ | |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/ | ||
+ | |Race Asian|1 Char|Asian (Y or N).| | ||
+ | |Student Previous District Name|13 Char|Student' | ||
+ | |Student Previous Campus Name|34 Char|Student' | ||
+ | |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.| |