Difference between revisions of "Data Dictionary"

From IMSMA Wiki
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Warning| The length of the fields may vary between migrated from Legacy databases and databases that were created with {{IMSMANG}} of version 5 or newer.}}  
+
{{Warning | Depending on if a database is originally created with 5.x or 6.0 there are differences in Foreign keys' '''CASCADE on delete'''.}}
 +
{{Note | The length of the fields may vary between databases that are migrated from [[Table differences between migrated and non-migrated databases | Legacy databases and databases]] that were created with {{IMSMANG}} of version 5 or newer.}}  
 
{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
 
{{Note | [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
The Data Dictionary has two user groups:
+
The Data Dictionary has two different user groups:
 
* non-technical users
 
* non-technical users
* administrators
+
* administrators.
and has the ambition to cover both user groups' needs.
 
  
There are fields that are shown in the DIM that are of the type calculated fields and they are therefore not included in the Data Dictionary. Examples are: Calculated area, Last updated date and Linked IDs.
+
There are fields that are shown in the DIM that are of the type calculated fields and they are therefore not included in the Data Dictionary.  
 +
Examples are:  
 +
* Calculated area,  
 +
* Last updated date and  
 +
* Linked IDs.
 +
 
 +
The structure is following the layout of the Data Inventory Manager. The {{IMSMANG}} version 6.0 database contains '''205''' tables but not all of them are described here. Contact your  [[Information Management Team | GICHD IM advisor]] if you have questions about tables.
 +
 
 +
The maXML schema is described [[XML Documentation | here]].
  
The structure is following the layout of the Data Inventory Manager. The {{IMSMANG}} version 6.0 database contains 205 tables but not all of them are not described here. Contact your  [[Information Management Team | GICHD IM advisor]] if you have questions about tables.
 
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 12:49, 16 April 2018

Warning.jpg Depending on if a database is originally created with 5.x or 6.0 there are differences in Foreign keys' CASCADE on delete.
Note.jpg The length of the fields may vary between databases that are migrated from Legacy databases and databases that were created with IMSMANG of version 5 or newer.
Note.jpg [italic] will highlight something technical such as IMSMANG database table name.

The Data Dictionary has two different user groups:

  • non-technical users
  • administrators.

There are fields that are shown in the DIM that are of the type calculated fields and they are therefore not included in the Data Dictionary. Examples are:

  • Calculated area,
  • Last updated date and
  • Linked IDs.

The structure is following the layout of the Data Inventory Manager. The IMSMANG version 6.0 database contains 205 tables but not all of them are described here. Contact your GICHD IM advisor if you have questions about tables.

The maXML schema is described here.