GPES_RC_TAX(SQL Table) |
Index Back |
---|---|
Run Control for Tax ProcessRun 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 |