Missing approval information: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "SELECT fieldreport.fieldreport_localid, fieldreport.dateofreport AS `Date of Information`, fieldreport.reportreceiveddate AS `Data Entry Date`, fieldreport.reportcompleteddate..."
 
No edit summary
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{TOC right}}
[[Image:Missing approval info.png|800px|center]]
<div align="center">
'' How it should NOT look like''
</div>
Depending on the reason why the approval information is missing there are different combinations:
* only Approval date missing
* only Approved by missing
* both missing.
The solution is of course depending on what is missing. It is '''important''' that the approval information is set and '''only''' rows with workbench status = '''Approved''' are included. 
==Missing approval information ==__NOEDITSECTION__
<pre>
SELECT
SELECT
fieldreport.fieldreport_localid,
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
fieldreport.dataenterer AS `Data enterer`,
fieldreport.dataenterer AS `Data enterer`,
fieldreport.verifiedby AS `Approved by`
imsmaenum.enumvalue
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL)
ORDER BY
`Form ID` ASC
</pre>
 
If you have any output here you need to take action. The queries below help you to identify for which item(s) the rows in the table ''fieldreport'' need to be updated.


=== Accident===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
accidentinfoversion.dataentrydate AS InfoDate,
accidentinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN accidentinfoversion ON accidentinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
accidentinfoversion.link_only = 0
ORDER BY
`Form ID` ASC
</pre>
=== Hazard ===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
hazardinfoversion.dataentrydate AS InfoDate,
hazardinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN hazardinfoversion ON fieldreport.fieldreport_guid = hazardinfoversion.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
hazardinfoversion.link_only = 0
</pre>
=== Hazard Reducation===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
hazreducinfoversion.dataentrydate AS InfoDate,
hazreducinfoversion.dataenterer AS InfoEnterer
FROM
FROM
fieldreport
fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN hazreducinfoversion ON fieldreport.fieldreport_guid = hazreducinfoversion.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
hazreducinfoversion.link_only = 0
</pre>
=== Location===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
locationinfoversion.dataentrydate AS InfoDate,
locationinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN locationinfoversion ON locationinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
locationinfoversion.link_only = 0
ORDER BY
`Form ID` ASC
</pre>
=== MRE===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
mreinfoversion.dataentrydate AS InfoDate,
mreinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN mreinfoversion ON mreinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
mreinfoversion.link_only = 0
ORDER BY
`Form ID` ASC
</pre>
=== QM===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
qainfoversion.dataentrydate AS InfoDate,
qainfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN qainfoversion ON qainfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
qainfoversion.link_only = 0
ORDER BY
`Form ID` ASC
</pre>
=== Victim===__NOEDITSECTION__
<pre>
SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
victiminfoversion.dataentrydate AS InfoDate,
victiminfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN victiminfoversion ON victiminfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
victiminfoversion.link_only = 0
ORDER BY
`Form ID` ASC
</pre>


== Example update query==__NOEDITSECTION__
<pre>
UPDATE fieldreport
INNER JOIN imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
INNER JOIN hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
SET
fieldreport.reportverifieddate = fieldreport.reportreceiveddate
WHERE
WHERE
workbench_status.enumvalue = 'Approved' AND
workbench_status.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.reportverifieddate IS NULL AND
fieldreport.verifiedby IS NULL )
fieldreport.verifiedby IS NOT NULL AND
 
hazardinfoversion.link_only = 0 AND
ORDER BY
fieldreport.dateofreport IS NULL AND
fieldreport.fieldreport_localid ASC
fieldreport.reportreceiveddate > hazardinfoversion.dataentrydate


UPDATE fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
SET
fieldreport.verifiedby = fieldreport.dataenterer
WHERE
workbench_status.enumvalue = 'Approved' AND
fieldreport.dataenterer IS NOT NULL AND
fieldreport.verifiedby IS NULL
</pre>
[[Category:NoPublic]]
[[Category:NoPublic]]
[[Category:SQL Queries]]
{{NavBox Upgrade}}

Latest revision as of 22:21, 5 December 2016

How it should NOT look like

Depending on the reason why the approval information is missing there are different combinations:

  • only Approval date missing
  • only Approved by missing
  • both missing.

The solution is of course depending on what is missing. It is important that the approval information is set and only rows with workbench status = Approved are included.

Missing approval information

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
fieldreport.dataenterer AS `Data enterer`,
imsmaenum.enumvalue
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL)
ORDER BY
`Form ID` ASC

If you have any output here you need to take action. The queries below help you to identify for which item(s) the rows in the table fieldreport need to be updated.

Accident

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
accidentinfoversion.dataentrydate AS InfoDate,
accidentinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN accidentinfoversion ON accidentinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
accidentinfoversion.link_only = 0
ORDER BY
`Form ID` ASC

Hazard

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
hazardinfoversion.dataentrydate AS InfoDate,
hazardinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN hazardinfoversion ON fieldreport.fieldreport_guid = hazardinfoversion.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
hazardinfoversion.link_only = 0

Hazard Reducation

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
hazreducinfoversion.dataentrydate AS InfoDate,
hazreducinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN hazreducinfoversion ON fieldreport.fieldreport_guid = hazreducinfoversion.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
hazreducinfoversion.link_only = 0

Location

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
locationinfoversion.dataentrydate AS InfoDate,
locationinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN locationinfoversion ON locationinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
locationinfoversion.link_only = 0
ORDER BY
`Form ID` ASC

MRE

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
mreinfoversion.dataentrydate AS InfoDate,
mreinfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN mreinfoversion ON mreinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
mreinfoversion.link_only = 0
ORDER BY
`Form ID` ASC

QM

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
qainfoversion.dataentrydate AS InfoDate,
qainfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN qainfoversion ON qainfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
qainfoversion.link_only = 0
ORDER BY
`Form ID` ASC

Victim

SELECT
fieldreport.fieldreport_localid AS `Form ID`,
fieldreport.dateofreport AS `Date of Information`,
fieldreport.reportreceiveddate AS `Data Entry Date`,
fieldreport.reportcompleteddate AS `Submitted Date`,
fieldreport.reportverifieddate AS `Approved Date`,
fieldreport.verifiedby AS `Approved by`,
imsmaenum.enumvalue,
fieldreport.dataentrydate AS `FR Data date`,
fieldreport.dataenterer AS `FR Data enterer`,
victiminfoversion.dataentrydate AS InfoDate,
victiminfoversion.dataenterer AS InfoEnterer
FROM
fieldreport
INNER JOIN imsmaenum ON imsmaenum.imsmaenum_guid = fieldreport.workbenchstatusenum_guid
INNER JOIN victiminfoversion ON victiminfoversion.fieldreport_guid = fieldreport.fieldreport_guid
WHERE
imsmaenum.enumvalue = 'Approved' AND
(fieldreport.reportverifieddate IS NULL OR
fieldreport.verifiedby IS NULL) AND
victiminfoversion.link_only = 0
ORDER BY
`Form ID` ASC

Example update query

UPDATE fieldreport
INNER JOIN imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
INNER JOIN hazardinfoversion ON hazardinfoversion.fieldreport_guid = fieldreport.fieldreport_guid
SET
fieldreport.reportverifieddate = fieldreport.reportreceiveddate
WHERE
workbench_status.enumvalue = 'Approved' AND
fieldreport.reportverifieddate IS NULL AND
fieldreport.verifiedby IS NOT NULL AND
hazardinfoversion.link_only = 0 AND
fieldreport.dateofreport IS NULL AND 
fieldreport.reportreceiveddate > hazardinfoversion.dataentrydate

UPDATE fieldreport
Inner Join imsmaenum AS workbench_status ON (workbench_status.imsmaenum_guid = fieldreport.workbenchstatusenum_guid)
SET
fieldreport.verifiedby = fieldreport.dataenterer 
WHERE
workbench_status.enumvalue = 'Approved' AND
fieldreport.dataenterer IS NOT NULL AND
fieldreport.verifiedby IS NULL

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|}}{{#if:Upgrade Process|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=
}}{{#if:IMSMA Hub|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:IMSMA Hub|}}}}{{#if:{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=
{{{above}}}
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:missing approval information 
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}|{{#if:IMSMA Hub|
{{{imageleft}}}
Upgrade Process
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=
}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:missing approval information 
|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}
}}}}}}
{{{image}}}
}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:missing approval information 

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:|{{{group2}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list2}}}

}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:missing approval information 

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if:|{{{group3}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list3}}}

}}{{#if:|{{#if:|{{{group4}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list4}}}

}}{{#if:|{{#if:|{{{group5}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list5}}}

}}{{#if:|{{#if:|{{{group6}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list6}}}

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:IMSMA Hub{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#if:|{{#if:|<th scope="col" style="border-left:2px solid #fdfdfd;width:100%;|}}{{#if:|{{#if:|}}}}{{#if:IMSMA3 script changes 6.0|{{#if:|}}{{#if:|}}{{#if:{{#if:Implementation plan|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|}}}}{{#if:Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|{{#if:IMSMA3 script changes 6.0|}}{{#if:{{#if:Data quality checks before upgrading to V6.0|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Locale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA Process|}}{{#if:{{#if:Upgrade from 5.08.04 to 6.0 process|}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group4}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group5}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group6}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group7}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group8}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group9}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group10}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group11}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group12}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group13}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group14}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group15}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group16}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group17}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group18}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group19}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:{{#if:|
{{{group20}}}
}}|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:|{{#if:IMSMA3 script changes 6.0Space coordinates · MGRS coordinates · Coordinate display rules · Point ID Length · Location point · Missing approval information · Missing Date of Information · Missing Local ID · SQL Templates · DIM Categories · Enum categories and values · Duplicate Enumvalue SQL · Translations · CDF display format · CDF missing in field · Duplicate CDF · Multi-select CDFs · CDF not used · Empty CDF · Duplicate allow value · Link invalid date · Attachment SQL · Country structure orphans · Country structure duplicates · Unknown device Accident · Update isactive · Data QA - Duplicates · Data QA - No geo data · Data QA - No links · Data QA - Different Locations · Data QA - Task · Data QA - MA ProcessLocale Pre-check SQL · Used DEF template SQL · Imsmaenum Duplicate fix · Imsmaenum Duplicate fix Part 2 · Inactive enumvalue fix · Translation Duplicate fix · Check Detection Sample Sector VegetationRemoval · Check coordinates distance and bearing  · Upgrade Category Error · Upgrade iReports to 6.0|}}}}
{{#if:Implementation plan|}}
{{#if:Data quality checks before upgrading to V6.0|}}
{{#if:Upgrade from 5.08.04 to 6.0 process|}}
{{#if:|
{{{group4}}}
}}
{{#if:|
{{{group5}}}
}}
{{#if:|
{{{group6}}}
}}
{{#if:|
{{{group7}}}
}}
{{#if:|
{{{group8}}}
}}
{{#if:|
{{{group9}}}
}}
{{#if:|
{{{group10}}}
}}
{{#if:|
{{{group11}}}
}}
{{#if:|
{{{group12}}}
}}
{{#if:|
{{{group13}}}
}}
{{#if:|
{{{group14}}}
}}
{{#if:|
{{{group15}}}
}}
{{#if:|
{{{group16}}}
}}
{{#if:|
{{{group17}}}
}}
{{#if:|
{{{group18}}}
}}
{{#if:|
{{{group19}}}
}}
{{#if:|
{{{group20}}}
}}
{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=
|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:missing approval information 

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:missing approval information 
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

Retrieved from "http://mwiki.gichd.org/IM/index.php?title=Missing_approval_information&oldid=22481"