GPCHTXX20_TMP(SQL Table) |
Index Back |
|---|---|
Temp Record for GPCHTX02Temp Record for GPCHTX02 |
| # | 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_RP_AMOUNT1 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 32 | GPCH_RP_AMOUNT2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 33 | GPCH_RP_AMOUNT3 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate Result Value |
| 34 | GPCH_RP_AMOUNT10 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 10 |
| 35 | GPCH_RP_AMOUNT11 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 11 |
| 36 | GPCH_RP_AMOUNT12 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 12 |
| 37 | GPCH_RP_AMOUNT13 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 13 |
| 38 | GPCH_RP_AMOUNT14 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 14 |
| 39 | GPCH_RP_AMOUNT15 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 15 |
| 40 | GPCH_RP_AMOUNT16 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 16 |
| 41 | GPCH_RP_AMOUNT17 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 17 |
| 42 | GPCH_RP_AMOUNT18 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 18 |
| 43 | GPCH_RP_AMOUNT19 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Amount 19 |
| 44 | GPCH_RP_CHAR05 | Character(6) | VARCHAR2(6) NOT NULL | Character 05 |
| 45 | GPCH_TX_GRANTCODE | Character(1) | VARCHAR2(1) NOT NULL | GP Switzerland Grant Tax At Source Code |
| 46 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |