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 This is an old revision of the document!
Online Registration Import
| 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) | |
| TATE_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) |
student/online_registration_import.1509629629.txt.gz · Last modified: 2017/11/02 08:33 (external edit)