GPIN_PT_TBL_VW (SQL View)	Index Back
Professional tax setup Professional tax setup

GPIN_PT_TBL_VW

(SQL View)

Professional tax setup

SELECT A.STATE , A.GPIN_PT_SLVL_VAL , A.EFFDT , A.EFF_STATUS , A.GPIN_PIN_PT1_NUM , A.GPIN_PIN_PT2_NUM , A.GPIN_PIN_PT3_NUM , A.GPIN_PT_INCOM_FREQ , A.GPIN_PT_DEDUC_FREQ , 0 FROM PS_GPIN_PT_TBL A WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPIN_PT_DED_PD B WHERE A.STATE = B.STATE AND A.GPIN_PT_SLVL_VAL = B.GPIN_PT_SLVL_VAL AND A.EFFDT = B.EFFDT ) UNION SELECT A.STATE , A.GPIN_PT_SLVL_VAL , A.EFFDT , MAX(A.EFF_STATUS) , MAX(A.GPIN_PIN_PT1_NUM) , MAX(A.GPIN_PIN_PT2_NUM) , MAX(A.GPIN_PIN_PT3_NUM) , MAX(A.GPIN_PT_INCOM_FREQ) , MAX(A.GPIN_PT_DEDUC_FREQ) , COUNT(B.GPIN_PT_DED_PRD) FROM PS_GPIN_PT_TBL A , PS_GPIN_PT_DED_PD B WHERE A.STATE = B.STATE AND A.GPIN_PT_SLVL_VAL = B.GPIN_PT_SLVL_VAL AND A.EFFDT = B.EFFDT GROUP BY A.STATE , A.GPIN_PT_SLVL_VAL , A.EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GPIN_PT_SLVL_VAL Character(20) VARCHAR2(20) NOT NULL Sublevel value

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

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 GPIN_PIN_PT1_NUM Number(8,0) INTEGER NOT NULL Global payroll element containing the Slab search key 1 value. I.e. Category: Gender.
Prompt Table: %GP_EDIT_FLD1

6 GPIN_PIN_PT2_NUM Number(8,0) INTEGER NOT NULL Global payroll element containing the Slab search key 2 value.
Prompt Table: %GP_EDIT_FLD2

7 GPIN_PIN_PT3_NUM Number(8,0) INTEGER NOT NULL Global payroll element containing the Slab search key 3 value.
Prompt Table: %GP_EDIT_FLD3

8 GPIN_PT_INCOM_FREQ Character(1) VARCHAR2(1) NOT NULL Professional tax income frequency. Used to point out the gross salary range frequency
A=Yearly
M=Monthly
N=Half-Yearly
Q=Quarterly
Default Value: M

9 GPIN_PT_DEDUC_FREQ Character(1) VARCHAR2(1) NOT NULL Professional tax deduction frequency. Used to point out the PT tax imposed slab frequency.
A=Yearly
M=Monthly
N=Half-Yearly
Q=Quarterly
Default Value: M

10 GPIN_PT_DED_PD_CNT Number(2,0) SMALLINT NOT NULL Professional tax deduction periods count. For frequencies other than monthly; if count is zero, the deduction is prorated and deducted monthly.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: GPIN_STATE_VW
2	GPIN_PT_SLVL_VAL	Character(20)	VARCHAR2(20) NOT NULL	Sublevel value
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	GPIN_PIN_PT1_NUM	Number(8,0)	INTEGER NOT NULL	Global payroll element containing the Slab search key 1 value. I.e. Category: Gender. Prompt Table: %GP_EDIT_FLD1
6	GPIN_PIN_PT2_NUM	Number(8,0)	INTEGER NOT NULL	Global payroll element containing the Slab search key 2 value. Prompt Table: %GP_EDIT_FLD2
7	GPIN_PIN_PT3_NUM	Number(8,0)	INTEGER NOT NULL	Global payroll element containing the Slab search key 3 value. Prompt Table: %GP_EDIT_FLD3
8	GPIN_PT_INCOM_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Professional tax income frequency. Used to point out the gross salary range frequency A=Yearly M=Monthly N=Half-Yearly Q=Quarterly Default Value: M
9	GPIN_PT_DEDUC_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Professional tax deduction frequency. Used to point out the PT tax imposed slab frequency. A=Yearly M=Monthly N=Half-Yearly Q=Quarterly Default Value: M
10	GPIN_PT_DED_PD_CNT	Number(2,0)	SMALLINT NOT NULL	Professional tax deduction periods count. For frequencies other than monthly; if count is zero, the deduction is prorated and deducted monthly.