HRCD_TREDEL_AET (SQL Table)	Index Back
Tree Builder State Record Used in process to delete old trees.

HRCD_TREDEL_AET

(SQL Table)

Tree Builder State Record

Used in process to delete old trees.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

4 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date