BUDGET_IDBUDGET_START_DTTREE_NODE_NUMVC_PLAN_IDPrompt Table: VC_PLAN_TBL
Prompt Table: CURRENCY_CD_TBL
WCS_ECM_VCND_VW(SQL View) |
Index Back |
|---|---|
Cycle Manual Plan SummaryThis record is used to display the totals for the Manual Funding |
| SELECT N.BUDGET_ID , N.BUDGET_START_DT , N.TREE_NODE_NUM , N.VC_PLAN_ID , N.WCS_TOT_C_COUNT , N.WCS_TOT_C_SALARIES , N.WCS_TOT_C_AMT , N.WCS_TOT_A_AMT , C.CURRENCY_CD FROM PS_WCS_ECM_NOD_VC N , PS_WCS_ECM_CYC_CFG C WHERE N.BUDGET_ID = C.BUDGET_ID AND N.BUDGET_START_DT = C.BUDGET_START_DT AND N.TREE_NODE_NUM = 1 |
| # | 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_C_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Calculated Amount in Node (direct and indirect) |
| 8 | WCS_TOT_A_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Adjusted Amount in Node (direct and indirect) |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |