LM_ATT_SCH_VW

(SQL View)
 Index Back

Attendance Schemes

Attendance Scheme Values

SELECT LM_ATT_VAL_ID , LM_ATT_STTS_LABEL FROM PS_LM_ATT_SCH_VAL WHERE LM_ATT_STTS = 'ATTD'

  • Related Language Record: LM_ATT_VW_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ATT_VAL_ID Number(10,0) DECIMAL(10) NOT NULL Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
    2 LM_ATT_STTS_LABEL Character(30) VARCHAR2(30) NOT NULL Attendance Status Label