WM_WO_INASD1_VW(SQL View) |
Index Back |
|---|---|
WO Inspection Asset Data View1 |
| SELECT TSK.BUSINESS_UNIT_AM , TSK.ASSET_ID , COL.INSPECTION_CODE , COL.INSP_COLLECT_DTTM , HDR.BUSINESS_UNIT , HDR.WO_ID , HDR.WO_TASK_ID , HDR.INSPECTION_ID , ACT.INSP_ACTIVITY_NBR , COL.INSP_STEP_NBR , COL.INSP_VALUE_STR50 , COL.INSP_VALUE_SNUM , COL.INSP_VALUE_DTTM , COL.MEASUREMENT_UOM , COL.REQUIRED_FLG , COL.SHOW_HISTORY_FLG , COL.INSP_COLLECT_OPRID , COL.LOG_ACCEPTANCE_FLG , COL.INSP_ACCEPT_STATUS , COL.INSP_ACCEPT_OPRID , COL.INSP_ACCEPT_DTTM , CDV.INSP_CODE_TYPE , CDV.INSP_CODE_SUBTYPE , CDV.MEASMT_DEVICE_TYPE , CDV.CALCLT_UNITS_OPT , CDV.BASE_UOM FROM PS_WM_WO_TSK TSK , PS_WM_WO_INSPC_HDR HDR , PS_WM_WO_INSPC_ACT ACT , PS_WM_WO_INSPC_COL COL , PS_WM_WO_INSPCD_VW CDV WHERE HDR.BUSINESS_UNIT = TSK.BUSINESS_UNIT AND HDR.WO_ID = TSK.WO_ID AND HDR.WO_TASK_ID = TSK.WO_TASK_ID AND HDR.WO_INSP_QUIT_OPTN <> '2' AND ACT.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND ACT.WO_ID = HDR.WO_ID AND ACT.WO_TASK_ID = HDR.WO_TASK_ID AND ACT.INSPECTION_ID = HDR.INSPECTION_ID AND ACT.INSP_ACTIVITY_TYPE = '3' AND (ACT.WO_INSPECT_STATUS = '09' OR COL.INSP_ACCEPT_STATUS = '1') AND COL.BUSINESS_UNIT = ACT.BUSINESS_UNIT AND COL.WO_ID = ACT.WO_ID AND COL.WO_TASK_ID = ACT.WO_TASK_ID AND COL.INSPECTION_ID = ACT.INSPECTION_ID AND COL.INSP_COLLECT_DTTM IS NOT NULL AND COL.INSP_ACCEPT_STATUS <> '0' AND CDV.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = COL.BUSINESS_UNIT AND SCR.REC_GROUP_ID = 'WM_01' AND SCR.RECNAME = 'WM_WO_INSPCD_VW') AND CDV.INSPECTION_CODE = COL.INSPECTION_CODE |
| # | 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 |