| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_ES_PREPROC_KEY |
Character(1) |
VARCHAR2(1) NOT NULL |
Elastic Search Pre-process Key
|
| 2 |
SSR_ES_PREPROC_BLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Elastic Search Pre-process Key
|
| 3 |
SSR_ES_PREPROC_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Elastic Search Pre-process Key
|
| 4 |
SSR_ES_PREPROC_STA |
Character(1) |
VARCHAR2(1) NOT NULL |
Elastic Search Pre-process Key
|
| 5 |
SSR_COUNTER |
Number(9,0) |
DECIMAL(9) NOT NULL |
This field is used by the view to create the SR enrollment cubes
|
| 6 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 7 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 8 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 9 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|