RUNCTL_HR_DR(SQL Table) |
Index Back |
|---|---|
Direct Reports Tbl Bld Run CntRun control for the Direct Reports Table Build process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | HR_DR_ACCESS_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
Direct Reports Table Build. Determines the Access Type Tables to build.
0=All Access Methods 2=2 - Supervisor Id 3=3 - Department Manager ID 4=4 - Reports To Position 5=5 - Position / Supervisor ID 6=6 - Position / Dept Manager Default Value: 0 |
| 4 | HR_DR_UPDT_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Determines whether the process rebuilds the entire direct reports tables or just updates information for those rows that are not current in the direct reports tables.
F=Full - Complete Rebuild I=Incremental - Current Date Upd Default Value: F |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |