SSR_STD_C_NL_VW

(SQL View)
 Index Back

Higher Education Program NLD

Registration of Higher Education program data

SELECT DISTINCT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.EFFDT , A.EFFSEQ , B.ACAD_PROG , A.SSR_SL_PROG_CD_NLD , A.SCC_BRINCD_NLD , A.SCC_SUBBRINCD_NLD , C1.ACAD_PLAN FROM PS_SSR_STD_PRG_NLD A , PS_ACAD_PROG B , PS_ACAD_PLAN C1 WHERE A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.EMPLID = C1.EMPLID AND A.ACAD_CAREER = C1.ACAD_CAREER AND A.STDNT_CAR_NBR = C1.STDNT_CAR_NBR AND C1.EFFDT = B.EFFDT AND C1.EFFSEQ = B.EFFSEQ AND 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 ) AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ACAD_PROG B1 WHERE B.EMPLID = B1.EMPLID AND B.ACAD_CAREER = B1.ACAD_CAREER AND B.STDNT_CAR_NBR = B1.STDNT_CAR_NBR AND B1.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(B2.EFFSEQ) FROM PS_ACAD_PROG B2 WHERE B2.EMPLID = B.EMPLID AND B2.ACAD_CAREER = B.ACAD_CAREER AND B2.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND B2.EFFDT = B.EFFDT ) UNION SELECT DISTINCT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.EFFDT , A.EFFSEQ , A.ACAD_PROG , %Substring(B.HEGIS_CODE, 1,5) , D.SCC_BRINCD_NLD , D.SCC_SUBBRINCD_NLD , C1.ACAD_PLAN FROM PS_ADM_APPL_PROG A , PS_ACAD_PROG_TBL B , PS_ADM_APPL_PLAN C1 , PS_SAD_STD_APP_NLD D WHERE A.EMPLID = C1.EMPLID AND A.ACAD_CAREER = C1.ACAD_CAREER AND A.STDNT_CAR_NBR = C1.STDNT_CAR_NBR AND A.ADM_APPL_NBR = C1.ADM_APPL_NBR AND A.APPL_PROG_NBR = C1.APPL_PROG_NBR AND C1.EFFDT = A.EFFDT AND C1.EFFSEQ = A.EFFSEQ AND 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 C1.EFFDT = D.EFFDT AND C1.EFFSEQ = D.EFFSEQ AND A.INSTITUTION = B.INSTITUTION AND A.ACAD_PROG = B.ACAD_PROG AND 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(A3.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 ) AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ACAD_PROG_TBL B1 WHERE B.INSTITUTION = B1.INSTITUTION AND B.ACAD_PROG = B1.ACAD_PROG AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS ='A'

  • 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
    6 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    7 SSR_SL_PROG_CD_NLD Character(5) VARCHAR2(5) NOT NULL Studielink Program Code

    Prompt Table: CIP_CODE_TBL

    8 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

    Prompt Table: SCC_BRINCD_NLD

    9 SCC_SUBBRINCD_NLD Character(2) VARCHAR2(2) NOT NULL Sub Institute
    10 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan