SSR_BR_INDEX_IDSSR_BR_MSGUUIDSSR_RIO_PRG_UUIDSSR_RI_OPR_ST_DTSSR_RI_OPP_NLD(SQL Table) |
Index Back |
|---|---|
staging table (off. Progr per)staging table (off. Progr. period) /* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */ Added SSR_RI_DSC3000_NLD |
| # | 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_RIO_PRG_UUID |
Character(50) | VARCHAR2(50) NOT NULL | Program UUID |
| 5 | SSR_RI_OPR_ST_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 6 | SSR_RI_DSC225_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description |
| 7 | SSR_RI_DSC225E_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description Language(ENG) |
| 8 | SSR_RI_DSC3000_NLD | Long Character(3000) | CLOB | /* 2022-10-13: fix for Bug-ID: 34695718 - RIOv4 */ |