LM_ACT_SEL_LST

(SQL View)
Index Back

Activity Select List

Browse Catalog - Activity Select List

SELECT DISTINCT A.LM_CI_ID ,A.EFFDT , A.LM_CS_LONG_NM , A.LM_CS_DESCR , C.LM_DISP_ORDER ,A.LM_CRSE_CODE , C.LM_CATG_ID FROM PS_LM_CI_TBL A , PS_LM_CATG_CI_TBL C WHERE A.LM_CI_ID=C.LM_CI_ID AND A.EFFDT=C.EFFDT AND A.LM_CI_STATUS='10' AND %CurrentDateIn BETWEEN A.EFFDT AND A.LM_END_EFFDT

  • Related Language Record: LM_ACT_SLST_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    4 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    5 LM_DISP_ORDER Number(10,0) DECIMAL(10) NOT NULL Display Order - A number indicating the ascending order in which the child category will appear under the parent.
    6 LM_CRSE_CODE Character(30) VARCHAR2(30) NOT NULL Course Code - User defined Code
    7 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.