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.

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.

Rationale and design of a randomized, double-blind, placebo controlled multicenter trial to study efficacy, security, and long term effects of intermittent repeated levosimendan administration in patients with advanced heart failure: LAICA study.

BACKGROUND Advanced heart failure (HF) is associated with high morbidity and mortality; it represents a major burden for the health system. Episodes of acute decompensation requiring frequent and prolonged hospitalizations account for most HF-related expenditure. Inotropic drugs are frequently used during hospitalization, but rarely in out-patients. The LAICA clinical trial aims to evaluate the effectiveness and safety of monthly levosimendan infusion in patients with advanced HF to reduce the incidence of hospital admissions for acute HF decompensation. METHODS The LAICA study is a multicenter, prospective, randomized, double-blind, placebo-controlled, parallel group trial. It aims to recruit 213 out-patients, randomized to receive either a 24-h infusion of levosimendan at 0.1 μg/kg/min dose, without a loading dose, every 30 days, or placebo. RESULTS The main objective is to assess the incidence of admission for acute HF worsening during 12 months. Secondarily, the trial will assess the effect of intermittent levosimendan on other variables, including the time in days from randomization to first admission for acute HF worsening, mortality and serious adverse events. CONCLUSIONS The LAICA trial results could allow confirmation of the usefulness of intermittent levosimendan infusion in reducing the rate of hospitalization for HF worsening in advanced HF outpatients.

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.

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.

How can Brazil’s leading role in South America contribute to boosting security cooperation between the EU and Mercosur?

The primary goal of this paper is to discuss how the leading position of Brazil in South America could contribute to boost security cooperation between the European Union and Mercosur. Both parties share common foreign and security policy concerns, including immigration, terrorism and drug trafficking. Through its great influence on the regional security agenda, Brazil could seek closer bilateral cooperation with Europe in tackling these global challenges, acting at the same time as a representative of regional interests.

Registro de incidencias : seguridad en ficheros automatizados. Protección de datos de carácter personal (DD.CC.PP.)

El proyecto de Registro Automatizado de Incidencias tiene como objeto el desarrollo de un software que permita realizar el procedimiento de notificación, gestión y respuesta ante las incidencias. Se considerarán como "incidencias de seguridad", entre otras, cualquier incumplimiento de la normativa desarrollada en el Documento de Seguridad, así como a cualquier anomalía que afecte o pueda afectar a la seguridad de los datos de carácter personal.

Transforming personal experience and emotions through education to cultural diversity: an interplay between unicity and genericity

When subjects studied at school are close to societal discourses and to the students' social identities, when they have high emotional resonance, is it possible to enable the students to distance themselves from their emotions and personal experience, and to conceptualise them? Examining the relation between emotion and learning through the lens of socio-cultural psychology, the aim of our study was to shed light on "secondarisation" processes, that is, processes that transform personal experience and emotions into conceptualised forms of thinking. We analysed 85 video-recorded lessons in education for cultural diversity involving 12 teachers (of primary and secondary schools). Having identified episodes in which emotions were put into words or personal experience was reported, we analysed the use of pronouns (taken as indicators of secondarisation processes) and found a recurrent pattern: "the unicity-genericity routine". We illustrate the functioning of this routine with various excerpts taken from lessons in education for diversity taught in the classes of two teachers in primary school. The results show that the interplay between unicity and genericity works as a discursive resource for the development of secondarisation processes.

The Farm, the city, and the emergence of social security

We study the social, demographic and economic origins of social security. The data for the U.S. and for a cross section of countries suggest that urbanization and industrialization are associated with the rise of social insurance. We describe an OLG model in which demographics, technology, and social security are linked together in a political economy equilibrium. In the model economy, there are two locations (sectors), the farm (agricultural) and the city (industrial) and the decision to migrate from rural to urban locations is endogenous and linked to productivity differences between the two locations and survival probabilities. Farmers rely on land inheritance for their old age and do not support a pay-as-you-go social security system. With structural change, people migrate to the city, the land loses its importance and support for social security arises. We show that a calibrated version of this economy, where social security taxes are determined by majority voting, is consistent with the historical transformation in the United States.