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

Base de dades realitzada en Oracle per controlar i ajustar les ofertes de de treball que es reben de les empreses i les demandes de feina i currículums que presenten els treballadors. Tot l'accés a les dades es realitza mitjançant procediments emmagatzemats.

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.

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.

Consensus guidelines for enhanced recovery after gastrectomy: Enhanced Recovery After Surgery (ERAS®) Society recommendations.

BACKGROUND: Application of evidence-based perioperative care protocols reduces complication rates, accelerates recovery and shortens hospital stay. Presently, there are no comprehensive guidelines for perioperative care for gastrectomy. METHODS: An international working group within the Enhanced Recovery After Surgery (ERAS®) Society assembled an evidence-based comprehensive framework for optimal perioperative care for patients undergoing gastrectomy. Data were retrieved from standard databases and personal archives. Evidence and recommendations were classified according to the Grading of Recommendations, Assessment, Development and Evaluation (GRADE) system and were discussed until consensus was reached within the group. The quality of evidence was rated 'high', 'moderate', 'low' or 'very low'. Recommendations were graded as 'strong' or 'weak'. RESULTS: The available evidence has been summarized and recommendations are given for 25 items, eight of which contain procedure-specific evidence. The quality of evidence varies substantially and further research is needed for many issues to improve the strength of evidence and grade of recommendations. CONCLUSION: The present evidence-based framework provides comprehensive advice on optimal perioperative care for the patient undergoing gastrectomy and facilitates multi-institutional prospective cohort registries and adequately powered randomized trials for further research.

(Endogenous) occupational choices and job satisfaction among recent PhD recipients: evidence from Catalonia

Drawing on data from two successive cohorts of PhD graduates, this paper analyses differences in overall job satisfaction and specific job domain satisfaction among PhDs employed in different sectors four years after completing their doctorate degrees. Covariate-adjusted job satisfaction differentials suggest that, compared to faculty members, PhD holders employed outside traditional academic and research jobs are more satisfied with the pecuniary facets of their work (principally, because of higher earnings), but significantly less satisfied with the content of their job and with how well the job matches their skills (and, in the case of public sector workers, with their prospects of promotion). The evidence regarding the overall job satisfaction of the PhD holders indicates that working in the public or private sectors is associated with less work well-being, which cannot be fully compensated by the better pecuniary facets of the job. It also appears that being employed in academia or in research centres provides almost the same perceived degree of satisfaction with the job and with its four specific domains. We also take into account the endogenous sorting of PhD holders into different occupations based on latent personal traits that might be related to job satisfaction. The selectivity-corrected job satisfaction differentials reveal the importance of self-selection based on unobservable traits, and confirm the existence of a certain penalisation for working in occupations other than academia or research, which is especially marked in the case of satisfaction with job content and job-skills match. The paper presents additional interesting evidence about the determinants of occupational choice among PhD holders, highlighting the relevance of certain academic attributes (especially PhD funding and pre-and-post-doc research mobility) in affecting the likelihood of being employed in academia, in a research centre or in other public or private sector job four years after completing their doctorate programme.