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 = '487976' 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 = '487976' 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 = '487976' 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 = '487976' 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 = '487976']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '487976'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 487976 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= 487976]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 487976 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= 487976

Título del libro: Spe Production And Operations Symposium, Proceedings
Título del capítulo: Integrated production operation solution applied in brown oil fields - AIATG asset PEMEX

Autores UNAM:
JORGE ARTURO YAÑEZ PONCE DE LEON;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2012

---

Palabras clave:

Abnormal conditions; Artificial lift; Automatic recognition; Brown fields; Daily production; Dispersion data; Engineering workflows; Integrated production; Key performance indicators; Me-xico; Natural flow; Operational data; Operational issues; Production network; Trend analysis; Web environment; Well productivity; Well test; Work-flows; Benchmarking; Oil fields; Oil wells; Visualization; Well testing; Wells; Integration

---

Resumen:

This paper presents the advances in the Integrated Production Operation Solution applied in Brown Fields from Activo Terciario del Golfo (AIATG) Asset PEMEX, located in The north-east of Mexico. AIATG has about 3377 wells, 2112 are producing, 948 of them in natural flow, 1164 in different artificial lift methods, and the remaining are closed. The total production is about 65004 BPD of oil and 149 MMFCD. Operational issues like, lack of well test event, poor well test by well, facilities constrains, production measured in conjunction with others sources, in combination with dispersion data the problems create a not trusty environment to detect abnormal conditions and events that impact directly in the production. In order to improve this process, AIATG has raised a new approach which allows consolidate the operational data base, to implement workflows for capturing from different sources daily production and operational data along the entire production network and facilities, and which will include engineering and smart validation rules and alarms notification across web environment, which this will permit to act in advance before a potential issue become in production loses. Additional features for trend analysis, visualization and management of key performance indicators will be integrated with engineering workflows, which the automatic recognition of issues and behavior of wells using calculated rates at the well level and their reconciled production compared to the measurement at the gathering station level. With this automatic workflow we can then identify any condition that has drastically affected well productivity. Copyright 2012, Society of Petroleum Engineers.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9781622761272
Editorial:

Tipo de producto:
Conference Paper