TAXGR_BASE_TBL (SQL Table)	Index Back
Taxable Gross Base Table This record defines the valid combinations of taxable gross types and taxable gross bases for use in the Taxable Gross Definition Table.

TAXGR_BASE_TBL

(SQL Table)

Taxable Gross Base Table

This record defines the valid combinations of taxable gross types and taxable gross bases for use in the Taxable Gross Definition Table.

Parent record: TAXGR_DEFN_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
P=Paid Benefit
U=Unemployment
W=Withholding
Default Value: W

5 TAX_GRS_BASE Character(1) VARCHAR2(1) NOT NULL Base Gross
D=FICA
G=All Gross
S=SWT
U=FUT
W=FWT
Default Value: W

6 PY_MAINT_SOURCE Character(1) VARCHAR2(1) NOT NULL Maintenance source indicator
D=Development
O=Other
Default Value: O

#	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 P=Paid Benefit U=Unemployment W=Withholding Default Value: W
5	TAX_GRS_BASE	Character(1)	VARCHAR2(1) NOT NULL	Base Gross D=FICA G=All Gross S=SWT U=FUT W=FWT Default Value: W
6	PY_MAINT_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Maintenance source indicator D=Development O=Other Default Value: O