HR_EERCDDEL_RES(SQL Table) | 
Index Back | 
|---|---|
ERN ResultsERN Delete Results Table. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 3 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
| 4 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
| 5 | DISPLAY_NAME | Character(50) | VARCHAR2(50) NOT NULL | Used to display the person's name in the PERS_SRCH_SBP, EMPL_SRCH_SBP and the components that allow a person to be created | 
| 6 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date | 
| 7 | RUNSTATUS | Character(2) | VARCHAR2(2) NOT NULL | 
Process Scheduler Process Run Status
 1=Cancel 10=Not Successful 11=Posted 12=Unable to post 13=Resend 14=Posting 15=Content Generated 16=Pending 17=Success With Warning 18=Blocked 19=Restart 2=Delete 3=Error 4=Hold 5=Queued 6=Initiated 7=Processing 8=Cancelled 9=Success  | 
| 8 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |