MIMOSA CRIS V2-1


Row Status Type Code

#12 - row_status_type

rstat_type_cod SMALLINT  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL
last_upd_db_site INTEGER  NOT NULL
last_upd_db_id INTEGER  NOT NULL
rstat_type_code SMALLINT  NOT NULL

Foreign keys:

Used By:

Site Table
Site Database Table
Manufacturer Table
Service Segment Type Table
Segment Type Child Table
Service Segment Table
Segment Child Table
Reference Unit Table
Engineering Unit Table
Engineering Unit Enumerated List Table
Segment Numeric Data Type Table
Segment Character Data Type Table
Segment Numeric Data Table
Segment Character Data Table
Segment/Asset Event Type Table
Segment Event Table
Asset Type Table
Asset Type Child Table
Model/Part Number Table ( Model Asset )
Model/Part Child Table
Asset Numeric Data Type Table
Asset Character Data Type Table
Model Numeric Data Table
Model Character Data Table
Asset Readiness Type
Asset Table
Asset Child Table
Asset Numeric Data Table
Asset Character Data Table
Asset Event Table
Asset Utilization on Segment History Table
Purchase Condition Type
Asset Owner History Table
Measurement Location Type Table
Data Source Type Table
Transducer Type Table
Transducer Sensitive Axis Direction Type Table
Meas. Location Data Calculation Type
Measurement Location Table
Ordered List Table
Ordered List of Measurement Locations Table
Ordered List of Eng. Units at Measurement Locations Table
Data Source Asset Table ( Subset of Asset Table )
Transducer Asset Table ( Subset of Asset Table )
Data Quality Type Table
Measurement Event History Table
Measurement Event Associations
Measurement Event Remarks Table
Measurement Event Numeric Data Table
Measurement Event Character Data Table
Alarm Severity Table
Alarm Type Table
Num_Alarm_Reg
agent_type
agent
Source Signal Detector Type Table
Post-Processed Signal Processing Scaling Mode Table
Measurement Event Numeric Data Alarm Table
Numeric Alarm Associated Regions in Alarm
Signal-processed Amplitudes Alarm Regions
Signal Process Type Table
Signal Process Block Table
Signal Process Block Numeric Data Type Table
Signal Process Block Numeric Data Table
Signal Process Stream Type
Signal Process Stream Table
Signal Process Stream Blocks Table
Average Type Table
Average Weight Type Table
Average Synchronization Type Table
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed Frequency/Order Single Amplitude Data Alarm Table
Signal-Processed Amplitude Associated Regions in Alarm
Window Type Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table
Collection Setup Parameters Needed to Collect Amplitude Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect FFT Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect Time Waveform Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect CPB Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table
Types of MIMOSA Technology
MIMOSA Support Levels
MIMOSA Data Categories
MIMOSA Functionality Type
MIMOSA Interface Type
MIMOSA Interfaces Supported By A Database
Database Connection Information To Connect Two Databases
Network Type
Event Type Child
Sample Test Type
Sample Numeric Data Type
Sample Character Data Type
Test Results Numeric Data Type
Test Results Char Data Type
Test Results Binary Large Object Data Type
Binary Large Object Data Type
Measurement Event Binary Large Object Type
Highlight Area Type
Agent Role Type
Event Numeric Data Type
Severity Type
Health Grade Type
Priority Type
Work Management Type
Work Task Type
Work Task Parent Child Taxonomy
Change Pattern Type
Work Audit Type
Work Numeric Data Type
Work Chr Data Type
Solution Package Type
Network
Segment Network Connect
Asset Network Connect
Agent Role
Agent Role With Associated Agent
Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample
Measurement Sample Master To Subsequent Child Sub-Samples
Measurement Sample Numeric Data
Measurement Sample Character Data
Measurement Sample Remark
Measurement Sample Test
Measurement Sample Test Numeric Results
Measurement Sample Test Character Results
Measurement Sample Test Remark
Measurement Sample Test Histogram
Measurement Sample Test Numeric Result Alarms
Sample Test Alarm Associated Regions in Alarm
Measurement Sample Test Binary Results
Measurement Sample Test BLOB Result Alarm
Segment Type Binary Data Related To a Specific Database
Segment Binary Data Related To a Specific Database
Model Binary Data Related to a Specific Database
Asset Type Binary Data
Asset Binary Data
Ordered List Binary Data
Measurement Event Binary Data
Blob Grid Data
Measurement Event BLOB Data Alarm
Measurement Event BLOB Data Area in Alarm
Segment Function
Asset Function
Segment Type Function
Asset Type Function
Model Function
Segment Events Linked to Functions Affected
Asset Events Linked to Functions Affected
Segment Event Numeric Data
Asset Event Numeric Data
Segment Events Associated With Measurement Event
Asset Events Associated With Measurement Event
Segment Event Link
Asset Event Link
Hypothetical Segment Event
Hypothetical Asset Event
Hypothetical Segment Type Event
Hypothetical Asset Type Event
Hypothetical Model Event
Hypothetical Segment Event Link
Hypothetical Asset Event Link
Hypothetical Segment Type Event Link
Hypothetical Asset Type Event Link
Hypothetical Model Event Link
Segment Hypothetical Event Numeric Data
Asset Hypothetical Event Numeric Data
Segment Type Hypothetical Event Numeric Data
Asset Type Hypothetical Event Numeric Data
Model Hypothetical Event Numeric Data
Segment Hypothetical Events Linked to Functions Affected
Asset Hypothetical Events Linked to Functions Affected
Segment Type Hypothetical Events Linked To Functions Affected
Asset Type Hypothetical Events Linked To Functions Affected
Model Hypothetical Events Linked to Functions Affected
Proposed Segment Event
Proposed Asset Event
Proposed Segment Event Link
Proposed Asset Event Link
Segment Proposed Event Numeric Data
Asset Proposed Event Numeric Data
Proposed Segment Events Linked to Functions Affected
Proposed Asset Events Linked to Functions Affected
Proposed Segment Events Linked to Hypothetical Segment Events
Proposed Asset Events Linked to Hypothetical Asset Events
Proposed Segment Events Linked to Actual Segment Event
Proposed Asset Events Linked to Actual Asset Event
Proposed Segment Events Associated With Measurement Event
Proposed Asset Events Associated With Measurement Event
Segment Health Assessment History
Asset Health Assessment History for past/present/future
Actual Segment Events Associated With Segment Health
Actual Asset Events Associated With Asset Health
Proposed Segment Events Associated With Segment Health
Proposed Asset Events Associated With Asset Health
Segment Remaining Life Assessment History
Asset Remaining Life Assessment History
Segment Recommendation
Asset Recommendation
Ordered List Recommendation
Segment Type Recommendation
Asset Type Recommendation
Model Recommendation
Segment Recommendation Remarks
Asset Recommendation Remarks
Ordered List Recommendation Remarks
Segment Type Recommendation Remarks
Asset Type Recommendation Remarks
Segment Type Recommendation Remarks
Binary Data Related to a Segment Recommendation
Binary Data Related to an Asset Recommendation
Binary Data Related to a Segment Type Recommendation
Binary Data Related to an Asset Type Recommendation
Binary Data Related to a Model Recommendation
Segment Health Assessments Linked to Segment Recommendations
Asset Health Assessments Linked to Asset Recommendations
Actual Segment Events Linked to Segment Recommendations
Actual Asset Events Linked to Asset Recommendations
Hypothetical Service Segment Events Linked to Segment Recommendations
Hypothetical Asset Events Linked to Asset Recommendations
Hypothetical Segment Events Linked to Segment Type Recommendations
Hypothetical Asset Events Linked to Asset Type Recommendations
Hypothetical Model Events Linked to Model Recommendations
Proposed Service Segment Events Linked to Segment Recommendations
Proposed Asset Events Linked to Asset Recommendations
Measurement Events Linked to Segment Recommendations
Measurement Events Linked to Asset Recommendations
Work Request
Solution Package
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Associated Segment Recommendations for a Work Request
Associated Asset Recommendations for a Work Request
Associated Solution Packages For a Work Request
Work Request Numeric Data
Work Request Character Data
Work Request Audit
Work Order
Work Order Child
Work Order Numeric Data
Work Order Character Data
Work Order Audit
Work Order Step
Work Order Step Numeric Data
Work Order Step Character Data
Work Order Step Audit
Work Order Step Segment Recommendation
Work Order Step Asset Recommendation
Work Order Step Solution Package
Work Order Step Work Request
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists

Notes:

 The row status code is a foreign key in every other table to
 define the status of the row. These codes will not change.
 The entries will include the following:

 1 = Active Row
 2 = Inactive Row
 3 = Soft Deleted Row

 NOTE: MIMOSA populates and maintains this table.
 No user-defined entries are supported.

 NOTE: The gmt_last_updated column is in every table to store the
 the date the row was inserted or updated.

 NOTE: All gmt fields are in Greenwich Mean Time
 in the format YYYY-MM-DD HH:MM:SS-BBBBBBBBB in 24-hour
 format like: 1995-02-27 18:01:03-500000000 which is equivalent
 to 27-Feb-1995 6:01 PM at 3.5 seconds


Site Table

#13 - site

site_code INTEGER  NOT NULL
company_name VARCHAR(254)  NOT NULL
site_name VARCHAR(254)  NOT NULL
phys_addr VARCHAR(254)  
phys_city_name VARCHAR(60)  
phys_state_abbr CHAR(2)  
phys_postal_code VARCHAR(10)  
phys_country_abb CHAR(3)  
mail_addr VARCHAR(254)  
mail_city_name VARCHAR(60)  
mail_state_abbr CHAR(2)  
mail_postal_code VARCHAR(10)  
mail_country_abb CHAR(3)  
us_ph_number CHAR(10)  
int_ph_contry_no VARCHAR(3)  
int_ph_city_no VARCHAR(5)  
int_ph_local_no VARCHAR(10)  
us_fax_number CHAR(10)  
int_fax_cntry_no VARCHAR(3)  
int_fax_city_no VARCHAR(5)  
int_fax_local_no VARCHAR(10)  
business_desc VARCHAR(254)  
primary_sic VARCHAR(8)  
gmt_last_updated CHAR(29)  NOT NULL
last_upd_db_site INTEGER  NOT NULL
last_upd_db_id INTEGER  NOT NULL

Foreign keys:

row_status_type () [rstat_type_code] NOT NULL

Used By:

Site Database Table
Service Segment Table
Asset Table
Asset Owner History Table
Asset Owner History Table
Measurement Location Table
agent

Notes:

 The site table holds information about the physical location
 in the world where objects which are being monitored exist and
 databases reside.

 NOTE: For all for-profit businesses, the site_code is the
 D-U-N-S number of the location-- a randomly-generated
 nine-digit number assigned by Dunn & Bradstreet.
 The D-U-N-S number is based on a coding system called the
 Data Universal Numbering System, hence it's name "D-U-N-S".
 This code is used to identify 38 million current and former
 business locations throught the world. Each location of
 a company is assigned a unique D-U-N-S number which does not
 change and will not be reassigned if the location closes.
 To locate your location's D-U-N-S number, please call Dun &
 Bradstreet Information Resources Customer Service at
 1-800-333-0505. This is a free service.

 NOTE: The model stores the D-U-N-S number as an integer, which
 does not preserve the leading zeroes in the DUNS number. To
 display the number to a user, left pad the number with zeroes
 to 9 digits.

 NOTE: For non-profit and government locations, you will need to
 have a MIMOSA number assigned. A group of numbers will
 be assigned to your corporate organization. A representative
 from your corporate organization should e-mail Kenneth Bever
 at kenneth_bever@hsb.com with the name of your organization,
 the number of locations in our organization, your name,
 title, and phone number. You will be sent a range of
 of MIMOSA numbers ( all over 999, 999, 999)  which you can
 then assign to each of your locations.

 NOTE: A negative D-U-N-S number can be used for temporary
 assignment when no correct D-U-N-S number is available.
 This should not be used permanently because the integration
 of multiple site data will later be troublesome, i.e.,
 both sites export with the D-U-N-S number of -1.

 NOTE: The last_upd_db_site, last_upd_db_id columns are included
 in all tables, except tables managed and populated by MIMOSA,
 to store the database site and the DB identifier which made the
 insert or last update to each row. This is a foreign key to
 to the site_database table, but we cannot define this
 relationship because the table is not yet created.

 NOTE: The optional field primary_sic relates to the primary Standard
 Industry Code ( SIC)  for the site. This code is linked in a SIC
 reference book to the type of industry the site is associated
 with.

 NOTE: On address lines, line breaks are denoted by a backslash "\"
 character.


Site Database Table

#15 - site_database

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
mf_db_site INTEGER  
mf_db_id INTEGER  
mf_duns_code INTEGER  
gmt_last_updated CHAR(29)  NOT NULL
last_upd_db_site INTEGER  NOT NULL
last_upd_db_id INTEGER  NOT NULL

Foreign keys:

site () [db_site] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Manufacturer Table
Manufacturer Table
Service Segment Type Table
Service Segment Type Table
Segment Type Child Table
Service Segment Table
Segment Child Table
Reference Unit Table
Engineering Unit Table
Engineering Unit Table
Engineering Unit Enumerated List Table
Segment Numeric Data Type Table
Segment Numeric Data Type Table
Segment Character Data Type Table
Segment Character Data Type Table
Segment Numeric Data Table
Segment Character Data Table
Segment/Asset Event Type Table
Segment/Asset Event Type Table
Segment Event Table
Asset Type Table
Asset Type Table
Asset Type Child Table
Model/Part Number Table ( Model Asset )
Model/Part Child Table
Asset Numeric Data Type Table
Asset Numeric Data Type Table
Asset Character Data Type Table
Asset Character Data Type Table
Model Numeric Data Table
Model Character Data Table
Asset Readiness Type
Asset Readiness Type
Asset Table
Asset Child Table
Asset Numeric Data Table
Asset Character Data Table
Asset Event Table
Asset Utilization on Segment History Table
Purchase Condition Type
Purchase Condition Type
Asset Owner History Table
Measurement Location Type Table
Measurement Location Type Table
Data Source Type Table
Data Source Type Table
Transducer Type Table
Transducer Sensitive Axis Direction Type Table
Transducer Sensitive Axis Direction Type Table
Meas. Location Data Calculation Type
Meas. Location Data Calculation Type
Measurement Location Table
Ordered List Table
Ordered List Table
Ordered List of Measurement Locations Table
Ordered List of Eng. Units at Measurement Locations Table
Data Source Asset Table ( Subset of Asset Table )
Transducer Asset Table ( Subset of Asset Table )
Data Quality Type Table
Measurement Event History Table
Measurement Event Associations
Measurement Event Remarks Table
Measurement Event Numeric Data Table
Measurement Event Character Data Table
Alarm Severity Table
Alarm Type Table
Alarm Type Table
Num_Alarm_Reg
Num_Alarm_Reg
agent_type
agent_type
agent
Source Signal Detector Type Table
Source Signal Detector Type Table
Post-Processed Signal Processing Scaling Mode Table
Post-Processed Signal Processing Scaling Mode Table
Measurement Event Numeric Data Alarm Table
Numeric Alarm Associated Regions in Alarm
Signal-processed Amplitudes Alarm Regions
Signal-processed Amplitudes Alarm Regions
Signal Process Type Table
Signal Process Type Table
Signal Process Block Table
Signal Process Block Table
Signal Process Block Numeric Data Type Table
Signal Process Block Numeric Data Type Table
Signal Process Block Numeric Data Table
Signal Process Stream Type
Signal Process Stream Type
Signal Process Stream Table
Signal Process Stream Table
Signal Process Stream Blocks Table
Average Type Table
Average Type Table
Average Weight Type Table
Average Weight Type Table
Average Synchronization Type Table
Average Synchronization Type Table
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed Frequency/Order Single Amplitude Data Alarm Table
Signal-Processed Amplitude Associated Regions in Alarm
Window Type Table
Window Type Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table
Collection Setup Parameters Needed to Collect Amplitude Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect FFT Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect Time Waveform Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect CPB Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table
Types of MIMOSA Technology
MIMOSA Support Levels
MIMOSA Data Categories
MIMOSA Functionality Type
MIMOSA Interface Type
MIMOSA Interfaces Supported By A Database
MIMOSA Interfaces Supported By A Database
Database Connection Information To Connect Two Databases
Database Connection Information To Connect Two Databases
Database Connection Information To Connect Two Databases
Network Type
Network Type
Event Type Child
Sample Test Type
Sample Test Type
Sample Numeric Data Type
Sample Numeric Data Type
Sample Character Data Type
Sample Character Data Type
Test Results Numeric Data Type
Test Results Numeric Data Type
Test Results Char Data Type
Test Results Char Data Type
Test Results Binary Large Object Data Type
Test Results Binary Large Object Data Type
Binary Large Object Data Type
Binary Large Object Data Type
Measurement Event Binary Large Object Type
Measurement Event Binary Large Object Type
Highlight Area Type
Highlight Area Type
Agent Role Type
Agent Role Type
Event Numeric Data Type
Event Numeric Data Type
Severity Type
Health Grade Type
Priority Type
Work Management Type
Work Management Type
Work Task Type
Work Task Type
Work Task Parent Child Taxonomy
Change Pattern Type
Change Pattern Type
Work Audit Type
Work Audit Type
Work Numeric Data Type
Work Numeric Data Type
Work Chr Data Type
Work Chr Data Type
Solution Package Type
Solution Package Type
Network
Network
Segment Network Connect
Asset Network Connect
Agent Role
Agent Role With Associated Agent
Alarm Regions for Measurement Location Sample Test Numeric Results
Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample
Measurement Sample Master To Subsequent Child Sub-Samples
Measurement Sample Numeric Data
Measurement Sample Character Data
Measurement Sample Remark
Measurement Sample Test
Measurement Sample Test Numeric Results
Measurement Sample Test Character Results
Measurement Sample Test Remark
Measurement Sample Test Histogram
Measurement Sample Test Numeric Result Alarms
Sample Test Alarm Associated Regions in Alarm
Measurement Sample Test Binary Results
Measurement Sample Test BLOB Result Alarm
Segment Type Binary Data Related To a Specific Database
Segment Type Binary Data Related To a Specific Database
Segment Binary Data Related To a Specific Database
Segment Binary Data Related To a Specific Database
Model Binary Data Related to a Specific Database
Model Binary Data Related to a Specific Database
Asset Type Binary Data
Asset Type Binary Data
Asset Binary Data
Asset Binary Data
Ordered List Binary Data
Ordered List Binary Data
Measurement Event Binary Data
Blob Grid Data
Measurement Event BLOB Data Alarm
Measurement Event BLOB Data Area in Alarm
Segment Function
Segment Function
Asset Function
Asset Function
Segment Type Function
Segment Type Function
Asset Type Function
Asset Type Function
Model Function
Model Function
Segment Events Linked to Functions Affected
Asset Events Linked to Functions Affected
Segment Event Numeric Data
Asset Event Numeric Data
Segment Events Associated With Measurement Event
Asset Events Associated With Measurement Event
Segment Event Link
Asset Event Link
Hypothetical Segment Event
Hypothetical Segment Event
Hypothetical Asset Event
Hypothetical Asset Event
Hypothetical Segment Type Event
Hypothetical Segment Type Event
Hypothetical Asset Type Event
Hypothetical Asset Type Event
Hypothetical Model Event
Hypothetical Model Event
Hypothetical Segment Event Link
Hypothetical Asset Event Link
Hypothetical Segment Type Event Link
Hypothetical Asset Type Event Link
Hypothetical Model Event Link
Segment Hypothetical Event Numeric Data
Asset Hypothetical Event Numeric Data
Segment Type Hypothetical Event Numeric Data
Asset Type Hypothetical Event Numeric Data
Model Hypothetical Event Numeric Data
Segment Hypothetical Events Linked to Functions Affected
Asset Hypothetical Events Linked to Functions Affected
Segment Type Hypothetical Events Linked To Functions Affected
Asset Type Hypothetical Events Linked To Functions Affected
Model Hypothetical Events Linked to Functions Affected
Proposed Segment Event
Proposed Segment Event
Proposed Asset Event
Proposed Asset Event
Proposed Segment Event Link
Proposed Asset Event Link
Segment Proposed Event Numeric Data
Asset Proposed Event Numeric Data
Proposed Segment Events Linked to Functions Affected
Proposed Asset Events Linked to Functions Affected
Proposed Segment Events Linked to Hypothetical Segment Events
Proposed Asset Events Linked to Hypothetical Asset Events
Proposed Segment Events Linked to Actual Segment Event
Proposed Asset Events Linked to Actual Asset Event
Proposed Segment Events Associated With Measurement Event
Proposed Asset Events Associated With Measurement Event
Segment Health Assessment History
Asset Health Assessment History for past/present/future
Actual Segment Events Associated With Segment Health
Actual Asset Events Associated With Asset Health
Proposed Segment Events Associated With Segment Health
Proposed Asset Events Associated With Asset Health
Segment Remaining Life Assessment History
Asset Remaining Life Assessment History
Segment Recommendation
Asset Recommendation
Ordered List Recommendation
Segment Type Recommendation
Asset Type Recommendation
Model Recommendation
Segment Recommendation Remarks
Asset Recommendation Remarks
Ordered List Recommendation Remarks
Segment Type Recommendation Remarks
Asset Type Recommendation Remarks
Segment Type Recommendation Remarks
Binary Data Related to a Segment Recommendation
Binary Data Related to an Asset Recommendation
Binary Data Related to a Segment Type Recommendation
Binary Data Related to an Asset Type Recommendation
Binary Data Related to a Model Recommendation
Segment Health Assessments Linked to Segment Recommendations
Asset Health Assessments Linked to Asset Recommendations
Actual Segment Events Linked to Segment Recommendations
Actual Asset Events Linked to Asset Recommendations
Hypothetical Service Segment Events Linked to Segment Recommendations
Hypothetical Asset Events Linked to Asset Recommendations
Hypothetical Segment Events Linked to Segment Type Recommendations
Hypothetical Asset Events Linked to Asset Type Recommendations
Hypothetical Model Events Linked to Model Recommendations
Proposed Service Segment Events Linked to Segment Recommendations
Proposed Asset Events Linked to Asset Recommendations
Measurement Events Linked to Segment Recommendations
Measurement Events Linked to Asset Recommendations
Work Request
Work Request
Solution Package
Solution Package
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Associated Segment Recommendations for a Work Request
Associated Asset Recommendations for a Work Request
Associated Solution Packages For a Work Request
Work Request Numeric Data
Work Request Character Data
Work Request Audit
Work Order
Work Order
Work Order Child
Work Order Numeric Data
Work Order Character Data
Work Order Audit
Work Order Step
Work Order Step Numeric Data
Work Order Step Character Data
Work Order Step Audit
Work Order Step Segment Recommendation
Work Order Step Asset Recommendation
Work Order Step Solution Package
Work Order Step Work Request
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists

Notes:

 This table holds information about the machinery databases
 located at the site. It requires a unique db_id to exist
 for each database. This allows for databases to be merged.

 NOTE: The vendor of the database is stored as a foreign key
 in the mf_db_site, mf_db_id, mf_duns_code rows
 which relates to the MANUFACTURER table defined below.
 We cannot define it as a foreign key because the table
 is not yet created, though indeed it is.


Manufacturer Table

#16 - manufacturer

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
manuf_trade_name VARCHAR(254)  NOT NULL
company_name VARCHAR(254)  NOT NULL
phys_addr VARCHAR(254)  
phys_city_name VARCHAR(30)  
phys_state_abbr CHAR(2)  
phys_postal_code VARCHAR(10)  
phys_country_abbr CHAR(3)  
mail_addr VARCHAR(254)  
mail_city_name VARCHAR(60)  
mail_state_abbr CHAR(2)  
mail_postal_code VARCHAR(10)  
mail_country_abbr CHAR(3)  
us_ph_number CHAR(10)  
int_ph_country_no VARCHAR(3)  
int_ph_city_no VARCHAR(5)  
int_ph_local_no VARCHAR(10)  
us_fax_number CHAR(10)  
int_fax_country_no VARCHAR(3)  
int_fax_city_no VARCHAR(5)  
int_fax_local_no VARCHAR(10)  
business_desc VARCHAR(254)  
primary_sic VARCHAR(8)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [mf_db_site, mf_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Model/Part Number Table ( Model Asset )

Notes:

 NOTE: MIMOSA maintains tbe zero ( 0)  mf_db_site entries in this
 table. A database can add entries to this table, but must
 insert the database's primary key in mf_db_site and mf_db_id
 columns and then enter the Manfufacturer's corporate D-U-N-S
 number in the mf_duns_code column. If this is not known,
 negative numbers can be generated.

 NOTE: mf_duns_code is the D-U-N-S number of the corporate
 office of the manufacturer of the object

 NOTE: The optional field primary_sic relates to the primary Standard
 Industry Code ( SIC)  for the site. This code is linked in a SIC
 reference book to the type of industry the site is associated
 with.

 NOTE: On address lines, line breaks are denoted by a backslash "\"
 character.


Service Segment Type Table

#17 - segment_type

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
default_mnemonic CHAR(3)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sg_db_site, sg_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Type Child Table
Segment Type Child Table
Service Segment Table
Segment Type Binary Data Related To a Specific Database
Segment Type Function
Hypothetical Segment Type Event
Segment Type Recommendation

Notes:

 This table standardizes the names of service segments: production
 processes, their inputs and outputs, physical structures, systems,
 mechanical devices, and mechanical device areas. Many of these
 segments appear on the engineering blueprints of the site.
 These are referred to as "service segments" in this model. Service segment
 types can be thought of as the labels which are used in plant layout
 drawings showing the process flow, machine trains, and physical buildings
 in a plant.

 NOTE: MIMOSA Populates and maintains the sg_db_site Zero ( 0) 
 entries in this Table



Segment Type Child Table

#98 - segment_type_child

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
child_sg_db_site INTEGER  NOT NULL
child_sg_db_id INTEGER  NOT NULL
child_sg_type_code INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
segment_type (segment_type_child) [child_sg_db_site, child_sg_db_id, child_sg_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table shows the parent-child relationships structure of
 the logical taxonomy of segment types--from the general to more
 specific. This table will support various classification schemes
 as desired by different MIMOSA databases.


Service Segment Table

#18 - segment

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
segment_group_yn CHAR(1)  NOT NULL in ('Y', 'N')
user_tag_ident VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site () [segment_site] NOT NULL
segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Child Table
Segment Child Table
Segment Numeric Data Table
Segment Character Data Table
Segment Event Table
Asset Utilization on Segment History Table
Measurement Location Table
Measurement Event History Table
Segment Network Connect
Segment Network Connect
Segment Binary Data Related To a Specific Database
Segment Function
Hypothetical Segment Event
Proposed Segment Event
Segment Health Assessment History
Segment Remaining Life Assessment History
Segment Recommendation
Request for Work for Segment
Completed Work Tasks For Segments

Notes:

 This table stores all the service segments which have been designed
 to perform a function at a site. Service segments include production
 processes, their inputs and outputs, physical structures, systems,
 mechanical devices, and mechanical device areas. Many of these
 segments appear on the engineering blueprints of the site.
 These segments include components which perform a function
 ( Turbine-driven Pump 1A, Motor outboard bearing, etc.)  but do NOT
 describe the particular asset tracked by manufacturer,
 model number, & serial number in the database. This is done in the
 asset table. Some database track only data tied to service segments such
 as a machine train component, but do not tie the measurement data
 to the physical component assets installed at the time the data was
 taken. These databases cannot track, for example, a physical motor
 which is taken out of one machine train, cleaned, and then later
 used in another train. Other systems track physical assets and
 tie measurements to them. In order to provide maximum flexibility,
 this model allows both functional segment objects at a site and
 physical objects at a site to be placed in the database and data
 can be related to both as necessary. Table#44 ( ASSET_ON_SEGMENT) 
 stores the utilization of a particular asset on a given segment
 with the time it was installed and removed.

 The Segment_Child Table shows the parent-child relationships
 of segments to each other. For example, segment "Steam Turbine"
 at site "ABC" is the child of segment "Turbine Generator#1 "
 which is the child of segment "Power Generation Line#1 ".
 The model allows for more than one segment to be the child of
 more than one segment.

 The segment_group_yn field when set to "Y" means that this segment
 is really a segment composed of 2 or more segments of the same type.
 If a count of total segments is made from the database, these group
 segments should be ignored.

 NOTE: Segment_id is used like a barcode--to assign a unique,
 non-changeable identifier since a primary key cannot change
 and must uniquely define the entity. The user_tag_ident
 field is the identifier which is meaningful to the plant.

 Computer systems monitoring or recording information on the
 same segment should utilize the same segment_site, segment_id
 pair.

 User_tag_ident is the user identification tag which
 follows the nomenclature of the plant. This is normally
 an abbreviation or user-defined alpha-numeric code from which
 the plant derives meaning. This column is mandatory.

 The "name" column is an optional column which is a full
 description of the segment.


Segment Child Table

#19 - segment_child

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
child_sg_site INTEGER  NOT NULL
child_sg_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
segment (segment_child) [child_sg_site, child_sg_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 The Segment Child Table shows the parent-child relationships
 of segments to each other. For example, segment "Steam Turbine"
 at site "ABC" is the child of segment "Turbine Generator#1 "
 which is the child of segment "Power Generation Line#1 ".
 The model allows for more than one segment to be the child of
 more than one segment.

 The mandatory ordering sequence specifies the order in which child
 segment will appear when an application requests "all children" of
 a particular segment. The ordering sequence of machine segments,
 coupling segments, and bearing segments on a rotating machine train
 should conform to the MIMOSA guidelines as specified in
 Document MIM-VB-001.


Reference Unit Table

#22 - ref_unit_type

ru_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
physics_descr VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Engineering Unit Table
Segment Numeric Data Type Table
Segment Character Data Type Table
Asset Numeric Data Type Table
Asset Character Data Type Table

Notes:

 NOTE: MIMOSA populates and maintains this table.
 No user-defined entries are supported.


Engineering Unit Table

#23 - eng_unit_type

eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
mult_fact_to_ref DOUBLE  NOT NULL
refer_off_to_ref DOUBLE  NOT NULL
name VARCHAR(254)  NOT NULL
abbrev VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [eu_db_site, eu_db_id] NOT NULL
ref_unit_type () [ru_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Engineering Unit Enumerated List Table
Segment Numeric Data Table
Segment Character Data Table
Model Numeric Data Table
Model Character Data Table
Asset Numeric Data Table
Asset Character Data Table
Measurement Location Table
Measurement Location Table
Ordered List of Eng. Units at Measurement Locations Table
Transducer Asset Table ( Subset of Asset Table )
Transducer Asset Table ( Subset of Asset Table )
Measurement Event History Table
Measurement Event Numeric Data Table
Measurement Event Character Data Table
Num_Alarm_Reg
Signal-processed Amplitudes Alarm Regions
Signal Process Block Numeric Data Table
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample Numeric Data
Measurement Sample Character Data
Measurement Sample Test Numeric Results
Measurement Sample Test Character Results
Measurement Sample Test Histogram
Blob Grid Data
Segment Event Numeric Data
Asset Event Numeric Data
Segment Hypothetical Event Numeric Data
Asset Hypothetical Event Numeric Data
Segment Type Hypothetical Event Numeric Data
Asset Type Hypothetical Event Numeric Data
Model Hypothetical Event Numeric Data
Segment Proposed Event Numeric Data
Asset Proposed Event Numeric Data
Segment Remaining Life Assessment History
Segment Remaining Life Assessment History
Asset Remaining Life Assessment History
Asset Remaining Life Assessment History
Work Request
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Work Request Numeric Data
Work Request Character Data
Work Order
Work Order Numeric Data
Work Order Character Data
Work Order Step Numeric Data
Work Order Step Character Data

Notes:

 NOTE: MIMOSA Populates and maintains the eu_db_site Zero ( 0) 
 entries in this table. To convert between units,
 a multiplication factor from reference plus an offset
 scalar is provided in the columns mult_fact_to_ref and
 refer_off_to_ref, respectively.

 Y[eng units] = ( X[ref units]*  mult_fact_to_ref)  +
 refer_off_to_ref

 Y[ref units] = ( X[eng units] - refer_off_to_ref)  /
 mult_fact_to_ref


Engineering Unit Enumerated List Table

#24 - eng_unit_enum

eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
data_value INTEGER  NOT NULL
data_name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the alpha-numeric data names for engineering units
 which are of reference unit type "Enumerated List".


Segment Numeric Data Type Table

#25 - sg_num_dat_type

sn_db_site INTEGER  NOT NULL
sn_db_id INTEGER  NOT NULL
sn_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sn_db_site, sn_db_id] NOT NULL
ref_unit_type () [default_ru_type]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Numeric Data Table

Notes:

 This table will define all the numeric data related to a segment

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Segment Character Data Type Table

#26 - sg_chr_dat_type

sc_db_site INTEGER  NOT NULL
sc_db_id INTEGER  NOT NULL
sc_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sc_db_site, sc_db_id] NOT NULL
ref_unit_type () [default_ru_type]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Character Data Table

Notes:

 This table will define all the alpha-numeric character data related to
 a segment.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Segment Numeric Data Table

#27 - segment_num_data

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
sn_db_site INTEGER  NOT NULL
sn_db_id INTEGER  NOT NULL
sn_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
sg_num_dat_type () [sn_db_site, sn_db_id, sn_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the numeric nameplate and composition
 data related to a segment.




Segment Character Data Table

#28 - segment_chr_data

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
sc_db_site INTEGER  NOT NULL
sc_db_id INTEGER  NOT NULL
sc_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
sg_chr_dat_type () [sc_db_site, sc_db_id, sc_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the alpha-numeric data related to a segment.



Segment/Asset Event Type Table

#29 - sg_as_event_type

ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ev_db_site, ev_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Event Table
Asset Event Table
Event Type Child
Event Type Child
Hypothetical Segment Event
Hypothetical Asset Event
Hypothetical Segment Type Event
Hypothetical Asset Type Event
Hypothetical Model Event
Proposed Segment Event
Proposed Asset Event

Notes:

 This table holds the different types of possible events for segments and
 assets. These include operating events and failure events. An event
 is NOT work performed by an entity, but a log of the actual events which
 occurred at a service segment or asset over time.

 NOTE: MIMOSA Populates and maintains the ev_db_site Zero ( 0) 
 entries in this Table



Segment Event Table

#30 - segment_event

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
gmt_event_stop CHAR(29)  
ev_loc_hr_delta SMALLINT  
ev_loc_min_delta SMALLINT  
gmt_stored CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Events Linked to Functions Affected
Segment Event Numeric Data
Segment Events Associated With Measurement Event
Segment Event Link
Segment Event Link
Proposed Segment Events Linked to Actual Segment Event
Actual Segment Events Associated With Segment Health
Actual Segment Events Linked to Segment Recommendations

Notes:

 This table holds the different events which occurred on segments.
 These include operating events and failure events. An event
 is NOT work performed by an entity, but a log of the actual events which
 occurred at a service segment over time.

 NOTE: gmt_event_start, gmt_event_stop, and gmt_stored are Greenwich
 Mean Time

 NOTE: ev_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the event.

 NOTE: st_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the date the
 event row was stored in the database.

 NOTE: ev_loc_min_delta: If null, then assume local minute offset from GMT = 0

 NOTE: st_loc_min_delta: If null, then assume local minute offset from GMT = 0


Asset Type Table

#31 - asset_type

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
default_mnemonic CHAR(3)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [as_db_site, as_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Type Child Table
Asset Type Child Table
Model/Part Number Table ( Model Asset )
Asset Table
Transducer Type Table
Asset Type Binary Data
Asset Type Function
Hypothetical Asset Type Event
Asset Type Recommendation

Notes:

 NOTE: MIMOSA Populates and maintains the as_db_site Zero ( 0) 
 entries in this Table


Asset Type Child Table

#99 - asset_type_child

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
child_as_db_site INTEGER  NOT NULL
child_as_db_id INTEGER  NOT NULL
child_as_type_code INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
asset_type (asset_type_child) [child_as_db_site, child_as_db_id, child_as_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table shows the parent-child relationships structure of
 the logical taxonomy of asset types--from the general to more
 specific. This table will support various classification schemes
 as desired by different MIMOSA databases.


Model/Part Number Table ( Model Asset )

#32 - model

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

manufacturer () [mf_db_site, mf_db_id, mf_duns_code] NOT NULL
asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Model/Part Child Table
Model/Part Child Table
Model Numeric Data Table
Model Character Data Table
Asset Table
Model Binary Data Related to a Specific Database
Model Function
Hypothetical Model Event
Model Recommendation

Notes:

 This table will store the unique manufacturer and model/part number for
 a specific type of asset like a turbine, motor, bearing, etc.

 The revision number is part of the primary key and is used when
 a model of a piece of equipment is modified by the manufacturer
 and specifications will need to be tracked separately for each
 revision. If no revision information is known, then this field
 should contain a zero.

 NOTE: MIMOSA maintains tbe zero ( 0)  md_db_site entries in this table
 in order to provide standardized lists of known turbines,
 bearings, etc.



Model/Part Child Table

#97 - model_child

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
child_mf_db_site INTEGER  NOT NULL
child_mf_db_id INTEGER  NOT NULL
child_mf_duns_code INTEGER  NOT NULL
child_model_num VARCHAR(254)  NOT NULL
child_revision_num INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
model (model_child) [child_mf_db_site, child_mf_db_id, child_mf_duns_code, child_model_num, child_revision_num] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 The Model/Part Child Table shows the parent-child relationships
 of model parts to each other. This might be derived from the drawing
 schematic diagrams provided by an equipment manufacturer.

 The mandatory ordering sequence specifies the order in which child
 asset will appear when an application requests "all children" of
 a particular model.


Asset Numeric Data Type Table

#33 - as_num_dat_type

an_db_site INTEGER  NOT NULL
an_db_id INTEGER  NOT NULL
an_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [an_db_site, an_db_id] NOT NULL
ref_unit_type () [default_ru_type]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Model Numeric Data Table
Asset Numeric Data Table

Notes:

 This table will define all the numeric data related to a asset or a
 model of an asset.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Asset Character Data Type Table

#34 - as_chr_dat_type

ac_db_site INTEGER  NOT NULL
ac_db_id INTEGER  NOT NULL
ac_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ac_db_site, ac_db_id] NOT NULL
ref_unit_type () [default_ru_type]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Model Character Data Table
Asset Character Data Table

Notes:

 This table will define all the alpha-numeric character data related to
 an asset or a model of an asset.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Model Numeric Data Table

#35 - model_num_data

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
an_db_site INTEGER  NOT NULL
an_db_id INTEGER  NOT NULL
an_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
as_num_dat_type () [an_db_site, an_db_id, an_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the numeric nameplate and composition
 data related to a model.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.




Model Character Data Table

#36 - model_chr_data

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
ac_db_site INTEGER  NOT NULL
ac_db_id INTEGER  NOT NULL
ac_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
as_chr_dat_type () [ac_db_site, ac_db_id, ac_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the alpha-numeric nameplate and composition
 data related to a model.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Asset Readiness Type

#324 - as_readiness_type

asr_db_site INTEGER  NOT NULL
asr_db_id INTEGER  NOT NULL
asr_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
description VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [asr_db_site, asr_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Table
Asset Owner History Table

Notes:

 Asset Readiness Type


Asset Table

#37 - asset

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
user_tag_ident VARCHAR(254)  NOT NULL
name VARCHAR(254)  
serial_number VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site () [asset_org_site] NOT NULL
asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number]
as_readiness_type () [asr_db_site, asr_db_id, asr_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Child Table
Asset Child Table
Asset Numeric Data Table
Asset Character Data Table
Asset Event Table
Asset Utilization on Segment History Table
Asset Owner History Table
Measurement Location Table
Data Source Asset Table ( Subset of Asset Table )
Transducer Asset Table ( Subset of Asset Table )
Measurement Event History Table
Asset Network Connect
Asset Network Connect
Measurement Sample Test
Asset Binary Data
Asset Function
Hypothetical Asset Event
Proposed Asset Event
Asset Health Assessment History for past/present/future
Asset Remaining Life Assessment History
Asset Recommendation
Request for Work for Asset
Completed Work Tasks for Assets

Notes:

 This table stores any asset at any site. These
 might include actual motors, turbines, bearings, data collectors,
 transudcers, etc. Optionally, one can associate this physical asset
 with a service segment of the same type as the asset in a 1 to 1
 association. For example, asset "Induction Motor Model XYZ" with
 a specific manufacturer can currently be installed
 on segment "Induction Motor" at site#343434323 .

 The model allows for more than one asset to be the child of
 more than 1 parent asset through the Asset_Child table.

 NOTE: Asset_org_site is the ORIGINAL site the object was
 installed at and always remains part of the primary key.
 This asset may move to another site, but the asset_org_site
 and asset_id should remain the same. This relates to the
 Vehicle ID Number ( VIN)  on an automobile. The car may
 change owners by the VIN number does not change.

 Asset_id is used like a barcode--to assign a unique,
 non-changeable identifier since a primary key cannot change
 and must uniquely define the entity. The user_tag_ident
 field is the identifier which is meaningful to the plant.

 Computer systems monitoring or recording information on the
 same asset should utilize the same asset_org_site, asset_id
 pair.

 User_tag_ident is the user identification tag which
 follows the nomenclature of the plant. This is normally
 an abbreviation or user-defined alpha-numeric code from which
 the plant derives meaning. This column is mandatory.

 The "name" column is an optional column which is a full
 description of the asset.


Asset Child Table

#38 - asset_child

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
child_as_site INTEGER  NOT NULL
child_as_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
asset (asset_child) [child_as_site, child_as_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 The Asset Child Table shows the parent-child relationships
 of assets to each other. The model allows for more than one asset to
 be the child of more than one asset.

 The mandatory ordering sequence specifies the order in which child
 asset will appear when an application requests "all children" of
 a particular asset. The ordering sequence of machine assets,
 coupling assets, and bearing assets on a rotating machine train
 should conform to the MIMOSA guidelines as specified in
 Document MIM-VB-001.


Asset Numeric Data Table

#41 - asset_num_data

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
an_db_site INTEGER  NOT NULL
an_db_id INTEGER  NOT NULL
an_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
as_num_dat_type () [an_db_site, an_db_id, an_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the current numeric data related to an asset.



Asset Character Data Table

#42 - asset_chr_data

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ac_db_site INTEGER  NOT NULL
ac_db_id INTEGER  NOT NULL
ac_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
as_chr_dat_type () [ac_db_site, ac_db_id, ac_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will hold all the current alpha-numeric character data
 related to an asset.



Asset Event Table

#43 - asset_event

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
gmt_event_stop CHAR(29)  
ev_loc_hr_delta SMALLINT  
ev_loc_min_delta SMALLINT  
gmt_stored CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Events Linked to Functions Affected
Asset Event Numeric Data
Asset Events Associated With Measurement Event
Asset Event Link
Asset Event Link
Proposed Asset Events Linked to Actual Asset Event
Actual Asset Events Associated With Asset Health
Actual Asset Events Linked to Asset Recommendations

Notes:

 This table holds the different types of possible events for assets.
 These include operating events and failure events. An event
 is NOT work performed by an entity, but a log of the actual events which
 occurred at an asset over time.

 NOTE: gmt_event_start, gmt_event_stop, and gmt_stored are Greenwich
 Mean Time

 NOTE: ev_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the event.

 NOTE: st_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the date the
 event row was stored in the database.

 NOTE: ev_loc_min_delta If null, then assume local minute offset from GMT = 0

 NOTE: st_loc_min_delta If null, then assume local minute offset from GMT = 0


Asset Utilization on Segment History Table

#44 - asset_on_segment

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_installed CHAR(29)  NOT NULL
gmt_removed CHAR(29)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores when a particular asset was utilized on a given
 segment and uses the date installed as part of the primary key.
 If not known when installed, a date of "0000-00-00 00:00:00-000000000"
 should be used.


Purchase Condition Type

#323 - purchase_cond_type

pc_db_site INTEGER  NOT NULL
pc_db_id INTEGER  NOT NULL
pc_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [pc_db_site, pc_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Owner History Table

Notes:

 Purchase Condition Type


Asset Owner History Table

#45 - asset_owner

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_purchased CHAR(29)  NOT NULL
gmt_sold CHAR(29)  
gmt_discarded CHAR(29)  

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
site (site_purch) [purch_from_site]
site (site_sold) [sold_to_site] NOT NULL
purchase_cond_type () [pc_db_site, pc_db_id, pc_type_code]
as_readiness_type () [asr_db_site, asr_db_id, asr_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the owner of a particular asset over time and
 stores the date purchased as part of the primary key.
 If not known when purchased, a date of "0000-00-00 00:00:00-000000000"
 should be used. If these assets are not currently active in the
 asset_on_segment table, then they could be considered "spares".


Measurement Location Type Table

#55 - meas_loc_type

ml_db_site INTEGER  NOT NULL
ml_db_id INTEGER  NOT NULL
ml_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ml_db_site, ml_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Location Table
Measurement Event History Table

Notes:

 This table stores all the various types of measurement locations.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Data Source Type Table

#51 - data_source_type

ds_db_site INTEGER  NOT NULL
ds_db_id INTEGER  NOT NULL
ds_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ds_db_site, ds_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Location Table
Data Source Asset Table ( Subset of Asset Table )

Notes:

 This table stores all the various types of data sources.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Transducer Type Table

#53 - trans_type

tr_db_site INTEGER  NOT NULL
tr_db_id INTEGER  NOT NULL
tr_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
tr_type_abbrev CHAR(2)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_type () [tr_db_site, tr_db_id, tr_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Location Table
Transducer Asset Table ( Subset of Asset Table )

Notes:

 A subset of the asset type table which defines the types of assets
 which are valid types of transducers.

 The tr_type_abbrev is an optional 2-character abbrev for the tranducer
 type as defined for vibration in MIMOSA Document MIM-VB-001.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Transducer Sensitive Axis Direction Type Table

#46 - tr_axis_dir_type

ta_db_site INTEGER  NOT NULL
ta_db_id INTEGER  NOT NULL
ta_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ta_db_site, ta_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Location Table

Notes:

 This table stores types of sensitive axis directions which
 relate to tranducers placed at measurement locations on machinery.
 The axis direction to use for monitoring rotating machinery should
 conform to the MIMOSA guidelines as specified in Document MIM-VB-001.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Meas. Location Data Calculation Type

#325 - mloc_calc_type

mc_db_site INTEGER  NOT NULL
mc_db_id INTEGER  NOT NULL
mc_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
description VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [mc_db_site, mc_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Location Table
Measurement Event History Table

Notes:

 Meas. Location Data Calculation Type


Measurement Location Table

#47 - meas_location

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
segment_or_asset CHAR(1)  NOT NULL in ('S', 'A')
ta_orient_deg INTEGER  
mim_loc_seq INTEGER  
motion_direction CHAR(1)  in ('N', 'R')
mim_user_prefix CHAR(4)  
mc_calc_size INTEGER  
update_interval DOUBLE  
collect_duration INTEGER  
user_tag_ident VARCHAR(254)  NOT NULL
barcode VARCHAR(254)  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site () [meas_loc_site] NOT NULL
meas_loc_type () [ml_db_site, ml_db_id, ml_type_code] NOT NULL
segment () [segment_site, segment_id]
asset () [asset_org_site, asset_id]
data_source_type () [ds_db_site, ds_db_id, ds_type_code]
trans_type () [tr_db_site, tr_db_id, tr_type_code]
tr_axis_dir_type () [ta_db_site, ta_db_id, ta_type_code]
mloc_calc_type () [mc_db_site, mc_db_id, mc_type_code]
eng_unit_type (def_freq) [int_eu_db_site, int_eu_db_id, int_eu_type_code]
eng_unit_type (col_duration) [dur_eu_db_site, dur_eu_db_id, dur_eu_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Ordered List of Measurement Locations Table
Ordered List of Eng. Units at Measurement Locations Table
Measurement Event History Table
Num_Alarm_Reg
Signal-processed Amplitudes Alarm Regions
Alarm Regions for Measurement Location Sample Test Numeric Results

Notes:

 This table is used to identify the location where actual measurements
 will be taken, along with the type of measurement location, the source
 of the measurement data, the type of transducer which will be used
 ( if applicable) , the degree of the tranducer's angular orientation
 ( if applicable) , the corresponding transducer sensitive axis direction
 code ( if applicable) , and to which segment or asset the location is
 associated.

 The meas_loc_id should be assigned by a plant to be the same across
 all database systems. This allows data from one collection system
 to be merged with another collection system for the same location.

 Although this table does not physically restrict it, a measurement
 location must be assigned to either a segment or an asset in this
 table, as indicated by the segment_or_asset column, but not both.

 The degree of the tranducer's angular orientation ( column ta_orient_deg) 
 ( 0-360)  and the corresponding tranducer sensitive axis direction code,
 if applicable, is stored in this table.

 The specification of the MIMOSA Vibration Measurement Location Code,
 as specified in Document MIM-VB-001, is based on appending the following
 columns together to form a 14-character unique MIMOSA Location code.
 The following columns from this table are used directly or as foreign key
 references to create this code:

 Component Part => mim_user_prefix ( 4 characters of XXXX if null) 
 Bearing Housing Location on Machine System =>
 mim_loc_seq ( 3 digits with leading zeroes) 
 Transducer Type Code => TRANS_TYPE.tr_type_abbrev ( 2 characters
 referenced by tr_db_site, tr_db_id, tr_type_code or XX if null) 
 Angular Orientation => ta_oreint_deg ( 3 digits with leading zeroes
 or XXX if null) 
 Transducer Sensitive Axis Direction => 1st character from
 TR_AXIS_DIR_TYPE.name referenced by ta_db_site, ta_db_id,
 ta_type_code
 Direction of Motion => motion_direction ( 1 character of X if null) 

 NOTE: meas_loc_id is used like a barcode--to assign a unique,
 non-changeable identifier since a primary key key cannot change
 and must uniquely define the entity. The user_tag_ident field
 is the identifier which is meaningful to the plant.

 Computer systems monitoring or recording information on the
 same location should utilize the same meas_loc_site, meas_loc_id
 pair.

 User_tag_ident is the user identification tag which
 follows the nomenclature of the plant. This is normally
 an abbreviation or user-defined alpha-numeric code from which
 the plant derives meaning. This column is mandatory.

 NOTE: ml_db_site, ml_db_id, ml_type_code - Default location type which categorize
 the measurements which will be collected and stored. Each Measurement Event of a
 Measurement Location can also map to a location type for an "event-specific" category

 NOTE: mc_db_site, mc_db_id, mc_type_code - Default method that measurement is calculated from raw data

 NOTE: mc_calc_size - Parameter "x" used for the calculation

 NOTE: update_interval - Default frequency that measurements at this location will be updated

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time eng. units for default frequency

 NOTE: collect_duration - Default duration of collection for measurements at this location

 NOTE: dur_eu_db_site, dur_eu_db_id, dur_eu_type_code - Time eng. units for default collection duration


Ordered List Table

#48 - ordered_list

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
name VARCHAR(254)  
user_tag_ident VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ord_list_db_site, ord_list_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Ordered List of Measurement Locations Table
Ordered List of Eng. Units at Measurement Locations Table
Ordered List Binary Data
Ordered List Recommendation
Request for Work for Ordered List
Completed Work Tasks For Ordered Lists

Notes:

 This table is used to identify the name an ordered list for a database.

 NOTE: ord_list_id should be a non-changeable, unique
 identifier since a primary key cannot change and
 must uniquely define the entity. System-assigned
 "hidden" ord_list_id's are strongly recommended.


Ordered List of Measurement Locations Table

#49 - meas_loc_list

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table is used to store the measurement locations for a
 a given ordered list.



Ordered List of Eng. Units at Measurement Locations Table

#50 - mloc_unit_list

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
channel_number INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Collection Setup Parameters Needed to Collect Amplitude Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect FFT Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect Time Waveform Data in the Ordered List of Eng. Units at Measurement Locations Table
Collection Setup Parameters Needed to Collect CPB Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table

Notes:

 This table is used to store the measurement location with associated
 engineering units and channel number ( set to 1 if not a multi-channel
 input)  which has been requested for data collection / reporting at a
 certain place ( ordering_seq)  on an ordered list.



Data Source Asset Table ( Subset of Asset Table )

#52 - data_source

ds_asset_site INTEGER  NOT NULL
ds_asset_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [ds_asset_site, ds_asset_id] NOT NULL
data_source_type () [ds_db_site, ds_db_id, ds_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event History Table

Notes:

 This table is a subset of the asset table and catalogs all
 the data asset sources ( collectors, monitoring systems, etc.) 
 used to take measurements.

 Measurements can be stored in the measurement event table, however,
 without data source information, so entries in this
 table are not required.



Transducer Asset Table ( Subset of Asset Table )

#54 - transducer

tr_asset_site INTEGER  NOT NULL
tr_asset_id INTEGER  NOT NULL
out_amplitude DOUBLE  
gmt_last_calib CHAR(29)  
self_powered_yn CHAR(1)  in (NULL, 'Y', 'N')
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [tr_asset_site, tr_asset_id] NOT NULL
trans_type () [tr_db_site, tr_db_id, tr_type_code] NOT NULL
eng_unit_type (out_eng_unit) [out_eu_db_site, out_eu_db_id, out_eu_type_code]
eng_unit_type (per_eng_unit) [per_eu_db_site, per_eu_db_id, per_eu_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event History Table

Notes:

 This table is a subset of the asset table and catalogs all the
 transducers used to take measurements. The output amplitude and
 output amplitude units are the raw analog output signal which comes from
 the transducer ( i.e. 200 millivolts)  representing 1 resulting
 engineering unit ( the "per" engineering unit fields, i.e. MIL)  .

 Measurements can be stored in the measurement event table, however,
 without transducer information, so entries in this table are not
 required.


Data Quality Type Table

#88 - data_qual_type

dqual_type_code SMALLINT  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event History Table
Proposed Segment Event
Proposed Asset Event
Segment Health Assessment History
Asset Health Assessment History for past/present/future

Notes:

 The data quality type defines the various quality states which
 data in tables can be classified. These come from the ISO 9000-2
 status guidelines:

 1 = Not Inspected, Quality Unknown
 2 = Inspected and Accepted, Quality Good
 3 = Inspected and On Hold, Quality Under Review
 4 = Inspected and Rejected, Quality Bad

 NOTE: MIMOSA populates and maintains this table.
 No user-defined entries are supported.


Measurement Event History Table

#56 - meas_event

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ev_loc_hr_delta SMALLINT  
ev_loc_min_delta SMALLINT  
gmt_stored CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
mc_calc_size INTEGER  
collect_duration DOUBLE  
confid_percent SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_location () [meas_loc_site, meas_loc_id] NOT NULL
segment () [segment_site, segment_id]
asset () [asset_org_site, asset_id]
data_source () [ds_asset_site, ds_asset_id]
transducer () [tr_asset_site, tr_asset_id]
data_qual_type () [dqual_type_code] NOT NULL
meas_loc_type () [ml_db_site, ml_db_id, ml_type_code]
mloc_calc_type () [mc_db_site, mc_db_id, mc_type_code]
eng_unit_type () [dur_eu_db_site, dur_eu_db_id, dur_eu_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event Associations
Measurement Event Associations
Measurement Event Remarks Table
Measurement Event Numeric Data Table
Measurement Event Character Data Table
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Measurement Sample
Measurement Event Binary Data
Segment Events Associated With Measurement Event
Asset Events Associated With Measurement Event
Proposed Segment Events Associated With Measurement Event
Proposed Asset Events Associated With Measurement Event
Measurement Events Linked to Segment Recommendations
Measurement Events Linked to Asset Recommendations

Notes:

 This table is a history of data collection events occurring at
 measurement locations. This event could have recorded a single
 numeric value of a certain type, or a group of related signal
 processed measurements. Each measurement event relates back to one
 measurement location.

 Foreign keys are defined to the segment, asset,
 data collection source, and transducer tables in order for a system to
 track which segment and/or which asset and which data collection
 source and transducer the measurement is tied to at at this
 particular instance in time. This table does not contain the actual
 data, but the fact that on a given time, at a measurement location
 which was then associated with a physical object and/or a functional
 object, a measurement of a certain location type was taken.

 NOTE: The non-mandatory segment_site, segment_id columns are for
 measurement locations on assets where the actual segment
 where the asset is installed needs to be captured with
 the measurement event.

 NOTE: The non-mandatory asset_org_site, asset_id columns are for
 measurement locations on segments where the actual asset
 installed on the segment needs to be captured with
 the measurement event.

 NOTE: ev_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the event.

 NOTE: st_loc_hr_delta is the the number of hours +/- GMT
 to calculate the correct local time for the date the
 event row was stored in the database.

 NOTE: ev_loc_min_delta: If null, then assume local minute offset from GMT = 0

 NOTE: st_loc_min_delta: If null, then assume local minute offset from GMT = 0

 NOTE: confid_percent: Confidence in measurement accuracy ( 0=no confidence, 100=complete confidence) 

 NOTE: ml_db_site, ml_db_id, ml_type_code - Optional location type which specifically categorizes
 this measurement event.

 NOTE: mc_db_site, mc_db_id, mc_type_code - Actual method that measurement was calculated from raw data

 NOTE: mc_calc_size - Parameter "x" used for the calculation

 NOTE: collect_duration - Actual duration for this measurement event's data collection

 NOTE: dur_eu_db_site, dur_eu_db_id, dur_eu_type_code - Time eng. units for data collection duration


Measurement Event Associations

#100 - meas_event_assoc

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
related_mloc_site INTEGER  NOT NULL
related_mloc_id INTEGER  NOT NULL
related_gmt_event CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
meas_event (related_meas_event) [related_mloc_site, related_mloc_id, related_gmt_event] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table contains measurement events which are related to one
 another. This is used in vibration to associate a vibration
 measurement event to its corresponding tachometer signal measurement
 event and for multi-channel data which are related to each other.


Measurement Event Remarks Table

#57 - meas_event_rem

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table is where each measurement event textual remarks are
 recorded. This table is for an operator or analyst to put in
 free-form notes about why this measurement event was recorded, etc.

 This table should NOT store measurement event alpha-numeric
 character data like dates or user identifiers which should be tracked
 over time. These should be stored in the measurement event character
 value table#59 ( MEVENT_CHR_VALUE)  with a specific engineering unit
 associated with it.


Measurement Event Numeric Data Table

#58 - mevent_num_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event Numeric Data Alarm Table

Notes:

 This table is where all simple numeric data values which are related to
 to a measurement event for non-signal processed data is stored.

 This table could store simple pressures, temperatures, tachometer voltages,
 load readings, etc. which do not need additional information to interpret.

 Do NOT store frequency-related overall vibration amplitude data in this table,
 which should be stored in the signal-processed, single amplitude value/vector
 table ( SP_AMPL_DATA)  .

 Do NOT store fluid/gas test data nor electrical test data which require a
 "test type" in order to comprehend. Version 1.1 of CRIS will provide specific
 tables for this type of data.


Measurement Event Character Data Table

#59 - mevent_chr_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table is where all alpha-numeric data values which are related to
 to a measurement event for non-signal processed data is stored.

 This table stores measurement location data which needs to
 be tracked over time and contains an alpha-numeric code or date.


Alarm Severity Table

#60 - alarm_severity

al_severity_rank SMALLINT  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Alarm Type Table

Notes:

 This table stores the entries possible for alarm severity.

 NOTE: MIMOSA populates and maintains this table.
 No user-defined entries are supported.


Alarm Type Table

#61 - alarm_type

al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [al_db_site, al_db_id] NOT NULL
alarm_severity () [al_severity_rank] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Num_Alarm_Reg
Measurement Event Numeric Data Alarm Table
Signal-processed Amplitudes Alarm Regions
Signal-Processed Frequency/Order Single Amplitude Data Alarm Table
Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample Test Numeric Result Alarms
Measurement Sample Test BLOB Result Alarm
Measurement Event BLOB Data Alarm
Measurement Event BLOB Data Area in Alarm

Notes:

 This table stores the different types of alarms used by a database,
 along with its severity ranking and name.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Num_Alarm_Reg

#317 - num_alarm_reg

alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_alarm_start CHAR(29)  NOT NULL
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
min_amplitude DOUBLE  NOT NULL
max_amplitude DOUBLE  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Numeric Alarm Associated Regions in Alarm

Notes:

 Measurement Location Numeric Alarm Regions


agent_type

#109 - agent_type

agent_db_site INTEGER  NOT NULL
agent_db_id INTEGER  NOT NULL
agent_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [agent_db_site, agent_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

agent

Notes:




agent

#117 - agent

org_agent_site INTEGER  NOT NULL
agent_id INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site () [org_agent_site] NOT NULL
agent_type () [agent_db_site, agent_db_id, agent_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event Numeric Data Alarm Table
Signal-Processed Frequency/Order Single Amplitude Data Alarm Table
Agent Role
Agent Role With Associated Agent
Measurement Sample
Measurement Sample Test
Measurement Sample Test Numeric Result Alarms
Measurement Sample Test BLOB Result Alarm
Measurement Event BLOB Data Alarm
Measurement Event BLOB Data Area in Alarm
Segment Function
Asset Function
Segment Type Function
Asset Type Function
Model Function
Segment Events Linked to Functions Affected
Asset Events Linked to Functions Affected
Segment Events Associated With Measurement Event
Asset Events Associated With Measurement Event
Hypothetical Segment Event
Hypothetical Asset Event
Hypothetical Segment Type Event
Hypothetical Asset Type Event
Hypothetical Model Event
Segment Hypothetical Events Linked to Functions Affected
Asset Hypothetical Events Linked to Functions Affected
Segment Type Hypothetical Events Linked To Functions Affected
Asset Type Hypothetical Events Linked To Functions Affected
Model Hypothetical Events Linked to Functions Affected
Proposed Segment Event
Proposed Segment Event
Proposed Asset Event
Proposed Asset Event
Proposed Segment Events Linked to Functions Affected
Proposed Asset Events Linked to Functions Affected
Proposed Segment Events Linked to Hypothetical Segment Events
Proposed Asset Events Linked to Hypothetical Asset Events
Proposed Segment Events Linked to Actual Segment Event
Proposed Asset Events Linked to Actual Asset Event
Proposed Segment Events Associated With Measurement Event
Proposed Asset Events Associated With Measurement Event
Segment Health Assessment History
Segment Health Assessment History
Asset Health Assessment History for past/present/future
Asset Health Assessment History for past/present/future
Actual Segment Events Associated With Segment Health
Actual Asset Events Associated With Asset Health
Proposed Segment Events Associated With Segment Health
Proposed Asset Events Associated With Asset Health
Segment Remaining Life Assessment History
Asset Remaining Life Assessment History
Segment Recommendation
Asset Recommendation
Ordered List Recommendation
Segment Type Recommendation
Asset Type Recommendation
Model Recommendation
Work Request
Work Request
Work Request
Request for Work for Segment
Request for Work for Segment
Request for Work for Segment
Request for Work for Asset
Request for Work for Asset
Request for Work for Asset
Request for Work for Ordered List
Request for Work for Ordered List
Request for Work for Ordered List
Work Request Audit
Work Request Audit
Work Order
Work Order
Work Order
Work Order Audit
Work Order Audit
Work Order Step
Work Order Step
Work Order Step
Work Order Step Audit
Work Order Step Audit
Completed Work Tasks For Segments
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists
Completed Work Tasks For Ordered Lists

Notes:

 Organization, Group, Individual, Intelligent Agent, System

 NOTE: org_agent_site: Original agent site ( home site) 


Source Signal Detector Type Table

#73 - src_detect_type

src_dt_db_site INTEGER  NOT NULL
src_dt_db_id INTEGER  NOT NULL
src_dt_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [src_dt_db_site, src_dt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-processed Amplitudes Alarm Regions
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table

Notes:

 This table stores different source signal detector types.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Post-Processed Signal Processing Scaling Mode Table

#74 - post_scaling_type

pst_sc_db_site INTEGER  NOT NULL
pst_sc_db_id INTEGER  NOT NULL
pst_sc_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [pst_sc_db_site, pst_sc_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-processed Amplitudes Alarm Regions
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

Notes:

 This table stores different types of signal processing scaling methods.

 NOTE: MIMOSA maintains the zero ( 0)  site entries in this table.


Measurement Event Numeric Data Alarm Table

#63 - mevent_num_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
gmt_acknowledged CHAR(29)  
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mevent_num_data () [meas_loc_site, meas_loc_id, gmt_event, eu_db_site, eu_db_id, eu_type_code] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Numeric Alarm Associated Regions in Alarm

Notes:

 This table stores all the alarms triggered by the numeric value
 stored in the MEVENT_NUM_DATA table. If data is available in the
 Measurement Location Numeric Data Alarm Region Table, then the alarm
 data in this table can be derived and does not need to be stored here.
 However, some systems do not send all the alarm region data, and we
 need to store the fact that an alarm was triggered.

 org_agent_site, agent_id - Agent which acknowleged the alarm


Numeric Alarm Associated Regions in Alarm

#318 - num_al_assoc_reg

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
eu_db_site INTEGER  NOT NULL
eu_db_id INTEGER  NOT NULL
eu_type_code INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
al_meas_loc_site INTEGER  NOT NULL
al_meas_loc_id INTEGER  NOT NULL
al_ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mevent_num_alarm () [meas_loc_site, meas_loc_id, gmt_event, eu_db_site, eu_db_id, eu_type_code, al_db_site, al_db_id, al_type_code] NOT NULL
num_alarm_reg () [alarm_db_site, alarm_db_id, al_meas_loc_site, al_meas_loc_id, al_ordering_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Numeric Alarm Associated Regions in Alarm


Signal-processed Amplitudes Alarm Regions

#319 - spa_alarm_reg

alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
freq_or_order CHAR(1)  NOT NULL
min_in_hz_or_ord DOUBLE  NOT NULL
max_in_hz_or_ord DOUBLE  NOT NULL
gmt_alarm_start CHAR(29)  NOT NULL
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
min_amplitude DOUBLE  NOT NULL
max_amplitude DOUBLE  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
src_detect_type () [src_dt_db_site, src_dt_db_id, src_dt_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed Amplitude Associated Regions in Alarm

Notes:

 Signal-processed Amplitudes Alarm Regions


Signal Process Type Table

#64 - signal_proc_type

sp_db_site INTEGER  NOT NULL
sp_db_id INTEGER  NOT NULL
sp_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sp_db_site, sp_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal Process Block Table

Notes:

 This table stores all the various types of signal processing that
 could be defined.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.



Signal Process Block Table

#65 - signal_proc_blk

sp_blk_db_site INTEGER  NOT NULL
sp_blk_db_id INTEGER  NOT NULL
sp_block_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sp_blk_db_site, sp_blk_db_id] NOT NULL
signal_proc_type () [sp_db_site, sp_db_id, sp_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal Process Block Numeric Data Table
Signal Process Stream Blocks Table

Notes:

 This table will store all the signal process block entries specified
 in a given database, each of a specified signal processing type and
 assigns each a unique signal_proc_id to each entry in each database.


Signal Process Block Numeric Data Type Table

#66 - sp_num_dat_type

spn_db_site INTEGER  NOT NULL
spn_db_id INTEGER  NOT NULL
spn_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [spn_db_site, spn_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal Process Block Numeric Data Table

Notes:

 This table stores all the various types of numeric data associated
 with signal process blocks. Data associated with averaging,
 source detection, and windows can optionally be stored here, but should
 be specified when data is stored in the actual time waveform, FFT, CPB,
 or single amplitude value/vector data tables.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Signal Process Block Numeric Data Table

#67 - sp_blk_num_data

sp_blk_db_site INTEGER  NOT NULL
sp_blk_db_id INTEGER  NOT NULL
sp_block_id INTEGER  NOT NULL
spn_db_site INTEGER  NOT NULL
spn_db_id INTEGER  NOT NULL
spn_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

signal_proc_blk () [sp_blk_db_site, sp_blk_db_id, sp_block_id] NOT NULL
sp_num_dat_type () [spn_db_site, spn_db_id, spn_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will store the numeric data related to an entry in the
 the signal process block table.

 NOTE: Care must be taken not to change the numeric data of blocks used
 in a signal process stream if measurements have been stored
 for the stream.


Signal Process Stream Type

#261 - sp_stream_type

sps_type_db_site INTEGER  NOT NULL
sps_type_db_id INTEGER  NOT NULL
sps_type_code INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sps_type_db_site, sps_type_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal Process Stream Table

Notes:

 Signal Process Stream Type


Signal Process Stream Table

#68 - sp_stream

sp_str_db_site INTEGER  NOT NULL
sp_str_db_id INTEGER  NOT NULL
sp_stream_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sp_str_db_site, sp_str_db_id] NOT NULL
sp_stream_type () [sps_type_db_site, sps_type_db_id, sps_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal Process Stream Blocks Table
Signal-Processed Frequency/Order Single Amplitude/Vector Data Table
Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

Notes:

 This table will store the signal process streams for a given database.
 These streams will contain sequences of signal process blocks which
 define the processing sequence which data passed through.

 Actual single amplitude value/vector data, FFT data, time waveform data,
 and CPB data can optionally be associated with an entry in this table.


Signal Process Stream Blocks Table

#69 - sp_stream_block

sp_str_db_site INTEGER  NOT NULL
sp_str_db_id INTEGER  NOT NULL
sp_stream_id INTEGER  NOT NULL
sp_blk_db_site INTEGER  NOT NULL
sp_blk_db_id INTEGER  NOT NULL
sp_block_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id] NOT NULL
signal_proc_blk () [sp_blk_db_site, sp_blk_db_id, sp_block_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table details the sequence of signal process blocks for each
 signal process stream.

 NOTE: Care must be taken not to change the sequence of blocks in
 a stream if measurements have been stored for the stream.
 Normally, a new stream should be defined instead of
 updating the original stream.



Average Type Table

#70 - average_type

ave_db_site INTEGER  NOT NULL
ave_db_id INTEGER  NOT NULL
ave_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ave_db_site, ave_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

Notes:

 This table stores different types of signal processing averaging methods.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Average Weight Type Table

#71 - ave_weight_type

ave_wt_db_site INTEGER  NOT NULL
ave_wt_db_id INTEGER  NOT NULL
ave_wt_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ave_wt_db_site, ave_wt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

Notes:

 This table stores different types of signal processing average
 weighting methods.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Average Synchronization Type Table

#72 - ave_synch_type

ave_sy_db_site INTEGER  NOT NULL
ave_sy_db_id INTEGER  NOT NULL
ave_sy_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ave_sy_db_site, ave_sy_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Signal-Processed , Real Linear Constant Percentage Band Spectrum Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

Notes:

 This table stores different types of signal processing averaging
 synchronization methods.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Signal-Processed Frequency/Order Single Amplitude/Vector Data Table

#75 - sp_ampl_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
freq_or_order CHAR(1)  NOT NULL in ('F', 'O')
min_in_hz_or_ord DOUBLE  NOT NULL
max_in_hz_or_ord DOUBLE  NOT NULL
assoc_rpm_in_hz DOUBLE  
amplitude DOUBLE  NOT NULL
angle_in_degrees DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
src_detect_type () [src_dt_db_site, src_dt_db_id, src_dt_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed Frequency/Order Single Amplitude Data Alarm Table

Notes:

 This table will store 1 or more single amplitudes AND/OR single vectors
 which are related to frequency or order ranges which resulted as an
 output of a measurement event.

 A vector can be stored by placing the angle in degrees in the
 column angle_in_degrees.

 NOTE: If the source signal detector type is "FFT Power RMS", then the
 amplitude field is calculated from the spectra by taking the
 square root of the sum of all amplitude values squared which is
 then divided by the window factor.



Signal-Processed Frequency/Order Single Amplitude Data Alarm Table

#79 - sp_ampl_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
gmt_acknowledged CHAR(29)  
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sp_ampl_data () [meas_loc_site, meas_loc_id, gmt_event, ordering_seq] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed Amplitude Associated Regions in Alarm

Notes:

 This table stores all the alarms triggered by the signal-processed
 single amplitudes stored in the SP_AMPL_DATA table. If data is
 available in the Measurement Location Signal-processed Single
 Amplitude Alarm Region Table, then the alarm data in this table can
 be derived and does not need to be stored here.
 However, some systems do not send all the alarm region data, and we
 need to store the fact that an alarm was triggered.

 org_agent_site, agent_id - Agent which acknowleged the alarm


Signal-Processed Amplitude Associated Regions in Alarm

#320 - spa_al_assoc_reg

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
al_meas_loc_site INTEGER  NOT NULL
al_meas_loc_id INTEGER  NOT NULL
al_ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sp_ampl_alarm () [meas_loc_site, meas_loc_id, gmt_event, ordering_seq, al_db_site, al_db_id, al_type_code] NOT NULL
spa_alarm_reg () [alarm_db_site, alarm_db_id, al_meas_loc_site, al_meas_loc_id, al_ordering_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Signal-Processed Amplitude Associated Regions in Alarm


Window Type Table

#80 - window_type

win_db_site INTEGER  NOT NULL
win_db_id INTEGER  NOT NULL
win_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
pf_multiplier DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [win_db_site, win_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Signal-Processed , Real/Complex Linear Time Waveform Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table
Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table

Notes:

 This table stores different types of FFT and time waveform windows.
 The pf_multiplier column is the power factor multiplier for the
 window.

 NOTE: MIMOSA maintains tbe zero ( 0)  site entries in this table.


Signal-Processed , Real/Complex Linear Frequency/Order FFT Spectrum Data Table

#81 - sp_fft_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
freq_or_order CHAR(1)  NOT NULL in ('F', 'O')
min_in_hz_or_ord DOUBLE  NOT NULL
max_in_hz_or_ord DOUBLE  NOT NULL
resolution_lines INTEGER  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
assoc_rpm_in_hz DOUBLE  
name VARCHAR(254)  
dc_level DOUBLE  
complex_yn CHAR(1)  NOT NULL in ('Y', 'N')
spectrum_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
window_type () [win_db_site, win_db_id, win_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will store real-only or complex FFT data which
 is related to a frequency or order range which resulted as an output of
 a measurement event.

 NOTE: Spectrum_data is a variable-length binary field, first containing
 4-byte IEEE float real values for each line of resolution in the
 spectra. If the complex_yn field = 'Y', then the imaginary
 float values in 4-byte IEEE format follow the set of real
 values.

 The IEEE format is:

 --> Low-Order Byte First
 bits 0-22 --> Mantissa
 bits 23-30 --> Exponent
 bit 31 --> Sign

 NOTE: The bin width = ( max_in_hz_or_ord - min_in_hz_or_ord)  /
 resolution_lines

 NOTE: The frequency/order associated with the first line of the
 spectrum = min_in_hz_or_ord + bin_width

 NOTE: The ave_overlap_pct column is an percentage ranging from
 0 100 of the average overlap percentage used.


Signal-Processed , Real/Complex Linear Time Waveform Data Table

#83 - sp_time_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
secs_or_revs CHAR(1)  NOT NULL in ('S', 'R')
off_secs_or_revs DOUBLE  NOT NULL
max_secs_or_revs DOUBLE  NOT NULL
number_of_samples DOUBLE  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
assoc_rpm_in_hz DOUBLE  
name VARCHAR(254)  
complex_yn CHAR(1)  NOT NULL in ('Y', 'N')
waveform_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
window_type () [win_db_site, win_db_id, win_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will store real-only or complex time waveform data which
 resulted as an output of a measurement event. A complex time waveform
 is obtained when you have a decimated signal over a certain frequency range.

 NOTE: Waveform_data is a variable-length binary field, first containing
 4-byte IEEE float real values of length number_of_samples in
 length. If the complex_yn field = 'Y', then the imaginary
 float values in 4-byte IEEE format follow the real set of values.

 The IEEE format is:

 --> Low-Order Byte First
 bits 0-22 --> Mantissa
 bits 23-30 --> Exponent
 bit 31 --> Sign

 NOTE: The off_secs_or_revs column is the delta offset start time
 in seconds or offset number of revolutions from gmt_event
 time when the sample started.

 NOTE: The ave_overlap_pct column is an percentage ranging from
 0 100 of the average overlap percentage used.


Signal-Processed , Real Linear Constant Percentage Band Spectrum Table

#85 - sp_cpb_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
ordering_seq INTEGER  NOT NULL
number_of_bands INTEGER  NOT NULL
center_in_hz_1bd DOUBLE  NOT NULL
width_pct_or_oct CHAR(1)  NOT NULL in ('P', 'O')
band_width DOUBLE  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
assoc_rpm_in_hz DOUBLE  
name VARCHAR(254)  
spectrum_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table will store real CPB spectrum data which resulted as an
 output of a measurement event.

 NOTE: Spectrum_data is a variable-length binary field, containing
 4-byte IEEE float real values for each band in the
 spectra. The IEEE format is:

 --> Low-Order Byte First
 bits 0-22 --> Mantissa
 bits 23-30 --> Exponent
 bit 31 --> Sign

 The width_pct_or_oct column stores a "P" for percent band width ( 0-100) 
 or an "O" for octave width associated with the band_width column.

 The field center_in_hz_1bd is the first band's center frequency in
 hertz.


Collection Setup Parameters for Signal-processed Frequency/Order Single Amplitude/Vector Data Table

#89 - sp_ampl_setup

spa_setup_db_site INTEGER  NOT NULL
spa_setup_db_id INTEGER  NOT NULL
spa_setup_id INTEGER  NOT NULL
freq_or_order CHAR(1)  NOT NULL in ('F', 'O')
min_in_hz_or_ord DOUBLE  NOT NULL
max_in_hz_or_ord DOUBLE  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [spa_setup_db_site, spa_setup_db_id] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
src_detect_type () [src_dt_db_site, src_dt_db_id, src_dt_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Collection Setup Parameters Needed to Collect Amplitude Data in the Ordered List of Eng. Units at Measurement Locations Table

Notes:

 This table stores the setup parameters used to capture frequency/order
 single amplitudes ( or vectors)  for a given database. These setup id's
 can then be referenced in the MLOC_ULIST_SP_AMPL table to associate the
 ordered list's measurement location unit with the signal processing
 parameters needed to capture the unit in a specified manner.



Collection Setup Parameters for Signal-processed Real/Complex Linear Frequency/Order FFT Spectrum Data Table

#90 - sp_fft_setup

spf_setup_db_site INTEGER  NOT NULL
spf_setup_db_id INTEGER  NOT NULL
spf_setup_id INTEGER  NOT NULL
freq_or_order CHAR(1)  NOT NULL in ('F', 'O')
min_in_hz_or_ord DOUBLE  NOT NULL
max_in_hz_or_ord DOUBLE  NOT NULL
resolution_lines INTEGER  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
complex_yn CHAR(1)  NOT NULL in ('Y', 'N')
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [spf_setup_db_site, spf_setup_db_id] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
window_type () [win_db_site, win_db_id, win_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Collection Setup Parameters Needed to Collect FFT Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table

Notes:

 This table stores the setup parameters used to capture real/complex
 linear frequency/order FFT spectrum data for a given database. These
 setup id's can then be referenced in the MLOC_ULIST_SP_FFT table
 to associate the ordered list's measurement location unit with the
 signal processing parameters needed to capture the unit in a
 specified manner.



Collection Setup Parameters for Signal-processed Real/Complex Linear Time Waveform Data Table

#91 - sp_time_setup

spt_setup_db_site INTEGER  NOT NULL
spt_setup_db_id INTEGER  NOT NULL
spt_setup_id INTEGER  NOT NULL
secs_or_revs CHAR(1)  NOT NULL in ('S', 'R')
off_secs_or_revs DOUBLE  NOT NULL
max_secs_or_revs DOUBLE  NOT NULL
number_of_samples DOUBLE  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
complex_yn CHAR(1)  NOT NULL in ('Y', 'N')
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [spt_setup_db_site, spt_setup_db_id] NOT NULL
window_type () [win_db_site, win_db_id, win_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Collection Setup Parameters Needed to Collect Time Waveform Data in the Ordered List of Eng. Units at Measurement Locations Table

Notes:

 This table stores the setup parameters used to capture real/complex
 linear time waveform data for a given database. These
 setup id's can then be referenced in the MLOC_ULIST_SP_TIME table
 to associate the ordered list's measurement location unit with the
 signal processing parameters needed to capture the unit in a
 specified manner.



Collection Setup Parameters for Signal-processed Real Linear Constant Percentage Band Data Table

#92 - sp_cpb_setup

spc_setup_db_site INTEGER  NOT NULL
spc_setup_db_id INTEGER  NOT NULL
spc_setup_id INTEGER  NOT NULL
number_of_bands INTEGER  NOT NULL
center_in_hz_1bd DOUBLE  NOT NULL
width_pct_or_oct CHAR(1)  NOT NULL in ('P', 'O')
band_width DOUBLE  NOT NULL
ave_overlap_pct DOUBLE  
num_of_averages INTEGER  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [spc_setup_db_site, spc_setup_db_id] NOT NULL
post_scaling_type () [pst_sc_db_site, pst_sc_db_id, pst_sc_type_code] NOT NULL
average_type () [ave_db_site, ave_db_id, ave_type_code]
ave_weight_type () [ave_wt_db_site, ave_wt_db_id, ave_wt_type_code]
ave_synch_type () [ave_sy_db_site, ave_sy_db_id, ave_sy_type_code]
sp_stream () [sp_str_db_site, sp_str_db_id, sp_stream_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Collection Setup Parameters Needed to Collect CPB Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table

Notes:

 This table stores the setup parameters used to capture real CPB
 spectrum data for a given database. These setup id's can then be
 referenced in the MLOC_ULIST_SP_CPB table to associate the ordered
 list's measurement location unit with the signal processing
 parameters needed to capture the unit in a specified manner.



Collection Setup Parameters Needed to Collect Amplitude Data in the Ordered List of Eng. Units at Measurement Locations Table

#93 - mloc_ulist_sp_ampl

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
channel_number INTEGER  NOT NULL
spa_setup_db_site INTEGER  NOT NULL
spa_setup_db_id INTEGER  NOT NULL
spa_setup_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mloc_unit_list () [ord_list_db_site, ord_list_db_id, ord_list_id, ordering_seq, channel_number] NOT NULL
sp_ampl_setup () [spa_setup_db_site, spa_setup_db_id, spa_setup_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the associated collection setup parameter to be used
 to capture amplitude data for the engineering unit referenced in the
 ordered list measurement location unit table.



Collection Setup Parameters Needed to Collect FFT Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table

#94 - mloc_ulist_sp_fft

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
channel_number INTEGER  NOT NULL
spf_setup_db_site INTEGER  NOT NULL
spf_setup_db_id INTEGER  NOT NULL
spf_setup_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mloc_unit_list () [ord_list_db_site, ord_list_db_id, ord_list_id, ordering_seq, channel_number] NOT NULL
sp_fft_setup () [spf_setup_db_site, spf_setup_db_id, spf_setup_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the associated collection setup parameter to be used
 to capture FFT spectrum data for the engineering unit referenced in the
 ordered list measurement location unit table.



Collection Setup Parameters Needed to Collect Time Waveform Data in the Ordered List of Eng. Units at Measurement Locations Table

#95 - mloc_ulist_sp_time

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
channel_number INTEGER  NOT NULL
spt_setup_db_site INTEGER  NOT NULL
spt_setup_db_id INTEGER  NOT NULL
spt_setup_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mloc_unit_list () [ord_list_db_site, ord_list_db_id, ord_list_id, ordering_seq, channel_number] NOT NULL
sp_time_setup () [spt_setup_db_site, spt_setup_db_id, spt_setup_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the associated collection setup parameter to be used
 to capture time waveform data for the engineering unit referenced in the
 ordered list measurement location unit table.



Collection Setup Parameters Needed to Collect CPB Spectrum Data in the Ordered List of Eng. Units at Measurement Locations Table

#96 - mloc_ulist_sp_cpb

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
channel_number INTEGER  NOT NULL
spc_setup_db_site INTEGER  NOT NULL
spc_setup_db_id INTEGER  NOT NULL
spc_setup_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mloc_unit_list () [ord_list_db_site, ord_list_db_id, ord_list_id, ordering_seq, channel_number] NOT NULL
sp_cpb_setup () [spc_setup_db_site, spc_setup_db_id, spc_setup_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 This table stores the associated collection setup parameter to be used
 to capture CPB spectrum data for the engineering unit referenced in the
 ordered list measurement location unit table.



Types of MIMOSA Technology

#215 - mim_tech_type

tech_type_code INTEGER  NOT NULL
abbrev VARCHAR(40)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

MIMOSA Interface Type

Notes:

 Types of MIMOSA Technology


MIMOSA Support Levels

#216 - mim_support_type

supp_type_code INTEGER  NOT NULL
abbrev VARCHAR(40)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Support Levels


MIMOSA Data Categories

#217 - mim_data_cat_type

dcat_type_code INTEGER  NOT NULL
abbrev VARCHAR(10)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Data Categories


MIMOSA Functionality Type

#326 - mim_func_type

func_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Functionality Type


MIMOSA Interface Type

#327 - mim_interface_type

interf_type_code INTEGER  NOT NULL
version_supported SMALLINT  NOT NULL
subversion_supp SMALLINT  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mim_data_cat_type () [dcat_type_code] NOT NULL
mim_support_type () [supp_type_code] NOT NULL
mim_func_type () [func_type_code] NOT NULL
mim_tech_type () [tech_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

MIMOSA Interfaces Supported By A Database

Notes:

 MIMOSA Interface Type


MIMOSA Interfaces Supported By A Database

#328 - db_mim_interface

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
interf_type_code INTEGER  NOT NULL
gmt_last_refresh CHAR(29)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
mim_interface_type () [interf_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 MIMOSA Interfaces Supported By A Database

 NOTE: gmt_last_refresh - Timestamp of last refresh date, if applicable


Database Connection Information To Connect Two Databases

#219 - db_connection_info

from_db_site INTEGER  NOT NULL
from_db_id INTEGER  NOT NULL
to_db_site INTEGER  NOT NULL
to_db_id INTEGER  NOT NULL
to_odbc_conn_str VARCHAR(254)  
mim_table_owner VARCHAR(254)  
wr_posting_yn CHAR(1)  in ('Y', 'N')
wr_ack_yn CHAR(1)  in ('Y', 'N')
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [from_db_site, from_db_id] NOT NULL
site_database () [to_db_site, to_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Database Connection Information To Connect Two Databases

 NOTE: to_odbc_conn_str: ODBC DSN-less Connection String ( example:
 "ODBC; Server="My-Server"; ...) , See Microsoft's Jet Engine
 User's Guide For More Information

 NOTE: mim_table_owner: MIMOSA Table Owner ( Table Owner to use to
 prefix table names in queries) 

 NOTE: wr_posting_yn: Does "To" Database Post Work Requests
 In "From" DB? ( Y or N) 

 NOTE: wr_ack_yn: Does "To" Database Want Acknowledge of Work Posted ( Y or N) 


Network Type

#283 - network_type

nt_db_site INTEGER  NOT NULL
nt_db_id INTEGER  NOT NULL
nt_type_code INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [nt_db_site, nt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Network

Notes:

 Network Type


Event Type Child

#121 - event_type_child

ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
child_ev_db_site INTEGER  NOT NULL
child_ev_db_id INTEGER  NOT NULL
child_ev_type_code INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
sg_as_event_type () [child_ev_db_site, child_ev_db_id, child_ev_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment, Asset Logged Operating Events, Failure Modes, Failure Effects, Failure Mechanisms, Defect Events, Abnormal Situations, Alarm Events Parent, Child Types


Sample Test Type

#160 - sample_test_type

stt_db_site INTEGER  NOT NULL
stt_db_id INTEGER  NOT NULL
stt_code INTEGER  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [stt_db_site, stt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample Test

Notes:

 Types of Oil, Water, Fluid, Air, Gas, Solid Sample Tests


Sample Numeric Data Type

#212 - sample_ndata_type

snum_db_site INTEGER  NOT NULL
snum_db_id INTEGER  NOT NULL
snum_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [snum_db_site, snum_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Numeric Data

Notes:

 Sample Numeric Data Type


Sample Character Data Type

#290 - sample_cdata_type

schr_db_site INTEGER  NOT NULL
schr_db_id INTEGER  NOT NULL
schr_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [schr_db_site, schr_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Character Data

Notes:

 Sample Character Data Type


Test Results Numeric Data Type

#161 - test_result_ntype

strn_db_site INTEGER  NOT NULL
strn_db_id INTEGER  NOT NULL
str_num_type_code INTEGER  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [strn_db_site, strn_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Alarm Regions for Measurement Location Sample Test Numeric Results
Measurement Sample Test Numeric Results
Measurement Sample Test Histogram

Notes:

 Oil, Water, Fluid, Air, Gas, Solid, Electrical Test Results Numeric Data Type


Test Results Char Data Type

#286 - test_result_ctype

strc_db_site INTEGER  NOT NULL
strc_db_id INTEGER  NOT NULL
str_chr_type_code INTEGER  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [strc_db_site, strc_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test Character Results

Notes:

 Oil, Water, Fluid, Air, Gas, Solid, Electrical Test Results Char Data Type


Test Results Binary Large Object Data Type

#167 - test_result_btype

strb_db_site INTEGER  NOT NULL
strb_db_id INTEGER  NOT NULL
str_blob_type_code INTEGER  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [strb_db_site, strb_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test Binary Results

Notes:

 Oil, Water, Fluid, Air, Gas, Solid Test Results Binary Large Object Data Type


Binary Large Object Data Type

#162 - blob_data_type

bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [bd_db_site, bd_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test Binary Results
Segment Type Binary Data Related To a Specific Database
Segment Binary Data Related To a Specific Database
Model Binary Data Related to a Specific Database
Asset Type Binary Data
Asset Binary Data
Ordered List Binary Data
Measurement Event Binary Data
Binary Data Related to a Segment Recommendation
Binary Data Related to an Asset Recommendation
Binary Data Related to a Segment Type Recommendation
Binary Data Related to an Asset Type Recommendation
Binary Data Related to a Model Recommendation

Notes:

 Binary Large Object such as a Bitmapped Drawing or Image, Ferrographic Image, Thermographic Image, Digitized Video Clip, Document, etc.


Measurement Event Binary Large Object Type

#291 - mevent_blob_type

mebt_db_site INTEGER  NOT NULL
mebt_db_id INTEGER  NOT NULL
meb_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [mebt_db_site, mebt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event Binary Data

Notes:

 Measurement Event Binary Large Object Type


Highlight Area Type

#292 - highlight_type

high_db_site INTEGER  NOT NULL
high_db_id INTEGER  NOT NULL
high_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [high_db_site, high_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Event BLOB Data Area in Alarm

Notes:

 Highlight Area Type for Drawing Attention to Certain Locations, now used for BLOB Areas


Agent Role Type

#110 - agent_role_type

ag_role_db_site INTEGER  NOT NULL
ag_role_db_id INTEGER  NOT NULL
ag_role_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ag_role_db_site, ag_role_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Agent Role
Agent Role With Associated Agent

Notes:

 Manager, Owner, Employer, Buyer, Operator


Event Numeric Data Type

#107 - ev_num_data_type

en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [en_db_site, en_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Event Numeric Data
Asset Event Numeric Data
Segment Hypothetical Event Numeric Data
Asset Hypothetical Event Numeric Data
Segment Type Hypothetical Event Numeric Data
Asset Type Hypothetical Event Numeric Data
Model Hypothetical Event Numeric Data
Segment Proposed Event Numeric Data
Asset Proposed Event Numeric Data

Notes:

 Segment, Asset Event Numeric Data Type


Severity Type

#103 - severity_type

severity_rank INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Segment Event
Hypothetical Asset Event
Hypothetical Segment Type Event
Hypothetical Asset Type Event
Hypothetical Model Event
Proposed Segment Event
Proposed Asset Event

Notes:

 Severity Types


Health Grade Type

#104 - health_grade_type

hgrade_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Health Assessment History
Asset Health Assessment History for past/present/future

Notes:

 Health Grade Type


Priority Type

#106 - priority_type

priority_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Recommendation
Asset Recommendation
Ordered List Recommendation
Segment Type Recommendation
Asset Type Recommendation
Model Recommendation
Work Request
Solution Package
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Work Order
Work Order Step
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists

Notes:

 Levels of Priority for Recommendations, Work Requests


Work Management Type

#128 - work_manage_type

wm_type_db_site INTEGER  NOT NULL
wm_type_db_id INTEGER  NOT NULL
wm_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [wm_type_db_site, wm_type_db_id] NOT NULL
site_database (upd_site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Request
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Work Order

Notes:

 Types of Work Management Work Requests and Work Orders


Work Task Type

#108 - work_task_type

task_db_site INTEGER  NOT NULL
task_db_id INTEGER  NOT NULL
task_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [task_db_site, task_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Task Parent Child Taxonomy
Work Task Parent Child Taxonomy
Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists

Notes:

 Types of Work Tasks, Steps, Actions, Activities


Work Task Parent Child Taxonomy

#150 - wtask_type_child

task_db_site INTEGER  NOT NULL
task_db_id INTEGER  NOT NULL
task_type_code INTEGER  NOT NULL
child_tk_db_site INTEGER  NOT NULL
child_tk_db_id INTEGER  NOT NULL
child_tk_type_code INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
work_task_type () [child_tk_db_site, child_tk_db_id, child_tk_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Work Task Parent Child Taxonomy


Change Pattern Type

#151 - change_patt_type

ch_patt_db_site INTEGER  NOT NULL
ch_patt_db_id INTEGER  NOT NULL
ch_patt_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ch_patt_db_site, ch_patt_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Proposed Segment Event
Proposed Asset Event
Segment Health Assessment History
Asset Health Assessment History for past/present/future

Notes:

 Type of change pattern observed in problems


Work Audit Type

#119 - work_audit_type

waudit_db_site INTEGER  NOT NULL
waudit_db_id INTEGER  NOT NULL
waudit_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [waudit_db_site, waudit_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Request Audit
Work Order Audit
Work Order Step Audit

Notes:

 Work Request, Order, Order Steps Audit Types


Work Numeric Data Type

#170 - work_num_data_type

wn_db_site INTEGER  NOT NULL
wn_db_id INTEGER  NOT NULL
wn_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [wn_db_site, wn_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Request Numeric Data
Work Order Numeric Data
Work Order Step Numeric Data

Notes:

 Work Request, Work Order, Work Order Steps Numeric Data Type


Work Chr Data Type

#171 - work_chr_data_type

wc_db_site INTEGER  NOT NULL
wc_db_id INTEGER  NOT NULL
wc_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [wc_db_site, wc_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Request Character Data
Work Order Character Data
Work Order Step Character Data

Notes:

 Work Request, Work Order, Work Order Steps Char. Data Type


Solution Package Type

#182 - solution_pack_type

sol_db_site INTEGER  NOT NULL
sol_db_id INTEGER  NOT NULL
sol_type_code INTEGER  NOT NULL
name VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sol_db_site, sol_db_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Solution Package

Notes:

 Solution Package Type


Network

#284 - network

network_db_site INTEGER  NOT NULL
network_db_id INTEGER  NOT NULL
network_id INTEGER  NOT NULL
user_tag_ident INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [network_db_site, network_db_id] NOT NULL
network_type () [nt_db_site, nt_db_id, nt_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Network Connect
Asset Network Connect

Notes:




Segment Network Connect

#308 - sg_network_connect

network_db_site INTEGER  NOT NULL
network_db_id INTEGER  NOT NULL
network_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
output_sg_site INTEGER  NOT NULL
output_sg_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_stream_config CHAR(29)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

network () [network_db_site, network_db_id, network_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
segment () [output_sg_site, output_sg_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Asset Network Connect

#309 - as_network_connect

network_db_site INTEGER  NOT NULL
network_db_id INTEGER  NOT NULL
network_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
output_as_site INTEGER  NOT NULL
output_as_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_stream_config CHAR(29)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

network () [network_db_site, network_db_id, network_id] NOT NULL
asset () [asset_org_site, asset_id] NOT NULL
asset () [output_as_site, output_as_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Agent Role

#118 - agent_role

org_agent_site INTEGER  NOT NULL
agent_id INTEGER  NOT NULL
ag_role_db_site INTEGER  NOT NULL
ag_role_db_id INTEGER  NOT NULL
ag_role_type_code INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

agent () [org_agent_site, agent_id] NOT NULL
agent_role_type () [ag_role_db_site, ag_role_db_id, ag_role_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Agent Roles


Agent Role With Associated Agent

#223 - agent_role_with_agent

org_agent_site INTEGER  NOT NULL
agent_id INTEGER  NOT NULL
ag_role_db_site INTEGER  NOT NULL
ag_role_db_id INTEGER  NOT NULL
ag_role_type_code INTEGER  NOT NULL
other_org_agent_site INTEGER  NOT NULL
other_agent_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

agent_role_type () [ag_role_db_site, ag_role_db_id, ag_role_type_code] NOT NULL
agent () [other_org_agent_site, other_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Agent in Defined Role With Associated Agent

 NOTE: org_agent_site, agent_id, ag_role_db_site, ag_role_db_id, ag_role_db_id: Manager Of, Owner Of,
 Employer Of, Buyer From, etc.
 NOTE: other_org_agent_site, other_agent_id: Associated Agent


Alarm Regions for Measurement Location Sample Test Numeric Results

#310 - mloc_test_alrm_rg

alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
gmt_alarm_start CHAR(29)  NOT NULL
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
min_data_value DOUBLE  NOT NULL
max_data_value DOUBLE  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] NOT NULL
sample_test_type () [stt_db_site, stt_db_id, stt_code] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
test_result_ntype () [strn_db_site, strn_db_id, str_num_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Sample Test Alarm Associated Regions in Alarm

Notes:

 Alarm Regions for Measurement Location Sample Test Numeric Results


Measurement Sample

#166 - meas_sample

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
user_tag_ident VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
agent () [by_agent_site, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Master To Subsequent Child Sub-Samples
Measurement Sample Master To Subsequent Child Sub-Samples
Measurement Sample Numeric Data
Measurement Sample Character Data
Measurement Sample Remark
Measurement Sample Test

Notes:

 Measurement Sample

 NOTE: user_tag_ident - Alpha-numeric Sample Number


Measurement Sample Master To Subsequent Child Sub-Samples

#163 - meas_sample_child

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
child_mloc_site INTEGER  NOT NULL
child_mloc_id INTEGER  NOT NULL
child_gmt_event CHAR(29)  NOT NULL
child_sam_ord_seq INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq] NOT NULL
meas_sample () [child_mloc_site, child_mloc_id, child_gmt_event, child_sam_ord_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Master To Subsequent Child Sub-Samples


Measurement Sample Numeric Data

#213 - sample_num_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
snum_db_site INTEGER  NOT NULL
snum_db_id INTEGER  NOT NULL
snum_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq] NOT NULL
sample_ndata_type () [snum_db_site, snum_db_id, snum_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Numeric Data


Measurement Sample Character Data

#288 - sample_chr_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
schr_db_site INTEGER  NOT NULL
schr_db_id INTEGER  NOT NULL
schr_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq] NOT NULL
sample_cdata_type () [schr_db_site, schr_db_id, schr_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Character Data


Measurement Sample Remark

#289 - sample_remark

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Remark


Measurement Sample Test

#122 - meas_sample_test

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
user_tag_ident VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_started CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
gmt_ended CHAR(29)  
end_loc_hr_delta SMALLINT  
end_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq] NOT NULL
sample_test_type () [stt_db_site, stt_db_id, stt_code] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
asset () [test_asset_site, test_asset_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test Numeric Results
Measurement Sample Test Character Results
Measurement Sample Test Remark
Measurement Sample Test Histogram
Measurement Sample Test Binary Results

Notes:

 Measurement Sample Test


Measurement Sample Test Numeric Results

#164 - test_num_results

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
real_data_value DOUBLE  NOT NULL
imag_data_value DOUBLE  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample_test () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq] NOT NULL
test_result_ntype () [strn_db_site, strn_db_id, str_num_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test Numeric Result Alarms

Notes:

 Measurement Sample Test Numeric Results


Measurement Sample Test Character Results

#285 - test_chr_results

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample_test () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq] NOT NULL
test_result_ctype () [strc_db_site, strc_db_id, str_chr_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Test Character Results


Measurement Sample Test Remark

#287 - test_remark

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample_test () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Test Remark


Measurement Sample Test Histogram

#214 - test_histogram

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
min_screen_in_eu INTEGER  NOT NULL
max_screen_in_eu INTEGER  NOT NULL
resolution_lines INTEGER  NOT NULL
name VARCHAR(254)  
histogram_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample_test () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq] NOT NULL
test_result_ntype () [strn_db_site, strn_db_id, str_num_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 NOTE: The constant screen width = [max_screen_in_eu - min_screen_in_eu], resolution_lines. The screen size of the first histogram value in histogram_data = min_screen_in_eu + constant screen width. Histogram_data is a variable-length binary field, containing 4-byte IEEE float real values for each line of resolution in the histogram.

 NOTE: The constant screen width = ( max_screen_in_eu - min_screen_in_eu) 
 resolution_lines. The screen size of the first histogram value in
 histogram_data = min_screen_in_eu + constant screen width.
 Histogram_data is a variable-length binary field, containing 4-byte IEEE
 float real values for each line of resolution in the histogram.


Measurement Sample Test Numeric Result Alarms

#191 - test_nres_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
gmt_acknowledged CHAR(29)  
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

test_num_results () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq, ordering_seq] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Sample Test Alarm Associated Regions in Alarm

Notes:

 Measurement Sample Test Numeric Result Alarms

 org_agent_site, agent_id - Agent which acknowleged the alarm


Sample Test Alarm Associated Regions in Alarm

#321 - test_al_assoc_reg

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
alarm_db_site INTEGER  NOT NULL
alarm_db_id INTEGER  NOT NULL
al_meas_loc_site INTEGER  NOT NULL
al_meas_loc_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

test_nres_alarm () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq, ordering_seq, al_db_site, al_db_id, al_type_code] NOT NULL
mloc_test_alrm_rg () [alarm_db_site, alarm_db_id, al_meas_loc_site, al_meas_loc_id, al_ordering_seq] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Sample Test Alarm Associated Regions in Alarm


Measurement Sample Test Binary Results

#168 - test_blob_results

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_sample_test () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq] NOT NULL
test_result_btype () [strb_db_site, strb_db_id, str_blob_type_code] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Measurement Sample Test BLOB Result Alarm

Notes:

 Measurement Sample Test Binary Results For Ferrography, Etc.


Measurement Sample Test BLOB Result Alarm

#192 - test_bres_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
sample_order_seq INTEGER  NOT NULL
test_order_seq INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
assoc_file_name VARCHAR(254)  
gmt_acknowledged CHAR(29)  NOT NULL
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

test_blob_results () [meas_loc_site, meas_loc_id, gmt_event, sample_order_seq, test_order_seq, ordering_seq] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Sample Test BLOB Result Alarms

 org_agent_site, agent_id - Agent which acknowleged the alarm


Segment Type Binary Data Related To a Specific Database

#224 - sg_type_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Type Binary Data Related To a Specific Database


Segment Binary Data Related To a Specific Database

#188 - segment_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Binary Data Related To a Specific Database


Model Binary Data Related to a Specific Database

#220 - model_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Model Binary Data Related to a Specific Database


Asset Type Binary Data

#225 - as_type_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Type Binary Data Related to a Specific Database


Asset Binary Data

#189 - asset_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
asset () [asset_org_site, asset_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Binary Data Related To a Specific Database


Ordered List Binary Data

#190 - olist_blob_data

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Ordered List Binary Data Related to a Specific Database


Measurement Event Binary Data

#165 - mevent_blob_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
mebt_db_site INTEGER  NOT NULL
mebt_db_id INTEGER  NOT NULL
meb_type_code INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
mevent_blob_type () [mebt_db_site, mebt_db_id, meb_type_code] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Blob Grid Data
Measurement Event BLOB Data Alarm
Measurement Event BLOB Data Area in Alarm

Notes:

 Measurement Event Binary Data


Blob Grid Data

#221 - blob_grid_data

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
mebt_db_site INTEGER  NOT NULL
mebt_db_id INTEGER  NOT NULL
meb_type_code INTEGER  NOT NULL
grid_seq INTEGER  NOT NULL
x_resolution INTEGER  NOT NULL
y_resolution INTEGER  NOT NULL
data_origin_x INTEGER  NOT NULL
data_origin_y INTEGER  NOT NULL
data_end_x INTEGER  NOT NULL
data_end_y INTEGER  NOT NULL
name VARCHAR(254)  
float_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mevent_blob_data () [meas_loc_site, meas_loc_id, gmt_event, mebt_db_site, mebt_db_id, meb_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 A 2-D Linear Rectangular Grid of Numeric Data Associated With Measurement
 Event BLOB Data. - Used for Radiological Data in Thermography, Thickness
 Data in Ultrasonic Testing, etc.

 NOTE: x_resolution, y_resolution - Total dimensions of the rectangular
 grid related to the BLOB image ( grid resolution) 

 NOTE: data_origin_x, data_origin_y - X, Y coordinates of the origin of the
 0-based rectangular grid for the "data rectangle" ( top left-most
 corner) 

 NOTE: data_end_x, data_end_y - X, Y coordinates of the end of the 0-based
 rectangular grid for the "data rectangle" ( lower right-most corner) 

 NOTE: float_data - Stored as a stream of 4-byte IEEE float values
 ( low-order byte first) , starting with coordinates ( data_origin_x,
 data_origin_y)  and progressing vertically downward ( increment y) 
 until data_end_y is exceeded, whereupon y is then set to
 data_origin_y and x is incremented until ( data_end_x, data_end_y) 
 is reached.


Measurement Event BLOB Data Alarm

#120 - blob_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
mebt_db_site INTEGER  NOT NULL
mebt_db_id INTEGER  NOT NULL
meb_type_code INTEGER  NOT NULL
al_db_site INTEGER  NOT NULL
al_db_id INTEGER  NOT NULL
al_type_code INTEGER  NOT NULL
gmt_acknowledged CHAR(29)  NOT NULL
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mevent_blob_data () [meas_loc_site, meas_loc_id, gmt_event, mebt_db_site, mebt_db_id, meb_type_code] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Event BLOB Data Alarm

 org_agent_site, agent_id - Agent which acknowleged the alarm


Measurement Event BLOB Data Area in Alarm

#293 - blob_area_alarm

meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
mebt_db_site INTEGER  NOT NULL
mebt_db_id INTEGER  NOT NULL
meb_type_code INTEGER  NOT NULL
area_seq INTEGER  NOT NULL
x_resolution INTEGER  NOT NULL
y_resolution INTEGER  NOT NULL
data_origin_x INTEGER  NOT NULL
data_origin_y INTEGER  NOT NULL
data_end_x INTEGER  NOT NULL
data_end_y INTEGER  NOT NULL
gmt_acknowledged CHAR(29)  NOT NULL
ack_loc_hr_delta SMALLINT  
ack_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

mevent_blob_data () [meas_loc_site, meas_loc_id, gmt_event, mebt_db_site, mebt_db_id, meb_type_code] NOT NULL
highlight_type () [high_db_site, high_db_id, high_type_code] NOT NULL
alarm_type () [al_db_site, al_db_id, al_type_code] NOT NULL
agent () [org_agent_site, agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Event BLOB Data Area in Alarm

 org_agent_site, agent_id - Agent which acknowleged the alarm


Segment Function

#226 - segment_function

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
user_tag_id VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Events Linked to Functions Affected
Segment Hypothetical Events Linked to Functions Affected
Proposed Segment Events Linked to Functions Affected

Notes:

 Function Codes, Descriptions of a Service Segment


Asset Function

#227 - asset_function

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
user_tag_id VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
asset () [asset_org_site, asset_id] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Events Linked to Functions Affected
Asset Hypothetical Events Linked to Functions Affected
Proposed Asset Events Linked to Functions Affected

Notes:

 Function Codes, Descriptions of an Asset


Segment Type Function

#264 - sg_type_function

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
user_tag_id VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Type Hypothetical Events Linked To Functions Affected

Notes:

 Function Codes, Descriptions of a Service Segment Type


Asset Type Function

#265 - as_type_function

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
user_tag_id VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Type Hypothetical Events Linked To Functions Affected

Notes:

 Function Codes, Descriptions of a Asset Type


Model Function

#268 - model_function

db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
user_tag_id VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [db_site, db_id] NOT NULL
model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Model Hypothetical Events Linked to Functions Affected

Notes:

 Function Codes, Descriptions of a Model


Segment Events Linked to Functions Affected

#228 - sg_ev_sg_func_link

ev_segment_site INTEGER  NOT NULL
ev_segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
fn_db_site INTEGER  NOT NULL
fn_db_id INTEGER  NOT NULL
fn_segment_site INTEGER  NOT NULL
fn_segment_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_event () [ev_segment_site, ev_segment_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
segment_function () [fn_db_site, fn_db_id, fn_segment_site, fn_segment_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Events Linked to Functions Affected


Asset Events Linked to Functions Affected

#229 - as_ev_as_func_link

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
fc_as_org_site INTEGER  NOT NULL
fc_as_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_event () [asset_org_site, asset_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
asset_function () [db_site, db_id, fc_as_org_site, fc_as_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Events Linked to Functions Affected


Segment Event Numeric Data

#111 - sg_event_num_data

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_event () [segment_site, segment_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Event Numeric Data


Asset Event Numeric Data

#113 - as_event_num_data

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_event () [asset_org_site, asset_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Event Numeric Data


Segment Events Associated With Measurement Event

#294 - sg_ev_meas_event

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_event () [segment_site, segment_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Events Associated With Measurement Events Which Substantiate the Actual Event


Asset Events Associated With Measurement Event

#295 - as_ev_meas_event

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_event () [asset_org_site, asset_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Events Associated With Measurement Events Which Substantiate the Actual Event


Segment Event Link

#152 - segment_event_link

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
caused_sg_site INTEGER  NOT NULL
caused_sg_id INTEGER  NOT NULL
caused_ev_db_site INTEGER  NOT NULL
caused_ev_db_id INTEGER  NOT NULL
caused_ev_code INTEGER  NOT NULL
caused_gmt CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_event () [segment_site, segment_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
segment_event () [caused_sg_site, caused_sg_id, caused_ev_db_site, caused_ev_db_id, caused_ev_code, caused_gmt] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Event Cause, Effect Links in an Event Causal Network


Asset Event Link

#153 - asset_event_link

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
caused_as_site INTEGER  NOT NULL
caused_as_id INTEGER  NOT NULL
caused_ev_db_site INTEGER  NOT NULL
caused_ev_db_id INTEGER  NOT NULL
caused_ev_code INTEGER  NOT NULL
caused_gmt CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_event () [asset_org_site, asset_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
asset_event () [caused_as_site, caused_as_id, caused_ev_db_site, caused_ev_db_id, caused_ev_code, caused_gmt] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Event Cause, Effect Links in an Event Causal Network


Hypothetical Segment Event

#230 - sg_hyp_event

sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
associated_blob LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sg_hyp_db_site, sg_hyp_db_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Segment Event Link
Hypothetical Segment Event Link
Segment Hypothetical Event Numeric Data
Segment Hypothetical Events Linked to Functions Affected
Proposed Segment Events Linked to Hypothetical Segment Events
Hypothetical Service Segment Events Linked to Segment Recommendations
Hypothetical Segment Events Linked to Segment Type Recommendations

Notes:

 Hypothetical Segment Events, Possible Failure Modes, Possible Failure Mechanisms

 NOTE: associated_blob - Associated document, drawing, etc.


Hypothetical Asset Event

#231 - as_hyp_event

as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
associated_blob LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [as_hyp_db_site, as_hyp_db_id] NOT NULL
asset () [asset_org_site, asset_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Asset Event Link
Hypothetical Asset Event Link
Asset Hypothetical Event Numeric Data
Asset Hypothetical Events Linked to Functions Affected
Proposed Asset Events Linked to Hypothetical Asset Events
Hypothetical Asset Events Linked to Asset Recommendations
Hypothetical Asset Events Linked to Asset Type Recommendations

Notes:

 Hypothetical Asset Events, Possible Failure Modes, Possible Failure Mechanisms


 NOTE: associated_blob - Associated document, drawing, etc.


Hypothetical Segment Type Event

#240 - sg_typ_hyp_event

sgt_hyp_db_site INTEGER  NOT NULL
sgt_hyp_db_id INTEGER  NOT NULL
sgt_hyp_event_id INTEGER  NOT NULL
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
associated_blob LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sgt_hyp_db_site, sgt_hyp_db_id] NOT NULL
segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Segment Type Event Link
Hypothetical Segment Type Event Link
Segment Type Hypothetical Event Numeric Data
Segment Type Hypothetical Events Linked To Functions Affected

Notes:

 Hypothetical Segment Type Events, Possible Failure Modes, Possible Failure Mechanisms


 NOTE: associated_blob - Associated document, drawing, etc.


Hypothetical Asset Type Event

#241 - as_typ_hyp_event

ast_hyp_db_site INTEGER  NOT NULL
ast_hyp_db_id INTEGER  NOT NULL
ast_hyp_event_id INTEGER  NOT NULL
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
associated_blob LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [ast_hyp_db_site, ast_hyp_db_id] NOT NULL
asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Asset Type Event Link
Hypothetical Asset Type Event Link
Asset Type Hypothetical Event Numeric Data
Asset Type Hypothetical Events Linked To Functions Affected

Notes:

 Hypothetical Asset Type Events, Possible Failure Modes, Possible Failure Mechanisms


 NOTE: associated_blob - Associated document, drawing, etc.


Hypothetical Model Event

#246 - model_hyp_event

mod_hyp_db_site INTEGER  NOT NULL
mod_hyp_db_id INTEGER  NOT NULL
mod_hyp_event_id INTEGER  NOT NULL
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
associated_blob LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [mod_hyp_db_site, mod_hyp_db_id] NOT NULL
model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Hypothetical Model Event Link
Hypothetical Model Event Link
Model Hypothetical Event Numeric Data
Model Hypothetical Events Linked to Functions Affected
Hypothetical Model Events Linked to Model Recommendations

Notes:

 Hypothetical Model Events, Possible Failure Modes, Possible Failure Mechanisms


 NOTE: associated_blob - Associated document, drawing, etc.


Hypothetical Segment Event Link

#232 - sg_hyp_event_link

sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_hyp_event () [sg_hyp_db_site, sg_hyp_db_id, sg_hyp_event_id] NOT NULL
sg_hyp_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Segment Event Cause, Effect Links in an Event Causal Network

 likelihood_prob - Likelihood probability between 0 and 1


Hypothetical Asset Event Link

#233 - as_hyp_event_link

as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_hyp_event () [as_hyp_db_site, as_hyp_db_id, as_hyp_event_id] NOT NULL
as_hyp_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Asset Event Cause, Effect Links in an Event Causal Network


 likelihood_prob - Likelihood probability between 0 and 1


Hypothetical Segment Type Event Link

#242 - sg_typ_hyp_ev_link

sgt_hyp_db_site INTEGER  NOT NULL
sgt_hyp_db_id INTEGER  NOT NULL
sgt_hyp_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_typ_hyp_event () [sgt_hyp_db_site, sgt_hyp_db_id, sgt_hyp_event_id] NOT NULL
sg_typ_hyp_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Segment Type Event Cause, Effect Links in an Event Causal Network


 likelihood_prob - Likelihood probability between 0 and 1


Hypothetical Asset Type Event Link

#243 - as_typ_hyp_ev_link

ast_hyp_db_site INTEGER  NOT NULL
ast_hyp_db_id INTEGER  NOT NULL
ast_hyp_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_typ_hyp_event () [ast_hyp_db_site, ast_hyp_db_id, ast_hyp_event_id] NOT NULL
as_typ_hyp_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Asset Type Event Cause, Effect Links in an Event Causal Network


 likelihood_prob - Likelihood probability between 0 and 1


Hypothetical Model Event Link

#247 - model_hyp_ev_link

mod_hyp_db_site INTEGER  NOT NULL
mod_hyp_db_id INTEGER  NOT NULL
mod_hyp_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_hyp_event () [mod_hyp_db_site, mod_hyp_db_id, mod_hyp_event_id] NOT NULL
model_hyp_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Model Event Cause, Effect Links in an Event Causal Network


 likelihood_prob - Likelihood probability between 0 and 1


Segment Hypothetical Event Numeric Data

#234 - sg_hyp_ev_num_data

sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_hyp_event () [sg_hyp_db_site, sg_hyp_db_id, sg_hyp_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Hypothetical Event Numeric Data


Asset Hypothetical Event Numeric Data

#235 - as_hyp_ev_num_data

as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_hyp_event () [as_hyp_db_site, as_hyp_db_id, as_hyp_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Hypothetical Event Numeric Data


Segment Type Hypothetical Event Numeric Data

#244 - sg_typ_hyp_ev_num_data

sgt_hyp_db_site INTEGER  NOT NULL
sgt_hyp_db_id INTEGER  NOT NULL
sgt_hyp_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_typ_hyp_event () [sgt_hyp_db_site, sgt_hyp_db_id, sgt_hyp_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Type Hypothetical Event Numeric Data


Asset Type Hypothetical Event Numeric Data

#245 - as_typ_hyp_ev_num_data

ast_hyp_db_site INTEGER  NOT NULL
ast_hyp_db_id INTEGER  NOT NULL
ast_hyp_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_typ_hyp_event () [ast_hyp_db_site, ast_hyp_db_id, ast_hyp_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Type Hypothetical Event Numeric Data


Model Hypothetical Event Numeric Data

#248 - model_hyp_ev_num_data

mod_hyp_db_site INTEGER  NOT NULL
mod_hyp_db_id INTEGER  NOT NULL
mod_hyp_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_hyp_event () [mod_hyp_db_site, mod_hyp_db_id, mod_hyp_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Model Hypothetical Event Numeric Data


Segment Hypothetical Events Linked to Functions Affected

#236 - sg_hyp_ev_sg_func

sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_hyp_event () [sg_hyp_db_site, sg_hyp_db_id, sg_hyp_event_id] NOT NULL
segment_function () [db_site, db_id, segment_site, segment_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Hypothetical Events Linked to Functions Affected


Asset Hypothetical Events Linked to Functions Affected

#237 - as_hyp_ev_as_func

as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_hyp_event () [as_hyp_db_site, as_hyp_db_id, as_hyp_event_id] NOT NULL
asset_function () [db_site, db_id, asset_org_site, asset_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Hypothetical Events Linked to Functions Affected


Segment Type Hypothetical Events Linked To Functions Affected

#266 - sg_typ_hyp_ev_func

sgt_hyp_db_site INTEGER  NOT NULL
sgt_hyp_db_id INTEGER  NOT NULL
sgt_hyp_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_typ_hyp_event () [sgt_hyp_db_site, sgt_hyp_db_id, sgt_hyp_event_id] NOT NULL
sg_type_function () [db_site, db_id, sg_db_site, sg_db_id, sg_type_code, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Type Hypothetical Events Linked To Functions Affected


Asset Type Hypothetical Events Linked To Functions Affected

#267 - as_typ_hyp_ev_func

ast_hyp_db_site INTEGER  NOT NULL
ast_hyp_db_id INTEGER  NOT NULL
ast_hyp_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_typ_hyp_event () [ast_hyp_db_site, ast_hyp_db_id, ast_hyp_event_id] NOT NULL
as_type_function () [db_site, db_id, as_db_site, as_db_id, as_type_code, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Type Hypothetical Events Linked To Functions Affected


Model Hypothetical Events Linked to Functions Affected

#269 - model_hyp_ev_func

mod_hyp_db_site INTEGER  NOT NULL
mod_hyp_db_id INTEGER  NOT NULL
mod_hyp_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_hyp_event () [mod_hyp_db_site, mod_hyp_db_id, mod_hyp_event_id] NOT NULL
model_function () [db_site, db_id, mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Model Hypothetical Events Linked to Functions Affected


Proposed Segment Event

#250 - sg_proposed_event

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
gmt_proposed CHAR(29)  
pr_loc_hr_delta SMALLINT  
pr_loc_min_delta SMALLINT  
likelihood_prob DOUBLE  
est_gmt_start CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
est_gmt_occur_end CHAR(29)  
end_loc_hr_delta SMALLINT  
end_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_audited CHAR(29)  
aud_loc_hr_delta SMALLINT  
aud_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sg_prop_db_site, sg_prop_db_id] NOT NULL
segment () [segment_site, segment_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
change_patt_type () [ch_patt_db_site, ch_patt_db_id, ch_patt_type_code]
data_qual_type () [aud_quality_code]
agent () [aud_by_org_asite, aud_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Proposed Segment Event Link
Proposed Segment Event Link
Segment Proposed Event Numeric Data
Proposed Segment Events Linked to Functions Affected
Proposed Segment Events Linked to Hypothetical Segment Events
Proposed Segment Events Linked to Actual Segment Event
Proposed Segment Events Associated With Measurement Event
Proposed Segment Events Associated With Segment Health
Proposed Service Segment Events Linked to Segment Recommendations

Notes:

 Proposed Past/Present/Future Segment Events including Diagnostic, Prognostic Event Outputs

 NOTE: severity_rank - Severity level of proposed event

 NOTE: gmt_proposed - Timestamp when proposed as an event

 NOTE: pr_loc_hr_delta - Hours from GMT when proposed as an event

 NOTE: pr_loc_min_delta - Minutes from GMT when proposed as an event

 NOTE: by_org_asite, by_agent_id - Agent who proposed event

 NOTE: likelihood_prob - Likelihood probability between 0 and 1

 NOTE: est_gmt_start - Estimated GMT event started or will start

 NOTE: st_loc_hr_delta - Hours from GMT for local start time

 NOTE: st_loc_min_delta - Minutes from GMT for local start time

 NOTE: est_gmt_occur_end - Estimated GMT event ended or will end

 NOTE: end_loc_hr_delta - Hours from GMT for local end time

 NOTE: end_loc_min_delta - Minutes from GMT for local end time

 NOTE: ch_patt_db_site, ch_patt_db_id, ch_patt_type_code - Change Pattern Code

 NOTE: name - Description

 NOTE: gmt_audited - GMT proposed event audited

 NOTE: cf_loc_hr_delta - Hours from GMT for local audit time

 NOTE: cf_loc_min_delta - Minutes from GMT for local audit time

 NOTE: aud_quality_code - Audit Quality Code ( proposed event not inspected,
 good/confirmed, bad/incorrect, or under review

 NOTE: aud_by_org_asite, aud_by_agent_id - Audited by Agent


Proposed Asset Event

#251 - as_proposed_event

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
gmt_proposed CHAR(29)  
pr_loc_hr_delta SMALLINT  
pr_loc_min_delta SMALLINT  
likelihood_prob DOUBLE  
est_gmt_start CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
est_gmt_occur_end CHAR(29)  
end_loc_hr_delta SMALLINT  
end_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_audited CHAR(29)  
aud_loc_hr_delta SMALLINT  
aud_loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [as_prop_db_site, as_prop_db_id] NOT NULL
asset () [asset_org_site, asset_id] NOT NULL
sg_as_event_type () [ev_db_site, ev_db_id, event_type_code] NOT NULL
severity_type () [severity_rank]
agent () [by_org_asite, by_agent_id]
change_patt_type () [ch_patt_db_site, ch_patt_db_id, ch_patt_type_code]
data_qual_type () [aud_quality_code]
agent () [aud_by_org_asite, aud_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Proposed Asset Event Link
Proposed Asset Event Link
Asset Proposed Event Numeric Data
Proposed Asset Events Linked to Functions Affected
Proposed Asset Events Linked to Hypothetical Asset Events
Proposed Asset Events Linked to Actual Asset Event
Proposed Asset Events Associated With Measurement Event
Proposed Asset Events Associated With Asset Health
Proposed Asset Events Linked to Asset Recommendations

Notes:

 Proposed Asset Events including Diagnostic, Prognostic Event Outputs

 NOTE: severity_rank - Severity level of proposed event

 NOTE: gmt_proposed - Timestamp when proposed as an event

 NOTE: pr_loc_hr_delta - Hours from GMT when proposed as an event

 NOTE: pr_loc_min_delta - Minutes from GMT when proposed as an event

 NOTE: by_org_asite, by_agent_id - Agent who proposed event

 NOTE: likelihood_prob - Likelihood probability between 0 and 1

 NOTE: est_gmt_start - Estimated GMT event started or will start

 NOTE: st_loc_hr_delta - Hours from GMT for local start time

 NOTE: st_loc_min_delta - Minutes from GMT for local start time

 NOTE: est_gmt_occur_end - Estimated GMT event ended or will end

 NOTE: end_loc_hr_delta - Hours from GMT for local end time

 NOTE: end_loc_min_delta - Minutes from GMT for local end time

 NOTE: ch_patt_db_site, ch_patt_db_id, ch_patt_type_code - Change Pattern Code

 NOTE: name - Description

 NOTE: gmt_audited - GMT proposed event audited

 NOTE: cf_loc_hr_delta - Hours from GMT for local audit time

 NOTE: cf_loc_min_delta - Minutes from GMT for local audit time

 NOTE: aud_quality_code - Audit Quality Code ( proposed event not inspected,
 good/confirmed, bad/incorrect, or under review

 NOTE: aud_by_org_asite, aud_by_agent_id - Audited by Agent


Proposed Segment Event Link

#252 - sg_prop_ev_link

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
sg_proposed_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Event Cause, Effect Links in an Event Causal Network

 NOTE: likelihood_prob - Likelihood probability between 0 and 1


Proposed Asset Event Link

#253 - as_prop_ev_link

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
caused_db_site INTEGER  NOT NULL
caused_db_id INTEGER  NOT NULL
caused_event_id INTEGER  NOT NULL
likelihood_prob DOUBLE  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
as_proposed_event () [caused_db_site, caused_db_id, caused_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Event Cause, Effect Links in an Event Causal Network


 NOTE: likelihood_prob - Likelihood probability between 0 and 1


Segment Proposed Event Numeric Data

#254 - sg_prop_ev_ndat

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Proposed Event Numeric Data


Asset Proposed Event Numeric Data

#255 - as_prop_ev_ndat

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
en_db_site INTEGER  NOT NULL
en_db_id INTEGER  NOT NULL
en_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
ev_num_data_type () [en_db_site, en_db_id, en_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Proposed Event Numeric Data


Proposed Segment Events Linked to Functions Affected

#262 - sg_prop_ev_sg_func

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
segment_function () [db_site, db_id, segment_site, segment_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Events Linked to Functions Affected


Proposed Asset Events Linked to Functions Affected

#263 - as_prop_ev_as_func

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
db_site INTEGER  NOT NULL
db_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
asset_function () [db_site, db_id, asset_org_site, asset_id, ordering_seq] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Linked to Functions Affected


Proposed Segment Events Linked to Hypothetical Segment Events

#256 - sg_prop_ev_hyp_ev

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
sg_hypev_db_site INTEGER  NOT NULL
sg_hypev_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
sg_hyp_event () [sg_hypev_db_site, sg_hypev_db_id, sg_hyp_event_id] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Events Linked to Hypothetical Segment Events


Proposed Asset Events Linked to Hypothetical Asset Events

#257 - as_prop_ev_hyp_ev

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
as_hypev_db_site INTEGER  NOT NULL
as_hypev_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
as_hyp_event () [as_hypev_db_site, as_hypev_db_id, as_hyp_event_id] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Linked to Hypothetical Asset Events


Proposed Segment Events Linked to Actual Segment Event

#258 - sg_prop_ev_sg_ev

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
segment_event () [segment_site, segment_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Events Linked to Actual Segment Events - Event Evidence Link


Proposed Asset Events Linked to Actual Asset Event

#259 - as_prop_ev_as_ev

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
asset_event () [asset_org_site, asset_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Linked to Actual Asset Events - Event Evidence Link


Proposed Segment Events Associated With Measurement Event

#296 - sg_prop_ev_meas_ev

sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Events Associated With Measurement Events Which Substantiate the Proposed Event - Measurement Evidence Link


Proposed Asset Events Associated With Measurement Event

#297 - as_prop_ev_meas_ev

as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
agent () [by_org_asite, by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Associated With Measurement Events Which Substantiate the Proposed Event - Measurement Evidence Link


Segment Health Assessment History

#127 - segment_health

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
hgrade_float DOUBLE  
likelihood_prob DOUBLE  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_audited CHAR(29)  
aud_loc_hr_delta SMALLINT  
aud_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
health_grade_type () [hgrade_type_code] NOT NULL
change_patt_type () [ch_patt_db_site, ch_patt_db_id, ch_patt_type_code]
data_qual_type () [aud_quality_code]
agent () [aud_by_org_asite, aud_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Actual Segment Events Associated With Segment Health
Proposed Segment Events Associated With Segment Health
Segment Health Assessments Linked to Segment Recommendations

Notes:

 Segment Health Assessment for Past, Present, Future

 NOTE: gmt_assessment - Assessment applies to this instant in time related to this segment

 NOTE: by_agent_site, by_agent_id - Agent who made the assessment / Doctor

 NOTE: loc_hr_delta - Local hours from GMT for gmt_assessment

 NOTE: loc_min_delta - Local minutes from GMT for gmt_assessment

 NOTE: hgrade_type_code - Health Grade Code

 NOTE: hgrade_float - Optional precise health grade float value between 0 & 10 ( 10 = perfect health) 

 NOTE: likelihood_prob - Likelihood probability between 0 and 1 that health assessment is accurate

 NOTE: gmt_created - Health assessment created on timestamp

 NOTE: cr_loc_hr_delta - Hours from GMT for creation timestamp

 NOTE: cr_loc_min_delta - Minutes from GMT for creation timestamp

 NOTE: ch_patt_db_site, ch_patt_db_id, ch_patt_type_code - Change Pattern Code

 NOTE: gmt_audited - GMT proposed event audited

 NOTE: aud_loc_hr_delta - Hours from GMT for local audit time

 NOTE: aud_loc_min_delta - Minutes from GMT for local audit time

 NOTE: aud_quality_code - Audit Quality Code ( health assessment not inspected, good/confirmed, bad/incorrect, or under review) 

 NOTE: aud_by_org_asite, aud_by_agent_id - Audit Agent

Asset Health Assessment History for past/present/future

#129 - asset_health

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
hgrade_float DOUBLE  
likelihood_prob DOUBLE  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
gmt_audited CHAR(29)  
aud_loc_hr_delta SMALLINT  
aud_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
health_grade_type () [hgrade_type_code] NOT NULL
change_patt_type () [ch_patt_db_site, ch_patt_db_id, ch_patt_type_code]
data_qual_type () [aud_quality_code]
agent () [aud_by_org_asite, aud_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Actual Asset Events Associated With Asset Health
Proposed Asset Events Associated With Asset Health
Asset Health Assessments Linked to Asset Recommendations

Notes:

 Asset Health Assessment History

 NOTE: gmt_assessment - Assessment applies to this instant in time related to this segment

 NOTE: by_agent_site, by_agent_id - Agent who made the assessment / Doctor

 NOTE: loc_hr_delta - Local hours from GMT for gmt_assessment

 NOTE: loc_min_delta - Local minutes from GMT for gmt_assessment

 NOTE: hgrade_type_code - Health Grade Code

 NOTE: hgrade_float - Optional precise health grade float value between 0 & 10 ( 10 = perfect health) 

 NOTE: likelihood_prob - Likelihood probability between 0 and 1 that health assessment is accurate

 NOTE: gmt_created - Health assessment created on timestamp

 NOTE: cr_loc_hr_delta - Hours from GMT for creation timestamp

 NOTE: cr_loc_min_delta - Minutes from GMT for creation timestamp

 NOTE: ch_patt_db_site, ch_patt_db_id, ch_patt_type_code - Change Pattern Code

 NOTE: gmt_audited - GMT proposed event audited

 NOTE: aud_loc_hr_delta - Hours from GMT for local audit time

 NOTE: aud_loc_min_delta - Minutes from GMT for local audit time

 NOTE: aud_quality_code - Audit Quality Code ( health assessment not inspected, good/confirmed, bad/incorrect, or under review) 

 NOTE: aud_by_org_asite, aud_by_agent_id - Audit Agent


Actual Segment Events Associated With Segment Health

#298 - sg_health_sg_event

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ev_sg_site INTEGER  NOT NULL
ev_sg_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_health () [segment_site, segment_id, gmt_assessment, by_agent_site, by_agent_id] NOT NULL
segment_event () [ev_sg_site, ev_sg_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
agent () [assoc_by_org_asite, assoc_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Actual Segment Events Associated With Segment Health Which Substantiate the Health Assessment


Actual Asset Events Associated With Asset Health

#299 - as_health_as_event

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ev_as_org_site INTEGER  NOT NULL
ev_as_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_health () [asset_org_site, asset_id, gmt_assessment, by_agent_site, by_agent_id] NOT NULL
asset_event () [ev_as_org_site, ev_as_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
agent () [assoc_by_org_asite, assoc_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Actual Asset Events Associated With Asset Health Which Substantiate the Health Assessment


Proposed Segment Events Associated With Segment Health

#300 - sg_health_sg_prop_ev

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_health () [segment_site, segment_id, gmt_assessment, by_agent_site, by_agent_id] NOT NULL
sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
agent () [assoc_by_org_asite, assoc_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Segment Events Associated With Segment Health Which Substantiate the Health Assessment


Proposed Asset Events Associated With Asset Health

#301 - as_health_as_prop_ev

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_health () [asset_org_site, asset_id, gmt_assessment, by_agent_site, by_agent_id] NOT NULL
as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
agent () [assoc_by_org_asite, assoc_by_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Associated With Asset Health Which Substantiate the Health Assessment


Segment Remaining Life Assessment History

#146 - sg_remaining_life

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
est_remaining_life DOUBLE  
error_estimate DOUBLE  
likelihood_prob DOUBLE  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
eng_unit_type () [erl_eu_db_site, erl_eu_db_id, erl_eu_type_code]
eng_unit_type () [err_eu_db_site, err_eu_db_id, err_eu_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Remaining Life Assessment History Assessment For Past/Present/Future

 NOTE: gmt_assessment - Remaining life assessment baseline timestamp from which to add estimated remaining useful life

 NOTE: by_agent_site, by_agent_id - Agent who made the assessment / Doctor

 NOTE: loc_hr_delta - Local time, hour offset from GMT

 NOTE: loc_min_delta - Local time, minute offset from GMT

 NOTE: est_remaining_life - Estimated remaining life assuming no intervention

 NOTE: erl_eu_db_site, erl_eu_db_id, erl_eu_type_code - Time units for est. remaining life

 NOTE: error_estimate - Error estimate ( +/- X duration) 

 NOTE: err_eu_db_site, err_eu_db_id, err_eu_type_code - Time units for error estimate

 NOTE: likelihood_prob - Likelihood probability between 0 and 1 that assessment is accurate

 NOTE: gmt_created - Life assessment created on timestamp

 NOTE: cr_loc_hr_delta - Hours from GMT for creation timestamp

 NOTE: cr_loc_min_delta - Minutes from GMT for creation timestamp


Asset Remaining Life Assessment History

#147 - as_remaining_life

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_assessment CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
est_remaining_life DOUBLE  
error_estimate DOUBLE  
likelihood_prob DOUBLE  
gmt_created CHAR(29)  
cr_loc_hr_delta SMALLINT  
cr_loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
eng_unit_type () [erl_eu_db_site, erl_eu_db_id, erl_eu_type_code]
eng_unit_type () [err_eu_db_site, err_eu_db_id, err_eu_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Remaining Life Assessment History For Past/Present/Future

 NOTE: gmt_assessment - Remaining life assessment baseline timestamp from which to add estimated remaining useful life

 NOTE: by_agent_site, by_agent_id - Agent who made the assessment / Doctor

 NOTE: loc_hr_delta - Local time, hour offset from GMT

 NOTE: loc_min_delta - Local time, minute offset from GMT

 NOTE: est_remaining_life - Estimated remaining life assuming no intervention

 NOTE: erl_eu_db_site, erl_eu_db_id, erl_eu_type_code - Time units for est. remaining life

 NOTE: error_estimate - Error estimate ( +/- X duration) 

 NOTE: err_eu_db_site, err_eu_db_id, err_eu_type_code - Time units for error estimate

 NOTE: likelihood_prob - Likelihood probability between 0 and 1 that assessment is accurate

 NOTE: gmt_created - Life assessment created on timestamp

 NOTE: cr_loc_hr_delta - Hours from GMT for creation timestamp

 NOTE: cr_loc_min_delta - Minutes from GMT for creation timestamp


Segment Recommendation

#184 - sg_recommendation

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Recommendation Remarks
Binary Data Related to a Segment Recommendation
Segment Health Assessments Linked to Segment Recommendations
Actual Segment Events Linked to Segment Recommendations
Hypothetical Service Segment Events Linked to Segment Recommendations
Proposed Service Segment Events Linked to Segment Recommendations
Measurement Events Linked to Segment Recommendations
Request for Work for Segment
Associated Segment Recommendations for a Work Request
Work Order Step Segment Recommendation

Notes:

 Segment Recommendation

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: name - Recommendation ID / Other Info.


Asset Recommendation

#185 - as_recommendation

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Recommendation Remarks
Binary Data Related to an Asset Recommendation
Asset Health Assessments Linked to Asset Recommendations
Actual Asset Events Linked to Asset Recommendations
Hypothetical Asset Events Linked to Asset Recommendations
Proposed Asset Events Linked to Asset Recommendations
Measurement Events Linked to Asset Recommendations
Request for Work for Asset
Associated Asset Recommendations for a Work Request
Work Order Step Asset Recommendation

Notes:

 Asset Recommendation

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: name - Recommendation ID / Other Info.


Ordered List Recommendation

#316 - ol_recommendation

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Ordered List Recommendation Remarks
Request for Work for Ordered List

Notes:

 Ordered List Recommendation

 NOTE: by_agent_site - Originator

 NOTE: name - Recommendation ID / Other Info.

 NOTE: by_agent_site - Originator

 NOTE: name - Recommendation ID / Other Info.


Segment Type Recommendation

#274 - sg_type_recomm

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment_type () [sg_db_site, sg_db_id, sg_type_code] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Type Recommendation Remarks
Binary Data Related to a Segment Type Recommendation
Hypothetical Segment Events Linked to Segment Type Recommendations

Notes:

 Segment Type Recommendation - Purpose is To Be Associated With Hypothesized Events

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: name - Recommendation ID / Other Info.


Asset Type Recommendation

#275 - as_type_recomm

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset_type () [as_db_site, as_db_id, as_type_code] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Asset Type Recommendation Remarks
Binary Data Related to an Asset Type Recommendation
Hypothetical Asset Events Linked to Asset Type Recommendations

Notes:

 Asset Type Recommendation - Purpose is To Be Associated With Hypothesized Events

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: name - Recommendation ID / Other Info.


Model Recommendation

#276 - model_recomm

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number] NOT NULL
agent () [by_agent_site, by_agent_id] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Segment Type Recommendation Remarks
Binary Data Related to a Model Recommendation
Hypothetical Model Events Linked to Model Recommendations

Notes:

 Model Recommendation - Purpose is To Be Associated With Hypothesized Events

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: name - Recommendation ID / Other Info.


Segment Recommendation Remarks

#130 - sg_rec_remark

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Asset Recommendation Remarks

#131 - as_rec_remark

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Ordered List Recommendation Remarks

#322 - ol_rec_remark

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ol_recommendation () [ord_list_db_site, ord_list_db_id, ord_list_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Ordered List Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Segment Type Recommendation Remarks

#277 - sg_type_rec_remark

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_type_recomm () [sg_db_site, sg_db_id, sg_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Type Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Asset Type Recommendation Remarks

#278 - as_type_rec_remark

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_type_recomm () [as_db_site, as_db_id, as_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Type Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Segment Type Recommendation Remarks

#279 - model_rec_remark

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
remark_text VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_recomm () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Type Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator


Binary Data Related to a Segment Recommendation

#311 - sg_rec_blob

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Binary Data Related to a Segment Recommendation


Binary Data Related to an Asset Recommendation

#312 - as_rec_blob

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Binary Data Related to an Asset Recommendation


Binary Data Related to a Segment Type Recommendation

#313 - sg_type_rec_blob

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_type_recomm () [sg_db_site, sg_db_id, sg_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Binary Data Related to a Segment Type Recommendation


Binary Data Related to an Asset Type Recommendation

#314 - as_type_rec_blob

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_type_recomm () [as_db_site, as_db_id, as_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Binary Data Related to an Asset Type Recommendation


Binary Data Related to a Model Recommendation

#315 - model_rec_blob

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
bd_db_site INTEGER  NOT NULL
bd_db_id INTEGER  NOT NULL
bd_type_code INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
name VARCHAR(254)  
assoc_file_name VARCHAR(254)  
image_data LONG  BINARY
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_recomm () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Binary Data Related to a Model Recommendation


Segment Health Assessments Linked to Segment Recommendations

#302 - sg_rec_sg_health

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
hth_sg_site INTEGER  NOT NULL
hth_sg_id INTEGER  NOT NULL
hth_gmt_assess CHAR(29)  NOT NULL
hth_by_agent_site INTEGER  NOT NULL
hth_by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
segment_health () [hth_sg_site, hth_sg_id, hth_gmt_assess, hth_by_agent_site, hth_by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Segment Health Assessments Linked to Segment Recommendations


Asset Health Assessments Linked to Asset Recommendations

#303 - as_rec_as_health

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
hth_as_org_site INTEGER  NOT NULL
hth_asset_id INTEGER  NOT NULL
hth_gmt_assess CHAR(29)  NOT NULL
hth_by_agent_site INTEGER  NOT NULL
hth_by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
asset_health () [hth_as_org_site, hth_asset_id, hth_gmt_assess, hth_by_agent_site, hth_by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Asset Health Assessments Linked to Asset Recommendations


Actual Segment Events Linked to Segment Recommendations

#208 - sg_rec_sg_event

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ev_sg_site INTEGER  NOT NULL
ev_sg_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
segment_event () [ev_sg_site, ev_sg_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Actual Segment Events Linked to Segment Recommendations


Actual Asset Events Linked to Asset Recommendations

#209 - as_rec_as_event

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
ev_as_org_site INTEGER  NOT NULL
ev_as_id INTEGER  NOT NULL
ev_db_site INTEGER  NOT NULL
ev_db_id INTEGER  NOT NULL
event_type_code INTEGER  NOT NULL
gmt_event_start CHAR(29)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
asset_event () [ev_as_org_site, ev_as_id, ev_db_site, ev_db_id, event_type_code, gmt_event_start] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Actual Asset Events Linked to Asset Recommendations


Hypothetical Service Segment Events Linked to Segment Recommendations

#270 - sg_rec_sg_hyp_ev

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
sg_hyp_event () [sg_hyp_db_site, sg_hyp_db_id, sg_hyp_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Service Segment Events Linked to Segment Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Hypothetical Asset Events Linked to Asset Recommendations

#271 - as_rec_as_hyp_ev

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
as_hyp_event () [as_hyp_db_site, as_hyp_db_id, as_hyp_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Asset Events Linked to Asset Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Hypothetical Segment Events Linked to Segment Type Recommendations

#280 - sg_typ_rec_hyp_ev

sg_db_site INTEGER  NOT NULL
sg_db_id INTEGER  NOT NULL
sg_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
sg_hyp_db_site INTEGER  NOT NULL
sg_hyp_db_id INTEGER  NOT NULL
sg_hyp_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_type_recomm () [sg_db_site, sg_db_id, sg_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
sg_hyp_event () [sg_hyp_db_site, sg_hyp_db_id, sg_hyp_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Segment Events Linked to Segment Type Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Hypothetical Asset Events Linked to Asset Type Recommendations

#281 - as_typ_rec_hyp_ev

as_db_site INTEGER  NOT NULL
as_db_id INTEGER  NOT NULL
as_type_code INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
as_hyp_db_site INTEGER  NOT NULL
as_hyp_db_id INTEGER  NOT NULL
as_hyp_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_type_recomm () [as_db_site, as_db_id, as_type_code, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
as_hyp_event () [as_hyp_db_site, as_hyp_db_id, as_hyp_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Asset Events Linked to Asset Type Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Hypothetical Model Events Linked to Model Recommendations

#282 - model_rec_hyp_ev

mf_db_site INTEGER  NOT NULL
mf_db_id INTEGER  NOT NULL
mf_duns_code INTEGER  NOT NULL
model_number VARCHAR(254)  NOT NULL
revision_number INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
mod_hyp_db_site INTEGER  NOT NULL
mod_hyp_db_id INTEGER  NOT NULL
mod_hyp_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

model_recomm () [mf_db_site, mf_db_id, mf_duns_code, model_number, revision_number, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
model_hyp_event () [mod_hyp_db_site, mod_hyp_db_id, mod_hyp_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Hypothetical Model Events Linked to Model Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Proposed Service Segment Events Linked to Segment Recommendations

#272 - sg_rec_sg_prop_ev

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
sg_prop_db_site INTEGER  NOT NULL
sg_prop_db_id INTEGER  NOT NULL
sg_prop_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
sg_proposed_event () [sg_prop_db_site, sg_prop_db_id, sg_prop_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Service Segment Events Linked to Segment Recommendations


Proposed Asset Events Linked to Asset Recommendations

#273 - as_rec_as_prop_ev

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
as_prop_db_site INTEGER  NOT NULL
as_prop_db_id INTEGER  NOT NULL
as_prop_event_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
as_proposed_event () [as_prop_db_site, as_prop_db_id, as_prop_event_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Proposed Asset Events Linked to Asset Recommendations

 NOTE: by_agent_site, by_agent_id - Originator


Measurement Events Linked to Segment Recommendations

#304 - sg_rec_mevent

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Events Linked to Segment Recommendations


Measurement Events Linked to Asset Recommendations

#305 - as_rec_mevent

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
meas_loc_site INTEGER  NOT NULL
meas_loc_id INTEGER  NOT NULL
gmt_event CHAR(29)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
meas_event () [meas_loc_site, meas_loc_id, gmt_event] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Measurement Events Linked to Asset Recommendations


Work Request

#136 - work_request

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
gmt_created CHAR(29)  
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
repeat_interval INTEGER  
user_tag_ident VARCHAR(254)  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [work_req_db_site, work_req_db_id] NOT NULL
work_manage_type () [wm_type_db_site, wm_type_db_id, wm_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
eng_unit_type () [int_eu_db_site, int_eu_db_id, int_eu_type_code]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Associated Segment Recommendations for a Work Request
Associated Asset Recommendations for a Work Request
Associated Solution Packages For a Work Request
Work Request Numeric Data
Work Request Character Data
Work Request Audit
Work Order Step Work Request

Notes:

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: repeat_interval - Time interval to automatically have work
 re-submitted for time-based actions

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time interval
 eng unit reference ( hours, days, months, etc.) 

 NOTE: from_sy_agent_site, from_sy_agent_id - System the request
 generated from

 NOTE: user_tag_ident - Work Request or Work Requested Number

 NOTE: abbrev - User generated short description

 NOTE: name - User generated full description


Solution Package

#181 - solution_package

sol_pack_db_site INTEGER  NOT NULL
sol_pack_db_id INTEGER  NOT NULL
sol_pack_id INTEGER  NOT NULL
gmt_created CHAR(29)  
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
user_tag_ident VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [sol_pack_db_site, sol_pack_db_id] NOT NULL
solution_pack_type () [sol_db_site, sol_db_id, sol_type_code] NOT NULL
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Request for Work for Segment
Request for Work for Asset
Request for Work for Ordered List
Associated Solution Packages For a Work Request
Work Order Step Solution Package

Notes:

 Package of Pre-defined Work and Associated Information to Be Done Based On a Need

 NOTE: user_tag_ident - User alpha-numeric solution package number


Request for Work for Segment

#134 - sg_req_for_work

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_requested CHAR(29)  NOT NULL
req_by_agent_site INTEGER  NOT NULL
req_by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
req_loc_hr_delta SMALLINT  
req_loc_min_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
repeat_interval INTEGER  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
agent () [req_by_agent_site, req_by_agent_id] NOT NULL
work_manage_type () [wm_type_db_site, wm_type_db_id, wm_type_code] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
eng_unit_type () [int_eu_db_site, int_eu_db_id, int_eu_type_code]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_id]
sg_recommendation () [rec_segment_site, rec_segment_id, rec_gmt_recomm, rec_by_agent_site, rec_by_agent_id]
work_request () [work_req_db_site, work_req_db_id, work_req_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Request for Work for Segment

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: from_sy_agent_site - System the request generated from

 NOTE: repeat_interval - Time interval to automatically have work re-submitted for time-based actions

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time interval eng unit reference ( hours, days, months, etc.) 

 NOTE: to_agent_site, to_agent_id - Agent to recieve the request work

 NOTE: sol_pack_db_site, sol_pack_db_id, sol_pack_id - Associated solution package

 NOTE: rec_segment_site, rec_segment_id, rec_gmt_recomm, rec_by_agent_site, ec_by_agent_id - Associated segment recommendation

 NOTE: work_req_db_site, work_req_db_id, work_req_id - Associated Work Request in local or remote database

 NOTE: abbrev - User-generated short work description

 NOTE: name - User-generated full work description


Request for Work for Asset

#135 - as_req_for_work

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_requested CHAR(29)  NOT NULL
req_by_agent_site INTEGER  NOT NULL
req_by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
req_loc_hr_delta SMALLINT  
req_min_hr_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
repeat_interval INTEGER  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
agent () [req_by_agent_site, req_by_agent_id] NOT NULL
work_manage_type () [wm_type_db_site, wm_type_db_id, wm_type_code] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
eng_unit_type () [int_eu_db_site, int_eu_db_id, int_eu_type_code]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_id]
as_recommendation () [rec_asset_org_site, rec_asset_id, rec_gmt_recomm, rec_by_agent_site, rec_by_agent_id]
work_request () [work_req_db_site, work_req_db_id, work_req_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Request for Work for Asset

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: from_sy_agent_site - System the request generated from

 NOTE: repeat_interval - Time interval to automatically have work re-submitted for time-based actions

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time interval eng unit reference ( hours, days, months, etc.) 

 NOTE: to_agent_site, to_agent_id - Agent to recieve the request work

 NOTE: sol_pack_db_site, sol_pack_db_id, sol_pack_id - Associated solution package

 NOTE: rec_asset_org_site, rec_asset_id, rec_gmt_recomm, rec_by_agent_site, ec_by_agent_id - Associated asset recommendation

 NOTE: work_req_db_site, work_req_db_id, work_req_id - Associated Work Request in local or remote database

 NOTE: abbrev - User-generated short work description

 NOTE: name - User-generated full work description


Request for Work for Ordered List

#148 - ol_req_for_work

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
gmt_requested CHAR(29)  NOT NULL
req_by_agent_site INTEGER  NOT NULL
req_by_agent_id INTEGER  NOT NULL
ordering_seq INTEGER  NOT NULL
req_loc_hr_delta SMALLINT  
req_loc_min_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
repeat_interval INTEGER  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
agent () [req_by_agent_site, req_by_agent_id] NOT NULL
work_manage_type () [wm_type_db_site, wm_type_db_id, wm_type_code] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
eng_unit_type () [int_eu_db_site, int_eu_db_id, int_eu_type_code]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_id]
ol_recommendation () [rec_ord_db_site, rec_ord_db_id, rec_ord_list_id, rec_gmt_recomm, rec_by_agent_site, rec_by_agent_id]
work_request () [work_req_db_site, work_req_db_id, work_req_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Request for Work for Ordered List, Route

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: from_sy_agent_site - System the request generated from

 NOTE: repeat_interval - Time interval to automatically have work re-submitted for time-based actions

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time interval eng unit reference ( hours, days, months, etc.) 

 NOTE: to_agent_site, to_agent_id - Agent to recieve the request work

 NOTE: sol_pack_db_site, sol_pack_db_id, sol_pack_id - Associated solution package

 NOTE: rec_ord_db_site, rec_ord_db_id, rec_ord_list_id, rec_gmt_recomm, rec_by_agent_site, rec_by_agent_id - Associated asset recommendation ( ordered list recommendation) 

 NOTE: work_req_db_site, work_req_db_id, work_req_id - Associated Work Request in local or remote database

 NOTE: abbrev - User-generated short work description

 NOTE: name - User-generated full work description


Associated Segment Recommendations for a Work Request

#186 - work_req_sg_recomm

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Segment Recommendations for a Work Request


Associated Asset Recommendations for a Work Request

#197 - work_req_as_recomm

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Asset Recommendations for a Work Request


Associated Solution Packages For a Work Request

#183 - work_req_sol_pack

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
sol_pack_db_site INTEGER  NOT NULL
sol_pack_db_id INTEGER  NOT NULL
sol_pack_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Solution Packages For a Work Request


Work Request Numeric Data

#172 - work_request_num_data

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
wn_db_site INTEGER  NOT NULL
wn_db_id INTEGER  NOT NULL
wn_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
work_num_data_type () [wn_db_site, wn_db_id, wn_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Work Request Numeric Data


Work Request Character Data

#173 - work_request_chr_data

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
wc_db_site INTEGER  NOT NULL
wc_db_id INTEGER  NOT NULL
wc_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
work_chr_data_type () [wc_db_site, wc_db_id, wc_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Work Request Character Data


Work Request Audit

#174 - work_request_audit

work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
waudit_db_site INTEGER  NOT NULL
waudit_db_id INTEGER  NOT NULL
waudit_type_code INTEGER  NOT NULL
gmt_audit_posted CHAR(29)  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
work_audit_type () [waudit_db_site, waudit_db_id, waudit_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 NOTE: by_agent_site, by_agent_id - Agent who posted audit record

 NOTE: from_sy_agent_site, from_sy_agent_id - System audit record generated from


Work Order

#139 - work_order

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
gmt_created CHAR(29)  
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
repeat_interval INTEGER  
user_tag_ident VARCHAR(254)  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

site_database () [work_order_db_site, work_order_db_id] NOT NULL
work_manage_type () [wm_type_db_site, wm_type_db_id, wm_type_code]
agent () [by_agent_site, by_agent_id]
eng_unit_type () [int_eu_db_site, int_eu_db_id, int_eu_type_code]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Order Child
Work Order Child
Work Order Numeric Data
Work Order Character Data
Work Order Audit
Work Order Step

Notes:

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: repeat_interval - Time interval to automatically have
 work re-submitted for time-based actions

 NOTE: int_eu_db_site, int_eu_db_id, int_eu_type_code - Time interval
 eng unit reference ( hours, days, months, etc.) 

 NOTE: from_sy_agent_site, from_sy_agent_id - System generated from

 NOTE: user_tag_ident - User alpha-numeric work order number

 NOTE: abbrev - User generated short description

 NOTE: name - User generated full description


Work Order Child

#159 - work_order_child

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
child_wo_db_site INTEGER  NOT NULL
child_wo_db_id INTEGER  NOT NULL
child_wo_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
work_order () [child_wo_db_site, child_wo_db_id, child_wo_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Relationship of Master Parent Work Order to Follow-on Work Orders


Work Order Numeric Data

#175 - work_order_num_data

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
wn_db_site INTEGER  NOT NULL
wn_db_id INTEGER  NOT NULL
wn_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
work_num_data_type () [wn_db_site, wn_db_id, wn_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Work Order Character Data

#176 - work_order_chr_data

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
wc_db_site INTEGER  NOT NULL
wc_db_id INTEGER  NOT NULL
wc_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
work_chr_data_type () [wc_db_site, wc_db_id, wc_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Work Order Audit

#177 - work_order_audit

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
waudit_db_site INTEGER  NOT NULL
waudit_db_id INTEGER  NOT NULL
waudit_type_code INTEGER  NOT NULL
gmt_audit_posted CHAR(29)  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
work_audit_type () [waudit_db_site, waudit_db_id, waudit_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Work Order Step

#140 - work_order_step

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
gmt_created CHAR(29)  
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
start_before_gmt CHAR(29)  
end_before_gmt CHAR(29)  
start_after_gmt CHAR(29)  
end_after_gmt CHAR(29)  
user_tag_ident VARCHAR(254)  NOT NULL
abbrev VARCHAR(254)  
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Work Order Step Numeric Data
Work Order Step Character Data
Work Order Step Audit
Work Order Step Segment Recommendation
Work Order Step Asset Recommendation
Work Order Step Solution Package
Work Order Step Work Request
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists

Notes:

 NOTE: by_agent_site, by_agent_id - Originator

 NOTE: start_before_gmt - Request for action to begin before this time

 NOTE: end_before_gmt - Request for action to end before this time

 NOTE: start_after_gmt - Request for action to start after this time

 NOTE: end_after_gmt - Request for action to end after this time

 NOTE: from_sy_agent_site, from_sy_agent_id - System generated from

 NOTE: priority_type_code - 0 = lowest, 10 = highest

 NOTE: abbrev - User generated short description

 NOTE: name - User generated full description


Work Order Step Numeric Data

#178 - wo_step_num_data

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
wn_db_site INTEGER  NOT NULL
wn_db_id INTEGER  NOT NULL
wn_type_code INTEGER  NOT NULL
data_value DOUBLE  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
work_num_data_type () [wn_db_site, wn_db_id, wn_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:




Work Order Step Character Data

#179 - wo_step_chr_data

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
wc_db_site INTEGER  NOT NULL
wc_db_id INTEGER  NOT NULL
wc_type_code INTEGER  NOT NULL
data_value VARCHAR(254)  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
work_chr_data_type () [wc_db_site, wc_db_id, wc_type_code] NOT NULL
eng_unit_type () [eu_db_site, eu_db_id, eu_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 null


Work Order Step Audit

#180 - wo_step_audit

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
waudit_db_site INTEGER  NOT NULL
waudit_db_id INTEGER  NOT NULL
waudit_type_code INTEGER  NOT NULL
gmt_audit_posted CHAR(29)  NOT NULL
loc_hr_delta SMALLINT  
loc_min_delta SMALLINT  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
work_audit_type () [waudit_db_site, waudit_db_id, waudit_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 NOTE: by_agent_site, by_agent_id - Agent who posted audit record

 NOTE: from_sy_agent_site, from_sy_agent_id - System audit record
 generated from


Work Order Step Segment Recommendation

#201 - wo_step_sg_recomm

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
sg_recommendation () [segment_site, segment_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Segment Recommendations for a Work Order Step


Work Order Step Asset Recommendation

#202 - wo_step_as_recomm

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
gmt_recommendation CHAR(29)  NOT NULL
by_agent_site INTEGER  NOT NULL
by_agent_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
as_recommendation () [asset_org_site, asset_id, gmt_recommendation, by_agent_site, by_agent_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Asset Recommendations for a Work Order Step


Work Order Step Solution Package

#206 - wo_step_sol_pack

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
sol_pack_db_site INTEGER  NOT NULL
sol_pack_db_id INTEGER  NOT NULL
sol_pack_id INTEGER  NOT NULL
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Associated Solution Packages For a Work Order Step


Work Order Step Work Request

#141 - wo_step_work_req

work_order_db_site INTEGER  NOT NULL
work_order_db_id INTEGER  NOT NULL
work_order_id INTEGER  NOT NULL
work_ord_step_seq INTEGER  NOT NULL
work_req_db_site INTEGER  NOT NULL
work_req_db_id INTEGER  NOT NULL
work_req_id INTEGER  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq] NOT NULL
work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Work Requests Related to Work Order Steps


Completed Work Tasks For Segments

#144 - sg_completed_work

segment_site INTEGER  NOT NULL
segment_id INTEGER  NOT NULL
task_db_site INTEGER  NOT NULL
task_db_id INTEGER  NOT NULL
task_type_code INTEGER  NOT NULL
gmt_completed CHAR(29)  NOT NULL
cp_loc_hr_delta SMALLINT  
cp_loc_min_delta SMALLINT  
gmt_started CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

segment () [segment_site, segment_id] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
priority_type () [priority_type_code]
work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Completed Work Tasks For Segments

 NOTE: gmt_completed - Actual completion time

 NOTE: cp_loc_hr_delta - Local completion time hours from GMT

 NOTE: cp_loc_min_delta - Local completion time minutes from GMT

 NOTE: gmt_started - Actual start time

 NOTE: st_loc_hr_delta - Local start time hours from GMT

 NOTE: st_loc_min_delta - Local start time minutes from GMT

 NOTE: by_agent_site, by_agent_id - Agent accomplishing the work

 NOTE: from_sy_agent_site, from_sy_agent_id - System generated from

 NOTE: priority_type_code - 0 = lowest, 10 = highest

 NOTE: abbrev - User generated short work description

 NOTE: name - User generated full work description

 NOTE: work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq - Associated Work Order Step


Completed Work Tasks for Assets

#145 - as_completed_work

asset_org_site INTEGER  NOT NULL
asset_id INTEGER  NOT NULL
task_db_site INTEGER  NOT NULL
task_db_id INTEGER  NOT NULL
task_type_code INTEGER  NOT NULL
gmt_completed CHAR(29)  NOT NULL
cp_loc_hr_delta SMALLINT  
cp_loc_min_delta SMALLINT  
gmt_started CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

asset () [asset_org_site, asset_id] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
priority_type () [priority_type_code]
work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Completed Work Tasks for Assets

 NOTE: gmt_completed - Actual completion time

 NOTE: cp_loc_hr_delta - Local completion time hours from GMT

 NOTE: cp_loc_min_delta - Local completion time minutes from GMT

 NOTE: gmt_started - Actual start time

 NOTE: st_loc_hr_delta - Local start time hours from GMT

 NOTE: st_loc_min_delta - Local start time minutes from GMT

 NOTE: by_agent_site, by_agent_id - Agent accomplishing the work

 NOTE: from_sy_agent_site, from_sy_agent_id - System generated from

 NOTE: priority_type_code - 0 = lowest, 10 = highest

 NOTE: abbrev - User generated short work description

 NOTE: name - User generated full work description

 NOTE: work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq - Associated Work Order Step


Completed Work Tasks For Ordered Lists

#187 - ol_completed_work

ord_list_db_site INTEGER  NOT NULL
ord_list_db_id INTEGER  NOT NULL
ord_list_id INTEGER  NOT NULL
task_db_site INTEGER  NOT NULL
task_db_id INTEGER  NOT NULL
task_type_code INTEGER  NOT NULL
gmt_completed CHAR(29)  NOT NULL
cp_loc_hr_delta SMALLINT  
cp_loc_min_delta SMALLINT  
gmt_started CHAR(29)  
st_loc_hr_delta SMALLINT  
st_loc_min_delta SMALLINT  
abbrev VARCHAR(254)  NOT NULL
name VARCHAR(254)  
gmt_last_updated CHAR(29)  NOT NULL

Foreign keys:

ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_id] NOT NULL
work_task_type () [task_db_site, task_db_id, task_type_code] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
priority_type () [priority_type_code]
work_order_step () [work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq]
site_database (site_db) [last_upd_db_site, last_upd_db_id] NOT NULL
row_status_type () [rstat_type_code] NOT NULL

Used By:

Notes:

 Completed Work Tasks For Ordered Lists

 NOTE: gmt_completed - Actual completion time

 NOTE: cp_loc_hr_delta - Local completion time hours from GMT

 NOTE: cp_loc_min_delta - Local completion time minutes from GMT

 NOTE: gmt_started - Actual start time

 NOTE: st_loc_hr_delta - Local start time hours from GMT

 NOTE: st_loc_min_delta - Local start time minutes from GMT

 NOTE: by_agent_site, by_agent_id - Agent accomplishing the work

 NOTE: from_sy_agent_site, from_sy_agent_id - System generated from

 NOTE: priority_type_code - 0 = lowest, 10 = highest

 NOTE: abbrev - User generated short work description

 NOTE: name - User generated full work description

 NOTE: work_order_db_site, work_order_db_id, work_order_id, work_ord_step_seq - Associated Work Order Step


Petr Hejda, Ondra Cervinka