GPFR_ABTKN_NRVW(SQL View) |
Index Back |
|---|---|
Absence Take Setup fo NPR ViewAbsence Take Setup for Reports |
| SELECT PIN_NUM + 50000000 , %Substring(GP_ELN_ATTR1, 1, 2) , %Substring(GP_ELN_ATTR2, 1, 2) , %Substring(GP_ELN_ATTR3, 1, 7) , %Substring(GP_ELN_ATTR4, 1, 7) , %Substring(GP_ELN_ATTR5, 1, 2) , %Substring(GP_ELN_ATTR6, 1, 2) , %Substring(GP_ELN_ATTR7, 1, 1) FROM PS_GP_ELN_PIN_ATTR WHERE COUNTRY = 'FRA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | GPFR_PYSL_ABS_B | Character(2) | VARCHAR2(2) NOT NULL | GPFR: Payslip Absence Code |
| 3 | GPFR_PYSL_ABS_A | Character(2) | VARCHAR2(2) NOT NULL | GPFR: Annexe Absence Code |
| 4 | GPFR_ILL_C6 | Character(7) | VARCHAR2(7) NOT NULL | Code 6 for absence take |
| 5 | GPFR_ACC_C14 | Character(7) | VARCHAR2(7) NOT NULL | Code 14 for absence take |
| 6 | GPFR_ABS_FAMILY | Character(2) | VARCHAR2(2) NOT NULL |
Stores the values of the type of absence related to the illness, work accident and maternity certificates
IL=Illness LT=Long Term Illness MT=Maternity OD=Occupational Disease PT=Paternity WA=Work Accident |
| 7 | GPFR_DA_ABS_CD | Character(2) | VARCHAR2(2) NOT NULL |
DADS related field
01=Illness 02=Maternity 03=Half Treatment Illness 04=Work Accident 05=Disability 07=Unemployment 08=Occ. Disease 09=Illness 10=Therap. PT 11=Journey Acc 12=Vacation NP |
| 8 | GPFR_DA_UNPAID | Character(1) | VARCHAR2(1) NOT NULL |
DADS related field
Y/N Table Edit Default Value: N |