| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
|
| 2 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 3 |
EP_REVW_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Review description
|
| 4 |
EP_REVW_DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Review short description
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
EP_DOC_USAGE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator used to determine what document types are available for performance assessments and which are available for development assessments.
D=Development
P=Performance
Default Value: P
|
| 7 |
EP_INITIATE_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can initiate the document process.
Y/N Table Edit
Default Value: N
|
| 8 |
EP_INITIATE_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can initiate the document process.
Y/N Table Edit
Default Value: N
|
| 9 |
EP_CLONE_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Clone process - Employee
Y/N Table Edit
Default Value: N
|
| 10 |
EP_CLONE_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Manager can Clone
Y/N Table Edit
Default Value: N
|
| 11 |
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
Default Value: U
|
| 12 |
EP_DFLT_TEMPLATE |
Character(8) |
VARCHAR2(8) NOT NULL |
Default template to use
Prompt Table:
EP_TMPL_DEFN
|
| 13 |
EP_J_JP_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific field for Profile Type
Prompt Table:
EP_J_JP_TMPL_I
|
| 14 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
EP_APPR_RULE_VW
|
| 15 |
PTAFDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Definition ID
Prompt Table:
EP_PTAFAW_PRCS
|
| 16 |
EP_EE_ELECT_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee can Select Manager
Y/N Table Edit
Default Value: N
|
| 17 |
EP_OFFICIAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This Yes/No switch can be set to "Y" by the user to denote that the review is "Official". The setting of this field has no real significance in the application, it is primarily a user-controlled informational field.
Y/N Table Edit
Default Value: N
|
| 18 |
EP_HISTORY_ONLY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag is used on the ePerformance Management Review Type Table to indicate that this Review Type was upgraded from the customer's legacy Employee_Review" data. The system turns this switch on automatically at upgrade time, and these review Types are considered to be "frozen", unless the customer inserts a new effective-dated row to "re-activate" the Review Type so that it can be used in ePerformance Management.
Y/N Table Edit
Default Value: N
|