BUDGET_IDBUDGET_START_DTTREE_NODE_NUMSEQNUMVC_PLAN_IDPrompt Table: VC_PLAN_TBL
C=Cash
N=Non-Cash
S=Stock
WCS_NOD_SUM_VW(SQL View) |
Index Back |
|---|---|
Cycle Node SummaryView contains union of WCS_ECM_NOD_SAL and WCS_ECM_NOD_VC tables, used in the approvals page for each group's summary values. |
| SELECT SAL.BUDGET_ID , SAL.BUDGET_START_DT , SAL.TREE_NODE_NUM , SAL.SEQNUM , ' ' , ' ' , SAL.TREE_NODE_NUM_END , SAL.TREE_LEVEL_NUM , SAL.WCS_TOT_A_COUNT , SAL.WCS_TOT_A_SALARIES , SAL.WCS_TOT_C_SALARIES , SAL.WCS_TOT_A_AMT , SAL.WCS_TOT_C_AMT , SAL.WCS_TOT_P_AMT FROM PS_WCS_ECM_NOD_SAL SAL UNION SELECT NOD.BUDGET_ID , NOD.BUDGET_START_DT , NOD.TREE_NODE_NUM , 0 , NOD.VC_PLAN_ID , CYC.WCS_VC_TYPE , NOD.TREE_NODE_NUM_END , NOD.TREE_LEVEL_NUM , NOD.WCS_TOT_A_COUNT , NOD.WCS_TOT_A_SALARIES , NOD.WCS_TOT_C_SALARIES , NOD.WCS_TOT_A_AMT , NOD.WCS_TOT_C_AMT , NOD.WCS_TOT_P_AMT FROM PS_WCS_ECM_NOD_VC NOD , PS_WCS_ECM_CYC_VC CYC WHERE NOD.BUDGET_ID = CYC.BUDGET_ID AND NOD.BUDGET_START_DT = CYC.BUDGET_START_DT AND NOD.VC_PLAN_ID = CYC.VC_PLAN_ID |
| # | 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 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | VC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL |
VC Plan ID
Prompt Table: VC_PLAN_TBL |
| 6 | WCS_VC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Variable Compensation Type
C=Cash N=Non-Cash S=Stock |
| 7 | TREE_NODE_NUM_END | Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 8 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 9 | WCS_TOT_A_COUNT | Number(6,0) | INTEGER NOT NULL | Total Adjusted Headcount in Node (direct and indirect) |
| 10 | WCS_TOT_A_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Adjusted Salaries in Node (direct and indirect) |
| 11 | WCS_TOT_C_SALARIES | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Calculated Salaries in Node (direct and indirect) |
| 12 | WCS_TOT_A_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Adjusted Amount in Node (direct and indirect) |
| 13 | WCS_TOT_C_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Calculated Amount in Node (direct and indirect) |
| 14 | WCS_TOT_P_AMT | Number(22,6) | DECIMAL(21,6) NOT NULL | Total Proposed Amount in Node (direct and indirect) |