HCSC_TREBLD_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
5	HCSC_APPCLASS_NAME	Character(30)	VARCHAR2(30) NOT NULL	This is a descriptive name for an application class. Prompt Table: HCSC_TBLDCLS_VW
6	HCSC_APPCLASS_ID	Character(25)	VARCHAR2(25) NOT NULL	This is used to hold a dynamically generated unique string that serves as a key for an Application Class. AppClasses do not have a key, other than their full class path, which is too cumbersome to use for searching purposes
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	TREE_CATEGORY	Character(18)	VARCHAR2(18) NOT NULL	Category name for the Tree
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
13	HCSC_ROOT_VALUE	Character(30)	VARCHAR2(30) NOT NULL	This is the value of the topmost item in a hierarchy: the point at which to begin building a tree.
14	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
15	EMPL_ID_RCD	Character(20)	VARCHAR2(20) NOT NULL	Job concatenated key.
16	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
17	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
18	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL