PROCESS_INSTANCERECNAMESCC_INTGR_ROWNUMA=Add
C=Change
D=Delete
SCC_RESOLVE_LOG(SQL Table) |
Index Back |
|---|---|
Log of discrepancy resolutionsLog of how integration discrepancies were resolved. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | SCC_INTGR_ROWNUM |
Number(10,0) | DECIMAL(10) NOT NULL | Row Number |
| 4 | SCC_RESOLVE_DTM | DateTime(26) | TIMESTAMP | Resolve Date Time |
| 5 | SCC_DATA_SOURCE | Character(30) | VARCHAR2(30) NOT NULL | Data Source |
| 6 | SCC_DISCREP_KEYS | Character(240) | VARCHAR2(240) NOT NULL | Key fields of discrepancies |
| 7 | SCC_RESOLVE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Resolve Action
A=Add C=Change D=Delete |
| 8 | SCC_NONKEY_CHANGES | Long Character | CLOB | Non Key Changes |