WCS_ECM_NOD_SAL

#	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	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
6	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
7	WCS_TOT_C_COUNT	Number(6,0)	INTEGER NOT NULL	Total Calculated Headcount in Node (direct and indirect)
8	WCS_TOT_C_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Salaries in Node (direct and indirect)
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_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Amount 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_P_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Proposed Amount in Node (direct and indirect)
14	WCS_DIR_C_COUNT	Number(6,0)	INTEGER NOT NULL	Total Calculated Direct Reports Headcount in Node
15	WCS_DIR_C_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Calculated Direct Reports Salaries in Node
16	WCS_DIR_A_COUNT	Number(6,0)	INTEGER NOT NULL	Total Adjusted Direct Reports Headcount in Node
17	WCS_DIR_A_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Direct Reports Salaries 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_A_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Adjusted Direct Reports Amount in Node
20	WCS_DIR_P_AMT	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Proposed Direct Reports Amount in Node