LM_OBJV_SES_LVW

(SQL View)
 Index Back

Objectives Related Language

This is the related language objective view for Oracle SES.

SELECT OBJLNG.LM_OBJV_ID , OBJLNG.LANGUAGE_CD , OBJLNG.LM_OBJV_DESC , OBJLNG.LM_OBJV_SDESC , OBJLNG.LM_OBJV_LDESC FROM PS_LM_OBJV_TBL OBJ , PS_LM_OBJV_LNG OBJLNG WHERE OBJ.LM_OBJV_ID = OBJLNG.LM_OBJV_ID

  • Related Language Record for LM_OBJV_SES_VW

    • # 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.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    4 LM_OBJV_SDESC Character(10) VARCHAR2(10) NOT NULL Objective short description.
    5 LM_OBJV_LDESC Long Character CLOB Objective long description.