GPUS_TAX_LOC_CDSTATEPrompt Table: GPUS_STATE_VW
EFFDTDefault Value: %date
GPUS_LOCALITYGPUS_LCLTAX_VW(SQL View) |
Index Back |
|---|---|
Local Tax ViewLocal Tax View |
| SELECT A.GPUS_TAX_LOC_CD , B.STATE , B.EFFDT , B.GPUS_LOCALITY , B.GPUS_COUNTY , B.GPUS_RES_TAXRT, B.GPUS_ALT_TAX_RATES FROM PS_GPUS_TAXLOC_DTL A , PS_GPUS_LOCAL_TAX B WHERE B.STATE = A.STATE AND B.GPUS_LOCALITY = A.GPUS_LOCALITY AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_TAX_LOC_CD |
Character(10) | VARCHAR2(10) NOT NULL | Tax Location |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: GPUS_STATE_VW |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | GPUS_LOCALITY |
Character(3) | VARCHAR2(3) NOT NULL | locality |
| 5 | GPUS_COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 6 | GPUS_RES_TAXRT | Number(7,3) | DECIMAL(6,3) NOT NULL | Resident Tax Rate |
| 7 | GPUS_ALT_TAX_RATES | Character(1) | VARCHAR2(1) NOT NULL | Use Alternate Tax Rates for County Taxes |