GPES_SSTC_AET (SQL Table)	Index Back
TCs Generation AET TCs Generation AET

GPES_SSTC_AET

(SQL Table)

TCs Generation AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

5 SOCS_AUTH_KEY_ESP Character(8) VARCHAR2(8) NOT NULL Authorization Key
Prompt Table: SOCS_SETHD_VW

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

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

8 GPES_SSTC_PYMT_OPT Character(3) VARCHAR2(3) NOT NULL Payment Type. This field is used to generate the FAN File.
L00=Regular
L02=Litigation Salary
L03=Retroactivity wo/Surcharge
L09=Retroactivity w/Surcharge
L13=Vacations (L13)
L31=Regular and Vacations (L13)
L99=Full
Default Value: L00

9 GPES_SSTC_OUTOF_DT Character(1) VARCHAR2(1) NOT NULL Out of date indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File.
0=Payment in Period
3=Payment Out of Period
Default Value: 0

10 SOCS_PAY_TYPE_ESP Character(1) VARCHAR2(1) NOT NULL Payment
0=Cash
C=Direct Debit
V=Electronic Payment

11 GPES_FILE_PATH Character(250) VARCHAR2(250) NOT NULL Output / Input file path

12 GPES_FILE_NAME Character(250) VARCHAR2(250) NOT NULL Name of a file, according to the process scheduler server.

13 GPES_OOD_COMM_SUR Number(2,0) SMALLINT NOT NULL FAN surcharge because of an out of date communication

14 GPES_OOD_PYMT_SUR Number(2,0) SMALLINT NOT NULL FAN surcharge because of an out of date payment

15 GPES_SPLIT_RTR_PMT Character(1) VARCHAR2(1) NOT NULL Sometimes it is required to split grouped L03 retro payments months in separate months. I.e. Change of contributing percentage in the middle of the year. This is is a flag to instruct the FAN file generation process to group (default behviour) or not group L03 retro payments.

16 GPES_TC2_MATH_VALD Character(1) VARCHAR2(1) NOT NULL FAN file mathematical validation

17 GPES_TC2_MATH_TOLR Number(4,2) DECIMAL(3,2) NOT NULL Mathematical validation tolerance

18 GPES_PAY_CNTB_FLG Character(2) VARCHAR2(2) NOT NULL Flag to instruct the winsuite to pay to Social Security either all employee and company contributions, or only employee contributions.
00=Total Contribution
01=EEs Total Contribution

19 GPES_EXCL_NEG_OPT Character(1) VARCHAR2(1) NOT NULL Exclude negative base/contribuiton amounts option
A=Exclude Full Employee
N=Exclude Only Negative

20 GP_ELN_SET Character(15) VARCHAR2(15) NOT NULL Element Set

21 GPES_SS_CRA_CORR Character(1) VARCHAR2(1) NOT NULL Flag to state the CRA report was sent in order in order to generate another file to correct such a previous sent file.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
5	SOCS_AUTH_KEY_ESP	Character(8)	VARCHAR2(8) NOT NULL	Authorization Key Prompt Table: SOCS_SETHD_VW
6	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
7	GPES_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
8	GPES_SSTC_PYMT_OPT	Character(3)	VARCHAR2(3) NOT NULL	Payment Type. This field is used to generate the FAN File. L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L09=Retroactivity w/Surcharge L13=Vacations (L13) L31=Regular and Vacations (L13) L99=Full Default Value: L00
9	GPES_SSTC_OUTOF_DT	Character(1)	VARCHAR2(1) NOT NULL	Out of date indicator. This field is used to populate the GP Write Array, which is used to generate the FAN File. 0=Payment in Period 3=Payment Out of Period Default Value: 0
10	SOCS_PAY_TYPE_ESP	Character(1)	VARCHAR2(1) NOT NULL	Payment 0=Cash C=Direct Debit V=Electronic Payment
11	GPES_FILE_PATH	Character(250)	VARCHAR2(250) NOT NULL	Output / Input file path
12	GPES_FILE_NAME	Character(250)	VARCHAR2(250) NOT NULL	Name of a file, according to the process scheduler server.
13	GPES_OOD_COMM_SUR	Number(2,0)	SMALLINT NOT NULL	FAN surcharge because of an out of date communication
14	GPES_OOD_PYMT_SUR	Number(2,0)	SMALLINT NOT NULL	FAN surcharge because of an out of date payment
15	GPES_SPLIT_RTR_PMT	Character(1)	VARCHAR2(1) NOT NULL	Sometimes it is required to split grouped L03 retro payments months in separate months. I.e. Change of contributing percentage in the middle of the year. This is is a flag to instruct the FAN file generation process to group (default behviour) or not group L03 retro payments.
16	GPES_TC2_MATH_VALD	Character(1)	VARCHAR2(1) NOT NULL	FAN file mathematical validation
17	GPES_TC2_MATH_TOLR	Number(4,2)	DECIMAL(3,2) NOT NULL	Mathematical validation tolerance
18	GPES_PAY_CNTB_FLG	Character(2)	VARCHAR2(2) NOT NULL	Flag to instruct the winsuite to pay to Social Security either all employee and company contributions, or only employee contributions. 00=Total Contribution 01=EEs Total Contribution
19	GPES_EXCL_NEG_OPT	Character(1)	VARCHAR2(1) NOT NULL	Exclude negative base/contribuiton amounts option A=Exclude Full Employee N=Exclude Only Negative
20	GP_ELN_SET	Character(15)	VARCHAR2(15) NOT NULL	Element Set
21	GPES_SS_CRA_CORR	Character(1)	VARCHAR2(1) NOT NULL	Flag to state the CRA report was sent in order in order to generate another file to correct such a previous sent file.