LM_ACT_LE_VW1 (SQL View)	Index Back
View on the LM_ACT_LE table

LM_ACT_LE_VW1

(SQL View)

View on the LM_ACT_LE table

SELECT LM_ACT_ID ,LM_LE_ID ,LM_PRM_LE FROM PS_LM_ACT_LE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

2 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

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)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
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)