CONSOL_SEL1 (SQL Table)	Index Back
Consolidation Selector Table 1 Work table to store consolidation entities and tree node information used in consolidation or equitization processes.

CONSOL_SEL1

(SQL Table)

Consolidation Selector Table 1

Work table to store consolidation entities and tree node information used in consolidation or equitization processes.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

3 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

5 ELIMS_ONLY Character(1) VARCHAR2(1) NOT NULL For Eliminations Only

6 IN_SCOPE_SW Character(1) VARCHAR2(1) NOT NULL In Scope

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
3	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
4	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
5	ELIMS_ONLY	Character(1)	VARCHAR2(1) NOT NULL	For Eliminations Only
6	IN_SCOPE_SW	Character(1)	VARCHAR2(1) NOT NULL	In Scope