LM_ACT_STTS_CMT

(SQL Table)
Index Back

Inactive Status Comments

Used to store comments about activities that have inactive status.

  • Related Language Record: LM_ACT_CMT_LNG
  • Parent record: LM_ACT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_CMNTS_NBR Number(8,0) INTEGER NOT NULL Used as a sequence # key for the Activity Comments table.

    Default Value: 99999999

    3 LM_NOTE Long Character CLOB Notes and Comments
    4 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    5 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    6 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    7 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid