This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
student:registration_export [2020/10/10 00:18] – lrosdahl | student:registration_export [2021/08/06 18:03] (current) – lrosdahl | ||
---|---|---|---|
Line 1: | Line 1: | ||
======Registration Export====== | ======Registration Export====== | ||
- | Used with ZippSlip. | + | Used with external registration systems. |
- | |Student ID|6 char for existing students; longer for new|Student ID| | + | **Notes**: |
- | |ZippSlip Stu Id|This is the Student ID sent from ZippSlip in the import | + | * The file is a .csv. ASCENDER has no requirement for naming this file. |
- | |School Year|4 char|School Year| | + | |
- | |Campus|3 char|Campus ID| | + | |
- | |date entry|YYYYMMDD (8 Char)|Entry Date| | + | |
- | |Social Security Number|999999999 (9 Char)|State Student ID| | + | |
- | |Last Name|25 char|Last Name| | + | |
- | |First Name|17 char|First Name| | + | |
- | |Grade Level|2 char|GRD_LVL| | + | |
- | |Middle Name|14 char|Middle Name| | + | |
- | |Gen Code|Valid values from ET_C012_Generation table (1 char)|Generation| | + | |
- | |Street Nbr|6 char|Street Number| | + | |
- | |Street Direction|2 char|Street Direction| | + | |
- | |Street Name|19 char|Street Name| | + | |
- | |Apt Number|7 char|Apartment Number| | + | |
- | |City|17 char|City| | + | |
- | |State|2 char|State| | + | |
- | |ZIP Code|5 char|ZIP Code| | + | |
- | |ZIP Code+4|4 char|ZIP Code4| | + | |
- | |Date of Birth|YYYYMMDD (8 Char)|Date of Birth| | + | |
- | |Sex|1 char (M or F)|Sex| | + | |
- | |Physical Street Nbr|6 char|Street Number| | + | |
- | |Physical Street Direction|2 char|Street Direction| | + | |
- | |Physical Street Name|19 char|Street Name| | + | |
- | |Physical Apt Nbr|7 char|Apartment Number| | + | |
- | |Physical City|17 char|City| | + | |
- | |Physical ZIP Code|5 char|ZIP Code| | + | |
- | |Physical ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Student Home AC|3 char|Student Phone Area Code| | + | |
- | |Student Home Phone Nbr|7 char (no hyphen)|Phone Number| | + | |
- | |Ethnicity Hispanic|Y or N|Hispanic| | + | |
- | |Race Black|Y or N|African American| | + | |
- | |Race White|Y or N|White| | + | |
- | |Race Pacific Islander|Y or N|Pacific Islander| | + | |
- | |Race Am. Ind/ | + | |
- | |Race Asian|Y or N|Asian| | + | |
- | |Student Previous District Name|13 char|Previous District| | + | |
- | |Student Previous Campus Name|34 char|Previous District| | + | |
- | |Student Birth State| |This is a place holder | + | |
- | |Student Birth City| |This is a place holder | + | |
- | |Contact1 LAST NAME|25 char|Last Name| | + | |
- | |Contact1 FIRST NAME|17 char|First Name| | + | |
- | |Contact1 MIDDLE NAME|14 char|Middle Name| | + | |
- | |Contact1 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation| | + | |
- | |Contact1 RelationshipIONSHIP 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| | + | |
- | |Contact1 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact1 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact1 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact1 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact1 Occup|25 char|Occupation | | + | |
- | |Contact1 Email|64 char|Email| | + | |
- | |Contact1 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact1 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT1 MIL IND|1 char|Military| | + | |
- | |Contact1 MIL BRANCH|1 char|Military Branch| | + | |
- | |Contact1 MIL RANK|5 char|Military Rank | | + | |
- | |Contact1 TRANSPORT IND|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_ST | | + | |
- | |Contact1 DRV LIC NBR|21 char|Drivers License Number| | + | |
- | |Contact1 DRV LIC ST|2 char|Drivers License State| | + | |
- | |Contact1 | + | |
- | |Contact1 | + | |
- | |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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation | | + | |
- | |Contact2 RelationshipIONSHIP 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| | + | |
- | |Contact2 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact2 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact2 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact2 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact2 Occup|25 char|Occupation | | + | |
- | |Contact2 Email|64 char|Email| | + | |
- | |Contact2 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact2 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT2 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 | + | |
- | |Contact2 | + | |
- | |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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation | | + | |
- | |Contact3 RelationshipIONSHIP 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| | + | |
- | |Contact3 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact3 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact3 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact3 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact3 Occup|25 char|Occupation | | + | |
- | |Contact3 Email|64 char|Email| | + | |
- | |Contact3 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact3 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT3 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 | + | |
- | |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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation | | + | |
- | |Contact4 RelationshipIONSHIP 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| | + | |
- | |Contact4 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact4 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact4 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |Contact4 WORK PHONE AC|3 char|Phone Area Code_BUS| | + | |
- | |Contact4 WORK PHONE NBR|7 char|Phone Number_BUS| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact4 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact4 Occup|25 char|Occupation | | + | |
- | |Contact4 Email|64 char|Email| | + | |
- | |Contact4 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact4 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT4 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 | + | |
- | |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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation | | + | |
- | |Contact5 RelationshipIONSHIP 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| | + | |
- | |Contact5 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact5 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact5 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact5 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact5 Occup|25 char|Occupation | | + | |
- | |Contact5 Email|64 char|Email| | + | |
- | |Contact5 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact5 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT5 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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation| | + | |
- | |Contact6 RelationshipIONSHIP 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| | + | |
- | |Contact6 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact6 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact6 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact6 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact6 Occup|25 char|Occupation | | + | |
- | |Contact6 Email|64 char|Email| | + | |
- | |Contact6 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact6 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT6 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 GenerationERATION CODE|Valid values from ET_C012_GEN table 1 char|Generation| | + | |
- | |Contact7 RelationshipIONSHIP 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| | + | |
- | |Contact7 ZIP Code+4|4 char|ZIP Plus Four| | + | |
- | |Contact7 HOME PHONE AC|3 char|Phone Area Code| | + | |
- | |Contact7 HOME PHONE NBR|7 char (no hyphens)|Phone Number| | + | |
- | |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 (no hyphens)|Cell Phone Number| | + | |
- | |Contact7 CELL PHONE EXT|4 char|Cell Phone Extension | | + | |
- | |Contact7 Occup|25 char|Occupation | | + | |
- | |Contact7 Email|64 char|Email| | + | |
- | |Contact7 Date of Birth|YYYYMMDD|Date of Birth| | + | |
- | |Contact7 Social Security Number|9 char (no hyphens)|Social Security Number| | + | |
- | |CONT7 MIL 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| | + | |
+ | |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.| |