GPIN_PT_SLABS_A

(SQL Table)
Index Back

PT Additional tax rates

Professional tax set up. Additional tax rates regardless they are tied to a gross salary range or not.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

2 GPIN_PT_SLVL_VAL Character(20) VARCHAR2(20) NOT NULL Sublevel value
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 GPIN_CTG1_PIN_VAL Character(20) VARCHAR2(20) NOT NULL Professional Tax slab search key1 value
5 GPIN_CTG2_PIN_VAL Character(20) VARCHAR2(20) NOT NULL Professional Tax slab search key2 value
6 GPIN_CTG3_PIN_VAL Character(20) VARCHAR2(20) NOT NULL Professional Tax slab search key3 value
7 GPIN_PT_SLAB_MX_A Number(12,2) DECIMAL(11,2) NOT NULL Professional tax slab gross salary
8 GPIN_PT_DED_PRD Number(2,0) SMALLINT NOT NULL Professional tax deduction month.
9 GPIN_PT_ADTAX_AMT Number(10,2) DECIMAL(9,2) NOT NULL Professional tax additional amount.