LM_CATG_SEL_LST

(SQL View)
Index Back

Category Select View

Browse Catalog category select view.

SELECT DISTINCT CATG.LM_CATG_ID ,CREL.LM_CATG_ID , CATG.LM_CS_LONG_NM , CATG.LM_CS_DESCR , CREL.LM_DISP_ORDER , CATG.LM_NOTE_URL FROM PS_LM_CATG_REL_TBL CREL , PS_LM_CATG_TBL CATG WHERE CREL.LM_CHLD_CATG_ID=CATG.LM_CATG_ID AND CATG.LM_CS_STATUS='10'

  • Related Language Record: LM_CAT_SLST_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CHLD_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Child Category ID - A unique identifier used to identify a subcategory.
    2 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
    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_NOTE_URL Character(254) VARCHAR2(254) NOT NULL URL available on the maintenance of notes in ELM catalog.