LM_OBJV_DTL_VW

(SQL View)
 Index Back

Objectives Detail

The Objectives Detail table is where external competencies, skills, etc., can be mapped to ELM Objectives

SELECT LM_EXT_SRC_CD , LM_EXT_CD , LM_OBJV_ID , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID FROM PS_LM_OBJV_DTL

  • Parent record: LM_OBJV_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_EXT_SRC_CD Character(10) VARCHAR2(10) NOT NULL External Source Code

    Prompt Table: LM_OBJV_EXT_STP

    2 LM_EXT_CD Character(30) VARCHAR2(30) NOT NULL External objective code

    Prompt Table: LM_EXT_SRC_VW

    3 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    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