Memories

All memories have the same data filtering options, therefore, the results will always be limited by:

• EBASP
• Sector and subsector
• Team
• Professional
• Time period

On the other hand, the option of how to account for actions, problems, demands, etc. allows:

• Registration date:   actual date of introduction of the action into the system (date on which the action was registered).
• Performance date:   date on which the action is said to have been taken (action date field), regardless of the day it was entered into the system.

This option is very important to take into account in months close to the change of year, for example, when actions carried out in December of the previous year are entered in January. When there are actions with an action date in December, but the date of registration in the system is in January, there may be a lag in the annual count. In this sense, it is important to select “Action date”.

The screens also contain the following function buttons:

• Update:   executes the query to obtain the results according to the filter data we have entered.
• Export active tab : exports to Microsoft Excel spreadsheets with active autofilters. If you do not have Microsoft Office 2003 or higher installed, these options will not be active.
• Generate : directly generates the information that is displayed on the screen in the official form of each report.

2.1-RUDEL sheet 01

Information systems

Number of people working with the application : obtained from application access records, therefore, it refers to all users who have accessed the application throughout the selected period by gender. It is important to keep the list of professionals who use Hestia updated.

Number of active files in the application : obtained from all files in status   Open during the reference period and in any of the people linked to these files, some action, appeal, intervention plan, procedure has been registered, or the situation of the file has changed. The status of the file must be kept updated. Those files that have not had activity for a long period of time should be closed.   Not to be confused with the number of files worked on.

Number of inactive files in the application : total files entered, regardless of the period chosen, minus those active within the period, that is, the inactive ones will refer to:

• Closed files.
• Open files without any actions.
• Open files without actions in the chosen period.

Basic social care team

Number of people attended : Number of people attended by a professional from a basic social care team. It is obtained from the total number of different people who have registered some action (whether manual or automatic) in the selected time period. Each user must have at least one action to be counted in this section.

Number of new family and/or cohabitation files in EBAS : Total files registered within the chosen period. It should be noted that the date of creation of a file cannot be modified, since it is created automatically when it is registered.

Number of family and/or cohabitation files worked on in the EBAS : this total does not appear in the RUDEL, it is complementary information . It counts all the files that have been dealt with, that is, that have at least one action within the chosen period.

Number of users served by intervention sectors

It refers to the RUDEL point “Number of users attended by EBAS broken down by intervention sectors”, within the Basic Team data. It collects the actions, manual and automatic, generated by the resource and procedure register and by the professional's manual registration, within the selected period, broken down by sex and classified by the scope of action defined in the register. The reason for intervention is taken into account, not the people. In the resource register it is very important to fill in all the fields, since depending on the registered one they will count in one or another area, and in a different type of action (pre-assigned or denied resources are counted in the Guidance column, while those granted are distributed according to the choice based on the following correspondences:

ORIENTATION INFORMATION:

HOME HELP:

COMMUNITY SUPPORT:

ALTERNATIVE ACCOMMODATION:

PREVENTION INSERTION:

Number of actions per service

Total actions according to their typology, manual or automatic. Pre-assigned or denied resources are counted in the Guidance and Advice section. Manual coordination actions are counted 50% in Information, and 50% in Guidance and Advice. It is important to update the procedure and the resource. The result obtained follows the following correspondence:

Number of problems addressed

List of the problems of each user within the family file, classified according to the General Type of problem, and broken down by Specific Type of problem and Totals. The calculation of the totals takes into account the problems addressed totally or partially within the chosen period.

Home help service (for entities that do not use the SAD Gestió module)

The data is extracted from resource 1.1.2.1 Home help service. The start and end dates and the status of the resource must be taken into account (it must be “granted” in order to be calculated). If in any case a Social SAD is given while a Dependency SAD is being resolved, then the type must be changed within the specifications of the resource itself: it will be calculated in both modalities. All users/owners of the resource and the entity must be selected.

Number of people served : the beneficiaries are considered. This classification is based on the age and sex of the active people who make up the family unit that has an assigned SAD resource. That is, if in a family file of 4 people, one of them is inactive, and that has an assigned SAD resource, the age and sex of each of the 3 active people are looked at.

Number of family units served : is based solely on the sex and age of the holder of the SAD resource.

Number of people served by support and care technology services.

Number of people served by the support and care technology service according to age and sex (without repetition). All people who have registered and granted the resource 1.1.2.2. “Support and care technology services” are counted during the selected period. Care must be taken in the status of the resource (granted) and the start and end dates.

Number of social emergency economic benefits.

Number of beneficiaries of resources from 2.3.1 to 2.3.8 registered during the selected time period.

In “Number of applications” all beneficiaries of resources from 2.3.1 to 2.3.8 are counted, regardless of their status. In “Number of people served” only beneficiaries with a resource granted will be counted. The status of the resource, the entity and the start and end dates must be taken into account. The total amount of the resource will only be counted once, despite having “n” beneficiaries registered. The “Third sector” entity will count in the “Number of referrals” column.

The following resources are currently defined:

Number of technical aids granted in total by the Local Entity:

This list is based on the resources:

3.1. Technological Features

3.1. Technical Aid dependent on the Social Services system

3.1.1 Aid for mobility and transport.

3.1.2 Aids for personal autonomy and communication.

Financing of social services

Currently, only the total number of users by sex and type of service is reported. The data on the number of users is derived from the variable “Number of users by intervention sector”. The data on the variable “Expenditure” cannot be calculated due to the lack of data in Hèstia.

Basic Social Services Users : People (without repetitions) who have been assigned a diagnosis, have been prescribed interventions, benefits, whether or not they have been treated by an EBAS. It is obtained from the sum of people, in a registered situation, who have had actions, resources, intervention plans or procedures registered for them, during the selected time period. The start and end dates of the resources must be taken into account (if the end date is December 31 of the previous year and no other action is taken, it will not count in subsequent years).

Waiting time : Waiting time for requesting the first interview. This is the average time for appointments selected as “First interview” from the date of their recording in the Hestia agenda to the scheduled date of the appointment. It is very important to select the type of appointment “First interview” so that it can be counted correctly. We must also remember to update its actual status (“carried out”) and relate this appointment in the agenda to an action carried out by the professional on this first visit.

2.2-RUDEL sheet 02-01

Number of children and adolescents referred by EBAS

It refers to the table “Number of children referred during the current year to open centers referred by EBAS”. The data extracted is the number of people assigned resource 1.1.6.1 Open center service, and classifies them by age and sex.

The list presents an additional age range, over 18 years old, to take into account possible data entry errors.

2.3-RUDEL sheet 02-02

It refers to the table “Number of children attended to during the current year in open centers referred by EBAS”. The data extracted is the number of people assigned resource 1.1.6.1 Open center service, and classifies them by age and sex.

This block of the reports deals with the data requested by the Catalan Women's Institute (ICD), but considering different variants and formats.

3.1 RUDEL sheet 28

Quantitative analysis.

Number of women treated: This value can be extracted from the “ n People Treated / n Cases ” tab, choosing the D, women column.

Number of services provided: this total is what appears in the title itself “ n services for… ”, where n refers to the total number of services.

Number of women treated by psychological counseling service, Number of services provided by psychological counseling service, Number of women treated by legal counseling service and Number of services provided by legal counseling service: can be extracted from the “ n Actions by Service provided ” tab, in which the column   Number   refers to the total of attentions and the column   Number of different people   to the people who have received these n actions.

Number of female users in situations of gender-based violence: this data can be extracted from the “ n Actions per Situation of Violence Detected ” tab. As the option of gender-based violence does not appear explicitly in any of the ICD options, this list has broken down as much information as possible according to the situations of violence that appear in the actions of the SIAD module.

Consultation areas

List “ n Actions by / Query Areas ”. Only items that have a value appear, if any do not appear it means that their value is 0.

Type of care processing

Tab “ n Actions for / Processing ”. Only items that have a value appear, if any do not appear it means that their value is 0.

Input channels

Tab “ n People attended – n Files / Input channel ”. Only items that have a value appear, if any do not appear it means that their value is 0.

Referral proposals

List “ n Actions for / Derivation ”. Only items that have a value appear, if any do not appear it means that their value is 0.

User profile analysis

People served by sex: Tab “ n People served – n Files / Sex ”. This table differentiates between those over and under 18 years of age, therefore, in order to obtain the Totals, it is necessary to add Minors served + People served. The sum of the totals for men and women must coincide with the number n that appears in the tab “ n People served ”.

People served by age: Tab “ n People served – n Files / Age ”.

People served by level of studies: “ n People served – n Files / Studies ”.

People served by civil status: “ n People served – n Files / Civil Status ”.

People served by nationality of origin: “ n People served – n Files / Nationality ”.

3.2 ICD memories

n People served / n Files for

Gender: number of people attended to by gender, according to the data in the Personal File.

Large age groups: number of people served according to their age, according to the date of birth on the Personal File. The data is grouped by age ranges, but the ranges in which no person is counted do not appear.

Age in five-year intervals: list with the number of people treated according to their age, grouped into 5-year ranges. Intervals with a result of 0 will not appear in the list.

Residence: list of the number of people according to the sector defined in the Personal File at the time of opening the SIAD file.

Studies: number of people attended classified by their level of studies, as defined in the SIAD file itself in the Studies Completed field.

Family Situation: list of the number of users according to the type of family defined in the SIAD file itself, in the Family Situation field.

Average Children: sum of the total number of children in the files divided by the number of files.

Average number of dependents in charge: sum of the number of dependents in charge of all SIAD files divided by the number of SIAD files.

ATENPRO: number of users who benefit from the service, according to the field of the same name present in the SIAD files.

Nationality: number of users according to the Nationality defined in the SIAD file itself.

n Performances

Arrival procedure: total of actions according to the arrival procedure defined in the action.

Attention channel: list of total actions by channel, according to the value entered in the SIAD action.

Scope: list of total actions by scope, according to SIAD action data.

Derived by / Derived to: list of total actions according to the data entered in the action.

Situation of violence detected: total of actions according to the value entered in the SIAD action, in the field of the same name. Values with a total result equal to 0 are not displayed.

4.1 RUDEL sheet 07

Employment guidance and legal advice

List of total queries/actions according to the   Action type   which follows from   the Action   defined within the Immigration action.

Improving the individual recruitment of immigrants

List of the number of beneficiaries by area of intervention, which is obtained from the   Training Actions   of each action, according to the following table:

Beneficiary profile

List of users according to origin and classified according to age range and gender.

5.1 RUDEL sheet 19

Diagnostic assessment

Cases studied before 6 months: this total is obtained from all files received in a period of time that have had a technical situation/measure in Study for less than 6 months.

Cases received: total cases received in a period of time.

Development of socio-educational commitment proposals

Number of socio-educational commitment proposals and/or non-serious risk assessments: obtained from the total number of socio-educational commitment type reports made throughout the chosen period.

Number of cases derived from basic social services: obtained from cases whose origin is a Sector/Municipality, that is, cases in which the “Origin” field has any value except Unassigned, DGAIA/SAIA or Justice Services.

1.1.2 Monthly statistics DGAIA/SAIA

It presents statistical data on the status of the service.