LM_ROOM_ACMDTN (SQL Table)	Index Back
Room Accomodation Table Stores special accomodations (such as wheel chair accessible) for individual training rooms.

LM_ROOM_ACMDTN

(SQL Table)

Room Accomodation Table

Stores special accomodations (such as wheel chair accessible) for individual training rooms.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID

2 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID

3 LM_ACMDTN_ID Number(10,0) DECIMAL(10) NOT NULL Accommodation ID
Prompt Table: LM_ACMDTN_TBL

4 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

5 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

6 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

7 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_FCLTY_ID	Number(10,0)	DECIMAL(10) NOT NULL	Facility ID
2	LM_ROOM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Room ID
3	LM_ACMDTN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Accommodation ID Prompt Table: LM_ACMDTN_TBL
4	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
5	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
6	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
7	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid