| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
|
| 2 |
EP_DUEDATE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field stores the various phases of a document for which due dates can be stored in a Performance Calendar.
1=Approve Criteria
2=Checkpoint Due
3=Finalize Criteria
4=Nomination Due
5=Evaluation Due
|
| 3 |
EP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role unique identifier
|
| 4 |
EP_CHKPT_NBR |
Number(2,0) |
SMALLINT NOT NULL |
the number of the checkpoint during the track progress step
|
| 5 |
EP_REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
|
| 6 |
EP_DUE_DATE |
Date(10) |
DATE |
Due Date used for Due Date notifications
|
| 7 |
EP_CREATED_DATE |
DateTime(26) |
TIMESTAMP |
Date when schedule file data was created.
Used for Due Date notifications
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 9 |
EP_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
|
| 10 |
PERIOD_END_DT |
Date(10) |
DATE |
Period End Date
|
| 11 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
|
| 12 |
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
|
| 13 |
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
|