LM_PASS_VAL_VW

(SQL View)
 Index Back

Passing Scheme

Passing Schemes

SELECT A.LM_PASS_SCH_ID , A.LM_PASS_VAL_ID , A.LM_PASS_STTS , A.LM_PASS_STTS_LABEL , A.SYSTEM_DATA_FLG , %subrec(LM_ROWAUDIT_SBR,A) FROM PS_LM_PASS_SCH_VAL A

  • Related Language Record: LM_PAS_SC_VL_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PASS_SCH_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme ID
    2 LM_PASS_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Passing Scheme Value ID
    3 LM_PASS_STTS Character(4) VARCHAR2(4) NOT NULL Passing Status
    FAIL=Fail
    NOMK=Not Marked
    NORQ=Not Required
    PASS=Pass
    PEND=Pending
    4 LM_PASS_STTS_LABEL Character(30) VARCHAR2(30) NOT NULL Passing Scheme status label
    5 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data
    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