MIMOSA CRIS V2.2

Row Status Type Code

#12 - row_status_type

rstat_type_cod	SHORT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)
last_upd_db_site	INT
last_upd_db_id	INT
rstat_type_code	SHORT

Foreign keys:

Used By:

Work Request Binary 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
Measurement Location Type Child Table
Asset Solution Packages
Segment Solution Packages
Ordered List Solution Packages
BLOB Content Type
Measurement Location Association

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.

Date/time in the following ISO 8601 variable length character form:

YYYY-MM-DDThh:mm:ss.fffffffff where:

YYYY    = four-digit year

MM      = two-digit month (01=January, etc.)

DD             = two-digit day of month (01 through 31)

hh             = two digits of hour (00 through 23) (am/pm NOT allowed)

T              = literal "T" character

mm             = two digits of minute (00 through 59)

ss             = two digits of second (00 through 59)

fffffffff      = represents a decimal fraction of a second to the billionth of a

second.  Year, month, and day must be specified.  Additional timestamp content

should be provided, if known.  Zeros will be assumed for the omitted values.

Negative DATETIME is not supported. All suffixes after the 29th character provided

in the ISO 8601 specification, such as "Z" (representing Coordinated Universal Time (UTC)

are not necessary since the CRIS specification explicitly manages local offset hours

and minutes as distinct columns associated with the UTC (referred to in the CRIS specification

prefixed with "GMT") column.Note that the actual difference between the new DATETIME(10:29)

data type and the CRIS V2.1 fixed-length STRING(29) form is the separator between date and

time information is now a literal "T" instead of a blank space, the separator for the

billionths of seconds is now a dot (".") instead of a dash ("-"), and trailing items after

the year-month-day fields may be omitted.

Site Table

#13 - site

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

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 business location in the world

where assets or agents reside, and 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 throughout 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 determine your location's D-U-N-S number, please call Dunn & 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 preseve the

leading zeros in the D-U-N-S number.  To display the number to a user, left pad the

number with zeros 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 the MIMOSA Technical

 Director info@mimosa.org with the name of your organization, the number of locations

 in your organization , your name, title, and phone number.  You will be sent a range

 of MIMOSA numbers (all over 999,999,999) which you can then assign to each of your

 organizations.

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 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	INT	NOT NULL
db_id	INT	NOT NULL
name	STRING(0:254)	NOT NULL
mf_db_site	INT
mf_db_id	INT
mf_duns_code	INT
gmt_last_updated	DATETIME(10:29)
last_upd_db_site	INT
last_upd_db_id	INT

Foreign keys:

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

Used By:

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
manuf_trade_name	STRING(0:254)	NOT NULL
company_name	STRING(0:254)	NOT NULL
phys_addr	STRING(0:254)
phys_city_name	STRING(0:30)
phys_state_abbr	STRING(2)
phys_postal_code	STRING(0:10)
phys_country_abbr	STRING(3)
mail_addr	STRING(0:254)
mail_city_name	STRING(0:60)
mail_state_abbr	STRING(2)
mail_postal_code	STRING(0:10)
mail_country_abbr	STRING(3)
us_ph_number	STRING(10)
int_ph_country_no	STRING(0:3)
int_ph_city_no	STRING(0:5)
int_ph_local_no	STRING(0:10)
us_fax_number	STRING(10)
int_fax_country_no	STRING(0:3)
int_fax_city_no	STRING(0:5)
int_fax_local_no	STRING(0:10)
business_desc	STRING(0:254)
primary_sic	STRING(0:8)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
default_mnemonic	STRING(3)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
child_sg_db_site	INT	NOT NULL
child_sg_db_id	INT	NOT NULL
child_sg_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
segment_group_yn	STRING(1)	NOT NULL in ('Y', 'N')
user_tag_ident	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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

Notes:

 This table stores all the service segments which have been designed

 to perform a function at a site. Service segments include production

 processes, their inputs and outputs, physical structures, systems,

 mechanical devices, and mechanical device areas. Many of these

 segments appear on the engineering blueprints of the site.

 These segments include components which perform a function

 ( Turbine-driven Pump 1A, Motor outboard bearing, etc.)  but do NOT

 describe the particular asset tracked by manufacturer,

 model number, & serial number in the database. This is done in the

 asset table. Some database track only data tied to service segments such

 as a machine train component, but do not tie the measurement data

 to the physical component assets installed at the time the data was

 taken. These databases cannot track, for example, a physical motor

 which is taken out of one machine train, cleaned, and then later

 used in another train. Other systems track physical assets and

 tie measurements to them. In order to provide maximum flexibility,

 this model allows both functional segment objects at a site and

 physical objects at a site to be placed in the database and data

 can be related to both as necessary. Table#44 ( ASSET_ON_SEGMENT)

 stores the utilization of a particular asset on a given segment

 with the time it was installed and removed.

 The Segment_Child Table shows the parent-child relationships

 of segments to each other. For example, segment "Steam Turbine"

 at site "ABC" is the child of segment "Turbine Generator#1 "

 which is the child of segment "Power Generation Line#1 ".

 The model allows for more than one segment to be the child of

 more than one segment.

 The segment_group_yn field when set to "Y" means that this segment

 is really a segment composed of 2 or more segments of the same type.

 If a count of total segments is made from the database, these group

 segments should be ignored.

 NOTE: Segment_id is used like a barcode--to assign a unique,

 non-changeable identifier since a primary key cannot change

 and must uniquely define the entity. The user_tag_ident

 field is the identifier which is meaningful to the plant.

 Computer systems monitoring or recording information on the

 same segment should utilize the same segment_site, segment_id

 pair.

 User_tag_ident is the user identification tag which

 follows the nomenclature of the plant. This is normally

 an abbreviation or user-defined alpha-numeric code from which

 the plant derives meaning. This column is mandatory.

 The "name" column is an optional column which is a full

 description of the segment.

Segment Child Table

#19 - segment_child

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
child_sg_site	INT	NOT NULL
child_sg_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
name	STRING(0:254)	NOT NULL
physics_descr	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
mult_fact_to_ref	DOUBLE	NOT NULL
refer_off_to_ref	DOUBLE	NOT NULL
name	STRING(0:254)	NOT NULL
abbrev	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
data_value	INT	NOT NULL
data_name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sn_db_id	INT	NOT NULL
sn_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sc_db_id	INT	NOT NULL
sc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
sn_db_site	INT	NOT NULL
sn_db_id	INT	NOT NULL
sn_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
sc_db_site	INT	NOT NULL
sc_db_id	INT	NOT NULL
sc_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
gmt_event_stop	DATETIME(10:29)
ev_loc_hr_delta	SHORT
ev_loc_min_delta	SHORT
gmt_stored	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
default_mnemonic	STRING(3)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
child_as_db_site	INT	NOT NULL
child_as_db_id	INT	NOT NULL
child_as_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
child_mf_db_site	INT	NOT NULL
child_mf_db_id	INT	NOT NULL
child_mf_duns_code	INT	NOT NULL
child_model_num	STRING(0:254)	NOT NULL
child_revision_num	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
an_db_id	INT	NOT NULL
an_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ac_db_id	INT	NOT NULL
ac_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
an_db_site	INT	NOT NULL
an_db_id	INT	NOT NULL
an_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
ac_db_site	INT	NOT NULL
ac_db_id	INT	NOT NULL
ac_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asr_db_id	INT	NOT NULL
asr_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
description	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Asset Table
Asset Owner History Table

Notes:

 Asset Readiness Type

Asset Table

#37 - asset

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
user_tag_ident	STRING(0:254)	NOT NULL
name	STRING(0:254)
serial_number	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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

Notes:

 This table stores any asset at any site. These

 might include actual motors, turbines, bearings, data collectors,

 transudcers, etc. Optionally, one can associate this physical asset

 with a service segment of the same type as the asset in a 1 to 1

 association. For example, asset "Induction Motor Model XYZ" with

 a specific manufacturer can currently be installed

 on segment "Induction Motor" at site#343434323 .

 The model allows for more than one asset to be the child of

 more than 1 parent asset through the Asset_Child table.

 NOTE: Asset_org_site is the ORIGINAL site the object was

 installed at and always remains part of the primary key.

 This asset may move to another site, but the asset_org_site

 and asset_id should remain the same. This relates to the

 Vehicle ID Number ( VIN)  on an automobile. The car may

 change owners by the VIN number does not change.

 Asset_id is used like a barcode--to assign a unique,

 non-changeable identifier since a primary key cannot change

 and must uniquely define the entity. The user_tag_ident

 field is the identifier which is meaningful to the plant.

 Computer systems monitoring or recording information on the

 same asset should utilize the same asset_org_site, asset_id

 pair.

 User_tag_ident is the user identification tag which

 follows the nomenclature of the plant. This is normally

 an abbreviation or user-defined alpha-numeric code from which

 the plant derives meaning. This column is mandatory.

 The "name" column is an optional column which is a full

 description of the asset.

Asset Child Table

#38 - asset_child

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
child_as_site	INT	NOT NULL
child_as_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
an_db_site	INT	NOT NULL
an_db_id	INT	NOT NULL
an_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
ac_db_site	INT	NOT NULL
ac_db_id	INT	NOT NULL
ac_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
gmt_event_stop	DATETIME(10:29)
ev_loc_hr_delta	SHORT
ev_loc_min_delta	SHORT
gmt_stored	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_installed	DATETIME(10:29)	NOT NULL
gmt_removed	DATETIME(10:29)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
pc_db_id	INT	NOT NULL
pc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Asset Owner History Table

Notes:

 Purchase Condition Type

Asset Owner History Table

#45 - asset_owner

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_purchased	DATETIME(10:29)	NOT NULL
gmt_sold	DATETIME(10:29)
gmt_discarded	DATETIME(10: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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ml_db_id	INT	NOT NULL
ml_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Measurement Location Table
Measurement Event History Table

Notes:

 This table stores all the various types of measurement locations.

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

Data Source Type Table

#51 - data_source_type

ds_db_site	INT	NOT NULL
ds_db_id	INT	NOT NULL
ds_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
tr_db_id	INT	NOT NULL
tr_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
tr_type_abbrev	STRING(2)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ta_db_id	INT	NOT NULL
ta_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
mc_db_id	INT	NOT NULL
mc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
description	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Measurement Location Table
Measurement Event History Table

Notes:

 Meas. Location Data Calculation Type

Measurement Location Table

#47 - meas_location

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
segment_or_asset	STRING(1)	NOT NULL in ('S', 'A')
ta_orient_deg	INT
mim_loc_seq	INT
motion_direction	STRING(1)	in ('N', 'R')
mim_user_prefix	STRING(4)
mc_calc_size	INT
update_interval	DOUBLE
collect_duration	INT
user_tag_ident	STRING(0:254)	NOT NULL
barcode	STRING(0:254)
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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
Measurement Location Association

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
name	STRING(0:254)
user_tag_ident	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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

Notes:

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

 NOTE: ord_list_id should be a non-changeable, unique

 identifier since a primary key cannot change and

 must uniquely define the entity. System-assigned

 "hidden" ord_list_id's are strongly recommended.

Ordered List of Measurement Locations Table

#49 - meas_loc_list

ord_list_db_site	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
channel_number	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ds_asset_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
tr_asset_id	INT	NOT NULL
out_amplitude	DOUBLE
gmt_last_calib	DATETIME(10:29)
self_powered_yn	STRING(1)	in (NULL, 'Y', 'N')
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	SHORT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ev_loc_hr_delta	SHORT
ev_loc_min_delta	SHORT
gmt_stored	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
mc_calc_size	INT
collect_duration	DOUBLE
confid_percent	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
related_mloc_site	INT	NOT NULL
related_mloc_id	INT	NOT NULL
related_gmt_event	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
eu_db_site	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
eu_db_site	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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	SHORT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
alarm_db_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_alarm_start	DATETIME(10:29)	NOT NULL
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
min_amplitude	DOUBLE	NOT NULL
max_amplitude	DOUBLE	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] 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]
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]
row_status_type () [rstat_type_code]

Used By:

Numeric Alarm Associated Regions in Alarm

Notes:

 Measurement Location Numeric Alarm Regions

agent_type

#109 - agent_type

agent_db_site	INT	NOT NULL
agent_db_id	INT	NOT NULL
agent_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

agent

Notes:

agent

#117 - agent

org_agent_site	INT	NOT NULL
agent_id	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
src_dt_db_id	INT	NOT NULL
src_dt_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
pst_sc_db_id	INT	NOT NULL
pst_sc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
eu_db_site	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
gmt_acknowledged	DATETIME(10:29)
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
eu_db_site	INT	NOT NULL
eu_db_id	INT	NOT NULL
eu_type_code	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
alarm_db_site	INT	NOT NULL
alarm_db_id	INT	NOT NULL
al_meas_loc_site	INT	NOT NULL
al_meas_loc_id	INT	NOT NULL
al_ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Numeric Alarm Associated Regions in Alarm

Signal-processed Amplitudes Alarm Regions

#319 - spa_alarm_reg

alarm_db_site	INT	NOT NULL
alarm_db_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
freq_or_order	STRING(1)	NOT NULL
min_in_hz_or_ord	DOUBLE	NOT NULL
max_in_hz_or_ord	DOUBLE	NOT NULL
gmt_alarm_start	DATETIME(10:29)	NOT NULL
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
min_amplitude	DOUBLE	NOT NULL
max_amplitude	DOUBLE	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] 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]
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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sp_db_id	INT	NOT NULL
sp_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
sp_blk_db_id	INT	NOT NULL
sp_block_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
spn_db_id	INT	NOT NULL
spn_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
sp_blk_db_id	INT	NOT NULL
sp_block_id	INT	NOT NULL
spn_db_site	INT	NOT NULL
spn_db_id	INT	NOT NULL
spn_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sps_type_db_id	INT	NOT NULL
sps_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Signal Process Stream Table

Notes:

 Signal Process Stream Type

Signal Process Stream Table

#68 - sp_stream

sp_str_db_site	INT	NOT NULL
sp_str_db_id	INT	NOT NULL
sp_stream_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sp_str_db_id	INT	NOT NULL
sp_stream_id	INT	NOT NULL
sp_blk_db_site	INT	NOT NULL
sp_blk_db_id	INT	NOT NULL
sp_block_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ave_db_id	INT	NOT NULL
ave_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
ave_wt_db_id	INT	NOT NULL
ave_wt_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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	INT	NOT NULL
ave_sy_db_id	INT	NOT NULL
ave_sy_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
freq_or_order	STRING(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	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
gmt_acknowledged	DATETIME(10:29)
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
alarm_db_site	INT	NOT NULL
alarm_db_id	INT	NOT NULL
al_meas_loc_site	INT	NOT NULL
al_meas_loc_id	INT	NOT NULL
al_ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Signal-Processed Amplitude Associated Regions in Alarm

Window Type Table

#80 - window_type

win_db_site	INT	NOT NULL
win_db_id	INT	NOT NULL
win_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
pf_multiplier	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
freq_or_order	STRING(1)	NOT NULL in ('F', 'O')
min_in_hz_or_ord	DOUBLE	NOT NULL
max_in_hz_or_ord	DOUBLE	NOT NULL
resolution_lines	INT	NOT NULL
ave_overlap_pct	DOUBLE
num_of_averages	INT
assoc_rpm_in_hz	DOUBLE
name	STRING(0:254)
dc_level	DOUBLE
complex_yn	STRING(1)	NOT NULL in ('Y', 'N')
spectrum_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
secs_or_revs	STRING(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	INT
assoc_rpm_in_hz	DOUBLE
name	STRING(0:254)
complex_yn	STRING(1)	NOT NULL in ('Y', 'N')
waveform_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
ordering_seq	INT	NOT NULL
number_of_bands	INT	NOT NULL
center_in_hz_1bd	DOUBLE	NOT NULL
width_pct_or_oct	STRING(1)	NOT NULL in ('P', 'O')
band_width	DOUBLE	NOT NULL
ave_overlap_pct	DOUBLE
num_of_averages	INT
assoc_rpm_in_hz	DOUBLE
name	STRING(0:254)
spectrum_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
spa_setup_db_id	INT	NOT NULL
spa_setup_id	INT	NOT NULL
freq_or_order	STRING(1)	NOT NULL in ('F', 'O')
min_in_hz_or_ord	DOUBLE	NOT NULL
max_in_hz_or_ord	DOUBLE	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
spf_setup_db_id	INT	NOT NULL
spf_setup_id	INT	NOT NULL
freq_or_order	STRING(1)	NOT NULL in ('F', 'O')
min_in_hz_or_ord	DOUBLE	NOT NULL
max_in_hz_or_ord	DOUBLE	NOT NULL
resolution_lines	INT	NOT NULL
ave_overlap_pct	DOUBLE
num_of_averages	INT
complex_yn	STRING(1)	NOT NULL in ('Y', 'N')
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
spt_setup_db_id	INT	NOT NULL
spt_setup_id	INT	NOT NULL
secs_or_revs	STRING(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	INT
complex_yn	STRING(1)	NOT NULL in ('Y', 'N')
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
spc_setup_db_id	INT	NOT NULL
spc_setup_id	INT	NOT NULL
number_of_bands	INT	NOT NULL
center_in_hz_1bd	DOUBLE	NOT NULL
width_pct_or_oct	STRING(1)	NOT NULL in ('P', 'O')
band_width	DOUBLE	NOT NULL
ave_overlap_pct	DOUBLE
num_of_averages	INT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
channel_number	INT	NOT NULL
spa_setup_db_site	INT	NOT NULL
spa_setup_db_id	INT	NOT NULL
spa_setup_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
channel_number	INT	NOT NULL
spf_setup_db_site	INT	NOT NULL
spf_setup_db_id	INT	NOT NULL
spf_setup_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
channel_number	INT	NOT NULL
spt_setup_db_site	INT	NOT NULL
spt_setup_db_id	INT	NOT NULL
spt_setup_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
channel_number	INT	NOT NULL
spc_setup_db_site	INT	NOT NULL
spc_setup_db_id	INT	NOT NULL
spc_setup_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
abbrev	STRING(0:40)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

MIMOSA Interface Type

Notes:

 Types of MIMOSA Technology

MIMOSA Support Levels

#216 - mim_support_type

supp_type_code	INT	NOT NULL
abbrev	STRING(0:40)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Support Levels

MIMOSA Data Categories

#217 - mim_data_cat_type

dcat_type_code	INT	NOT NULL
abbrev	STRING(0:10)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Data Categories

MIMOSA Functionality Type

#326 - mim_func_type

func_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

MIMOSA Interface Type

Notes:

 MIMOSA Functionality Type

MIMOSA Interface Type

#327 - mim_interface_type

interf_type_code	INT	NOT NULL
version_supported	SHORT	NOT NULL
subversion_supp	SHORT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

MIMOSA Interfaces Supported By A Database

Notes:

 MIMOSA Interface Type

MIMOSA Interfaces Supported By A Database

#328 - db_mim_interface

db_site	INT	NOT NULL
db_id	INT	NOT NULL
interf_type_code	INT	NOT NULL
gmt_last_refresh	DATETIME(10:29)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
from_db_id	INT	NOT NULL
to_db_site	INT	NOT NULL
to_db_id	INT	NOT NULL
to_odbc_conn_str	STRING(0:254)
mim_table_owner	STRING(0:254)
wr_posting_yn	STRING(1)	in ('Y', 'N')
wr_ack_yn	STRING(1)	in ('Y', 'N')
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
nt_db_id	INT	NOT NULL
nt_type_code	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Network

Notes:

 Network Type

Event Type Child

#121 - event_type_child

ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
child_ev_db_site	INT	NOT NULL
child_ev_db_id	INT	NOT NULL
child_ev_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
stt_db_id	INT	NOT NULL
stt_code	INT	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
snum_db_id	INT	NOT NULL
snum_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Measurement Sample Numeric Data

Notes:

 Sample Numeric Data Type

Sample Character Data Type

#290 - sample_cdata_type

schr_db_site	INT	NOT NULL
schr_db_id	INT	NOT NULL
schr_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Measurement Sample Character Data

Notes:

 Sample Character Data Type

Test Results Numeric Data Type

#161 - test_result_ntype

strn_db_site	INT	NOT NULL
strn_db_id	INT	NOT NULL
str_num_type_code	INT	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
strc_db_id	INT	NOT NULL
str_chr_type_code	INT	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
strb_db_id	INT	NOT NULL
str_blob_type_code	INT	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
mebt_db_id	INT	NOT NULL
meb_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Measurement Event Binary Data

Notes:

 Measurement Event Binary Large Object Type

Highlight Area Type

#292 - highlight_type

high_db_site	INT	NOT NULL
high_db_id	INT	NOT NULL
high_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
ag_role_db_id	INT	NOT NULL
ag_role_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
wm_type_db_id	INT	NOT NULL
wm_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
task_db_id	INT	NOT NULL
task_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
task_db_id	INT	NOT NULL
task_type_code	INT	NOT NULL
child_tk_db_site	INT	NOT NULL
child_tk_db_id	INT	NOT NULL
child_tk_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Work Task Parent Child Taxonomy

Change Pattern Type

#151 - change_patt_type

ch_patt_db_site	INT	NOT NULL
ch_patt_db_id	INT	NOT NULL
ch_patt_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
waudit_db_id	INT	NOT NULL
waudit_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
wn_db_id	INT	NOT NULL
wn_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
wc_db_id	INT	NOT NULL
wc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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	INT	NOT NULL
sol_db_id	INT	NOT NULL
sol_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

Used By:

Solution Package

Notes:

 Solution Package Type

Network

#284 - network

network_db_site	INT	NOT NULL
network_db_id	INT	NOT NULL
network_id	INT	NOT NULL
user_tag_ident	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Segment Network Connect
Asset Network Connect

Notes:

Segment Network Connect

#308 - sg_network_connect

network_db_site	INT	NOT NULL
network_db_id	INT	NOT NULL
network_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
output_sg_site	INT	NOT NULL
output_sg_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_stream_config	DATETIME(10:29)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Asset Network Connect

#309 - as_network_connect

network_db_site	INT	NOT NULL
network_db_id	INT	NOT NULL
network_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
output_as_site	INT	NOT NULL
output_as_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_stream_config	DATETIME(10:29)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Agent Role

#118 - agent_role

org_agent_site	INT	NOT NULL
agent_id	INT	NOT NULL
ag_role_db_site	INT	NOT NULL
ag_role_db_id	INT	NOT NULL
ag_role_type_code	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Agent Roles

Agent Role With Associated Agent

#223 - agent_role_with_agent

org_agent_site	INT	NOT NULL
agent_id	INT	NOT NULL
ag_role_db_site	INT	NOT NULL
ag_role_db_id	INT	NOT NULL
ag_role_type_code	INT	NOT NULL
other_org_agent_site	INT	NOT NULL
other_agent_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
alarm_db_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
gmt_alarm_start	DATETIME(10:29)	NOT NULL
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
min_data_value	DOUBLE	NOT NULL
max_data_value	DOUBLE	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

site_database () [alarm_db_site, alarm_db_id] NOT NULL
meas_location () [meas_loc_site, meas_loc_id] 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]
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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
user_tag_ident	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
child_mloc_site	INT	NOT NULL
child_mloc_id	INT	NOT NULL
child_gmt_event	DATETIME(10:29)	NOT NULL
child_sam_ord_seq	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Master To Subsequent Child Sub-Samples

Measurement Sample Numeric Data

#213 - sample_num_data

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
snum_db_site	INT	NOT NULL
snum_db_id	INT	NOT NULL
snum_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Numeric Data

Measurement Sample Character Data

#288 - sample_chr_data

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
schr_db_site	INT	NOT NULL
schr_db_id	INT	NOT NULL
schr_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Character Data

Measurement Sample Remark

#289 - sample_remark

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Remark

Measurement Sample Test

#122 - meas_sample_test

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
user_tag_ident	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_started	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
gmt_ended	DATETIME(10:29)
end_loc_hr_delta	SHORT
end_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
real_data_value	DOUBLE	NOT NULL
imag_data_value	DOUBLE
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Test Character Results

Measurement Sample Test Remark

#287 - test_remark

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Sample Test Remark

Measurement Sample Test Histogram

#214 - test_histogram

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
min_screen_in_eu	INT	NOT NULL
max_screen_in_eu	INT	NOT NULL
resolution_lines	INT	NOT NULL
name	STRING(0:254)
histogram_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
gmt_acknowledged	DATETIME(10:29)
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
alarm_db_site	INT	NOT NULL
alarm_db_id	INT	NOT NULL
al_meas_loc_site	INT	NOT NULL
al_meas_loc_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Sample Test Alarm Associated Regions in Alarm

Measurement Sample Test Binary Results

#168 - test_blob_results

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
sample_order_seq	INT	NOT NULL
test_order_seq	INT	NOT NULL
ordering_seq	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
assoc_file_name	STRING(0:254)
gmt_acknowledged	DATETIME(10:29)	NOT NULL
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
sg_db_site	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
mf_db_site	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Model Binary Data Related to a Specific Database

Asset Type Binary Data

#225 - as_type_blob_data

db_site	INT	NOT NULL
db_id	INT	NOT NULL
as_db_site	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Type Binary Data Related to a Specific Database

Asset Binary Data

#189 - asset_blob_data

db_site	INT	NOT NULL
db_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Binary Data Related To a Specific Database

Ordered List Binary Data

#190 - olist_blob_data

db_site	INT	NOT NULL
db_id	INT	NOT NULL
ord_list_db_site	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Ordered List Binary Data Related to a Specific Database

Measurement Event Binary Data

#165 - mevent_blob_data

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
mebt_db_site	INT	NOT NULL
mebt_db_id	INT	NOT NULL
meb_type_code	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
mebt_db_site	INT	NOT NULL
mebt_db_id	INT	NOT NULL
meb_type_code	INT	NOT NULL
grid_seq	INT	NOT NULL
x_resolution	INT	NOT NULL
y_resolution	INT	NOT NULL
data_origin_x	INT	NOT NULL
data_origin_y	INT	NOT NULL
data_end_x	INT	NOT NULL
data_end_y	INT	NOT NULL
name	STRING(0:254)
float_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
mebt_db_site	INT	NOT NULL
mebt_db_id	INT	NOT NULL
meb_type_code	INT	NOT NULL
al_db_site	INT	NOT NULL
al_db_id	INT	NOT NULL
al_type_code	INT	NOT NULL
gmt_acknowledged	DATETIME(10:29)	NOT NULL
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
mebt_db_site	INT	NOT NULL
mebt_db_id	INT	NOT NULL
meb_type_code	INT	NOT NULL
area_seq	INT	NOT NULL
x_resolution	INT	NOT NULL
y_resolution	INT	NOT NULL
data_origin_x	INT	NOT NULL
data_origin_y	INT	NOT NULL
data_end_x	INT	NOT NULL
data_end_y	INT	NOT NULL
gmt_acknowledged	DATETIME(10:29)	NOT NULL
ack_loc_hr_delta	SHORT
ack_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
user_tag_id	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
user_tag_id	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
sg_db_site	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
user_tag_id	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
as_db_site	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
user_tag_id	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
db_id	INT	NOT NULL
mf_db_site	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
ordering_seq	INT	NOT NULL
user_tag_id	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ev_segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
fn_db_site	INT	NOT NULL
fn_db_id	INT	NOT NULL
fn_segment_site	INT	NOT NULL
fn_segment_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Events Linked to Functions Affected

Asset Events Linked to Functions Affected

#229 - as_ev_as_func_link

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
fc_as_org_site	INT	NOT NULL
fc_as_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Events Linked to Functions Affected

Segment Event Numeric Data

#111 - sg_event_num_data

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Event Numeric Data

Asset Event Numeric Data

#113 - as_event_num_data

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Event Numeric Data

Segment Events Associated With Measurement Event

#294 - sg_ev_meas_event

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Events Associated With Measurement Events Which Substantiate the Actual Event

Segment Event Link

#152 - segment_event_link

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
caused_sg_site	INT	NOT NULL
caused_sg_id	INT	NOT NULL
caused_ev_db_site	INT	NOT NULL
caused_ev_db_id	INT	NOT NULL
caused_ev_code	INT	NOT NULL
caused_gmt	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Event Cause, Effect Links in an Event Causal Network

Asset Event Link

#153 - asset_event_link

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
caused_as_site	INT	NOT NULL
caused_as_id	INT	NOT NULL
caused_ev_db_site	INT	NOT NULL
caused_ev_db_id	INT	NOT NULL
caused_ev_code	INT	NOT NULL
caused_gmt	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Event Cause, Effect Links in an Event Causal Network

Hypothetical Segment Event

#230 - sg_hyp_event

sg_hyp_db_site	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sgt_hyp_db_id	INT	NOT NULL
sgt_hyp_event_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ast_hyp_db_id	INT	NOT NULL
ast_hyp_event_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mod_hyp_db_id	INT	NOT NULL
mod_hyp_event_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sgt_hyp_db_id	INT	NOT NULL
sgt_hyp_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ast_hyp_db_id	INT	NOT NULL
ast_hyp_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mod_hyp_db_id	INT	NOT NULL
mod_hyp_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Hypothetical Event Numeric Data

Asset Hypothetical Event Numeric Data

#235 - as_hyp_ev_num_data

as_hyp_db_site	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sgt_hyp_db_id	INT	NOT NULL
sgt_hyp_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ast_hyp_db_id	INT	NOT NULL
ast_hyp_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Type Hypothetical Event Numeric Data

Model Hypothetical Event Numeric Data

#248 - model_hyp_ev_num_data

mod_hyp_db_site	INT	NOT NULL
mod_hyp_db_id	INT	NOT NULL
mod_hyp_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sgt_hyp_db_id	INT	NOT NULL
sgt_hyp_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
sg_db_site	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ast_hyp_db_id	INT	NOT NULL
ast_hyp_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
as_db_site	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mod_hyp_db_id	INT	NOT NULL
mod_hyp_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
mf_db_site	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Model Hypothetical Events Linked to Functions Affected

Proposed Segment Event

#250 - sg_proposed_event

sg_prop_db_site	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
gmt_proposed	DATETIME(10:29)
pr_loc_hr_delta	SHORT
pr_loc_min_delta	SHORT
likelihood_prob	DOUBLE
est_gmt_start	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
est_gmt_occur_end	DATETIME(10:29)
end_loc_hr_delta	SHORT
end_loc_min_delta	SHORT
name	STRING(0:254)
gmt_audited	DATETIME(10:29)
aud_loc_hr_delta	SHORT
aud_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
gmt_proposed	DATETIME(10:29)
pr_loc_hr_delta	SHORT
pr_loc_min_delta	SHORT
likelihood_prob	DOUBLE
est_gmt_start	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
est_gmt_occur_end	DATETIME(10:29)
end_loc_hr_delta	SHORT
end_loc_min_delta	SHORT
name	STRING(0:254)
gmt_audited	DATETIME(10:29)
aud_loc_hr_delta	SHORT
aud_loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
caused_db_site	INT	NOT NULL
caused_db_id	INT	NOT NULL
caused_event_id	INT	NOT NULL
likelihood_prob	DOUBLE
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Proposed Event Numeric Data

Asset Proposed Event Numeric Data

#255 - as_prop_ev_ndat

as_prop_db_site	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
en_db_site	INT	NOT NULL
en_db_id	INT	NOT NULL
en_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
db_site	INT	NOT NULL
db_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
sg_hypev_db_site	INT	NOT NULL
sg_hypev_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
as_hypev_db_site	INT	NOT NULL
as_hypev_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
hgrade_float	DOUBLE
likelihood_prob	DOUBLE
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_audited	DATETIME(10:29)
aud_loc_hr_delta	SHORT
aud_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
hgrade_float	DOUBLE
likelihood_prob	DOUBLE
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
gmt_audited	DATETIME(10:29)
aud_loc_hr_delta	SHORT
aud_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ev_sg_site	INT	NOT NULL
ev_sg_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ev_as_org_site	INT	NOT NULL
ev_as_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
sg_prop_db_site	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
as_prop_db_site	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
est_remaining_life	DOUBLE
error_estimate	DOUBLE
likelihood_prob	DOUBLE
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_assessment	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
est_remaining_life	DOUBLE
error_estimate	DOUBLE
likelihood_prob	DOUBLE
gmt_created	DATETIME(10:29)
cr_loc_hr_delta	SHORT
cr_loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Segment Recommendation Remarks

 NOTE: by_agent_site, by_agent_id - Originator

Asset Recommendation Remarks

#131 - as_rec_remark

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
remark_text	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Binary Data Related to a Segment Recommendation

Binary Data Related to an Asset Recommendation

#312 - as_rec_blob

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
image_data	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Binary Data Related to a Model Recommendation

Segment Health Assessments Linked to Segment Recommendations

#302 - sg_rec_sg_health

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
hth_sg_site	INT	NOT NULL
hth_sg_id	INT	NOT NULL
hth_gmt_assess	DATETIME(10:29)	NOT NULL
hth_by_agent_site	INT	NOT NULL
hth_by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
hth_as_org_site	INT	NOT NULL
hth_asset_id	INT	NOT NULL
hth_gmt_assess	DATETIME(10:29)	NOT NULL
hth_by_agent_site	INT	NOT NULL
hth_by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Asset Health Assessments Linked to Asset Recommendations

Actual Segment Events Linked to Segment Recommendations

#208 - sg_rec_sg_event

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ev_sg_site	INT	NOT NULL
ev_sg_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
ev_as_org_site	INT	NOT NULL
ev_as_id	INT	NOT NULL
ev_db_site	INT	NOT NULL
ev_db_id	INT	NOT NULL
event_type_code	INT	NOT NULL
gmt_event_start	DATETIME(10:29)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
sg_hyp_db_site	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
as_hyp_db_site	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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_type_rec_hyp_ev

sg_db_site	INT	NOT NULL
sg_db_id	INT	NOT NULL
sg_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
sg_hyp_db_site	INT	NOT NULL
sg_hyp_db_id	INT	NOT NULL
sg_hyp_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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_type_rec_hyp_ev

as_db_site	INT	NOT NULL
as_db_id	INT	NOT NULL
as_type_code	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
as_hyp_db_site	INT	NOT NULL
as_hyp_db_id	INT	NOT NULL
as_hyp_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
mf_db_id	INT	NOT NULL
mf_duns_code	INT	NOT NULL
model_number	STRING(0:254)	NOT NULL
revision_number	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
mod_hyp_db_site	INT	NOT NULL
mod_hyp_db_id	INT	NOT NULL
mod_hyp_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
sg_prop_db_site	INT	NOT NULL
sg_prop_db_id	INT	NOT NULL
sg_prop_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
as_prop_db_site	INT	NOT NULL
as_prop_db_id	INT	NOT NULL
as_prop_event_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Events Linked to Segment Recommendations

Measurement Events Linked to Asset Recommendations

#305 - as_rec_mevent

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
gmt_event	DATETIME(10:29)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Measurement Events Linked to Asset Recommendations

Work Request

#136 - work_request

work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
loc_hr_delta	SHORT
loc_min_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
repeat_interval	INT
user_tag_ident	STRING(0:254)	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
sol_pack_db_id	INT	NOT NULL
sol_pack_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
loc_hr_delta	SHORT
loc_min_delta	SHORT
user_tag_ident	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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

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	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_requested	DATETIME(10:29)	NOT NULL
req_by_agent_site	INT	NOT NULL
req_by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
req_loc_hr_delta	SHORT
req_loc_min_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
repeat_interval	INT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_requested	DATETIME(10:29)	NOT NULL
req_by_agent_site	INT	NOT NULL
req_by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
req_loc_hr_delta	SHORT
req_min_hr_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
repeat_interval	INT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
gmt_requested	DATETIME(10:29)	NOT NULL
req_by_agent_site	INT	NOT NULL
req_by_agent_id	INT	NOT NULL
ordering_seq	INT	NOT NULL
req_loc_hr_delta	SHORT
req_loc_min_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
repeat_interval	INT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
sol_pack_db_site	INT	NOT NULL
sol_pack_db_id	INT	NOT NULL
sol_pack_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Associated Solution Packages For a Work Request

Work Request Numeric Data

#172 - work_req_num_data

work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
wn_db_site	INT	NOT NULL
wn_db_id	INT	NOT NULL
wn_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Work Request Numeric Data

Work Request Character Data

#173 - work_req_chr_data

work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
wc_db_site	INT	NOT NULL
wc_db_id	INT	NOT NULL
wc_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Work Request Character Data

Work Request Binary Data

#335 - work_req_blob_data

work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
bd_db_site	INT	NOT NULL
bd_db_id	INT	NOT NULL
bd_type_code	INT	NOT NULL
ordering_seq	INT	NOT NULL
name	STRING(0:254)
assoc_file_name	STRING(0:254)
associated_blob	BASE64BINARY
gmt_last_updated	DATETIME(10:29)

Foreign keys:

work_request () [work_req_db_site, work_req_db_id, work_req_id] NOT NULL

blob_data_type () [bd_db_site, bd_db_id, bd_type_code] NOT NULL
blob_content_type () [blct_db_site, blct_db_id, blc_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Work Request BLOB Data – For attachments to Work Requests

Work Request Audit

#174 - work_request_audit

work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
waudit_db_site	INT	NOT NULL
waudit_db_id	INT	NOT NULL
waudit_type_code	INT	NOT NULL
gmt_audit_posted	DATETIME(10:29)	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
gmt_created	DATETIME(10:29)
loc_hr_delta	SHORT
loc_min_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
repeat_interval	INT
user_tag_ident	STRING(0:254)	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
child_wo_db_site	INT	NOT NULL
child_wo_db_id	INT	NOT NULL
child_wo_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
wn_db_site	INT	NOT NULL
wn_db_id	INT	NOT NULL
wn_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Work Order Character Data

#176 - work_order_chr_data

work_order_db_site	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
wc_db_site	INT	NOT NULL
wc_db_id	INT	NOT NULL
wc_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Work Order Audit

#177 - work_order_audit

work_order_db_site	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
waudit_db_site	INT	NOT NULL
waudit_db_id	INT	NOT NULL
waudit_type_code	INT	NOT NULL
gmt_audit_posted	DATETIME(10:29)	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Work Order Step

#140 - work_order_step

work_order_db_site	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
gmt_created	DATETIME(10:29)
loc_hr_delta	SHORT
loc_min_delta	SHORT
start_before_gmt	DATETIME(10:29)
end_before_gmt	DATETIME(10:29)
start_after_gmt	DATETIME(10:29)
end_after_gmt	DATETIME(10:29)
user_tag_ident	STRING(0:254)	NOT NULL
abbrev	STRING(0:254)
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

work_order () [work_order_db_site, work_order_db_id, work_order_id] NOT NULL
agent () [by_agent_site, by_agent_id]
agent () [from_sy_agent_site, from_sy_agent_id]
agent () [to_agent_site, to_agent_id]
priority_type () [priority_type_code]
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
wn_db_site	INT	NOT NULL
wn_db_id	INT	NOT NULL
wn_type_code	INT	NOT NULL
data_value	DOUBLE	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Work Order Step Character Data

#179 - wo_step_chr_data

work_order_db_site	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
wc_db_site	INT	NOT NULL
wc_db_id	INT	NOT NULL
wc_type_code	INT	NOT NULL
data_value	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 null

Work Order Step Audit

#180 - wo_step_audit

work_order_db_site	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
waudit_db_site	INT	NOT NULL
waudit_db_id	INT	NOT NULL
waudit_type_code	INT	NOT NULL
gmt_audit_posted	DATETIME(10:29)	NOT NULL
loc_hr_delta	SHORT
loc_min_delta	SHORT
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
gmt_recommendation	DATETIME(10:29)	NOT NULL
by_agent_site	INT	NOT NULL
by_agent_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
work_order_db_id	INT	NOT NULL
work_order_id	INT	NOT NULL
work_ord_step_seq	INT	NOT NULL
work_req_db_site	INT	NOT NULL
work_req_db_id	INT	NOT NULL
work_req_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

 Work Requests Related to Work Order Steps

Completed Work Tasks For Segments

#144 - sg_completed_work

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
task_db_site	INT	NOT NULL
task_db_id	INT	NOT NULL
task_type_code	INT	NOT NULL
gmt_completed	DATETIME(10:29)	NOT NULL
cp_loc_hr_delta	SHORT
cp_loc_min_delta	SHORT
gmt_started	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
asset_id	INT	NOT NULL
task_db_site	INT	NOT NULL
task_db_id	INT	NOT NULL
task_type_code	INT	NOT NULL
gmt_completed	DATETIME(10:29)	NOT NULL
cp_loc_hr_delta	SHORT
cp_loc_min_delta	SHORT
gmt_started	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]]
row_status_type () [rstat_type_code]

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	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
task_db_site	INT	NOT NULL
task_db_id	INT	NOT NULL
task_type_code	INT	NOT NULL
gmt_completed	DATETIME(10:29)	NOT NULL
cp_loc_hr_delta	SHORT
cp_loc_min_delta	SHORT
gmt_started	DATETIME(10:29)
st_loc_hr_delta	SHORT
st_loc_min_delta	SHORT
abbrev	STRING(0:254)	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

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]]
row_status_type () [rstat_type_code]

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

Measurement Location Type Child Table

#329 - mloc_type_child

ml_db_site	INT	NOT NULL
ml_db_id	INT	NOT NULL
ml_type_code	INT	NOT NULL
child_ml_db_site	INT	NOT NULL
child_ml_db_id	INT	NOT NULL
child_ml_type_code	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

meas_loc_type () [ml_db_site, ml_db_id, ml_type_code] NOT NULL
meas_loc_type (child_mloc_type) [child_ml_db_site, child_ml_db_id, child_ml_type_code] NOT NULL
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

The mloc_type_child table shows the parent-child relationships of measurement location types to each other.

For example, measurement location type "Speed, Shaft, Input Shaft" is the child of measurement location

type "Speed, Shaft" which is the child of measurement location type "Speed".  The model allows for more

than one measurement location type to be the child of more than one measurment location type.  The

mandatory ordering sequence specifies the order in which child measurement location types appear when

as application requests "all children" of a particular measurment location type.

Asset Solution Packages

#330 - as_sol_pack

asset_org_site	INT	NOT NULL
asset_id	INT	NOT NULL
sol_pack_db_site	INT	NOT NULL
sol_pack_db_id	INT	NOT NULL
sol_pack_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Associated solution packages for an asset.

Segment Solution Packages

#331 - sg_sol_pack

segment_site	INT	NOT NULL
segment_id	INT	NOT NULL
sol_pack_db_site	INT	NOT NULL
sol_pack_db_id	INT	NOT NULL
sol_pack_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Associated solution packages for a segment.

Ordered List Solution Packages

#332 - ol_sol_pack

ord_list_db_site	INT	NOT NULL
ord_list_db_id	INT	NOT NULL
ord_list_id	INT	NOT NULL
sol_pack_db_site	INT	NOT NULL
sol_pack_db_id	INT	NOT NULL
sol_pack_id	INT	NOT NULL
gmt_last_updated	DATETIME(10:29)

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]
row_status_type () [rstat_type_code]

Used By:

Notes:

Associated solution packages for an ordered list.

BLOB Content Type

#333 - blob_content_type

blct_db_site	INT	NOT NULL
blct_db_id	INT	NOT NULL
blc_type_code	INT	NOT NULL
name	STRING(0:254)	NOT NULL
gmt_last_updated	DATETIME(10:29)

Foreign keys:

site_database () [blct_db_site, blct_db_id]
site_database (site_db) [last_upd_db_site, last_upd_db_id]
row_status_type () [rstat_type_code]

Used By:

Notes:

 This table stores the content types of Binary Large Object Data for Segments,

 Assets, Models, and Ordered Lists.

Measurement Location Association

#334 - meas_loc_assoc

meas_loc_site	INT	NOT NULL
meas_loc_id	INT	NOT NULL
related_mloc_site	INT	NOT NULL
related_mloc_id	INT	NOT NULL
name	STRING(0:254)
gmt_last_updated	DATETIME(10:29)

Foreign keys:

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

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.

MIMOSA CRIS V2.2