LM_FCLTY_LE (SQL Table)	Index Back
Facility LE Table Facility Learning Environment Table

LM_FCLTY_LE

(SQL Table)

Facility LE Table

Facility Learning Environment Table

# 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_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
Prompt Table: LM_LE_VW

3 LM_PRM_LE Character(2) VARCHAR2(2) NOT NULL Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)
Y/N Table Edit
Default Value: N

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_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number Prompt Table: LM_LE_VW
3	LM_PRM_LE	Character(2)	VARCHAR2(2) NOT NULL	Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category) Y/N Table Edit Default Value: N
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