WM_WO_INASD2_VW(SQL View) |
Index Back |
|---|---|
WO Inspection Asset Data View2 |
| SELECT A.BUSINESS_UNIT_AM , A.ASSET_ID , A.INSPECTION_CODE , A.INSP_COLLECT_DTTM , A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.INSPECTION_ID , A.INSP_ACTIVITY_NBR , A.INSP_STEP_NBR , A.INSP_VALUE_STR50 , CASE WHEN AA.READING IS NOT NULL THEN AA.READING ELSE A.INSP_VALUE_SNUM END , 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 , A.INSP_CODE_TYPE , A.INSP_CODE_SUBTYPE , A.MEASMT_DEVICE_TYPE , A.CALCLT_UNITS_OPT , A.BASE_UOM FROM PS_WM_WO_INASD1_VW A LEFT OUTER JOIN PS_AM_METER_READ AA ON AA.BUSINESS_UNIT = A.BUSINESS_UNIT_AM AND AA.ASSET_ID = A.ASSET_ID AND AA.METER_TYPE = A.MEASMT_DEVICE_TYPE AND AA.READING_DTTM = A.INSP_COLLECT_DTTM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_AM |
Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table: WM_ASSET_VWA |
| 3 | INSPECTION_CODE |
Character(20) | VARCHAR2(20) NOT NULL | Inspection Code |
| 4 | INSP_COLLECT_DTTM |
DateTime(26) | TIMESTAMP NOT NULL | Collected DateTime |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 6 | WO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: WM_FTRK_WOI_PVW |
| 7 | WO_TASK_ID | Number(5,0) | INTEGER NOT NULL |
Task Number
Prompt Table: WM_FTRK_TSK_PVW |
| 8 | INSPECTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Inspection ID |
| 9 | INSP_ACTIVITY_NBR | Number(5,0) | INTEGER NOT NULL | Activity Number |
| 10 | INSP_STEP_NBR | Number(5,0) | INTEGER NOT NULL | Step Number |
| 11 | INSP_VALUE_STR50 | Character(50) | VARCHAR2(50) NOT NULL | Value |
| 12 | INSP_VALUE_SNUM | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Value |
| 13 | INSP_VALUE_DTTM | DateTime(26) | TIMESTAMP | Value |
| 14 | MEASUREMENT_UOM | Character(3) | VARCHAR2(3) NOT NULL | Measurement Unit of Measure |
| 15 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit |
| 16 | SHOW_HISTORY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show History
Y/N Table Edit |
| 17 | INSP_COLLECT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Collected by User |
| 18 | LOG_ACCEPTANCE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Log Acceptance
Y/N Table Edit |
| 19 | INSP_ACCEPT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Acceptance Status
0=Rejected 1=Accepted |
| 20 | INSP_ACCEPT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Accepted by User |
| 21 | INSP_ACCEPT_DTTM | DateTime(26) | TIMESTAMP | Acceptance DateTime |
| 22 | INSP_CODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Code Type
1=Measurement 2=Observation 3=Calculation |
| 23 | INSP_CODE_SUBTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Inspection Code Subtype
Prompt Table: WM_INSP_CDSB_VW |
| 24 | MEASMT_DEVICE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Measurement Device Type |
| 25 | CALCLT_UNITS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Units Option
0=None 1=Percent (%) 2=Unit of Measure |
| 26 | BASE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Base Unit of Measure
Prompt Table: UNITS_TBL |