SCC_TEMP_IDSCC_TRANSAC_CDAN=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_SM_RSLT(SQL Table) |
Index Back |
|---|---|
Search Match Results |
| # | 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 |
| 3 | SEARCH_RULE_NBR | Number(3,0) | SMALLINT NOT NULL | Search Match Rule Number. This field identifies the Search Order for a specific Search Match Rule within the Search Parameters. |
| 4 | SM_NBR_FOUND | Number(5,0) | INTEGER NOT NULL | Search Match Number of ID's found. |
| 5 | 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 |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |