LM_DMTHD_IDEFFDTDefault Value: %date
LM_LRNR_GROUP_IDPrompt Table: %EDITTABLE
LM_DM_LE_LG_VW(SQL View) |
Index Back |
|---|---|
LE LG ViewLearning Environments related to Learner Groups |
| SELECT D.LM_DMTHD_ID , D.EFFDT , C.LM_LRNR_GROUP_ID , A.LM_LRNR_GRP_DESCR FROM PS_LM_LG_LE_VW A , PS_LM_CI_SEC_TBL C , PS_LM_DMTHD_TBL D , PS_LM_CI_TBL E WHERE D.EFFDT BETWEEN E.EFFDT AND E.LM_END_EFFDT AND D.LM_CI_ID=C.LM_CI_ID AND D.EFFDT=C.EFFDT AND D.LM_CI_ID=E.LM_CI_ID AND C.LM_LRNR_GROUP_ID=A.LM_LRNR_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_DMTHD_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | LM_LRNR_GROUP_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Learner Group ID - Business Role/ Student Group ID |
| 4 | LM_LRNR_GRP_DESCR | Character(50) | VARCHAR2(50) NOT NULL |
Learner Group Description
Prompt Table: %EDITTABLE |