GPUS_TAX_EIN_VW (SQL View)	Index Back
Year End Tax EIN View View to show EIN's that report to the Reporting Companies

GPUS_TAX_EIN_VW

(SQL View)

Year End Tax EIN View

View to show EIN's that report to the Reporting Companies

SELECT A.GPUS_TAX_EIN FROM PS_GPUS_YE_CO_EIN A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GPUS_YE_CO_EIN B WHERE B.GPUS_YE_RPT_CO = A.GPUS_YE_RPT_CO AND B.GPUS_TAX_EIN = A.GPUS_TAX_EIN AND B.EFFDT <= %CurrentDateIn) AND A.GPUS_TAX_EIN <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number