GPCH_TX_CANTONEFFDTDefault Value: %date
GPCH_TX_TRF_CDF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
GPCH_TX_STAF_VW(SQL View) |
Index Back |
|---|---|
Source Tax Tarif View CHESwiss Source Tax Tarif for Prompt on Tarif codes |
| SELECT DISTINCT GPCH_TX_CANTON , EFFDT , GPCH_TX_TRF_CD , SEX FROM PS_GPCH_TX_RATES WHERE GPCH_TX_PCT_TYPE='0' AND (SEX = 'F' OR SEX = 'U') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_TX_CANTON |
Character(2) | VARCHAR2(2) NOT NULL | Canton |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | GPCH_TX_TRF_CD |
Character(10) | VARCHAR2(10) NOT NULL | Withholding Tax Tariff |
| 4 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |