SADSTDAPPNLDVW

(SQL View)
Index Back

Higher Ed Stdnt Admission View

Applications record for Higher Education Netherlands

SELECT A.EMPLID ,A.ACAD_CAREER ,A.STDNT_CAR_NBR ,A.ADM_APPL_NBR ,A.APPL_PROG_NBR ,A.SSR_FORM_STUDY_NLD ,A.SSR_ACAD_LEVEL_NLD ,A.SSR_FUNDING_CD_NLD ,A.SCC_BRINCD_NLD ,A.SSR_SL_PROG_CD_NLD ,A.SSR_SL_ACAD_YR_NLD ,A.SSR_SL_FIRSTYR_NLD ,A.SSR_SL_PAYMODE_NLD ,A.SSR_SL_PAIDBY_NLD ,A.SSR_SL_BL_TRMS_NLD ,A.SSR_SL_STATUS_NLD ,A.SSR_SL_DEFSTAT_NLD ,A.SSR_SL_JOBSTAT_NLD ,A.SSR_SL_ACTSTAT_NLD ,A.SSR_SL_DRAWOPT_NLD ,A.SSR_SL_STATLNG_NLD ,A.SSR_SL_IBGSTAT_NLD ,A.SSR_SL_IBGSRSN_NLD ,A.SSR_SL_IBGDEFI_NLD ,A.SSR_SL_TUITAMT_NLD ,A.SSR_SL_TUITIND_NLD ,A.SSR_SL_DRAW_DT_NLD ,A.SSR_SL_DRAWRST_NLD ,A.SSR_SL_DRAWRSN_NLD ,A.SSR_SL_DRAWSEQ_NLD FROM PS_SAD_STD_APP_NLD A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ADM_APPL_PROG A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.ACAD_CAREER = A_ED.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ED.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A_ED.ADM_APPL_NBR AND A.APPL_PROG_NBR = A_ED.APPL_PROG_NBR AND A_ED.EFFDT <= %CurrentDateIn ) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_ADM_APPL_PROG A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.ACAD_CAREER = A_ES.ACAD_CAREER AND A.STDNT_CAR_NBR = A_ES.STDNT_CAR_NBR AND A.ADM_APPL_NBR = A_ES.ADM_APPL_NBR AND A.APPL_PROG_NBR = A_ES.APPL_PROG_NBR AND A.EFFDT = A_ES.EFFDT )

  • 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
    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 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
    7 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
    8 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

    Y/N Table Edit

    9 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
    10 SSR_SL_PROG_CD_NLD Character(5) VARCHAR2(5) NOT NULL Studielink Program Code
    11 SSR_SL_ACAD_YR_NLD Character(4) VARCHAR2(4) NOT NULL Academic Year
    12 SSR_SL_FIRSTYR_NLD Character(1) VARCHAR2(1) NOT NULL Approval Higher Year
    F=False
    T=True
    13 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
    14 SSR_SL_PAIDBY_NLD Character(1) VARCHAR2(1) NOT NULL Paid by
    A=Other
    E=Another Institution
    O=Parents
    X=Already Paid
    Z=Student
    15 SSR_SL_BL_TRMS_NLD Character(1) VARCHAR2(1) NOT NULL Request Payment Terms
    F=False
    T=True
    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 SSR_SL_DEFSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Deficiency Status
    D=Deficient via Institution
    J=Deficient via IBG counter
    N=Not yet determined
    S=Sufficient
    T=Not Deficient via IBG Counter
    V=Provisional IBG
    W=Provisional Institution
    18 SSR_SL_JOBSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Prof Requirements Status
    A=Rejected
    G=Selected/passed
    N=Not Applicable
    O=Open, not yet determined
    19 SSR_SL_ACTSTAT_NLD Character(1) VARCHAR2(1) NOT NULL Professional Duties Status
    A=Rejected
    G=Selected/passed
    N=Not applicable
    O=Open, not yet determined
    20 SSR_SL_DRAWOPT_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Type
    C=Central
    I=Local
    N=None
    S=Selection & Placement
    21 SSR_SL_STATLNG_NLD Character(1) VARCHAR2(1) NOT NULL Language Test Status
    A=Rejected
    G=Selected/passed
    H=Passed
    N=Not applicable
    O=Open, not yet determined
    22 SSR_SL_IBGSTAT_NLD Character(1) VARCHAR2(1) NOT NULL IBG Status
    A=Rejected by RASP
    G=Sent
    N=Not sent
    V=Processed in RASP
    23 SSR_SL_IBGSRSN_NLD Character(1) VARCHAR2(1) NOT NULL IBG Status Reason
    B=Identity not timely verifieD
    C=Transcript too late
    I=Declaration too late
    L=Too often entered in lotterey
    M=Not permitted to enter lottery
    N=Not complied Admin Requisites
    O=Deceased
    P=No placement certificate
    S=Too often selected
    T=Applied after close date
    V=No temp placement certificate
    W=Correspon.nbr changed
    24 SSR_SL_IBGDEFI_NLD Character(1) VARCHAR2(1) NOT NULL IBG Deficiency Status
    25 SSR_SL_TUITAMT_NLD Character(13) VARCHAR2(13) NOT NULL Payment Amount
    26 SSR_SL_TUITIND_NLD Character(1) VARCHAR2(1) NOT NULL Payment Indicator
    F=Not Paid
    O=Undo Previous Payment
    T=Paid
    27 SSR_SL_DRAW_DT_NLD Date(10) DATE Lot Drawing Date
    28 SSR_SL_DRAWRST_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Result
    D=Locally Drawn
    I=Selected
    J=Selected (decentralized)
    M=Locally Not Participated
    N=Locally Not Selected
    O=Conditionally Selected
    S=Locally Selected
    U=Centrally Not Selected
    V=Temp placement certificate
    29 SSR_SL_DRAWRSN_NLD Character(1) VARCHAR2(1) NOT NULL Lot Drawing Result Reason
    D=Several
    H=Hardship Clause
    N=Language Test
    O=Supremacy
    V=Not yet sufficient
    30 SSR_SL_DRAWSEQ_NLD Character(3) VARCHAR2(3) NOT NULL Lot Drawing Number