LM_FUND_CDE_LVW

(SQL View)
Index Back

Fund Codes View

Contains current row for all Fund Codes

SELECT A.SETID , B.LM_FUND_CODE , B.LANGUAGE_CD , B.LM_CF_FUND_DESCR , B.LM_CF_FUND_SDESCR FROM PS_LM_CF_FUND A , PS_LM_FUND_LANG B WHERE A.SETID= B.SETID AND A.LM_FUND_CODE=B.LM_FUND_CODE AND A.EFFDT = B.EFFDT AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LM_FUND_CODE Character(20) VARCHAR2(20) NOT NULL Fund Code
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 LM_CF_FUND_DESCR Character(50) VARCHAR2(50) NOT NULL Fund Chart Field Description
5 LM_CF_FUND_SDESCR Character(10) VARCHAR2(10) NOT NULL Fund Chart field Short Description