Databases Reference
In-Depth Information
temporal foreign key. So the foreign key declaration is dropped
from the DDL, the client number column is also dropped,
and a
client_oid
column replaces it. With these changes, the
temporalization of this table is complete.
The Policy Amendment Table
. According to the Table Type
metadata table, the Policy Amendment table is an asserted
version table. Prior to temporalization, the primary key of this
table was
policy_amend_nbr
. From this column we derive the
name
policy_amend_oid
for the first column in the bi-temporal
primary key. We then add effective begin date and assertion
begin date as the other two primary key columns. Policy amend-
ment number itself is designated as the business key of this
table, and appears in it as a non-key column. Policy amendment
text is left unchanged. Episode begin date, effective end date,
assertion end date and row create date are added as non-key
columns. As before, unique constraints and indexes are aug-
mented and are modified, as required.
Policy_nbr
appears in the logical data model as a foreign key
to the Policy table, and so the AVF must convert it into a
temporal foreign key. So the foreign key declaration is dropped
from the DDL, the policy number column is also dropped,
and a
policy_oid
column replaces it. With these changes, the
temporalization of this table is complete.
The Wellness Program Category Table
. According to the
Table Type metadata table, the Wellness Program Category table
is an asserted version table. Prior to temporalization, the primary
key of this table was
wellpgmcat_cd
. From this column we derive
the name
wellpgmcat_oid
for the first column in the bi-temporal
primary key. We then add effective begin date and assertion
begin date as the other two primary key columns. Wellness pro-
gram category code itself is designated as the business key of
this table, and appears in it as a non-key column. Wellness pro-
gram category name is left unchanged. Episode begin date,
effective end date, assertion end date and row create date are
added as non-key columns. As before, unique constraints and
indexes are augmented and are modified, as required. With these
changes, the temporalization of this table is complete.
The Wellness Program Table
. According to the Table Type
metadata table, the Wellness Program table is an asserted ver-
sion table. Prior to temporalization, the primary key of this table
was
wellpgm_nbr
. From this column we derive the name
wellpgm_oid
for the first column in the bi-temporal primary
key. We then add effective begin date and assertion begin date
as the other two primary key columns. Wellness program num-
ber itself is designated as the business key of this table, and
