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 | Character(1) | VARCHAR2(1) NOT NULL |
Menu Level
E=Employee M=Manager |
|
2 | Character(1) | VARCHAR2(1) NOT NULL |
Popup menu application
B=Business Objectives E=ePerformance R=Recognition |
|
3 | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
|
4 | Character(1) | VARCHAR2(1) NOT NULL |
Popup Menu Locked status
Y/N Table Edit Default Value: N |
|
5 | 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 | 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 | 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 |