LM_RPT_UN_CATG1(SQL View) |
Index Back |
---|---|
LMCATGREL Report queryLMCATGREL 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 |