FACILITY_CMPNT (SQL Table)	Index Back
Facility Component Table This table identifies a given facility's components. If a facility is comprised of one or more sub-facilities, a row that corresponds to each of the sub-facilities must be entered in the Facility Components table. Note that a facility cannot be a component of more than one facility nor can sub-facilities be nested.

FACILITY_CMPNT

(SQL Table)

Facility Component Table

This table identifies a given facility's components. If a facility is comprised of one or more sub-facilities, a row that corresponds to each of the sub-facilities must be entered in the Facility Components table. Note that a facility cannot be a component of more than one facility nor can sub-facilities be nested.

Parent record: FACILITY_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
Prompt Table: FACILITY_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 CMPNT_FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Component Facility ID
Prompt Table: FACIL_CMPNT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
2	FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Facility ID Prompt Table: FACILITY_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	CMPNT_FACILITY_ID	Character(10)	VARCHAR2(10) NOT NULL	Component Facility ID Prompt Table: FACIL_CMPNT_VW