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 |