TAXGR_CMPNT_TBL (SQL Table)	Index Back
Taxable Gross Component Table This record is used to relate Taxable Gross Component IDs to the taxable gross bases defined for various states and localities and to indicate how the earnings and deductions related to these IDs through the Earnings Table affect the taxable gross being defined.

TAXGR_CMPNT_TBL

(SQL Table)

Taxable Gross Component Table

This record is used to relate Taxable Gross Component IDs to the taxable gross bases defined for various states and localities and to indicate how the earnings and deductions related to these IDs through the Earnings Table affect the taxable gross being defined.

Parent record: TAXGR_BASE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: STATE_TAX_TBL

2 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Prompt Table: LOCAL_TAX_TBL

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 TAX_GRS_TYPE Character(1) VARCHAR2(1) NOT NULL Taxable Gross
D=Disability
U=Unemployment
W=Withholding
Default Value: W

5 TAX_GRS_COMPNT Character(5) VARCHAR2(5) NOT NULL Taxable gross component ID.

6 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.

7 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code
Default Value: $DFLT

8 OTHER_RATE_ID Character(4) VARCHAR2(4) NOT NULL This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data.
SSCH=Children - SS Rate
SSEE=Employee - SS Rate
SSSP=Spouse - SS Rate

9 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit

10 TAX_GRS_EFFECT Character(1) VARCHAR2(1) NOT NULL Tax Gross Effect
A=Adds To
N=No Effect
S=Subtracts From
Default Value: A

11 WH_FOLLOWS_FED_SW Character(1) VARCHAR2(1) NOT NULL Withholding Follows Fed Rules
Y/N Table Edit
Default Value: Y

12 PY_MAINT_SOURCE Character(1) VARCHAR2(1) NOT NULL Maintenance source indicator
D=Development
O=Other

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TAX_TBL
2	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: LOCAL_TAX_TBL
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	TAX_GRS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Taxable Gross D=Disability U=Unemployment W=Withholding Default Value: W
5	TAX_GRS_COMPNT	Character(5)	VARCHAR2(5) NOT NULL	Taxable gross component ID.
6	PLAN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
7	DEDCD	Character(6)	VARCHAR2(6) NOT NULL	Deduction Code Default Value: $DFLT
8	OTHER_RATE_ID	Character(4)	VARCHAR2(4) NOT NULL	This is used as the record key for Other Benefits Rate Data that recategorize rates from parent record Benefit Rate Data. SSCH=Children - SS Rate SSEE=Employee - SS Rate SSSP=Spouse - SS Rate
9	DED_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Deduction Classification A=After-Tax B=Before-Tax L=QC Taxable Benefit N=Nontaxable Benefit P=Nontaxable Btax Benefit T=Taxable Benefit
10	TAX_GRS_EFFECT	Character(1)	VARCHAR2(1) NOT NULL	Tax Gross Effect A=Adds To N=No Effect S=Subtracts From Default Value: A
11	WH_FOLLOWS_FED_SW	Character(1)	VARCHAR2(1) NOT NULL	Withholding Follows Fed Rules Y/N Table Edit Default Value: Y
12	PY_MAINT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Maintenance source indicator D=Development O=Other