SSR_PRG_NRM_NLD

(SQL Table)
 Index Back

Program Norm Units Type NLD

Sister table of academic program table for the Netherlands /* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */ Added Educational Unit Field /* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */ Added Long Description

  • Related Language Record: SSR_PRG_NRM_LNG

  • Parent record: ACAD_PROG_TBL

    • # 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_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 SSR_PROG_NORM_NLD Character(1) VARCHAR2(1) NOT NULL Program Norm Units Type
    D=Days
    H=Hours
    M=Months
    W=Weeks
    Y=Years
    5 SSR_DESC200_NLD Character(200) VARCHAR2(200) NOT NULL Marketing Description
    6 SSR_LIM_ACC_NLD Character(1) VARCHAR2(1) NOT NULL Limited Access

    Y/N Table Edit

    Default Value: N

    7 SSR_RI_EUN_COD_NLD Character(12) VARCHAR2(12) NOT NULL RIO STAP Educational Unit Code

    Prompt Table: SSR_RI_EDUNTVNL

    8 SSR_DESC3000_NLD Long Character(3000) CLOB /* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */
    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time