WCS_CYC_FND_LVW

(SQL View)
 Index Back

Adj Cyc Plan Fund Page Lng VW

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

SELECT ACSS.EMPLID , CFGL.BUDGET_ID , CFGL.BUDGET_START_DT , NSL.TREE_NODE_NUM , CFGL.LANGUAGE_CD , CFGL.DESCR , CFGL.DESCR20 , NSL.DESCR FROM PS_WCS_CYC_CFG_LNG CFGL , PS_WCS_NOD_STS_LNG NSL , PS_WCS_ECM_ACCESS ACSS WHERE CFGL.BUDGET_ID = NSL.BUDGET_ID AND CFGL.BUDGET_START_DT = NSL.BUDGET_START_DT AND ACSS.BUDGET_ID = CFGL.BUDGET_ID AND ACSS.BUDGET_START_DT = CFGL.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1 AND CFGL.LANGUAGE_CD = NSL.LANGUAGE_CD UNION SELECT ACSS.EMPLID , CFGL.BUDGET_ID , CFGL.BUDGET_START_DT , NSL.TREE_NODE_NUM , CFGL.LANGUAGE_CD , CFGL.DESCR , CFGL.DESCR20 , NSL.DESCR FROM PS_WCS_CYC_CFG_LNG CFGL , PS_WCS_NOD_STS_LNG NSL , PS_WCS_ECM_ACCESS ACSS WHERE CFGL.BUDGET_ID = NSL.BUDGET_ID AND CFGL.BUDGET_START_DT = NSL.BUDGET_START_DT AND ACSS.BUDGET_ID = CFGL.BUDGET_ID AND ACSS.BUDGET_START_DT = CFGL.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1 UNION SELECT ACSS.EMPLID , CFGL.BUDGET_ID , CFGL.BUDGET_START_DT , NSL.TREE_NODE_NUM , NSL.LANGUAGE_CD , CFGL.DESCR , CFGL.DESCR20 , NSL.DESCR FROM PS_WCS_CYC_CFG_LNG CFGL , PS_WCS_NOD_STS_LNG NSL , PS_WCS_ECM_ACCESS ACSS WHERE CFGL.BUDGET_ID = NSL.BUDGET_ID AND CFGL.BUDGET_START_DT = NSL.BUDGET_START_DT AND ACSS.BUDGET_ID = CFGL.BUDGET_ID AND ACSS.BUDGET_START_DT = CFGL.BUDGET_START_DT AND ACSS.WCS_SP_ACCESS_TYPE = 'C' AND ACSS.TREE_NODE_NUM = 1

  • Related Language Record for WCS_CYC_FUND_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    7 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description