Revision as of 16:54, 1 December 2015 (view source) Rob Kay (talk | contribs) ← Older edit		Latest revision as of 15:23, 1 February 2024 (view source) Alanconway (talk | contribs) m (→‎Introduction)
(57 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.  The folwing fields can be used:
		+	* '''System ID Number''' - Auto populated when a record is created.
		+	* '''Name''' - An individuals surname or an organisations name, depending on the record type.
		+	* '''Forename(s)''' - A person first and middle names
		+	* '''Initials''' - Auto populated from the forenames field
		+	* '''Title''' - The persons title, Mr, Master, Miss, Mrs, Ms, Dr, Rev etc.
		+	* '''Salutation''' - Auto populated using the 'Title' and 'Name' fields.
		+	* '''Address line 1''' - House number/Name and Street
		+	* '''Address line 2''' - Flat/Block or Apartment #
		+	* '''Address line 3''' - Village/Locality
		+	* '''Address line 4 (Town)''' - Town
		+	* '''Address line 5 (County)''' - County
		+	* '''Postcode''' -  - Postcode
		+	* '''Postal District''' - District (Often used for Local Authority Areas).  Generally used for reporting on work done in these areas.
		+	* '''Preferred Method of Communication''' - How this person/organisation would normally be contacted.
		+	* '''Main Telephone No.''' - Main telephone number to contact the person/organisation.
		+	* '''Mobile Telephone No.''' - Mobile Phone number.
		+	* '''Emergency Telephone No.''' - Emergency contact number, recommended you put who's number this is in brackets - example 01234 567890 (Mother).
		+	* '''Email Address (Main)''' - The main Email address.
		+	* '''Notes / General Description''' - Used for basic notes, used to explain details about telephone numbers or other things about the person/organisation.  Not to be used for case/referral notes.
		+	* '''Consent Given''' - If this person has given consent to be recorded, this has been superseded by [[Consent_Rule_Text_Entry| Consent Rules]]
		+	* '''Active''' - This determines if this record is available to the normal searches.  If a record is inactive it is '''not''' destroyed and can easily be made active again.
		+	* '''Gender''' - The legal gender of an individual.
		+	* '''Date of Birth''' - This field displays day, month and year of birth.
		+	* '''Age Range''' - Auto calculated using the date of birth.
		+	* '''Marital Status''' - A person marital status.
		+	* '''Sexual Orientation''' - A person sexual orientation/preference
		+	* '''Ethnic Group''' - [https://en.wikipedia.org/wiki/Ethnic_group| An ethnic group, or an ethnicity, is a category of people who identify with each other based on similarities such as common ancestry, language, history, society, culture or nation.]
		+	* '''Religious Group''' - An individuals personal religious beliefs.
		+	* '''Victim of Crime''' - Is this person currently a victim of crime generally used in relation to the Domestic Violence, Crime and Victims Act 2004
		+	* '''Employed?''' - The employment status of an individual.
		+	* '''Blue Badge Holder?''' - Does this person have a blue badge (The Blue Badge scheme helps you park closer to your destination if you’re disabled).
		+	* '''GP Surgery''' - A persons GP Surgery, this is populated using the field 'Is this a GP Surgery?' used on an organisations record type.
		+	* '''GP Name''' - A person GP (Doctor), this is populated using the field 'Is this a GP (Doctor)?' used on a professionals record.
		+	* '''Accounts Code''' - This is used by the invoice module and often is the accounts code from an accounts program.
		+	* '''Status''' - On a carer system this is used for the types of carers, other organisations may use this to say an individuals status.
		+	* '''NI Number''' - A persons National Insurance number.
		+	* '''NHS Number''' - A person National Health Service (NHS) Number.
		+	* '''Social Services ID No.''' - A persons reference number with the local authorities social services.  This is often called a different name depending on the local authority.
		+	* '''Living Arrangements''' - An individuals living arrangements - Lives alone, with partner/spouse etc.
		+	* '''People in Household''' - A fixed field to record the number of people living in a household.
		+	* '''Accommodation Type''' - The type of accommodation a person is living in - House (Private), House (Social Housing), Care Home etc.
		+	* '''Any Disabilities?''' - Does this person have any disabilities.  This field can be set manually or is automatically updated when a main disability is recorded.
		+	* '''Registered Disabled?''' - Is this person registered on a local authorities voluntary system or used for Registered Blind.
		+	* '''Main Disability''' - A a persons primary disability, this will auto populate the 'Any Disabilities?' if you disable this feature it is also recommended that you change the [[Operational_Rules#Require_main_disability_for_people_with_disabilities.3F| Operational Rules]] to disable the requirement of main disability.
		+	* '''General Category of Need''' - This is used to classify a persons need level.  A person can only be in one category at a time.
		+	* '''Deceased?''' - Specifies if the person has died and will activate termination process.
		+	* '''Risk Assessment''' - This is a text box that allows risk assessment information to be recorded.  When populated it the tab label will change to '***Risk Assessment***' and a warning symbol will be displayed on search pages and the [[Action List]].
		+	* '''Job Title''' - A person job title
		+	* '''Image or logo''' - Used to attach a photo of an individual or a logo of an organisation to be displayed on the record.
		+	* '''Department''' - A persons department that they work in.
		+	* '''Is this a Young Carer?''' - Used on a carers system to specify the individual is a young carer.  This is also auto populated from the 'Status' field.
		+	* '''Email Address (Other)''' - A secondary Email address
		+	* '''School''' - What school a person attends/works in/manages.  This is auto populated by the 'Is this a school field'
		+	* '''Person/Organisation Category''' - A way of categorising organisation and professionals.  Example:  If you add several Social Services teams on the system they could all be categorised as 'Social Services' which can then be reported on by category.
		+	* '''Website''' - The website address for an organisation.
		+	* '''Social Media Link 1''' - A box to enter a social media link.
		+	* '''Preferred Known As''' - A box to specify a person preferred name
		+	* '''Induction Date''' - A workers/volunteers induction date.
		+	* '''Service User Group''' - Some organisation categorise their service users into groups, a person can only be in one group.
		+	* '''First Referral Date''' - The date a person was first referred.  This is auto populated from the first referral recorded on the system.  You can change the
		+	* '''Social Media Link 2''' - A box to enter a social media link.
		+	* '''UDPRN (Royal Mail)''' - Unique Delivery Point Reference Number.
		+	* '''ID Badge Number''' - A person ID badge number.
		+	* '''Eligible For Gift Aid?''' - Used if a person has completed a Gift Aid Certificate.
		+	* '''References Taken?''' - Used for personnel records.
		+	* '''Social Media Link 3''' - A box to enter a social media link.
		+	* '''Main Language''' - A persons main spoken language.
		+	* '''Landline Telephone No.''' - Land-line (home) telephone number.
		+	* '''Fax/Other Telephone No.''' - Used for either a fax or additional number.
		+	* '''Current School Year''' - This is auto populated from the data of birth and school year offset.
		+	* '''User Name: ##LINK_NAME##''' - This is a system users user name, usually displayed on staff and volunteer records.
		+	* '''Payment Method''' - Specifies a persons payment method, if the invoice module is used it will also update the footer on invoices.
		+	* '''DBS/PVG Checked?''' - Disclosure Barring Service (England or  Wales) or Protecting Vulnerable Groups (Scotland) check has been carried out.
		+	* '''PAYE Reference''' - A persons Pay As You Earn tax reference service.
		+	* '''Second Referrer/Contact''' - Specify a secondary referrer that often refers the person.
		+	* '''DBS/PVG Expiry Date?''' - Expiry date as determined by your organisations own policies.
		+	* '''Is this a GP (Doctor)?''' - Used for professionals which populates the GP/Doctor list used on client records.
		+	* '''UTR Number''' - Unique Tax Reference number which is usually used for self employed people.
		+	* '''Is this a GP Surgery?''' - Used for refers and organisations, this will populate the GP surgery list used on client records.
		+	* '''Is this a School?''' - Used on organisations to populate the Schools list used on Client/Student records.
		+	* '''PIN (for CM System)''' - PIN number used with CM integrations.
		+	* '''Is this a Handyperson?''' - Used to specify that the record is a Handy Person and can be allocated jobs in the [[Modules| HandyPerson Module]].
		+	* '''Is this an Org/Signpostee?''' - This field will set any record type as an 'Organisation' type record as well.  This field should not be added to an 'Organisation' record it will lose it's record type.
		+	* '''Main Referrer/Contact''' - The main referrer for the person.  This field can auto populate the Record A Contact screen's Referrers field, see [[Operational_Rules#Pre-fill_Referrer_on_RaC_with_Referrer_from_Org.2FPeople_Record.3F| Operational Rules]] for further details.
		+	* '''Is this a Referrer?''' - This field will set any record type as a 'Referrer' type record as well.  This field should not be added to a 'Referrer' record it will lose it's record type.
		+	* '''Is this a Carer?''' - Used on a non carer system.  This will make a client record a carer record as well.
		+	* '''Usual Support Worker''' - This is a list of Staff and Volunteers on the system.
		+	* '''DBS/PVG Issued Date?''' - The date that a DBS/PVG certificate was issued.
		+	* '''Is this a Supplier?''' - Marks the record as a supplier record as well.
		+	* '''Include in Info. Links''' - Allows the record to have the 'Save and Set Information Links' button at the base of the record.  This will put the record on the Information Links directory.
		+	* '''School Year Offset''' - Allows the School Year to be adjusted with the relevant offset.
		+	* '''Nourish Carer ID''' - Used with the Nourish Integration.
		+	* '''Nourish Carer Username''' - Used with the Nourish Integration.
		+	* '''DBS/PVG Certificate Number''' - DBS/PVG Certificate Number
		+	* '''Ezitracker ID''' - Used with Ezitracker dial in system.
		+	* '''Nourish Carer API Key''' - Used with the Nourish Integration.
		+	* '''Webroster ID''' - [[Deprecated Feature]]
		+	* '''Alternative Identifier''' - ID number to much to a secondary system that you may use.
−	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.
−	* 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 15:23, 1 February 2024

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. The folwing fields can be used:

• System ID Number - Auto populated when a record is created.
• Name - An individuals surname or an organisations name, depending on the record type.
• Forename(s) - A person first and middle names
• Initials - Auto populated from the forenames field
• Title - The persons title, Mr, Master, Miss, Mrs, Ms, Dr, Rev etc.
• Salutation - Auto populated using the 'Title' and 'Name' fields.
• Address line 1 - House number/Name and Street
• Address line 2 - Flat/Block or Apartment #
• Address line 3 - Village/Locality
• Address line 4 (Town) - Town
• Address line 5 (County) - County
• Postcode - - Postcode
• Postal District - District (Often used for Local Authority Areas). Generally used for reporting on work done in these areas.
• Preferred Method of Communication - How this person/organisation would normally be contacted.
• Main Telephone No. - Main telephone number to contact the person/organisation.
• Mobile Telephone No. - Mobile Phone number.
• Emergency Telephone No. - Emergency contact number, recommended you put who's number this is in brackets - example 01234 567890 (Mother).
• Email Address (Main) - The main Email address.
• Notes / General Description - Used for basic notes, used to explain details about telephone numbers or other things about the person/organisation. Not to be used for case/referral notes.
• Consent Given - If this person has given consent to be recorded, this has been superseded by Consent Rules
• Active - This determines if this record is available to the normal searches. If a record is inactive it is not destroyed and can easily be made active again.
• Gender - The legal gender of an individual.
• Date of Birth - This field displays day, month and year of birth.
• Age Range - Auto calculated using the date of birth.
• Marital Status - A person marital status.
• Sexual Orientation - A person sexual orientation/preference
• Ethnic Group - An ethnic group, or an ethnicity, is a category of people who identify with each other based on similarities such as common ancestry, language, history, society, culture or nation.
• Religious Group - An individuals personal religious beliefs.
• Victim of Crime - Is this person currently a victim of crime generally used in relation to the Domestic Violence, Crime and Victims Act 2004
• Employed? - The employment status of an individual.
• Blue Badge Holder? - Does this person have a blue badge (The Blue Badge scheme helps you park closer to your destination if you’re disabled).
• GP Surgery - A persons GP Surgery, this is populated using the field 'Is this a GP Surgery?' used on an organisations record type.
• GP Name - A person GP (Doctor), this is populated using the field 'Is this a GP (Doctor)?' used on a professionals record.
• Accounts Code - This is used by the invoice module and often is the accounts code from an accounts program.
• Status - On a carer system this is used for the types of carers, other organisations may use this to say an individuals status.
• NI Number - A persons National Insurance number.
• NHS Number - A person National Health Service (NHS) Number.
• Social Services ID No. - A persons reference number with the local authorities social services. This is often called a different name depending on the local authority.
• Living Arrangements - An individuals living arrangements - Lives alone, with partner/spouse etc.
• People in Household - A fixed field to record the number of people living in a household.
• Accommodation Type - The type of accommodation a person is living in - House (Private), House (Social Housing), Care Home etc.
• Any Disabilities? - Does this person have any disabilities. This field can be set manually or is automatically updated when a main disability is recorded.
• Registered Disabled? - Is this person registered on a local authorities voluntary system or used for Registered Blind.
• Main Disability - A a persons primary disability, this will auto populate the 'Any Disabilities?' if you disable this feature it is also recommended that you change the Operational Rules to disable the requirement of main disability.
• General Category of Need - This is used to classify a persons need level. A person can only be in one category at a time.
• Deceased? - Specifies if the person has died and will activate termination process.
• Risk Assessment - This is a text box that allows risk assessment information to be recorded. When populated it the tab label will change to '***Risk Assessment***' and a warning symbol will be displayed on search pages and the Action List.
• Job Title - A person job title
• Image or logo - Used to attach a photo of an individual or a logo of an organisation to be displayed on the record.
• Department - A persons department that they work in.
• Is this a Young Carer? - Used on a carers system to specify the individual is a young carer. This is also auto populated from the 'Status' field.
• Email Address (Other) - A secondary Email address
• School - What school a person attends/works in/manages. This is auto populated by the 'Is this a school field'
• Person/Organisation Category - A way of categorising organisation and professionals. Example: If you add several Social Services teams on the system they could all be categorised as 'Social Services' which can then be reported on by category.
• Website - The website address for an organisation.
• Social Media Link 1 - A box to enter a social media link.
• Preferred Known As - A box to specify a person preferred name
• Induction Date - A workers/volunteers induction date.
• Service User Group - Some organisation categorise their service users into groups, a person can only be in one group.
• First Referral Date - The date a person was first referred. This is auto populated from the first referral recorded on the system. You can change the
• Social Media Link 2 - A box to enter a social media link.
• UDPRN (Royal Mail) - Unique Delivery Point Reference Number.
• ID Badge Number - A person ID badge number.
• Eligible For Gift Aid? - Used if a person has completed a Gift Aid Certificate.
• References Taken? - Used for personnel records.
• Social Media Link 3 - A box to enter a social media link.
• Main Language - A persons main spoken language.
• Landline Telephone No. - Land-line (home) telephone number.
• Fax/Other Telephone No. - Used for either a fax or additional number.
• Current School Year - This is auto populated from the data of birth and school year offset.
• User Name: ##LINK_NAME## - This is a system users user name, usually displayed on staff and volunteer records.
• Payment Method - Specifies a persons payment method, if the invoice module is used it will also update the footer on invoices.
• DBS/PVG Checked? - Disclosure Barring Service (England or Wales) or Protecting Vulnerable Groups (Scotland) check has been carried out.
• PAYE Reference - A persons Pay As You Earn tax reference service.
• Second Referrer/Contact - Specify a secondary referrer that often refers the person.
• DBS/PVG Expiry Date? - Expiry date as determined by your organisations own policies.
• Is this a GP (Doctor)? - Used for professionals which populates the GP/Doctor list used on client records.
• UTR Number - Unique Tax Reference number which is usually used for self employed people.
• Is this a GP Surgery? - Used for refers and organisations, this will populate the GP surgery list used on client records.
• Is this a School? - Used on organisations to populate the Schools list used on Client/Student records.
• PIN (for CM System) - PIN number used with CM integrations.
• Is this a Handyperson? - Used to specify that the record is a Handy Person and can be allocated jobs in the HandyPerson Module.
• Is this an Org/Signpostee? - This field will set any record type as an 'Organisation' type record as well. This field should not be added to an 'Organisation' record it will lose it's record type.
• Main Referrer/Contact - The main referrer for the person. This field can auto populate the Record A Contact screen's Referrers field, see Operational Rules for further details.
• Is this a Referrer? - This field will set any record type as a 'Referrer' type record as well. This field should not be added to a 'Referrer' record it will lose it's record type.
• Is this a Carer? - Used on a non carer system. This will make a client record a carer record as well.
• Usual Support Worker - This is a list of Staff and Volunteers on the system.
• DBS/PVG Issued Date? - The date that a DBS/PVG certificate was issued.
• Is this a Supplier? - Marks the record as a supplier record as well.
• Include in Info. Links - Allows the record to have the 'Save and Set Information Links' button at the base of the record. This will put the record on the Information Links directory.
• School Year Offset - Allows the School Year to be adjusted with the relevant offset.
• Nourish Carer ID - Used with the Nourish Integration.
• Nourish Carer Username - Used with the Nourish Integration.
• DBS/PVG Certificate Number - DBS/PVG Certificate Number
• Ezitracker ID - Used with Ezitracker dial in system.
• Nourish Carer API Key - Used with the Nourish Integration.
• Webroster ID - Deprecated Feature
• Alternative Identifier - ID number to much to a secondary system that you may use.

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.

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.

---