From CaisisWiki

Revision as of 16:18, 5 October 2011 (view source) Avinash (Talk | contribs) (→Important Notes) ← Older edit		Current revision as of 14:08, 30 April 2013 (view source) Avinash (Talk | contribs) (→Table Attributes)
(One intermediate revision not shown)
Line 76:		Line 76:
	====MenuOrder====		====MenuOrder====
		+
		+	====RelatedRecordUtility====
		+	True or False controlling if the Related Records utility shows up on this form.
		+
		+	====RelatedRecordTable====
		+	True or false controlling if a table shows up as a relatable table in the Related Records utility.
		+
		+	===Technical===
		+	====Database Table Metadata====
		+	=====Main Tables=====
		+	#MetadataTables
		+	#MetadataTableAttributes
		+	#MetadataTableAttributeValues
		+	=====Auxiliary Tables=====
		+	#Diseases
		+	#DiseaseAttributes
		+	#DiseaseAttributeValues
		+
		+	=====Query All Table Metadata=====
		+	<code>
		+
		+	</code>
		+	====Business Object Table Metadata====
	== Field Metadata ==		== Field Metadata ==

---

Current revision as of 14:08, 30 April 2013

Contents 1 Background 1.1 Table Metadata 1.1.1 Important Notes 1.1.2 Table Attributes 1.1.2.1 Table Label 1.1.2.2 Table Description 1.1.2.3 Form 1.1.2.4 NumDisplayColumns 1.1.2.5 LoadByDefault 1.1.2.6 DisplayWithParent 1.1.2.7 DisplayWithChild 1.1.2.8 GridView 1.1.2.9 TotalBlankGridRows 1.1.2.10 TotalVisibleBlankGridRows 1.1.2.11 FileName 1.1.2.12 MostRelevantTables 1.1.2.13 DisplayInMainMenu 1.1.2.14 ChronListOption 1.1.2.15 ChronListText 1.1.2.16 AllowAbsentEvent 1.1.2.17 ProtocolMgmtTopLevelTable 1.1.2.18 UseInWorkflows 1.1.2.19 Menu 1.1.2.20 MenuOrder 1.1.2.21 RelatedRecordUtility 1.1.2.22 RelatedRecordTable 1.1.3 Technical 1.1.3.1 Database Table Metadata 1.1.3.1.1 Main Tables 1.1.3.1.2 Auxiliary Tables 1.1.3.1.3 Query All Table Metadata 1.1.3.2 Business Object Table Metadata 1.2 Field Metadata 1.2.1 Important Notes 1.2.2 Field Attributes 1.3 Lookup Codes

Background

Metadata is a general term used to describe application specific information, which are related to tables, fields and interface, but do not disrupt the integrity of the database structure.

Table Metadata

Table level metadata is information related to database tables which represents application specific attributes describing the table. These mappings are superficial and do not modify the database structure, keys, relationships, etc... Such examples include Table Label, Table Description, Relevant Diseases, etc... which are used to describe a table's role in the application.

The following table attributes are used to add metadata to tables across multiple diseases.

The attributes are always inherited from the GENERAL metadata view, where applicable. (i.e., In PROSTATE View, TableLabel for Encounters inherited from GENERAL view, where no Prostate mapping exists).

However, this is not true in the inverse (i.e., Attribute Values from disease views aren't inherited by the GENERAL View).

Important Notes

Previous iterations of Caisis mapped information about MetadataTable were in the table columns FieldLabel and FieldDescription. These columns have become deprecated and this information is now stored as Table Attribute Values, allowing for multiple Table Labels across diseases.

Table Attributes

Table Label

The friendly table label (default: actual TableName), i.e., EncExams = Physical Exams.

IMPORTANT: Main label used to display in menus, page headings, and where applicable.

Table Description

The friendly table description (default: empty string).

Form

True or False (default) indicating whether a table is a data entry form.

NumDisplayColumns

The number (default: 2) of columns in which to display the data entry form.

LoadByDefault

True or False (default) indicating whether the form is loaded as the default form in the Data Entry section.

DisplayWithParent

True or False (default) whether a form is displayed with it's parent table. i.e., Physical Exams displays with parent Encounter.

DisplayWithChild

A list (comma separated) of child tables names to display with form. i.e., Encounter displays with Physical Exams and Review Of Systems.

GridView

True of False (default) indicating if a form is displayed as tabular data (grid).

TotalBlankGridRows

If GridView=true, controls the number of blank rows to allocate for the form.

TotalVisibleBlankGridRows

If GridView=true, controls the number of blank rows initially visible.

FileName

The static file name (optional) of the custom data entry form (.ascx).

MostRelevantTables

A list (comma separated) of sibling tables.

DisplayInMainMenu

True (default) or False indicating whether a table's menu will display in the Data Entry Menus.

ChronListOption

The name of the chron list stored proc item.

ChronListText

The displayable text column of the chron list stored proc item.

AllowAbsentEvent

True or False (default) indicating whether the Table allows Absent Events.

ProtocolMgmtTopLevelTable

True or False (default) indicating whether the table will be used in the Protocol Manager.

UseInWorkflows

True or False (default) indicating whether the table will be used in the Workflow Builder.

Menu

The name of the top level menu where to place the form. i.e., Diagnostics > Lab Tests

MenuOrder

RelatedRecordUtility

True or False controlling if the Related Records utility shows up on this form.

RelatedRecordTable

True or false controlling if a table shows up as a relatable table in the Related Records utility.

Technical

Database Table Metadata

Main Tables

1. MetadataTables
2. MetadataTableAttributes
3. MetadataTableAttributeValues

Auxiliary Tables

1. Diseases
2. DiseaseAttributes
3. DiseaseAttributeValues

Query All Table Metadata

Business Object Table Metadata

Field Metadata

Similar to table metadata, field level metadata is information related to database fields, not the database structure or integrity. These mappings allow the application to have specific attributes related to a field, such as Field Label, Lookup Code, Control Type, etc...

Important Notes

Previous iterations of Caisis mapped information about MetadataFields were in the table columns FieldOrder and FieldSuppress. These columns have become deprecated and this information is now stored as Field Attribute Values, allowing for various ordering and field suppression across tables.

Field Attributes

Lookup Codes

Lookup Codes are vocabulary items which are used through the system to provide reuse and uniformity across the application. They are used for restricting data entry values for a consistent range of values. These are often there to aid in data entry, but often do not restrict values outside the range.