PY_TAXYR_CAN_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_CAN_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.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 COMPANY FROM PS_PY_YEOPT_CO_CAN WHERE COMPANY = A.COMPANY AND PY_TAX_YEAR = B.PY_TAX_YEAR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL 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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	PY_TAX_YEAR	Number(4,0)	SMALLINT NOT NULL	Represents the year for personal income tax purposes.