TL_COMPLEAV_VW(SQL View) |
Index Back |
|---|---|
Comp and Leave Time ViewCompensatory and Leave Time Summary View |
| SELECT A.EMPLID , A.EMPL_RCD , A.ACCRUAL_PROC_DT , A.PLAN_TYPE , C.DESCR , ' ' , %DateNull , A.HRS_CARRYOVER , 0 , A.HRS_EARNED_YTD , A.HRS_TAKEN_YTD , B.END_BAL FROM PS_LEAVE_ACCRUAL A , PS_TL_COMPLEAV_TBL B , PS_PLAN_TYPE_VW C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.PLAN_TYPE = B.COMP_TIME_PLAN AND A.ACCRUAL_PROC_DT = B.DUR AND A.PLAN_TYPE = C.PLAN_TYPE UNION SELECT B.EMPLID , B.EMPL_RCD , B.DUR , B.COMP_TIME_PLAN , C.DESCR , B.ACTION , A.EXP_DT , 0 , 0 , B.TL_QUANTITY , B.TAKEN_TOTAL , A.END_BAL FROM PS_TL_COMPLEAV_TBL A , PS_TL_COMP_DAY_BAL B , PS_TL_COMP_TIME C WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.DUR = B.DUR AND A.TRC = B.TRC AND A.COMP_TIME_PLAN = B.COMP_TIME_PLAN AND A.COMP_TIME_PLAN = C.COMP_TIME_PLAN AND C.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_TL_COMP_TIME D WHERE D.COMP_TIME_PLAN = C.COMP_TIME_PLAN AND D.EFFDT <= C.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 4 | COMP_TIME_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Plan |
| 5 | PLAN_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Plan Type Description |
| 6 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 7 | EXP_DT | Date(10) | DATE | Expected Completion Date |
| 8 | HRS_CARRYOVER | Signed Number(13,6) | DECIMAL(11,6) NOT NULL | Carryover Hours |
| 9 | HRS_EARNED_YTD | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Hours Earned Year-to-Date |
| 10 | HOURS_EARNED | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Hours Earned |
| 11 | HRS_TAKEN | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Taken |
| 12 | END_BAL | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Ending Balance |