LM_PRG_KWRD

(SQL Table)
Index Back

Program Keywords

Program Keywords

  • Parent record: LM_PRG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: LM_PRG.EFFDT

    3 LM_KWRD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Keyword Type ID- System generated unique ID created with each new instance of a Keyword Type.

    Prompt Table: LM_KWRD_TYP_VW2

    4 LM_KWRD_ID Number(10,0) DECIMAL(10) NOT NULL Keyword ID - This is a system generated number used as a unique identifier for the keyword table.

    Prompt Table: LM_KWRD_VW3

    5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    6 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    7 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    8 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    9 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid