GPES_SSTC_AET

(SQL Table)
Index Back

TCs Generation AET

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.