SAD_SL_31

(SQL Table)
 Index Back

Studielink Msg 31 Stage Table

  • Parent record: SAD_SL_TRNS_INF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_SL_TRANS_INOUT Character(1) VARCHAR2(1) NOT NULL Transaction Direction
    I=Inbound
    O=Outbound
    2 SAD_SL_TRANS_DTTM DateTime(26) TIMESTAMP Transaction DateTime
    3 SAD_SL_TRANS_SEQ Number(3,0) SMALLINT NOT NULL Sequence Number
    4 SAD_SL_INDEX_ID Character(40) VARCHAR2(40) NOT NULL Index ID
    5 SAD_SL_STDLNK_NBR Character(9) VARCHAR2(9) NOT NULL Studielink Number
    6 SAD_SL_NAME_TEXT Character(220) VARCHAR2(220) NOT NULL Merged name
    7 SAD_SL_O_NBR Character(9) VARCHAR2(9) NOT NULL Onumber
    8 SAD_SL_CIOP_NBR Character(12) VARCHAR2(12) NOT NULL Correspondence number
    9 SAD_SL_SOFI_NBR Character(9) VARCHAR2(9) NOT NULL Social Fiscal Number
    10 SAD_SL_STUD_NBR Character(12) VARCHAR2(12) NOT NULL Student Number
    11 SAD_SL_ACTIVITY_DT Character(10) VARCHAR2(10) NOT NULL Activity Date
    12 SAD_SL_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    B=Continuing Application
    G=Cancelled/Withdrawn
    I=Registered/Enrolled
    N=No Re-Enrollment
    R=Rejected/Denied
    S=Study Suspended
    U=Departed
    V=Enrollment Requested
    W=Data Change
    X=Not a Studielink Participant
    13 SAD_SL_PROG_CODE Character(5) VARCHAR2(5) NOT NULL Program Code
    14 SAD_SL_EXT_PROG_CD Character(12) VARCHAR2(12) NOT NULL Alternative programcode
    15 SAD_SL_BRIN_CODE Character(4) VARCHAR2(4) NOT NULL Brincode institution
    16 SAD_SL_ACAD_LOAD Character(1) VARCHAR2(1) NOT NULL Academic load
    1=Full-time
    2=Part-time
    3=Dual
    17 SAD_SL_ACTEDU_CITY Character(24) VARCHAR2(24) NOT NULL City
    18 SAD_SL_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    M=Master
    P=Propaedeutic Phase
    V=Continuation Phase
    19 SAD_SL_ENRL_MANNER Character(1) VARCHAR2(1) NOT NULL Enrolment Manner
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    20 SAD_SL_ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    21 SAD_SL_START_MONTH Character(2) VARCHAR2(2) NOT NULL Start month
    22 SAD_SL_END_DT Character(10) VARCHAR2(10) NOT NULL Preferred End Date
    23 SAD_SL_END_REASON Character(1) VARCHAR2(1) NOT NULL Reason for Ending
    0=Student Suspended
    1=Article 7.42.1a
    2=Article 7.42.1d
    3=Article 7.42.1c
    4=HE and RP 1996
    5=Article 7.42.1b
    6=Post Exam
    8=Death of Student
    9=Article 7.42.1e
    24 SAD_SL_TUITION_RES Character(1) VARCHAR2(1) NOT NULL Request for Refund
    25 SAD_SL_DRAW_RESULT Character(1) VARCHAR2(1) NOT NULL Drawing result
    D=Locally Not Selected
    I=Selected
    J=Locally Selected
    M=Institution Not Participated
    N=Institution Not Selected
    O=Provisional Select
    S=Institution Selected
    U=Central Not Selected
    V=Temporary Selected
    26 SAD_SL_DRAW_SEQ Character(3) VARCHAR2(3) NOT NULL Lot Drawing Number
    27 SAD_SL_RQST_ACPTD Character(1) VARCHAR2(1) NOT NULL Request Granted
    28 SAD_SL_DEFICIENT Character(2) VARCHAR2(2) NOT NULL Deficiency Status
    29 SAD_SL_FIRST_YR Character(1) VARCHAR2(1) NOT NULL First Year
    F=False
    T=True
    30 SAD_SL_NONFIRST_YR Character(1) VARCHAR2(1) NOT NULL First year accepted
    31 SAD_SL_STATJOB_REQ Character(1) VARCHAR2(1) NOT NULL Status Profnl Requirements
    A=Rejected
    G=Selected/Passed
    N=Not Applicable
    O=Open, not yet detrmined
    32 SAD_SL_STATACT_REQ Character(1) VARCHAR2(1) NOT NULL Status Professional Duties
    A=Rejected
    G=Selected/passed
    N=Not applicable
    O=Open, not yet determined
    33 SAD_SL_STATLNG_REQ Character(1) VARCHAR2(1) NOT NULL Language Test
    A=Rejected
    G=Selected/Passed
    H=Passed
    N=Not Applicable
    O=Open, not yet determined
    34 SAD_SL_STUDY_RESLT Character(1) VARCHAR2(1) NOT NULL Study Result
    35 SAD_SL_UP_ACADLOAD Character(1) VARCHAR2(1) NOT NULL Updated Load
    1=Full-time
    2=Part-time
    3=Dual
    36 SAD_SL_UP_CITY Character(24) VARCHAR2(24) NOT NULL Updated City
    37 SAD_SL_UP_ACAD_LVL Character(1) VARCHAR2(1) NOT NULL Updated Academic Level
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    M=Master
    P=Propaedeutic Phase
    V=Continuation Phase
    38 SAD_SL_UP_ENRL_MNR Character(1) VARCHAR2(1) NOT NULL Updated Form of Study
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    39 SAD_SL_UP_STRT_MTH Character(2) VARCHAR2(2) NOT NULL Updated Month from
    40 SAD_SL_SUBINST Character(2) VARCHAR2(2) NOT NULL Sub Institute
    41 SAD_SL_START_OCCSN Character(12) VARCHAR2(12) NOT NULL Start Occasion
    42 SAD_SL_ENRLSQ_NLD Character(20) VARCHAR2(20) NOT NULL Studielink Enroll Seq Nbr
    43 SAD_SL_UP_SUBINST Character(2) VARCHAR2(2) NOT NULL Updated Sub Institute
    44 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    45 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    46 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    47 SAD_SL_ENRSQ_NLD Character(20) VARCHAR2(20) NOT NULL Old Enrollment Seq Nbr
    48 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    49 SAD_SL_DEFICNT_REM Long Character(1000) VARCHAR2(1000) Deficiency Information
    50 SAD_SL_NFRSTYR_REM Long Character(1000) VARCHAR2(1000) Non First Year Info
    51 SAD_SL_JOB_REQ_REM Long Character(1000) VARCHAR2(1000) Job Requirement Info
    52 SAD_SL_ACT_REQ_REM Long Character(1000) VARCHAR2(1000) Activity Reqmnt Info
    53 SAD_SL_LNG_REQ_REM Long Character(1000) VARCHAR2(1000) Language Reqmnt Info
    54 SAD_SL_REMARK50 Long Character(1000) VARCHAR2(1000) Explanation