GPES_SSTC_EDL_W (SQL Table)	Index Back
TC EDL data Work table to be used just to populate data within a page grid. Nothing to be saved in this table.

GPES_SSTC_EDL_W

(SQL Table)

TC EDL data

Work table to be used just to populate data within a page grid. Nothing to be saved in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

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

3 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year

4 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

5 GPES_SSTC_PAYMNT Character(3) VARCHAR2(3) NOT NULL Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File.
L00=Regular
L02=Litigation Salary
L03=Retroactivity wo/Surcharge
L04=Reductions Payback
L09=Retroactivity w/Surcharge
L13=Vacations
L90=Retro w/Surch. Base Incr.
L91=Retro w/Surch. New Slices
V03=Retro wo/ Surcharge Vacations
V90=Retro w/ Surcharge Vacations

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

7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID

8 SOC_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Social Security Risk Code

9 GPES_SEC_RISK_CODE Character(3) VARCHAR2(3) NOT NULL Social Security secondary risk code

10 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

11 GPES_SS_WRK_GRP_CD Character(2) VARCHAR2(2) NOT NULL Social Security work group. Equivalent to SOC_SEC_WRK_GRP_CD.

12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

13 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name

14 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

15 GPES_SSTC_DAYS_HRS Signed Number(4,0) DECIMAL(3) NOT NULL Amount of Days or Hours (depending on Hours Flag). This field is used to populate the GP Write Array, which is used to generate the FAN File.

16 GPES_SSTC_STRIKE Character(1) VARCHAR2(1) NOT NULL Strike indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.

17 GPES_SSTC_MULTIJOB Character(1) VARCHAR2(1) NOT NULL Multijob indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.

18 GPES_SSTC_LGL_CUST Character(1) VARCHAR2(1) NOT NULL Legal custody indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.

19 GPES_SSTC_MONTHLY Character(1) VARCHAR2(1) NOT NULL Monthly indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.

20 GPES_SSTC_NOSALARY Character(1) VARCHAR2(1) NOT NULL No salary. This field is used to populate the GP Write Array, which is used to generate the FAN File.

21 SOCS_DAY_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Days Type
0=Regular

22 GPES_SSTC_OTHERS Character(1) VARCHAR2(1) NOT NULL Others flag. This field is used to populate the GP Write Array, which is used to generate the FAN File.

23 GPES_SSTC_MT Character(1) VARCHAR2(1) NOT NULL Maternity Flag

24 GPES_SSTC_CONTR_7D Character(1) VARCHAR2(1) NOT NULL Contracts with duration of less than seven days

25 GPES_SSTC_SPC_CNTB Character(1) VARCHAR2(1) NOT NULL Special contribution

26 GPES_SSTC_ELEMENT Character(4) VARCHAR2(4) NOT NULL This code indicates if the element represents a base or a deduction. This field is used to populate the GP Write Array, which is used to generate the FAN File.

27 GPES_SSTC_AMOUNT Signed Number(11,2) DECIMAL(9,2) NOT NULL Amount of the element.(Entire part). This field is used to populate the GP Write Array, which is used to generate the FAN File.

28 GPES_SSTC_PCT_ENT Number(6,0) INTEGER NOT NULL Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.

29 GPES_SSTC_PCT_DEC Number(6,0) INTEGER NOT NULL Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.

30 GPES_SSTC_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.

31 GPES_SSTC_CT_ER Signed Number(15,2) DECIMAL(13,2) NOT NULL Employer Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.

32 GPES_SSTC_RES_TYPE Character(2) VARCHAR2(2) NOT NULL Type or resolution. This field is used to populate the GP Write Array, which is used to generate the FAN File.
1=IT
10=Multiple-Employment
11=Structural Overtime
2=Reduction
3=Bonification
6=Partial Unemployment

33 GPES_SSTC_RESLN_DT Date(10) DATE Resolution Date in case of Reduction/MultiJob. This field is used to populate the GP Write Array, which is used to generate the FAN File.

34 GPES_SSTC_BEGIN_DT Date(10) DATE Start Date for employee situations. This field is used to populate the GP Write Array, which is used to generate the FAN File.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	SSN_EMPLOYER	Character(13)	VARCHAR2(13) NOT NULL	Employer Social Security number
3	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
4	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
5	GPES_SSTC_PAYMNT	Character(3)	VARCHAR2(3) NOT NULL	Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File. L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L04=Reductions Payback L09=Retroactivity w/Surcharge L13=Vacations L90=Retro w/Surch. Base Incr. L91=Retro w/Surch. New Slices V03=Retro wo/ Surcharge Vacations V90=Retro w/ Surcharge Vacations
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	NATIONAL_ID	Character(20)	VARCHAR2(20) NOT NULL	National ID
8	SOC_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Social Security Risk Code
9	GPES_SEC_RISK_CODE	Character(3)	VARCHAR2(3) NOT NULL	Social Security secondary risk code
10	CONTRACT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Contract Type
11	GPES_SS_WRK_GRP_CD	Character(2)	VARCHAR2(2) NOT NULL	Social Security work group. Equivalent to SOC_SEC_WRK_GRP_CD.
12	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
13	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
14	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
15	GPES_SSTC_DAYS_HRS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Amount of Days or Hours (depending on Hours Flag). This field is used to populate the GP Write Array, which is used to generate the FAN File.
16	GPES_SSTC_STRIKE	Character(1)	VARCHAR2(1) NOT NULL	Strike indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
17	GPES_SSTC_MULTIJOB	Character(1)	VARCHAR2(1) NOT NULL	Multijob indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
18	GPES_SSTC_LGL_CUST	Character(1)	VARCHAR2(1) NOT NULL	Legal custody indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
19	GPES_SSTC_MONTHLY	Character(1)	VARCHAR2(1) NOT NULL	Monthly indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
20	GPES_SSTC_NOSALARY	Character(1)	VARCHAR2(1) NOT NULL	No salary. This field is used to populate the GP Write Array, which is used to generate the FAN File.
21	SOCS_DAY_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Days Type 0=Regular
22	GPES_SSTC_OTHERS	Character(1)	VARCHAR2(1) NOT NULL	Others flag. This field is used to populate the GP Write Array, which is used to generate the FAN File.
23	GPES_SSTC_MT	Character(1)	VARCHAR2(1) NOT NULL	Maternity Flag
24	GPES_SSTC_CONTR_7D	Character(1)	VARCHAR2(1) NOT NULL	Contracts with duration of less than seven days
25	GPES_SSTC_SPC_CNTB	Character(1)	VARCHAR2(1) NOT NULL	Special contribution
26	GPES_SSTC_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	This code indicates if the element represents a base or a deduction. This field is used to populate the GP Write Array, which is used to generate the FAN File.
27	GPES_SSTC_AMOUNT	Signed Number(11,2)	DECIMAL(9,2) NOT NULL	Amount of the element.(Entire part). This field is used to populate the GP Write Array, which is used to generate the FAN File.
28	GPES_SSTC_PCT_ENT	Number(6,0)	INTEGER NOT NULL	Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.
29	GPES_SSTC_PCT_DEC	Number(6,0)	INTEGER NOT NULL	Social Security Employee Percentage. This field houses the percentage that has to be aplied to a particular base for contibuting to the Social Security. This information is from the Employee perspective.
30	GPES_SSTC_CT_EE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
31	GPES_SSTC_CT_ER	Signed Number(15,2)	DECIMAL(13,2) NOT NULL	Employer Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
32	GPES_SSTC_RES_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Type or resolution. This field is used to populate the GP Write Array, which is used to generate the FAN File. 1=IT 10=Multiple-Employment 11=Structural Overtime 2=Reduction 3=Bonification 6=Partial Unemployment
33	GPES_SSTC_RESLN_DT	Date(10)	DATE	Resolution Date in case of Reduction/MultiJob. This field is used to populate the GP Write Array, which is used to generate the FAN File.
34	GPES_SSTC_BEGIN_DT	Date(10)	DATE	Start Date for employee situations. This field is used to populate the GP Write Array, which is used to generate the FAN File.