LM_PERS_LGRP2VW (SQL View)	Index Back
Person Learner Groups Selects the learner's learner group and matches the learner group criteria field. Also, calculates the total count on how many matches on the learner's learner group with the learner group criteria. For example, the criteria for learner group 2030 will have learner group criteria of 1001, 1004. However, the learner's learner group matches only 1001. Therefore, this view will show for learner group 2030, only 1 matches.

LM_PERS_LGRP2VW

(SQL View)

Person Learner Groups

Selects the learner's learner group and matches the learner group criteria field. Also, calculates the total count on how many matches on the learner's learner group with the learner group criteria. For example, the criteria for learner group 2030 will have learner group criteria of 1001, 1004. However, the learner's learner group matches only 1001. Therefore, this view will show for learner group 2030, only 1 matches.

SELECT P1.LM_PERSON_ID , C1.LM_LRNR_GROUP_ID , COUNT(*) FROM PS_LM_GROUP_PERSON P1 , PS_LM_GROUPS_CRIT C1 WHERE C1.LM_FIELDNAME = 'LM_LRNR_GROUP_ID' AND %NumToChar(P1.LM_LRNR_GROUP_ID) = C1.LM_CRITERIA_VALUE GROUP BY P1.LM_PERSON_ID, C1.LM_LRNR_GROUP_ID

# 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_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

3 LM_COUNT Number(10,0) DECIMAL(10) NOT NULL Field to keep track of the count of id fields

#	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_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
3	LM_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Field to keep track of the count of id fields