LCL_TAX_AUTH_VW

(SQL View)
 Index Back

Selects SpecificTax Agencies

for W2 Processing in the MMREF-1 format.

SELECT DISTINCT(A.W2_RPTG_AGENCY) FROM PS_LOCAL_TAX_TBL2 A WHERE A.W2_RPTG_AGENCY <> ' ' AND A.EFFDT=( SELECT MAX(B.EFFDT) FROM PS_LOCAL_TAX_TBL2 B , PS_TAXRPT_RUNCTL C WHERE A.LOCALITY = B.LOCALITY AND A.STATE=B.STATE AND %DateIn(B.EFFDT) < %DateIn(%NumToChar(C.BALANCE_YEAR + 1) %Concat '-01-01'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 W2_RPTG_AGENCY Character(5) VARCHAR2(5) NOT NULL W2 Reporting Agency