LM_PNDIFADH_REQ(SQL View) |
Index Back |
|---|---|
Pending DIF RequestsThis will list enrollments that are DIF enrolled and Hour Tracking Status is pending. Also, only the DIF activities are selected on this view. |
| SELECT E.LM_ADHC_LRN_ID , E.LM_PERSON_ID , E.LM_ENRL_DT , E.LM_ADHC_ID , E.LM_TRAINING_CLASS , E.LM_TRG_PLN_CTGY , B.LM_HR_COMPANY , B.BUSINESS_UNIT , B.LM_ORGANIZATION_ID , D.LM_DIF_BALANCE_HRS , D.LM_DIF_LIMIT_HRS , 0 FROM PS_LM_ADHC_LRN_TBL E , PS_LM_PERSON_ATTRB B , PS_LM_DIFHIST_TBL D WHERE E.LM_PERSON_ID = B.LM_PERSON_ID AND E.LM_DIFELIGIBLE_FLG = 'Y' AND B.LM_PERSON_ID = D.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND B.LM_EMPL_RCD = D.LM_EMPL_RCD AND D.LM_AS_OF_DATE = ( SELECT MAX(X.LM_AS_OF_DATE) FROM PS_LM_DIFHIST_TBL X WHERE X.LM_PERSON_ID = D.LM_PERSON_ID AND X.LM_EMPL_RCD = D.LM_EMPL_RCD) UNION SELECT E.LM_ADHC_LRN_ID , E.LM_PERSON_ID , E.LM_ENRL_DT , E.LM_ADHC_ID , E.LM_TRAINING_CLASS , E.LM_TRG_PLN_CTGY , B.LM_HR_COMPANY , B.BUSINESS_UNIT , B.LM_ORGANIZATION_ID , 0 , 0 , 0 FROM PS_LM_ADHC_LRN_TBL E , PS_LM_PERSON_ATTRB B WHERE E.LM_PERSON_ID = B.LM_PERSON_ID AND E.LM_DIFELIGIBLE_FLG = 'Y' AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND NOT EXISTS ( SELECT 1 FROM PS_LM_DIFHIST_TBL D WHERE D.LM_PERSON_ID = B.LM_PERSON_ID AND D.LM_EMPL_RCD = B.LM_EMPL_RCD) |
| # | 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_PERSON_ID | Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 3 | LM_ENRL_DT | Date(10) | DATE | Enrollment/Registration Date |
| 4 | LM_ADHC_ID | Number(10,0) | DECIMAL(10) NOT NULL | Adhoc Id |
| 5 | LM_TRAINING_CLASS | Character(10) | VARCHAR2(10) NOT NULL | Training Class |
| 6 | LM_TRG_PLN_CTGY | Character(10) | VARCHAR2(10) NOT NULL | Training Plan Category |
| 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_ORGANIZATION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Organization ID |
| 10 | LM_DIF_BALANCE_HRS | Signed Number(13,3) | DECIMAL(11,3) NOT NULL | DIF Balance |
| 11 | LM_DIF_LIMIT_HRS | Number(6,0) | INTEGER NOT NULL | DIF in Advance |
| 12 | LM_DIF_PLANNED_HRS | Signed Number(13,3) | DECIMAL(11,3) NOT NULL | Planned DIF Balance |