LM_ACTNOTE_LANG

(SQL Table)
Index Back

Activity Notes Table

Stores notes related to an activity. The status field controls whether the notes are shown on the catalog or not.

  • Related Language Record for LM_ACT_NOTE
  • # 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_NOTES_ID Number(10,0) DECIMAL(10) NOT NULL Notes ID - System generated unique ID for each new note entered.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_NOTE Long Character CLOB Notes and Comments