LM_LRNR_PRG_LNG (SQL View)	Index Back
Learner Programs Language Tbl Lists all programs (any status) associated with a learner. Joins to the program table with the program registration table to bring in all of the program information, selecting the correct effective dated program row based upon the learners registration date.

LM_LRNR_PRG_LNG

(SQL View)

Learner Programs Language Tbl

Lists all programs (any status) associated with a learner. Joins to the program table with the program registration table to bring in all of the program information, selecting the correct effective dated program row based upon the learners registration date.

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

Related Language Record for LM_LRNR_PRG_VW LM_MYLRN_PRG_VW

# 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_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

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_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
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