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 = '471028' 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 = '471028' 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 = '471028']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 471028 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= 471028]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Proceedings Of The 2002 International Joint Power Generation Conference Título del capítulo: Integrated diagnostic system for the equipment of power plants: Part II - The expert system
Autores UNAM: ALFONSO GARCIA GUTIERREZ;
Autores externos: Idioma: InglésAño de publicación: 2002Palabras clave:
Compressors; Electric power plant equipment; Expert systems; Gas turbines; Identification (control systems); Steam turbines; Thermodynamics; Vibrations (mechanical); Fault identification; Integrated diagnostic system; Combined cycle power plants
Resumen:
This paper describes the development of an Expert System for identification of generating equipment faults caused by wearing out of their components, which decrease the efficiency and thus the heat rate of a generating plant. In a sister paper, the formulation was presented and the algorithms for the principal equipment were developed. The Expert Systems are based on the above algorithms. Also, in some case a vibration analysis is used jointly with thermodynamic analysis to locate precisely a fault, for example in a case of rubbing which damaged the seals of the turbine and/or compressors. The system is used off-line, however it can be installed on-line with a monitoring system. The expert systems identify the faults of the gas turbine, the compressor and the steam turbine. Auxiliary equipment faults are presented in the form of tables also, listing the symptons and their causes. The knowledge levels and the separate bases are built into the systems.