LM_LPLN_ACTD_VW(SQL View) |
Index Back |
|---|---|
Learning Plan with Planned EnrLearning Plan with Planned Enrollments. This view does not have any associated activity id. |
| SELECT A.LM_LPLN_ID , A.LM_PERSON_ID , A.LM_PRG_REG_ID , A.LM_ENRLMT_ID , A.LM_ADHC_LRN_ID , A.LM_ASSIGNED_BY , A.LM_PRIORITY , A.LM_TARGET_DATE , A.LM_REQUIRED , CI.LM_CS_LONG_NM , ENRL.LM_STTS , ENRL.LM_ACT_REQ , ENRL.LM_CI_ID ,A.LM_SCHEDULE_ENRLMT ,A.LM_SCHED_ENRL_FROM ,A.LM_SCHED_ENRL_TO ,A.LM_TRNG_REG_CD FROM PS_LM_LPLN_DTL A , PS_LM_ENRLMT ENRL , PS_LM_CI_TBL CI WHERE A.LM_ENRLMT_ID = ENRL.LM_ENRLMT_ID AND ENRL.LM_CI_ID = CI.LM_CI_ID AND ENRL.LM_ACT_ID = 0 AND %CurrentDateIn BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND CI.LM_CI_STATUS = '10' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_LPLN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Plan ID |
| 2 | LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_PRG_REG_ID |
Number(10,0) | DECIMAL(10) NOT NULL | The Program Registration ID is a unique identifier for a learner's program enrollment. |
| 4 | LM_ENRLMT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 5 | LM_ADHC_LRN_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 6 | LM_ASSIGNED_BY | Number(15,0) | DECIMAL(15) NOT NULL | Assigned By |
| 7 | LM_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Learning Plan Priority
H=High L=Low M=Medium |
| 8 | LM_TARGET_DATE | Date(10) | DATE | Learning Plan Target Date |
| 9 | LM_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Required
Y/N Table Edit |
| 10 | LM_CS_LONG_NM | Character(200) | VARCHAR2(200) NOT NULL | Long Name - Describes the long name of an object |
| 11 | LM_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Enrollment Status
CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted |
| 12 | LM_ACT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
N=No Y=Yes |
| 13 | LM_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 14 | LM_SCHEDULE_ENRLMT | Character(1) | VARCHAR2(1) NOT NULL | Schedule Enrollment |
| 15 | LM_SCHED_ENRL_FROM | Date(10) | DATE | Schedule Enrollment Date Range |
| 16 | LM_SCHED_ENRL_TO | Date(10) | DATE | Schedule Enrollment Date Range |
| 17 | LM_TRNG_REG_CD | Character(30) | VARCHAR2(30) NOT NULL |
Training Region
Prompt Table: LM_TRNG_REG_TBL |