SCC_TEMP_IDSCC_TRANSAC_CDPrompt Table: SCC_TRN_SCTY_VW
AN=Add New ID
CN=Cancelled
LD=Loaded
SA=New ID Created
SI=Ignore
SS=Suspended
SU=ID Updated
UE=Update ID
VE=Error
SCC_SL_PURG_BND(SQL View) |
Index Back |
|---|---|
Pop Select Bind Record - PurgeThis table is the bind record for Pop Select and the Purge Process. |
| SELECT SCC_TEMP_ID , SCC_TRANSAC_CD , SCC_STG_STATUS , SCC_STG_STS_DT FROM PS_SCC_STG_CONSTIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_TEMP_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Temp Constituent ID |
| 2 | SCC_TRANSAC_CD |
Character(25) | VARCHAR2(25) NOT NULL |
Transaction
Prompt Table: SCC_TRN_SCTY_VW |
| 3 | SCC_STG_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Staging Status
AN=Add New ID CN=Cancelled LD=Loaded SA=New ID Created SI=Ignore SS=Suspended SU=ID Updated UE=Update ID VE=Error |
| 4 | SCC_STG_STS_DT | Date(10) | DATE | SnL Staging Status Date |