WM_INOBS_UPD_VW

(SQL View)
Index Back

Inspection Obsrvn UpdSrch View

Inspection Observation Existing-Search View

SELECT SETID , INSPECTION_CODE , INSP_OBSRVN_TYPE , DESCR50 , INSP_RSLT_STAT_FLG , EFF_STATUS , ASSET_TYPE , ASSET_SUBTYPE , MFG_ID , MODEL FROM PS_WM_INSP_OBS_HDR

  • Related Language Record: WM_INOBS_UPD_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
    3 INSP_OBSRVN_TYPE Character(2) VARCHAR2(2) NOT NULL Observation Type
    10=Char/Text
    21=Unranked CodeList
    22=Ranked CodeList
    23=Toggle CodeList
    30=DateTime
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    5 INSP_RSLT_STAT_FLG Character(1) VARCHAR2(1) NOT NULL Inspection Result Code
    N=No
    Y=Yes

    Default Value: N

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    7 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
    8 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

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

    Prompt Table: WM_MANUFACTURER

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

    Prompt Table: WM_WO_MFGMOD_VW