Act Data Dictionary

The Conceptual Act Data Dictionary expressed in ADO.NET tables.

Physical Table	Conceptual Entity	Description
act_tbl	Act	This table is used to store the non-versioned aspects of an act. These are things that are not supposed to change over the lifespan of an act
act_vrsn_tbl	Act (Versions)	This table is used to store the versioned portions of an act. The version sequence column should be a sequence which increments for each tuple (at minimum) or each new version of an object (best option)
act_id_tbl	Act Identifiers	This is an associative table which is used to store identifiers by which an act is referenced externally.
act_ext_tbl	Act Extensions	Extensions table.
act_proto_tbl	Act Protocols	Act protocol implementation table.
act_ptcpt_tbl	Act Participation	Act participation table (links acts to entities)
act_tag	Act Tags	Act tags table
act_ext_tbl	Act Extensions	Act extensions table (value should be a binary array or BLOB)
act_note_tbl	Act Notes	Act notes
act_pol_assoc_tbl	Act Policies	Policies which apply to the act.
act_rel_tbl	Act Relationships	Relationships table. Note that effective/obsolete sequence columns refer to the source act.
sub_adm_tbl	Substance Administrations	Substance administration child table which is linked directly to the act table.
obs_tbl	Observation	Observation child table which is linked to the act table.
qty_obs_tbl	Quantity Observations	Quantity Observation table which is linked with the observation table.
txt_obs_tbl	Text Observations	Text observations table which is linked with the observation table.
cd_obs_tbl	Coded Observations	Coded observations table which is linked to the observation table.
pat_enc_tbl	Patient Encounters	Patient encounters table which is linked to the act table.
proc_tbl	Procedures	Procedures tablet which is linked to the act table.