LM_RCPNT_LG_VW(SQL View) |
Index Back |
---|---|
Learner Group ViewContains all active Learner Groups. |
SELECT LM_LRNR_GROUP_ID , LM_LRNR_GRP_DESCR FROM PS_LM_LRNR_GROUPS WHERE LM_ACTIVE = 'Y' AND LM_LG_TYPE <> 'X' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LM_RCPNT_GRP | Number(15,0) | DECIMAL(15) NOT NULL |
Recipient Group
Prompt Table: %EDITTABLE |
2 | LM_LRNR_GRP_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Learner Group Description |