SAD_SL_31_VW1

(SQL View)
Index Back

Studielink Msg 31 Stage View

This view eliminates SAD_SL_STDLNK_NBR as a key, and just takes the maximum one. This is ok because for this purpose, it will always return one row anyway. Used for Studielink equations.

SELECT MAX(A.SAD_SL_TRANS_INOUT) ,MAX(A.SAD_SL_TRANS_DTTM) ,MAX(A.SAD_SL_TRANS_SEQ) ,MAX(A.SAD_SL_INDEX_ID) ,MAX(A.SAD_SL_STDLNK_NBR) ,MAX(A.SAD_SL_NAME_TEXT) ,MAX(A.SAD_SL_O_NBR) ,MAX(A.SAD_SL_CIOP_NBR) ,MAX(A.SAD_SL_SOFI_NBR) ,MAX(A.SAD_SL_STUD_NBR) ,MAX(A.SAD_SL_ACTIVITY_DT) ,MAX(A.SAD_SL_STATUS) ,MAX(A.SAD_SL_PROG_CODE) ,MAX(A.SAD_SL_EXT_PROG_CD) ,MAX(A.SAD_SL_BRIN_CODE) ,MAX(A.SAD_SL_ACAD_LOAD) ,MAX(A.SAD_SL_ACTEDU_CITY) ,MAX(A.SAD_SL_ACAD_LEVEL) ,MAX(A.SAD_SL_ENRL_MANNER) ,MAX(A.SAD_SL_ACAD_YEAR) ,MAX(A.SAD_SL_START_MONTH) ,MAX(A.SAD_SL_END_DT) ,MAX(A.SAD_SL_END_REASON) ,MAX(A.SAD_SL_TUITION_RES) ,MAX(A.SAD_SL_DRAW_RESULT) ,MAX(A.SAD_SL_DRAW_SEQ) ,MAX(A.SAD_SL_RQST_ACPTD) ,MAX(A.SAD_SL_DEFICIENT) ,MAX(A.SAD_SL_FIRST_YR) ,MAX(A.SAD_SL_NONFIRST_YR) ,MAX(A.SAD_SL_STATJOB_REQ) ,MAX(A.SAD_SL_STATACT_REQ) ,MAX(A.SAD_SL_STATLNG_REQ) ,MAX(A.SAD_SL_STUDY_RESLT) ,MAX(A.SAD_SL_UP_ACADLOAD) ,MAX(A.SAD_SL_UP_CITY) ,MAX(A.SAD_SL_UP_ACAD_LVL) ,MAX(A.SAD_SL_UP_ENRL_MNR) ,MAX(A.SAD_SL_UP_STRT_MTH) ,MAX(A.SAD_SL_SUBINST) ,MAX(A.SAD_SL_START_OCCSN) ,MAX(A.SAD_SL_UP_SUBINST) FROM PS_SAD_SL_31 A WHERE A.SAD_SL_STDLNK_NBR = ( SELECT MAX(B.SAD_SL_STDLNK_NBR) FROM PS_SAD_SL_31 B WHERE B.SAD_SL_TRANS_INOUT = A.SAD_SL_TRANS_INOUT AND B.SAD_SL_TRANS_DTTM = A.SAD_SL_TRANS_DTTM AND B.SAD_SL_TRANS_SEQ = A.SAD_SL_TRANS_SEQ AND B.SAD_SL_INDEX_ID = A.SAD_SL_INDEX_ID ) GROUP BY A.SAD_SL_TRANS_INOUT ,A.SAD_SL_TRANS_DTTM ,A.SAD_SL_TRANS_SEQ, A.SAD_SL_INDEX_ID

  • 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_UP_SUBINST Character(2) VARCHAR2(2) NOT NULL Updated Sub Institute