Find Purchasing Agent III Job in Lakewood, Colorado | Snaprecruit

Find Purchasing Agent Job in Lakewood, Colorado
image
  • Snapboard
  • Activity
  • Reports
  • Campaign
Welcome ,

Purchasing Agent III

  • ... Lakewood, Colorado, United States
  • ... Full time
  • ... Salary: 89652 per year
  • Posted on: Mar 12, 2024       Expires on: Apr 26, 2024

Purchasing Agent III   

JOB TITLE:

Purchasing Agent III

JOB TYPE:

Full-time

JOB LOCATION:

Lakewood Colorado United States

JOB DESCRIPTION:

Full job description

Department Information

This position is open only to Colorado state residents.

Please Note:
An eligible list established with this recruitment may be used to fill other similar positions within the Colorado Department of Public Safety in the next 12 months.

Although the full salary range for this position is provided, appointments are typically made at or near the range minimum.

Our Mission -
Engaged employees working together to safeguard lives and to provide diverse public safety services to local communities.
Our Vision - Creating safer and more resilient communities across Colorado.
Our Core Values Unity, Honor, Service

CDPS commits to cultivating an equitable, diverse, and inclusive work environment.
We ensure that we recruit, retain, and promote engaged employees.
Our approach to diversity is simple - it's about embracing everyone! We strive to build and nurture a culture where inclusiveness is a reflex, not an initiative.
Our strength is our promise to be inclusive with intentional strategies to welcome and uplift our employees to thrive - while building a more equitable workplace.
CDPS is an equal opportunity employer.
See our EEOD Utilization Report (2020)


Why Do I Love My Job at CDPS


At CDPS we nurture a centric culture driven by our commitment of creating a safer Colorado, an inclusive workplace where everyone can be their own authentic self.
We model a culture of collaboration, support and growth to our employees.
Our culture has public service focus, and we strive to provide innovative solutions and services to our fellow Coloradans!


Careers with a purpose:

If you are passionate about public safety service, and are eager to dedicate your career to serving Coloradans, this is the organization you want to join!
We are committed to providing public safety services to our fellow Coloradans in their times of greater needs such as: safety on our roads, preparing and mitigating environmental disasters, disaster recovery, combating crime, school safety, and victim recovery.
Youll have the opportunity to challenge yourself and acquire new capabilities to build a rewarding and fulfilling career while making a difference in our community!

When you join CDPS, you are joining a team of exceptional individuals and together you will be inspired, motivated and supported to become the best you can be.


Unmatched Benefits:

We highly value work life balance and offer excellent work-life programs, training, and professional development opportunities!

Did you know that only 15% of employers offer a defined contribution plan? CDPS offers unmatched retirement benefits including PERA Defined Benefit Plan or PERA Defined Contribution Plan, plus 401K and 457 plans.

The Employee Assistance Program (C-SEAP) is available in every region of the state.
It is our effort to support the well-being of employees and the workplace.
EAPs provide short-term counseling, referrals and resources, as well as training and organizational development services.

CDPS provides generous time off including 11 paid holidays per year plus vacation, sick leave, and wellness days.

Medical and dental options are available for permanent employees and their dependents.
We also offer short and long-term disability coverage, and life insurance that includes legal resources and discounts.

Additional benefits we offer include free ECO passes for qualifying State employees within the RTD service area, and reduced college tuition at CSU Global and DeVry University.


Description of Job

WORK ENVIRONMENT
  • Office operates between 7:00 am and 5:00 pm
  • Mostly sedentary
  • CDPS currently operates on a 2 day a week on-site requirement for employees.
    For employees outside the Denver metro area, the hybrid structure is determined on a case by case basis dependent upon the position's requirements, the employees location and the needs of the business unit manager.
    If you are referred for an interview and have questions, please reach out to your HR representative who can connect you with the Appointing Authority or address those with the hiring manager during the interview process
    .

KEY RESPONSIBILITY

Assists the CDPS Director of Purchasing and Contracts with implementation and maintenance of the agencys Group II procurement delegation and authority.
Serves as a resource to provide guidance and training for field, headquarters, and support staff regarding procurement practices, policies and rules.
Serves as the key advisor to the divisions on policy issues and as the liaison with the state and department regarding purchasing issues, procedures and policies.
Examines, evaluates, and creates appropriate systems to integrate all CDPS procurement functions.
Prepares all necessary documentation to support the purchasing operation including necessary solicitations (i.
e.
, requests for Proposals, documented quotes, Invitations for Bid); and utilizes the States automated systems.
Serves as a CDPS purchasing agent for departmental needs.
Applies working knowledge of Colorado Revised Statutes (CRS), procurement code, and fiscal rules for the procurement of goods and services.
Accesses the Colorado Operations Resource Engine (CORE) to ensure purchase order compliance and sound fiscal management/control.
Ensures compliance with Contract Management System (CMS) requirements Provides technical guidance in the preparation, implementation and review of solicitations for CDPS.
Coordinates and disseminates information to advise internal customers on proper solicitation procedural requirements to ensure that state and fiscal rules and procurement policy requirements are met.
Researches and confers with CDPS staff to evaluate solicitation specification and performance criteria.
Assist customers and vendors by providing guidance and objective feedback on solicitations and services.


Assists the CDPS Director of Purchasing and Contracts with implementation and maintenance of the agencys Group II procurement delegation and authority.
Serves as a resource to provide guidance and training for field, headquarters, and support staff regarding procurement practices, policies and rules.
Serves as the key advisor to the divisions on policy issues and as the liaison with the state and department regarding purchasing issues, procedures and policies.
Examines, evaluates, and creates appropriate systems to integrate all CDPS procurement functions.
Prepares all necessary documentation to support the purchasing operation including necessary solicitations (i.
e.
, requests for Proposals, documented quotes, Invitations for Bid); and utilizes the States automated systems.
Serves as a CDPS purchasing agent for departmental needs.
Applies working knowledge of Colorado Revised Statutes (CRS), procurement code, and fiscal rules for the procurement of goods and services.
Accesses the Colorado Operations Resource Engine (CORE) to ensure purchase order compliance and sound fiscal management/control.
Ensures compliance with Contract Management System (CMS) requirements.
Facilitates the communication of the CDPS solicitation policies by training and advising staff regarding the development and implementation of appropriate business practices.
Represents CDPS at meetings with public officials, government officials and other parties as required regarding issues as determined necessary.
Provides procurement program management for special projects as assigned.
Develops technical guidance documents such as Excel spreadsheets, policy handouts, and training PowerPoint programs.


Serves as a member of the EDO Disaster Response Finance Team (DRFT) augmenting the Incident Command and General Staffs Finance Section and supporting State Emergency Operations Center (SEOC) activities during activation and training events.
During Level 4 activations (day to day operations), this position is available remotely to support staff operations if necessary.
During Level 3 activations (Command and General Staff), this position conducts a virtual check in with the Finance section chief, remains available in a consultation role to support SEOC staff requirements, aid in decision making and may attend initial meetings in person.
During Level 2 activations (one or more state agencies involved), this position supports in-person augmenting the Finance Section based on requirements.
During Level 1 activations (one or more federal agencies involved), this position supports in-person augmenting the Finance Section based on requirements.
Participates in routine SEOC training events to gain and maintain proficiency with WebEOC functionality, SEOC processes and build relationships with key emergency management personnel.
Completes familiarization training on the National Incident Management System completing ICS 100, ICS 200, and ICS 300 (supervisory positions only, coordinated by DHSEM) training as part of the initial training requirements for incident command system familiarization, and additional ongoing position training identified by the SEOC Integrated Preparedness Coordinator.
Participates in State Emergency Operations Center (SEOC) activations and exercises as the EDO Procurement Liaison which entails physical presence in the SEOC during activations which may occur outside standard business hours.
This position will work alongside SEOC staff and leadership to analyze the purchasing needs of each particular activation and determines the tactical steps required for each emergency which includes obtaining emergency procurement declaration, achieving properly authorized procurements, and completing the required encumbrance process as soon as is practical.
This liaison role will evaluate communication needs and coordinate effective communication and information sharing between the SEOC and EDO Finance team members which includes developing, coordinating, implementing, training, and maintaining procurement procedures and workflow processes in support of the SEOC and providing technical assistance and purchasing service support to internal and external stakeholders.
Technical assistance includes providing guidance on financial, procurement, and contractual requirements and identifies alternative treatments if needed to achieve compliance.
This position will assist the SEOC with maintaining procurement rule co

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

MINIMUM QUALIFICATIONS (EDUCATION AND EXPERIENCE)

Six (6) years of professional experience in procurement.


OR SUBSTITUTION

Two (2) years of experience in procurement and Bachelors Degree.


PREFERRED QUALIFICATIONS AND/OR SPECIAL QUALIFICATIONS
  • Must possess a high level of accuracy and attention to detail and have a strong knowledge in how personnel and/or payroll systems (software) work.
  • Must be able to accurately interpret and coach others on simple to complex rules and regulations regarding purchasing guidlines
  • Must have excellent customer service skills and sensitivity and discretion with respect to confidential matters.
  • Experience in creating, maintaining, and producing reports.
  • Experience creating training materials.
  • Must be detail-oriented and have outstanding organizational skills with the ability to prioritize tasks.
  • Must be proficient with spreadsheet and word processing software.
  • Ability to multi-task and maintain a tracked workflow in order to put aside projects that do not have a ready solution for items that require immediate attention
  • Excellent interpersonal skills and intercultural competence.
  • Exceptional verbal, writing, and presentation skills.
  • Proficiency in Microsoft Office and Google Suite.

CONDITIONS OF EMPLOYMENT
  • Requires successful completion of an extensive background investigation including reference checks, a polygraph examination, and fingerprint based criminal background check is required.

APPEAL RIGHTS
If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination.
Also, if you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging.
Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for more information about the appeals process.
The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at www.
colorado.
gov/spb.
A standard appeal form is available at: www.
colorado.
gov/spb.
If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203.
Fax: 303-866-5038.
Phone: 303-866-3300.
The ten-day deadline and these appeal procedures also apply to all charges of discrimination.

Supplemental Information

NOTIFICATIONS
All correspondence regarding your status in the selection/examination process will be via email.
Include your current working email address on your application and check your email frequen

???errorPage.heading???

org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [update `job_archive_partner` set `alias`=?, `alternateJobEmail`=?, `archived`=?, campaign_id=?, `checkedAt`=?, `city`=?, `company_name`=?, `confirmedEmail`=?, country_id=?, `created_at`=?, `currentBoost`=?, `deleted`=?, `descUrl`=?, `description`=?, `dummy`=?, `dummy2`=?, `emailScraped`=?, `employerJobFeedId`=?, `employerJobURL`=?, `employment`=?, `exclude`=?, `inBoosted`=?, `industry`=?, `isExpired`=?, `jobBoard`=?, `jobEmail`=?, `jobOrigin`=?, `jobSyncDate`=?, `jobTags`=?, `lastUpdateAt`=?, `linkedin`=?, `notification_email`=?, `notifiedAt`=?, `partnerEmail`=?, `partnerJobFeedId`=?, `partnerJobURL`=?, `payment_type`=?, `position_id`=?, `pricingOption`=?, `qcFlag`=?, `qcReason`=?, `qualityAssuranceFlag`=?, `rate`=?, `referenceNumber`=?, `salary`=?, `salaryunit`=?, `snaprecruit_id`=?, `snapxSync`=?, `socialPilotBoost`=?, `state`=?, `tags`=?, `title`=?, `totalBoost`=?, `twitter`=?, user_id=?, `from_date`=?, `zipCode`=? where `id`=?]; nested exception is org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:648)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:394)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:90)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	at com.sun.proxy.$Proxy76.getUserDetails(Unknown Source)
	at net.jumpspire.app.webapp.taglib.CustomLabelTag.doStartTag(CustomLabelTag.java:47)
	at org.apache.jsp.WEB_002dINF.jsp.job.archive_002djob_jsp._jspx_meth_sp_005fcustomLabel_005f0(archive_002djob_jsp.java:6046)
	at org.apache.jsp.WEB_002dINF.jsp.job.archive_002djob_jsp._jspService(archive_002djob_jsp.java:643)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:82)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at net.jumpspire.core.webapp.filter.MessageFilter.doFilter(MessageFilter.java:48)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
	at org.apache.struts2.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:164)
	at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)
	at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:374)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:278)
	at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:236)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
	at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:192)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsExecuteFilter.doFilter(StrutsExecuteFilter.java:88)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:134)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:81)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareFilter.doFilter(StrutsPrepareFilter.java:82)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at net.jumpspire.core.webapp.filter.MessageFilter.doFilter(MessageFilter.java:48)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
	at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
	at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
	at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at net.jumpspire.core.webapp.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:75)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:139)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at psiprobe.Tomcat90AgentValve.invoke(Tomcat90AgentValve.java:35)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:688)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:375)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1639)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)
	... 154 more
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'pricingOption' at row 1
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2054)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 162 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'pricingOption' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4072)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2719)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2450)
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
	... 167 more