student:online_registration_import
Book Creator
Add this page to your book
Add this page to your book Book Creator
Remove this page from your book
Remove this page from your book 
Manage book (
Help Registration Import from Third-Party Lottery System
This requires a third-party agreement form…
| Field | Type and Length | Notes |
|---|---|---|
| CAMPUS_ID | CHAR(03) | |
| TRACK | CHAR(01) | 1 digit (0-9) |
| GRD_LVL | CHAR(02) | |
| NAME_L | CHAR(25) | |
| NAME_F | CHAR(17) | |
| NAME_M | CHAR(14) | |
| NAME_GEN_CD | CHAR(01) | |
| ELIG_CD | CHAR(01) | |
| STATUS_CD | CHAR(01) | |
| DT_ENTRY | CHAR(08) | |
| STATE_STU_ID | CHAR(09) | |
| ATTRIBUTION_CD | CHAR(02) | |
| CAMPUS_ID_RES | CHAR(09) | |
| ADDR_STR_NBR | CHAR(06) | |
| ADDR_STR_NAME | CHAR(19) | |
| ADDR_STR_DIR | CHAR(02) | Street direction |
| ADDR_APT_NBR | CHAR(07) | |
| ADDR_CITY | CHAR(17) | |
| ADDR_STATE | CHAR(02) | |
| ADDR_ZIP | CHAR(05) | |
| ADDR_ZIP4 | CHAR(04) | |
| SEX | CHAR(01) | |
| DOB | CHAR(08) | |
| STU_PHONE_AC | CHAR(03) | |
| PHONE_NBR | CHAR(07) | |
| STR_NBR_PHYS | CHAR(06) | Physical address fields |
| STR_NAME_PHYS | CHAR(19) | |
| STR_DRCTN_PHYS | CHAR(02) | |
| APT_NBR_PHYS_ADDR | CHAR(07) | |
| CITY_NAME_PHYS_ADDR | CHAR(17) | |
| ZIP_CODE_PHYS_ADDR | CHAR(05) | |
| ZIP4_PHYS_ADDR | CHAR(04) | |
| PHYS_ADDR_STATE | CHAR(02) | |
| LANG_PRI | CHAR(02) | |
| PAR_MILITARY | CHAR(01) | |
| ETHN_HISPANIC | CHAR(01) | |
| RACE_AMER_INDIAN | CHAR(01) | |
| RACE_ASIAN | CHAR(01) | |
| RACE_BLACK | CHAR(01) | |
| RACE_WHITE | CHAR(01) | |
| RACE_PACIFIC_ISL | CHAR(01) | |
| VARCHAR(64) | ||
| STU_CELL_PH | VARCHAR(10) | |
| HOME_LANG_CD | CHAR(02) | |
| C1_NAME_L | CHAR(25) | |
| C1_NAME_F | CHAR(17) | |
| C1_NAME_M | CHAR(14) | |
| C1_GEN | CHAR(01) | |
| C1_RELAT | CHAR(02) | |
| C1_STR_NBR | CHAR(06) | |
| C1_STR_NAME | CHAR(19) | |
| C1_APT_NBR | CHAR(07) | |
| C1_CITY | CHAR(17) | |
| C1_STATE_CD | CHAR(02) | |
| C1_ZIP | CHAR(05) | |
| C1_ZIP4 | CHAR(04) | |
| C1_PHONE_AREA_CD | CHAR(03) | |
| C1_PHONE_NBR | CHAR(07) | |
| C1_PHONE_AREA_CD_BUS | CHAR(03) | |
| C1_PHONE_NBR_BUS | CHAR(07) | |
| C1_PHONE_EXT_BUS | CHAR(04) | |
| C1_OCCUPATION | CHAR(25) | |
| C1_OTHER_PHONE_AC | CHAR(03) | |
| C1_OTHER_PHONE_NBR | CHAR(07) | |
| C1_OTHER_PHONE_EXT | CHAR(04) | |
| C1_GUARDIAN_IND | CHAR(01) | |
| C1_EMERGENCY_FLAG | CHAR(01) | |
| C1_MIL_IND | CHAR(01) | |
| C1_EMAIL | CHAR(64) | |
| C1_ENROLL_PAR_IND | CHAR(01) | |
| C1_TRANSPORT_IND | CHAR(01) | |
| C1_LANG_CD | CHAR(02) | |
| C1_RCV_MAILOUTS | CHAR(01) | |
| C1_CELL_PHONE | CHAR(10) | |
| C1_PHONE_PREF | CHAR(01) | |
| C2_NAME_L | CHAR(25) | |
| C2_NAME_F | CHAR(17) | |
| C2_NAME_M | CHAR(14) | |
| C2_GEN | CHAR(01) | |
| C2_RELAT | CHAR(02) | |
| C2_STR_NBR | CHAR(06) | |
| C2_STR_NAME | CHAR(19) | |
| C2_APT_NBR | CHAR(07) | |
| C2_CITY | CHAR(17) | |
| C2_STATE_CD | CHAR(02) | |
| C2_ZIP | CHAR(05) | |
| C2_ZIP4 | CHAR(04) | |
| C2_PHONE_AREA_CD | CHAR(03) | |
| C2_PHONE_NBR | CHAR(07) | |
| C2_PHONE_AREA_CD_BUS | CHAR(03) | |
| C2_PHONE_NBR_BUS | CHAR(07) | |
| C2_PHONE_EXT_BUS | CHAR(04) | |
| C2_OCCUPATION | CHAR(25) | |
| C2_OTHER_PHONE_AC | CHAR(03) | |
| C2_OTHER_PHONE_NBR | CHAR(07) | |
| C2_OTHER_PHONE_EXT | CHAR(04) | |
| C2_GUARDIAN_IND | CHAR(01) | |
| C2_EMERGENCY_FLAG | CHAR(01) | |
| C2_MIL_IND | CHAR(01) | |
| C2_EMAIL | CHAR(64) | |
| C2_ENROLL_PAR_IND | CHAR(01) | |
| C2_TRANSPORT_IND | CHAR(01) | |
| C2_LANG_CD | CHAR(02) | |
| C2_RCV_MAILOUTS | CHAR(01) | |
| C2_CELL_PHONE | CHAR(10) | |
| C2_PHONE_PREF | CHAR(01) | |
| C3_NAME_L | CHAR(25) | |
| C3_NAME_F | CHAR(17) | |
| C3_NAME_M | CHAR(14) | |
| C3_GEN | CHAR(01) | |
| C3_RELAT | CHAR(02) | |
| C3_STR_NBR | CHAR(06) | |
| C3_STR_NAME | CHAR(19) | |
| C3_APT_NBR | CHAR(07) | |
| C3_CITY | CHAR(17) | |
| C3_STATE_CD | CHAR(02) | |
| C3_ZIP | CHAR(05) | |
| C3_ZIP4 | CHAR(04) | |
| C3_PHONE_AREA_CD | CHAR(03) | |
| C3_PHONE_NBR | CHAR(07) | |
| C3_PHONE_AREA_CD_BUS | CHAR(03) | |
| C3_PHONE_NBR_BUS | CHAR(07) | |
| C3_PHONE_EXT_BUS | CHAR(04) | |
| C3_OCCUPATION | CHAR(25) | |
| C3_OTHER_PHONE_AC | CHAR(03) | |
| C3_OTHER_PHONE_NBR | CHAR(07) | |
| C3_OTHER_PHONE_EXT | CHAR(04) | |
| C3_GUARDIAN_IND | CHAR(01) | |
| C3_EMERGENCY_FLAG | CHAR(01) | |
| C3_MIL_IND | CHAR(01) | |
| C3_EMAIL | CHAR(64) | |
| C3_ENROLL_PAR_IND | CHAR(01) | |
| C3_TRANSPORT_IND | CHAR(01) | |
| C3_LANG_CD | CHAR(02) | |
| C3_RCV_MAILOUTS | CHAR(01) | |
| C3_CELL_PHONE | CHAR(10) | |
| C3_PHONE_PREF | CHAR(01) | |
| C4_NAME_L | CHAR(25) | |
| C4_NAME_F | CHAR(17) | |
| C4_NAME_M | CHAR(14) | |
| C4_GEN | CHAR(01) | |
| C4_RELAT | CHAR(02) | |
| C4_STR_NBR | CHAR(06) | |
| C4_STR_NAME | CHAR(19) | |
| C4_APT_NBR | CHAR(07) | |
| C4_CITY | CHAR(17) | |
| C4_STATE_CD | CHAR(02) | |
| C4_ZIP | CHAR(05) | |
| C4_ZIP4 | CHAR(04) | |
| C4_PHONE_AREA_CD | CHAR(03) | |
| C4_PHONE_NBR | CHAR(07) | |
| C4_PHONE_AREA_CD_BUS | CHAR(03) | |
| C4_PHONE_NBR_BUS | CHAR(07) | |
| C4_PHONE_EXT_BUS | CHAR(04) | |
| C4_OCCUPATION | CHAR(25) | |
| C4_OTHER_PHONE_AC | CHAR(03) | |
| C4_OTHER_PHONE_NBR | CHAR(07) | |
| C4_OTHER_PHONE_EXT | CHAR(04) | |
| C4_GUARDIAN_IND | CHAR(01) | |
| C4_EMERGENCY_FLAG | CHAR(01) | |
| C4_MIL_IND | CHAR(01) | |
| C4_EMAIL | CHAR(64) | |
| C4_ENROLL_PAR_IND | CHAR(01) | |
| C4_TRANSPORT_IND | CHAR(01) | |
| C4_LANG_CD | CHAR(02) | |
| C4_RCV_MAILOUTS | CHAR(01) | |
| C4_CELL_PHONE | CHAR(10) | |
| C4_PHONE_PREF | CHAR(01) | |
| C5_NAME_L | CHAR(25) | |
| C5_NAME_F | CHAR(17) | |
| C5_NAME_M | CHAR(14) | |
| C5_GEN | CHAR(01) | |
| C5_RELAT | CHAR(02) | |
| C5_STR_NBR | CHAR(06) | |
| C5_STR_NAME | CHAR(19) | |
| C5_APT_NBR | CHAR(07) | |
| C5_CITY | CHAR(17) | |
| C5_STATE_CD | CHAR(02) | |
| C5_ZIP | CHAR(05) | |
| C5_ZIP4 | CHAR(04) | |
| C5_PHONE_AREA_CD | CHAR(03) | |
| C5_PHONE_NBR | CHAR(07) | |
| C5_PHONE_AREA_CD_BUS | CHAR(03) | |
| C5_PHONE_NBR_BUS | CHAR(07) | |
| C5_PHONE_EXT_BUS | CHAR(04) | |
| C5_OCCUPATION | CHAR(25) | |
| C5_OTHER_PHONE_AC | CHAR(03) | |
| C5_OTHER_PHONE_NBR | CHAR(07) | |
| C5_OTHER_PHONE_EXT | CHAR(04) | |
| C5_GUARDIAN_IND | CHAR(01) | |
| C5_EMERGENCY_FLAG | CHAR(01) | |
| C5_MIL_IND | CHAR(01) | |
| C5_EMAIL | CHAR(64) | |
| C5_ENROLL_PAR_IND | CHAR(01) | |
| C5_TRANSPORT_IND | CHAR(01) | |
| C5_LANG_CD | CHAR(02) | |
| C5_RCV_MAILOUTS | CHAR(01) | |
| C5_CELL_PHONE | CHAR(10) | |
| C5_PHONE_PREF | CHAR(01) | |
| C6_NAME_L | CHAR(25) | |
| C6_NAME_F | CHAR(17) | |
| C6_NAME_M | CHAR(14) | |
| C6_GEN | CHAR(01) | |
| C6_RELAT | CHAR(02) | |
| C6_STR_NBR | CHAR(06) | |
| C6_STR_NAME | CHAR(19) | |
| C6_APT_NBR | CHAR(07) | |
| C6_CITY | CHAR(17) | |
| C6_STATE_CD | CHAR(02) | |
| C6_ZIP | CHAR(05) | |
| C6_ZIP4 | CHAR(04) | |
| C6_PHONE_AREA_CD | CHAR(03) | |
| C6_PHONE_NBR | CHAR(07) | |
| C6_PHONE_AREA_CD_BUS | CHAR(03) | |
| C6_PHONE_NBR_BUS | CHAR(07) | |
| C6_PHONE_EXT_BUS | CHAR(04) | |
| C6_OCCUPATION | CHAR(25) | |
| C6_OTHER_PHONE_AC | CHAR(03) | |
| C6_OTHER_PHONE_NBR | CHAR(07) | |
| C6_OTHER_PHONE_EXT | CHAR(04) | |
| C6_GUARDIAN_IND | CHAR(01) | |
| C6_EMERGENCY_FLAG | CHAR(01) | |
| C6_MIL_IND | CHAR(01) | |
| C6_EMAIL | CHAR(64) | |
| C6_ENROLL_PAR_IND | CHAR(01) | |
| C6_TRANSPORT_IND | CHAR(01) | |
| C6_LANG_CD | CHAR(02) | |
| C6_RCV_MAILOUTS | CHAR(01) | |
| C6_CELL_PHONE | CHAR(10) | |
| C6_PHONE_PREF | CHAR(01) |
PROCESSING NOTE: For errors that report an invalid or duplicate SSN: If the number is nine digits, the student may have been previously enrolled. In this case the student must be manually re-enrolled through the Online Student Enrollment system in order to use logic that processes historical records.
student/online_registration_import.txt · Last modified: 2018/07/24 13:21 by 127.0.0.1