LM_FCLTY_EQP (SQL Table)	Index Back
Facility Equipment Table Stores equipment at the facility which is available for use/rent by all of the training rooms in the facility.

LM_FCLTY_EQP

(SQL Table)

Facility Equipment Table

Stores equipment at the facility which is available for use/rent by all of the training rooms in the facility.

# 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_EQP_ID Number(10,0) DECIMAL(10) NOT NULL Equipment ID
Prompt Table: LM_EQP_SRCH

3 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

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

5 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

6 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_EQP_ID	Number(10,0)	DECIMAL(10) NOT NULL	Equipment ID Prompt Table: LM_EQP_SRCH
3	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
4	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
5	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
6	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid