WM_INSP_LASTID

(SQL Table)
 Index Back

Last-Used Inspection ID

Maintenance Management Inspection ID "last number used" record. Tracks the last auto-generated (numeric) Inspection ID used by a particular Business Unit.

  • Parent record: BUS_UNIT_TBL_WM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    2 LAST_INSPECT_NBR Number(10,0) DECIMAL(10) NOT NULL Last Inspection Number