GPCHTXX26_TMP(SQL Table) |
Index Back |
|---|---|
XML Correction DataThe GPCHTX2X.SQR process uses this record to retrieve the tax data in case of retro and include dummy rows for retro Hire/Termination or change of Canton. These data are printed under |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | GPCH_SI_PROV_CD |
Character(6) | VARCHAR2(6) NOT NULL | Provider Code |
| 5 | GPCH_AL_CPAY_ENDDT |
Date(10) | DATE | Current Pay End Date |
| 6 | SEG_BGN_DT |
Date(10) | DATE | Payee Process Segment's Begin Date |
| 7 | SEG_END_DT |
Date(10) | DATE | Payee Process Segment's End Date |
| 8 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 9 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 10 | END_DT | Date(10) | DATE | end date |
| 11 | HIRE_DT | Date(10) | DATE | First Start Date |
| 12 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 13 | REG_TEMP | Character(1) | VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular T=Temporary |
| 14 | GPCH_TX_CANTON | Character(2) | VARCHAR2(2) NOT NULL | Canton |
| 15 | GPCH_RP_CHAR03 | Character(8) | VARCHAR2(8) NOT NULL | Character 03 |
| 16 | GPCH_RP_CHAR04 | Character(6) | VARCHAR2(6) NOT NULL | Character 04 |
| 17 | MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law D=Divorced E=Separated H=Head of Household L=DissDeclLost Civil Partner M=Married P=Civil Partnership S=Single T=Surviving Civil Partner U=Unknown V=Dissolved Civil Partnership W=Widowed |
| 18 | GPCH_TX_VILLAGE_CD | Character(4) | VARCHAR2(4) NOT NULL | Municipality Code |
| 19 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 20 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 21 | ACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 22 | GPCH_RP_CHAR01 | Character(6) | VARCHAR2(6) NOT NULL | Character 01 |
| 23 | GPCH_RP_FROMDT1 | Date(10) | DATE | From Date 1 |
| 24 | GPCH_RP_CHAR02 | Character(8) | VARCHAR2(8) NOT NULL | Character 02 |
| 25 | GPCH_RP_FROMDT2 | Date(10) | DATE | From Date 2 |
| 26 | COUNTRY_FROM | Character(3) | VARCHAR2(3) NOT NULL | From Country |
| 27 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 28 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 29 | CB_FREQ_CHE | Character(1) | VARCHAR2(1) NOT NULL |
Cross Border Return Frequency
D=Daily W=Weekly |
| 30 | GPCH_TX_TRF_CD | Character(10) | VARCHAR2(10) NOT NULL | Withholding Tax Tariff |
| 31 | GPCH_STX_BASE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 13 |
| 32 | GPCH_STX_CONTRB | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Tax Contribution |
| 33 | GPCH_STX_DAYS | Signed Number(5,0) | DECIMAL(4) NOT NULL | Source Tax Days |
| 34 | GPCH_STX_LOOKUP | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Tax Lookup |
| 35 | GPCH_STX_PCT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Tax Percentage |
| 36 | GPCH_STX_REFUND | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Tax Contribution Refund |
| 37 | GPCH_STX_IRREGULAR | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Source Tax Irregular Amount |
| 38 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |