EMPLIDEMPL_RCDBEGIN_DTABSENCE_TYPEABS_SUMM_VW(SQL View) |
Index Back |
|---|---|
Absence Summary ViewAbsence Summary View |
| SELECT emplid , EMPL_RCD , begin_dt , absence_type , abs_begin_tm , return_dt , abs_return_tm , duration_days , duration_hours , reason FROM PS_ABSENCE_HIST |
| # | 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 Rcd Nbr |
| 3 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | ABSENCE_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 5 | ABS_BEGIN_TM | Time(15) | TIMESTAMP | Begin Time |
| 6 | RETURN_DT | Date(10) | DATE | Return Date |
| 7 | ABS_RETURN_TM | Time(15) | TIMESTAMP | Return Time |
| 8 | DURATION_DAYS | Number(7,3) | DECIMAL(6,3) NOT NULL | Duration (Days) |
| 9 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
| 10 | REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason |