SSR_RI_OPRS_NLD

(SQL Table)
Index Back

Snapshot Tbl (base off. Progr)

/* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_RIO_PRG_UUID Character(50) VARCHAR2(50) NOT NULL Program UUID
3 SSR_RI_EPV_COD_NLD Character(12) VARCHAR2(12) NOT NULL Educational Provider Code
4 SSR_RI_OLO_COD_NLD Character(12) VARCHAR2(12) NOT NULL RIO Establishment ID
5 BEGIN_DT Date(10) DATE Begin Date
6 SSR_RI_FRST_DT_NLD Date(10) DATE First Inflow Date
7 END_DT Date(10) DATE end date
8 SSR_BR_CAREER_NLD Character(3) VARCHAR2(3) NOT NULL 15-04-2020 changes for bug 30723216
BBL=BBL
BLT=BBL_DT
BOL=BOL
BOT=BOL_DT
CBL=CBL
CBT=CBL_DT
CLD=COL_DT
COL=COL
EX=EX
ODT=ODT
OVO=Other Education
9 SSR_RI_EDU_GOV_NLD Character(20) VARCHAR2(20) NOT NULL Educational Board Code
10 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
11 SSR_RI_ADM_REQ_NLD Character(1) VARCHAR2(1) NOT NULL Admissions requirements
12 SSR_RI_LIM_ACC_NLD Character(1) VARCHAR2(1) NOT NULL Limited Access
13 SSR_RI_EDU_REG_NLD Character(8) VARCHAR2(8) NOT NULL Educational Register
14 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
15 SSR_RI_EUN_COD_NLD Character(12) VARCHAR2(12) NOT NULL RIO STAP Educational Unit Code
16 SSR_RI_PRG_NRM_NLD Character(1) VARCHAR2(1) NOT NULL Program Norm Units Type /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Additional translate value J.
D=Days
H=Hours
J=Years
M=Months
W=Weeks
Y=Years
17 SSR_RI_PRN_CMP_NLD Number(3,0) SMALLINT NOT NULL IPEDS Normal Completion