LM_PRGREG2_LNG (SQL View)	Index Back
Manager Program Registration Manager Program Registration

LM_PRGREG2_LNG

(SQL View)

Manager Program Registration

SELECT A.LM_PERSON_ID , A.LM_PRG_REG_ID , E.LANGUAGE_CD , E.LM_PRG_LONG_NM FROM PS_LM_PRG_REG_VW A , PS_LM_PERS_NAME_VW C , PS_LM_PRG D , PS_LM_PRG_LANG E WHERE A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_PRG_ID = D.LM_PRG_ID AND D.LM_PRG_ID = E.LM_PRG_ID AND D.EFFDT = E.EFFDT AND A.LM_ENRL_DT BETWEEN D.EFFDT AND D.LM_END_EFFDT

Related Language Record for LM_PRGRE_MG_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_PRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

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

4 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

#	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_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name