LM_LRNR_GROUP_IDLM_PERSON_IDLM_GROUP_PER_VW(SQL View) |
Index Back |
|---|---|
Learner Group Person ViewC14N View of the Learner Group Person Table |
| SELECT GP.LM_LRNR_GROUP_ID , GP.LM_PERSON_ID FROM PS_LM_GROUP_PERSON GP , PS_LM_LRNR_GROUPS LG WHERE LG.LM_LRNR_GROUP_ID = GP.LM_LRNR_GROUP_ID AND LG.LM_ACTIVE='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LRNR_GROUP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |