SSR_RI_CMPL_NLD

(SQL View)
 Index Back

Home Campus Organizations NLD

Registration of Campus, academic program and Brincode Netherlands

SELECT DISTINCT A.INSTITUTION ,A.CAMPUS ,A.SCC_BRINCD_NLD FROM PS_SCC_HM_CAMP_NLD A WHERE A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_SCC_HM_CAMP_NLD A_ED WHERE A.INSTITUTION = A_ED.INSTITUTION AND A.ACAD_PROG = A_ED.ACAD_PROG AND A.CAMPUS = A_ED.CAMPUS AND A_ED.EFFDT <= %CurrentDateIn )

  • Parent record: ACAD_PROG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    3 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode

    Prompt Table: SCC_BRIN_CD_VW