EFFDTDefault Value: %date
GPUS_EIC_QUAL_CHLD0=0
1=1
2=2
3=3
GPUS_WI_EIC_VW(SQL View) |
Index Back |
|---|---|
Wisconsin State EIC RatesWisconsin State EIC Rates |
| SELECT EFFDT ,%Substring(%NumToChar(GPUS_TAX_GRS),1,1) ,GPUS_TAX_PCT FROM PS_GPUS_TAX_ST_BRK WHERE STATE = 'WI' AND GPUS_TAX_BRK_TYP = '05' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 2 | GPUS_EIC_QUAL_CHLD |
Character(1) | VARCHAR2(1) NOT NULL |
Earned Income Credit Qualifying Children
0=0 1=1 2=2 3=3 |
| 3 | GPUS_TAX_PCT | Number(7,3) | DECIMAL(6,3) NOT NULL | Tax Percent |