TL_CMPLEVDTL_VW(SQL View) |
Index Back |
|---|---|
Leave and Compensatory DetailLeave and Compensatory Detail Record |
| SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.LAST_NAME , A.FIRST_NAME , A.JOB_DESCR , B.DUR , B.COMP_TIME_PLAN , B.PLAN_TYPE_DESCR , B.ACTION , B.EXP_DT , B.HRS_CARRYOVER , B.HRS_EARNED_YTD , B.HOURS_EARNED , B.HRS_TAKEN , B.END_BAL FROM PS_TL_LEAV_COMP_VW A , PS_TL_COMPLEAV_VW B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD |
| # | 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 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 4 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 5 | JOB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Job Description |
| 6 | ACCRUAL_PROC_DT | Date(10) | DATE | Accrual Process Date |
| 7 | COMP_TIME_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Plan |
| 8 | PLAN_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Plan Description |
| 9 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 10 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 11 | HRS_CARRYOVER | Signed Number(13,6) | DECIMAL(11,6) NOT NULL | Carryover Hours |
| 12 | HRS_EARNED_YTD | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Starting Balance |
| 13 | HOURS_EARNED | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Hours Earned |
| 14 | HRS_TAKEN | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Hours Taken |
| 15 | END_BAL | Signed Number(9,3) | DECIMAL(7,3) NOT NULL | Ending Balance |