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.