W2C_STATE_NM_VW

(SQL View)
 Index Back

States available for the W-2c

States available for the W-2c

SELECT A.STATE ,A.DESCR FROM PS_STATE_NAMES_TBL A WHERE A.COUNTRY = 'USA' AND (A.NUMERIC_CD <> ' ' OR A.STATE IN ('AS', 'VI', 'GU', 'PR'))

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