LM_ACT_IDDefault Value: %date
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
LM_ACT_PL_VW(SQL View) |
Index Back |
|---|---|
Popular Learning ActivitiesGets activities for popular learning pagelets. |
| SELECT ACT.LM_ACT_ID , CI.LM_CI_ID , CI.EFFDT , DMTH.LM_DMTHD_TYPE_ID , ACT.LM_ACT_CD , ACT.LM_ACT_STATUS , ACT.LM_ENRL_TOT , GRP.LM_PERSON_ID , ACT.LM_RESTRICT_TO_PRG FROM PS_LM_ACT ACT , PS_LM_CI_TBL CI , PS_LM_DMTH_TYP_TBL DMTH , PS_LM_ACT_SEC_VW ASEC , PS_LM_GROUP_PERSON GRP WHERE ACT.LM_CI_ID = CI.LM_CI_ID AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND DMTH.LM_DMTHD_TYPE_ID = ACT.LM_DMTHD_TYPE_ID AND ACT.LM_ACT_ID = ASEC.LM_ACT_ID AND ASEC.LM_LRNR_GROUP_ID = GRP.LM_LRNR_GROUP_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | LM_DMTHD_TYPE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Delivery Method Type ID - This is a unique identifier for each delivery method type |
| 5 | LM_ACT_CD | Character(30) | VARCHAR2(30) NOT NULL | Activity Code |
| 6 | LM_ACT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded |
| 7 | LM_ENRL_TOT | Number(6,0) | INTEGER NOT NULL | Enrollment Total |
| 8 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 9 | LM_RESTRICT_TO_PRG | Character(1) | VARCHAR2(1) NOT NULL | Restrict to Programs |