LM_LC_VW1(SQL View) |
Index Back |
---|---|
Component Header viewComponent 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 |