SSR_RI_EUP_NLD(SQL Table) |
Index Back |
---|---|
Edu Unit Period Staging Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_BR_INDEX_ID | Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
2 | SSR_BR_MSGUUID | Character(50) | VARCHAR2(50) NOT NULL | Message ID |
3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
4 | SSR_RI_EUN_COD_NLD | Character(12) | VARCHAR2(12) NOT NULL | RIO STAP Educational Unit Code |
5 | SSR_RI_EUN_ST_DT | Date(10) | DATE | RIO STAP Educational Unit Start Date |
6 | SSR_RI_EDU_SNM_NLD | Character(30) | VARCHAR2(30) NOT NULL | Edu unit short name |
7 | SSR_RI_DSC225_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description |
8 | SSR_RI_DSC225E_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description Language(ENG) |
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 | ACAD_PROG | Character(5) | VARCHAR2(5) NOT NULL | Academic Program |