GPJP_IT_OTS_SAL (SQL Table)	Index Back
OTSU Salary Income Tax Table OTSU Salary Income Tax Table.

GPJP_IT_OTS_SAL

(SQL Table)

OTSU Salary Income Tax Table

OTSU 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_NET_SAL Number(19,6) DECIMAL(18,6) NOT NULL Lower Bound of Net Salary.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
2	GPJP_NET_SAL	Number(19,6)	DECIMAL(18,6) NOT NULL	Lower Bound of Net Salary.
3	GPJP_TAX_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Amount of Income Tax.
4	GPJP_EXP_RATE	Number(9,6)	DECIMAL(8,6) NOT NULL	Exception Rate.