LM_LGQRYVW_LANG (SQL View)	Index Back
Adhoc Learner Groups Query vw Adhoc Learner Groups Query vw

LM_LGQRYVW_LANG

(SQL View)

Adhoc Learner Groups Query vw

SELECT A.LM_QUERY_NAME , A.LANGUAGE_CD , A.LM_LG_QRY_NAME FROM PS_LM_LG_QRY_LANG a , PS_LM_LG_QRYNAME B WHERE A.LM_QUERY_NAME = B.LM_QUERY_NAME

Related Language Record for LM_LG_N_QRY_VW LM_LG_QUERY_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_QUERY_NAME Character(30) VARCHAR2(30) NOT NULL Query Name.

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 LM_LG_QRY_NAME Character(80) VARCHAR2(80) NOT NULL Used in Learner Group page as the label that shows up in the Query Type Learner Group.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_QUERY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Query Name.
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	LM_LG_QRY_NAME	Character(80)	VARCHAR2(80) NOT NULL	Used in Learner Group page as the label that shows up in the Query Type Learner Group.