WM_WO_INACT_VW

(SQL View)
 Index Back

Work Order Inspection Activity


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.INSPECTION_ID , A.INSP_ACTIVITY_NBR , A.DEPEND_ACTV_NBR , A.INSP_ACTIVITY_TYPE , A.INSP_ACTV_SRC_CODE , A.DESCR50 , A.WO_INSPECT_STATUS , A.STATUS_DTTM , A.WO_DURATION , A.WO_DURATION2 , A.INSPECT_START_DTTM , A.INSPECT_END_DTTM , A.CRAFT_ID , A.EMPLID , (%Sql(WM_WO_INSPC_ITEM_CNT_SEL, PS_WM_WO_INSPC_COL)) , (%Sql(WM_WO_INSPC_REQ_CNT_SEL, PS_WM_WO_INSPC_COL)) , (%Sql(WM_WO_INSPC_ITEM_CNT_SEL, PS_WM_WO_INSPC_EVL)) , (%Sql(WM_WO_INSPC_ITEM_CNT_SEL, PS_WM_WO_INSPC_INS)) , (%Sql(WM_WO_INSPC_CKLIST_CNT_SEL, '1')) , (%Sql(WM_WO_INSPC_CKLIST_CNT_SEL, '2')) , (%Sql(WM_WO_INSPC_ITEM_CNT_SEL, PS_WM_WO_INSPC_NOT)) , (%Sql(WM_WO_INSPC_ITEM_CNT_SEL, PS_WM_WO_INSPC_ATT)) , (%Sql(WM_WO_INSPC_LASTDTTM_SEL, PS_WM_WO_INSPC_COL, INSP_COLLECT_DTTM)) , (%Sql(WM_WO_INSPC_LASTDTTM_SEL, PS_WM_WO_INSPC_CKL, COMPLETED_DTTM)) FROM PS_WM_WO_INSPC_ACT A

  • Parent record: WM_WO_INSPC_HDR

    • # 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_HDR.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_HDR.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_HDR.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_HDR.INSPECTION_ID

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

    Default Value: 1

    6 DEPEND_ACTV_NBR Number(3,0) SMALLINT NOT NULL Parent Activity No.
    7 INSP_ACTIVITY_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection Activity Type
    1=Asset Verification
    2=Tool Calibration
    3=Data Collection
    4=Trigger Evaluation
    8=Sub-Plan
    9=Other Logistics
    8 INSP_ACTV_SRC_CODE Character(25) VARCHAR2(25) NOT NULL Inspection Activity Source

    Prompt Table: %EDITTABLE

    9 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    10 WO_INSPECT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
    01=Created
    02=Assigned
    03=In Progress
    09=Completed
    99=Terminated

    Default Value: 01

    11 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
    12 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration
    13 WO_DURATION2 Number(8,2) DECIMAL(7,2) NOT NULL Actual (Calc) Duration
    14 INSPECT_START_DTTM DateTime(26) TIMESTAMP Activity Start DateTime
    15 INSPECT_END_DTTM DateTime(26) TIMESTAMP Activity End DateTime
    16 CRAFT_ID Character(16) VARCHAR2(16) NOT NULL Craft Identification

    Prompt Table: RS_CRAFT_DETAIL

    17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE2

    18 WM_DATA_CNT Number(5,0) INTEGER NOT NULL Data Collection Count
    19 WM_DATA_REQ_CNT Number(5,0) INTEGER NOT NULL Required Count
    20 WM_EVAL_CNT Number(5,0) INTEGER NOT NULL Data Evaluation Count
    21 WM_INSTR_CNT Number(5,0) INTEGER NOT NULL Instructions Count
    22 WM_PRE_CHKLST_CNT Number(5,0) INTEGER NOT NULL Pre-Checklist Count
    23 WM_POST_CHKLST_CNT Number(5,0) INTEGER NOT NULL Post-Checklist Count
    24 WM_NOTE_CNT Number(5,0) INTEGER NOT NULL Notes Count
    25 WM_ATTACHMENT_CNT Number(5,0) INTEGER NOT NULL Attachments Count
    26 INSP_COLLECT_DTTM DateTime(26) TIMESTAMP Collected DateTime
    27 COMPLETED_DTTM DateTime(26) TIMESTAMP Completed Datetime