WCS_CYC_FUND_VW

(SQL View)
 Index Back

Adj Cyc Plan Fund Page View

View used as the search record for the Adjust Cycle Plan Funding Page.

SELECT ACSS.EMPLID , CFG.BUDGET_ID , CFG.BUDGET_START_DT , NSTS.TREE_NODE_NUM , CFG.BUDGET_END_DT , CFG.WCS_CYCLE_STATUS , CFG.DESCR , CFG.DESCR20 , NSTS.TREE_NODE , NSTS.DESCR , CFG.CURRENCY_CD FROM PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_NOD_STS NSTS , PS_WCS_ECM_ACCESS ACSS WHERE CFG.BUDGET_ID = NSTS.BUDGET_ID AND CFG.BUDGET_START_DT = NSTS.BUDGET_START_DT AND NSTS.WCS_DIR_COUNT > 0 AND (CFG.WCS_CYCLE_STATUS = 'BLT' OR CFG.WCS_CYCLE_STATUS = 'CAN') AND ACSS.BUDGET_ID = CFG.BUDGET_ID AND ACSS.BUDGET_START_DT = CFG.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1

  • Related Language Record: WCS_CYC_FND_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget
    3 BUDGET_START_DT Date(10) DATE NOT NULL Budget Start Date
    4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
    5 BUDGET_END_DT Date(10) DATE NOT NULL Budget End Date
    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
    7 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    8 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    9 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL