Column: Answer sheet duplicate record - Revision history

Nguyentanphong at 04:38, 7 February 2012

2012-02-07T04:38:12Z

← Older revision		Revision as of 04:38, 7 February 2012
Line 2:		Line 2:


	===Column: Answer sheet duplicate record===		=== Column: Answer sheet duplicate record ===

	{\| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101~~" width="1067" border="1" cellpadding="2~~"		{\| width="1067" cellpadding="2" border="1" class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101"
	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Column		Column
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Answer sheet duplicate record		\| width="839" style="border: 1px solid #010101" \|
			Answer sheet duplicate record

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Source		Source
	\| style="border: 1px solid #010101~~" width="839~~" \|
	This column will be set to true for the first instance of the same answer sheet record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when an answer sheet was called multiple times (more CATI contacts for the same answer sheet) then the answer sheet record information will be copied multiple times for each cati contact log record.		\| width="839" style="border: 1px solid #010101" \|
			This column will be set to true for the first instance of the same answer sheet record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when an answer sheet was called multiple times (more CATI contacts for the same answer sheet) then the answer sheet record information will be copied multiple times for each cati contact log record.

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Automatically given column name		Automatically given column name
	\| style="border: 1px solid #010101~~" width="839~~" \|
	AnswerSheetDuplicateRecord		\| width="839" style="border: 1px solid #010101" \|
			AnswerSheetDuplicateRecord

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Column type		Column type
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Boolean		\| width="839" style="border: 1px solid #010101" \|
			Boolean

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Resource types that use it		Resource types that use it
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Questionnaire		\| width="839" style="border: 1px solid #010101" \|
			Questionnaire

	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	How axis set information is built		How axis set information is built
	\| style="border: 1px solid #010101~~" width="839~~" \|
	Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes.		\| width="839" style="border: 1px solid #010101" \|
			Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes.

			The axis generated for this column will look like below:

			Axis text: "Answer sheet duplicate record"

			Math base: "AnswerSheetDuplicateRecord"

			Pct base: "AnswerSheetDuplicateRecord!=empty"

	~~The axis generated for this column will look like below~~:		Option 1: Name="False"; Value="!AnswerSheetDuplicateRecord"

	~~Axis text~~: "~~Answer sheet duplicate record~~"~~Math base: "AnswerSheetDuplicateRecord"Pct base:~~ "AnswerSheetDuplicateRecord~~!=empty~~"		Option 2: Name="True"; Value="AnswerSheetDuplicateRecord"

	~~Option 1: Name="False"; Value="!AnswerSheetDuplicateRecord"Option 2: Name="True"; Value="AnswerSheetDuplicateRecord"~~
	\|- align="left" valign="top"		\|- align="left" valign="top"
	\| ~~style="border: 1px solid #010101"~~ width="228" bgcolor="#FFC20E" \|		\| width="228" bgcolor="#FFC20E" style="border: 1px solid #010101" \|
	Comment		Comment
	\| style="border: 1px solid #010101~~" width="839~~" \|
	As a answer sheet record can occur in more than one data row, this column helps you “SELECT DISTINCT” answer sheet records in a resource cache, so for example the following expression will return the number of times a specific respondent has taken part in the interviews of all questionnaires in QNR resource cache.		\| width="839" style="border: 1px solid #010101" \|
			As a answer sheet record can occur in more than one data row, this column helps you “SELECT DISTINCT” answer sheet records in a resource cache, so for example the following expression will return the number of times a specific respondent has taken part in the interviews of all questionnaires in QNR resource cache.

			=(count() where (respondent == 83861) && (AnswerSheetDuplicated== FALSE) && (id!=empty)) __NOTOC__ <!-- imported from file: 7848.htm-->

	~~=(count() where (respondent == 83861) && (AnswerSheetDuplicated== FALSE) && (id!=empty))~~		\|}
	~~__NOTOC__~~
	~~<!-- imported from file: 7848.htm-->~~

Cg huyphong at 04:42, 26 April 2011

2011-04-26T04:42:51Z

← Older revision		Revision as of 04:42, 26 April 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Resource data caches]]

Catglobe: jrfconvert import

2011-03-07T08:51:20Z

jrfconvert import

New page

[[Category:HelpBooks]]

===Column: Answer sheet duplicate record===

{| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="1067" border="1" cellpadding="2"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column
| style="border: 1px solid #010101" width="839" |
Answer sheet duplicate record
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Source
| style="border: 1px solid #010101" width="839" |
This column will be set to true for the first instance of the same answer sheet record that is added for a resource cache. Should any duplicates be added, then these will be set to false. The reason that duplicates may exist is when an answer sheet was called multiple times (more CATI contacts for the same answer sheet) then the answer sheet record information will be copied multiple times for each cati contact log record.
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Automatically given column name
| style="border: 1px solid #010101" width="839" |
AnswerSheetDuplicateRecord
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Column type
| style="border: 1px solid #010101" width="839" |
Boolean
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Resource types that use it
| style="border: 1px solid #010101" width="839" |
Questionnaire
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
How axis set information is built
| style="border: 1px solid #010101" width="839" |
Since this is a boolean column, then the possible values that can exist in this column are only 0 and 1, which corresponds to "False" and "True". It is therefore easy to create the axis since we have a limited well defined number of outcomes.

The axis generated for this column will look like below:

Axis text: "Answer sheet duplicate record"Math base: "AnswerSheetDuplicateRecord"Pct base: "AnswerSheetDuplicateRecord!=empty"

Option 1: Name="False"; Value="!AnswerSheetDuplicateRecord"Option 2: Name="True"; Value="AnswerSheetDuplicateRecord"
|- align="left" valign="top"
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |
Comment
| style="border: 1px solid #010101" width="839" |
As a answer sheet record can occur in more than one data row, this column helps you “SELECT DISTINCT” answer sheet records in a resource cache, so for example the following expression will return the number of times a specific respondent has taken part in the interviews of all questionnaires in QNR resource cache.

=(count() where (respondent == 83861) && (AnswerSheetDuplicated== FALSE) && (id!=empty))
__NOTOC__