| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EP_PMENU_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Menu Level
E=Employee
M=Manager
|
| 2 |
EP_PMENU_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Popup menu application
B=Business Objectives
E=ePerformance
R=Recognition
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 4 |
EP_PMENU_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
Popup Menu Locked status
Y/N Table Edit
|
| 5 |
EP_PMENU_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Popup menu status
A=Assigned
ANY=Any Status
I=Inactive
P=Published
R=Ready to Publish
RR=Recognition Received
RS=Recognition Sent
U=Unassigned
|
| 6 |
EP_PMENU_STEP |
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
ANY=Any Step
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
|
| 7 |
EP_PMENU_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Popup menu type
DC=Document Heading
DL=Document List
DS=Document Step
ID=Item Detail
OB=Objective
OI=Objective Item
PL=Participant List
RC=Comment
RF=Find Person
RP=Post
SB=Subitem
SH=Section Heading
SI=Section Item
|
| 8 |
EP_PMENU_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Popup menu action
|
| 9 |
EP_PMENU_HIDE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Popup menu hide when readonly field
Y/N Table Edit
Default Value: N
|
| 10 |
IMAGE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
The name of images used in Personalizations explanations.
Prompt Table:
EP_PMENU_IMG_VW
|
| 11 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
Prompt Table:
HR_TC_OO_VW
|
| 12 |
HR_SSTEXT_SUB_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID.
For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.
Prompt Table:
HR_SSTEXT_OS_VW
|
| 13 |
TEXT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Text ID
Prompt Table:
HR_SSTEXT_TX_VW
|
| 14 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 15 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
|
| 16 |
EP_PMENU_PACKAGE |
Character(30) |
VARCHAR2(30) NOT NULL |
ePerformance Popup Menu Application Package
Prompt Table:
PSPACKAGROOT_VW
|
| 17 |
EP_PMENU_PATH |
Character(127) |
VARCHAR2(127) NOT NULL |
ePerformance Popup Menu Application Path
Prompt Table:
EP_PMENUPATH_VW
|
| 18 |
EP_PMENU_CLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
ePerformance Popup Menu Class
Prompt Table:
EP_PMENUCLS_VW
|
| 19 |
EP_PMENU_METHOD |
Character(30) |
VARCHAR2(30) NOT NULL |
ePerformance Popup Menu Method
|
| 20 |
SYSTEM_DATA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit
Default Value: N
|