| # |
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 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
%EDITTABLE
|
| 4 |
PERIOD_BEGIN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 5 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
|
| 6 |
EP_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Template unique identifier
Prompt Table:
EP_TMPL_DEFN
|
| 7 |
EP_TEMPLATE_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Source used to determine what templates are available (from job profile)
J=Profile Management
U=User Specified
|
| 8 |
EP_DFLT_TEMPLATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Default template to use
|
| 9 |
EP_MGR_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager Selection Method
1=Department Manager ID
2=SupervisorID
3=ReportsToID
4=GroupID
5=Partial PosnMgmt/DeptMgrID
6=Partial PosnMgmt/SupervisorID
|
| 10 |
ACCESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID
|
| 11 |
EP_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
Prompt Table:
EP_EE_ID_VW
|
| 12 |
EP_SUBDOC |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Employee Document
Y/N Table Edit
Default Value: N
|
| 13 |
EP_SEND_NOTICE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is an indicator as to whether notifications should be sent for each review created by the batch process.
A=All Participants
M=Managers Only
N=No
Default Value: A
|
| 14 |
EP_J_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table:
EP_J_JP_TMPL_I
|
| 15 |
EP_PRCS_MODE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
EE Groups to Process or EE to Process updates or adds values according to this flag the 'EE Group to Process' or 'EE to Process' appears.
1=Group ID
2=Employee ID
Default Value: 1
|
| 16 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|