TRN_FAC_EQUIPVW (SQL View)	Index Back
Training Facility Equipment Administer Training - Equipment available at a training facility.

TRN_FAC_EQUIPVW

(SQL View)

Training Facility Equipment

Administer Training - Equipment available at a training facility.

SELECT FACILITY , EQUIP_CD , QUANTITY FROM PS_TRN_FACIL_EQUIP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility

2 EQUIP_CD Character(4) VARCHAR2(4) NOT NULL Equipment/Materials Code

3 QUANTITY Number(3,0) SMALLINT NOT NULL Quantity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility
2	EQUIP_CD	Character(4)	VARCHAR2(4) NOT NULL	Equipment/Materials Code
3	QUANTITY	Number(3,0)	SMALLINT NOT NULL	Quantity