LM_RTG_ALLCD_VW (SQL View)	Index Back
Learning Item Codes Use this view to select all the activity and program codes.

LM_RTG_ALLCD_VW

(SQL View)

Learning Item Codes

Use this view to select all the activity and program codes.

SELECT DISTINCT AC.LM_ACT_CD FROM PS_LM_ACT_CI_VW AC UNION SELECT DISTINCT PG.LM_PRG_CD FROM PS_LM_PRG PG WHERE PG.EFFDT = ( SELECT MAX(X.EFFDT) FROM PS_LM_PRG X WHERE X.LM_PRG_ID = PG.LM_PRG_ID AND X.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_RTG_ACT_PRG_CD Character(30) VARCHAR2(30) NOT NULL Code