Fieldreport ID and Dates - Revision history

Alnaucler: Alnaucler moved page Fieldreport Dates to Fieldreport ID and Dates without leaving a redirect

2016-11-12T21:10:16Z

Alnaucler moved page Fieldreport Dates to Fieldreport ID and Dates without leaving a redirect

← Older revision	Revision as of 23:10, 12 November 2016
(No difference)

Alnaucler at 21:09, 12 November 2016

2016-11-12T21:09:17Z

← Older revision		Revision as of 23:09, 12 November 2016
Line 1:		Line 1:
			{{Warning \| The dates may have been set in a non-chronological / illogical way by migration / import scripts due to misunderstanding of the meaning of the dates / no Mine Action knowledge.}}
	{\|		{\|
	\|- valign="top"		\|- valign="top"

Alnaucler at 23:12, 11 November 2016

2016-11-11T23:12:21Z

← Older revision		Revision as of 01:12, 12 November 2016
Line 1:		Line 1:
	~~{{Under construction\| }}~~
	{\|		{\|
	\|- valign="top"		\|- valign="top"
Line 23:		Line 22:
	\| Approved Date		\| Approved Date
	\| Approved by		\| Approved by
	\| ''Last updated''		\| ''Last updated date''
	\|-		\|-
	\| '''GUI'''		\| '''GUI'''
Line 38:		Line 37:
	(either using button or typing)		(either using button or typing)
	\| Entered in DEF (Age of Information)		\| Entered in DEF (Age of Information)
	(there are no checks in the code that this date is before the ~~others~~)		(there are no checks in the code that this date is before the other)
	\| Clicking on Save		\| Clicking on Save
	(might be NULL if DEF is imported)		(might be NULL if DEF is imported)
Line 62:		Line 61:
	\| <span style="color:#ff0000"><b> <big>Mandatory</big> </b></span>		\| <span style="color:#ff0000"><b> <big>Mandatory</big> </b></span>
	\| Good to have		\| Good to have
	\| ~~Nice to have~~		\| Not necessary (depends on permission configuration)
	\| '''Should have'''		\| '''Should have'''
	\| '''Should have'''		\| '''Should have'''
Line 68:		Line 67:
	\|-		\|-
	\| '''Error'''		\| '''Error'''
	\|		\| [[Empty Reconciliation Tab#Case 2 The tab is highlighted and no error message in the log \| Reconciliation tab will be empty]]
	\| [[Not Possible to Unapprove]]		\| [[Not Possible to Unapprove]]
	\|		\|
	\|		\|
	\|		\| Should have been fixed in the upgrade
	\|		\| Should have been fixed in the upgrade
	\|		\|
	\|}		\|}

	<span style="color:#ff0000"><b>* Never ever</b></span> use ''fieldreport.dataentrydate'' for updating anyone of the above because that is ''Last Updated'' which e.g. changes when the template is switched.		<span style="color:#ff0000"><b>* Never ever</b></span> use ''fieldreport.dataentrydate'' for updating anyone of the above because that is ''Last Updated date'' which e.g. changes when the template is switched.

	{\|		{\|
Line 89:		Line 88:
	\| width="250pt"\| '''MySQL queries'''		\| width="250pt"\| '''MySQL queries'''
	\| width="250pt"\| '''PostgreSQL queries'''		\| width="250pt"\| '''PostgreSQL queries'''
			\|-
			\| Form ID
			\| [[Data quality checks before upgrading to V6.0#Missing Local ID (mandatory) \| Upgrade from 5.08.04 section]]
			\| [[Missing Local ID \| Missing Local ID MySQL]]
			\| [[Missing Local ID PGSQL]]
	\|-		\|-
	\| Date of Information		\| Date of Information
Line 94:		Line 98:
	\| [[Missing Date of Information \| Missing Date of Information MySQL]]		\| [[Missing Date of Information \| Missing Date of Information MySQL]]
	\| [[Missing Date of Information PGSQL]]		\| [[Missing Date of Information PGSQL]]
			\|-
			\| Approval Information
			\| [[Data quality checks before upgrading to V6.0#Missing Approval Information (mandatory) \| Upgrade from 5.08.04 section]]
			\| [[Missing approval information \| Missing approval information MySQL]]
			\| [[Missing approval information PGSQL]]
	\|}		\|}
	{{NavBox Hub}}		{{NavBox Hub}}

	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 05:43, 11 November 2016

2016-11-11T05:43:13Z

← Older revision		Revision as of 07:43, 11 November 2016
Line 79:		Line 79:
	<span style="color:#ff0000"><b>* Never ever</b></span> use ''fieldreport.dataentrydate'' for updating anyone of the above because that is ''Last Updated'' which e.g. changes when the template is switched.		<span style="color:#ff0000"><b>* Never ever</b></span> use ''fieldreport.dataentrydate'' for updating anyone of the above because that is ''Last Updated'' which e.g. changes when the template is switched.

	'''~~Read more~~'''~~<br/>~~		{\|
	''Date of Information~~''<br/>~~		\|- valign="top"
	[[Data quality checks before upgrading to V6.0#Missing Date of Information (mandatory) \| Upgrade from 5.08.04]]~~<br/>~~		\|
	[[Missing Date of Information PGSQL]]~~<br/>~~		{\| class="wikitable"
			! colspan="4" \| Read more
			\|-
			\| width="200pt"\| '''Field'''
			\| width="200pt"\| '''General information'''
			\| width="250pt"\| '''MySQL queries'''
			\| width="250pt"\| '''PostgreSQL queries'''
			\|-
			\| Date of Information
			\| [[Data quality checks before upgrading to V6.0#Missing Date of Information (mandatory) \| Upgrade from 5.08.04 section]]
			\| [[Missing Date of Information \| Missing Date of Information MySQL]]
			\| [[Missing Date of Information PGSQL]]
			\|}
	{{NavBox Hub}}		{{NavBox Hub}}

	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 16:24, 10 November 2016

2016-11-10T16:24:11Z

← Older revision		Revision as of 18:24, 10 November 2016
Line 82:		Line 82:
	''Date of Information''<br/>		''Date of Information''<br/>
	[[Data quality checks before upgrading to V6.0#Missing Date of Information (mandatory) \| Upgrade from 5.08.04]]<br/>		[[Data quality checks before upgrading to V6.0#Missing Date of Information (mandatory) \| Upgrade from 5.08.04]]<br/>
	[[Missing Date of Information]]<br/>		[[Missing Date of Information PGSQL]]<br/>

	{{NavBox Hub}}		{{NavBox Hub}}

	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 16:14, 10 November 2016

2016-11-10T16:14:01Z

← Older revision		Revision as of 18:14, 10 November 2016
Line 58:		Line 58:
	\| 2014-06-19		\| 2014-06-19
	\|-		\|-
	\| '''~~Rule~~'''		\| '''Importance'''
	\| <span style="color:#ff0000"><b> Mandatory </b></span>		\| <span style="color:#ff0000"><b> <big>Mandatory</big> </b></span>
	\| <span style="color:#ff0000"><b> Mandatory </b></span>		\| <span style="color:#ff0000"><b> <big>Mandatory</big> </b></span>
	\| Good to have		\| Good to have
	\| Nice to have		\| Nice to have
	\| '''Should have'''		\| '''Should have'''
	\| '''Should have'''		\| '''Should have'''
	\| ~~What~~-~~ever~~		\| <span style="color:#ff0000">Do '''not''' use for UPDATE<sup>*</sup></span>
			\|-
			\| '''Error'''
			\|
			\| [[Not Possible to Unapprove]]
			\|
			\|
			\|
			\|
			\|
	\|}		\|}

			<span style="color:#ff0000"><b>* Never ever</b></span> use ''fieldreport.dataentrydate'' for updating anyone of the above because that is ''Last Updated'' which e.g. changes when the template is switched.

			'''Read more'''<br/>
			''Date of Information''<br/>
			[[Data quality checks before upgrading to V6.0#Missing Date of Information (mandatory) \| Upgrade from 5.08.04]]<br/>
			[[Missing Date of Information]]<br/>

	{{NavBox Hub}}		{{NavBox Hub}}

	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 10:43, 10 November 2016

2016-11-10T10:43:10Z

← Older revision		Revision as of 12:43, 10 November 2016
Line 59:		Line 59:
	\|-		\|-
	\| '''Rule'''		\| '''Rule'''
	\| Mandatory		\| <span style="color:#ff0000"><b> Mandatory </b></span>
	\| Mandatory		\| <span style="color:#ff0000"><b> Mandatory </b></span>
	\| Good to have		\| Good to have
	\| Nice to have		\| Nice to have
	\| ~~Mandatory~~		\| '''Should have'''
	\| ~~Mandatory~~		\| '''Should have'''
	\| What-ever		\| What-ever
	\|}		\|}

Alnaucler at 10:25, 10 November 2016

2016-11-10T10:25:26Z

← Older revision		Revision as of 12:25, 10 November 2016
Line 5:		Line 5:
	{\| class="wikitable"		{\| class="wikitable"

	! colspan="7" \| ''fieldreport'' table		! colspan="8" \| ''fieldreport'' table
	\|-		\|-
	\| '''Database column'''		\| '''Database column'''
			\| fieldreport_localid
	\| dateofreport		\| dateofreport
	\| reportreceiveddate		\| reportreceiveddate
Line 16:		Line 17:
	\|-		\|-
	\| '''GUI name'''		\| '''GUI name'''
			\| Form ID
	\| Date of Information		\| Date of Information
	\| Data Entry Date		\| Data Entry Date
Line 24:		Line 26:
	\|-		\|-
	\| '''GUI'''		\| '''GUI'''
			\| [[Image:Form ID widget.png\|150px\|center]]
	\| [[Image:Date widget NG.png\|150px\|center]]		\| [[Image:Date widget NG.png\|150px\|center]]
	\| [[Image:Save button.png\|65px\|center]]		\| [[Image:Save button.png\|65px\|center]]
Line 32:		Line 35:
	\|-		\|-
	\| '''GUI Action'''		\| '''GUI Action'''
			\| Entered in DEF
			(either using button or typing)
	\| Entered in DEF (Age of Information)		\| Entered in DEF (Age of Information)
	(there are no checks in the code that this date is before the others)		(there are no checks in the code that this date is before the others)
Line 45:		Line 50:
	\|-		\|-
	\| '''Example'''		\| '''Example'''
			\| DEF-456
	\| 2011-09-11 oldest		\| 2011-09-11 oldest
	\| 2011-10-04		\| 2011-10-04
Line 51:		Line 57:
	\| emma		\| emma
	\| 2014-06-19		\| 2014-06-19
			\|-
			\| '''Rule'''
			\| Mandatory
			\| Mandatory
			\| Good to have
			\| Nice to have
			\| Mandatory
			\| Mandatory
			\| What-ever
	\|}		\|}

Alnaucler at 09:58, 10 November 2016

2016-11-10T09:58:00Z

← Older revision		Revision as of 11:58, 10 November 2016
Line 45:		Line 45:
	\|-		\|-
	\| '''Example'''		\| '''Example'''
	\| 2011-09-11		\| 2011-09-11 oldest
	\| 2011-10-04		\| 2011-10-04
	\| 2011-10-05		\| 2011-10-05
	\| 2011-10-06		\| 2011-10-06 newest
	\| ~~2011-10-06~~		\| emma
	\| 2014-06-19		\| 2014-06-19
	\|}		\|}

Alnaucler at 09:56, 10 November 2016

2016-11-10T09:56:57Z

@@ Line 30: / Line 30: @@
 | [[Image:Approve button.png|75px|center]]
 | [[Image:Last updated date.png|400px|center]]
+|-
 |}