LOCL_TX_TYP_VW

(SQL View)
 Index Back

Local Tax Type View

This table is used to display those states that exist in the LOCL_TX_TYP_EFF table.

SELECT DISTINCT A.STATE , B.DESCR FROM PS_LOCL_TX_TYP_EFF A , PS_STATE_TBL B WHERE B.COUNTRY = 'USA' AND A.STATE = B.STATE AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCL_Tx_TYP_EFF B WHERE B.STATE = A.STATE AND B.LOCALITY = A.LOCALITY AND B.EFFDT <= %CurrentDateIn)

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

Prompt Table: STATE_US_VW

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description