| # |
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 Rcd Nbr
|
| 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 |
Review Template Effective Date
|
| 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=Available for Review
CA=Cancelled
CO=Completed
IP=In Progress
NS=Not Started
RH=Review Held
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=Approval Before EE Review Held
02=Approval After EE Review Held
03=No Approval, EE Review Held
04=No Approval, No EE Review Held
05=Approval, No EE Review Held
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 |
PTAFDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Definition ID
Prompt Table:
EP_PTAFAW_PRCS
|
| 49 |
EP_PRE_REVW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Preliminary Review Rating Code (character).
Prompt Table:
REVW_RATING_TBL
|
| 50 |
EP_PRE_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Preliminary Rating (numeric)
|
| 51 |
EP_PRE_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Preliminary Rating Points
|
| 52 |
EP_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 53 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 54 |
REVIEW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 55 |
EP_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation method used - Summary, Average, Review Band
A=Average
R=Review Band
S=Summation
|
| 56 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
|
| 57 |
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
|
| 58 |
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
|
| 59 |
EP_EMPL_ACK_DT |
Date(10) |
DATE |
This field tracks the date that the employee acknowledged that a review has been held.
|
| 60 |
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
|
| 61 |
EP_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
|
| 62 |
EP_CREATE_DTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time a document was created.
|
| 63 |
EP_CREATE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which created a document.
|