| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
Prompt Table:
EP_APPR
|
| 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
C=Cascade
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 |
CLOB |
1325 character description field used in ePerformance
|
| 21 |
EP_MEASURE |
Long Character |
CLOB |
1325 Character Item measurement description
|
| 22 |
EP_SUB_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sub-Competency level
Prompt Table:
JPM_EP_SUBLV_I
|
| 23 |
EPO_ITEM_ALIGN |
Number(8,0) |
INTEGER NOT NULL |
Used in ePerformance to specify the Objectives Item that Document Items are Aligned to.
Prompt Table:
EPO_NO_ITEM_VW
|
| 24 |
EP_STRETCH_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section Stretch Goal
Y/N Table Edit
Default Value: N
|
| 25 |
EP_PRIVATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Y/N switch for ePerformance Section. Private, hide from Employees.
Y/N Table Edit
Default Value: N
|
| 26 |
EP_EE_MEASURE |
Long Character |
CLOB |
An additional Measurement field for the ePerformance Section Definition that is not used in the Content Catalog.
|
| 27 |
EP_ITEM_START_DT |
Date(10) |
DATE |
used for ePerformance Section Definition, Item Start Date
|
| 28 |
EP_ITEM_END_DT |
Date(10) |
DATE |
used for ePerformance Section Definition, Item End Date
|
| 29 |
EPO_PAGE_ID |
Number(8,0) |
INTEGER NOT NULL |
Objectives Management: Objective Page ID
|
| 30 |
EPO_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Objectives Section type
|
| 31 |
EPO_OBJ_ITEM_ID |
Number(8,0) |
INTEGER NOT NULL |
Objectives Management: Objective Item ID. Used as a key to hold unique values as Item ID is not a key in Objective Management. It will uniquely define an item on ePerformance document when cascaded or copied over.
|
| 32 |
EPO_SUP_OBJITEM_ID |
Number(8,0) |
INTEGER NOT NULL |
Objectives Supporting Item
|
| 33 |
EPO_OBJ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Objective Status
A=Active Item
I=Inactive Item
|
| 34 |
EPO_ITEM_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Title of an Objective item
|
| 35 |
EP_ITEM_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Objectives field to keep track whether tan item was copied, aligned or cascaded
A=Align Objective
B=Copy Objective
C=Copy Performance Document
D=Cascade Item
N=Non Display Item
P=Performance Item
|
| 36 |
EPO_LAST_MOD_DTTM |
DateTime(26) |
TIMESTAMP |
Datetime stamp of when an Item on an Objective Page was last modified
|
| 37 |
EP_ITEM_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Percentage complete an item is.
|
| 38 |
EP_ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of an Item.
A=Not Applicable
C=Complete
I=In Progress
|
| 39 |
EP_ITEM_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
Objectives field specifying when the Item was added
|
| 40 |
EP_ITEM_ADDED_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
ePerformance field specifying who added the Item
|
| 41 |
EP_ITEM_MOD_DTTM |
DateTime(26) |
TIMESTAMP |
Objectives field specifying when the last time the Item was modified
|
| 42 |
EP_ITEM_MOD_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
ePerformance field specifying who last modified the Item
|
| 43 |
EP_ITEM_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Specifies whether the Item was originally created in the Establish Criteria or Evaluation document.
C=Establish Criteria doc
E=Evaluation document
|
| 44 |
EP_ITEM_MGR_CMNTS |
Long Character |
CLOB |
Track progress document - mgr comments at item level
|
| 45 |
EP_ITEM_EE_CMNTS |
Long Character |
CLOB |
Track progress document - EE comments at item level
|
| 46 |
EP_MGR_NUM_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 47 |
EP_MGR_REVW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 48 |
EP_MGR_REVW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
EP_M_RVW_RTG_VW
|
| 49 |
EP_EE_NUM_RATING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Rating
|
| 50 |
EP_EE_REVW_POINTS |
Number(3,0) |
SMALLINT NOT NULL |
Review Points
|
| 51 |
EP_EE_REVW_RATING |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Rating
Prompt Table:
EP_E_RVW_RTG_VW
|
| 52 |
EP_SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence number
|