WCS_ECM_ACSS_VW

(SQL View)
 Index Back

Cycle Comp Admin Access Roles

Gets access role rows for compensation administrators where the cycle status is built, canceled, or open.

SELECT STS.BUDGET_ID , STS.BUDGET_START_DT , CFG.BUDGET_END_DT , CFG.DESCR , CFG.DESCR20 , CFG.WCS_CYCLE_STATUS , ACSS.TREE_NODE_NUM FROM PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_NOD_STS STS , PS_WCS_ECM_ACCESS ACSS WHERE CFG.BUDGET_ID = STS.BUDGET_ID AND CFG.BUDGET_START_DT = STS.BUDGET_START_DT AND CFG.BUDGET_ID = ACSS.BUDGET_ID AND CFG.BUDGET_START_DT = ACSS.BUDGET_START_DT AND STS.TREE_NODE_NUM = ACSS.TREE_NODE_NUM AND CFG.WCS_CYCLE_STATUS IN ('BLT' ,'OPN') AND ACSS.TREE_NODE_NUM = 1 AND ACSS.WCS_SP_ACCESS_TYPE = 'C'

  • Related Language Record: WCS_ECM_ACSS_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    2 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
    3 BUDGET_END_DT Date(10) DATE Budget End Date
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    6 WCS_CYCLE_STATUS Character(3) VARCHAR2(3) NOT NULL Cycle Status
    BIP=Build In Progress
    BLT=Built
    CAN=Canceled
    DEF=Defined
    FIN=Closed
    OPN=Opened

    Default Value: DEF

    7 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number