Data Dictionary - Revision history

Alnaucler at 11:49, 16 April 2018

2018-04-16T11:49:13Z

← Older revision		Revision as of 13:49, 16 April 2018
Line 12:		Line 12:
	* Linked IDs.		* 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 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 maXML schema is described [[XML Documentation \| here]].

Alnaucler at 09:12, 17 June 2017

2017-06-17T09:12:30Z

← Older revision		Revision as of 11:12, 17 June 2017
Line 2:		Line 2:
	{{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 \| 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.		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.

Alnaucler at 08:59, 17 June 2017

2017-06-17T08:59:30Z

← Older revision		Revision as of 10:59, 17 June 2017
Line 7:		Line 7:
	and has the ambition to cover both user groups' needs.		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 or if you would need technical documentation of the maXML schema.
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 18:30, 7 May 2017

2017-05-07T18:30:00Z

← Older revision		Revision as of 20:30, 7 May 2017
Line 9:		Line 9:
	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 not described here. Contact your [[Information Management Team \| GICHD IM advisor]] if you have questions about tables.		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 or if you would need technical documentation of the maXML schema.
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 16:52, 10 August 2016

2016-08-10T16:52:34Z

← Older revision		Revision as of 18:52, 10 August 2016
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 user groups:

Alnaucler at 15:43, 17 June 2016

2016-06-17T15:43:40Z

← Older revision		Revision as of 17:43, 17 June 2016
Line 5:		Line 5:
	* administrators		* administrators
	and has the ambition to cover both user groups' needs.		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.

	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.		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]]

Alnaucler at 19:27, 16 March 2016

2016-03-16T19:27:15Z

← Older revision		Revision as of 21:27, 16 March 2016
Line 6:		Line 6:
	and has the ambition to cover both user groups' needs.		and has the ambition to cover both user groups' needs.

			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.
	~~</div>~~
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 19:24, 16 March 2016

2016-03-16T19:24:25Z

← Older revision		Revision as of 21:24, 16 March 2016
Line 6:		Line 6:
	and has the ambition to cover both user groups' needs.		and has the ambition to cover both user groups' needs.

	~~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>		</div>
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 19:21, 16 March 2016

2016-03-16T19:21:29Z

← Older revision		Revision as of 21:21, 16 March 2016
Line 1:		Line 1:
	{{~~Under construction~~ \| ~~There has been some progress~~ and ~~the Data Dictionary is about 50% done~~.}}		{{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.}}
			{{Note \| [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}
	The Data Dictionary has two user groups:		The Data Dictionary has two user groups:
	* non-technical users		* non-technical users
Line 6:		Line 6:
	and has the ambition to cover both user groups' needs.		and has the ambition to cover both user groups' needs.

	~~The {{IMSMANG}} database consists of three main groups of tables:~~
	* Items
	** Approved information a.k.a. Item / Summary / CV tables
	** Data Entry Forms a.k.a. infoversion tables
	** Tables that belongs to both groups
	* Task and Auxiliary Data
	* Miscellaneous tables
	** Data Inventory Manager and templates tables
	** Migration tables
	** System tables

	~~{{Note \| [''italic''] will highlight something technical such as {{IMSMANG}} database table name.}}~~
	The data type used are		The data type used are
	* Country structure		<div style="column-count:2;-moz-column-count:2;-webkit-column-count:2">
			* Boolean
			* Double
			* ''Country structure''
	* Date		* Date
	* Integer		* Integer
	* Multi-select (are stored in a separate table ''xx_has_imsmaenum''. and use the look-up table ''imsmaenum'')		* Multi-select (are stored in a separate table ''xx_has_imsmaenum'' and use the look-up table ''imsmaenum'')
	* Numeric (may have decimals)		* Numeric (may have decimals)
	* Organisation		* ''Organisation''
	* Place		* ''Place''
	* Single-select (use the look-up table ''imsmaenum'')		* Single-select (use the look-up table ''imsmaenum'')
	* String (have maximum length)		* String (have maximum length)
	* Text (no maximum length)		* Text (no maximum length)
	~~{{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.}}~~		</div>
	{{NavBox Data Dictionary}}		{{NavBox Data Dictionary}}
	[[Category:NAA]]		[[Category:NAA]]

Alnaucler at 14:54, 15 March 2016

2016-03-15T14:54:55Z

← Older revision		Revision as of 16:54, 15 March 2016
Line 1:		Line 1:
	{{Under construction \| ~~The~~ Data Dictionary is ~~quite an ambitious task and it will take time until more than 1000 fields and 200 tables will be documented~~}}		{{Under construction \| There has been some progress and the Data Dictionary is about 50% done.}}

	The Data Dictionary has two user groups:		The Data Dictionary has two user groups: