https://wiki.catglobe.com/index.php?action=history&feed=atom&title=Column%3A_CATI_contact_duplicate_record
Column: CATI contact duplicate record - Revision history
2026-04-20T11:48:25Z
Revision history for this page on the wiki
MediaWiki 1.43.0
https://wiki.catglobe.com/index.php?title=Column:_CATI_contact_duplicate_record&diff=18336&oldid=prev
Cg huyphong at 04:49, 26 April 2011
2011-04-26T04:49:19Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 04:49, 26 April 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<del style="font-weight: bold; text-decoration: none;">HelpBooks</del>]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>[[Category:<ins style="font-weight: bold; text-decoration: none;">Resource data caches</ins>]]</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l38">Line 38:</td>
<td colspan="2" class="diff-lineno">Line 38:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The axis generated for this column will look like below:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The axis generated for this column will look like below:</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Axis text: "CATI contact duplicate record"Math base: "CATIContactDuplicateRecord"Pct base: "CATIContactDuplicateRecord!=empty"</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Axis text: "CATI contact duplicate record"</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><br></ins>Math base: "CATIContactDuplicateRecord"</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><br></ins>Pct base: "CATIContactDuplicateRecord!=empty"</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Option 1: Name="False"; Value="!CATIContactDuplicateRecord"Option 2: Name="True"; Value="CATIContactDuplicateRecord"</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Option 1: Name="False"; Value="!CATIContactDuplicateRecord"</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><br></ins>Option 2: Name="True"; Value="CATIContactDuplicateRecord"</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|- align="left" valign="top"</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|- align="left" valign="top"</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |</div></td></tr>
<tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l49">Line 49:</td>
<td colspan="2" class="diff-lineno">Line 52:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=(count() where (interviewer == 12345) &amp;&amp; (CATIContactDuplicated== FALSE) &amp;&amp; (id==567800))</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=(count() where (interviewer == 12345) &amp;&amp; (CATIContactDuplicated== FALSE) &amp;&amp; (id==567800))</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">Back to: [[ Column: CATI contact ]]</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">__NOTOC__</del></div></td><td colspan="2" class="diff-side-added"></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><!-- imported from file: 7865.htm--></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><!-- imported from file: 7865.htm--></div></td></tr>
<!-- diff cache key wiki:diff:1.41:old-15667:rev-18336:php=table -->
</table>
Cg huyphong
https://wiki.catglobe.com/index.php?title=Column:_CATI_contact_duplicate_record&diff=15667&oldid=prev
Catglobe: jrfconvert import
2011-03-07T08:58:22Z
<p>jrfconvert import</p>
<p><b>New page</b></p><div>[[Category:HelpBooks]]<br />
<br />
<br />
===Column: CATI contact duplicate record===<br />
<br />
{| class="tableintopic" style="border-collapse: collapse; border: 1px solid #010101" width="1067" border="1" cellpadding="2"<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Column<br />
| style="border: 1px solid #010101" width="839" |<br />
CATI contact duplicate record<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Source<br />
| style="border: 1px solid #010101" width="839" |<br />
This column will be set to true for the first instance of the same CATI contact 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 a CATI contact record was called multiple times (more CATI contacts for the same answer sheet) then the CATI contact record information will be copied multiple times foranswer sheet contact log record.<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Automatically given column name<br />
| style="border: 1px solid #010101" width="839" |<br />
CATIContactDuplicateRecord<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Column type<br />
| style="border: 1px solid #010101" width="839" |<br />
Boolean<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Resource types that use it<br />
| style="border: 1px solid #010101" width="839" |<br />
Questionnaire<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
How axis set information is built<br />
| style="border: 1px solid #010101" width="839" |<br />
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.<br />
<br />
The axis generated for this column will look like below:<br />
<br />
Axis text: "CATI contact duplicate record"Math base: "CATIContactDuplicateRecord"Pct base: "CATIContactDuplicateRecord!=empty"<br />
<br />
Option 1: Name="False"; Value="!CATIContactDuplicateRecord"Option 2: Name="True"; Value="CATIContactDuplicateRecord"<br />
|- align="left" valign="top"<br />
| style="border: 1px solid #010101" width="228" bgcolor="#FFC20E" |<br />
Comment<br />
| style="border: 1px solid #010101" width="839" |<br />
As a CATI contact log record can occur in more than one data row this column helps you “SELECT DISTINCT” CATI contact records in a resource cache, so for example the following expression will return the number of CATI contacts which a specific interviewer already did for a specific CATI questionnaire.<br />
<br />
=(count() where (interviewer == 12345) &amp;&amp; (CATIContactDuplicated== FALSE) &amp;&amp; (id==567800))<br />
<br />
Back to: [[ Column: CATI contact ]]<br />
__NOTOC__<br />
<!-- imported from file: 7865.htm--></div>
Catglobe