| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
EP_REVW_TYP_VW
|
| 2 |
EP_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Template unique identifier
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 5 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 6 |
EP_TMPL_USE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Product Flag used to distingush between HR Basic templates and ePerformance templates.
B=Basic HR
E=ePerformance
Default Value: E
|
| 7 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N
|
| 8 |
TABSET_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Tab Identifier ID
|
| 9 |
EP_DISPLAY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Control Display Type of Document whether in Long Page Format or Tab Format
LONG=Long Format Only
TABS=Tabs Format Only
TOGL=Toggle - Default Long
TOGT=Toggle - Default Tabs
Default Value: LONG
|
| 10 |
EP_REVIEW_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Review ID
Prompt Table:
EP_REV_DEF_VW
|
| 11 |
EP_ROUNDING_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine how the review rating will be rounded to the maximum decimal point.
D=Round Down
S=Standard Rounding
U=Round Up
Default Value: S
|
| 12 |
EP_DEC_PLACES |
Number(1,0) |
SMALLINT NOT NULL |
Amount of decimal places to take a numeric value out to
|
| 13 |
EP_RATE_MODEL_MAP |
Character(1) |
VARCHAR2(1) NOT NULL |
Mapping used to determine the rating text to display
H=Next Highest Rating
L=Next Lowest Rating
N=Nearest Rating
Default Value: N
|
| 14 |
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
|
| 15 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
EP_APPR_RULE_VW
|
| 16 |
EP_EE_REVIEW_FLG |
Character(2) |
VARCHAR2(2) NOT NULL |
Field used to determine the process flow for a performance review.
01=Apvl Before Review-5 Steps
02=Apvl After Review-4 Steps
03=No Apvl with Review-4 Steps
04=No Apvl No Review
05=Apvl No Review
06=No Apvl with Review-2 Steps
07=Apvl Before Review-3 Steps
08=Apvl After Review-3 Steps
Default Value: 01
|
| 17 |
EP_CALC_RATING_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if a performance review calculates ratings.
Y/N Table Edit
Default Value: Y
|
| 18 |
EP_LANG_CHECK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the language checker is used on the manager's performance review.
Y/N Table Edit
Default Value: N
|
| 19 |
EP_EST_STEP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if the establish criteria step is enabled.
Y/N Table Edit
Default Value: N
|
| 20 |
EP_EST_UPD_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can update the baseline document during the establish criteria step.
Y/N Table Edit
Default Value: N
|
| 21 |
EP_EST_UPD_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can update the baseline document during the establish criteria step.
Y/N Table Edit
Default Value: N
|
| 22 |
EP_EST_CMP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role that determines if an employee or manager can complete the baseline document during the establish criteria step.
Prompt Table:
EP_ROLE_VW1
|
| 23 |
EP_EST_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Amount of days in which the establish criteria step is due.
|
| 24 |
EP_EST_DUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of due date - Before or After the period end date.
Used for the establish criteria step.
A=After Period End Date
B=Before Period End Date
|
| 25 |
EP_NOM_STEP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if the nomination process is enabled.
Y/N Table Edit
Default Value: N
|
| 26 |
EP_NOM_UPD_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can update the nominations list during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 27 |
EP_NOM_UPD_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can update the nominations list during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 28 |
EP_NOM_SUB_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role that determines if an employee or manager can submit nominations document during the nominate participant process.
Prompt Table:
EP_ROLE_VW1
|
| 29 |
EP_NOM_TRK_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can track the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 30 |
EP_NOM_TRK_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can track the nomination acceptance/denial/cancellation during the nominate participants process.
Y/N Table Edit
Default Value: N
|
| 31 |
EP_NOM_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Amount of days in which the nominate participants process is due.
|
| 32 |
EP_NOM_DUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of due date - Before or After the period end date.
Used for the nominate participants process.
A=After Period End Date
B=Before Period End Date
|
| 33 |
EP_TRK_FDBK_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can track participant feedback during the track participant feedback process.
Y/N Table Edit
Default Value: N
|
| 34 |
EP_TRK_FDBK_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can track participant feedback during the track participant feedback process.
Y/N Table Edit
Default Value: N
|
| 35 |
EP_TRK_VIEW_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if an employee can view participant documents during the track participant feedback process.
Y/N Table Edit
Default Value: N
|
| 36 |
EP_TRK_VIEW_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if a manager can view participant documents during the track participant feedback process.
Y/N Table Edit
Default Value: N
|
| 37 |
EP_VIEW_AVG_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
ePerformance flag
Y/N Table Edit
Default Value: N
|
| 38 |
EP_VIEW_AVG_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
ePerformance Flag
Y/N Table Edit
Default Value: N
|
| 39 |
EP_CANCEL_OUT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch that determines if outstanding evaluations and nominations are cancelled when the manager evaluation moves past 'in progress' status.
Y/N Table Edit
Default Value: N
|
| 40 |
EOAWDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table:
EP_PTAFAW_PRCS
|
| 41 |
EP_ATTACH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachment Switch
Y/N Table Edit
Default Value: N
|
| 42 |
EP_TP_STEP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Template header switch on General Tab specifying whether or not Track Progresss step is available
Y/N Table Edit
Default Value: N
|
| 43 |
EP_DUE_DATE_MTHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Method
C=Performance Calendar
T=Template Setup
Default Value: T
|
| 44 |
EP_CALENDAR_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Calendar id
Prompt Table:
EP_CALENDAR
|
| 45 |
EP_PERIOD_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
This field stores the Period specified for a Calendar ID.
Prompt Table:
EP_CAL_PERIOD
|
| 46 |
EP_TP_UPD_BY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Template switch on Process Tab specifying which roles can update the Track Progress appraisals
B=Manager and Employee
M=Manager
Default Value: M
|
| 47 |
EP_TP_EE_CMNTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Template switch on Process Tab specifying whether the Employee role has comments enabled.
Y/N Table Edit
Default Value: N
|
| 48 |
EP_TP_NBR_CHECKPTS |
Number(2,0) |
SMALLINT NOT NULL |
The Number of Checkpoints defined for the Track Progress step.
|
| 49 |
EP_TP_COMP_BY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Template switch on Process Tab specifying which role completes the Track Progress checkpoints
B=Manager and Employee
E=Employee
M=Manager
Default Value: M
|
| 50 |
EP_TP_DUE_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Track Progress completion date in days
|
| 51 |
EP_TP_DUE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Track Progress completion date type
Before or After the period end date.
A=After Period End Date
B=Before Period End Date
Default Value: B
|
| 52 |
EP_CPY_RTGS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Track Progress Ratings to Evaluations?
Y/N Table Edit
Default Value: N
|
| 53 |
EP_CPY_CMNTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Track Progress Comments to Evaluations?
Y/N Table Edit
Default Value: N
|
| 54 |
EP_SAVE_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Establish Criteria document when approved?
Y/N Table Edit
Default Value: Y
|
| 55 |
EP_SAVE_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Save the Completed Track Progress document?
Y/N Table Edit
Default Value: Y
|
| 56 |
EP_SAVE_CHKPTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Template process tab, whether or not checkpoint docs are stored
Y/N Table Edit
Default Value: Y
|
| 57 |
EP_TITLE_FORMAT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Field specifying whether or not to concatenate the Sub-Step onto the Step in the Page Title of the document
Y/N Table Edit
Default Value: Y
|
| 58 |
EP_EE_ATTACH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachment Switch on the Template to allow employees to add/remove attachments in the self-evaluation document
Y/N Table Edit
Default Value: N
|
| 59 |
EP_EE_VIEW_NOM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch on the Template to allow employees to view nominees before nomination is submitted
Y/N Table Edit
Default Value: Y
|
| 60 |
EP_EE_DEL_NOM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch on the Template to allow employees to view/delete nominees before nomination is submitted
Y/N Table Edit
Default Value: Y
|
| 61 |
EP_PARTIC_EARLY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Participant Evaluation at any step during the appraisal cycle.
Y/N Table Edit
Default Value: N
|
| 62 |
EP_MIN_CHAR_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Count of minimum characters required in comments fields.
Default Value: 0
|
| 63 |
EP_NOM_SUB_BOTH_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Use in fluid documents only: Used to allow both manager and employee roles to submit nominations during the nominate participant process.
Y/N Table Edit
Default Value: N
|
| 64 |
EP_DC_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Define Criteria Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 65 |
EP_CP_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkpoint Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 66 |
EP_FC_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Finalize Criteria Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 67 |
EP_MGR_RECOG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Manager to View Recognitions
Y/N Table Edit
Default Value: N
|
| 68 |
EP_EE_RECOG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Manager to View Recognitions
Y/N Table Edit
Default Value: N
|
| 69 |
EP_VIEW_INSTR_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
View Instructions
D=Display on Document Page
M=Display in Modal Window
Default Value: M
|