This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
student:online_registration_import [2017/11/02 13:16] – created jstanford | student:online_registration_import [2018/07/24 13:21] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | Online | + | ======Registration Import |
+ | 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)| | | ||
+ | |EMAIL|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)| | | ||
+ | |||
+ | <WRAP box> |