GPES_SSTC_AET(SQL Table) |
Index Back |
---|---|
TCs Generation AETTCs 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. |