Data Loader

About the Hazards Data Loader

Using the Hazards Data Loader, you can implement HAZOP Analysis when you have data in a legacy system. To import data using the Hazards Data Loader, APM provides an Excel workbook, Hazards.xlsx, which supports baseline Hazards Analysis in APM. You must export your legacy system so that the data can be used to populate the workbook. The data from the workbook will then be imported into APM using the Hazards Data Loader.

Note: The Excel template is referred to throughout this documentation as the data loader workbook.

The data loader workbook can be used in the following scenario:

  • Loading existing legacy HAZOP analysis data into APM so that you can retain visibility into previous HAZOP analyses, view the risk mitigation graph and re-validation schedules.

After importing the data, the Hazards Data Loader creates the following records in APM:

  • Hazards Analysis
  • Hazards Analysis System/Node
  • Hazards Analysis Deviation
  • Hazards Analysis Cause
  • Hazards Analysis Consequence
  • Hazards Analysis Safeguard
  • Independent Layer of Protection
  • Risk Assessment
  • Risk Assessment Recommendation
  • Human Resource
Note: This data loader workbook is not backward compatible to earlier versions of APM.

About the Hazards Data Loader Requirements

Before importing data using the data loader workbook, you must have completed the deployment of the Hazards Analysis module. You must also have populated the Equipment and Functional Location to establish relationship with the families in Hazards Analysis, and have entered a valid Equipment entity key and Functional Location entity key into the data loader workbook. To do this, the Equipment and Functional Locations must exist in the APM database.

Security Settings

The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role.

About the Hazards Data Loader General Loading Strategy

The imported data must load in a specific sequence in order to successfully populate fields, to create records, and to link them to the predecessor and/or successor records.

Best Practices

When importing data using the data loader workbook, you must use the following best practices:

  • ID fields (Row 2 of each worksheet) must not include special characters (other than underscores) or spaces.
  • Columns (including columns representing custom fields) in the worksheets should be formatted as Text.
  • You should not try to create and update a component in the same data loader workbook.
  • You must consider the rules described in the Workbook Layout and Use section of this document while using the Hazards Data Loader.

Load Sequence

When importing data using the data loader workbook, you must use the following workflow:

  1. Download the data loader workbook provided by APM
  2. Identify the data requirements for exporting the data in to the data loader workbook.
  3. Extract data from legacy applications to populate the data loader workbook.
  4. Import data into APM.
  5. Monitor the status of the data load, and verify the results in the log.
  6. Conduct tests in APM to ensure that the imported data loaded accurately.

For each row in the data loader workbook, the Hazards Loader creates a new record in APM. However, if records have already been created and you reimport the data, the existing records will be updated.

About the Hazards Data Loader Load Verification

About This Task

Following a successful data load, the user is able to navigate to any of the imported templates, to view the details associated with the template, and to import template content into an analysis.

Procedure

  1. In the data loader worksheet, enter the following values:

    Worksheet

    Field Caption

    Value

    MI_HAZANANA

    Analysis ID

    Hazop-DL-Testing-01

    Analysis Type

    HAZOP

    Site Reference NameISO Site

    MI_HAZANNOD

    Analysis ID

    Hazop-DL-Testing-01

    System/Node ID

    Node-01

    System/Node Number

    1

    Analysis ID

    Hazop-DL-Testing-01

    System/Node ID

    Node-02

    System/Node Number

    2

    Node_Assets

    Analysis ID

    Hazop-DL-Testing-01

    System/Node ID

    Node-01

    System/Node Number

    1

    Equipment Technical Number

    A001

    MI_HAZOPDEV

    Analysis ID

    Hazop-DL-Testing-01

    System/Node Number

    1

    Deviation Sequence Number

    1

    Deviation/Guideword

    More Temperature

    Analysis ID

    Hazop-DL-Testing-01

    System/Node Number

    2

    Deviation Sequence Number

    1

    Deviation/Guideword

    Less Flow

    MI_HAZANSAF

    Analysis ID

    Hazop-DL-Testing-01

    System/Node ID

    Node-01

    System/Node Number

    1

    Deviation Sequence Number

    1

    Cause Sequence Number

    1

    Consequence Sequence Number

    1

    Safeguard ID

    Node-01 Safeguard

    Safeguard Sequence Number

    1

    MI_HAZANCAUAnalysis IDHazop-DL-Testing-01
    System/Node Number1
    Deviation Sequence Number1
    Cause Sequence Number1
    Cause IDCause-01
    MI_HAZANCONAnalysis IDHazop-DL-Testing-01
    System/Node Number1
    Deviation Sequence Number1
    Cause Sequence Number1
    Consequence IDConsequence-01
    Consequence Sequence Number1
    MI_IPL_CHECSafeguard Sequence Number 1
    IPL Criteria Is the IPL independent of the initiating cause of the hazardous scenario?
    IPL Criteria Value FALSE
    MI_RISKASSE

    Analysis ID

    Hazop-DL-Testing-01

    System/Node ID

    Node-01

    System/Node Number

    1

    Deviation Sequence Number

    1

    Cause Sequence Number

    1

    Consequence Sequence Number

    1

    Safeguard Sequence Number

    1

    (ENVIRONMENT) Consequence

    1

    (ENVIRONMENT) Probability

    1

    (FINANCIAL) Consequence550
    (FINANCIAL) Maintenance Cost50
    (FINANCIAL) Probability5
    (FINANCIAL) Production Loss500
    (OPERATIONS) Consequence100
    (OPERATIONS) Probability0.1
    (SAFETY) Consequence100
    (SAFETY) Probability0.3
    Note: In the MI_RISKASSE worksheet, when you enter values for both Consequence Sequence Number and Safeguard Sequence Number, the values in the following fields are considered as Mitigated Risk Values, and when you enter a value for only the Consequence Sequence Number, the values in these fields are considered as Unmitigated Risk Values.
    • (ENVIRONMENT) Consequence
    • (ENVIRONMENT) Probability
    • (ENVIRONMENT) Protection Level
    • (FINANCIAL) Consequence
    • (FINANCIAL) Maintenance Cost
    • (FINANCIAL) Probability
    • (FINANCIAL) Production Loss
    • (FINANCIAL) Protection level
    • (OPERATIONS) Consequence
    • (OPERATIONS) Probability
    • (OPERATIONS) Protection Level
    • (SAFETY) Consequence
    • (SAFETY) Probability
  2. Import the data loader worksheet into APM.
  3. Access the Hazards Analysis Overview page.
  4. Select the HAZOP tab, and then select Hazop-DL-Testing-01.

    The Analysis Summary workspace appears, displaying the risk graph. The two Systems/Nodes, Node-01 and Node-02, appear in the left pane.

  5. In the left pane, select Node-01, and then select the Hazards Worksheet tab.

    The Hazards worksheet section appears, displaying the hierarchical structure of the elements in Node-01.

About the Hazards Data Loader Data Model

The following data model illustrates the records that the Data Loader supports.

Note: Equipment and Functional Location records must exist prior to importing data.

About the Hazards Data Loader Workbook Layout and Use

To import Hazards Analysis data, APM provides the data loader workbook (Hazards.xlsx). This workbook supports baseline Hazards Analysis in APM. You can modify the workbook to include custom fields used by your organization.

The following table lists the worksheets that are included in the data loader workbook.

WorksheetDescription
MI_HAZANANAThis worksheet is used to define the Hazards Analysis records.
MI_HAZANNODThis worksheet is used to define Hazards Analysis System/Node records.
Node_AssetsThis worksheet is used to identify Equipment and Functional Location records.
MI_HAZOPDEVThis worksheet is used to define HAZOP Deviation records.
MI_HAZANCAUThis worksheet is used to define Hazards Analysis Cause records.
MI_HAZANCONThis worksheet is used to define Hazards Analysis Consequence records.
MI_HAZANSAFThis worksheet is used to define Hazards Analysis Safeguard records.
MI_IPL_CHECThis worksheet is used to define IPL Checklist records
MI_RISKASSEThis worksheet is used to define Risk Assessment records.
MI_RSKASRECThis worksheet is used to define Risk Assessment Recommendation records.
MI_Human_ResourceThis worksheet is used to define Human Resource records.

Limitations

The Hazards Data Loader has the following limitations:

  • You can import data related to HAZOP Analysis only.
  • You must use the data loader workbook. If you modify the format of the values in columns in any of the worksheets, you will not be able to import data.
  • The values that you enter in the data loader workbook are case-sensitive.

  • If you reimport data, the records that were created by the Hazards Data Loader will be updated. Therefore, while reimporting data related to a record, if you remove the data for a field in the data loader workbook, the value for the corresponding field in APM will be blank.

MI_HAZANANA Worksheet

The MI_HAZANANA worksheet stores the details of the Hazards Analysis records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must be unique. This value identifies the Hazards Analysis.

Site Reference NameMI_SITE_NAMECharacter (50)

This field is required and must match an existing Site name.

Note: If you want to set the site reference to be a Global Site Reference, in the MI_SITE_NAME column on the spreadsheet, enter the constant *Global*.

Unit Description

MI_HAZANANA_UNIT_DESCR_C

Character (255)

None

Unit ID

MI_HAZANANA_UNIT_ID_C

Character (50)

None

Process Type

MI_HAZANANA_PROCE_TYPE_C

Character (50)

None

Process Description

MI_HAZANANA_PROCE_DESCR_T

Text

None

Summary

MI_HAZANANA_SUMMA_T

Text

None

Last Modified By

MI_HAZANANA_LAST_MODIF_BY_C

Character (255)

None

Last Modified Date

MI_HAZANANA_LAST_MODIF_DATE_D

Date

None

State

MI_SM_STATE_ID_C

Character (50)

None

State Owner

MI_SM_STATE_OWNER_ID_C

Character (255)

None

Revision NumberMI_HAZANANA_REVIS_NUMBE_CCharacter (50)None
Revision DateMI_HAZANANA_REVIS_DATE_DDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
MI_SM_STATE_ENTERED_D MI_SM_STATE_ENTERED_DDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Analysis PurposeMI_HAZANANA_ANALY_PURPO_TTextNone
Analysis ScopeMI_HAZANANA_ANALY_SCOPE_TTextNone
Analysis ObjectiveMI_HAZANANA_ANALY_OBJEC_TTextNone
Analysis End DateMI_AN_ANALY_END_DATE_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Analysis Start DateMI_AN_ANALY_START_DATE_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Process Life Cycle PhaseMI_HAZANANA_PROCE_LIFE_CYCLE_CCharacter (255)

By default, in APM system, this field may contain one of the following System Code IDs:

  • Design and Development
  • Construction and Startup
  • Operate and Maintain
  • Decommissioning

The list in this field is populated by the MI_HAZARDS_ANALYSIS_LIFE_CYCLE_PHASE System Code Table. If the system code table has been modified, the valid values could be different. To verify which options are acceptable in your APM system, via Configuration Manager, refer to the MI_HAZARDS_ANALYSIS_LIFE_CYCLE_PHASE System Code Table.

Analysis DescriptionMI_AN_SHORT_DESCR_CHRCharacter (255)None
Is DeletedMI_HAZANANA_IS_DELET_LBooleanEnter TRUE or FALSE.
Reevaluation IntervalMI_HAZANANA_ANALY_REEV_NNumericNone
Analysis Type MI_AN_ANALY_TYPE_CHRCharacter (59)

By default, in APM system, this fields may contain one of the following values:

  • HAZOP
  • What If
Next Reevaluation DateMI_HAZANANA_NEXT_REEVA_DATE_DDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Production Unit KeyMI_ANLY_PROD_UNIT_KEY_NNumericNone
State Key TESTMI_SM_STATE_KEY_NNumericNone
Visual AttributesMI_AN_VISUA_ATTRI_TXCharacterNone

MI_HAZANNOD Worksheet

The MI_HAZANNOD worksheet stores the details of the Hazards Analysis System/Node records.

Field CaptionField IDData Type (Length)Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node IDMI_HAZANNOD_NODE_ID_C

Character (255)

A value is required and must be unique.
System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Systems/Nodes in a Hazards Analysis, then the values in this column for the three Systems/Nodes must be 1, 2, and 3.
Modified ByMI_TST_EQUIP_HIST_DATE_CCharacter (255)

None

Modified DateMI_HAZANNOD_MODIF_BY_CDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Reference DrawingMI_HAZANNOD_MODIF_DATE_DCharacter (255)None
System/Node DescriptionMI_HAZANNOD_REFER_DRAWI_CTextNone
System/Node Equipment TypeMI_HAZANNOD_NODE_DESCR_TCharacter (255)None
System/Node Process TypeMI_HAZANNOD_NODE_EQUIP_TYPE_CCharacter (255)None
System/Node CommentsMI_HAZANNOD_COMME_TTextNone

Node_Assets Worksheet

The Node_Assets worksheet identifies the Equipment and Functional Location records, and links them to each Hazards Analysis.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node IDMI_HAZANNOD_NODE_ID_CCharacter (255)A value is required and must match the ID of a System/Node that exists in APM or one of the values that you enter in the MI_HAZANNOD worksheet.
System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match the value in the System/Node Number field of the System/Node whose ID you have provided in the System/Node ID column.

Equipment Technical Number

MI_EQUIP000_EQUIP_TECH_NBR_C

Character (255)

None

Function Location ID

MI_FNCLOC00_INTERNAL_ID_C

Character (255)

None

MI_HAZOPDEV Worksheet

The MI_HAZOPDEV worksheet stores the details of the HAZOP Deviation records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the System/Node Number field, in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must follow a sequence. For example, if there are three Deviations in a System/Node, then the values in this column for the three Deviations must be 1, 2, and 3.

Deviation/Guideword

MI_HAZOPDEV_DEVIA_C

Character (255)

None

MI_HAZANCAU Worksheet

The MI_HAZANCAU worksheet stores details of the Hazards Analysis Cause records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must follow a sequence. For example, if there are three Causes for a Deviation, then the values in this column for the three Causes must be 1, 2, and 3.

Cause IDMI_HAZANCAU_CAUSE_ID_CCharacter (255)A value is required.
Functional Location IDMI_HAZANCAU_FUNCT_LOCAT_ID_CCharacter (255)None

Equipment Technical Number

MI_EQUIP000_EQUIP_TECH_NBR_C

Character (255)None
Cause CommentMI_HAZANCAU_CAUSE_COMME_TTextNone
Cause DescriptionMI_HAZANCAU_CAUSE_DESCR_TTextNone
Cause TypeMI_HAZANCAU_CAUSE_TYPE_CHRCharacter (100)In the baseline APM system, this cell is the CCPS Cause Type field and may contain is populated by the value in the Initiating Event ID field of the Initiating Event records. The Cause Frequency (per year) field is populated with the default value of frequency specified in the Initiating Event record based on your selection in the CCPS Cause Type field. For more information, refer to the Initiating Events section of the documentation.

MI_HAZANCON Worksheet

The MI_HAZANCON worksheet stores details of the Hazards Analysis Consequence records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZANCAU worksheet.

Consequence IDMI_HAZANCON_CONSE_ID_CCharacter (255)A value is required.
Consequence Sequence NumberMI_HAZANCON_SEQUE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Consequences for a Cause, then the values in this column for the three Consequences must be 1, 2, and 3.
Consequence DescriptionMI_HAZANCON_CONSE_DESCR_TTextNone
Consequence CommentMI_HAZANCON_CONSE_COMME_TTextNone

Consequence Type

MI_HAZANCON_CONSE_TYPE_C

Character (100)

None

MI_HAZANSAF Worksheet

The MI_HAZANSAF worksheet stores details of the Hazards Analysis Safeguard records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZANCAU worksheet.

Consequence Sequence NumberMI_HAZANCON_SEQUE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Consequences for a Cause, then the values in this column for the three Consequences must be 1, 2, and 3.
Safeguard IDMI_HAZANSAF_SAFEG_ID_CCharacter (255)A value is required.
Safeguard Sequence NumberMI_HAZANSAF_SEQUE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Safeguards for a Consequence, then the values in this column for the three Safeguards must be 1, 2, and 3.
Functional Location IDMI_HAZANSAF_FUNCT_LOCAT_ID_CCharacter (255)Enter a value that matches the value in the Functional Location ID field of a Functional Location that exists in the database.

Equipment Technical Number

MI_EQUIP000_EQUIP_TECH_NBR_C

Character (255)Enter a value that matches the value in the Equipment Technical Number field of an Equipment that exists in the database.
Safeguard CommentMI_HAZANSAF_SAFEG_COMME_TCharacterNone
Safeguard TypeMI_HAZANSAF_SAFEG_TYPE_CCharacter (100)None
Safeguard DescriptionMI_HAZANSAF_SAFEG_DESCR_TTextNone
IF IDMI_HAZANSAF_PIF_ID_CCharacter (255)You must enter a value that matches the value in the PIF ID field of an Instrumented Function that exists in the database.
Is the IPL independent of the initiating cause of the hazardous scenario?MI_HAZANSAF_IS_IPL_INDEP_LBooleanEnter TRUE or FALSE.
Is the IPL specific in that it has the ability to detect the hazardous scenario?MI_HAZANSAF_IS_IPL_SPCFC_LBooleanEnter TRUE or FALSE.
Is the IPL auditable with applicable industry standard?MI_HAZANSAF_IS_IPL_ADTBL_LBooleanEnter TRUE or FALSE.
Is the IPL capable with respect to its availability?MI_HAZANSAF_IS_IPL_CPBL_LBooleanEnter TRUE or FALSE.
IPL TypeMI_HAZANSAF_IPL_TYPE_CCharacter (50)

In the baseline APM system, this cell may contain one of the following System Code IDs:

  • Consequence Reducing IPL
  • Frequency Reducing IPL

The list in this field is populated by the MI_HAZOP_IPL_TYPE System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your APM system, using Configuration Manager, access and verify with the appropriate System Code table.

IPL CreditsMI_HAZANSAF_IPL_CREDI_NNumericIn the baseline APM system, this cell may contain a value between 1 and 10.
TypeMI_HAZANSAF_TYPE_CCharacter (50)

This field is stored only if the values for all the IPL Criteria associated with the Safeguard is TRUE.

In the baseline APM system, this cell may contain one of the following System Code IDs:

  • Active IPL
  • Passive IPL
  • Human IPL

The list in this field is populated by the MI_IPL_TYPES_SAFEGUARD System Code Table. If the System Code Table has been customized, the valid values could be different. To verify which options are acceptable in your APM system, using Configuration Manager, access and verify with the MI_IPL_TYPES_SAFEGUARD System Code Table.

IPL Sub TypeMI_HAZANSAF_IPL_SUB_TYPE_CCharacter (250)

This field is stored only if the values for all the IPL Criteria associated with the Safeguard is TRUE.

In the baseline APM system, this cell may contain System Codes from one of the following System Code Tables:

  • MI_ACTIVE_IPL System Code table if the value in the IPL Type field is Active IPL.

  • MI_PASSIVE_IPL System Code table if the value in the IPL Type field is Passive IPL.

  • MI_HUMAN_IPL System Code table if the value in the IPL Type field is Human IPL.

To verify which options are acceptable in your APM system, using Configuration Manager, access and verify with the appropriate System Code Table.

PFDMI_HAZANSAF_PFD_NNumeric

This field is stored only if the values for all the IPL Criteria associated with the Safeguard is TRUE.

The default value for the PFD field for each IPL Sub Type is provided in the following records:

  • Active IPL record if the value in the IPL Type field is Active IPL.
  • Passive IPL record if the value in the IPL Type field is Passive IPL.
  • Human IPL record if the value in the IPL Type field is Human IPL.

For more information, refer to the Layers of Protection Analysis section of the documentation.

To verify which value is acceptable in your APM system, using Record Manager, access and verify with the appropriate record. For more information, refer to the Manage Records section of the documentation.

MI_IPL_CHEC Worksheet

The MI_IPL_CHEC worksheet stores details of the IPL Checklist records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZANCAU worksheet.

Consequence Sequence NumberMI_HAZANCON_SEQUE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Consequences for a Cause, then the values in this column for the three Consequences must be 1, 2, and 3.
Safeguard IDMI_HAZANSAF_SAFEG_ID_CCharacter (255)A value is required.
Safeguard Sequence NumberMI_HAZANSAF_SEQUE_NUMBE_NNumericA value is required and must follow a sequence. For example, if there are three Safeguards for a Consequence, then the values in this column for the three Safeguards must be 1, 2, and 3.
IPL CriteriaMI_IPL_CHEC_IPL_CRIT_CCharacter (250)

In the baseline APM system, this cell may contain one of the following values:

  • Is the IPL Independent of the initiating cause of the hazardous scenario?

  • Is the IPL Auditable with applicable industry standard?

  • Is the IPL Specific in that has the ability to detect the hazardous scenario?

  • Is the IPL Capable with respect to its availability?

  • Is the Risk Reduction Factor (RRF) >= 10?

The list in this field is populated by the Asset Safety Preferences records. If the records have been customized, the valid values could be different. To verify which options are acceptable access the administrative settings for LOPA, to view the list of criteria configured in your APM system.

IPL Criteria ValueMI_IPL_CHEC_IPL_CRIT_VALU_FBooleanEnter TRUE or FALSE.

MI_RISKASSE Worksheet

The MI_RISKASSE worksheet stores details of the Risk Assessment records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZANCAU worksheet.

Consequence Sequence NumberMI_HAZANCON_SEQUE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANCON worksheet.
Safeguard Sequence NumberMI_HAZANSAF_SEQUE_NUMBE_NCharacter (10)A value is required and must match one of the values that you enter in the MI_HAZANSAF worksheet.
(ENVIRONMENT) ConsequenceENVIRONMENT|MI_CONSE_NNumericNone
(ENVIRONMENT) ProbabilityENVIRONMENT|MI_PROB_NNumericNone
(ENVIRONMENT) Protection LevelENVIRONMENT|MI_PROT_NNumericNone
(FINANCIAL) ConsequenceFINANCIAL|MI_CONSE_NNumericNone
(FINANCIAL) Maintenance CostFINANCIAL|MI_RISK_MAIN_COST_NNumericNone
(FINANCIAL) ProbabilityFINANCIAL|MI_PROB_NNumericNone
(FINANCIAL) Production LossFINANCIAL|MI_RISK_PROD_LOSS_NNumericNone
(FINANCIAL) Protection levelFINANCIAL|MI_PROT_NNumericNone
(OPERATIONS) consequenceOPERATIONS|MI_CONSE_NNumericNone
(OPERATIONS) ProbabilityOPERATIONS|MI_PROB_NNumericNone
(OPERATIONS) Protection LevelOPERATIONS|MI_PROT_NNumeric

Enter TRUE or FALSE.

(SAFETY) ConsequenceSAFETY|MI_CONSE_NNumericNone
(SAFETY) ProbabilitySAFETY|MI_PROB_NNumericNone

MI_RSKASREC Worksheet

The MI_RSKASREC worksheet stores details of the Risk Assessment Recommendation records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

System/Node NumberMI_HAZANNOD_NODE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANNOD worksheet.

Deviation Sequence Number

MI_HAZOPDEV_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZOPDEV worksheet.

Cause Sequence Number

MI_HAZANCAU_SEQUE_NUMBE_N

Numeric

A value is required and must match one of the values that you enter in the MI_HAZANCAU worksheet.

Consequence Sequence NumberMI_HAZANCON_SEQUE_NUMBE_NNumericA value is required and must match one of the values that you enter in the MI_HAZANCON worksheet.
Recommendation IDMI_REC_IDCharacter (255)A value is required.
Target Completion DateMI_REC_TARGE_COMPL_DATE_DTDateA value is required. Enter the value in the following format: YYYY-MM-DD hh:mm:ss
StatusMI_REC_STATU_CHRCharacter (50)

In the baseline APM system, this cell may contain one of the following System Code IDs:

  • APPROVED
  • CREATED
  • PENDING REVIEW
  • REVIEWED
  • REJECTED
  • CANCELLED
  • SUPERCEDED
  • IN PROGRESS
  • IMPLEMENTED

The list in this field is populated by the MI_STATUS System Code Table. If the system code table has been customized, the valid values could be different. To verify which options are acceptable in your APM system, via Configuration Manager, refer to the appropriate table.

Equipment Technical Number

MI_EQUIP000_EQUIP_TECH_NBR_C

Character (255)None
Days Before Due Date to be NotifiedMI_REC_DAYS_BEF_DUE_DT_NOT_NBRNumericNone
Reevaluate?MI_REC_REEVAL_FLGBooleanEnter TRUE or FALSE.
Reevaluation Notification ListMI_REC_REEVAL_NOTIF_LIST_CHRCharacter (2000)None
Work Request ReferenceMI_REC_WK_REQ_REF_CHRCharacter (50)None
Work Order NumberMI_REC_WORK_ORDER_NUMB_CHRCharacter (50)None
Generate Work RequestMI_REC_WO_INTERFACE_FLAG_FBooleanEnter TRUE or FALSE.
Meridium Task IDMI_REC_WO_INTERFACE_FLAG_FDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Reviewer IDMI_REC_REVIE_CHRCharacter (255)

Enter TRUE or FALSE.

Alert Assignee When Due?MI_REC_NOTIFY_RP_FLGBooleanNone
Reevaluation DateMI_REC_REEVAL_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Implementation Alert TextMI_REC_NOTIF_EMAIL_TEXT_CHRTextNone
Required Equipment StatusMI_REC_REQUI_EQUIP_STATU_CHRCharacter (50)None
Business ImpactMI_REC_IMPAC_CHRCharacter (100)None
Published FlagMI_REC_PUB_FLAG_FBooleanEnter TRUE or FALSE.
Final Approver IDMI_REC_FINAL_APPRO_ID_CCharacter (255)None
Associated ReferenceMI_REC_EVNTREF_CHRCharacter (255)None
Generate Meridium TaskMI_REC_GENERATE_MERID_TASK_FBooleanEnter TRUE or FALSE.
Final Approver NameMI_REC_FINAL_APPROVE_NAME_CCharacter (255)None
Reviewer NameMI_REC_REVIE_NM_CHRCharacterNone
Reevaluation Alert Body TextMI_REC_REEVAL_EMAIL_TXTextNone
Final State LockMI_REC_FINAL_STATE_LOCK_FBooleanEnter TRUE or FALSE.
Completed DateMI_REC_COMPL_DATE_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Recommendation PriorityMI_REC_PRIORITY_CCharacter (50)None
Recommendation DescriptionMI_REC_LONG_DESCR_TXTextNone
Recommendation HeadlineMI_REC_SHORT_DESCR_CHRCharacter (255)None
Frequency of Alert After Due DateMI_REC_NOTIF_AFTER_DD_CHRCharacter (50)None
Recommendation BasisMI_REC_BASISCharacter (255)None
Author LockMI_REC_AUTHOR_LOCK_FBooleanEnter TRUE or FALSE.
Author NameMI_REC_AUTHO_NM_CHRCharacter (255)None
Assigned To NameMI_REC_ASSIG_NM_CHRCharacter (255)None
Author User IDMI_REC_AUTHO_CHRCharacter (255)None
StateMI_SM_STATE_ID_CCharacterNone
Mandatory DateMI_SM_STATE_ID_CDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
State OwnerMI_SM_STATE_OWNER_ID_CCharacterNone
State EnteredMI_SM_STATE_ENTERED_DDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Analysis IDMI_REC_ANALY_ID_CHRCharacter (255)None
Create Work Request?MI_REC_CREATE_SAP_NOTIF_FLGBooleanEnter TRUE or FALSE.
Work Request Functional LocationMI_REC_WR_LOC_CCharacter (255)None
Work Request EquipmentMI_REC_WR_EQUIP_CCharacter (255)None
Notification TypeMI_REC_NOTIF_TYPE_CCharacter (2)None
Assigned To User IDMI_REC_ASSIG_TO_CHRCharacter (255)None
Recommendation TypeMI_REC_TYPE_CHRCharacter (255)None
Completion CommentsMI_REC_CLOSE_COMME_TXTextNone
Functional Location KeyMI_RSKASREC_FUNCT_LOCAT_KEY_NNumericNone
Functional Location IDMI_REC_LOC_ID_CHRCharacter (2000)None
Recommendation Closure DateMI_REC_CLOSE_DATE_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Last Change DateMI_REC_LAST_CHANG_DATE_DTDateEnter a value in the following format: YYYY-MM-DD hh:mm:ss
Last Changed ByMI_REC_LAST_CHANG_BY_CHRCharacter (255)None
Technical NumberMI_REC_TECHNICAL_NUM_CCharacter (50)None
Asset DescriptionMI_REC_ASSET_DESCR_CCharacter (255)None
Action Interval UnitsMI_RSKASREC_INTER_UNITS_CCharacter (50)None
Action IntervalMI_RSKASREC_INTER_UNITS_CNumericNone
State KeyMI_SM_STATE_KEY_NNumericNone

MI_Human_Resource Worksheet

The MI_Human_Resource worksheet stores details of the Human Resource records.

Field Caption

Field ID

Data Type (Length)

Comments

Analysis ID

MI_AN_ANALY_ID_CHR

Character (255)

A value is required and must match one of the values that you enter in the MI_HAZANANA worksheet. Additionally, all the records that are linked to one another must contain the same Analysis ID.

First NameMI_HR_FIRST_NAME_CHRCharacter (255)A value is required.
Last NameMI_HR_LAST_NAME_CHRCharacter (255)A value is required.
Resource IDMI_RES_ID_CHRCharacter (255)A value is required.
Badge IdMI_HR_BADGE_IDCharacter (20)None
Company IdMI_HR_COMPANY_CHRCharacter (255)None
DepartmentMI_HR_DEPT_CHRCharacter (255)None
Address1MI_HR_ADDR1_CHRCharacter (255)None
Address2MI_HR_ADDR2_CHRCharacter (255)None
Area of ResponsibilityMI_HR_AREA_RESPONSIBILITY_TXCharacter (100)None
FacilityMI_HR_AREA_RESPONSIBILITY_TXCharacter (50)None
Business UnitMI_HR_BUSINESS_UNIT_TXCharacter (50)None
DomainMI_HR_DOMAIN_TXCharacter (50)None
CultureMI_HR_CULTURE_IDCharacter (10)None
CityMI_HR_CITY_CHRCharacter (255)None
StateMI_HR_STATE_CHRCharacter (255)None
Postal CodeMI_HR_POSTCODE_CHRCharacter (100)None
CountryMI_HR_COUNTRY_CHRCharacter (50)None
Phone1MI_HR_PHONE1_CHRCharacter (50)None
Phone2MI_HR_PHONE2_CHRCharacter (50)None
FaxMI_HR_FAX_CHRCharacter (50)None
Email AddressMI_HR_EMAIL_TXCharacter (500)None
CommentsMI_HR_COMMENTS_TXTextNone
Available?MI_HR_AVAIL_CHRCharacter (10)None
Site CodeMI_SITE_CD_CHRCharacter (20)None