Changes

Jump to: navigation, search

Data Dictionary

294 bytes added, 13:49, 16 April 2018
no edit summary
{{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.}}
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 has they are therefore not included in the ambition to cover both user groupsData 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 ' needs''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 data type used are
<div style="column-count:2;-moz-column-count:2;-webkit-column-count:2">
* Boolean
* Double
* ''Country structure''
* Date
* Integer
* Multi-select (are stored in a separate table ''xx_has_imsmaenum'' and use the look-up table ''imsmaenum'')
* Numeric (may have decimals)
* ''Organisation''
* ''Place''
* Single-select (use the look-up table ''imsmaenum'')
* String (have maximum length)
* Text (no maximum length)
</div>
{{NavBox Data Dictionary}}
[[Category:NAA]]
6,632
edits

Navigation menu