SSR_STD_N_NL_VW

(SQL View)
 Index Back

Higher Education Program NLD

Registration of Higher Education program data

SELECT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.EFFDT , A.EFFSEQ FROM PS_SSR_STD_PRG_NLD A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_SSR_STD_PRG_NLD A2 WHERE A2.EMPLID = A.EMPLID AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A3.EFFSEQ) FROM PS_SSR_STD_PRG_NLD A3 WHERE A3.EMPLID = A.EMPLID AND A3.ACAD_CAREER = A.ACAD_CAREER AND A3.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A3.EFFDT = A.EFFDT ) UNION SELECT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.EFFDT , A.EFFSEQ FROM PS_ADM_APPL_PROG A WHERE A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ADM_APPL_PROG A2 WHERE A2.EMPLID = A.EMPLID AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A2.ADM_APPL_NBR = A.ADM_APPL_NBR AND A2.APPL_PROG_NBR = A.APPL_PROG_NBR AND A2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_ADM_APPL_PROG A3 WHERE A3.EMPLID = A.EMPLID AND A3.ACAD_CAREER = A.ACAD_CAREER AND A3.STDNT_CAR_NBR = A.STDNT_CAR_NBR AND A3.ADM_APPL_NBR = A.ADM_APPL_NBR AND A3.APPL_PROG_NBR = A.APPL_PROG_NBR AND A3.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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence