GPCHTXX26_TMPVW(SQL View) |
Index Back |
|---|---|
Total Segment AmtsThe GPCHTX2X.SQR process uses this record to calculate the total amounts for Source Tax Base, Source Tax Contribution and Source Tax Refund in case of several segments in the month. These data are printed under 'old' and 'new' correction nodes in Swissdec XML file. |
| SELECT PROCESS_INSTANCE , EMPLID , EMPL_RCD , GPCH_SI_PROV_CD , GPCH_AL_CPAY_ENDDT , SEG_BGN_DT , SEG_END_DT , PRD_END_DT , BEGIN_DT , END_DT , HIRE_DT , TERMINATION_DT , REG_TEMP , GPCH_TX_CANTON , GPCH_RP_CHAR03 , GPCH_RP_CHAR04 , MAR_STATUS , GPCH_TX_VILLAGE_CD , SETID , LOCATION , ACTION , GPCH_RP_CHAR01 , GPCH_RP_FROMDT1 , GPCH_RP_CHAR02 , GPCH_RP_FROMDT2 , COUNTRY_FROM , COUNTRY , STATE , CB_FREQ_CHE , GPCH_TX_TRF_CD , GPCH_STX_BASE , GPCH_STX_CONTRB , GPCH_STX_DAYS , GPCH_STX_LOOKUP , GPCH_STX_PCT , GPCH_STX_REFUND , STATUS FROM %Table(GPCHTXX26_TMP) |
| # | 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 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |