PROCESS_INSTANCESSR_RI_EPV_COD_NLDSSR_RI_EDU_GOV_NLDSSR_RI_OLO_COD_NLDSSR_RI_MUT_TYP_NLDT=Addition
V=Removal
W=Change
SSR_RI_DLTA_NLD(SQL Table) |
Index Back |
|---|---|
Transaction rec for Delta MsgTransaction rec for Delta Msg |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SSR_RI_EPV_COD_NLD |
Character(12) | VARCHAR2(12) NOT NULL | Educational Provider Code |
| 3 | SSR_RI_EDU_GOV_NLD |
Character(20) | VARCHAR2(20) NOT NULL | Educational Board Code |
| 4 | SSR_RI_OLO_COD_NLD |
Character(12) | VARCHAR2(12) NOT NULL | RIO Establishment ID |
| 5 | SSR_RI_MUT_TYP_NLD |
Character(4) | VARCHAR2(4) NOT NULL |
Mutation Type
T=Addition V=Removal W=Change |
| 6 | SSR_RI_EPIMPDT_NLD | Date(10) | DATE | Ed Provider Last Import Date |
| 7 | SSR_RI_OLIMPDT_NLD | Date(10) | DATE | Ed Location Last Import Date |
| 8 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 9 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 10 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 11 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |