| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
EPO_OBJ_PLAN |
Character(8) |
VARCHAR2(8) NOT NULL |
Objectives Management: Objective Plan ID field
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 6 |
EPO_NODE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Objectives Management. Used to store the Node ID associated with the Objective Plan
|
| 7 |
EP_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Section type
|
| 8 |
EP_ITEM_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Item unique identifier
|
| 9 |
EP_SUB_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Sub-Item unique identifier
|
| 10 |
EPO_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cascade Run Type - Preview or Confirm
C=Confirm Cascade Items
P=Preview Cascade Items
|
| 11 |
EPO_PAGE_ID |
Number(8,0) |
INTEGER NOT NULL |
Objectives Management: Objective Page ID
|
| 12 |
EPO_CASC_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cascade Items to roles
Y/N Table Edit
Default Value: N
|
| 13 |
EP_J_ITEM_CAT_TYPE |
Character(12) |
VARCHAR2(12) NOT NULL |
ePerformance specific version of the JPM Catalog Type field.
|
| 14 |
EPO_SECTION_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Objectives Section type
|
| 15 |
EP_APPRAISAL_ID |
Number(8,0) |
INTEGER NOT NULL |
Document ID
|
| 16 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 17 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 18 |
PERIOD_BEGIN_DT |
Date(10) |
DATE NOT NULL |
Period Begin Date
|
| 19 |
PERIOD_END_DT |
Date(10) |
DATE NOT NULL |
Period End Date
|
| 20 |
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
|
| 21 |
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
|
| 22 |
EP_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Manager/Mentor ID.
Prompt Table:
PERSON
|
| 23 |
EPO_DR_FND |
Character(1) |
VARCHAR2(1) NOT NULL |
Direct Report Found flag
|
| 24 |
EPO_CASC_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cascade document processes
|
| 25 |
EP_ITEM_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Item sequence number
|
| 26 |
MESSAGE_TEXT40 |
Character(40) |
VARCHAR2(40) NOT NULL |
Message Text
|
| 27 |
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
|
| 28 |
EP_NEW_MANAGER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
New Manager/Mentor ID. Used when transferring ownership of a document to another manager.
Prompt Table:
PERSON
|
| 29 |
EP_REVIEW_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Review type
|
| 30 |
EPO_CASC_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Cascade Levels - All or One level
A=All Levels
O=One Level
|
| 31 |
IF_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
If flag
|
| 32 |
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.
|
| 33 |
EP_TITLE |
Character(60) |
VARCHAR2(60) NOT NULL |
Title of an item
|
| 34 |
EP_ITEM_OVRWRT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Item existing in document should be overwritten by Cascade process or not.
|
| 35 |
EPO_ITEM_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Objectives Item sequence number
|
| 36 |
EPO_OBJ_SUBITEM_ID |
Number(8,0) |
INTEGER NOT NULL |
Objectives Management: Object Sub Item ID. Used as a key to hold Sub Item ID values because Sub Item ID is not a key and its value will be copied over to SubItem ID of ePerformance document which will be unique.
|
| 37 |
EP_SUB_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Sub-Item sequence number
|
| 38 |
REPORT_DEFN_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Report Name (see PSXPRPTDEFN).
|
| 39 |
TMPLDEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template ID (see PSXPTMPLDEFN).
|
| 40 |
EPO_NOTIF_CASC_EE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for cascade objective items.
|
| 41 |
EPO_NOTIF_CASC_MGR |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification for cascade objective items.
|
| 42 |
EPO_ALLOW_CASCADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Manager to Cascade Items
|
| 43 |
EPO_NOTIF_CASC_ADM |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to confgure e-mail notification to Admin for cascade of objective items by a manager.
|
| 44 |
PORTAL_LINK_URL |
Long Character |
CLOB |
Link Definition
|
| 45 |
EPO_SEQ_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Objective Item sequence number
|
| 46 |
EP_ALL_ITEMS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if all items use the same Rating Model
|
| 47 |
EP_SECTION_RTD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No switch used to determine if the section can be rated
|
| 48 |
RATING_MODEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Rating Model
|
| 49 |
EP_ITEM_PROMPT |
Character(15) |
VARCHAR2(15) NOT NULL |
Prompt table used to populate an item
|
| 50 |
EP_J_CONTENT_GROUP |
Character(12) |
VARCHAR2(12) NOT NULL |
Content Group
|
| 51 |
EP_J_CONTENT_GRP_T |
Character(15) |
VARCHAR2(15) NOT NULL |
Content Group Type
|
| 52 |
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
|
| 53 |
EP_DESCR254 |
Long Character |
CLOB |
1325 character description field used in ePerformance
|
| 54 |
EP_MEASURE |
Long Character |
CLOB |
1325 Character Item measurement description
|
| 55 |
EP_DESCRLONG |
Long Character |
CLOB |
Long description field used in ePerformance.
|
| 56 |
EPO_PORTAL_LNK_URL |
Long Character |
CLOB |
Link Definition
|
| 57 |
EPO_MGR_LNK_URL |
Long Character |
CLOB |
Link Definition
|