CURR_CD_PAY_VW

(SQL View)
Index Back

Select currency_cd, effdt, descr, descrshort from ps_currency_cd_tbl where eff_status = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CURRENCY_PAY_CD Character(3) VARCHAR2(3) NOT NULL Preferred Pay Currency
2 EFFDT Date(10) DATE Effective Date
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description