TRN_ROOM_LANG (SQL Table)	Index Back
Training Rooms Use TRN_ROOM_TBL to record information about rooms located within a training facility, where training courses are taught for your company. You can enter building, floor, room number and the maximum number of students a room can hold. You can also set the training room to be inactive, so that no more courses can be booked in it. This functionality is part of the Training Administration application.

TRN_ROOM_LANG

(SQL Table)

Training Rooms

Use TRN_ROOM_TBL to record information about rooms located within a training facility, where training courses are taught for your company. You can enter building, floor, room number and the maximum number of students a room can hold. You can also set the training room to be inactive, so that no more courses can be booked in it. This functionality is part of the Training Administration application.

Related Language Record for TRN_ROOM_TBL

Parent record: TRN_FACIL_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

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 BUILDING Character(10) VARCHAR2(10) NOT NULL Building #

5 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor #

6 ROOM_NBR Character(30) VARCHAR2(30) NOT NULL Room Number

#	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
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	BUILDING	Character(10)	VARCHAR2(10) NOT NULL	Building #
5	FLOOR	Character(10)	VARCHAR2(10) NOT NULL	Floor #
6	ROOM_NBR	Character(30)	VARCHAR2(30) NOT NULL	Room Number