LM_LC_VW1

(SQL View)
Index Back

Component Header view

Component Header view

SELECT A.LM_ACT_ID ,B.LM_LC_ID ,B.LM_SCO12_NAV_OPT ,B.LM_SCO_NUMB_OPT ,B.LM_HIDE_PROG_BAR FROM PS_LM_ACT_CI_VW A , PS_LM_LC B , PS_LM_LC_TYPE_VW C WHERE A.LM_ACT_ID = B.LM_ACT_ID AND B.LM_LC_TYPE_ID = C.LM_LC_TYPE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
2 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
3 LM_SCO12_NAV_OPT Character(1) VARCHAR2(1) NOT NULL Hide Navigation Controls
N=No
Y=Yes
4 LM_SCO_NUMB_OPT Character(1) VARCHAR2(1) NOT NULL Show Numbering
N=No
Y=Yes
5 LM_HIDE_PROG_BAR Character(1) VARCHAR2(1) NOT NULL Hide Progress bar