ADP_TXST_VW

(SQL View)
Index Back

ADP Tax State View

This view is used by ADP Connection via ODBC to facilitate the mapping of state codes.

SELECT DISTINCT A.STATE FROM PS_STATE_TAX_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_STATE_TAX_TBL B WHERE B.EFFDT <= %CurrentDateIn AND A.STATE = B.STATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STATE Character(6) VARCHAR2(6) NOT NULL State