GP_ABS_EVT_VW(SQL View) |
Index Back |
|---|---|
Absence Event ViewAbsence Event Definition - View |
| SELECT EMPLID ,EMPL_RCD ,BGN_DT ,PIN_TAKE_NUM ,END_DT ,BEGIN_DAY_HRS ,BEGIN_DAY_HALF_IND ,END_DAY_HRS ,END_DAY_HALF_IND ,ALL_DAYS_IND ,VOIDED_IND ,PRC_EVT_ACTN_OPTN ,MANAGER_APPR_IND FROM PS_GP_ABS_EVENT |
| # | 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 | BGN_DT |
Date(10) | DATE | Begin Date |
| 4 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 5 | END_DT | Date(10) | DATE NOT NULL |
end date
Default Value: GP_ABS_EVENT.BGN_DT |
| 6 | BEGIN_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Partial Hours |
| 7 | BEGIN_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
indicates whether first day of an absence event began counts as half a day
Y/N Table Edit Default Value: N |
| 8 | END_DAY_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | partial hours end |
| 9 | END_DAY_HALF_IND | Character(1) | VARCHAR2(1) NOT NULL |
half day end indicator
Y/N Table Edit Default Value: N |
| 10 | ALL_DAYS_IND | Character(1) | VARCHAR2(1) NOT NULL |
All Days Indicator
N=Apply To Begin Day Only Y=Apply To All Days Y/N Table Edit Default Value: N |
| 11 | VOIDED_IND | Character(1) | VARCHAR2(1) NOT NULL | Voided Indicator |
| 12 | PRC_EVT_ACTN_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process Action Event Indicator
N=Normal V=Void |
| 13 | MANAGER_APPR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Manager Approved
Y/N Table Edit Default Value: N |