BUSINESS_UNITPrompt Table: SP_BU_WM_NONVW
INSPECTION_IDINSPECTION_CODEPrompt Table: %EDITTABLE
INSP_ACTIVITY_NBRINSP_STEP_NBRWM_WO_INCLPV_VW(SQL View) |
Index Back |
|---|---|
WO Inspect Calc ParmValue View |
| SELECT A.BUSINESS_UNIT , A.INSPECTION_ID , A.INSPECTION_CODE , A.INSP_ACTIVITY_NBR , A.INSP_STEP_NBR , A.INSP_VALUE_STR50 , A.INSP_VALUE_SNUM , A.INSP_VALUE_DTTM FROM PS_WM_WO_INSPC_COL A , PS_WM_INCLC_CP_VW B WHERE A.INSP_COLLECT_DTTM IS NOT NULL AND A.INSP_ACCEPT_STATUS <> '0' AND B.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND REC_GROUP_ID = 'WM_01' AND RECNAME = 'WM_INCLC_CP_VW') AND B.CALCLT_PARM_CODE = A.INSPECTION_CODE AND B.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_WM_NONVW |
| 2 | INSPECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Inspection ID |
| 3 | INSPECTION_CODE |
Character(20) | VARCHAR2(20) NOT NULL |
Inspection Code
Prompt Table: %EDITTABLE |
| 4 | INSP_ACTIVITY_NBR |
Number(5,0) | INTEGER NOT NULL | Activity Number |
| 5 | INSP_STEP_NBR |
Number(5,0) | INTEGER NOT NULL | Step Number |
| 6 | INSP_VALUE_STR50 | Character(50) | VARCHAR2(50) NOT NULL | Value |
| 7 | INSP_VALUE_SNUM | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Value |
| 8 | INSP_VALUE_DTTM | DateTime(26) | TIMESTAMP | Value |