SAD_SL_EQN_VW2

(SQL View)
 Index Back

Higher Education Program NLD

Retrieves the current effective dated row from SSR_STD_PRG_NLD. Used for Studielink equations.

SELECT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.ACAD_YEAR , A.EFFDT , A.EFFSEQ , A.SSR_PRG_ACTION_NLD , A.SSR_PRG_STATUS_NLD , A.SSR_FORM_STUDY_NLD , A.SSR_ACAD_LEVEL_NLD , A.SSR_FUNDING_CD_NLD , A.SSR_PROG_UNITS_NLD , A.SSR_PAYMT_FORM_NLD , A.SSR_CONSENT_NLD , A.ACTION_DT , A.SSR_SL_STATUS_NLD , A.SCC_STDY_PRGRS_NLD , A.SSR_PRG_UNITS_NLD , A.SSR_SL_PROG_CD_NLD , A.SCC_BRINCD_NLD , A.SCC_SUBBRINCD_NLD , A.SSR_SL_PAYMODE_NLD , A.SSR_SL_PAIDBY_NLD , A.SSR_SL_BL_TRMS_NLD FROM PS_SSR_STD_PRG_NLD A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_SSR_STD_PRG_NLD B WHERE B.EMPLID = A.EMPLID AND B.ACAD_CAREER=A.ACAD_CAREER AND B.STDNT_CAR_NBR=A.STDNT_CAR_NBR AND B.ACAD_YEAR=A.ACAD_YEAR AND B.EFFDT<= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_SSR_STD_PRG_NLD C WHERE C.EMPLID = A.EMPLID AND C.ACAD_CAREER=A.ACAD_CAREER AND C.STDNT_CAR_NBR=A.STDNT_CAR_NBR AND C.ACAD_YEAR=A.ACAD_YEAR AND C.EFFDT = A.EFFDT )

  • Parent record: STDNT_CAREER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 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

    Prompt Table: STDNT_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

    Prompt Table: TERM_YR1_VW

    5 EFFDT Date(10) DATE NOT NULL Effective Date
    6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    7 SSR_PRG_ACTION_NLD Character(4) VARCHAR2(4) NOT NULL Progr Action Higher Education
    CENR=Change Enrollment
    DATA=Data Change
    DSAC=Departure Accepted
    DSNA=Departure Not Accepted
    ENRL=Enrollment
    EXAM=Examination
    MATR=Matriculation
    NRNR=No Re-Enrollment
    PAYM=Payment
    RENR=Re-Enrollment
    SLCN=Studielink Conversion
    8 SSR_PRG_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Progr Status Higher Education
    E=Enrollment
    R=Result
    9 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    10 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
    A=Associate Degree
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    K=Candidate
    L=University teacher education
    M=Master
    P=Propaedeutic Phase
    Q=Post-Initial
    T=Interim Doctoral Exam
    V=Continuation Phase
    W=Continuing study
    11 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

    Y/N Table Edit

    Default Value: N

    12 SSR_PROG_UNITS_NLD Character(1) VARCHAR2(1) NOT NULL Program Units Apply

    Y/N Table Edit

    Default Value: N

    13 SSR_PAYMT_FORM_NLD Character(3) VARCHAR2(3) NOT NULL Form of Payment
    BNK=Bank
    CHK=Cheque
    CSH=Cash
    GIR=Giro
    GLD=Loan
    INE=2nd Enrl.Other Institution)
    INI=2nd Enrollment
    MCH=Refund Request
    SCH=I Owe You
    VRY=No Payment Necessary
    14 SSR_CONSENT_NLD Character(60) VARCHAR2(60) NOT NULL Authorized for Payment
    15 ACTION_DT Date(10) DATE Action Date

    Default Value: %date

    16 SSR_SL_STATUS_NLD Character(1) VARCHAR2(1) NOT NULL Studielink 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
    X=Not a Studielink Participant
    17 SCC_STDY_PRGRS_NLD Character(1) VARCHAR2(1) NOT NULL Study Progress

    Y/N Table Edit

    Default Value: N

    18 SSR_PRG_UNITS_NLD Number(3,0) SMALLINT NOT NULL Program Units Apply
    19 SSR_SL_PROG_CD_NLD Character(5) VARCHAR2(5) NOT NULL Studielink Program Code
    20 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
    21 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
    22 SSR_SL_PAYMODE_NLD Character(1) VARCHAR2(1) NOT NULL Studielink Form of Payment
    0=Payment Transfer
    1=Auth Printed by Institution
    2=Auth Printed by Student
    3=Foreign Account Number
    4=Other
    5=E-Payment
    6=Electronic Direct Debit
    7=Via Institution
    8=Non SEPA Country
    23 SSR_SL_PAIDBY_NLD Character(1) VARCHAR2(1) NOT NULL Paid by
    A=Other
    E=Another Institution
    O=Parents
    X=Already Paid
    Z=Student
    24 SSR_SL_BL_TRMS_NLD Character(1) VARCHAR2(1) NOT NULL Request Payment Terms
    F=False
    T=True