/
PM_HIVE_DATA Table

PM_HIVE_DATA Table

Sep 04, 2018

  • The PM_HIVE_DATA table contains general information about the hive.

  • The DOMAIN_ID column is expected to be highly unique (at least 20 characters in a random sequence).

 

  • The DOMAIN_ID needs to be unique across multiple enterprises, which is why it should be at least 20 characters in random sequence.


  • The name in the DOMAIN_NAME column represents the hive's domain identifier.

  • Each DOMAIN_ID row contains the DOMAIN_NAME for the hive and the ENVIRONMENT_CD.

  • The ENVIRONMENT_CD can be easily switched by changing the active configuration.


PM_HIVE_DATA

 

 

PK

DOMAIN_ID

varchar(50)

 

ENVIRONMENT_CD

varchar(255)

 

DOMAIN_NAME

varchar(255)

 

HELPURL

varchar(255)

 

ACTIVE

int



The enumerated values that represent the environment are:

Value

Description

PRODUCTION

The operational system that is used by all i2b2 users. This environment contains actual / real data.

TEST

A testing or "staging" environment. Used for testing changes before they are moved to production. The data may or may not be real.

DEVELOPMENT

The development environment is used for developing and upgrading the systems. Only test data resides in this environment.

STOPPED

Temporarily down.

INACTIVE

Undefined down period.

ARCHIVED

Not active, not anticipated to be restarted in the future.