| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
PERIOD_BEGIN_DT |
Date(10) |
DATE NOT NULL |
Period Begin Date
|
| 5 |
PERIOD_END_DT |
Date(10) |
DATE NOT NULL |
Period End Date
|
| 6 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
Prompt Table:
EP_REVW_TYP_VW
|
| 7 |
EP_TEMPLATE_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Template unique identifier
Prompt Table:
EP_TMPL_DEFN
|
| 8 |
EP_TMPL_EFFDT |
Date(10) |
DATE NOT NULL |
the effdt of the Template
|
| 9 |
CREATION_DT |
Date(10) |
DATE NOT NULL |
Creation Date
Default Value: %Date
|
| 10 |
EP_EST_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the establish criteria step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
Default Value: NA
|
| 11 |
EP_EST_DUE_DATE |
Date(10) |
DATE |
Date the establish criteria step is due to be completed.
|
| 12 |
EP_NOM_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the nominate participants step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
Default Value: NA
|
| 13 |
EP_NOM_DUE_DATE |
Date(10) |
DATE |
Date the nominate participants step is due to be completed.
|
| 14 |
EP_TRK_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the track participants step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
Default Value: NA
|
| 15 |
EP_PRT_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
Translate field that determines the state (status) of the review participants feedback step.
CO=Completed
IP=In Progress
NA=Not Applicable
NS=Not Started
Default Value: NA
|
| 16 |
EP_REVIEW_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
This field tracks the status of a review document through it's life cycle. This is separate from the approval status of the review, which is tracked separately.
AK=Acknowledged
AR=Shared with Employee
CA=Canceled
CO=Completed
EC=Define Criteria
IP=Evaluation in Progress
NS=Not Started
PA=Approval
RH=Pending Acknowledgement
TP=Track Progress
Default Value: IP
|
| 17 |
EP_APPROVAL_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
This field tracks the current approval status of a review. This is separate from the review's lifecycle status, which is tracked separately.
APRV=Approved
DENY=Denied
ERRO=Approval Error
NREQ=Not Required
OPEN=Not Submitted
SUBM=Submitted
Default Value: OPEN
|
| 18 |
EP_REVIEW_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Review ID
Prompt Table:
EP_REV_DEF_VW
|
| 19 |
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
|
| 20 |
EP_DEC_PLACES |
Number(1,0) |
SMALLINT NOT NULL |
Amount of decimal places to take a numeric value out to
|
| 21 |
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
|
| 22 |
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
|
| 23 |
APPR_RULE_SET |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Rule Set
Prompt Table:
EP_APPR_RULE_VW
|
| 24 |
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
|
| 25 |
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
|
| 26 |
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
|
| 27 |
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
|
| 28 |
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
|
| 29 |
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
|
| 30 |
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
|
| 31 |
EP_EST_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Amount of days in which the establish criteria step is due.
|
| 32 |
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
|
| 33 |
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
|
| 34 |
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
|
| 35 |
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
|
| 36 |
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
|
| 37 |
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
|
| 38 |
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
|
| 39 |
EP_NOM_DUE_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Amount of days in which the nominate participants process is due.
|
| 40 |
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
|
| 41 |
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
|
| 42 |
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
|
| 43 |
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
|
| 44 |
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
|
| 45 |
EP_VIEW_AVG_EE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
ePerformance flag
Y/N Table Edit
Default Value: N
|
| 46 |
EP_VIEW_AVG_MGR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
ePerformance Flag
Y/N Table Edit
Default Value: N
|
| 47 |
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
|
| 48 |
EOAWDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval Framework Definition ID
Prompt Table:
EP_PTAFAW_PRCS
|
| 49 |
EP_ATTACH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Attachment Switch
Y/N Table Edit
Default Value: N
|
| 50 |
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
|
| 51 |
EP_DUE_DATE_MTHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date Method
C=Performance Calendar
T=Template Setup
Default Value: T
|
| 52 |
EP_CALENDAR_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Calendar id
Prompt Table:
EP_CALENDAR
|
| 53 |
EP_PERIOD_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
This field stores the Period specified for a Calendar ID.
Prompt Table:
EP_CAL_PERIOD
|
| 54 |
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
|
| 55 |
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
|
| 56 |
EP_TP_NBR_CHECKPTS |
Number(2,0) |
SMALLINT NOT NULL |
The Number of Checkpoints defined for the Track Progress step.
|
| 57 |
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
|
| 58 |
EP_TP_DUE_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
Track Progress completion date in days
|
| 59 |
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
|
| 60 |
EP_CPY_RTGS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Track Progress Ratings to Evaluations?
Y/N Table Edit
Default Value: N
|
| 61 |
EP_CPY_CMNTS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Track Progress Comments to Evaluations?
Y/N Table Edit
Default Value: N
|
| 62 |
EP_SAVE_EC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Save Establish Criteria document when approved?
Y/N Table Edit
Default Value: Y
|
| 63 |
EP_SAVE_TP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Save the Completed Track Progress document?
Y/N Table Edit
Default Value: Y
|
| 64 |
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
|
| 65 |
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
|
| 66 |
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
|
| 67 |
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
|
| 68 |
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
|
| 69 |
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
|
| 70 |
EP_MIN_CHAR_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Count of minimum characters required in comments fields.
Default Value: 0
|
| 71 |
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
|
| 72 |
EP_DC_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Define Criteria Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 73 |
EP_CP_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkpoint Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 74 |
EP_FC_ATTACH |
Character(1) |
VARCHAR2(1) NOT NULL |
Finalize Criteria Attachment
B=Manager and Employee
E=Employee
M=Manager
|
| 75 |
EP_MGR_RECOG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Manager to View Recognitions
Y/N Table Edit
Default Value: N
|
| 76 |
EP_EE_RECOG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Manager to View Recognitions
Y/N Table Edit
Default Value: N
|
| 77 |
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
|
| 78 |
EP_PRE_REVW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Preliminary Review Rating Code (character).
Prompt Table:
REVW_RATING_TBL
|
| 79 |
EP_PRE_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Preliminary Rating (numeric)
|
| 80 |
EP_PRE_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Preliminary Rating Points
|
| 81 |
EP_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 82 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 83 |
REVIEW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 84 |
EP_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
|
| 85 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
|
| 86 |
EP_RTG_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the calculated Rating for this item or section has been manually overridden by the user.
Y/N Table Edit
Default Value: N
|
| 87 |
EP_EMPL_ACK_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
This field tracks whether an employee has acknowledged that a review has been held. Note that it does not indicate whether the employee agrees with the content of the review.
ACKN=Employee Acknowledged
NREQ=Not Required
OPEN=Open
OVRD=Manager Override
RFSD=Employee Refused
|
| 88 |
EP_EMPL_ACK_DT |
Date(10) |
DATE |
This field tracks the date that the employee acknowledged that a review has been held.
|
| 89 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 90 |
EP_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
|
| 91 |
EP_CREATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time a document was created.
|
| 92 |
EP_CREATE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which created a document.
|
| 93 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 94 |
EOAWORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 95 |
EOAWREQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|
| 96 |
ORIGINATORID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator Identifier
|