SSR_RI_HCMP_NLD

(SQL View)
 Index Back

Brincd registrations

Registration of Brincode Netherlands for each educational provider (ACAD_ORG)

SELECT DISTINCT A.INSTITUTION ,A.ACAD_ORG ,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 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL

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

    Prompt Table: SCC_BRIN_CD_VW