HRS_DUPE_PRCS_IDRUN_CNTL_ID10=Search Requested
15=Search In Progress
20=Search Completed
30=Review in Progress
40=Merge In Progress
50=Merge Completed
60=Closed
HRS_DUPE_PRCS(SQL Table) |
Index Back |
|---|---|
Duplicate Find/Merge ProcessDuplicate Find/Merge Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_DUPE_PRCS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Duplicate Process ID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | HRS_DUPE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Duplicate Processing Status
10=Search Requested 15=Search In Progress 20=Search Completed 30=Review in Progress 40=Merge In Progress 50=Merge Completed 60=Closed |
| 4 | HRS_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Row Added DateTime |
| 5 | HRS_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Added Operator Id |
| 6 | HRS_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Row Updated DateTime |
| 7 | HRS_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Updated Operator Id |