SSR_RI_EDUNT_NL

(SQL Table)
 Index Back

Edu Unit

/* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */ Added SSR_RI_CAT_NLD

  • Related Language Record: SSR_RI_EDUNTLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 SSR_RI_EUN_COD_NLD Character(12) VARCHAR2(12) NOT NULL RIO STAP Educational Unit Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR200 Character(254) VARCHAR2(254) NOT NULL Long Description
    7 SSR_RI_DOCTP_NLD Character(4) VARCHAR2(4) NOT NULL Document type
    CERT=CERTIFICAAT
    DIPL=DIPLOMA
    NONE=GEEN_OFFICIEEL_DOCUMENT
    SADV=SCHOOLADVIES
    TSTM=GETUIGSCHRIFT
    8 SSR_BR_LVL_NLD Character(1) VARCHAR2(1) NOT NULL /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Additional translate value U.
    1=MBO-1
    2=MBO-2
    3=MBO-3
    4=MBO-4
    U=Undetermined
    9 SSR_RI_LD_UNT_NLD Character(4) VARCHAR2(4) NOT NULL RIO STAP Academic Load Unit
    CTHR=Contact hours
    ECTS=ECTS
    HOUR=Hours
    SBU=Study load hours
    STPT=Study points
    10 SSR_RI_LOAD_NLD Number(5,0) INTEGER NOT NULL RIO STAP Academic Study Load
    11 SSR_RI_EQF_NLD Character(2) VARCHAR2(2) NOT NULL RIO STAP European Qualification Framework
    1=1
    2=2
    3=3
    4=4
    5=5
    6=6
    7=7
    8=8
    12 SSR_RI_NLQF_NLD Character(2) VARCHAR2(2) NOT NULL RIO STAP NLD Qualification Framework
    1=1
    2=2
    3=3
    4=4
    4P=4p
    5=5
    6=6
    7=7
    8=8
    13 SSR_RI_CAT_NLD Character(4) VARCHAR2(4) NOT NULL /* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */
    BDPR=BEDRIJFS_PROJECTONDERSTEUNING
    ECON=ECONOMIE
    GDMY=GEDRAG_EN_MAATSCHAPPIJ
    GZSP=GEZONDHEID_ZORG_EN_SPORT
    HBVT=HOBBY_EN_VRIJE_TIJD
    LVNO=LANDBW_VOEDSEL_EN_NAT_OMGEVING
    MNPR=MANAGEMENT_EN_PROJECTMNGT
    NATR=NATUUR
    ONDW=ONDERWIJS
    RCHT=RECHT
    SCTO=SECTOROVERSTIJGEND
    TECH=TECHNIEK_EN_ICT
    THRC=TOERISME_HORECA_EN_RECREATIE
    TLCL=TAAL_EN_CULTUUR
    TRLG=TRANSPORT_EN_LOGISTIEK
    VLDF=VEILIGHEID_EN_DEFENSIE
    14 DESCRLONG Long Character CLOB Long Description
    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time