ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '643035' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '643035' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '643035' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '643035' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '643035']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '643035'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 643035 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 643035]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 643035 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 643035

Título del libro: Social Work In Public Health And Hospitals
Título del capítulo: Direct Costs Associated with the Appropriateness of Hospital Stay in Elderly Population

Autores UNAM:
MARIA DEL CARMEN GARCIA PEÑA; TERESA JUAREZ CEDILLO; SERGIO SANCHEZ GARCIA;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2016

---

Resumen:

Background: Ageing of Mexican population implies greater demand of hospital services. Nevertheless, the available resources are used inadequately. In this study, the direct medical costs associated with the appropriateness of elderly populations hospital stay are estimated. Methods: Appropriateness of hospital stay was evaluated with the Appropriateness Evaluation Protocol (AEP). Direct medical costs associated with hospital stay under the third-party payer?s institutional perspective were estimated, using as information source the clinical files of 60 years of age and older patients, hospitalized during year 2004 in a Regional Hospital from the Mexican Social Security Institute (IMSS), in Mexico City. Results The sample consisted of 724 clinical files, with a mean of 5.3 days (95% CI = 4.9-5.8) of hospital stay, of which 12.4% (n = 90) were classified with at least one inappropriate patient day, with a mean of 2.2 days (95% CI = 1.6 - 2.7). The main cause of inappropriateness days was the inexistence of a diagnostic and/or treatment plan, 98.9% (n = 89). The mean cost for an appropriate hospitalization per patient resulted in US$1, 497.2 (95% CI = US$323.2 - US$4, 931.4), while the corresponding mean cost for an inappropriate hospitalization per patient resulted in US$2, 323.3 (95% CI = US$471.7 - US$6, 198.3), (p < 0.001). Conclusion: Elderly patients who were inappropriately hospitalized had a higher rate of inappropriate patient days. The average of inappropriate patient days cost is considerably higher than appropriate days. In this study, inappropriate hospital-stay causes could be attributable to physicians and current organizational management. © 2011 by Apple Academic Press, Inc.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781466562462
Editorial:
Apple Academic Press Nombre de la publicación:
Direct Costs Associated with the Appropriateness of Hospital Stay in Elderly Population
Página inicial:
13
Página final:
28

Tipo de producto:
Capítulo de un Libro