| # |
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 |
LM_PRCS_PRE_PRSLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Person Pre-Load Steps
Y/N Table Edit
|
| 4 |
LM_PRCS_PRE_WFLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Workforce Pre-Load Steps
Y/N Table Edit
|
| 5 |
LM_PRCS_PRSLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Person Load
Y/N Table Edit
|
| 6 |
LM_PRCS_WFLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Workforce Load
Y/N Table Edit
|
| 7 |
LM_HR_EMPLID_FROM |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID from the HR System
|
| 8 |
LM_HR_EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EMPLID in the Person/Workforce data loads
|
| 9 |
LM_PRCS_DEL_PRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Person Staging Tables
Y/N Table Edit
|
| 10 |
LM_PRCS_DEL_WF |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Workforce Staging Table
Y/N Table Edit
|
| 11 |
LM_PRCS_DEL_DEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Dept Staging Tables
|
| 12 |
LM_PRCS_DEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Department Load Steps
|
| 13 |
LM_PRCS_PRE_DEPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Department Pre-Load Steps
|
| 14 |
LM_HR_SETID_FROM |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 15 |
LM_HR_SETID_TO |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 16 |
LM_LOAD_STEPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Staging Table
Y/N Table Edit
|
| 17 |
LM_PRE_LOAD_STEPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Validate Staging Tables
Y/N Table Edit
|
| 18 |
LM_DELETE_STEPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Staging Tables
Y/N Table Edit
|
| 19 |
LM_LOAD_STG_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Load Staging Table
|
| 20 |
LM_EIP_AE_PROG |
Character(12) |
VARCHAR2(12) NOT NULL |
EIPs Application Engine Prog
|
| 21 |
LM_EIP_PROC_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the EIP Application Engine Process Name
0=Please Select a Process...
CAT=Catalog Data
CMP=HR Company Data
CST=Cost Acknowledgment
DEP=Organization Data
DIF=DIF Balance
EPH=User Photo
HRS=Training Hour Acknowledgment
INS=Instance Qualifier Data
PIT=Person of Interest Types
PRF=Profile Data
PRP=Persons of Interest Data
PRS=Person Data
PTY=Profile Type
WRK=Workforce Data
Default Value: 0
|