Governance artifacts reporting tables

Check the Postgres, Db2 statements for the tables that are related to governance artifacts.

Subject area Table name Description
Governance artifacts governance_artifacts The governance artifacts that are defined in the system that are in the published state.
Governance artifacts governance_artifact_stewards A list of stewards that are assigned to a published artifact.
Governance artifacts governance_artifact_associations The relationships between the governance artifacts.
Governance artifacts artifact_tags The tags that are associated with an artifact.
Governance artifacts business_term_abbreviations Abbreviations assigned to business term artifacts (of type glossary_term).

governance_artifacts table

This table contains information about the governance artifacts that are defined in the system that are in the published state.

This table has the following columns:

  • artifact_id - The identifier of the artifact.
  • version_id - The version identifier of the artifact.
  • artifact_type - The type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.
  • name - The name of the artifact.
  • description - The description of the artifact.
  • created_by - The identifier of the user that created the artifact.
  • created_on - The timestamp when the artifact was created.
  • modified_by - The identifier of the user that last modified the artifact
  • modified_on - The timestamp when the artifact was last modified.
  • primary_category_id - The identifier of the primary category of the artifact.
  • workflow_id - The identifier of the workflow configuration that was used to publish the artifact.
  • effective_start_date - The effective start date that is assigned to the artifact.
  • effective_end_date - The effective end date that is assigned to the artifact.
  • system_id - The system identifier or global identifier of the associated governance artifact.
  • rds_values_total_counts - The count of reference data values for reference data artifact type.

Postgres

CREATE TABLE statement:

CREATE TABLE "globalschema".governance_artifacts(
  artifact_id varchar(128) NOT NULL,
  version_id varchar(128) NOT NULL,
  artifact_type varchar(128) NOT NULL,
  name varchar(256) NOT NULL,
  description text,
  created_on timestamp(6) NOT NULL,
  created_by varchar(128) NOT NULL,
  modified_on timestamp(6),
  modified_by varchar(128),
  primary_category_id varchar(128) NOT NULL,
  effective_start timestamp(6),
  effective_end timestamp(6),
  system_id varchar(128) DEFAULT '' NOT NULL,
  rds_values_total_counts bigint DEFAULT 0 NOT NULL,
  tech_start TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tech_end TIMESTAMP(6) NOT NULL DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD'),
  ts_id TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(artifact_id)
)

CREATE INDEX statement:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE statement:

alter table governance_artifacts add constraint fk_governance_artifacts_categories_21 foreign key (primary_category_id) references categories(category_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

CREATE TABLE "globalschema".governance_artifacts(
  artifact_id varchar(128) NOT NULL,
  version_id varchar(128) NOT NULL,
  artifact_type varchar(128) NOT NULL,
  name varchar(256) NOT NULL,
  description text,
  created_on timestamp(6) NOT NULL,
  created_by varchar(128) NOT NULL,
  modified_on timestamp(6),
  modified_by varchar(128),
  primary_category_id varchar(128) NOT NULL,
  effective_start timestamp(6),
  effective_end timestamp(6),
  system_id varchar(128) DEFAULT '' NOT NULL,
  rds_values_total_counts bigint DEFAULT 0 NOT NULL,
  tech_start TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tech_end TIMESTAMP(6) NOT NULL DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD'),
  ts_id TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(artifact_id)
)

CREATE INDEX statement:

create index idx_governance_artifacts_1 on
governance_artifacts (artifact_type)

ALTER TABLE statement:

ALTER TABLE governance_artifacts ADD CONSTRAINT fk_governance_artifacts_categories_21 FOREIGN KEY (primary_category_id) REFERENCES categories(category_id) ON DELETE CASCADE  ON UPDATE NO ACTION


MS SQL Server

CREATE TABLE statement:

CREATE TABLE "globalschema".governance_artifacts(
  artifact_id varchar(128) NOT NULL,
  version_id varchar(128) NOT NULL,
  artifact_type varchar(128) NOT NULL,
  name varchar(256) NOT NULL,
  description varchar(MAX),
  created_on DATETIME2 NOT NULL,
  created_by varchar(128) NOT NULL,
  modified_on DATETIME2,
  modified_by varchar(128),
  primary_category_id varchar(128) NOT NULL,
  effective_start DATETIME2,
  effective_end DATETIME2,
  system_id varchar(128) DEFAULT '' NOT NULL,
  rds_values_total_counts bigint DEFAULT 0 NOT NULL,
  tech_start DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
  tech_end DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
  ts_id DATETIME2 DEFAULT CURRENT_TIMESTAMP NOT NULL,
  CONSTRAINT PK_governance_artifacts_globalschema PRIMARY KEY(artifact_id),
  PERIOD FOR SYSTEM_TIME (tech_start, tech_end)
) WITH (
  SYSTEM_VERSIONING = ON (
    HISTORY_TABLE = "globalschema".hist_governance_artifacts
  )
)


governance_artifact_stewards table

This table contains a list of stewards that are assigned to a published artifact.

This table has the following columns:

  • artifact_id - The identifier of the artifact.
  • user_id - The identifier of the user that is assigned as a steward.

Postgres

CREATE TABLE statement:

create table governance_artifact_stewards(artifact_id varchar(128) not null,
user_id varchar(128) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(artifact_id,
user_id));

ALTER TABLE statement:

alter table governance_artifact_stewards add constraint fk_governance_artifact_stewards_governance_artifacts_3 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table governance_artifact_stewards(artifact_id varchar(128) not null,
user_id varchar(128) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(artifact_id,
user_id),
period SYSTEM_TIME (tech_start,
tech_end) )

ALTER TABLE statement:

alter table governance_artifact_stewards add constraint fk_governance_artifact_stewards_governance_artifacts_3 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action

governance_artifact_associations table

This table contains information about the relationships between the governance artifacts.

This table has the following columns:

  • end1_artifact_id - The identifier of the source artifact.
  • end2_artifact_id - The identifier of the target artifact.
  • end1_artifact_type - The type of the source artifact.
  • end2_artifact_type - The type of the target artifact.
  • relationship_type - The relationship type.

Postgres

CREATE TABLE statement:

create table governance_artifact_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
end1_artifact_type varchar(128) not null,
end2_artifact_type varchar(128) not null,
cr_definition_id varchar(128),
reverse_relationship_type varchar(256),
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(end1_artifact_id,
end2_artifact_id,
relationship_type))

ALTER TABLE statement:

alter table governance_artifact_associations add constraint fk_governance_artifact_associations_glossary_custom_relationship_def_8 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table governance_artifact_associations(end1_artifact_id varchar(128) not null,
end2_artifact_id varchar(128) not null,
relationship_type varchar(256) not null,
end1_artifact_type varchar(128) not null,
end2_artifact_type varchar(128) not null,
cr_definition_id varchar(128),
reverse_relationship_type varchar(256),
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(end1_artifact_id,
end2_artifact_id,
relationship_type),
period SYSTEM_TIME (tech_start,
tech_end) ) ORGANIZE by row

ALTER TABLE statement:

alter table governance_artifact_associations add constraint fk_governance_artifact_associations_glossary_custom_relationship_def_8 foreign key (cr_definition_id) references glossary_custom_relationship_def(cr_definition_id) on
delete
	cascade on
	update
	no action

artifact_tags table

This table contains information about the tags that are associated with an artifact.

This table has the following columns:

  • tag_name - The name of the associated tag.
  • artifact_id - The identifier of the artifact.
  • artifact_type - The type of the artifact, for example glossary_term, classification, data_class, reference_data, rule, or policy.

Postgres

CREATE TABLE statement:

create table artifact_tags(tag_name varchar(256) not null,
artifact_id varchar(128) not null,
artifact_type varchar(128) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(tag_name,
artifact_id));

ALTER TABLE statements:

alter table artifact_tags add constraint fk_artifact_tags_governance_artifacts_24 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action
alter table artifact_tags add constraint fk_artifact_tags_tags_26 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action


Db2

CREATE TABLE statement:

create table artifact_tags(tag_name varchar(256) not null,
artifact_id varchar(128) not null,
artifact_type varchar(128) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(tag_name,
artifact_id),
period SYSTEM_TIME (tech_start,
tech_end) )

ALTER TABLE statements:

alter table artifact_tags add constraint fk_artifact_tags_governance_artifacts_24 foreign key (artifact_id) references governance_artifacts(artifact_id) on
delete
	cascade on
	update
	no action
alter table artifact_tags add constraint fk_artifact_tags_tags_26 foreign key (tag_name) references tags(tag_name) on
delete
	cascade on
	update
	no action

business_term_abbreviations table

This table contains information about abbreviations assigned to business term artifacts (artifacts of type glossary_term).

This table has the following columns:

  • artifact_id - The identifier of the glossary_term (business term) artifact.
  • abbreviation - The abbreviation of the artifact.

Postgres

CREATE TABLE statement:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation varchar(128) NOT NULL,
  tech_start TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tech_end TIMESTAMP(6) NOT NULL DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD'),
  ts_id TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(artifact_id, abbreviation)
)



Db2

CREATE TABLE statement:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation varchar(128) NOT NULL,
  tech_start TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  tech_end TIMESTAMP(6) NOT NULL DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD'),
  ts_id TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(artifact_id, abbreviation)
)


MS SQL Server

CREATE TABLE statement:

CREATE TABLE "globalschema".business_term_abbreviations(
  artifact_id varchar(128) NOT NULL,
  abbreviation varchar(128) NOT NULL,
  tech_start DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
  tech_end DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
  ts_id DATETIME2 DEFAULT CURRENT_TIMESTAMP NOT NULL,
  CONSTRAINT PK_business_term_abbreviations_globalschema PRIMARY KEY(artifact_id, abbreviation),
  PERIOD FOR SYSTEM_TIME (tech_start, tech_end)
) WITH (
  SYSTEM_VERSIONING = ON (
    HISTORY_TABLE = "globalschema".hist_business_term_abbreviations
  )
)


Learn more

Parent topic: Reporting tables