GPES_FIE_EE (SQL Table)	Index Back
FIE file employee data FIE file employee data. Loaded data from FIE flat file according to a flat file setup. Storing only the flat file fields especified in the flat file setup. FIE master record. One row several fields.

GPES_FIE_EE

(SQL Table)

FIE file employee data

FIE file employee data. Loaded data from FIE flat file according to a flat file setup. Storing only the flat file fields especified in the flat file setup. FIE master record. One row several fields.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key

2 GPES_FILE_DATE Date(10) DATE File Date

3 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

6 GPES_ABS_BGNDT Date(10) DATE Absence begin date

7 GPES_FIE_SEGMENT Character(3) VARCHAR2(3) NOT NULL FIE Segment
AYN=AYN - Employee Name
CIT=CIT - Continuation IT
DAF=DAF - Affiliation Data
DIP=DIP - Permanent Disb Data
DIT=DIT - Temporary Disb Data
DOP=DOP - Other Subsidy Data
EMP=EMP - Company Identification
ETF=ETF - Final Segment
ETI=ETI - File Identification
IT2=IT2 - Other IT Data 2
ITD=ITD - Disability Direct Pay
JUB=JUB - Retirement Data
NAC=NAC - Birth
OIT=OIT - Other IT Data
RZS=RZS - Company Name
TRA=TRA - Employee Identification

8 GPES_SUBSIDY_TYPE Character(3) VARCHAR2(3) NOT NULL Subsidy type
DIP=DIP - Permanent Disb Data
DIT=DIT - Temporary Disb Data
DOP=DOP - Other Subsidy Data
ITD=ITD - Disability Direct Pay
JUB=JUB - Retirement Data
NAC=NAC - Birth
OIT=OIT - Other IT Data

9 GPES_FILE_RECORD Character(90) VARCHAR2(90) NOT NULL Imported file record

10 GPES_SSN_EMPLOYEE Character(12) VARCHAR2(12) NOT NULL Employee Social Security Number

11 ORIG_BEGIN_DT Date(10) DATE original begin date

12 GPES_ABS_ENDDT Date(10) DATE Absence end date

13 GPES_ABS_TYPE Character(3) VARCHAR2(3) NOT NULL Absence type
ACC=Industrial Accident
CUI=Minors (Serious illness)
DIS=Temporary Disability
MAT=Maternity
RSK=Risk on Pregnancy

14 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
Prompt Table: GP_ABS_TYPE

15 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)

16 GPES_FDI_DUR_TYP Character(1) VARCHAR2(1) NOT NULL Sickness duration type
1=Very short
2=Short
3=Medium
4=Long

17 GPES_CARENCE_IND Character(1) VARCHAR2(1) NOT NULL Carence Indicator

18 GPES_SUBSIDY_BASE Number(19,6) DECIMAL(18,6) NOT NULL Subsidy base

19 BIRTHDATE Date(10) DATE Date of Birth

20 GPES_ERRORS Character(1) VARCHAR2(1) NOT NULL Errors detail link

21 GPES_ABS_SPC_SIT Character(2) VARCHAR2(2) NOT NULL absence reason
01=Special Situation 1
02=Special Situation 2
03=Special Situation 3
04=Special Situation 4

22 ERROR_TEXT Long Character CLOB Error Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SOCS_AUTH_KEY_ESP	Character(8)	VARCHAR2(8) NOT NULL	Authorization Key
2	GPES_FILE_DATE	Date(10)	DATE	File Date
3	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
6	GPES_ABS_BGNDT	Date(10)	DATE	Absence begin date
7	GPES_FIE_SEGMENT	Character(3)	VARCHAR2(3) NOT NULL	FIE Segment AYN=AYN - Employee Name CIT=CIT - Continuation IT DAF=DAF - Affiliation Data DIP=DIP - Permanent Disb Data DIT=DIT - Temporary Disb Data DOP=DOP - Other Subsidy Data EMP=EMP - Company Identification ETF=ETF - Final Segment ETI=ETI - File Identification IT2=IT2 - Other IT Data 2 ITD=ITD - Disability Direct Pay JUB=JUB - Retirement Data NAC=NAC - Birth OIT=OIT - Other IT Data RZS=RZS - Company Name TRA=TRA - Employee Identification
8	GPES_SUBSIDY_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Subsidy type DIP=DIP - Permanent Disb Data DIT=DIT - Temporary Disb Data DOP=DOP - Other Subsidy Data ITD=ITD - Disability Direct Pay JUB=JUB - Retirement Data NAC=NAC - Birth OIT=OIT - Other IT Data
9	GPES_FILE_RECORD	Character(90)	VARCHAR2(90) NOT NULL	Imported file record
10	GPES_SSN_EMPLOYEE	Character(12)	VARCHAR2(12) NOT NULL	Employee Social Security Number
11	ORIG_BEGIN_DT	Date(10)	DATE	original begin date
12	GPES_ABS_ENDDT	Date(10)	DATE	Absence end date
13	GPES_ABS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Absence type ACC=Industrial Accident CUI=Minors (Serious illness) DIS=Temporary Disability MAT=Maternity RSK=Risk on Pregnancy
14	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type Prompt Table: GP_ABS_TYPE
15	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)
16	GPES_FDI_DUR_TYP	Character(1)	VARCHAR2(1) NOT NULL	Sickness duration type 1=Very short 2=Short 3=Medium 4=Long
17	GPES_CARENCE_IND	Character(1)	VARCHAR2(1) NOT NULL	Carence Indicator
18	GPES_SUBSIDY_BASE	Number(19,6)	DECIMAL(18,6) NOT NULL	Subsidy base
19	BIRTHDATE	Date(10)	DATE	Date of Birth
20	GPES_ERRORS	Character(1)	VARCHAR2(1) NOT NULL	Errors detail link
21	GPES_ABS_SPC_SIT	Character(2)	VARCHAR2(2) NOT NULL	absence reason 01=Special Situation 1 02=Special Situation 2 03=Special Situation 3 04=Special Situation 4
22	ERROR_TEXT	Long Character	CLOB	Error Text