Data Dictionary

The Data Dictionary has two user groups:

• non-technical users
• administrators

and has the ambition to cover both user groups' needs.

The IMSMA^NG 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

[italic] will highlight something technical such as IMSMANG database table name.

The data type used are

• 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)

The length of the fields may vary between migrated from Legacy databases and databases that were created with IMSMANG of version 5 or newer.