LM_MTRL_LE_LVW

(SQL View)
Index Back

Material LE Language View

Material Learning Environment Language View

SELECT C.OPRID , A.LM_MTRL_ID , A.EFFDT , A.LANGUAGE_CD , A.LM_MTRL , A.LM_MTRL_SHORT FROM PS_LM_MTRLTBL_LANG A , PS_LM_MTRL_LE B , PS_LM_OPRID_LE_VW C WHERE A.LM_MTRL_ID = B.LM_MTRL_ID AND B.LM_LE_ID = C.LM_LE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 LM_MTRL_ID Number(10,0) DECIMAL(10) NOT NULL Material ID
3 EFFDT Date(10) DATE Effective Date

Default Value: %date

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 LM_MTRL Character(50) VARCHAR2(50) NOT NULL Material Description
6 LM_MTRL_SHORT Character(10) VARCHAR2(10) NOT NULL Material Short Description