LM_STG_CITEM_LG

(SQL Table)
Index Back

Catalog Items Staging Table

Catalog Items Staging Table

  • Related Language Record for LM_STG_CAT_ITEM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL Category Type
    2 LM_CAT_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Category Item field
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LM_EIP_CTRL_ID Number(10,0) DECIMAL(10) NOT NULL EIP Control Id
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_DESCR90 Character(100) VARCHAR2(100) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 DESCRLONG Long Character CLOB Long Description
    9 LM_EIP_PRCS_STTS Character(1) VARCHAR2(1) NOT NULL EIP Process status
    0=Not Processed
    1=Validated
    2=Invalid Data
    3=Loaded Successfully
    4=Invalid EmplRcd Number
    5=Warning Message