RE_CAFM_DEPTS (SQL Table)	Index Back
Depart Hierarchy table This table contains the departmental hierarchy relationship.

RE_CAFM_DEPTS

(SQL Table)

Depart Hierarchy table

This table contains the departmental hierarchy relationship.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

2 PARENT_DEPTID Character(10) VARCHAR2(10) NOT NULL Holds the Department ID of the parent department. Needed in the process of flattening out the department hierarchy for the sending to CAFM.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 LEVEL_CNT Number(3,0) SMALLINT NOT NULL Level Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
2	PARENT_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Holds the Department ID of the parent department. Needed in the process of flattening out the department hierarchy for the sending to CAFM.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	LEVEL_CNT	Number(3,0)	SMALLINT NOT NULL	Level Count