PY_TAXYR_USA_VW (SQL View)	Index Back
Tax Year in BI not in Year End View to find tax years defined in Tax Form BI Publisher but not defined in Year End Form Options.

PY_TAXYR_USA_VW

(SQL View)

Tax Year in BI not in Year End

View to find tax years defined in Tax Form BI Publisher but not defined in Year End Form Options.

SELECT A.COMPANY , B.PY_TAX_YEAR FROM PS_COMPANY_TBL A , PS_PY_TAX_YEAR B WHERE A.TAX_REPORT_TYPE IN ('2','P', 'R') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_COMPANY_TBL B WHERE B.COMPANY = A.COMPANY AND B.EFFDT <= %CurrentDateIn AND B.EFF_STATUS = 'A') AND A.COMPANY NOT IN ( SELECT W2_REPORTING_CO FROM PS_PY_YEOPT_CO_USA WHERE W2_REPORTING_CO = A.COMPANY AND PY_TAX_YEAR = B.PY_TAX_YEAR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company

2 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	W2_REPORTING_CO	Character(3)	VARCHAR2(3) NOT NULL	W-2 Reporting Company
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.