LM_PRG_LE

(SQL Table)
Index Back

Program Learning Environments

Program Learning Environments

  • 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_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

    Prompt Table: LM_PRG_LE_VW2

    4 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    5 LM_PRM_LE Character(2) VARCHAR2(2) NOT NULL Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)

    Y/N Table Edit

    Default Value: N

    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