WM_WO_IPSRC_VW

(SQL View)
 Index Back

Inspection Activity Source Vw


SELECT A.SETID , A.INSPECTION_CODE , A.DESCR50 , A.EFF_STATUS , ' ' , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL , A.BASE_UOM FROM PS_WM_INSP_MMT_HDR A UNION SELECT B.SETID , B.INSPECTION_CODE , B.DESCR50 , B.EFF_STATUS , ' ' , 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 , C.DESCR50 , C.EFF_STATUS , C.INSP_VALID_STATUS , C.ASSET_TYPE , C.ASSET_SUBTYPE , C.MFG_ID , C.MODEL , C.BASE_UOM FROM PS_WM_INSP_CLC_HDR C

  • Related Language Record: WM_WO_IPSRC_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 INSP_ACTV_SRC_CODE Character(25) VARCHAR2(25) NOT NULL Inspection Activity Source

    Prompt Table: %EDITTABLE

    3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 INSP_VALID_STATUS Character(1) VARCHAR2(1) NOT NULL Validation Status
    0=Invalid
    1=Valid
    2=New
    4=Changed
    6 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
    7 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: WM_MANUFACTURER

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

    Prompt Table: WM_WO_MFGMOD_VW

    10 BASE_UOM Character(3) VARCHAR2(3) NOT NULL Base Unit of Measure

    Prompt Table: UNITS_TBL