Interfaces

User Tools

Site Tools

Trace: • Merge Asset Management Text File Layout
student:registration_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
student:registration_import [2021/05/24 15:33] – lrosdahlstudent:registration_import [2024/08/13 13:49] (current) – lrosdahl
Line 1: Line 1:
-======Registration Import======+======Registration Import Guidelines======
  
-Used with external registration systems.+Used with ALL external registration systems.\\ \\ 
 +Review the guidelines in [[https://wiki.ascendertx.com/pages/viewpage.action?spaceKey=TCCTD&title=External+Registration+Setup|External Registration Setup]] in TCC Technical Documentation.
  
-|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|Student ID| + 
-|School Year|4 char|School Year| +**Notes**: 
-|Campus|3 char|Campus ID| +  * The export filename should be saved as: //enrollment.csv//. 
-|date entry|YYYYMMDD (8 Char)|Entry Date| +  * Headers are required. The data **MUST** be in the order as shown in the table below. 
-|Social Security Number|999999999 (9 Char)|State Student ID| +  * New and returning students are loaded. 
-|Last Name|25 char|Last Name| +    * **New students**: The first character of the StudentID for New Students **MUST** be a single alphabetic (A-Z). This is generally determined by the third-party vendor. If one is not present in the saved export .CSV file, please append one to the existing StudentID value, as it is used in the import process to identify new students. 
-|First Name|17 char|First Name| +    * **Returning students**: Returning students should already have a record in ASCENDER (Student ID, Campus, Entry Date, School Year, SSN and DOB should match ASCENDER table data). The returning student should be active for the current school year. 
-|Grade Level|2 char|Grade Level| +    * The program accepts Social Security Numbers that begin with "S". 
-|Middle Name|14 char|Middle Name| +  * Errors: 
-|Gen Code|Valid values from ET_C012_ GEN table (1 char)|Generation| +    * If a returning student does not have matching data in the fields listed below, the student will not import into ASCENDER and will produce an error. 
-|Street Nbr|6 char|Street Number| +    * Before attaching a .CSV file to the Jira ticket requesting an import, please review the saved export file for extra commas at the end of each line. Extra commas will cause the import to fail. Remove the extra commas manually using an application such as //Notepad// on Windows and resave the file before attaching to Jira ticket. 
-|Street Direction|2 char|Street Direction| +    * Students should have an active code of //1// and a status code of less than //4// in the campus for the current school year. 
-|Street Name|19 char|Street Name| + 
-|Apt Number|7 char|Apartment Number| +===Required Fields:=== 
-|City|17 char|City| +|Student ID|6 char for existing students; longer for new|Student ID.| 
-|State|2 char|State| +|School Year|4 char|School Year.| 
-|ZIP Code|5 char|ZIP Code| +|Campus|3 char|Campus ID.| 
-|ZIP Code+4|4 char|ZIP Code Plus Four| +|Date Entry|YYYYMMDD (8 Char)|Entry Date.| 
-|Date of Birth|YYYYMMDD (8 Char)|Date of Birth| +|Social Security Number|999999999 (9 Char)|State Student ID. Accepts the "S" State Student ID numbers.| 
-|Sex|1 char (M or F)|Sex| +|Last Name|25 char|Last Name.| 
-|Physical Street Nbr|6 char|Street Number| +|First Name|17 char|First Name.| 
-|Physical Street Direction|2 char|Street Direction| +|Middle Name|14 char|Middle Name.| 
-|Physical Street Name|19 char|Street Name| +|Gen Code|Valid values from ET_C012_ GEN table (1 char)|Generation.| 
-|Physical Apt Nbr|7 char|Apartment Number| +|Street Nbr|6 char|Street Number.| 
-|Physical City|17 char|City| +|Street Direction|2 char|Street Direction.| 
-|Physical ZIP Code|5 char|ZIP Code| +|Street Name|19 char|Street Name.| 
-|Physical ZIP Code+4|4 char|ZIP Code Plus Four| +|Apt Number|7 char|Apartment Number.| 
-|Student Home AC|3 char|Student Phone Area Code| +|City|17 char|City.| 
-|Student Home Phone Nbr|7 char (no hyphen)|Phone Number| +|State|2 char|State.| 
-|Ethnicity Hispanic|Y or N|Hispanic| +|ZIP Code|5 char|ZIP Code.| 
-|Race Black|Y or N|African American| +|ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Race White|Y or N|White| +|Date of Birth|YYYYMMDD (8 Char)|Date of Birth.| 
-|Race Pacific Islander|Y or N|Pacific Islander| +|Sex|1 char (M or F)|Sex.| 
-|Race Am. Ind/Alaskan|Y or N|Native American/Alaskan| +|Physical Street Nbr|6 char|Street Number.| 
-|Race Asian|Y or N|Asian| +|Physical Street Direction|2 char|Street Direction.| 
-|Student Previous District Name|13 char|Previous District| +|Physical Street Name|19 char|Street Name.| 
-|Student Previous Campus Name|34 char|Previous Campus| +|Physical Apt Nbr|7 char|Apartment Number.| 
-|Student Birth State| |This is a place holder .We are sending spaces now and the data received from registration vendor is not uploaded to any tables.| +|Physical City|17 char|City.| 
-|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.| +|Physical ZIP Code|5 char|ZIP Code.| 
-|Contact1 Last Name|25 char|Last Name| +|Physical ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Contact1 First Name|17 char|First Name| +|Student Home AC|3 char|Student Phone Area Code.| 
-|Contact1 Middle Name|14 char|Middle Name| +|Student Home Phone Nbr|7 char (no hyphen)|Phone Number.| 
-|Contact1 Generation CODE|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Ethnicity Hispanic|Y or N|Hispanic (Y or N).| 
-|Contact1 Relationship 1|2 char|Relationship| +|Race Black|1 Char|African American (Y or N).| 
-|Contact1 Primary Flag|1 char|Primary Contact| +|Race White|1 Char|White (Y or N).| 
-|Contact1 Emergency Flag|1 char|Emergency Contact| +|Race Pacific Islander|1 Char|Pacific Islander (Y or N).| 
-|Contact1 Migrant Flag|1 char| Migrant| +|Race Am. Ind/Alaskan|1 Char|Native American/Alaskan (Y or N).| 
-|Contact1 Street Nbr|6 char|Street Number| +|Race Asian|1 Char|Asian (Y or N).| 
-|Contact1 Street Name|19 char|Street Name| +|Student Previous District Name|13 char|Previous District.| 
-|Contact1 Apt Nbr|7 char|Apartment Number| +|Student Previous Campus Name|34 char|Previous Campus.| 
-|Contact1 City|17 char|City| +|Student Birth State| | .| 
-|Contact1 State|2 char|State| +|Student Birth City| | .| 
-|Contact1 ZIP Code|5 char|ZIP| +|Contact1 Last Name|25 char|Last Name.| 
-|Contact1 ZIP Code+4|4 char|ZIP Plus Four| +|Contact1 First Name|17 char|First Name.| 
-|Contact1 Home Phone AC|3 char|Phone Area Code| +|Contact1 Middle Name|14 char|Middle Name.| 
-|Contact1 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact1 Generation CODE|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact1 Work Phone AC|3 char|Phone Area Code| +|Contact1 Relationship 1|2 char|Relationship.| 
-|Contact1 Work Phone Nbr|7 char|Phone Number| +|Contact1 Primary Flag|1 char|Primary Contact.| 
-|Contact1 Work Phone EXT|4 char|Business Phone Extension| +|Contact1 Emergency Flag|1 char|Emergency Contact.| 
-|Contact1 Cell Area Code|3 char|Cell Phone Area Code| +|Contact1 Migrant Flag|1 char| Migrant.| 
-|Contact1 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact1 Street Nbr|6 char|Street Number.| 
-|Contact1 Cell Phone EXT|4 char| Cell Phone Extension| +|Contact1 Street Name|19 char|Street Name.| 
-|Contact1 Occup|25 char| Occupation| +|Contact1 Apt Nbr|7 char|Apartment Number.| 
-|Contact1 Email|64 char|Email| +|Contact1 City|17 char|City.| 
-|Contact1 Date of Birth|YYYYMMDD|Date of Birth| +|Contact1 State|2 char|State.| 
-|Contact1 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact1 ZIP Code|5 char|ZIP.| 
-|CONT1 Mil Ind|1 char|Military| +|Contact1 ZIP Code+4|4 char|ZIP Plus Four.| 
-|Contact1 Mil Branch|1 char|Military Branch| +|Contact1 Home Phone AC|3 char|Phone Area Code.| 
-|Contact1 Mil Rank|5 char| Military Rank| +|Contact1 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact1 Transport Ind|1 char|Transportation| +|Contact1 Work Phone AC|3 char|Phone Area Code.| 
-|Contact1 Veh Make|15 char|Vehicle Make| +|Contact1 Work Phone Nbr|7 char|Phone Number.| 
-|Contact1 Veh Model|15 char|Vehicle Model| +|Contact1 Work Phone EXT|4 char|Business Phone Extension.| 
-|Contact1 Veh Color|10 char|Vehicle Color| +|Contact1 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact1 Veh Lic|8 char|License Plate Number| +|Contact1 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact1 Veh Lic St|2 char| License Plate State| +|Contact1 Cell Phone EXT|4 char| Cell Phone Extension.| 
-|Contact1 Drv Lic Nbr|21 char|Drivers License Number| +|Contact1 Occup|25 char| Occupation.| 
-|Contact1 Drv Lic St|2 char|Drivers License State| +|Contact1 Email|64 char|Email.| 
-|Contact1 Sch Yr|4 char|School Year| +|Contact1 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact1 Seq Nbr|Integer|Priority| +|Contact1 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact1 Land CD|2 char| Language| +|CONT1 Mil Ind|1 char|Military.| 
-|Contact1 Cell Phn|10 char| Cell Phone Number| +|Contact1 Mil Branch|1 char|Military Branch.| 
-|Contact1 Phn Pref|1 char| Phone Preference| +|Contact1 Mil Rank|5 char| Military Rank.| 
-|Contact1 Rcv Mailouts|1 char|Receives Mailouts| +|Contact1 Transport Ind|1 char|Transportation.| 
-|Contact1 Prty|Integer|Priority| +|Contact1 Veh Make|15 char|Vehicle Make.| 
-|Contact2 Last Name|25 char|Last Name| +|Contact1 Veh Model|15 char|Vehicle Model.| 
-|Contact2 First Name|17 char|First Name| +|Contact1 Veh Color|10 char|Vehicle Color.| 
-|Contact2 Middle Name|14 char|Middle Name| +|Contact1 Veh Lic|8 char|License Plate Number.| 
-|Contact2 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Contact1 Veh Lic St|2 char| License Plate State.| 
-|Contact2 Relationship 1|2 char|Relationship| +|Contact1 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact2 Primary Flag|1 char|Primary Contact| +|Contact1 Drv Lic St|2 char|Drivers License State.| 
-|Contact2 Emergency Flag|1 char|Emergency Contact| +|Contact1 Sch Yr|4 char|School Year.| 
-|Contact2 Migrant Flag|1 char| Migrant| +|Contact1 Seq Nbr|Integer|Priority.| 
-|Contact2 Street Nbr|6 char|Street Number| +|Contact1 Land CD|2 char| Language.| 
-|Contact2 Street Name|19 char|Street Name| +|Contact1 Cell Phn|10 char| Cell Phone Number.| 
-|Contact2 Apt Nbr|7 char|Apartment Number| +|Contact1 Phn Pref|1 char| Phone Preference.| 
-|Contact2 City|17 char|City| +|Contact1 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact2 State|2 char|State| +|Contact2 Last Name|25 char|Last Name.| 
-|Contact2 ZIP Code|5 char|ZIP Code| +|Contact2 First Name|17 char|First Name.| 
-|Contact2 ZIP Code+4|4 char|ZIP Code Plus Four| +|Contact2 Middle Name|14 char|Middle Name.| 
-|Contact2 Home Phone AC|3 char|Phone Area Code| +|Contact2 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact2 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact2 Relationship 1|2 char|Relationship.| 
-|Contact2 Work Phone AC|3 char|Phone Area Code| +|Contact2 Primary Flag|1 char|Primary Contact.| 
-|Contact2 Work Phone Nbr|7 char|Phone Number| +|Contact2 Emergency Flag|1 char|Emergency Contact.| 
-|Contact2 Work Phone Ext|4 char|Business Phone Extension| +|Contact2 Migrant Flag|1 char| Migrant.| 
-|Contact2 Cell Area Code|3 char|Cell Phone Area Code| +|Contact2 Street Nbr|6 char|Street Number.| 
-|Contact2 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact2 Street Name|19 char|Street Name.| 
-|Contact2 Cell Phone Ext|4 char| Cell Phone Extension| +|Contact2 Apt Nbr|7 char|Apartment Number.| 
-|Contact2 Occup|25 char| Occupation| +|Contact2 City|17 char|City.| 
-|Contact2 Email|64 char|Email| +|Contact2 State|2 char|State.| 
-|Contact2 Date of Birth|YYYYMMDD|Date of Birth| +|Contact2 ZIP Code|5 char|ZIP Code.| 
-|Contact2 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact2 ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Contact2 Mil Ind|1 char|Military| +|Contact2 Home Phone AC|3 char|Phone Area Code.| 
-|Contact2 Mil Branch|1 char|Military Branch| +|Contact2 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact2 Mil Rank|5 char| Military Rank| +|Contact2 Work Phone AC|3 char|Phone Area Code.| 
-|Contact2 Transport Ind|1 char|Transportation| +|Contact2 Work Phone Nbr|7 char|Phone Number.| 
-|Contact2 Veh Make|15 char|Vehicle Make| +|Contact2 Work Phone Ext|4 char|Business Phone Extension.| 
-|Contact2 Veh Model|15 char|Vehicle Model| +|Contact2 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact2 Veh Color|10 char|Vehicle Color| +|Contact2 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact2 Veh Lic|8 char|License Plate Number| +|Contact2 Cell Phone Ext|4 char| Cell Phone Extension.| 
-|Contact2 Veh Lic Str|2 char| License Plate State| +|Contact2 Occup|25 char| Occupation.| 
-|Contact2 Drv Lic Nbr|21 char|Drivers License Number| +|Contact2 Email|64 char|Email.| 
-|Contact2 Drv Lic St|2 char|Drivers License State| +|Contact2 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact2  Sch Yr|4 char|School Year| +|Contact2 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact2  Seq Nbr|Integer|Priority| +|Contact2 Mil Ind|1 char|Military.| 
-|Contact2 Lang CD|2 char| Language| +|Contact2 Mil Branch|1 char|Military Branch.| 
-|Contact2 Cell Phn|10 char| Cell Phone Number| +|Contact2 Mil Rank|5 char| Military Rank.| 
-|Contact2 Phn Pref|1 char| Phone Preference| +|Contact2 Transport Ind|1 char|Transportation.| 
-|Contact2 Rcv Mailouts|1 char|Receives Mailouts| +|Contact2 Veh Make|15 char|Vehicle Make.| 
-|Contact2 Prty|Interger|Priority| +|Contact2 Veh Model|15 char|Vehicle Model.| 
-|Contact3 Last Name|25 char|Last Name| +|Contact2 Veh Color|10 char|Vehicle Color.| 
-|Contact3 First Name|17 char|First Name| +|Contact2 Veh Lic|8 char|License Plate Number.| 
-|Contact3 Middle Name|14 char|Middle Name| +|Contact2 Veh Lic Str|2 char| License Plate State.| 
-|Contact3 Generation Code|Valid values from ET_C012_ GEN table 1 char|Generation| +|Contact2 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact3 Relationship 1|2 char|Relationship| +|Contact2 Drv Lic St|2 char|Drivers License State.| 
-|Contact3 Primary Flag|1 char|Primary Contact| +|Contact2  Sch Yr|4 char|School Year.| 
-|Contact3 Emergency Flag|1 char|Emergency Contact| +|Contact2  Seq Nbr|Integer|Priority.| 
-|Contact3 Migrant Flag|1 char| Migrant| +|Contact2 Lang CD|2 char| Language.| 
-|Contact3 Street Nbr|6 char|Street Number| +|Contact2 Cell Phn|10 char| Cell Phone Number.| 
-|Contact3 Street Name|19 char|Street Name| +|Contact2 Phn Pref|1 char| Phone Preference.| 
-|Contact3 Apt Nbr|7 char|Apartment Number| +|Contact2 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact3 City|17 char|City| +|Contact3 Last Name|25 char|Last Name.| 
-|Contact3 State|2 char|State| +|Contact3 First Name|17 char|First Name.| 
-|Contact3 ZIP Code|5 char|ZIP Code| +|Contact3 Middle Name|14 char|Middle Name.| 
-|Contact3 ZIP Code+4|4 char|ZIP CodePlus Four| +|Contact3 Generation Code|Valid values from ET_C012_ GEN table 1 char|Generation.| 
-|Contact3 Home Phone AC|3 char|Phone Area Code| +|Contact3 Relationship 1|2 char|Relationship.| 
-|Contact3 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact3 Primary Flag|1 char|Primary Contact.| 
-|Contact3 Work Phone AC|3 char|Phone Area Code| +|Contact3 Emergency Flag|1 char|Emergency Contact.| 
-|Contact3 Work Phone Nbr|7 char|Phone Number| +|Contact3 Migrant Flag|1 char| Migrant.| 
-|Contact3 Work Phone Ext|4 char|Business Phone Extension| +|Contact3 Street Nbr|6 char|Street Number.| 
-|Contact3 Cell Area Code|3 char|Cell Phone Area Code| +|Contact3 Street Name|19 char|Street Name.| 
-|Contact3 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact3 Apt Nbr|7 char|Apartment Number.| 
-|Contact3 Cell Phone Ext|4 char| Cell Phone Extension| +|Contact3 City|17 char|City.| 
-|Contact3 Occup|25 char| Occupation| +|Contact3 State|2 char|State.| 
-|Contact3 Email|64 char|Email| +|Contact3 ZIP Code|5 char|ZIP Code.| 
-|Contact3 Date of Birth|YYYYMMDD|Date of Birth| +|Contact3 ZIP Code+4|4 char|ZIP CodePlus Four.| 
-|Contact3 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact3 Home Phone AC|3 char|Phone Area Code.| 
-|Contact3 Mil Ind|1 char|Military| +|Contact3 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact3 Mil Branch|1 char|Military Branch| +|Contact3 Work Phone AC|3 char|Phone Area Code.| 
-|Contact3 Mil Rank|5 char| Military Rank| +|Contact3 Work Phone Nbr|7 char|Phone Number.| 
-|Contact3 Transport Ind|1 char|Transportation| +|Contact3 Work Phone Ext|4 char|Business Phone Extension.| 
-|Contact3 Veh Make|15 char|Vehicle Make| +|Contact3 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact3 Veh Model|15 char|Vehicle Model| +|Contact3 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact3 Veh Color|10 char|Vehicle Color| +|Contact3 Cell Phone Ext|4 char| Cell Phone Extension.| 
-|Contact3 Veh Lic|8 char|License Plate Number| +|Contact3 Occup|25 char| Occupation.| 
-|Contact3 Veh Lic St|2 char| License Plate State| +|Contact3 Email|64 char|Email.| 
-|Contact3 Drv Lic Nbr|21 char|Drivers License Number| +|Contact3 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact3 Drv Lic St|2 char|Drivers License State| +|Contact3 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact3 Sch Yr|4 char|School Year| +|Contact3 Mil Ind|1 char|Military.| 
-|Contact3 Seq Nbr|Integer|Priority| +|Contact3 Mil Branch|1 char|Military Branch.| 
-|Contact3 Lang CD|2 char| Language| +|Contact3 Mil Rank|5 char| Military Rank.| 
-|Contact3 Cell Phn|10 char| Cell Phone Number| +|Contact3 Transport Ind|1 char|Transportation.| 
-|Contact3 Phn Pref|1 char| Phone Preference| +|Contact3 Veh Make|15 char|Vehicle Make.| 
-|Contact3 Rcv Mailouts|1 char|Receives Mailouts| +|Contact3 Veh Model|15 char|Vehicle Model.| 
-|Contact3 Prty|Interger|Priority| +|Contact3 Veh Color|10 char|Vehicle Color.| 
-|Contact4 Last Nam|25 char|Last Name| +|Contact3 Veh Lic|8 char|License Plate Number.| 
-|Contact4 First Name|17 char|First Name| +|Contact3 Veh Lic St|2 char| License Plate State.| 
-|Contact4 Middle Name|14 char|Middle Name| +|Contact3 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact4 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Contact3 Drv Lic St|2 char|Drivers License State.| 
-|Contact4 Relationship 1|2 char|Relationship| +|Contact3 Sch Yr|4 char|School Year.| 
-|Contact4 Primary Flag|1 char|Primary Contact| +|Contact3 Seq Nbr|Integer|Priority.| 
-|Contact4 Emergency Flag|1 char|Emergency Contact| +|Contact3 Lang CD|2 char| Language.| 
-|Contact4 Migrant Flag|1 char| Migrant| +|Contact3 Cell Phn|10 char| Cell Phone Number.| 
-|Contact4 Street Nbr|6 char|Street Number| +|Contact3 Phn Pref|1 char| Phone Preference.| 
-|Contact4 Street Name|19 char|Street Name| +|Contact3 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact4 Apt Nbr|7 char|Apartment Number| +|Contact4 Last Nam|25 char|Last Name.| 
-|Contact4 City|17 char|City| +|Contact4 First Name|17 char|First Name.| 
-|Contact4 State|2 char|State| +|Contact4 Middle Name|14 char|Middle Name.| 
-|Contact4 ZIP Code|5 char|ZIP Code| +|Contact4 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact4 ZIP Code+4|4 char|ZIP Code Plus Four| +|Contact4 Relationship 1|2 char|Relationship.| 
-|Contact4 Home Phone AC|3 char|Phone Area Code| +|Contact4 Primary Flag|1 char|Primary Contact.| 
-|Contact4 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact4 Emergency Flag|1 char|Emergency Contact.| 
-|Contact4 Work Phone AC|3 char|Phone Area Code| +|Contact4 Migrant Flag|1 char| Migrant.| 
-|Contact4 Work Phone Nbr|7 char|Phone Number| +|Contact4 Street Nbr|6 char|Street Number.| 
-|Contact4 Work Phone EXT|4 char|Business Phone Extension| +|Contact4 Street Name|19 char|Street Name.| 
-|Contact4 Cell AC|3 char|Cell Phone Area Code| +|Contact4 Apt Nbr|7 char|Apartment Number.| 
-|Contact4 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact4 City|17 char|City.| 
-|Contact4 Cell Phone EXT|4 char| Cell Phone Extension| +|Contact4 State|2 char|State.| 
-|Contact4 Occup|25 char| Occupation| +|Contact4 ZIP Code|5 char|ZIP Code.| 
-|Contact4 Email|64 char|Email| +|Contact4 ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Contact4 Date of Birth|YYYYMMDD|Date of Birth| +|Contact4 Home Phone AC|3 char|Phone Area Code.| 
-|Contact4 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact4 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact4 Mil Ind|1 char|Military| +|Contact4 Work Phone AC|3 char|Phone Area Code.| 
-|Contact4 Mil Branch|1 char|Military Branch| +|Contact4 Work Phone Nbr|7 char|Phone Number.| 
-|Contact4 Mil Rank|5 char| Military Rank| +|Contact4 Work Phone EXT|4 char|Business Phone Extension.| 
-|Contact4 Transport Ind|1 char|Transportation| +|Contact4 Cell AC|3 char|Cell Phone Area Code.| 
-|Contact4 Veh Make|15 char|Vehicle Make| +|Contact4 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact4 Veh Model|15 char|Vehicle Model| +|Contact4 Cell Phone EXT|4 char| Cell Phone Extension.| 
-|Contact4 Veh Color|10 char|Vehicle Color| +|Contact4 Occup|25 char| Occupation.| 
-|Contact4 Veh Lic|8 char|License Plate Number| +|Contact4 Email|64 char|Email.| 
-|Contact4 Veh Lic St|2 char| License Plate State| +|Contact4 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact4 Drv Lic Nbr|21 char|Drivers License Number| +|Contact4 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact4 Drv Lic St|2 char|Drivers License State| +|Contact4 Mil Ind|1 char|Military.| 
-|Contact4 Sch Yr|4 char|School Year| +|Contact4 Mil Branch|1 char|Military Branch.| 
-|Contact4 Seq Nbr|Integer|Priority| +|Contact4 Mil Rank|5 char| Military Rank.| 
-|Contact4 Lang CD|2 char| Language| +|Contact4 Transport Ind|1 char|Transportation.| 
-|Contact4 Cell Phn|10 char| Cell Phone Number| +|Contact4 Veh Make|15 char|Vehicle Make.| 
-|Contact4 Phn Pref|1 char| Phone Preference| +|Contact4 Veh Model|15 char|Vehicle Model.| 
-|Contact4 Rcv Mailouts|1 char|Receives Mailouts| +|Contact4 Veh Color|10 char|Vehicle Color.| 
-|Contact4 Prty|Interger|Priority| +|Contact4 Veh Lic|8 char|License Plate Number.| 
-|Contact5 Last Name|25 char|Last Name| +|Contact4 Veh Lic St|2 char| License Plate State.| 
-|Contact5 First Name|17 char|First Name| +|Contact4 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact5 Middle Name|14 char|Middle Name| +|Contact4 Drv Lic St|2 char|Drivers License State.| 
-|Contact5 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Contact4 Sch Yr|4 char|School Year.| 
-|Contact5 Relationship 1|2 char|Relationship| +|Contact4 Seq Nbr|Integer|Priority.| 
-|Contact5 Primary Flag|1 char|Primary Contact| +|Contact4 Lang CD|2 char| Language.| 
-|Contact5 Emergency Flag|1 char|Emergency Contact| +|Contact4 Cell Phn|10 char| Cell Phone Number.| 
-|Contact5 Migrant Flag|1 char| Migrant| +|Contact4 Phn Pref|1 char| Phone Preference.| 
-|Contact5 Street Nbr|6 char|Street Number| +|Contact4 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact5 Street Name|19 char|Street Name| +|Contact5 Last Name|25 char|Last Name.| 
-|Contact5 Apt Nbr|7 char|Apartment Number| +|Contact5 First Name|17 char|First Name.| 
-|Contact5 City|17 char|City| +|Contact5 Middle Name|14 char|Middle Name.| 
-|Contact5 State|2 char|State| +|Contact5 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact5 ZIP Code|5 char|ZIP Code| +|Contact5 Relationship 1|2 char|Relationship.| 
-|Contact5 ZIP Code+4|4 char|ZIP Code Plus Four| +|Contact5 Primary Flag|1 char|Primary Contact.| 
-|Contact5 Home Phone AC|3 char|Phone Area Code| +|Contact5 Emergency Flag|1 char|Emergency Contact.| 
-|Contact5 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact5 Migrant Flag|1 char| Migrant.| 
-|Contact5 Work Phone AC|3 char|Phone Area Code| +|Contact5 Street Nbr|6 char|Street Number.| 
-|Contact5 Work Phone Nbr|7 char|Phone Number| +|Contact5 Street Name|19 char|Street Name.| 
-|Contact5 Work Phone Ext|4 char|Business Phone Extension| +|Contact5 Apt Nbr|7 char|Apartment Number.| 
-|Contact5 Cell Area Code|3 char|Cell Phone Area Code| +|Contact5 City|17 char|City.| 
-|Contact5 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact5 State|2 char|State.| 
-|Contact5 Cell Phone Ext|4 char| Cell Phone Extension| +|Contact5 ZIP Code|5 char|ZIP Code.| 
-|Contact5 Occup|25 char| Occupation| +|Contact5 ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Contact5 Email|64 char|Email| +|Contact5 Home Phone AC|3 char|Phone Area Code.| 
-|Contact5 Date of Birth|YYYYMMDD|Date of Birth| +|Contact5 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact5 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact5 Work Phone AC|3 char|Phone Area Code.| 
-|Contact5 Mil Ind|1 char|Military| +|Contact5 Work Phone Nbr|7 char|Phone Number.| 
-|Contact5 Mil Branch|1 char|Military Branch| +|Contact5 Work Phone Ext|4 char|Business Phone Extension.| 
-|Contact5 Mil Rank|5 char| Military Rank| +|Contact5 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact5 Transport Ind|1 char|Transportation| +|Contact5 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact5 Veh Make|15 char|Vehicle Make| +|Contact5 Cell Phone Ext|4 char| Cell Phone Extension.| 
-|Contact5 Veh Model|15 char|Vehicle Model| +|Contact5 Occup|25 char| Occupation.| 
-|Contact5 Veh Color|10 char|Vehicle Color| +|Contact5 Email|64 char|Email.| 
-|Contact5 Veh Lic|8 char|License Plate Number| +|Contact5 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact5 Veh Lic St|2 char| License Plate State| +|Contact5 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact5 Drv Lic Nbr|21 char|Drivers License Number| +|Contact5 Mil Ind|1 char|Military.| 
-|Contact5 Drv Lic St|2 char|Drivers License State| +|Contact5 Mil Branch|1 char|Military Branch.| 
-|Contact5 Sch Yr|4 char|School Year| +|Contact5 Mil Rank|5 char| Military Rank.| 
-|Contact5 Seq Nbr|Integer|Priority| +|Contact5 Transport Ind|1 char|Transportation.| 
-|Contact5 Lang Cd|2 char| Language| +|Contact5 Veh Make|15 char|Vehicle Make.| 
-|Contact5 Cell Phn|10 char| Cell Phone Number| +|Contact5 Veh Model|15 char|Vehicle Model.| 
-|Contact5 Phn Pref|1 char| Phone Preference| +|Contact5 Veh Color|10 char|Vehicle Color.| 
-|Contact5 Rcv Mailouts|1 char|Receives Mailouts| +|Contact5 Veh Lic|8 char|License Plate Number.| 
-|Contact6 Prty|Interger|Priority| +|Contact5 Veh Lic St|2 char| License Plate State.| 
-|Contact6 Last Name|25 char|Last Name| +|Contact5 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact6 First Name|17 char|First Name| +|Contact5 Drv Lic St|2 char|Drivers License State.| 
-|Contact6 Middle Name|14 char|Middle Name| +|Contact5 Sch Yr|4 char|School Year.| 
-|Contact6 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Contact5 Seq Nbr|Integer|Priority.| 
-|Contact6 Relationship 1|2 char|Relationship| +|Contact5 Lang Cd|2 char| Language.| 
-|Contact6 Primary Flag|1 char|Primary Contact| +|Contact5 Cell Phn|10 char| Cell Phone Number.| 
-|Contact6 Emergency Flag|1 char|Emergency Contact| +|Contact5 Phn Pref|1 char| Phone Preference.| 
-|Contact6 Migrant Flag|1 char| Migrant| +|Contact5 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact6 Street Nbr|6 char|Street Number| +|Contact6 Last Name|25 char|Last Name.| 
-|Contact6 Street Name|19 char|Street Name| +|Contact6 First Name|17 char|First Name.| 
-|Contact6 Apt Nbr|7 char|Apartment Number| +|Contact6 Middle Name|14 char|Middle Name.| 
-|Contact6 City|17 char|City| +|Contact6 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact6 State|2 char|State| +|Contact6 Relationship 1|2 char|Relationship.| 
-|Contact6 ZIP Code|5 char|ZIP Code| +|Contact6 Primary Flag|1 char|Primary Contact.| 
-|Contact6 ZIP Code+4|4 char|ZIP Code Plus Four| +|Contact6 Emergency Flag|1 char|Emergency Contact.| 
-|Contact6 Home Phone AC|3 char|Phone Area Code| +|Contact6 Migrant Flag|1 char| Migrant.| 
-|Contact6 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact6 Street Nbr|6 char|Street Number.| 
-|Contact6 Work Phone AC|3 char|Phone Area Code| +|Contact6 Street Name|19 char|Street Name.| 
-|Contact6 Work Phone Nbr|7 char|Phone Number| +|Contact6 Apt Nbr|7 char|Apartment Number.| 
-|Contact6 Work Phone Ext|4 char|Business Phone Extension| +|Contact6 City|17 char|City.| 
-|Contact6 Cell Area Code|3 char|Cell Phone Area Code| +|Contact6 State|2 char|State.| 
-|Contact6 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact6 ZIP Code|5 char|ZIP Code.| 
-|Contact6 Cell Phone Ext|4 char| Cell Phone Extension| +|Contact6 ZIP Code+4|4 char|ZIP Code Plus Four.| 
-|Contact6 Occup|25 char| Occupation| +|Contact6 Home Phone AC|3 char|Phone Area Code.| 
-|Contact6 Email|64 char|Email| +|Contact6 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact6 Date of Birth|YYYYMMDD|Date of Birth| +|Contact6 Work Phone AC|3 char|Phone Area Code.| 
-|Contact6 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact6 Work Phone Nbr|7 char|Phone Number.| 
-|Contact6 Mil Ind|1 char|Military| +|Contact6 Work Phone Ext|4 char|Business Phone Extension.| 
-|Contact6 Mil Branch|1 char|Military Branch| +|Contact6 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact6 Mil Rank|5 char| Military Rank| +|Contact6 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact6 Transport Ind|1 char|Transportation| +|Contact6 Cell Phone Ext|4 char| Cell Phone Extension.| 
-|Contact6 Veh Make|15 char|Vehicle Make| +|Contact6 Occup|25 char| Occupation.| 
-|Contact6 Veh Model|15 char|Vehicle Model| +|Contact6 Email|64 char|Email.| 
-|Contact6 Veh Color|10 char|Vehicle Color| +|Contact6 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact6 Veh Lic|8 char|License Plate Number| +|Contact6 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact6 Veh Lic St|2 char| License Plate State| +|Contact6 Mil Ind|1 char|Military.| 
-|Contact6 Drv Lic Nbr|21 char|Drivers License Number| +|Contact6 Mil Branch|1 char|Military Branch.| 
-|Contact6 Drv Lic St|2 char|Drivers License State| +|Contact6 Mil Rank|5 char| Military Rank.| 
-|Contact6 Sch Yr|4 char|School Year| +|Contact6 Transport Ind|1 char|Transportation.| 
-|Contact6 Seq Nbr|Integer|Priority| +|Contact6 Veh Make|15 char|Vehicle Make.| 
-|Contact6 Lang Cd|2 char| Language| +|Contact6 Veh Model|15 char|Vehicle Model.| 
-|Contact6 Cell Phn|10 char| Cell Phone Number| +|Contact6 Veh Color|10 char|Vehicle Color.| 
-|Contact6 Phn Pref|1 char| Phone Preference| +|Contact6 Veh Lic|8 char|License Plate Number.| 
-|Contact6 Rcv Mailouts|1 char|Receives Mailouts| +|Contact6 Veh Lic St|2 char| License Plate State.| 
-|Contact6 Prty|Interger|Priority| +|Contact6 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact7 Last Name|25 char|Last Name| +|Contact6 Drv Lic St|2 char|Drivers License State.| 
-|Contact7 First Name|17 char|First Name| +|Contact6 Sch Yr|4 char|School Year.| 
-|Contact7 Middle Name|14 char|Middle Name| +|Contact6 Seq Nbr|Integer|Priority.| 
-|Contact7 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation| +|Contact6 Lang Cd|2 char| Language.| 
-|Contact7 Relationship 1|2 char|Relationship| +|Contact6 Cell Phn|10 char| Cell Phone Number.| 
-|Contact7 Primary Flag|1 char|Primary Contact| +|Contact6 Phn Pref|1 char| Phone Preference.| 
-|Contact7 Emergency Flag|1 char|Emergency Contact| +|Contact6 Rcv Mailouts|1 char|Receives Mailouts.| 
-|Contact7 Migrant Flag|1 char| Migrant| +|Contact7 Last Name|25 char|Last Name.| 
-|Contact7 Street Nbr|6 char|Street Number| +|Contact7 First Name|17 char|First Name.| 
-|Contact7 Street Name|19 char|Street Name| +|Contact7 Middle Name|14 char|Middle Name.| 
-|Contact7 Apt Nbr|7 char|Apartment Number| +|Contact7 Generation Code|Valid values from ET_C012_ Generationtable 1 char|Generation.| 
-|Contact7 City|17 char|City| +|Contact7 Relationship 1|2 char|Relationship.| 
-|Contact7 State|2 char|State| +|Contact7 Primary Flag|1 char|Primary Contact.| 
-|Contact7 ZIP Code|5 char|ZIP Code| +|Contact7 Emergency Flag|1 char|Emergency Contact.| 
-|Contact7 ZIP Code+4|4 char|ZIP CodePlus Four| +|Contact7 Migrant Flag|1 char| Migrant.| 
-|Contact7 Home Phone AC|3 char|Phone Area Code| +|Contact7 Street Nbr|6 char|Street Number.| 
-|Contact7 Home Phone Nbr|7 char (no hyphens)|Phone Number| +|Contact7 Street Name|19 char|Street Name.| 
-|Contact7 Work Phone AC|3 char|Phone Area Code| +|Contact7 Apt Nbr|7 char|Apartment Number.| 
-|Contact7 Work Phone Nbr|7 char|Phone Number| +|Contact7 City|17 char|City.| 
-|Contact7 Work Phone Ext|4 char|Business Phone Extension| +|Contact7 State|2 char|State.| 
-|Contact7 Cell Area Code|3 char|Cell Phone Area Code| +|Contact7 ZIP Code|5 char|ZIP Code.| 
-|Contact7 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number| +|Contact7 ZIP Code+4|4 char|ZIP CodePlus Four.| 
-|Contact7 Cell Phone Ext|4 char| Cell Phone Extension| +|Contact7 Home Phone AC|3 char|Phone Area Code.| 
-|Contact7 Occup|25 char| Occupation| +|Contact7 Home Phone Nbr|7 char (no hyphens)|Phone Number.| 
-|Contact7 Email|64 char|Email| +|Contact7 Work Phone AC|3 char|Phone Area Code.| 
-|Contact7 Date of Birth|YYYYMMDD|Date of Birth| +|Contact7 Work Phone Nbr|7 char|Phone Number.| 
-|Contact7 Social Security Number|9 char (no hyphens)|Social Security Number| +|Contact7 Work Phone Ext|4 char|Business Phone Extension.| 
-|Contact7 Mil Ind|1 char|Military| +|Contact7 Cell Area Code|3 char|Cell Phone Area Code.| 
-|Contact7 Mil Branch|1 char|Military Branch| +|Contact7 Cell Phone Nbr|7 char (no hyphens)|Cell Phone Number.| 
-|Contact7 Mil Rank|5 char| Military Rank| +|Contact7 Cell Phone Ext|4 char| Cell Phone Extension.| 
-|Contact7 Transport Ind|1 char|Transportation| +|Contact7 Occup|25 char| Occupation.| 
-|Contact7 Veh Make|15 char|Vehicle Make| +|Contact7 Email|64 char|Email.| 
-|Contact7 Veh Model|15 char|Vehicle Model| +|Contact7 Date of Birth|YYYYMMDD|Date of Birth.| 
-|Contact7 Veh Color|10 char|Vehicle Color| +|Contact7 Social Security Number|9 char (no hyphens)|Social Security Number.| 
-|Contact7 Veh Lic|8 char|License Plate Number| +|Contact7 Mil Ind|1 char|Military.| 
-|Contact7 Veh Lic STR|2 char| License Plate State| +|Contact7 Mil Branch|1 char|Military Branch.| 
-|Contact7 Drv Lic Nbr|21 char|Drivers License Number| +|Contact7 Mil Rank|5 char| Military Rank.| 
-|Contact7 Drv Lic St|2 char|Drivers License State| +|Contact7 Transport Ind|1 char|Transportation.| 
-|Contact7 Sch Yr|4 char|School Year| +|Contact7 Veh Make|15 char|Vehicle Make.| 
-|Contact7 Seq Nbr|Integer|Priority| +|Contact7 Veh Model|15 char|Vehicle Model.| 
-|Contact7 Lang Cd|2 char| Language| +|Contact7 Veh Color|10 char|Vehicle Color.| 
-|Contact7 Cell Phn|10 char| Cell Phone Number| +|Contact7 Veh Lic|8 char|License Plate Number.| 
-|Contact7 Phn Pref|1 char| Phone Preference| +|Contact7 Veh Lic STR|2 char| License Plate State.| 
-|Contact7 Rcv Mailouts|1 char|Receives Mailouts| +|Contact7 Drv Lic Nbr|21 char|Drivers License Number.| 
-|Contact7 Prty|Interger|Priority|+|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.|
student/registration_import.1621870416.txt.gz · Last modified: 2021/05/24 10:33 (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.