WM_WO_INASD3_VW

(SQL View)
 Index Back

WO Inspection Asset Data View3


SELECT ROWNUM AS INSP_COL_ROW_NBR , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.INSPECTION_CODE , A.INSP_COLLECT_DTTM , A.BUSINESS_UNIT , A.INSPECTION_ID , A.INSP_VALUE_STR50 , A.INSP_VALUE_SNUM , A.INSP_VALUE_DTTM , A.MEASUREMENT_UOM , A.REQUIRED_FLG , A.SHOW_HISTORY_FLG , A.INSP_COLLECT_OPRID , A.LOG_ACCEPTANCE_FLG , A.INSP_ACCEPT_STATUS , A.INSP_ACCEPT_OPRID , A.INSP_ACCEPT_DTTM FROM PS_WM_WO_INASD2_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSP_COL_ROW_NBR Number(10,0) DECIMAL(10) NOT NULL Data Collection Row Number
2 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

3 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

Prompt Table: WM_ASSET_VWA

4 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code
5 INSP_COLLECT_DTTM DateTime(26) TIMESTAMP NOT NULL Collected DateTime
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

7 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID
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

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

Y/N Table Edit

14 INSP_COLLECT_OPRID Character(30) VARCHAR2(30) NOT NULL Collected by User
15 LOG_ACCEPTANCE_FLG Character(1) VARCHAR2(1) NOT NULL Log Acceptance

Y/N Table Edit

16 INSP_ACCEPT_STATUS Character(1) VARCHAR2(1) NOT NULL Acceptance Status
0=Rejected
1=Accepted
17 INSP_ACCEPT_OPRID Character(30) VARCHAR2(30) NOT NULL Accepted by User
18 INSP_ACCEPT_DTTM DateTime(26) TIMESTAMP Acceptance DateTime