GPJP_IT_KOU_SAL (SQL Table)	Index Back
KOU Salary Income Tax Table KOU Salary Income Tax Table.

GPJP_IT_KOU_SAL

(SQL Table)

KOU Salary Income Tax Table

KOU Salary Income Tax Table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

2 GPJP_NUM_DEP Number(3,0) SMALLINT NOT NULL Adjusted Number of Dependent.

3 GPJP_NET_SAL Number(19,6) DECIMAL(18,6) NOT NULL Lower Bound of Net Salary.

4 GPJP_NET_SAL_HL Number(19,6) DECIMAL(18,6) NOT NULL GPJP_NET_SAL_HL field to hold the maximum amount of a range

5 GPJP_TAX_AMT Number(19,6) DECIMAL(18,6) NOT NULL Amount of Income Tax.

6 GPJP_EXP_RATE Number(9,6) DECIMAL(8,6) NOT NULL Exception Rate.

7 GPJP_EXP_AMT Number(19,6) DECIMAL(18,6) NOT NULL Exception Amount.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	GPJP_NUM_DEP	Number(3,0)	SMALLINT NOT NULL	Adjusted Number of Dependent.
3	GPJP_NET_SAL	Number(19,6)	DECIMAL(18,6) NOT NULL	Lower Bound of Net Salary.
4	GPJP_NET_SAL_HL	Number(19,6)	DECIMAL(18,6) NOT NULL	GPJP_NET_SAL_HL field to hold the maximum amount of a range
5	GPJP_TAX_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount of Income Tax.
6	GPJP_EXP_RATE	Number(9,6)	DECIMAL(8,6) NOT NULL	Exception Rate.
7	GPJP_EXP_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Exception Amount.