RUNCTL_JPM_DR(SQL Table) |
Index Back |
---|---|
JPM Supervisor Unload RunCtlJPM Direct Reports Supervisor Unload run control |
# | 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 | JPM_DR_NAV_MTHD | Character(1) | VARCHAR2(1) NOT NULL |
JPM - Direct Reports Supervisor Unload. Determines the Navigation Method to use when determining reporting relationships.
Note: only a subset of the Direct Reports navigation methods are supported for purposes of Unloading to a flat table, as defined by the Translate Values for this field.
2=2 - Supervisor Id 3=3 - Department Manager Id 4=4 - Reports To Position 5=5 - Position / Supervisor Id 6=6 - Position / Dept Manager |
4 | JPM_DR_MODE | Character(1) | VARCHAR2(1) NOT NULL |
JPM Direct Reports Supervisor Unload Mode. Determines whether the process rebuilds the entire JPM_SUPERVISORS table (F)ull, or just updates information for one assignment (I)ncremental.
F=Full - Complete Rebuild I=Incremental - 1 Assignment Default Value: F |
5 | JPM_COMMIT_INTERVL | Number(6,0) | INTEGER NOT NULL |
Commit Interval for batch processes.
Default Value: 1000 |
6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL |
Empl Rcd Nbr
Prompt Table: PER_ORG_ASGN |
8 | JPM_COMMITS_PROC | Number(6,0) | INTEGER NOT NULL | Total Processed |
9 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |