HRCD_TRNODE_AET (SQL Table)	Index Back
Company Directory Nodes This table stores the list of available employee Job nodes for the Company Directory Tree. This table will contain all active Jobs as of a given date. The Jobs in this table may or may not exist in the corresponding Tree, but a row must exist in this table before a Job can be added to the Tree. The column TREE_NODE contains a unique serial number. This table acts as a foreign key table to get emplid for a tree node.

HRCD_TRNODE_AET

(SQL Table)

Company Directory Nodes

This table stores the list of available employee Job nodes for the Company Directory Tree. This table will contain all active Jobs as of a given date. The Jobs in this table may or may not exist in the corresponding Tree, but a row must exist in this table before a Job can be added to the Tree. The column TREE_NODE contains a unique serial number. This table acts as a foreign key table to get emplid for a tree node.

# 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 Character(20) VARCHAR2(20) NOT NULL Node name
Prompt Table: HRCD_JBTRPRM_VW

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

5 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

8 PARENT_NODE_NAME Character(20) VARCHAR2(20) NOT NULL Name of parent node

9 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

10 SUPERVISOR_ERN Number(3,0) SMALLINT NOT NULL This is used to hold the Employment Record Number of a supervisor.

11 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

12 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts

13 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

#	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	Character(20)	VARCHAR2(20) NOT NULL	Node name Prompt Table: HRCD_JBTRPRM_VW
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
5	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
7	LASTUPDDTTM	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.
8	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node
9	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
10	SUPERVISOR_ERN	Number(3,0)	SMALLINT NOT NULL	This is used to hold the Employment Record Number of a supervisor.
11	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
12	COUNT1	Number(12,0)	DECIMAL(12) NOT NULL	AUS WGEA counts
13	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job