GPES_NRP_ANH_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
3	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	BGN_DT	Date(10)	DATE	Begin Date
7	PIN_TAKE_NUM	Number(8,0)	INTEGER NOT NULL	Absence Take
8	END_DT	Date(10)	DATE	end date
9	GPES_SICK_DATE	Date(10)	DATE	Date to Sick note
10	GPES_FDI_NOTE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	FDI note type ACC=Child Care ACM=Maternity ACP=Paternity ARE=Risk in Pregnancy ARL=Risk in Lactancy CC=Child care DE=Economic Data MT=Maternity/Paternity PA=Medical Discharge PB=Sick Note PC=Confirmation Sick Note RE=Risk pregnancy or lactancy
11	GPES_REASON_DISCHR	Character(2)	VARCHAR2(2) NOT NULL	Reason Discharge 01=Healing 02=Decease 03=Medical Inspection 04=Incapacity Proposal 05=Time Limit Exhaust 06=Work Habitual 07=Absence 10=Control INSS 12 months 17=Recovery Professional Capacity 18=Formation Contracts 20=Maternity Communicated by SPS 53=Discharge Inspection INSS 55=Incapacity Proposal b/f 12 Mnt 56=Death 57=Discharge MATEPSS (art 128)
12	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
13	GPES_FDI_NUMBER	Number(2,0)	SMALLINT NOT NULL	Number
14	GPES_AREA_ID_CODE	Character(11)	VARCHAR2(11) NOT NULL	Area Identifier Code
15	GPES_SENDING_ID	Character(10)	VARCHAR2(10) NOT NULL	Sending ID
16	GPES_STATE_REG	Character(2)	VARCHAR2(2) NOT NULL	State where the phisician is registered
17	NUMERIC_CD	Character(2)	VARCHAR2(2) NOT NULL	Numeric Code
18	GPES_PHYSICIAN_ID	Character(6)	VARCHAR2(6) NOT NULL	Physician ID
19	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
20	GPES_FDI_MODIFIED	Character(1)	VARCHAR2(1) NOT NULL	Modified Y/N Table Edit
21	GPES_FDI_SRC_ENT	Character(1)	VARCHAR2(1) NOT NULL	Soruce entity 1=SPS 2=INSS/ISM 3=Insurance Company
22	GPES_FDI_SS_CARD	Character(22)	VARCHAR2(22) NOT NULL	Social Security card number
23	GPES_FDI_DUR_TYP	Character(1)	VARCHAR2(1) NOT NULL	Sickness duration type 1=Very short 2=Short 3=Medium 4=Long
24	GPES_FDI_SICK_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Sickness type. 1=Minor 2=Serious 3=Very serious
25	GPES_FDI_ASIST_TYP	Character(1)	VARCHAR2(1) NOT NULL	Assistance type. A=Outpatient H=Hospital
26	GPES_FDI_NXTMED_RV	Date(10)	DATE	Next medical revision
27	GPES_LST_SICK_LOC	Character(2)	VARCHAR2(2) NOT NULL	Last sickness in the location flag
28	GPES_SICK_365_DT	Date(10)	DATE	Date that the absence event is 365 days long.