LM_OBJV_PRG_VW2

(SQL View)
 Index Back

Program Objectives

This view is a direct view over LM_PRG_OBJV table. Only difference being LM_OBJV_ID is the first key as this record is used at level 1 on Objectives Definition and Mapping page where LM_OBJV_ID is the key at level0

SELECT A.LM_OBJV_ID ,A.LM_PRG_ID , A.EFFDT , A.LM_REVIEW_RATING , A.LM_END_EFFDT , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_PRG_OBJV A

  • Parent record: LM_PRG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.

    Prompt Table: LM_PRG_OBJV_VW2

    2 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

    Prompt Table: LM_PRG_DTL_VW

    3 LM_EFFDT Date(10) DATE NOT NULL Effective Date

    Prompt Table: LM_PRG_EFDT_VW1

    4 LM_REVIEW_RATING Character(1) VARCHAR2(1) NOT NULL REview points for Rating models from HRMS

    Prompt Table: LM_RVW_RTNG_VW

    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