TAXGR_DEFN_TBL (SQL Table)	Index Back
Taxable Gross ID Table This is the effective-dated control record for the Taxable Gross Definition Table. The table is used to define the taxability of earnings and deductions which are treated differently by state and local jurisdictions than by the federal government.

TAXGR_DEFN_TBL

(SQL Table)

Taxable Gross ID Table

This is the effective-dated control record for the Taxable Gross Definition Table. The table is used to define the taxability of earnings and deductions which are treated differently by state and local jurisdictions than by the federal government.

Parent Record Of 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 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	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	PY_MAINT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Maintenance source indicator D=Development O=Other