WCS_EVENT_TBL

(SQL Table)
Index Back

WCS ECM Event Table

This table contains all of the available and supported Event Codes that are used as part of the Compensation Cycle administration and processing.

  • Related Language Record: WCS_EVENT_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WCS_ECM_EVENT_CD Character(3) VARCHAR2(3) NOT NULL WCS ECM Event Code
    2 LABEL Character(15) VARCHAR2(15) NOT NULL This is used to hold an item's description, or label, for display on a Configurable Matrix.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 WCS_ROLE_TARGET_CD Character(3) VARCHAR2(3) NOT NULL WCS Event Role Target Code
    ADM=Administrator
    ALL=All Roles
    APR=Approver
    RVW=Reviewer
    SUB=Submitter
    5 WCS_IMPACT_CD Character(1) VARCHAR2(1) NOT NULL WCS Event Impact Code
    A=Remove All
    C=Create
    R=Remove
    6 WCS_NOD_DIR_CD Character(1) VARCHAR2(1) NOT NULL WCS Node Direction Code
    C=Current Node
    D=Down One Level
    U=Up One Level