Post Processing SQL Scripts

By using this optional step it is possible to change the Staging area after the generation. This can be valuable in several use cases, for example:

• If the Staging area should only contain a subset of the IMSMA^NG database e.g. only Land with status Closed
• If sensitive data (e.g. victim names and addresses) should not be included in the Staging area
• If data has to be processed for reporting purposes e.g. complex calculations of square meters
• If it would facilitate reporting to concatenate fields e.g. victim family and given names
• If it would facilitate to add fields from other items e.g. Accident date to Victim table
• If additional database SQL views are necessary, also for reporting and analysis purposes

If you would like to use Ordnance data, link items and/or use multi-select fields then you need to create SQL views.

{{Note | Contact your GICHD IM advisor for help in developing SQL statements according to specific requirements.