RUN_CNTL_IDFIELDNAMEVALUE_BEFORE_1VALUE_AFTER_1VALUE_NBR_FROMDefault Value: 0
VALUE_NBR_TODefault Value: 0
RB_STG_TGT_VAL(SQL Table) |
Index Back |
|---|---|
Cache table for Matched IdsThis table stores the From Values from the Staging tables and To Values from the Target tables for Matched Ids. This cache table is used later by Matching to update the matched keys on the staging tables. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 3 | VALUE_BEFORE_1 |
Character(80) | VARCHAR2(80) NOT NULL | Value Before Change |
| 4 | VALUE_AFTER_1 |
Character(80) | VARCHAR2(80) NOT NULL | Value After Change |
| 5 | VALUE_NBR_FROM |
Signed Number(32,0) | DECIMAL(31) NOT NULL |
Value From
Default Value: 0 |
| 6 | VALUE_NBR_TO |
Signed Number(32,0) | DECIMAL(31) NOT NULL |
Value To
Default Value: 0 |