| # |
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 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
Prompt Table:
%RECNAME_EDIT
|
| 4 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Default Value: ESP
Prompt Table:
COUNTRY_TBL
|
| 5 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table:
GPES_REP_PAYENT
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP1_VW
|
| 7 |
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
|
| 8 |
GPES_MONTHCD_FROM |
Character(2) |
VARCHAR2(2) NOT NULL |
Month from
|
| 9 |
YEARCD |
Character(4) |
VARCHAR2(4) NOT NULL |
Calendar Year
|
| 10 |
GPES_FILE_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
Name of a file, according to the process scheduler server.
|
| 11 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 12 |
GPES_TAX_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.
Prompt Table:
GPES_TAX_LOCATN
|
| 13 |
PAY_BEGIN_DT |
Date(10) |
DATE |
Pay Period Begin Date
|
| 14 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 15 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 16 |
CONTACT_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Contact Name
|
| 17 |
GPES_CONTACT_PHONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Contact phone number
|
| 18 |
GPES_AEAT_DEVICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Device code
C=Compact Disk
D=Floppy Disk
D=Floppy Disk
T=Electronic Transmission
Default Value: D
|
| 19 |
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/Surcharge Bases Increa
L91=Retro w/Surchage new Slices
Default Value: L00
|
| 20 |
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
|
| 21 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table:
GPES_SS_WC_VW
|
| 22 |
CAL_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 23 |
GPES_CAL_PRD_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Calendar Period ID
|
| 24 |
TEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Test
Y/N Table Edit
|
| 25 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 26 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
Prompt Table:
LOCATION_TBL
|
| 27 |
SIGNATURE_CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Signature City
|
| 28 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table:
PERSON
|
| 29 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 30 |
RERUN_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if the extract process should be rerun because of a confirm/unconfirm process.
N=NO
Y=YES
Default Value: N
|
| 31 |
GPES_FILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank file definition ID
Prompt Table:
GPES_BANK_FILE
|
| 32 |
GPES_PATH_NAME |
Character(250) |
VARCHAR2(250) NOT NULL |
File path
|
| 33 |
GPES_FILENAME |
Character(8) |
VARCHAR2(8) NOT NULL |
FDI File Name or EFT File Name
Prompt Table:
GPES_FILE_MSF_V
|
| 34 |
DEBIT_DT |
Date(10) |
DATE |
Debit Date
Default Value: %DATE
|
| 35 |
PYMT_DT |
Date(10) |
DATE |
Payment Date
|
| 36 |
SRC_BANK_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Source Bank ID
Prompt Table:
GPES_BNK_SRC_VW
|
| 37 |
RUN_CNTL_ID_EO |
Character(30) |
VARCHAR2(30) NOT NULL |
Used by the Currency Conversion Utility in EO_RC_AUD1_VW which is the online interface with SQR Report EO002.SQR - Audit Report.
Prompt Table:
GPES_FILE_MSD_V
|
| 38 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
Prompt Table:
GPES_FILE_MSG_V
|
| 39 |
GPES_SRC_COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Source company
Prompt Table:
COMPANY_TBL
|
| 40 |
GPES_COMMENTS_350 |
Long Character(350) |
VARCHAR2(350) |
Comments text 350 characters long
|