TRN_ROOM_TAO (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_TAO

(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.

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 BUILDING Character(10) VARCHAR2(10) NOT NULL Building Nbr

4 FLOOR Character(10) VARCHAR2(10) NOT NULL Floor Nbr

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

6 MAX_STUDENTS Number(3,0) SMALLINT NOT NULL Maximum Nbr of Students

7 ROOM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Room Active
Y/N Table Edit
Default Value: Y

8 PER_UNIT_COST Number(19,3) DECIMAL(18,3) NOT NULL Per Unit Cost

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

10 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit
Prompt Table: TD_COST_UNIT_VW

#	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	BUILDING	Character(10)	VARCHAR2(10) NOT NULL	Building Nbr
4	FLOOR	Character(10)	VARCHAR2(10) NOT NULL	Floor Nbr
5	ROOM_NBR	Character(30)	VARCHAR2(30) NOT NULL	Room Number
6	MAX_STUDENTS	Number(3,0)	SMALLINT NOT NULL	Maximum Nbr of Students
7	ROOM_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Room Active Y/N Table Edit Default Value: Y
8	PER_UNIT_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Per Unit Cost
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: BUS_UNIT_OPT_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
10	COST_UNIT_CD	Character(10)	VARCHAR2(10) NOT NULL	Cost Unit Prompt Table: TD_COST_UNIT_VW