HCSC_TREEBLD_RC (SQL Table)	Index Back
Tree Builder Run Control This is the Run Control for the tree builder process, which attempts to populate a PeopleTools tree from an HCM hierarchy.

HCSC_TREEBLD_RC

(SQL Table)

Tree Builder Run Control

This is the Run Control for the tree builder process, which attempts to populate a PeopleTools tree from an HCM hierarchy.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID
Prompt Table: PRCSRUNCNTL

3 HCSC_APPCLASS_NAME Character(30) VARCHAR2(30) NOT NULL This is a descriptive name for an application class.
Prompt Table: HCSC_TBLDCLS_VW

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

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

6 TREE_EFFDT Date(10) DATE NOT NULL Effective date of the Tree

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

8 TREE_CATEGORY Character(18) VARCHAR2(18) NOT NULL Category name for the Tree
Prompt Table: PSTREECATGVW

9 TREE_STRCT_ID Character(18) VARCHAR2(18) NOT NULL Tree Structure Name (see PSTREESTRCT).

10 HCSC_RELATION_VW Character(15) VARCHAR2(15) NOT NULL This is the name of the relationship view used as the source of hierarchy information when building a tree.

11 HCSC_TREE_EXISTS Character(1) VARCHAR2(1) NOT NULL This is an indicator that a tree already exists with the specified keys.
Y/N Table Edit
Default Value: N

12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

13 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: PER_ORG_ASGN_VW

14 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: PRCSRUNCNTL.OPRID
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID Default Value: PRCSRUNCNTL.RUN_CNTL_ID Prompt Table: PRCSRUNCNTL
3	HCSC_APPCLASS_NAME	Character(30)	VARCHAR2(30) NOT NULL	This is a descriptive name for an application class. Prompt Table: HCSC_TBLDCLS_VW
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
5	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
6	TREE_EFFDT	Date(10)	DATE NOT NULL	Effective date of the Tree
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	TREE_CATEGORY	Character(18)	VARCHAR2(18) NOT NULL	Category name for the Tree Prompt Table: PSTREECATGVW
9	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
10	HCSC_RELATION_VW	Character(15)	VARCHAR2(15) NOT NULL	This is the name of the relationship view used as the source of hierarchy information when building a tree.
11	HCSC_TREE_EXISTS	Character(1)	VARCHAR2(1) NOT NULL	This is an indicator that a tree already exists with the specified keys. Y/N Table Edit Default Value: N
12	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
13	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: PER_ORG_ASGN_VW
14	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.