Revision as of 16:54, 1 December 2015 (view source) Rob Kay (talk | contribs) ← Older edit		Latest revision as of 09:51, 19 February 2025 (view source) Alanconway (talk | contribs) (→‎Extension Database)
(61 intermediate revisions by 6 users not shown)
Line 1:		Line 1:
	[[File:helpheader_small.png|right]]		[[File:helpheader_small.png|right]]
−
−	'''Location in standard build:''' '''''Accessible anywhere a Blue Folder icon is displayed'''''
−
	__TOC__		__TOC__
		+	=Introduction=
		+	The  Blue Folder Lookup page allows you to see the details behind that make up the numbers on a report. For example, if you ask for "number of contacts" using the KPI Report Designer, you will get a total number of contacts; next to the number is a blue folder, which will allow you to see the full details of the contacts counted towards that number. The webinar explains its key functions and additional information is below.
		+	{{#ev:youtube|S-xQsyqFPRQ790}}
−	==About Blue Folder Lookups==	+	In the blue folder you are able to do the following:
−		+	* '''Mail Merge''' - This process will allow sending emails, letters from the system to the people/organisations. You can do this via Charitylog using the ''Preview Mail Merge'' function or ''Generate Spreadsheet'' and export the data into a third party system.
−	You may have already noticed blue folders displayed on reporting outputs. For example, running the "Memberships/Skills Report" shows all of the Organisations/People on your system who belong to/have a [[System_Setup_Guide#Membership.2FSkills_Groups|group or skill]]. The basic output of the report looks something like this:	+	* '''Map View''' - Se the location of the people/organisations on a map.
−		+	* '''Extract the data''' - You are able to extract the data into a spreadsheet for analysis. The extraction can include:
−		+	** Additional fields from the person/organisation record.
−	[[File:reports_7.png|790px|border]]	+	** Additional information linked to the record, like benefits, disabilities, project record, extension databases (bespoke fields) and more.
−		+	** Additional information about the referrals (referral based KPI's), including assessments, extension databases and outcome.
−		+	** Use spread sheet templates that can be used for built in analysis for other members of staff.
−	This output is fine, as long as it contains the information you need, but suppose that you want to cross-reference this output with some other information. The "real world" thought process might go like this -	+	* '''Print''' - Print the summary details that make up the KPI.
−
−	''We ask all of our clients whether they consider themselves computer literate, and we use a skill group called "computers" to log this, putting them in the group if they are computer literate. We also log the disabilities our clients have, if they have any. I wonder what the data would show if I could cross-reference this with the "Computers" group? Does the fact that someone has a disability affect whether they see themselves as computer literate? If it does, does the disability in question matter? A lot of our clients have arthritis - is having arthritis likely to affect your confidence with a computer? Is there anything we can do about this?...'' and so on.
−
−	To answer these questions you could do the following -
−
−	# Run the "Memberships/Skills Report" to see who is in the "Computers" group.
−	# Export this to a spreadsheet.
−	# Look up the relevant clients and their disabilities.
−	# Add these to the spreadsheet.
−
−	Steps 1 and 2 are easy; steps 3 and 4 will take a long time. What you need is an easy way to say to the system, "show me the ouput of this report, and add on the disability data for the relevant clients" - and this is exactly what Blue Folder Lookups allow you to do.
−
−	At the bottom of the reporting output is a blue folder.
−
−
−	[[File:reports_8.png|border]]
−
−
−	Clicking this blue folder will take you to the lookup page.
−
−
−	[[File:reports_9.png|790px|border]]
−
−
−	At the bottom of the page, the data is displayed. At the top, however, we have two extra sections: '''Export Results Through Mailmerge''', and '''Export This Report With Extra Data From'''.
−
−	===Export Results Through Mailmerge===
−
−	This section will allow you to put together the output of your report with a mail merge, which you have previously set up. Mail merges will be covered later in this chapter.
−
−	===Export This Report With Extra Data From===
−
−	This section has two ways to output data: as a spreadsheet, using the "Export This Report" button, or on a map, using the "Switch to Map View" button.
−
−	====Exporting a spreadsheet====
−
−	The basic spreadsheet to be exported will be roughly the same as the original report output. However, by using the Extra Data section, you can add columns onto the spreadsheet with more data in about the relevant clients.
−
−	=====Extra data from a Data Extraction=====
−
−	See later in this guide for details of setting up Data Extractions.
−
−	Once you have a data extraction set up, you can use that data extraction on any reporting output, using this drop-down box. For example, a data extraction has been set up named "EA", which shows the age range and ethnic background of any pool of clients. If you select this data extraction, and click the "Export This Report" button;
−
−
−	[[File:reports_10.png|border]]
−
−
−	The resulting spreadsheet looks like this:
−
−	[[File:reports_11.png|790px|border]]	+	The Blue Folder page is split up into three sections:
		+	* '''Export Options for the Organisations and People in this Report''' This will export the details based on individuals or organisations to either a mail merge or map.  If a person/organisation appears multiple times in the report they will only be exported as one person/organisation.
		+	* '''Export options for this report''' - Allows the Report Data to be exported with additional information for analysis.
		+	* '''The report data''' - Summary details of the report data.
		+	[[File:bluefolderscreen_oct.png]]
−	Not particularly tidy, but very informative. What you have here, after only a few clicks, is a spreadsheet showing:	+	=Export Options for the Organisations and People in this Report=
		+	This section will export the details based on individuals or organisations to either a mail merge or map. If a person/organisation appears multiple times in the report they will only be exported as one person/organisation.
−	* All people that were active in a skill group over a certain date range	+	[[File:BFexportoptions.png]]
−	* The information about the age ranges of those particular people
−	* The information about the ethnic backgrounds of those particular people
−	You can use this spreadsheet to show:	+	==Preview Mail Merge==
		+	The mail merge option is powered by [[Mail_Merge| Mail Merge Formats]] and will use built-in [https://wiki.dizions.co.uk/index.php/Standard_Letter_Templates Letter Templates] to generate the mailings. It allows you to:
		+	* '''Produce a letter''' - This will allow the printing of multiple letters to the recipients.
		+	* '''Produce an Email''' - This will allow the batch of multiple letters to the recipients.  It would be recommended to send no more than 300 (use extra criteria on [[Mail_Merge| Mail Merge Formats]] to filter recipients) at a time and to use your own [[Email Settings| Email Server]].
−	* Whether the people in a particular group are biased towards a particular ethnic background and/or age range	+	To configure a new [[Mail_Merge| Mail Merge Format]] click on the link 'Mail Merge Format', you will need to re-run the report.  If you open up the Mail Merge Format in a new tab you will need to refresh press F5 on the keyboard)  the Blue Folder page once its set up.
−	This kind of information is very useful. For example, consider disability again.	+	Select the mail merge format you wish to use and click the 'Confirm Mail Merge' button.  Depending on the type of format selected you will then be displayed a summary of the options selected on the mail merge and also a preview of the people selected (and excluded). It is important to remember it is only mailing people already selected by the Blue Folder extract.
−	''If the members of the group "Computers" (meaning the person considers themselves to be computer literate) contains no-one with a disability, does that mean that people with disabilities in your funded area are not being supported to access computers? Can your organisation do anything to help, or signpost people to an organisation which can help?''	+	==Generate Spreadsheet==
		+	This function allows you to just extract records and export them into Excel. You can then use a third party product to produce your mailings. You will have to set up an [https://wiki.dizions.co.uk/index.php/Data_Extraction extract] which ensures you have selected the correct records and fields. Once you have selected the correct records using a data extract, you can then click on ''Generate Spreadsheet.''
−	''If the members of the group "Befrienders" are all younger and male, will this have an impact on how many people take up your Befriending service? Is there a need for more female Befrienders, and/or more older Befrienders?''	+	==Preview Batch SMS==
		+	This allows you to send an SMS to people identified on the blue folder extract. You need to set up a [https://wiki.dizions.co.uk/index.php/Batch_SMS Batch SMS] first which can then be applied at the blue folder extract stage. Click on ''Preview Batch SMS'' and it will then display a list of selected records before sending the actual SMS.
−	...and so on. If you are using a paper filing system, and/or each department has its own database, you would not be able to answer these questions without a huge amount of manual data collection, counting and tabulating. Using Charitylog means that you can do this easily, in less than a minute.	+	[[File:BFSMS.png]]
−	=====Extra data from Client-linked Records=====	+	==Map View==
		+	The Map View will pin point the location of each person/organisation on the map.  On the left hand side you will find a list of people/organisations that appear on the map, and below the mapp you will find details of records that are not on the map as they do not have a correct postal code.
−	You also have the option to add data from Client-linked records. Various options are available. Like data extractions, these will simply add more columns on to the output spreadsheet. You can select more than one set of client-linked records by shift-clicking a range (PC or Mac), or holding the "Ctrl" button (PC) or the "Command" button (Mac) and clicking the options you require.	+	On the map you can click a map pin to view the details of the person/organisation and click again to hide the details. You are able to zoom in if required and a full screen option is available. If you want to take a copy you can either take a screen shot or use a snipping tool.
−	=====Extra data from Extension Databases & Extras=====	+	[[File:BF_mapview.png]]
−	Finally, you can add extra data from the Extension Databases you have on your system (providing they are Organisation/Person linked or Personal Tab-linked).	+	Click the 'Close Window' button to return to the report data.
−	====Spreadsheet output size====	+	=Export Options=
		+	The export options allow extraction of the data with the ability of adding additional information for analysis in applications like MS Excel.  This section is broken down into four columns:
−	You can add as many options as you need - there is nothing to stop you using a data extract which gives 20 fields on every result, then adding all the Client-linked records, and all the Extension Database records. However, this will result in an extremely long spreadsheet which is difficult to work with. Consider breaking your requirements down into a series of spreadsheets and then work with these.	+	==Field Sets==
−	Length of spreadsheet output is one of the primary reasons that Charitylog has moved to the .xlsx (Office 2010) output format. The old .xls format only allowed 256 columns, whereas .xlsx allows somewhere over 16,000 (not that you would want or need that many for a Charitylog output).	+	[[File:BFfieldset.png]]
−	===Map View===	+	[[Field Sets]] specify additional fields from the persons/organisations record.  When you select a field set this information will be added to the report data and exported to a spread sheet. [https://wiki.dizions.co.uk/index.php/Field_Sets#Field_Sets click here] for a list of available fields.
−	The Blue Folder Lookup screen also allows an output to be displayed on a map. This has various uses, but all of the most obvious are to do with geographical location - for example;	+	==Add Org/People-linked Records==
		+	You are able to include multiple options from the Org/People linked records, use the CTRL on the keyboard to make the selections.  The available linked records can be selected:
−	* Display all new clients over the last three years, and see where your client base is	+	===Extension Database===
−	* Display all new clients over the last year, and see how new projects have affected your clients' uptake of your services	+	[[Extension Databases]] are groups of bespoke fields that can be added to a records tabs or displayed on the footer of the record.  All available Extension Databases will be displayed, this is determined by the type and security of the Extension Database. Once you have selected the relevant extension database, you can then decide which fields will be exported. You can use the CTRL key to select more than one field.
−	* Display clients accessing a particular service/Project - are there holes in the coverage that cannot be explained? Do you need to make more efforts at outreach in those communities?
−	* Check for incorrectly filled Super Output Areas - are there any outliers displayed that might be wrong?
−	The map view relies on postcodes to place the clients/people, so if there is no postcode entered on their record, the map view will discard them. This is one of the reasons we advise that a name and a postcode should always be a minimum for data capture.	+	===Other org/people-linked records===
		+	This section of the list will allow you to attach the following:
		+	* '''Benefit Details''' - Details of the benefits recorded via the blue link of a record or on the referral outcomes page.  This will include all benefits.
		+	* '''Benefit Values''' - Values of the benefits recorded via the blue link of a record or on the referral outcomes page.  This will include all benefits.
		+	* '''Club and Clinic Attendances''' - Details of Clubs and Clinic attendances for the person/organisation.
		+	* '''Club and Clinic Memberships''' - Columns for all Clubs and Clinics with a Y for each Club/Clinic the person/organisation is a member of.
		+	* '''Consent Options''' - Details of the [[Consent Rule Text Entry| Consent Rules]] recorded on the records.
		+	* '''Courses and Qualifications''' - Details of any courses or qualifications (blue links at the base of the record) that are recorded.
		+	* '''Groups and Skills''' - Which groups and skill have been added via the bl;ue link on the footer of the record.
		+	* '''Full Disability Records''' - Columns for disabilities with a Y for each disability record on the person's/organisation's record.
		+	* '''In Project Records''' - Columns for each project with a Y for each project the person/organisation is in or been in.
		+	* '''NoK and Contacts''' - Details of the Next of Kins and Contacts recorded using the blue link at the footer of the record.
		+	* '''Output Areas and Wards''' - If [[LSOA Areas and Wards]] data has been populated and matched with the post code this will be added to the report data.
		+	* '''Relationships''' - Attaches the relationship type and the related persons name.
		+	* '''Relationships (Full details)''' - Attaches the relationship type and the related persons full details (Name, Contact details and other key fields).
		+	* '''Carer Relationships''' - Attaches the carer relationship type and the carers name.
		+	* '''Carer Relationships (Full details)''' - Attaches the carers relationship type and the carers full details (Name, Contact details and other key fields).
		+	* '''Dependant Relationships''' - Attaches the Cared Fors relationship type and the Cared Fors name (only available on a carer system).
		+	* '''Dependant Relationships (Full details)''' - Attaches the Cared Fors relationship type and the Cared Fors full details (Name, Contact details and other key fields) (only available on a carer system).
		+	* '''Associated People''' - Attaches the names of associated people to an organisation, this is from the blue link on the footer of an organisation based record type.
		+	* '''Associated Organisations''' - Attaches the names of associated organisation to a person, this is from the blue link on the footer of an person based record type.
		+	Multiple selections can be made by holding down the CTRL button on the keyboard.  If you select relationships you will be displayed the option to add additional data to those records as well.
		+	[[File:BFOrg.png]]
−	[[File:reports_13.png|790px|border]]	+	==Add Referral-linked Records==
−	===Gathering the data in in the first place===	+	====Assessment Forms ([[Deprecated Feature]])====
		+	The answers to each question on the assessment forms selected.
−	Look again at the spreadsheet output for the data extraction "EA", which added age range and ethnic group information onto the output of the Memberships/Skills Groups report.	+	====Assessment Scores ([[Deprecated Feature]])====
		+	The scores to each question and section on the assessment forms selected.
		+	====Extension Databases====
		+	[[Extension Databases]] are groups of bespoke fields that can be added to a referral.  All available Extension Databases will be displayed, this is determined by the type and security of the Extension Database. When you select an Extension database you will then be able to choose which fields you want to add to your extract. This means you can select relevant fields rather than the entire extension database.
−	[[File:reports_11.png|790px|border]]	+	====Extra Referral Data====
		+	Referral link records are only available when reporting on referrals or contacts.  Project and person based reports will not show any referral based options.  The follow options can be included on the export:
		+	* '''Extra Referral Data''' - This will include additional details about the referral.
		+	* '''Benefit Details''' - Details of the benefits recorded via the blue link of a record or on the referral outcomes page.  This will include only the benefits attached to the referrals linked to the report data.
		+	* '''Benefit Values''' - Values of the benefits recorded via the blue link of a record or on the referral outcomes page. This will include only benefit values attached to the referrals linked to the report data.
		+	* '''Referral Reasons''' - This will produce a column for each referral reasons and place a Y under the reasons selected on the referral.
		+	* '''Conflict of Interest''' - This will include all Conflict of Interests that have been recorded to any referral linked to the report data.
		+	Multiple selections can be made by holding down the CTRL button on the keyboard.
−	This demonstrates the power available in Charitylog, of being able to get out any data you have on the system, cross-referenced with other data. However, this spreadsheet also shows the most common problem with extracting this data - '''the fact that users fail to enter it in the first place'''. The column for Ethnic Group shows that while a few people in this group have their Ethnic Group recorded on Charitylog, the majority do not.	+	On all of the above it does need consideration to the amount of additional options chosen. If you select too many options this may cause your internet browser to time out or your machine to crash if the spread sheet is too big for the specification of your machine or software.
		+	[[File:BFRef.png]]
−	[[File:reports_12.png|border]]	+	==Spreadsheet Options==
		+	Options in this section affect the output of the spread sheet that is exported.
		+	*Export Header Options
		+	* '''No Titles''' - just the report and options data, no field titles will be included.
		+	* '''1 Title Line (column headings)''' - The report and options data including field names as headers.
		+	* '''Full Titles (includes header with dates etc)''' - Details of the report plus the report and options data including field names as headers.
		+	* '''Where To Export To'''
		+	** '''A blank spreadsheet''' - the data will appear on a newly created spreadsheet.
		+	** '''Uploaded Spreadsheet''' - You will see a list of spreadsheet templates uploaded via [[System Uploads]].  The data will be placed on the worksheet specified by the template.
		+	When you have specified your criteria the spreadsheet will be prepared and presented to open or save (depending on your browser).
−	This is not a problem for the day-to-day running of the service; you might well imagine that a volunteer manager would not want to explicitly ask every volunteer for their age and which ethnic group they consider themselves to be in - if done wrongly, it could look confrontational and unnecessary. However, from the point of view of the chief executive, or the fundraiser, it becomes very important.	+	[[File:BFSpreadsheet.png]]
−	* If your Computer Literacy project is only succeeding in serving people under 40, even though you know from market research that there is a real need for computer tuition for people over 60, is this to do with the people that are delivering the service? Are they all under 25? Does this have a bearing on the clients that are willing to take the service up, bearing in mind that the volunteer tutors have to enter the client's home? Are people who live alone particularly unlikely to take up this service?...	+	=Report Data=
		+	At the bottom of the Blu Folder Lookup page you will see the report data.  If you wish to print this click on the 'Print' button.
−	'''If the age range information has not been input by users in the first place, there is no way to answer, or even ask, these questions.'''	+	When you have finished click on the 'Close Report' Button
−	This is why it's so important that an organisation's data capture (and therefore data protection) policy is well thought out, and communicated to staff. Implementing Charitylog often provides a chance for an organisation to do this for the first time - speak to your Implementation Consultant if you have any questions.	+	=Saving Blue Folder Options=
		+	Once you have established filters on your chosen export, you can instruct the report to remember those options. This means, when you run that particular Blue Folder report in the future, it will extract the same data. Depending on the report which triggered the blue folder, you can then select from relevant options when saving.
		+	[[File:savedbluefolder.png]]
	----		----
	[[File:helpheader_small.png|right]]		[[File:helpheader_small.png|right]]
−	[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 16:53, 1 December 2015 (GMT)	+	[[Category:Reporting]]

---

Latest revision as of 09:51, 19 February 2025

Introduction

The Blue Folder Lookup page allows you to see the details behind that make up the numbers on a report. For example, if you ask for "number of contacts" using the KPI Report Designer, you will get a total number of contacts; next to the number is a blue folder, which will allow you to see the full details of the contacts counted towards that number. The webinar explains its key functions and additional information is below.

In the blue folder you are able to do the following:

• Mail Merge - This process will allow sending emails, letters from the system to the people/organisations. You can do this via Charitylog using the Preview Mail Merge function or Generate Spreadsheet and export the data into a third party system.
• Map View - Se the location of the people/organisations on a map.
• Extract the data - You are able to extract the data into a spreadsheet for analysis. The extraction can include:
  • Additional fields from the person/organisation record.
  • Additional information linked to the record, like benefits, disabilities, project record, extension databases (bespoke fields) and more.
  • Additional information about the referrals (referral based KPI's), including assessments, extension databases and outcome.
  • Use spread sheet templates that can be used for built in analysis for other members of staff.
• Print - Print the summary details that make up the KPI.

The Blue Folder page is split up into three sections:

• Export Options for the Organisations and People in this Report This will export the details based on individuals or organisations to either a mail merge or map. If a person/organisation appears multiple times in the report they will only be exported as one person/organisation.
• Export options for this report - Allows the Report Data to be exported with additional information for analysis.
• The report data - Summary details of the report data.

Export Options for the Organisations and People in this Report

This section will export the details based on individuals or organisations to either a mail merge or map. If a person/organisation appears multiple times in the report they will only be exported as one person/organisation.

Preview Mail Merge

The mail merge option is powered by Mail Merge Formats and will use built-in Letter Templates to generate the mailings. It allows you to:

• Produce a letter - This will allow the printing of multiple letters to the recipients.
• Produce an Email - This will allow the batch of multiple letters to the recipients. It would be recommended to send no more than 300 (use extra criteria on Mail Merge Formats to filter recipients) at a time and to use your own Email Server.

To configure a new Mail Merge Format click on the link 'Mail Merge Format', you will need to re-run the report. If you open up the Mail Merge Format in a new tab you will need to refresh press F5 on the keyboard) the Blue Folder page once its set up.

Select the mail merge format you wish to use and click the 'Confirm Mail Merge' button. Depending on the type of format selected you will then be displayed a summary of the options selected on the mail merge and also a preview of the people selected (and excluded). It is important to remember it is only mailing people already selected by the Blue Folder extract.

Generate Spreadsheet

This function allows you to just extract records and export them into Excel. You can then use a third party product to produce your mailings. You will have to set up an extract which ensures you have selected the correct records and fields. Once you have selected the correct records using a data extract, you can then click on Generate Spreadsheet.

Preview Batch SMS

This allows you to send an SMS to people identified on the blue folder extract. You need to set up a Batch SMS first which can then be applied at the blue folder extract stage. Click on Preview Batch SMS and it will then display a list of selected records before sending the actual SMS.

Map View

The Map View will pin point the location of each person/organisation on the map. On the left hand side you will find a list of people/organisations that appear on the map, and below the mapp you will find details of records that are not on the map as they do not have a correct postal code.

On the map you can click a map pin to view the details of the person/organisation and click again to hide the details. You are able to zoom in if required and a full screen option is available. If you want to take a copy you can either take a screen shot or use a snipping tool.

Click the 'Close Window' button to return to the report data.

Export Options

The export options allow extraction of the data with the ability of adding additional information for analysis in applications like MS Excel. This section is broken down into four columns:

Field Sets

Field Sets specify additional fields from the persons/organisations record. When you select a field set this information will be added to the report data and exported to a spread sheet. click here for a list of available fields.

Add Org/People-linked Records

You are able to include multiple options from the Org/People linked records, use the CTRL on the keyboard to make the selections. The available linked records can be selected:

Extension Database

Extension Databases are groups of bespoke fields that can be added to a records tabs or displayed on the footer of the record. All available Extension Databases will be displayed, this is determined by the type and security of the Extension Database. Once you have selected the relevant extension database, you can then decide which fields will be exported. You can use the CTRL key to select more than one field.

Other org/people-linked records

This section of the list will allow you to attach the following:

• Benefit Details - Details of the benefits recorded via the blue link of a record or on the referral outcomes page. This will include all benefits.
• Benefit Values - Values of the benefits recorded via the blue link of a record or on the referral outcomes page. This will include all benefits.
• Club and Clinic Attendances - Details of Clubs and Clinic attendances for the person/organisation.
• Club and Clinic Memberships - Columns for all Clubs and Clinics with a Y for each Club/Clinic the person/organisation is a member of.
• Consent Options - Details of the Consent Rules recorded on the records.
• Courses and Qualifications - Details of any courses or qualifications (blue links at the base of the record) that are recorded.
• Groups and Skills - Which groups and skill have been added via the bl;ue link on the footer of the record.
• Full Disability Records - Columns for disabilities with a Y for each disability record on the person's/organisation's record.
• In Project Records - Columns for each project with a Y for each project the person/organisation is in or been in.
• NoK and Contacts - Details of the Next of Kins and Contacts recorded using the blue link at the footer of the record.
• Output Areas and Wards - If LSOA Areas and Wards data has been populated and matched with the post code this will be added to the report data.
• Relationships - Attaches the relationship type and the related persons name.
• Relationships (Full details) - Attaches the relationship type and the related persons full details (Name, Contact details and other key fields).
• Carer Relationships - Attaches the carer relationship type and the carers name.
• Carer Relationships (Full details) - Attaches the carers relationship type and the carers full details (Name, Contact details and other key fields).
• Dependant Relationships - Attaches the Cared Fors relationship type and the Cared Fors name (only available on a carer system).
• Dependant Relationships (Full details) - Attaches the Cared Fors relationship type and the Cared Fors full details (Name, Contact details and other key fields) (only available on a carer system).
• Associated People - Attaches the names of associated people to an organisation, this is from the blue link on the footer of an organisation based record type.
• Associated Organisations - Attaches the names of associated organisation to a person, this is from the blue link on the footer of an person based record type.

Multiple selections can be made by holding down the CTRL button on the keyboard. If you select relationships you will be displayed the option to add additional data to those records as well.

Add Referral-linked Records

Assessment Forms (Deprecated Feature)

The answers to each question on the assessment forms selected.

Assessment Scores (Deprecated Feature)

The scores to each question and section on the assessment forms selected.

Extension Databases

Extension Databases are groups of bespoke fields that can be added to a referral. All available Extension Databases will be displayed, this is determined by the type and security of the Extension Database. When you select an Extension database you will then be able to choose which fields you want to add to your extract. This means you can select relevant fields rather than the entire extension database.

Extra Referral Data

Referral link records are only available when reporting on referrals or contacts. Project and person based reports will not show any referral based options. The follow options can be included on the export:

• Extra Referral Data - This will include additional details about the referral.
• Benefit Details - Details of the benefits recorded via the blue link of a record or on the referral outcomes page. This will include only the benefits attached to the referrals linked to the report data.
• Benefit Values - Values of the benefits recorded via the blue link of a record or on the referral outcomes page. This will include only benefit values attached to the referrals linked to the report data.
• Referral Reasons - This will produce a column for each referral reasons and place a Y under the reasons selected on the referral.
• Conflict of Interest - This will include all Conflict of Interests that have been recorded to any referral linked to the report data.

Multiple selections can be made by holding down the CTRL button on the keyboard.

On all of the above it does need consideration to the amount of additional options chosen. If you select too many options this may cause your internet browser to time out or your machine to crash if the spread sheet is too big for the specification of your machine or software.

Spreadsheet Options

Options in this section affect the output of the spread sheet that is exported.

• Export Header Options
• No Titles - just the report and options data, no field titles will be included.
• 1 Title Line (column headings) - The report and options data including field names as headers.
• Full Titles (includes header with dates etc) - Details of the report plus the report and options data including field names as headers.
• Where To Export To
  • A blank spreadsheet - the data will appear on a newly created spreadsheet.
  • Uploaded Spreadsheet - You will see a list of spreadsheet templates uploaded via System Uploads. The data will be placed on the worksheet specified by the template.

When you have specified your criteria the spreadsheet will be prepared and presented to open or save (depending on your browser).

Report Data

At the bottom of the Blu Folder Lookup page you will see the report data. If you wish to print this click on the 'Print' button.

When you have finished click on the 'Close Report' Button

Saving Blue Folder Options

Once you have established filters on your chosen export, you can instruct the report to remember those options. This means, when you run that particular Blue Folder report in the future, it will extract the same data. Depending on the report which triggered the blue folder, you can then select from relevant options when saving.

---