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) |