WCS_ORG_SUM_VW (SQL View)	Index Back
Group Summary Tables View View contains union of WCS_ECM_NOD_SAL and WCS_ECM_NOD_VC tables, used in the Organization Summay Grid on the WCS_ECM_MSS_SUM page.

WCS_ORG_SUM_VW

(SQL View)

Group Summary Tables View

View contains union of WCS_ECM_NOD_SAL and WCS_ECM_NOD_VC tables, used in the Organization Summay Grid on the WCS_ECM_MSS_SUM page.

SELECT BUDGET_ID , BUDGET_START_DT , TREE_NODE_NUM , SEQNUM , ' ' , TREE_NODE_NUM_END , TREE_LEVEL_NUM , WCS_TOT_A_COUNT , WCS_TOT_A_SALARIES , WCS_TOT_C_SALARIES , WCS_TOT_A_AMT , WCS_TOT_C_AMT , WCS_TOT_P_AMT , WCS_DIR_A_COUNT , WCS_DIR_A_SALARIES , WCS_DIR_C_SALARIES , WCS_DIR_A_AMT , WCS_DIR_C_AMT , WCS_DIR_P_AMT FROM PS_WCS_ECM_NOD_SAL UNION SELECT BUDGET_ID , BUDGET_START_DT , TREE_NODE_NUM , 0 , VC_PLAN_ID , TREE_NODE_NUM_END , TREE_LEVEL_NUM , WCS_TOT_A_COUNT , WCS_TOT_A_SALARIES , WCS_TOT_C_SALARIES , WCS_TOT_A_AMT , WCS_TOT_C_AMT , WCS_TOT_P_AMT , WCS_DIR_A_COUNT , WCS_DIR_A_SALARIES , WCS_DIR_C_SALARIES , WCS_DIR_A_AMT , WCS_DIR_C_AMT , WCS_DIR_P_AMT FROM PS_WCS_ECM_NOD_VC

# 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 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number

7 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

8 WCS_TOT_A_COUNT Number(6,0) INTEGER NOT NULL Total Adjusted Headcount in Node (direct and indirect)

9 WCS_TOT_A_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Adjusted Salaries in Node (direct and indirect)

10 WCS_TOT_C_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Calculated Salaries in Node (direct and indirect)

11 WCS_TOT_A_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Adjusted Amount in Node (direct and indirect)

12 WCS_TOT_C_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Calculated Amount in Node (direct and indirect)

13 WCS_TOT_P_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Proposed Amount in Node (direct and indirect)

14 WCS_DIR_A_COUNT Number(6,0) INTEGER NOT NULL Total Adjusted Direct Reports Headcount in Node

15 WCS_DIR_A_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Adjusted Direct Reports Salaries in Node

16 WCS_DIR_C_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Calculated Direct Reports Salaries in Node

17 WCS_DIR_A_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Adjusted Direct Reports Amount in Node

18 WCS_DIR_C_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Calculated Direct Reports Amount in Node

19 WCS_DIR_P_AMT Number(22,6) DECIMAL(21,6) NOT NULL Total Proposed Direct Reports Amount in Node

#	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	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
7	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
8	WCS_TOT_A_COUNT	Number(6,0)	INTEGER NOT NULL	Total Adjusted Headcount in Node (direct and indirect)
9	WCS_TOT_A_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Salaries in Node (direct and indirect)
10	WCS_TOT_C_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Salaries in Node (direct and indirect)
11	WCS_TOT_A_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Amount in Node (direct and indirect)
12	WCS_TOT_C_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Amount in Node (direct and indirect)
13	WCS_TOT_P_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Proposed Amount in Node (direct and indirect)
14	WCS_DIR_A_COUNT	Number(6,0)	INTEGER NOT NULL	Total Adjusted Direct Reports Headcount in Node
15	WCS_DIR_A_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Direct Reports Salaries in Node
16	WCS_DIR_C_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Direct Reports Salaries in Node
17	WCS_DIR_A_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Direct Reports Amount in Node
18	WCS_DIR_C_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Direct Reports Amount in Node
19	WCS_DIR_P_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Proposed Direct Reports Amount in Node