LM_OPR_FRA_VW (SQL View)	Index Back
User LE and French Indicator Gets Learning Environment and French Features Flag for the user.

LM_OPR_FRA_VW

(SQL View)

User LE and French Indicator

Gets Learning Environment and French Features Flag for the user.

SELECT LRNR.LM_LE_ID , LRNR.OPRID , LEFR.LM_ENABLE_FRA FROM PS_LM_OPRID_LE_VW LRNR , PS_LM_LE_DFLT_TBL LEFR WHERE LRNR.LM_LE_ID = LEFR.LM_LE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 LM_ENABLE_FRA Character(1) VARCHAR2(1) NOT NULL Enable French Features

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	LM_ENABLE_FRA	Character(1)	VARCHAR2(1) NOT NULL	Enable French Features