LM_TPLN_ADHC_VW(SQL View) |
Index Back |
|---|---|
Training plan enrollmentTraining plan enrollment view |
| SELECT A.LM_ADHC_LRN_ID , A.LM_PER_TRN_ST_DT , A.LM_PER_TRN_ED_DT , A.LM_PERSON_ID , B.LM_ORGANIZATION_ID , B.LM_LE_ID , B.LM_HR_COMPANY , B.BUSINESS_UNIT , A.LM_ENRL_DT , A.LM_ADHC_LRN_STTS , A.LM_STD_HRS , A.LM_ADHC_ID , A.LM_ACT_FEE , A.LM_COMPL_DT FROM PS_LM_ADHC_LRN_TBL A , PS_LM_PERSON_ATTRB B WHERE A.LM_PERSON_ID = B.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ADHC_LRN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Learning Id |
| 2 | LM_START_DT | Date(10) | DATE | Start Date |
| 3 | LM_END_DT | Date(10) | DATE | End Date |
| 4 | LM_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 5 | LM_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 6 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 7 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 10 | LM_ADHC_LRN_STTS | Character(4) | VARCHAR2(4) NOT NULL |
Adhoc Learning Status
COMP=Completed DECL=Denied DROP=Dropped INPO=In-Progress PEAP=Pending Approval PLAN=Planned |
| 11 | LM_STD_HRS | Number(15,2) | DECIMAL(14,2) NOT NULL | Study Hours |
| 12 | LM_ADHC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Id |
| 13 | LM_ACT_FEE | Number(19,3) | DECIMAL(18,3) NOT NULL | Activity Fee -- The cost to the learner of enrolling in a class |
| 14 | LM_COMPL_DT | Date(10) | DATE | The date on which this Enrollment was marked Completed / InComplete |