EP_PMENU_DEFN(SQL Table) |
Index Back |
---|---|
ePerformance Fluid Popup MenuPopup menu definition for fluid ePerformance |
# | 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 NOT NULL |
Effective Date
Default Value: %date |
4 | EP_PMENU_LOCKED | Character(1) | VARCHAR2(1) NOT NULL |
Popup Menu Locked status
Y/N Table Edit Default Value: N |
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 Default Value: ANY |
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 Default Value: ANY |
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 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
9 | 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 |