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 19:05] jstanfordstudent:online_registration_import [2018/07/24 13:21] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======Registration Import from Third-Party Lottery System====== ======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)| |
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> <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.1509649536.txt.gz · Last modified: 2017/11/02 14:05 (external edit)