WCS_ECM_NOD_STS (SQL Table)	Index Back
Main Node Record Parent Node Record WCS. All groups roll up to this record.

WCS_ECM_NOD_STS

(SQL Table)

Main Node Record

Parent Node Record WCS. All groups roll up to this record.

Related Language Record: WCS_NOD_STS_LNG

Parent Record Of WCS_ECM_ACCESS WCS_ECM_NOD_SAL WCS_ECM_NOD_VC WCS_UNQ_NODE_VW

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

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

6 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 WCS_NODE_STATUS Character(3) VARCHAR2(3) NOT NULL Node Status
CLC=Calculated
CME=Completed with Errors
CMP=Completed
CNF=Confirmed
INP=In Progress
PSB=Pushed Back
RTL=Ready to Load
SUB=Submitted

9 WCS_STATUS_DTTM DateTime(26) TIMESTAMP Status Date/Time Stamp

10 WCS_TOT_COUNT Number(6,0) INTEGER NOT NULL Total Employees in Node (direct and indirect)

11 WCS_TOT_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Employee Salaries in Node (direct and indirect)

12 WCS_DIR_COUNT Number(6,0) INTEGER NOT NULL Total Direct Reports in Node

13 WCS_DIR_SALARIES Number(22,6) DECIMAL(21,6) NOT NULL Total Direct Reports Salaries in Node

14 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

15 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	TREE_NODE_NUM_END	Number(10,0)	DECIMAL(10) NOT NULL	Internal ending node range number
5	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
6	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	WCS_NODE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Node Status CLC=Calculated CME=Completed with Errors CMP=Completed CNF=Confirmed INP=In Progress PSB=Pushed Back RTL=Ready to Load SUB=Submitted
9	WCS_STATUS_DTTM	DateTime(26)	TIMESTAMP	Status Date/Time Stamp
10	WCS_TOT_COUNT	Number(6,0)	INTEGER NOT NULL	Total Employees in Node (direct and indirect)
11	WCS_TOT_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Employee Salaries in Node (direct and indirect)
12	WCS_DIR_COUNT	Number(6,0)	INTEGER NOT NULL	Total Direct Reports in Node
13	WCS_DIR_SALARIES	Number(22,6)	DECIMAL(21,6) NOT NULL	Total Direct Reports Salaries in Node
14	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.