GPES_RC_TAX

(SQL Table)
Index Back

Run Control for Tax Process

Run Control for Spanish Tax Process

# 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

Default Value: 01

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_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

9 PAY_END_DT Date(10) DATE Pay Period End Date
10 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

11 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
12 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
13 GPES_CONTACT_PHONE Character(9) VARCHAR2(9) NOT NULL Contact phone number
14 GPES_CONTACT_CELL Character(9) VARCHAR2(9) NOT NULL Contact cellular number
15 GPES_CONTACT_EMAIL Character(50) VARCHAR2(50) NOT NULL Contact e-mail address
16 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: T

17 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

18 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

19 SIGNATURE_CITY Character(30) VARCHAR2(30) NOT NULL Signature City
20 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID

Prompt Table: PERS_SRCH_GBL

21 SIGNATURE_DT Date(10) DATE Signature Date
22 GPES_PYE_LIST Character(1) VARCHAR2(1) NOT NULL Payee select option
23 GPES_PYE_SELCT_OPT Character(1) VARCHAR2(1) NOT NULL Payee Select Option
A=All Payees
L=Listed Payees

Default Value: A

24 GPES_TAXMODEL Character(3) VARCHAR2(3) NOT NULL Tax report model. Indicates if the report model is quarterly (Model 110) or monthly (Model 111)
110=Quarterly
111=Monthly

Default Value: 111

25 GPES_QUARTER_CD Character(2) VARCHAR2(2) NOT NULL Quarter code
1T=First Quarter
2T=Second Quarter
3T=Third Quarter
4T=Fourth Quarter

Default Value: 1T

26 GPES_TAX_PAY_TYPE Character(1) VARCHAR2(1) NOT NULL Pay type for 110 report
D=Direct Debit
I=Cash
O=Debit

Default Value: I

27 GPES_110_DECL_TYPE Character(1) VARCHAR2(1) NOT NULL Declaration Type for 110 report
G=Tax Agency Account
I=Pay In
N=Negative
U=Direct Debit

Default Value: I

28 GPES_111_DECL_TYPE Character(1) VARCHAR2(1) NOT NULL Declaration Type for 111 report
G=Tax Agency Account
I=Pay In
N=Negative
U=Direct Debit

Default Value: I

29 GPES_COMMENTS_350 Long Character(350) VARCHAR2(350) Comments text 350 characters long
30 GPES_EMPL_INFO Character(2) VARCHAR2(2) NOT NULL Payee Type selection
B=All
N=Non-Resident Employee
P=Professional
R=Resident Employee

Default Value: B

31 GPES_HE_FORMAT Character(1) VARCHAR2(1) NOT NULL Device code

Y/N Table Edit

Default Value: N