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
Meas. Location Type Parent-Child Relationships
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 Work Request
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists
Solution Packages Associated With an Asset
Solution Packages Associated With a Segment
Solution Packages Associated With an Ordered List
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
Meas. Location Type Parent-Child Relationships
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 Work Request
Completed Work Tasks For Segments
Completed Work Tasks for Assets
Completed Work Tasks For Ordered Lists
Solution Packages Associated With an Asset
Solution Packages Associated With a Segment
Solution Packages Associated With an Ordered List
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
Solution Packages Associated With a Segment
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
Solution Packages Associated With an Asset
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:
Meas. Location Type Parent-Child Relationships
Meas. Location Type Parent-Child Relationships
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.
Meas. Location Type Parent-Child Relationships
#329 - mloc_type_child
ml_db_site | INTEGER | NOT NULL
|
ml_db_id | INTEGER | NOT NULL
|
ml_type_code | INTEGER | NOT NULL
|
child_ml_db_site | INTEGER | NOT NULL
|
child_ml_db_id | INTEGER | NOT NULL
|
child_ml_type_code | INTEGER | NOT NULL
|
child_ml_type_id | INTEGER | NOT NULL
|
gmt_last_updated | CHAR(29) | NOT NULL
|
Foreign keys:
meas_loc_type () [child_ml_db_site, child_ml_db_id, child_ml_type_code] NOT NULL
meas_loc_type () [ml_db_site, ml_db_id, ml_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:
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
Solution Packages Associated With an Ordered List
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
|
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 Packages Associated With an Asset
Solution Packages Associated With a Segment
Solution Packages Associated With an Ordered List
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]
solution_package () [sol_pack_db_site, sol_pack_db_id, sol_pack_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 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 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
Solution Packages Associated With an Asset
#330 - as_sol_pack
asset_org_site | INTEGER | NOT NULL
|
asset_id | INTEGER | NOT NULL
|
sol_pack_db_site | INTEGER | NOT NULL
|
sol_pack_db_id | INTEGER | NOT NULL
|
sol_pack_id | INTEGER | NOT NULL
|
Foreign keys:
asset () [asset_org_site, asset_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:
Solution Packages Associated With a Segment
#331 - sg_sol_pack
segment_site | INTEGER | NOT NULL
|
segment_id | INTEGER | NOT NULL
|
sol_pack_db_site | INTEGER | NOT NULL
|
sol_pack_db_id | INTEGER | NOT NULL
|
sol_pack_id | INTEGER | NOT NULL
|
Foreign keys:
segment () [segment_site, segment_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:
Solution Packages Associated With an Ordered List
#332 - ol_sol_pack
ord_list_db_site | INTEGER | NOT NULL
|
ord_list_db_id | INTEGER | NOT NULL
|
ord_list_id | INTEGER | NOT NULL
|
sol_pack_db_site | INTEGER | NOT NULL
|
sol_pack_db_id | INTEGER | NOT NULL
|
sol_pack_id | INTEGER | NOT NULL
|
Foreign keys:
ordered_list () [ord_list_db_site, ord_list_db_id, ord_list_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:
Petr Hejda, Ondra Cervinka