SAD_STD_APNLDVW

(SQL View)
 Index Back

Higher Ed Stdnt Adm NLD vw

Applications view for Higher Education Netherlands

SELECT A.EMPLID , A.ACAD_CAREER ,A.STDNT_CAR_NBR ,A.ADM_APPL_NBR , A.APPL_PROG_NBR , A.EFFDT ,A.EFFSEQ , A.SSR_SL_PAIDBY_NLD ,A.SSR_SL_TUITAMT_NLD , A.SSR_SL_TUITIND_NLD ,A.SSR_SL_PDINST_NLD , A.SSR_SL_PAYMODE_NLD , A.SSR_SL_TUITNBR_NLD ,A.SSR_ACAD_LEVEL_NLD FROM PS_SAD_STD_APP_NLD A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_SAD_STD_APP_NLD B WHERE A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.ADM_APPL_NBR = B.ADM_APPL_NBR AND A.APPL_PROG_NBR = B.APPL_PROG_NBR AND B.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_SAD_STD_APP_NLD D WHERE A.EMPLID = D.EMPLID AND A.ACAD_CAREER = D.ACAD_CAREER AND A.STDNT_CAR_NBR = D.STDNT_CAR_NBR AND A.ADM_APPL_NBR = D.ADM_APPL_NBR AND A.APPL_PROG_NBR = D.APPL_PROG_NBR AND D.EFFDT <= %CurrentDateIn )

  • Parent record: ADM_APP_CAR_SEQ

    • # 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

    Default Value: OPR_DEF_TBL_CS.ACAD_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

    Prompt Table: ADM_APP_CAR_SEQ

    6 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    7 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    8 SSR_SL_PAIDBY_NLD Character(1) VARCHAR2(1) NOT NULL Paid by
    A=Other
    E=Another Institution
    O=Parents
    X=Already Paid
    Z=Student
    9 SSR_SL_TUITAMT_NLD Character(13) VARCHAR2(13) NOT NULL Payment Amount
    10 SSR_SL_TUITIND_NLD Character(1) VARCHAR2(1) NOT NULL Payment Indicator
    F=Not Paid
    O=Undo Previous Payment
    T=Paid
    11 SSR_SL_PDINST_NLD Character(4) VARCHAR2(4) NOT NULL Paid at Brincode
    12 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
    13 SSR_SL_TUITNBR_NLD Character(2) VARCHAR2(2) NOT NULL Number of Payments
    14 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