WM_WO_INSPCD_VW(SQL View) |
Index Back |
---|---|
WO Inspection Insp Code View |
SELECT A.SETID , A.INSPECTION_CODE , '1' , A.INSP_MEASMT_TYPE AS INSP_CODE_SUBTYPE , A.DESCR50 , A.EFF_STATUS , A.MEASMT_DEVICE_TYPE , ' ' , ' ' , A.BASE_UOM , A.MEASMT_PRECIS_INT , A.MEASMT_NEGINT_FLG , A.MEASMT_PRECIS_DEC , A.MEASMT_AUTODEC_FLG , A.MEASMT_TOLER_OPT , A.LOWER_TOLERANCE , A.UPPER_TOLERANCE , ' ' , 0 , ' ' , A.ASSET_TYPE , A.ASSET_SUBTYPE , A.MFG_ID , A.MODEL FROM PS_WM_INSP_MMT_HDR A UNION SELECT B.SETID , B.INSPECTION_CODE , '2' , B.INSP_OBSRVN_TYPE AS INSP_CODE_SUBTYPE , B.DESCR50 , B.EFF_STATUS , ' ' , ' ' , ' ' , ' ' , 0 , ' ' , 0 , ' ' , ' ' , 0 , 0 , B.INSP_OBS_CHTX_OPT , B.INSP_OBS_CHTX_MAX , B.INSP_OBS_DTTM_OPT , B.ASSET_TYPE , B.ASSET_SUBTYPE , B.MFG_ID , B.MODEL FROM PS_WM_INSP_OBS_HDR B UNION SELECT C.SETID , C.INSPECTION_CODE , '3' , C.INSP_CALCLT_TYPE AS INSP_CODE_SUBTYPE , C.DESCR50 , C.EFF_STATUS , ' ' , C.INSP_VALID_STATUS , C.CALCLT_UNITS_OPT , C.BASE_UOM , 23 , 'Y' , 4 , ' ' , '0' , 0 , 0 , ' ' , 0 , ' ' , C.ASSET_TYPE , C.ASSET_SUBTYPE , C.MFG_ID , C.MODEL FROM PS_WM_INSP_CLC_HDR C |
# | 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
Prompt Table: %EDITTABLE |
3 | INSP_CODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Inspection Code Type
1=Measurement 2=Observation 3=Calculation |
4 | INSP_CODE_SUBTYPE | Character(2) | VARCHAR2(2) NOT NULL |
Inspection Code Subtype
Prompt Table: WM_INSP_CDSB_VW |
5 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
7 | MEASMT_DEVICE_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Measurement Device Type |
8 | INSP_VALID_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Validation Status
0=Invalid 1=Valid 2=New 4=Changed Default Value: 2 |
9 | CALCLT_UNITS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Calculation Units Option
0=None 1=Percent (%) 2=Unit of Measure |
10 | BASE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Base Unit of Measure
Prompt Table: UNITS_TBL |
11 | MEASMT_PRECIS_INT | Number(2,0) | SMALLINT NOT NULL | Integer Digits |
12 | MEASMT_NEGINT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Negative Value
Y/N Table Edit |
13 | MEASMT_PRECIS_DEC | Number(1,0) | SMALLINT NOT NULL | Decimal Digits |
14 | MEASMT_AUTODEC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Auto-Decimal Enabled
N=Disabled Y=Enabled |
15 | MEASMT_TOLER_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Measurement Tolerance Option
0=None 1=Range |
16 | LOWER_TOLERANCE | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Lower Tolerance |
17 | UPPER_TOLERANCE | Signed Number(21,4) | DECIMAL(19,4) NOT NULL | Upper Tolerance |
18 | INSP_OBS_CHTX_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Char/Text Display Option
1=Mixed case 2=Uppercase |
19 | INSP_OBS_CHTX_MAX | Number(3,0) | SMALLINT NOT NULL | Char/Text Maximum Length |
20 | INSP_OBS_DTTM_OPT | Character(1) | VARCHAR2(1) NOT NULL |
DateTime Display Option
1=DateTime 2=Date-part Only 3=Time-part Only |
21 | 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 |
22 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: AM_SUBTYPE |
23 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: WM_MANUFACTURER |
24 | MODEL | Character(30) | VARCHAR2(30) NOT NULL |
Model
Prompt Table: WM_WO_MFGMOD_VW |