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

LM_PRGREG_LNG

(SQL View)

Manager Program Registration

SELECT B.OPRID , B.LM_MANAGER_ID , 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_MGR_SRCH_VW B , PS_LM_PERS_NAME_VW C , PS_LM_PRG D , PS_LM_PRG_LANG E WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND 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_PRGREG_MG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 LM_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID

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

4 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.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_MANAGER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Manager ID
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	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.
5	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
6	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name