Build logic: CATI contact columns - Revision history

Cg_pham at 09:17, 24 February 2012

2012-02-24T09:17:55Z

← Older revision		Revision as of 09:17, 24 February 2012
Line 23:		Line 23:
	[http://wiki.catglobe.com/index.php/Column:_Respondent_second_business_phone_number Respondent second business phone number]		[http://wiki.catglobe.com/index.php/Column:_Respondent_second_business_phone_number Respondent second business phone number]
	[http://wiki.catglobe.com/index.php/Column:_Sample_rule Sample rule]		[http://wiki.catglobe.com/index.php/Column:_Sample_rule Sample rule]
	[~~http~~:~~//wiki.catglobe.com/index.php/Answer_sheet_status~~ Answer sheet status]		[[Column:_Answer_sheet_status\|Answer sheet status]]

	CATI contact columns		CATI contact columns

Cg_pham at 09:17, 6 January 2012

2012-01-06T09:17:33Z

← Older revision		Revision as of 09:17, 6 January 2012
Line 37:		Line 37:
	[http://wiki.catglobe.com/index.php/Column:_Interviewer_first_name Interviewer first name]		[http://wiki.catglobe.com/index.php/Column:_Interviewer_first_name Interviewer first name]
	[http://wiki.catglobe.com/index.php/Column:_Interviewer_middle_name Interviewer middle name]		[http://wiki.catglobe.com/index.php/Column:_Interviewer_middle_name Interviewer middle name]
	Interviewer last name		[http://wiki.catglobe.com/index.php/Column:_Interviewer_last_name Interviewer last name]
	CATI contact description		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_description CATI contact description]
	Outcome status		[http://wiki.catglobe.com/index.php/Column:_Outcome_status Outcome status]
	Outcome status as text		[http://wiki.catglobe.com/index.php/Column:_Outcome_status_as_text Outcome status as text]
	Outcome type		[http://wiki.catglobe.com/index.php/Column:_Outcome_type Outcome type]
	CATI contact copied		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_copied CATI contact copied]

	Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.		Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.

Cg_pham at 09:13, 6 January 2012

2012-01-06T09:13:12Z

← Older revision		Revision as of 09:13, 6 January 2012
Line 27:		Line 27:
	CATI contact columns		CATI contact columns

	CATI contact id		[http://wiki.catglobe.com/index.php/Column:_CATI_contact CATI contact id]
	CATI contact duplicate record		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_duplicate_record CATI contact duplicate record]
	CATI contact start time		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_start_time CATI contact start time]
	CATI contact end time		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_end_time CATI contact end time]
	CATI contact duration		[http://wiki.catglobe.com/index.php/Column:_CATI_contact_duration CATI contact duration]
	Interviewer		[http://wiki.catglobe.com/index.php/Column:_Interviewer Interviewer]
	Interviewer resource id		[http://wiki.catglobe.com/index.php/Column:_Interviewer_resource_Id Interviewer resource id]
	Interviewer full name		[http://wiki.catglobe.com/index.php/Column:_Interviewer_full_name Interviewer full name]
	Interviewer first name		[http://wiki.catglobe.com/index.php/Column:_Interviewer_first_name Interviewer first name]
	Interviewer middle name		[http://wiki.catglobe.com/index.php/Column:_Interviewer_middle_name Interviewer middle name]
	Interviewer last name		Interviewer last name
	CATI contact description		CATI contact description

Cg_pham at 09:05, 6 January 2012

2012-01-06T09:05:11Z

← Older revision		Revision as of 09:05, 6 January 2012
Line 7:		Line 7:
	Answer sheet columns		Answer sheet columns

	[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_Id Answer sheet id]		[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_Id Answer sheet id]
	[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_duplicate_record Answer sheet duplicate record]		[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_duplicate_record Answer sheet duplicate record]
	[http://wiki.catglobe.com/index.php/Column:_Respondent Respondent]		[http://wiki.catglobe.com/index.php/Column:_Respondent Respondent]
	[http://wiki.catglobe.com/index.php/Column:_Respondent_resource_id Respondent resource id]		[http://wiki.catglobe.com/index.php/Column:_Respondent_resource_id Respondent resource id]
	Respondent full name		[http://wiki.catglobe.com/index.php/Column:_Respondent_full_name Respondent full name]
	Respondent first name		[http://wiki.catglobe.com/index.php/Column:_Respondent_first_name Respondent first name]
	Respondent middle name		[http://wiki.catglobe.com/index.php/Column:_Respondent_middle_name Respondent middle name]
	Respondent last name		[http://wiki.catglobe.com/index.php/Column:_Respondent_last_name Respondent last name]
	Respondent unidentified phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_unidentified_phone_number Respondent unidentified phone number]
	Respondent first home phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_first_home_phone_number Respondent first home phone number]
	Respondent second home phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_first_home_phone_number Respondent second home phone number]
	Respondent first mobile phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_first_mobile_phone_number Respondent first mobile phone number]
	Respondent second mobile phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_second_mobile_phone_number Respondent second mobile phone number]
	Respondent first business phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_first_business_phone_number Respondent first business phone number]
	Respondent second business phone number		[http://wiki.catglobe.com/index.php/Column:_Respondent_second_business_phone_number Respondent second business phone number]
	Sample rule		[http://wiki.catglobe.com/index.php/Column:_Sample_rule Sample rule]
	Answer sheet status		[http://wiki.catglobe.com/index.php/Answer_sheet_status Answer sheet status]

	CATI contact columns		CATI contact columns

Cg_pham at 08:57, 6 January 2012

2012-01-06T08:57:39Z

← Older revision		Revision as of 08:57, 6 January 2012
Line 1:		Line 1:
	~~[[Category:Resource data caches]]~~
	=== Build logic: CATI contact columns ===		=== Build logic: CATI contact columns ===

Line 8:		Line 7:
	Answer sheet columns		Answer sheet columns

	Answer sheet id		[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_Id Answer sheet id]
	Answer sheet duplicate record		[http://wiki.catglobe.com/index.php/Column:_Answer_sheet_duplicate_record Answer sheet duplicate record]
	Respondent		[http://wiki.catglobe.com/index.php/Column:_Respondent Respondent]
	Respondent resource id		[http://wiki.catglobe.com/index.php/Column:_Respondent_resource_id Respondent resource id]
	Respondent full name		Respondent full name
	Respondent first name		Respondent first name
	Respondent middle name		Respondent middle name
	Respondent last name		Respondent last name
	Respondent unidentified phone number		Respondent unidentified phone number
	Respondent first home phone number		Respondent first home phone number
	Respondent second home phone number		Respondent second home phone number
	Respondent first mobile phone number		Respondent first mobile phone number
	Respondent second mobile phone number		Respondent second mobile phone number
	Respondent first business phone number		Respondent first business phone number
	Respondent second business phone number		Respondent second business phone number
	Sample rule		Sample rule
	Answer sheet status		Answer sheet status

	CATI contact columns		CATI contact columns

	CATI contact id		CATI contact id
	CATI contact duplicate record		CATI contact duplicate record
	CATI contact start time		CATI contact start time
	CATI contact end time		CATI contact end time
	CATI contact duration		CATI contact duration
	Interviewer		Interviewer
	Interviewer resource id		Interviewer resource id
	Interviewer full name		Interviewer full name
	Interviewer first name		Interviewer first name
	Interviewer middle name		Interviewer middle name
	Interviewer last name		Interviewer last name
	CATI contact description		CATI contact description
	Outcome status		Outcome status
	Outcome status as text		Outcome status as text
	Outcome type		Outcome type
	CATI contact copied		CATI contact copied

	Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.		Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.
Line 57:		Line 56:
	Now, with the same number of included resources, we have 14 rows rather than only one as before. The reason is that it needs to show information from 13 answer sheets that exist in it; and for each answer sheet it needs to show anywhere between 0 and 2 CATI contact records depending on how many CATI calls where made in regards to the answer sheet (as you can see it was only for answer sheet with id 6532 and 6527 that CATI calls were made -- 6527 had 2 calls done for it).		Now, with the same number of included resources, we have 14 rows rather than only one as before. The reason is that it needs to show information from 13 answer sheets that exist in it; and for each answer sheet it needs to show anywhere between 0 and 2 CATI contact records depending on how many CATI calls where made in regards to the answer sheet (as you can see it was only for answer sheet with id 6532 and 6527 that CATI calls were made -- 6527 had 2 calls done for it).

	It is therefore important to understand which data relates to answer sheet and CATI contact columns and which relate to the questionnaire. CATI contact columns will always only be shown once in a resource cache, whereas answer sheets and questionnaires may be shown multiple times if the questionnaire has more than one of each.		It is therefore important to understand which data relates to answer sheet and CATI contact columns and which relate to the questionnaire. CATI contact columns will always only be shown once in a resource cache, whereas answer sheets and questionnaires may be shown multiple times if the questionnaire has more than one of each.

			[[Category:Resource_data_caches]]

Cg_pham at 03:40, 3 January 2012

2012-01-03T03:40:37Z

← Older revision		Revision as of 03:40, 3 January 2012
Line 1:		Line 1:
			[[Category:Resource data caches]]
	=== Build logic: CATI contact columns ===		=== Build logic: CATI contact columns ===

Cg_pham at 03:39, 3 January 2012

2012-01-03T03:39:00Z

← Older revision		Revision as of 03:39, 3 January 2012
Line 7:		Line 7:
	Answer sheet columns		Answer sheet columns

	Answer sheet id		Answer sheet id
	Answer sheet duplicate record		Answer sheet duplicate record
	Respondent		Respondent
	Respondent resource id		Respondent resource id
	Respondent full name		Respondent full name
	Respondent first name		Respondent first name
	Respondent middle name		Respondent middle name
	Respondent last name		Respondent last name
	Respondent unidentified phone number		Respondent unidentified phone number
	Respondent first home phone number		Respondent first home phone number
	Respondent second home phone number		Respondent second home phone number
	Respondent first mobile phone number		Respondent first mobile phone number
	Respondent second mobile phone number		Respondent second mobile phone number
	Respondent first business phone number		Respondent first business phone number
	Respondent second business phone number		Respondent second business phone number
	Sample rule		Sample rule
	Answer sheet status		Answer sheet status

	CATI contact columns		CATI contact columns

	CATI contact id		CATI contact id
	CATI contact duplicate record		CATI contact duplicate record
	CATI contact start time		CATI contact start time
	CATI contact end time		CATI contact end time
	CATI contact duration		CATI contact duration
	Interviewer		Interviewer
	Interviewer resource id		Interviewer resource id
	Interviewer full name		Interviewer full name
	Interviewer first name		Interviewer first name
	Interviewer middle name		Interviewer middle name
	Interviewer last name		Interviewer last name
	CATI contact description		CATI contact description
	Outcome status		Outcome status
	Outcome status as text		Outcome status as text
	Outcome type		Outcome type
	CATI contact copied		CATI contact copied

	Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.		Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.
Line 52:		Line 52:
	Now let us try to add the 'Answer sheet Id' (from answer sheet generating the ResourceProjectQuestionnaireId column) and 'CATI contact Id' (from CATI contact generating CatiContactId column) columns and see what will happen.		Now let us try to add the 'Answer sheet Id' (from answer sheet generating the ResourceProjectQuestionnaireId column) and 'CATI contact Id' (from CATI contact generating CatiContactId column) columns and see what will happen.

	[[Image:7884.png]]		[[Image:7884.png]]

	Now, with the same number of included resources, we have 14 rows rather than only one as before. The reason is that it needs to show information from 13 answer sheets that exist in it; and for each answer sheet it needs to show anywhere between 0 and 2 CATI contact records depending on how many CATI calls where made in regards to the answer sheet (as you can see it was only for answer sheet with id 6532 and 6527 that CATI calls were made -- 6527 had 2 calls done for it).		Now, with the same number of included resources, we have 14 rows rather than only one as before. The reason is that it needs to show information from 13 answer sheets that exist in it; and for each answer sheet it needs to show anywhere between 0 and 2 CATI contact records depending on how many CATI calls where made in regards to the answer sheet (as you can see it was only for answer sheet with id 6532 and 6527 that CATI calls were made -- 6527 had 2 calls done for it).

	It is therefore important to understand which data relates to answer sheet and CATI contact columns and which relate to the questionnaire. CATI contact columns will always only be shown once in a resource cache, whereas answer sheets and questionnaires may be shown multiple times if the questionnaire has more than one of each.		It is therefore important to understand which data relates to answer sheet and CATI contact columns and which relate to the questionnaire. CATI contact columns will always only be shown once in a resource cache, whereas answer sheets and questionnaires may be shown multiple times if the questionnaire has more than one of each.

Cg_pham: Created page with "=== Build logic: CATI contact columns === When we are generating caches for questionnaires it is important that we understand one major difference -- caches may have more than ..."

2012-01-03T03:36:25Z

Created page with "=== Build logic: CATI contact columns === When we are generating caches for questionnaires it is important that we understand one major difference -- caches may have more than ..."

New page

=== Build logic: CATI contact columns ===

When we are generating caches for questionnaires it is important that we understand one major difference -- caches may have more than one row per questionnaire! This will happen when we choose to include columns that take information from the answer sheet or CATI contact records. The number of rows in our cache that an invoice will create will then be one for each CATI contact record that exists in the answer sheet -- and one record for each answer sheet that exists in the questionnaire.

The columns that belong to the CATI contacts and answer sheet info are:

Answer sheet columns

Answer sheet id
Answer sheet duplicate record
Respondent
Respondent resource id
Respondent full name
Respondent first name
Respondent middle name
Respondent last name
Respondent unidentified phone number
Respondent first home phone number
Respondent second home phone number
Respondent first mobile phone number
Respondent second mobile phone number
Respondent first business phone number
Respondent second business phone number
Sample rule
Answer sheet status

CATI contact columns

CATI contact id
CATI contact duplicate record
CATI contact start time
CATI contact end time
CATI contact duration
Interviewer
Interviewer resource id
Interviewer full name
Interviewer first name
Interviewer middle name
Interviewer last name
CATI contact description
Outcome status
Outcome status as text
Outcome type
CATI contact copied

Below is a small example, where we choose to make a resource cache with just ID of one questionnaire resource.

[[Image:7883.png]]<br>

As you will notice, the addition of one questionnaire will create one row in our resource cache, since we have not added any answer sheet or CATI contact columns.

Now let us try to add the 'Answer sheet Id' (from answer sheet generating the ResourceProjectQuestionnaireId column) and 'CATI contact Id' (from CATI contact generating CatiContactId column) columns and see what will happen.

[[Image:7884.png]]

Now, with the same number of included resources, we have 14 rows rather than only one as before. The reason is that it needs to show information from 13 answer sheets that exist in it; and for each answer sheet it needs to show anywhere between 0 and 2 CATI contact records depending on how many CATI calls where made in regards to the answer sheet (as you can see it was only for answer sheet with id 6532 and 6527 that CATI calls were made -- 6527 had 2 calls done for it).

It is therefore important to understand which data relates to answer sheet and CATI contact columns and which relate to the questionnaire. CATI contact columns will always only be shown once in a resource cache, whereas answer sheets and questionnaires may be shown multiple times if the questionnaire has more than one of each.