LM_CATG_TBL

(SQL Table)
Index Back

Category Table

Defines the categories that form the training catalog

  • Related Language Record: LM_CATG_LANG
  • Parent Record Of LM_CATGCI_LA_VW LM_CATG_CI_VW2 LM_CATG_LE_TBL LM_CATG_REL_TBL LM_CATG_REL_VW LM_CATG_SEC_TBL LM_CGCI_LA_LANG LM_CG_CI_VW2_LG LM_CTGRL_VW_LNG
  • # 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.

    Default Value: 0

    2 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    3 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object
    4 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail
    5 LM_CS_STATUS Character(3) VARCHAR2(3) NOT NULL Status - Indicates whether an item is active or inactive
    10=Active
    20=Inactive

    Default Value: 10

    6 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID

    Prompt Table: LM_OWNERID_VW

    7 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    8 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    9 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    10 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
    11 LM_NOTE_URL Character(254) VARCHAR2(254) NOT NULL URL available on the maintenance of notes in ELM catalog.