RUNCTL_JPM_DR

(SQL Table)
Index Back

JPM Supervisor Unload RunCtl

JPM 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