GPIN_PT_SLAB_VW

(SQL View)
 Index Back

PT Gross salary ranges

Professional tax gross salary ranges with imposed tax rates.

SELECT DISTINCT A.STATE , A.GPIN_PT_SLVL_VAL , A.EFFDT , A.GPIN_CTG1_PIN_VAL , A.GPIN_CTG2_PIN_VAL , A.GPIN_CTG3_PIN_VAL , A.GPIN_PT_SLAB_MX_A , A.GPIN_PT_SLAB_TAX , %Coalesce(B.GPIN_PT_DED_PRD, 0) , %Coalesce(B.GPIN_PT_ADTAX_AMT, 0) FROM PS_GPIN_PT_SLABS A LEFT OUTER JOIN PS_GPIN_PT_SLABS_A B ON A.STATE = B.STATE AND A.GPIN_PT_SLVL_VAL = B.GPIN_PT_SLVL_VAL AND A.EFFDT = B.EFFDT AND A.GPIN_PT_SLAB_MX_A = B.GPIN_PT_SLAB_MX_A UNION SELECT A.STATE , A.GPIN_PT_SLVL_VAL , A.EFFDT , A.GPIN_CTG1_PIN_VAL , A.GPIN_CTG2_PIN_VAL , A.GPIN_CTG3_PIN_VAL , A.GPIN_PT_SLAB_MX_A , A.GPIN_PT_SLAB_TAX , %Coalesce(B.GPIN_PT_DED_PRD, 0) , %Coalesce(B.GPIN_PT_ADTAX_AMT, 0) FROM PS_GPIN_PT_SLABS A LEFT OUTER JOIN PS_GPIN_PT_SLABS_A B ON A.STATE = B.STATE AND A.GPIN_PT_SLVL_VAL = B.GPIN_PT_SLVL_VAL AND A.EFFDT = B.EFFDT WHERE B.GPIN_PT_SLAB_MX_A = 0

# 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_SLAB_TAX Number(10,2) DECIMAL(9,2) NOT NULL Professional tax imposed amount
9 GPIN_PT_DED_PRD Number(2,0) SMALLINT NOT NULL Professional tax deduction month.
10 GPIN_PT_ADTAX_AMT Number(10,2) DECIMAL(9,2) NOT NULL Professional tax additional amount.