| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
|
| 5 |
GPES_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 6 |
GPES_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month
|
| 7 |
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
|
| 8 |
GPES_YEAR_RECALC |
Number(4,0) |
SMALLINT NOT NULL |
Retro year
|
| 9 |
GPES_MONTH_RECALC |
Number(2,0) |
SMALLINT NOT NULL |
Retro month
|
| 10 |
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
|
| 11 |
GPES_REUSE_PRV_BS |
Character(1) |
VARCHAR2(1) NOT NULL |
Reuse Previous Month Bases for Creta reporting
|
| 12 |
XML_TEMPLATE_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Template type
|
| 13 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 14 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 15 |
SOCS_AUTH_KEY_ESP |
Character(8) |
VARCHAR2(8) NOT NULL |
Authorization Key
|
| 16 |
XMLFILE_ID |
Character(50) |
VARCHAR2(50) NOT NULL |
XML File ID
|
| 17 |
GPES_FILE_PATH |
Character(250) |
VARCHAR2(250) NOT NULL |
Output / Input file path
|
| 18 |
GPES_FILE_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Name of a file, according to the process scheduler server.
|
| 19 |
GPES_CRT_DOC_TMPLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Liquidation Doc Template Type
- D Request of a Draft
- B XML of Bases
- R Response XML
- S Slices XML
- C Calculations XML
- X Request of Slices
- Y Request of Calculation
- Z Request of Confirmation
B=XML of Bases
C=Calculation Details
D=Request of a Draft
R=Response
S=Employees Slices
X=Request of Slices
Y=Request of Calculations
Z=Request of Confirmation
|
| 20 |
GPES_CRT_VRF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
CRET@ Social Security calcullation response verification type:
S - Slices
C - Calculation
C=Calculation
S=Slices
|
| 21 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Exist
|