Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Una empresa de selecció de personal vol incorporar un sistema per controlar i ajustar les ofertes de feina que rep de les empreses i les demandes de feina i currículums que presenten els treballadors.

Expectations, experiences and attitudes of patients and primary care health professionals regarding online psychotherapeutic interventions for depression: protocol for a qualitative study.

BACKGROUND In the year 2020, depression will cause the second highest amount of disability worldwide. One quarter of the population will suffer from depression symptoms at some point in their lives. Mental health services in Western countries are overburdened. Therefore, cost-effective interventions that do not involve mental health services, such as online psychotherapy programs, have been proposed. These programs demonstrate satisfactory outcomes, but the completion rate for patients is low. Health professionals' attitudes towards this type of psychotherapy are more negative than the attitudes of depressed patients themselves. The aim of this study is to describe the profile of depressed patients who would benefit most from online psychotherapy and to identify expectations, experiences, and attitudes about online psychotherapy among both patients and health professionals that can facilitate or hinder its effects. METHODS A parallel qualitative design will be used in a randomised controlled trial on the efficiency of online psychotherapeutic treatment for depression. Through interviews and focus groups, the experiences of treated patients, their reasons for abandoning the program, the expectations of untreated patients, and the attitudes of health professionals will be examined. Questions will be asked about training in new technologies, opinions of online psychotherapy, adjustment to therapy within the daily routine, the virtual and anonymous relationship with the therapist, the process of online communication, information necessary to make progress in therapy, process of working with the program, motivations and attitudes about treatment, expected consequences, normalisation of this type of therapy in primary care, changes in the physician-patient relationship, and resources and risks. A thematic content analysis from the grounded theory for interviews and an analysis of the discursive positions of participants based on the sociological model for focus groups will be performed. DISCUSSION Knowledge of the expectations, experiences, and attitudes of both patients and medical personnel regarding online interventions for depression can facilitate the implementation of this new psychotherapeutic tool. This qualitative investigation will provide thorough knowledge of the perceptions, beliefs, and values of patients and clinicians, which will be very useful for understanding how to implement this intervention method for depression.

L' Aula de Teatre de la Universitat de Vic (ATUV) : una aproximació a la seva trajectòria

El present treball de recerca explora i descriu alguns dels aspectes més rellevants del que ha estat la trajectòria de l’Aula de Teatre de la UVic (ATUV) al llarg dels anys. Consta de dues parts diferenciades. En la primera, presento de forma breu alguns dels elements bàsics de caràcter històric que configuren la relació del teatre amb l’educació, fent una especial referència al teatre universitari a l’estat espanyol i a Catalunya. La segona part del treball es desdobla, a la vegada, en dues perspectives. En una, dono compte de l’evolució realitzada per l’Aula de Teatre de la Universitat de Vic, des del punt de vista de la seva organització, característiques i funcionament, i produccions. S’ha fet una memòria descriptiva dels 18 anys de trajectòria de l’ATUV. La segona perspectiva aporta la visió del conjunt de persones (estudiants i exestudiants) que han passat per l’ATUV i que fan, a partir d’un qüestionari tramès prèviament, una valoració dels objectius de dinamització cultural de la Universitat que es proposa l’aula, així com dels aspectes de formació humanística que comprenen el treball de valors, d’habilitats i d’actituds com a procés de creixement personal que han viscut en la seva experiència a l’ATUV..

La valoració del coneixement de la llengua pròpia i del dret propi de Catalunya en la provisió de places del personal al servei de l’administració de justícia

La recerca proposa l’estudi del contingut i abast de les principals disposicions normatives que ordenen la valoració del coneixement de la llengua i el dret propis de Catalunya en la provisió de les places judicials. L’anàlisi de la tramitació parlamentària de les disposicions ha permès posar en context decisions del legislador, oferint instruments d’hermenèutica útils per resoldre debats interpretatius que avui es plantegen en seu doctrinal. La recerca inclou l’estudi dels efectes d’aquests textos normatius, en tant que permeten mesurar-ne la seva eficàcia i s’han de tenir en compte en el debat de les reformes que, eventualment, puguin desplegar-se. Des de la perspectiva d’anàlisi de les polítiques públiques, la recerca descriu les principals mesures formulades i implementades per les diferents Administracions Públiques, i molt especialment per la Generalitat de Catalunya, amb l’objectiu de corregir disfuncions que presenta aquest marc legal i reglamentari. La recerca ha posat en evidència que el règim jurídic que ordena l’aptitud lingüística i el coneixement del dret propi de Catalunya per part del personal judicial es caracteritza per la seva complexitat i falta de coherència. La valoració del coneixement de la llengua i el dret propis de la Comunitat Autònoma s’ha regulat molt tardament. Com a regla general, es valora com un mèrit en la provisió de la plaça, sotmès a més a intenses controvèrsies pel que fa a la determinació dels barems de puntuació concedits. En certs casos, com és el cos de Fiscals substituts, la valoració de la llengua i el dret propis de la Comunitat Autònoma ni tan sols es valora com un mèrit. Simplement no es té en compte. Pel que fa referència als secretaris judicials, la darrera reforma de la L.O. 6/1985 d’1 de juliol, del Poder Judicial, aprovada per L.O. 19/2003 de 23 de desembre, ha introduït el requisit de la capacitació lingüística per cobrir determinades places, per bé que el criteri general és el de la meritació puntuable. Altrament, en el cas del personal judicial depenent de la Generalitat s’ha garantit el requisit d’aptitud lingüística. D’aquesta manera, s’ha optat per assegurar un coneixement adequat i suficient de les dues llengües oficials, tant en l’expressió oral com en l’escrita, per a desenvolupar eficaçment les funcions pròpies del seu lloc de treball.

Integració i gestió dels marcatges laborals del personal d'empresa al sistema SAP R/3

L'objectiu d'aquest projecte és realitzar l'estudi i el disseny per a la corresponent implantació d'un sistema de control dels marcatges per fer el traspàs i poder-los gestionar amb SAP R/3 en un grup d'empreses.

From Leadership to Citizenship Behavior in Public Organizations: When Values Matter

After decades of management reforms in the public sector, questions on the impact of leader-ship behavior in public organizations have been attracting increasing attention. This paper investigates the relationship between transformational leadership behavior and organizational citizenship behavior as one major extra-role outcome of transformational leadership. Refer-ring to a growing body of research that shows the importance of public service values and employee identification in public administration research, we include public service motiva-tion and organizational goal clarification as mediating variables in our analysis. Structural equation modeling is applied as the method of analysis for a sample of 569 public managers at the local level of Switzerland. The findings of our study support the assumed indirect relation-ship between leadership and employee behavior and emphasize the relevance of public ser-vice values when analyzing leadership behavior in public sector organizations.

Tuberculin skin test and interferon-gamma release assay values are associated with antimicrobial peptides expression in polymorphonuclear cells during latent tuberculous infection

It has been reported that patients with progressive tuberculosis (TB) express abundant amounts of the antimicrobial peptides (AMPs) cathelicidin (LL-37) and human neutrophil peptide-1 (HNP-1) in circulating cells, whereas latent TB infected donors showed no differences when compared with purified protein derivative (PPD) and QuantiFERON®-TB Gold (QFT)-healthy individuals. The aim of this study was to determine whether LL-37 and HNP-1 production correlates with higher tuberculin skin test (TST) and QFT values in TB household contacts. Twenty-six TB household contact individuals between 26-58 years old TST and QFT positive with at last two years of latent TB infection were recruited. AMPs production by polymorphonuclear cells was determined by flow cytometry and correlation between TST and QFT values was analysed. Our results showed that there is a positive correlation between levels of HNP-1 and LL-37 production with reactivity to TST and/or QFT levels. This preliminary study suggests the potential use of the expression levels of these peptides as biomarkers for progression in latent infected individuals.

Conocimiento de la ley y preparación del personal sanitario sobre el proceso asistencial de la muerte.

The aims of this study were to ascertain the perception that health professionals (doctors, nurses and nursing assistants) have about their preparation for the care of terminally ill patients and to determine their knowledge about palliative care legislation. This cross sectional study was performed at a hospital in Granada (Spain); we administered an ad hoc questionnaire. The results indicated that although most of the staff had worked with terminally ill patients, only half believed that they have been trained to care for them. A significant proportion stated that they did not know about the current palliative care legislation. Most professionals would question the withdrawal of therapies for the maintenance of life; most of them are also unaware of the mechanism for reporting on the completion of a Living Will, as well as a Plan for Palliative Care in Andalusia (Spain).

Adaptación y validación al español del cuestionario 4CornerSAT para la medida de la satisfacción profesional del personal médico de atención especializada.

BACKGROUND Satisfaction of physicians is a concern in the healthcare sector, and it requires a multi-dimensional questionnaire in Spanish which studies their high-order needs. The objectives of this study are to adapt the 4CornerSAT Questionnaire to measure career satisfaction of physicians and to evaluate its validity in our context. METHOD The 4CornerSAT Questionnaire was adapted into Spanish, validating it among physicians of hospitals in Andalusia, Spain. A confirmatory factor analysis (CFA) was performed to corroborate the a priori model, and it was evaluated the internal consistency and the construct validity through the Cronbach's alpha and the correlation between the scale and the global item, respectively. RESULTS The adapted questionnaire was administrated to 121 specialist physicians. The CFA corroborated the four dimensions of the questionnaire (χ2=114.64, df=94, p<0.07; χ2/df=1.22; RMSEA=0.04). The internal consistency obtained an α=0.92 and the correlation between the summed scale and the global item verified the construct validity (r=0.77; p<0.001). CONCLUSIONS The 4CornerSAT questionnaire was adapted to Spanish, identifying an adequate construct validity and internal consistency.

The combination of social and personal contexts affects dominance hierarchy development in shore crabs, Carcinus maenas

Many animals that live in groups maintain competitive relationships, yet avoid continual fighting, by forming dominance hierarchies. We compare predictions of stochastic, individual-based models with empirical experimental evidence using shore crabs to test competing hypotheses regarding hierarchy development. The models test (1) what information individuals use when deciding to fight or retreat, (2) how past experience affects current resource-holding potential, and (3) how individuals deal with changes to the social environment. First, we conclude that crabs assess only their own state and not their opponent's when deciding to fight or retreat. Second, willingness to enter, and performance in, aggressive contests are influenced by previous contest outcomes. Winning increases the likelihood of both fighting and winning future interactions, while losing has the opposite effect. Third, when groups with established dominance hierarchies dissolve and new groups form, individuals reassess their ranks, showing no memory of previous rank or group affiliation. With every change in group composition, individuals fight for their new ranks. This iterative process carries over as groups dissolve and form, which has important implications for the relationship between ability and hierarchy rank. We conclude that dominance hierarchies emerge through an interaction of individual and social factors, and discuss these findings in terms of an underlying mechanism. Overall, our results are consistent with crabs using a cumulative assessment strategy iterated across changes in group composition, in which aggression is constrained by an absolute threshold in energy spent and damage received while fighting.

alr approach for replacing values below the detection limit

All of the imputation techniques usually applied for replacing values below thedetection limit in compositional data sets have adverse effects on the variability. In thiswork we propose a modification of the EM algorithm that is applied using the additivelog-ratio transformation. This new strategy is applied to a compositional data set and theresults are compared with the usual imputation techniques

Modelling the Human Values Scale from Consumers Transactional Data Bases

The main objective of this paper aims at developing a methodology that takes into account the human factor extracted from the data base used by the recommender systems, and which allow to resolve the specific problems of prediction and recommendation. In this work, we propose to extract the user's human values scale from the data base of the users, to improve their suitability in open environments, such as the recommender systems. For this purpose, the methodology is applied with the data of the user after interacting with the system. The methodology is exemplified with a case study