BUDGET_IDBUDGET_START_DTTREE_NODE_NUMVC_PLAN_IDPrompt Table: VC_PLAN_TBL
Prompt Table: CURRENCY_CD_TBL
WCS_ECM_SLND_VW(SQL View) |
Index Back |
|---|
| SELECT SAL.BUDGET_ID , SAL.BUDGET_START_DT , SAL.TREE_NODE_NUM , VC.VC_PLAN_ID , SAL.WCS_TOT_C_COUNT , SAL.WCS_TOT_C_SALARIES , SAL.WCS_TOT_A_AMT , CFG.CURRENCY_CD FROM PS_WCS_ECM_NOD_SAL SAL , PS_WCS_ECM_CYC_CFG CFG , PS_WCS_ECM_NOD_VC VC WHERE SAL.BUDGET_ID = CFG.BUDGET_ID AND SAL.BUDGET_START_DT = CFG.BUDGET_START_DT AND SAL.TREE_NODE_NUM = 1 AND SAL.BUDGET_ID = VC.BUDGET_ID AND SAL.BUDGET_START_DT = VC.BUDGET_START_DT AND SAL.TREE_NODE_NUM = VC.TREE_NODE_NUM |
| # | 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 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 5 | WCS_TOT_C_COUNT | Number(6,0) | INTEGER NOT NULL | Total Calculated Headcount in Node (direct and indirect) |
| 6 | WCS_TOT_C_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Calculated Salaries in Node (direct and indirect) |
| 7 | WCS_TOT_A_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Adjusted Amount in Node (direct and indirect) |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |