| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
GPES_MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 4 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 5 |
GPES_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
Output / Input file path
|
| 6 |
GPES_FILE_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Name of a file, according to the process scheduler server.
|
| 7 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 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
L31=Regular and Vacations
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 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
GPES_SS_WC_VW
|
| 11 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 12 |
TEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Test
Y/N Table Edit
|
| 13 |
SOCS_PAY_TYPE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment
0=Cash
C=Direct Debit
V=Electronic Payment
Default Value: 0
|
| 14 |
GPES_OOD_COMM_SUR |
Number(2,0) |
SMALLINT NOT NULL |
FAN surcharge because of an out of date communication
|
| 15 |
GPES_OOD_PYMT_SUR |
Number(2,0) |
SMALLINT NOT NULL |
FAN surcharge because of an out of date payment
|
| 16 |
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.
Y/N Table Edit
Default Value: N
|
| 17 |
GPES_TC2_MATH_VALD |
Character(1) |
VARCHAR2(1) NOT NULL |
FAN file mathematical validation
Y/N Table Edit
Default Value: N
|
| 18 |
GPES_TC2_MATH_TOLR |
Number(4,2) |
DECIMAL(3,2) NOT NULL |
Mathematical validation tolerance
|
| 19 |
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
Default Value: 00
|
| 20 |
GPES_EXCL_NEG_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Exclude negative base/contribuiton amounts option
A=Exclude Full Employee
N=Exclude Only Negative
Default Value: A
|