NoPublic, bureaucrat, administrator
1,068
edits
Changes
→Structure of the IMSMA Staging Area
==Structure of the IMSMA Staging Area==
===Flattening principles===
The generation of the staging area follows the following principles, for all the tables:
* Standard text, numeric, and any single-select attribute values (known as '''imsmaenum''') are stored directly in the main table
** Example:
* CDF text, numeric, and any single-select attribute values are stored directly in the main table.
** Example:
* Standard multi-select attribute values are directly stored in the main table as a comma-separated list '''and''' in a normalised way in the standard multi-select table associated to the object.
** Example:
* CDF multi-select attribute values are directly stored in the main table as a comma-separated list '''and''' in a normalised way in the CDF multi-select table associated to the object.
** Example:
* The guid, localid and name of the location an object is linked to are directly stored in the main object table.
** Example:
* The guid, localid and name of an organization linked to an object are directly stored in the main object table.
** Example:
* The guid, localid and name of classifications (country structure (gazetteer), assistance classification, cause classification and needs assessment classification) associated to an object are directly stored in the main object table. Since a classification can have several levels, there is a placeholder for each level, up to the maximum number of levels. For example, the country structure can have up to seven levels. Therefore, in a main object table like HAZARD, there will the following columns: gazetteer_level1_localid, gazetteer_level1_name, gazetteer_level2_localid, gazetteer_level2_name, ..., gazetteer_level7_localid, gazetteer_level7_name. If in IMSMA only four levels are defined, then the columns for levels five to seven will always be empty.
** Example:
===Main object tables===