EP_PMENU_DEFN

(SQL Table)
Index Back

ePerformance Fluid Popup Menu

Popup menu definition for fluid ePerformance

  • Related Language Record: EP_PMENU_DFN_LN
  • Parent record: EP_PMENU_LVL
  • # 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