LM_CT_LCT_VW

(SQL View)
 Index Back

LearningComp Template Join Vie


SELECT A.LM_TMPL_PAGE_ID , B.LM_BAS_LC_TYPE , A.LM_TMPL_SECT_ID , A.LM_TMPL_LBL , C.RECNAME , C.FIELDNAME FROM PS_LM_TMPL_PG_SECT A , PS_LM_CT_LC B , PS_LM_TMPL_TP_SECT C , PS_LM_TMPL_PAGE D , PS_LM_TMPL E WHERE A.LM_TMPL_SECT_ID=B.LM_TMPL_SECT_ID AND A.LM_TMPL_PAGE_ID=D.LM_TMPL_PAGE_ID AND D.LM_TMPL_TP_PAGE_ID=C.LM_TMPL_TP_PAGE_ID AND D.LM_TMPL_ID=E.LM_TMPL_ID AND E.LM_TMPL_TYPE_ID=C.LM_TMPL_TYPE_ID AND A.LM_TMPL_SECT_ID=C.LM_TMPL_SECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_TMPL_PAGE_ID Number(15,0) DECIMAL(15) NOT NULL Page ID
2 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey
3 LM_TMPL_SECT_ID Character(34) VARCHAR2(34) NOT NULL Template Section

Prompt Table: LM_TMPL_TP_SECT

4 LM_TMPL_LBL Character(60) VARCHAR2(60) NOT NULL New Label
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).