GPES_NRP_FD2_VW

(SQL View)
 Index Back

Abs Event ESP. Addtl Data

Absences event additional data for Global Payroll Spain

SELECT EMPLID ,EMPL_RCD ,BGN_DT ,PIN_TAKE_NUM + 50000000 ,END_DT ,GPES_SICK_DATE ,GPES_FDI_NOTE_TYPE ,ORIG_BEGIN_DT ,GPES_FDI_NUMBER ,GPES_REASON_DISCHR ,GPES_AREA_ID_CODE ,GPES_SENDING_ID ,GPES_STATE_REG ,NUMERIC_CD ,GPES_PHYSICIAN_ID ,GPES_CONFIRM_SEND ,GPES_FDI_MODIFIED FROM PS_GPES_ABSEVT_NT

# 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 BGN_DT Date(10) DATE NOT NULL Begin Date
4 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
5 END_DT Date(10) DATE NOT NULL end date
6 GPES_SICK_DATE Date(10) DATE Date to Sick note
7 GPES_FDI_NOTE_TYPE Character(2) VARCHAR2(2) NOT NULL Type
PA=Medical Discharge
PB=Sick Note
PC=Confirmation Sick Note

Default Value: PB

8 ORIG_BEGIN_DT Date(10) DATE original begin date
9 GPES_FDI_NUMBER Number(2,0) SMALLINT NOT NULL Number
10 GPES_REASON_DISCHR Character(2) VARCHAR2(2) NOT NULL Reason Discharge
01=Healing
02=Decease
03=Medical Inspection
04=Incapacity Proposal
05=Time Limit Exhaustion
06=Work Habitual
07=Absence
10=Control INSS (12 months)
17=Recovery Professional Capacity
18=Contracts Formation Absence
11 GPES_AREA_ID_CODE Character(11) VARCHAR2(11) NOT NULL Area Identifier Code
12 GPES_SENDING_ID Character(10) VARCHAR2(10) NOT NULL Sending ID
13 GPES_STATE_REG Character(2) VARCHAR2(2) NOT NULL State where the phisician is registered

Prompt Table: GPES_STATE_TBL

14 NUMERIC_CD Character(2) VARCHAR2(2) NOT NULL Numeric Code

Prompt Table: GPES_STATE_TBL

15 GPES_PHYSICIAN_ID Character(6) VARCHAR2(6) NOT NULL Physician ID
16 GPES_CONFIRM_SEND Character(1) VARCHAR2(1) NOT NULL Confirmed Send
1=Included in FDI
N=No Communicated
Y=FDI Sent Confirmed

Y/N Table Edit

Default Value: N

17 GPES_FDI_MODIFIED Character(1) VARCHAR2(1) NOT NULL Modified

Y/N Table Edit

Default Value: N