LM_PERSON_IDLM_LRNR_GROUP_IDLM_PERS_LGRP_VW(SQL View) |
Index Back |
|---|---|
Person Learner GroupsContains one row for each Learner Group a Person is in. Also, the learner group criteria is selected if the person meets the criteria. If it does, then the learner group criteria is also selected. |
| SELECT LM_PERSON_ID , LM_LRNR_GROUP_ID FROM PS_LM_GROUP_PERSON UNION SELECT DISTINCT P2.LM_PERSON_ID , P2.LM_LRNR_GROUP_ID FROM PS_LM_PERS_LGRP2VW P2 , PS_LM_PERS_LGRP1VW P1 WHERE P1.LM_LRNR_GROUP_ID = P2.LM_LRNR_GROUP_ID AND P1.LM_COUNT = P2.LM_COUNT |
| # | 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 |