SAD_SL_SEL_PG_V

(SQL View)
 Index Back

Selection & Placement Programs


SELECT A.CIP_CODE , A.SCC_BRINCD_NLD , A.ACADEMIC_LOAD , A.ACAD_YEAR ,C.ACAD_PROG ,C.DESCR ,C.DESCRSHORT ,A.SAD_SL_PROG_LD_STA ,A.SAD_SL_PROC_SELECT FROM PS_SAD_SL_SEL_PROG A JOIN PS_CIP_CODE_TBL B ON A.CIP_CODE = B.CIP_CODE JOIN PS_ACAD_PROG_TBL C ON A.CIP_CODE = C.CIP_CODE WHERE B.EFFDT = ( SELECT MAX(F.EFFDT) FROM PS_CIP_CODE_TBL F WHERE F.CIP_CODE=B.CIP_CODE AND F.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(G.EFFDT) FROM PS_ACAD_PROG_TBL G WHERE G.INSTITUTION=C.INSTITUTION AND G.CIP_CODE=C.CIP_CODE AND G.EFFDT <= %CurrentDateIn) AND A.SCC_BRINCD_NLD IN ( SELECT HM.SCC_BRINCD_NLD FROM PS_SCC_HM_CAMP_NLD HM WHERE HM.EFFDT = ( SELECT MAX(HM1.EFFDT) FROM PS_SCC_HM_CAMP_NLD HM1 WHERE HM1.CAMPUS = HM.CAMPUS AND HM1.ACAD_PROG = HM.ACAD_PROG AND HM.EFFDT <= %CurrentDateIn)) AND A.ACADEMIC_LOAD IN ( SELECT ACAD_LOAD_APPR FROM PS_SCC_CMPLOAD_NLD SCC WHERE SCC.EFFDT = ( SELECT MAX(SCC1.EFFDT) FROM PS_SCC_CMPLOAD_NLD SCC1 WHERE SCC1.CAMPUS = SCC.CAMPUS AND SCC1.ACAD_PROG = SCC.ACAD_PROG AND SCC.EFFDT <= %CurrentDateIn))

  • Parent record: SAD_SL_TRNS_INF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

    Prompt Table: CIP_CODE_TBL

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

    Prompt Table: SCC_BRINCD_NLD

    3 ACADEMIC_LOAD Character(1) VARCHAR2(1) NOT NULL Academic Load
    F=Enrolled Full-Time
    H=Enrolled Half-Time
    L=Less than Half-Time
    N=No Unit Load
    P=Enrolled Part-Time
    T=Three Quarter Time
    4 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year

    Prompt Table: ACAD_YEAR_MC_VW

    5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 SAD_SL_PROG_LD_STA Character(1) VARCHAR2(1) NOT NULL Studielink Program Load Status
    N=New
    P=In Progress
    S=Sent
    9 SAD_SL_PROC_SELECT Character(1) VARCHAR2(1) NOT NULL Select to Process
    N=No
    Y=Yes