SAD_CA_PRUID_VW

(SQL View)
 Index Back

Campus Program Load NLD View


SELECT DISTINCT SSR_RIO_PRG_UUID , ACAD_PROG , CAMPUS , ACAD_LOAD_APPR , ACAD_ORG FROM PS_SSR_RIO_PRG_NLD

  • Parent record: SCC_HM_CAMP_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_RIO_PRG_UUID Character(50) VARCHAR2(50) NOT NULL Program UUID
    2 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    3 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Default Value: OPR_DEF_TBL_CS.CAMPUS

    Prompt Table: CAMPUS_TBL

    4 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    5 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL