LM_RPT_UN_CATG1

(SQL View)
Index Back

LMCATGREL Report query

LMCATGREL Report query

SELECT J.LM_CATG_ID , J.LM_CS_LONG_NM , J.LM_CS_STATUS , S.LM_CATG_ID , S.LM_CS_LONG_NM , S.LM_CS_STATUS , L.LM_CI_ID , L.LM_CI_STATUS , L.LM_CS_LONG_NM , L.LM_CS_DESCR , O.LM_DMTHD_TYPE_ID , O.LM_DM_LONG_NM , P.LM_ACT_ID , P.LM_ACT_CD , P.LM_ACT_STATUS , P.LM_START_DT , P.LM_END_DT , Q.LM_LC_ID , Q.LM_COMP_SEQ_ID , Q.LM_REQD_FLAG , Q.LM_LC_LONG_NM , Q.LM_LC_DESCR , Q.LM_LC_TYPE_LONG , Q.LM_PASS_REQD , Q.LM_SCORE , R.LM_CS_LONG_NM , R.LM_ACT_CD , R.LM_START_DT , R.LM_THRUDATE , R.RUN_CNTL_ID , T.LANGUAGE_CD FROM PS_LM_CATG_TBL J , PS_LM_CI_TBL L , PS_LM_CATG_CI_TBL M , PS_LM_DMTHD_TBL N , PS_LM_DMTH_TYP_TBL O , PS_LM_ACT_CI_VW P , PS_LM_LC_CMPL_VW Q , PS_LM_RUN_CATG_RPT R , PS_LM_CATG_TBL S , PS_PRCSRUNCNTL T , PSOPTIONS U WHERE J.LM_CATG_ID = M.LM_CATG_ID AND L.LM_CI_ID = M.LM_CI_ID AND T.OPRID = R.OPRID AND T.RUN_CNTL_ID = R.RUN_CNTL_ID AND U.LANGUAGE_CD = T.LANGUAGE_CD AND L.EFFDT = M.EFFDT AND %CurrentDateIn BETWEEN L.EFFDT AND L.LM_END_EFFDT AND N.LM_CI_ID = L.LM_CI_ID AND N.LM_DMTHD_TYPE_ID = O.LM_DMTHD_TYPE_ID AND %CurrentDateIn BETWEEN N.EFFDT AND N.LM_END_EFFDT AND L.LM_CI_ID = P.LM_CI_ID AND N.LM_DMTHD_TYPE_ID = P.LM_DMTHD_TYPE_ID AND P.LM_ACT_ID = Q.LM_ACT_ID AND ( R.LM_CATG_ID = 0 OR J.LM_CATG_ID = R.LM_CATG_ID) AND ( L.LM_CI_ID = R.LM_CI_ID OR R.LM_CI_ID = 0) AND ( P.LM_ACT_ID = R.LM_ACT_ID OR R.LM_ACT_ID = 0) AND (( R.LM_START_DT IS NULL AND R.LM_THRUDATE IS NULL) OR ( R.LM_START_DT IS NOT NULL AND R.LM_THRUDATE IS NULL AND P.LM_START_DT > R.LM_START_DT) OR ( R.LM_START_DT IS NULL AND R.LM_THRUDATE IS NOT NULL AND P.LM_START_DT < R.LM_THRUDATE) OR ( R.LM_START_DT IS NOT NULL AND R.LM_THRUDATE IS NOT NULL AND P.LM_START_DT BETWEEN R.LM_START_DT AND R.LM_THRUDATE)) AND S.LM_CATG_ID = R.LM_CATG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
2 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
3 LM_CS_STATUS Character(3) VARCHAR2(3) NOT NULL Status - Indicates whether an item is active or inactive
10=Active
20=Inactive
4 LM_RPT_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
5 LM_RPT_CS_LONG_NM Character(254) VARCHAR2(254) NOT NULL Long Name - Describes the long name of an object
6 LM_RPT_CS_STATUS Character(3) VARCHAR2(3) NOT NULL Status - Indicates whether an item is active or inactive
10=Active
20=Inactive
7 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
8 LM_CI_STATUS Character(3) VARCHAR2(3) NOT NULL Catalog Item Status - A drop down list with values indicating the current status of the learning activity.
10=Active
20=Inactive
40=Pending
9 LM_DM_CS_LONG_NM Character(254) VARCHAR2(254) NOT NULL Long Name - Describes the long name of an object
10 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
11 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type
12 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
13 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
14 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
15 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
16 LM_START_DT Date(10) DATE Start Date
17 LM_END_DT Date(10) DATE End Date
18 LM_LC_ID Number(10,0) DECIMAL(10) NOT NULL Learning Component ID - Blended Learning
19 LM_COMP_SEQ_ID Number(3,0) SMALLINT NOT NULL Learning Component sequence - Blended Learning
20 LM_REQD_FLAG Character(1) VARCHAR2(1) NOT NULL Learning Component required? - Blended Learning
21 LM_LC_LONG_NM Character(200) VARCHAR2(200) NOT NULL Learning Component Long Name
22 LM_LC_DESCR Long Character CLOB Learning Component Description
23 LM_LC_TYPE_LONG Character(200) VARCHAR2(200) NOT NULL Learning Component Type Long Name
24 LM_PASS_REQD Character(1) VARCHAR2(1) NOT NULL Passing Required
25 LM_SCORE Character(30) VARCHAR2(30) NOT NULL Score for this Enrollment. Score will be passed by Content Vendor.
26 LM_RPT_CS_LONG_NM2 Character(254) VARCHAR2(254) NOT NULL Long Name - Describes the long name of an object
27 LM_RPT_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
28 LM_RPT_START_DT Date(10) DATE Start Date
29 LM_THRUDATE Date(10) DATE End Date parameter for enrollment related reports.
30 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
31 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code