M1099_STATE_VW

(SQL View)
 Index Back

1099 Misc States View


SELECT a.state , b.descr FROM ps_m1099_state_tbl a , PS_STATE_TBL b WHERE a.state = b.state AND b.country = 'USA'

  • Related Language Record: M1099_STATEVWLG

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

    Prompt Table: STATE_TBL_US_VW

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