Module: Common
Type: Dimension
MEASR_COMP_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| MEASR_COMP_ID | VARCHAR2 | 12 | True | Measuring Component | |||
| SOURCE_RECORD_ID | VARCHAR2 | 12 | Source Record Id | ||||
| ADJ_LATEST_MSRMT_DTTM | TIMESTAMP | 0 | 6 | Adjust Latest Measurement Date/Time | |||
| D1_FULL_SCALE | NUMBER | 18 | 7 | Full Scale | |||
| D1_NBR_OF_DGTS_LFT | NUMBER | 5 | 0 | Number of Digits Left | |||
| D1_NBR_OF_DGTS_RGT | NUMBER | 5 | 0 | Number of Digits Right | |||
| D1_READ_SEQ | NUMBER | 5 | 0 | Read Sequence | |||
| LATEST_MSRMT_DTTM | TIMESTAMP | 0 | 6 | Latest Measurement Date/Time | |||
| MEASR_COMP_MULTIPLIER | NUMBER | 12 | 6 | Measuring Component Multiplier | |||
| MEASR_COMP_USAGE_FLG | VARCHAR2 | 38 | How To Use | ||||
| MOST_RECENT_MSRMT_DTTM | TIMESTAMP | 0 | 6 | Most Recent Read Date/Time | |||
| MOST_RECENT_MSRMT_READING_COND | VARCHAR2 | 38 | Most Recent Read Condition | ||||
| MOST_RECENT_MSRMT_READING_VAL | NUMBER | 16 | 6 | Most Recent Read Value | |||
| MOST_RECENT_NON_EST_MSRMT_DTTM | TIMESTAMP | 0 | 6 | Most Recent Non Estimated Read Date/Time | |||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |