This is an old revision of the document!
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) |