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 <> ' '

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