GPUS_CO_ST_TAX(SQL Table) |
Index Back |
|---|---|
Company State Tax Data USACompany State Tax Data USA |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: GPUS_STATE_VW |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GPUS_SUT_EIN | Character(20) | VARCHAR2(20) NOT NULL | Employer Identification Number (SUT) |
| 6 | GPUS_SWT_EIN | Character(20) | VARCHAR2(20) NOT NULL | Employer Identification Number (SWT) |
| 7 | GPUS_SUT_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL |
Exempt from SUI
Y/N Table Edit |
| 8 | GPUS_SUT_EXP_RATE | Number(8,5) | DECIMAL(7,5) NOT NULL | SUT Experience rate (%) |
| 9 | GPUS_SUT_TAX_QTR | Character(2) | VARCHAR2(2) NOT NULL |
SUT Effective Tax Quarter
01=First Quarter 02=Second Quarter 03=Third Quarter 04=Fourth Quarter |
| 10 | GPUS_SUT_TAX_YR | Number(4,0) | SMALLINT NOT NULL | SUT Effective tax Year |
| 11 | GPUS_DIS_EXEMPT | Character(1) | VARCHAR2(1) NOT NULL |
Exempt from Employer Disability
Y/N Table Edit |
| 12 | GPUS_DIS_EXP_RATE | Number(8,5) | DECIMAL(7,5) NOT NULL | Disability Experience rate |
| 13 | GPUS_DIS_TAX_QTR | Character(2) | VARCHAR2(2) NOT NULL |
Disability Effective Tax Quarter
01=First Quarter 02=Second Quarter 03=Third Quarter 04=Fourth Quarter |
| 14 | GPUS_DIS_TAX_YR | Number(4,0) | SMALLINT NOT NULL | Disability Effective Tax Year |
| 15 | GPUS_BRANCH_CD | Number(2,0) | SMALLINT NOT NULL | Branch Code |
| 16 | GPUS_NR_DEC_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Non Resident Declaration Request
Y/N Table Edit |
| 17 | GPUS_SHI_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
State health insurance override
Y/N Table Edit |
| 18 | GPUS_SHI_RATE | Signed Number(8,6) | DECIMAL(6,6) NOT NULL | SHI Override Rate |
| 19 | GPUS_BUS_EFILE_NBR | Character(8) | VARCHAR2(8) NOT NULL | Business eFile Number for GPUS Year-End Reports |
| 20 | GPUS_WH_PERMIT_NBR | Character(12) | VARCHAR2(12) NOT NULL | Withholding Permit Number for GPUS Year-End Reports |
| 21 | GPUS_WH_ACCT_NBR | Character(15) | VARCHAR2(15) NOT NULL | Withholding Account Number for GPUS Year End Reports |
| 22 | GPUS_EXEMPT_TR_TAX | Character(1) | VARCHAR2(1) NOT NULL |
Exempt from the Oregon Statewide Transit Tax
Y/N Table Edit Default Value: N |