RUN_CNTL_IDLM_TRN_PLN_IDLM_ORGANIZATION_IDLM_TPLAN_ORG_VW(SQL View) |
Index Back |
|---|---|
Training Plan ViewTraining Plan View |
| SELECT E.RUN_CNTL_ID , C.LM_TRN_PLN_ID , A.LM_ORGANIZATION_ID , C.LM_START_DT , C.LM_END_DT , C.LM_FINALIZATION_DT , C.LM_AS_OF_DATE , C.LM_LE_ID , C.BUSINESS_UNIT , C.LM_HR_ESTAB_ID , D.LM_LE_LONG_NM , C.LM_HR_COMPANY , F.LM_COMP_DESCR , B.LM_ORG_DESCR , A.LM_FUNDING_AMT , A.CURRENCY_CD FROM PS_LM_TRN_PLN_SETP C LEFT OUTER JOIN PS_LM_LE_VW D ON C.LM_LE_ID = D.LM_LE_ID LEFT OUTER JOIN PS_LM_HR_COMP_VW F ON C.LM_HR_COMPANY = F.LM_HR_COMPANY ,PS_LM_TRNGPLAN_FND A , PS_LM_ORG_VW B , PS_LM_TRN_PLN_RCTL E WHERE E.LM_TRN_PLN_ID = A.LM_TRN_PLN_ID AND C.LM_TRN_PLN_ID = A.LM_TRN_PLN_ID AND A.LM_ORGANIZATION_ID = B.LM_ORGANIZATION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | LM_TRN_PLN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Training Plan Id |
| 3 | LM_ORGANIZATION_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 4 | LM_START_DT | Date(10) | DATE | Start Date |
| 5 | LM_END_DT | Date(10) | DATE | End Date |
| 6 | LM_FINALIZATION_DT | Date(10) | DATE | Finalization Date |
| 7 | LM_AS_OF_DATE | Date(10) | DATE | As of Date |
| 8 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | LM_HR_ESTAB_ID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 11 | LM_LE_LONG_NM | Character(60) | VARCHAR2(60) NOT NULL | Learning Environment Long Name |
| 12 | LM_HR_COMPANY | Character(3) | VARCHAR2(3) NOT NULL | HR's Company ID brought over during synchronization. |
| 13 | LM_COMP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Company description. |
| 14 | LM_ORG_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Customer Description |
| 15 | LM_FUNDING_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Funding amount of an organization. |
| 16 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |