TRN_ROOM_EQUIP (SQL Table)	Index Back
Training Room Equipment Use TRN_ROOM_EQUIP to record information about equipment and materials that are directly associated with a training room, i.e. fixed. This functionality is part of the Training Administration application.

TRN_ROOM_EQUIP

(SQL Table)

Training Room Equipment

Use TRN_ROOM_EQUIP to record information about equipment and materials that are directly associated with a training room, i.e. fixed. This functionality is part of the Training Administration application.

Parent record: TRN_ROOM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FACILITY Character(6) VARCHAR2(6) NOT NULL Facility
Prompt Table: TRN_FACIL_TBL

2 ROOM_CD Character(6) VARCHAR2(6) NOT NULL Room Code
Prompt Table: TRN_ROOM_TBL

3 EQUIP_CD Character(4) VARCHAR2(4) NOT NULL Equipment/Materials Code
Prompt Table: TRN_EQUIP_TBL

4 QUANTITY Number(3,0) SMALLINT NOT NULL Quantity
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FACILITY	Character(6)	VARCHAR2(6) NOT NULL	Facility Prompt Table: TRN_FACIL_TBL
2	ROOM_CD	Character(6)	VARCHAR2(6) NOT NULL	Room Code Prompt Table: TRN_ROOM_TBL
3	EQUIP_CD	Character(4)	VARCHAR2(4) NOT NULL	Equipment/Materials Code Prompt Table: TRN_EQUIP_TBL
4	QUANTITY	Number(3,0)	SMALLINT NOT NULL	Quantity Default Value: 1