User Tools

Site Tools


student:online_registration_import

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
student:online_registration_import [2017/11/02 13:30] jstanfordstudent:online_registration_import [2018/07/24 13:21] (current) – external edit 127.0.0.1
Line 1: Line 1:
-======Online Registration Import======+======Registration Import from Third-Party Lottery System====== 
 +This requires a third-party agreement form...
  
 ^Field^Type and Length^Notes^ ^Field^Type and Length^Notes^
Line 12: Line 13:
 |STATUS_CD|CHAR(01)| | |STATUS_CD|CHAR(01)| |
 |DT_ENTRY|CHAR(08)| | |DT_ENTRY|CHAR(08)| |
-|TATE_STU_ID|CHAR(09)| |+|STATE_STU_ID|CHAR(09)| |
 |ATTRIBUTION_CD|CHAR(02)| | |ATTRIBUTION_CD|CHAR(02)| |
 |CAMPUS_ID_RES|CHAR(09)| | |CAMPUS_ID_RES|CHAR(09)| |
 |ADDR_STR_NBR|CHAR(06)| | |ADDR_STR_NBR|CHAR(06)| |
 |ADDR_STR_NAME|CHAR(19)| | |ADDR_STR_NAME|CHAR(19)| |
-|ADDR_STR_DIR|CHAR(02) Street Direction+|ADDR_STR_DIR|CHAR(02)|Street direction|
 |ADDR_APT_NBR|CHAR(07)| | |ADDR_APT_NBR|CHAR(07)| |
 |ADDR_CITY|CHAR(17)| | |ADDR_CITY|CHAR(17)| |
Line 27: Line 28:
 |STU_PHONE_AC|CHAR(03)| | |STU_PHONE_AC|CHAR(03)| |
 |PHONE_NBR|CHAR(07)| |  |PHONE_NBR|CHAR(07)| | 
-|STR_NBR_PHYS|CHAR(06) Physical Address Fields+|STR_NBR_PHYS|CHAR(06)|Physical address fields|
 |STR_NAME_PHYS|CHAR(19)| |  |STR_NAME_PHYS|CHAR(19)| | 
 |STR_DRCTN_PHYS|CHAR(02)| | |STR_DRCTN_PHYS|CHAR(02)| |
Line 76: Line 77:
 |C1_RCV_MAILOUTS|CHAR(01)| | |C1_RCV_MAILOUTS|CHAR(01)| |
 |C1_CELL_PHONE|CHAR(10)| | |C1_CELL_PHONE|CHAR(10)| |
-|C1_PHONE_PREF|CHAR(01)|| |+|C1_PHONE_PREF|CHAR(01)| |
 |C2_NAME_L|CHAR(25)| | |C2_NAME_L|CHAR(25)| |
 |C2_NAME_F|CHAR(17)| | |C2_NAME_F|CHAR(17)| |
Line 170: Line 171:
 |C4_CELL_PHONE|CHAR(10)| | |C4_CELL_PHONE|CHAR(10)| |
 |C4_PHONE_PREF|CHAR(01)| | |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>**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.</WRAP>
student/online_registration_import.1509629438.txt.gz · Last modified: 2017/11/02 08:30 (external edit)