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 = '614790' 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 = '614790' 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 = '614790']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 614790 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= 614790]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: Association For Information Systems - 11th Americas Conference On Information Systems, Amcis 2005: A Conference On A Human Scale Título del capítulo: Cam structural change in the system area an insurance company in Mexico to align with business processes
Autores UNAM: GUILLERMO RODRIGUEZ ABITIA;
Autores externos: Idioma: Año de publicación: 2005Palabras clave:
Business Process; Change management; Competitive environment; External consultants; Functional structure; Inhibiting factors; Insurance companies; IT structures; Me-xico; Organizational structures; Strategic objectives; Structural change; Technology vendors; Transformation Program; C (programming language); Information systems; Insurance; Cams
Resumen:
A structural-change case study in the systems area of one of the main insurance companies in Mexico is presented. This change is produced as a consequence of a need for improvement of the instrumentation effectiveness of an operational and technological transformation. We describe a) the changes that have taken place in the competitive environment, and in the organization, b) the strategic objective that justify the creation of such a transformation program, c) the evolution of the organizational structure of the systems area to a highly-fragmented functional structure, d) the problems that such functional structure caused during the transformation-program execution, and e) the organizational structure redesign to align it to the firm's business processes. The inhibiting factors for change are analyzed, such as the dependency on the technology vendors and external consultants' knowledge, as well as the internal factors of cultural resistance, and conflicting interests.
