LM_PLAN_MG_LVW2 (SQL View)	Index Back
Manager Enrollment Manager Enrollment

LM_PLAN_MG_LVW2

(SQL View)

Manager Enrollment

SELECT A1.LM_PERSON_ID , A1.LM_ENRLMT_ID , GLG1.LANGUAGE_CD , GLG1.LM_CS_LONG_NM FROM PS_LM_ENRLMT_VW A1 , PS_LM_PERS_DTL_VW C1 , PS_LM_CI_VW G1 , PS_LM_CI_VW_LNG GLG1 WHERE A1.LM_PERSON_ID = C1.LM_PERSON_ID AND C1.LM_ACTIVE = 'Y' AND A1.LM_CI_ID = G1.LM_CI_ID AND A1.LM_ACT_ID = 0 AND G1.LM_CI_ID = GLG1.LM_CI_ID

Related Language Record for LM_PLAN_MGD_VW2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

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

4 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object