WM_WO_INSPCD_VW

(SQL View)
Index Back

WO Inspection Insp Code View


SELECT A.SETID , A.INSPECTION_CODE , '1' , A.INSP_MEASMT_TYPE AS INSP_CODE_SUBTYPE , A.DESCR50 , A.EFF_STATUS , A.MEASMT_DEVICE_TYPE , ' ' , ' ' , A.BASE_UOM , A.MEASMT_PRECIS_INT , A.MEASMT_NEGINT_FLG , A.MEASMT_PRECIS_DEC , A.MEASMT_AUTODEC_FLG , A.MEASMT_TOLER_OPT , A.LOWER_TOLERANCE , A.UPPER_TOLERANCE , ' ' , 0 , ' ' , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL FROM PS_WM_INSP_MMT_HDR A UNION SELECT B.SETID , B.INSPECTION_CODE , '2' , B.INSP_OBSRVN_TYPE AS INSP_CODE_SUBTYPE , B.DESCR50 , B.EFF_STATUS , ' ' , ' ' , ' ' , ' ' , 0 , ' ' , 0 , ' ' , ' ' , 0 , 0 , B.INSP_OBS_CHTX_OPT , B.INSP_OBS_CHTX_MAX , B.INSP_OBS_DTTM_OPT , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL FROM PS_WM_INSP_OBS_HDR B UNION SELECT C.SETID , C.INSPECTION_CODE , '3' , C.INSP_CALCLT_TYPE AS INSP_CODE_SUBTYPE , C.DESCR50 , C.EFF_STATUS , ' ' , C.INSP_VALID_STATUS , C.CALCLT_UNITS_OPT , C.BASE_UOM , 23 , 'Y' , 4 , ' ' , '0' , 0 , 0 , ' ' , 0 , ' ' , C.ASSET_TYPE , C.ASSET_SUBTYPE , C.MFG_ID , C.MODEL FROM PS_WM_INSP_CLC_HDR C

  • Related Language Record: WM_WO_INSPCD_LV
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

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

    Prompt Table: %EDITTABLE

    3 INSP_CODE_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection Code Type
    1=Measurement
    2=Observation
    3=Calculation
    4 INSP_CODE_SUBTYPE Character(2) VARCHAR2(2) NOT NULL Inspection Code Subtype

    Prompt Table: WM_INSP_CDSB_VW

    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 MEASMT_DEVICE_TYPE Character(30) VARCHAR2(30) NOT NULL Measurement Device Type
    8 INSP_VALID_STATUS Character(1) VARCHAR2(1) NOT NULL Validation Status
    0=Invalid
    1=Valid
    2=New
    4=Changed

    Default Value: 2

    9 CALCLT_UNITS_OPT Character(1) VARCHAR2(1) NOT NULL Calculation Units Option
    0=None
    1=Percent (%)
    2=Unit of Measure
    10 BASE_UOM Character(3) VARCHAR2(3) NOT NULL Base Unit of Measure

    Prompt Table: UNITS_TBL

    11 MEASMT_PRECIS_INT Number(2,0) SMALLINT NOT NULL Integer Digits
    12 MEASMT_NEGINT_FLG Character(1) VARCHAR2(1) NOT NULL Allow Negative Value

    Y/N Table Edit

    13 MEASMT_PRECIS_DEC Number(1,0) SMALLINT NOT NULL Decimal Digits
    14 MEASMT_AUTODEC_FLG Character(1) VARCHAR2(1) NOT NULL Auto-Decimal Enabled
    N=Disabled
    Y=Enabled
    15 MEASMT_TOLER_OPT Character(1) VARCHAR2(1) NOT NULL Measurement Tolerance Option
    0=None
    1=Range
    16 LOWER_TOLERANCE Signed Number(21,4) DECIMAL(19,4) NOT NULL Lower Tolerance
    17 UPPER_TOLERANCE Signed Number(21,4) DECIMAL(19,4) NOT NULL Upper Tolerance
    18 INSP_OBS_CHTX_OPT Character(1) VARCHAR2(1) NOT NULL Char/Text Display Option
    1=Mixed case
    2=Uppercase
    19 INSP_OBS_CHTX_MAX Number(3,0) SMALLINT NOT NULL Char/Text Maximum Length
    20 INSP_OBS_DTTM_OPT Character(1) VARCHAR2(1) NOT NULL DateTime Display Option
    1=DateTime
    2=Date-part Only
    3=Time-part Only
    21 ASSET_TYPE Character(3) VARCHAR2(3) NOT NULL Asset Type
    010=IT Hardware
    020=IT Software
    040=Equipment
    050=Property
    060=Fleet
    070=Machinery
    080=Furniture
    090=Facility
    100=Intangible
    200=Asset Retirement Obligations
    999=Other
    22 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    23 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: WM_MANUFACTURER

    24 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: WM_WO_MFGMOD_VW