WM_WO_INSPL_COL(SQL Table) |
Index Back |
|---|---|
Insp Plan Activity Collect |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: WM_WO_INSPL_ACT.SETID Prompt Table: SP_SETID_NONVW |
| 2 | WO_TEMPLATE_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Work Order Task/Job Template ID
Default Value: WM_WO_INSPL_ACT.WO_TEMPLATE_ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: WM_WO_INSPL_ACT.EFFDT |
| 4 | INSP_ACTIVITY_NBR |
Number(5,0) | INTEGER NOT NULL |
Activity Number
Default Value: WM_WO_INSPL_ACT.INSP_ACTIVITY_NBR |
| 5 | INSP_STEP_NBR |
Number(5,0) | INTEGER NOT NULL |
Step Number
Default Value: 1 |
| 6 | SEQ_NBR_5 | Number(5,0) | INTEGER NOT NULL | Sequence number five digits long |
| 7 | COLL_ACTV_SUBTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Collection Activity Subtype
0=Calibrate 1=Measure 2=Observe 3=Calculate |
| 8 | INSPECTION_CODE | Character(20) | VARCHAR2(20) NOT NULL |
Inspection Code
Prompt Table: %EDITTABLE |
| 9 | MEASUREMENT_UOM | Character(3) | VARCHAR2(3) NOT NULL | Measurement Unit of Measure |
| 10 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |
| 11 | SHOW_HISTORY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show History
Y/N Table Edit Default Value: N |
| 12 | LOG_ACCEPTANCE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Log Acceptance
Y/N Table Edit Default Value: N |
| 13 | LOG_INSTRUMENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Log Measuring Instrument
Y/N Table Edit Default Value: N |