GPCH_TX_PRY_OVR

(SQL Table)
Index Back

Source Tax Data CHE

Source Tax Data CHE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
6 GPCH_RP_CHAR04 Character(6) VARCHAR2(6) NOT NULL Character 04
7 GPCH_TX_SD_EMA Character(2) VARCHAR2(2) NOT NULL SourceTax Event.

Prompt Table: GPCH_TX_SDREASO

8 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton
9 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code
10 GPCH_TX_TRF_CD Character(10) VARCHAR2(10) NOT NULL Withholding Tax Tariff
11 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
12 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
13 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
14 GPCH_TX_STAX_CANTN Character(2) VARCHAR2(2) NOT NULL Withholding Tax Canton
15 GPCH_TX_VILLAGE_L Character(4) VARCHAR2(4) NOT NULL Village Code
16 GPCH_RP_CHAR02 Character(8) VARCHAR2(8) NOT NULL Character 02
17 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
18 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
19 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
20 GPCH_RP_AMOUNT7 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
21 GPCH_RP_AMOUNT8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
22 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
23 GPCH_RP_REMARKS Long Character CLOB Remarks