| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
Prompt Table:
EP_APPR
|
| 2 |
EP_ROLE |
Character(8) |
VARCHAR2(8) NOT NULL |
Role unique identifier
Prompt Table:
EP_ROLE_TBL
|
| 3 |
EP_REVIEWER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Reviewer ID
Prompt Table:
EP_REVWR_ID_VW
|
| 4 |
EP_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Section type
Prompt Table:
EP_SECTION_DEFN
|
| 5 |
EP_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Item unique identifier
Prompt Table:
%EDITTABLE
|
| 6 |
EP_ITEM_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Item sequence number
Default Value: 1
|
| 7 |
EP_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Title of an item
|
| 8 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table:
RATING_MDL_TBL
|
| 9 |
EP_MIN_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Minumum weight used (percentage)
|
| 10 |
EP_WEIGHT |
Number(3,0) |
SMALLINT NOT NULL |
Weight factor
|
| 11 |
EP_ITEM_DUE_DT |
Date(10) |
DATE |
Date that an item is due.
|
| 12 |
EP_ITEM_REMIND_DT |
Date(10) |
DATE |
Date to remind an item is due.
|
| 13 |
EP_ITEM_MANDTRY_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the mandatory field is available
Y/N Table Edit
Default Value: N
|
| 14 |
EP_ITEM_CRIT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the critical field is available
Y/N Table Edit
Default Value: N
|
| 15 |
EP_ITEM_LINK |
Character(12) |
VARCHAR2(12) NOT NULL |
Field an item is linked to
Prompt Table:
EP_TMPL_ITEM
|
| 16 |
EP_ITEM_OWNER_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Translate field used to indicate the owner of a performance review item.
E=Employee
M=Manager
|
| 17 |
EP_TARGET_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Target Rating Field
Prompt Table:
REVW_RATING_TBL
|
| 18 |
EP_ROW_ADDED_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Added By Source
P=Profile
R=HR Admin (Profile)
T=HR Admin (Template)
U=User
|
| 19 |
EP_ROW_ADDED_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Added By ID
|
| 20 |
EP_DESCR254 |
Long Character(1325) |
VARCHAR2(1325) |
1325 character description field used in ePerformance
|
| 21 |
EP_MEASURE |
Long Character(1325) |
VARCHAR2(1325) |
1325 Character Item measurement description
|
| 22 |
EP_ITEM_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Percentage complete an item is.
|
| 23 |
EP_ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of an Item.
A=Not Applicable
C=Complete
I=In Progress
|
| 24 |
EP_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 25 |
REVIEW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 26 |
REVIEW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
REVW_RATING_TBL
|
| 27 |
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
|
| 28 |
EP_RESULTS |
Long Character |
CLOB |
Results statement
|