WM_WO_INSPC_COL

(SQL Table)
 Index Back

WO Inspection Data Collection

  • Parent record: WM_WO_INSPC_ACT

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

    Default Value: WM_WO_INSPC_ACT.BUSINESS_UNIT

    Prompt Table: SP_BU_WM_NONVW

    2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

    Default Value: WM_WO_INSPC_ACT.WO_ID

    Prompt Table: WM_FTRK_WOI_PVW

    3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

    Default Value: WM_WO_INSPC_ACT.WO_TASK_ID

    Prompt Table: WM_FTRK_TSK_PVW

    4 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID

    Default Value: WM_WO_INSPC_ACT.INSPECTION_ID

    5 INSP_ACTIVITY_NBR Number(5,0) INTEGER NOT NULL Activity Number

    Default Value: WM_WO_INSPC_ACT.INSP_ACTIVITY_NBR

    6 INSP_STEP_NBR Number(5,0) INTEGER NOT NULL Step Number

    Default Value: 1

    7 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code

    Prompt Table: %EDITTABLE

    8 INSP_VALUE_STR50 Character(50) VARCHAR2(50) NOT NULL Value
    9 INSP_VALUE_SNUM Signed Number(29,4) DECIMAL(27,4) NOT NULL Value
    10 INSP_VALUE_DTTM DateTime(26) TIMESTAMP Value
    11 MEASUREMENT_UOM Character(3) VARCHAR2(3) NOT NULL Measurement Unit of Measure
    12 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    Default Value: N

    13 SHOW_HISTORY_FLG Character(1) VARCHAR2(1) NOT NULL Show History

    Y/N Table Edit

    Default Value: N

    14 INSP_COLLECT_OPRID Character(30) VARCHAR2(30) NOT NULL Collected by User
    15 INSP_COLLECT_DTTM DateTime(26) TIMESTAMP Collected DateTime
    16 LOG_ACCEPTANCE_FLG Character(1) VARCHAR2(1) NOT NULL Log Acceptance

    Y/N Table Edit

    Default Value: N

    17 INSP_ACCEPT_STATUS Character(1) VARCHAR2(1) NOT NULL Acceptance Status
    0=Rejected
    1=Accepted
    18 INSP_ACCEPT_OPRID Character(30) VARCHAR2(30) NOT NULL Accepted by User
    19 INSP_ACCEPT_DTTM DateTime(26) TIMESTAMP Acceptance DateTime
    20 LOG_INSTRUMENT_FLG Character(1) VARCHAR2(1) NOT NULL Log Measuring Instrument

    Y/N Table Edit

    Default Value: N

    21 INSTRMT_ASSET_OPTN Character(1) VARCHAR2(1) NOT NULL Instrument Asset Option
    0=Non-Asset
    1=Asset
    22 INSTRMT_ASSET_KEY1 Character(5) VARCHAR2(5) NOT NULL Instrument Asset Key1
    23 INSTRMT_ASSET_KEY2 Character(20) VARCHAR2(20) NOT NULL Instrument Asset Key2