GPJP_TAXESLA_VW (SQL View)	Index Back
Tax Establishment View Tax Establishment View contains Labor Insurance Establishment rows from Tax Establishment Table.

GPJP_TAXESLA_VW

(SQL View)

Tax Establishment View

Tax Establishment View contains Labor Insurance Establishment rows from Tax Establishment Table.

SELECT A.GPJP_TAX_ESTAB , A.EFFDT , A.DESCR FROM PS_GPJP_TAX_ESTAB A WHERE A.GPJP_TAX_ESTAB_TYP = 'LA'

Related Language Record: GPJP_TXESLAL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPJP_TAX_ESTAB	Character(15)	VARCHAR2(15) NOT NULL	Salary Payer Reference Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description