GPGB_ABEJR_NRVW(SQL View) |
Index Back |
|---|---|
UK Absence Event Juni NPR ViewThis record contains the UK specific information relating to an absence event. |
| SELECT EMPLID , EMPL_RCD , BGN_DT , PIN_TAKE_NUM + 50000000 , END_DT , NOTIFIED_BY , NOTIFIED_DT , NOTIFIED_TM , PAID_UNPAID , GPGB_ABSENCE_TYPE , GPGB_ABSENCE_CODE , REASON , GPGB_ADJ_ENT_MAP1 , GPGB_OVRD_ENT_MAP1 , GPGB_STAT_AV_EARNS , GPGB_OCC_AV_EARNS , AWC_DT , EWC_DT , INDUSTRIAL_INJURY , INCIDENT_NBR , REFER_TO_OHA , COUNSELLING , DISCIPLINARY , DOC_CONSULT_DT , DOC_CONSULTED , GPGB_ABS_PRI_IND , GPGB_ABS_EB_IND , GPGB_DISQ_DATE , GPGB_DISQ_REASON , GPGB_MTCH_NOTIF_DT , GPGB_MW_END_DT ,GPGB_EXPD_PLCMT_DT , GPGB_ABS_DAILY ,GPGB_ABS_LINK_DUR ,GPGB_FROM_DT ,GPGB_TO_DT ,GPGB_ABS_RET_DT ,GPGB_ASPP_ENT ,GPGB_ASPP_CERT ,GPGB_OSPP ,GPGB_KIT_OVR_DT ,GPGB_ABS_PRTNR_DIE FROM PS_GPGB_ABS_EVT_JR |
| # | 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 | end date |
| 6 | NOTIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Notified of Absence By Whom |
| 7 | NOTIFIED_DT | Date(10) | DATE | Date First Notified |
| 8 | NOTIFIED_TM | Time(15) | TIMESTAMP | Time First Notified |
| 9 | PAID_UNPAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid/Unpaid
P=Paid U=Unpaid |
| 10 | GPGB_ABSENCE_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Absence Type
Prompt Table: GPGB_ABS_TYPE |
| 11 | GPGB_ABSENCE_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Absence Code
Prompt Table: GPGB_ABS_CODE |
| 12 | REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason |
| 13 | GPGB_ADJ_ENT_MAP1 | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Override Adjustment Amount |
| 14 | GPGB_OVRD_ENT_MAP1 | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Override Entitlement Amount |
| 15 | GPGB_STAT_AV_EARNS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Statutory Average Earnings |
| 16 | GPGB_OCC_AV_EARNS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Occupational Average Earnings |
| 17 | AWC_DT | Date(10) | DATE | Actual Week of Child Birth |
| 18 | EWC_DT | Date(10) | DATE | Expected Week of Child Birth |
| 19 | INDUSTRIAL_INJURY | Character(1) | VARCHAR2(1) NOT NULL |
Work Injury Related
Y/N Table Edit Default Value: N |
| 20 | INCIDENT_NBR | Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 21 | REFER_TO_OHA | Character(1) | VARCHAR2(1) NOT NULL |
Refer to Occ Health Auth
Y/N Table Edit Default Value: N |
| 22 | COUNSELLING | Character(1) | VARCHAR2(1) NOT NULL |
Counseling
Y/N Table Edit Default Value: N |
| 23 | DISCIPLINARY | Character(1) | VARCHAR2(1) NOT NULL |
Disciplinary
Y/N Table Edit Default Value: N |
| 24 | DOC_CONSULT_DT | Date(10) | DATE | Consultation Date |
| 25 | DOC_CONSULTED | Character(1) | VARCHAR2(1) NOT NULL |
Doctor Consulted
Y/N Table Edit Default Value: N |
| 26 | GPGB_ABS_PRI_IND | Character(1) | VARCHAR2(1) NOT NULL |
Pregnancy Related Illness
Y/N Table Edit Default Value: N |
| 27 | GPGB_ABS_EB_IND | Character(1) | VARCHAR2(1) NOT NULL |
Early Childbirth
Y/N Table Edit Default Value: N |
| 28 | GPGB_DISQ_DATE | Date(10) | DATE | Date of Disqualification |
| 29 | GPGB_DISQ_REASON | Character(30) | VARCHAR2(30) NOT NULL | Reason for Disqualification |
| 30 | GPGB_MTCH_NOTIF_DT | Date(10) | DATE | Date Match Notified |
| 31 | GPGB_MW_END_DT | Date(10) | DATE | Matching Week End Date |
| 32 | GPGB_EXPD_PLCMT_DT | Date(10) | DATE | The Absence Expected Placement date |
| 33 | GPGB_ABS_DAILY | Character(1) | VARCHAR2(1) NOT NULL |
Absence Daily Payment Indicator
N=No Y=Yes |
| 34 | GPGB_ABS_LINK_DUR | Number(3,0) | SMALLINT NOT NULL | calculates absence duration |
| 35 | GPGB_FROM_DT | Date(10) | DATE | GP UK From Date |
| 36 | GPGB_TO_DT | Date(10) | DATE | GP UK To Date |
| 37 | GPGB_ABS_RET_DT | Date(10) | DATE | ASPP - Partner return date |
| 38 | GPGB_ASPP_ENT | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | ASPP Entitlement Weeks |
| 39 | GPGB_ASPP_CERT | Character(1) | VARCHAR2(1) NOT NULL |
Self certificate provided by employee for ASPP has been retained
N=No Y=Yes |
| 40 | GPGB_OSPP | Character(1) | VARCHAR2(1) NOT NULL |
If Ordinary SPP has been availed
N=No Y=Yes |
| 41 | GPGB_KIT_OVR_DT | Date(10) | DATE | ASPP : KIT Limit exceeded Date |
| 42 | GPGB_ABS_PRTNR_DIE | Character(1) | VARCHAR2(1) NOT NULL | Partner Deceased |