LM_RPT_UN_CATG(SQL View) |
Index Back |
|---|---|
LMCATGREl Report queryReport query for LMCATGREL |
| SELECT A.LM_CATG_ID , A.LM_CS_LONG_NM , A.LM_CS_STATUS , B.LM_CATG_ID , B.LM_CS_LONG_NM , B.LM_CS_STATUS , D.LM_CI_ID , D.LM_CI_STATUS , D.LM_CS_LONG_NM , D.LM_CS_DESCR , G.LM_DMTHD_TYPE_ID , G.LM_DM_LONG_NM , H.LM_ACT_ID , H.LM_ACT_CD , H.LM_ACT_STATUS , H.LM_START_DT , H.LM_END_DT , I.LM_LC_ID , I.LM_COMP_SEQ_ID , I.LM_REQD_FLAG , I.LM_LC_LONG_NM , I.LM_LC_DESCR , I.LM_LC_TYPE_LONG , I.LM_PASS_REQD , I.LM_SCORE , K.LM_CS_LONG_NM , K.LM_ACT_CD , K.LM_START_DT , K.LM_THRUDATE , K.RUN_CNTL_ID , L.LANGUAGE_CD FROM PS_LM_CATG_TBL A , PS_LM_CATG_TBL B , PS_LM_CATG_REL_TBL C , PS_LM_CI_TBL D , PS_LM_CATG_CI_TBL E , PS_LM_DMTHD_TBL F , PS_LM_DMTH_TYP_TBL G , PS_LM_ACT_CI_VW H , PS_LM_LC_CMPL_VW I , PS_LM_RUN_CATG_RPT K , PS_PRCSRUNCNTL L , PSOPTIONS M WHERE A.LM_CATG_ID = C.LM_CATG_ID AND B.LM_CATG_ID = C.LM_CHLD_CATG_ID AND L.OPRID = K.OPRID AND L.RUN_CNTL_ID = K.RUN_CNTL_ID AND M.LANGUAGE_CD = L.LANGUAGE_CD AND D.LM_CI_ID = E.LM_CI_ID AND D.EFFDT = E.EFFDT AND %CurrentDateIn BETWEEN D.EFFDT AND D.LM_END_EFFDT AND F.LM_CI_ID = D.LM_CI_ID AND F.LM_DMTHD_TYPE_ID = G.LM_DMTHD_TYPE_ID AND D.LM_CI_ID = H.LM_CI_ID AND F.LM_DMTHD_TYPE_ID = H.LM_DMTHD_TYPE_ID AND H.LM_ACT_ID = I.LM_ACT_ID AND ( K.LM_CATG_ID = 0 OR A.LM_CATG_ID = K.LM_CATG_ID) AND ( D.LM_CI_ID = K.LM_CI_ID OR K.LM_CI_ID = 0) AND ( H.LM_ACT_ID = K.LM_ACT_ID OR K.LM_ACT_ID = 0) AND (( K.LM_START_DT IS NULL AND K.LM_THRUDATE IS NULL) OR ( K.LM_START_DT IS NOT NULL AND K.LM_THRUDATE IS NULL AND H.LM_START_DT > K.LM_START_DT) OR ( K.LM_START_DT IS NULL AND K.LM_THRUDATE IS NOT NULL AND H.LM_START_DT < K.LM_THRUDATE) OR ( K.LM_START_DT IS NOT NULL AND K.LM_THRUDATE IS NOT NULL AND H.LM_START_DT BETWEEN K.LM_START_DT AND K.LM_THRUDATE)) AND %CurrentDateIn BETWEEN F.EFFDT AND F.LM_END_EFFDT AND E.LM_CATG_ID = B.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 |