CONSOL_ND_STAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CONSOLIDATION_SET	Character(10)	VARCHAR2(10) NOT NULL	Consolidation Set
4	AS_OF_DATE	Date(10)	DATE	As of Date
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
6	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
7	CONSOL_NODE_SW	Character(1)	VARCHAR2(1) NOT NULL	Consolidation Node Y/N
8	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
9	CONSOL_NODE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Consolidation Node Status 0=Not Processed 1=Process Completed 2=Need Re-Process 3=Warning 4=Process Errored
10	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
11	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
13	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
14	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
15	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
16	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
17	MESSAGE_PARM4	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 4
18	DTTM_STAMP_SEC	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.