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 = '263759' 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 = '263759' 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 = '263759']
®
ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 263759 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= 263759]
SIIA Público
SISTEMA INTEGRAL DE INFORMACIÓN ACADÉMICA - PÚBLICO
Título del libro: 26th European Modeling And Simulation Symposium, Emss 2014 Título del capítulo: Approaching demand of cash transactions at bank branches
Autores UNAM: IDALIA FLORES DE LA MOTA;
Autores externos: Idioma: InglésAño de publicación: 2014Palabras clave:
Markov processes; Monte Carlo methods; Risk perception; Bank branches; Compound process; Generalized linear model; INLA; Simulation; Computer simulation
Resumen:
Trying to maintain a service level in many operations can result very expensive, especially if there are severe penalties due to a low level related with the service level objective. In such cases, we seek to achieve a goal even at the cost of significant loss in the operation efficiency. In particular, bank companies at their branches undertake transactions related to cash money as main service, so, not having available cash becomes a critical issue, which slightest consequence is the bank company prestige deterioration, and not only affectations for a specific branch. This paper has the purpose of establish an approach for cash transactions demand at bank branches, with perspectives that best fit, which helps to control the risk of stocking out of cash, setting up some parameters, e. g. branches' safety stock of cash, and projecting horizons of cash balances, given certain scenarios. The model we present is developed with frequentist and Bayesian perspectives, the last one is a 'recent' develop that covers in a more efficient way, the Markov Chain Monte Carlo (MCMC) simulations. So, by means a real evaluation, it will be estimated the accuracy level that can be got approaching the cash demand with each of these, in particular with the best.
Entidades citadas de la UNAM:
Fuente:
ISBN: 9788897999324 Editorial: Dime University of Genoa
