2018-04-23 16:02:20.803 INFO estContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [gov.va.ccrs.brengine.BatchProcessorAllRulesTest], using SpringBootContextLoader
2018-04-23 16:02:20.825 INFO AbstractContextLoader  - Could not detect default resource locations for test class [gov.va.ccrs.brengine.BatchProcessorAllRulesTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2018-04-23 16:02:20.825 INFO nfigContextLoaderUtils - Could not detect default configuration classes for test class [gov.va.ccrs.brengine.BatchProcessorAllRulesTest]: BatchProcessorAllRulesTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2018-04-23 16:02:21.141 INFO estContextBootstrapper - Found @SpringBootConfiguration gov.va.ccrs.brengine.BrEngineApplication for test class gov.va.ccrs.brengine.BatchProcessorAllRulesTest
2018-04-23 16:02:21.387 INFO estContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener]
2018-04-23 16:02:21.426 INFO estContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@306e95ec, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@52af26ee, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@6fd83fc1, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@4f2b503c, org.springframework.test.context.support.DirtiesContextTestExecutionListener@bae7dc0, org.springframework.test.context.transaction.TransactionalTestExecutionListener@209da20d, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@e15b7e8, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@1b2abca6, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@6392827e, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@2ed2d9cb, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@d5b810e, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@43dac38f]
2018-04-23 16:02:22.208 INFO hProcessorAllRulesTest - Starting BatchProcessorAllRulesTest on JX574H2 with PID 5884 (started by DWei in C:\Users\DWei\CCRS-BUSRULES\brengine)
2018-04-23 16:02:22.213 INFO hProcessorAllRulesTest - The following profiles are active: ut
2018-04-23 16:02:22.256 INFO nfigApplicationContext - Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@54eb2b70: startup date [Mon Apr 23 16:02:22 EDT 2018]; root of context hierarchy
2018-04-23 16:02:23.770 INFO ultListableBeanFactory - Overriding bean definition for bean 'authenticationManager' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=apiSecurityConfig; factoryMethodName=authenticationManager; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [gov/va/ccrs/brengine/security/ApiSecurityConfig.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=securityConfig; factoryMethodName=authenticationManager; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [gov/va/ccrs/brengine/security/SecurityConfig.class]]
2018-04-23 16:02:23.958 INFO ultListableBeanFactory - Overriding bean definition for bean 'dataSource' with a different definition: replacing [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Generic; factoryMethodName=dataSource; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Generic.class]] with [Root bean: class [null]; scope=; abstract=false; lazyInit=false; autowireMode=3; dependencyCheck=0; autowireCandidate=true; primary=false; factoryBeanName=org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari; factoryMethodName=dataSource; initMethodName=null; destroyMethodName=(inferred); defined in class path resource [org/springframework/boot/autoconfigure/jdbc/DataSourceConfiguration$Hikari.class]]
2018-04-23 16:02:25.557 INFO anPostProcessorChecker - Bean 'org.springframework.kafka.annotation.KafkaBootstrapConfiguration' of type [org.springframework.kafka.annotation.KafkaBootstrapConfiguration$$EnhancerBySpringCGLIB$$1fe23b0f] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-23 16:02:25.599 INFO anPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$4c30298c] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-23 16:02:26.340 INFO HikariDataSource       - HikariPool-1 - Starting...
2018-04-23 16:02:26.668 INFO HikariDataSource       - HikariPool-1 - Start completed.
2018-04-23 16:02:26.839 INFO tityManagerFactoryBean - Building JPA container EntityManagerFactory for persistence unit 'default'
2018-04-23 16:02:28.164 WARN RootClass              - HHH000038: Composite-id class does not override equals(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-23 16:02:28.174 WARN RootClass              - HHH000039: Composite-id class does not override hashCode(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-23 16:02:29.225 INFO tityManagerFactoryBean - Initialized JPA EntityManagerFactory for persistence unit 'default'
2018-04-23 16:02:30.904 INFO HoconUtils             - Loading config file from C:\Users\DWei\CCRS-BUSRULES\brengine\bin\main\rules-config.conf
2018-04-23 16:02:31.671 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-23 16:02:31.818 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-23 16:02:32.503 INFO ultSecurityFilterChain - Creating filter chain: Ant [pattern='/fetchDecisions/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5d5ae6aa, org.springframework.security.web.context.SecurityContextPersistenceFilter@407b41e6, org.springframework.security.web.header.HeaderWriterFilter@7a34c1f6, org.springframework.security.web.csrf.CsrfFilter@417446d9, org.springframework.security.web.authentication.logout.LogoutFilter@2773504f, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@3ba5c4dd, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@6cfd08e9, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@990b86b, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2bc2e022, org.springframework.security.web.session.SessionManagementFilter@3e998033, org.springframework.security.web.access.ExceptionTranslationFilter@433ae0b0, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@52290e63]
2018-04-23 16:02:32.554 INFO ultSecurityFilterChain - Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@d271a54, org.springframework.security.web.context.SecurityContextPersistenceFilter@66b40dd3, org.springframework.security.web.header.HeaderWriterFilter@5abc5854, org.springframework.security.web.authentication.logout.LogoutFilter@1191029d, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@774c5e5c, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@578d472a, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7296fe0b, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@4a5066f5, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@6ff8e744, org.springframework.security.web.session.SessionManagementFilter@5c3007d, org.springframework.security.web.access.ExceptionTranslationFilter@773c7147, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@56ba8e8c]
2018-04-23 16:02:32.900 INFO AbstractContextSource  - Property 'userDn' not set - anonymous context will be used for read-write operations
2018-04-23 16:02:34.247 INFO aultLifecycleProcessor - Starting beans in phase 2147483547
2018-04-23 16:02:34.298 INFO ConsumerConfig         - ConsumerConfig values: 
	auto.commit.interval.ms = 1000
	auto.offset.reset = latest
	bootstrap.servers = [localhost:9092]
	check.crcs = true
	client.id = 
	connections.max.idle.ms = 540000
	enable.auto.commit = true
	exclude.internal.topics = true
	fetch.max.bytes = 52428800
	fetch.max.wait.ms = 500
	fetch.min.bytes = 1
	group.id = brengine-batch-request
	heartbeat.interval.ms = 3000
	interceptor.classes = null
	internal.leave.group.on.close = true
	isolation.level = read_uncommitted
	key.deserializer = class org.apache.kafka.common.serialization.LongDeserializer
	max.partition.fetch.bytes = 1048576
	max.poll.interval.ms = 300000
	max.poll.records = 500
	metadata.max.age.ms = 300000
	metric.reporters = []
	metrics.num.samples = 2
	metrics.recording.level = INFO
	metrics.sample.window.ms = 30000
	partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor]
	receive.buffer.bytes = 65536
	reconnect.backoff.max.ms = 1000
	reconnect.backoff.ms = 50
	request.timeout.ms = 305000
	retry.backoff.ms = 100
	sasl.jaas.config = null
	sasl.kerberos.kinit.cmd = /usr/bin/kinit
	sasl.kerberos.min.time.before.relogin = 60000
	sasl.kerberos.service.name = null
	sasl.kerberos.ticket.renew.jitter = 0.05
	sasl.kerberos.ticket.renew.window.factor = 0.8
	sasl.mechanism = GSSAPI
	security.protocol = PLAINTEXT
	send.buffer.bytes = 131072
	session.timeout.ms = 10000
	ssl.cipher.suites = null
	ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1]
	ssl.endpoint.identification.algorithm = null
	ssl.key.password = null
	ssl.keymanager.algorithm = SunX509
	ssl.keystore.location = null
	ssl.keystore.password = null
	ssl.keystore.type = JKS
	ssl.protocol = TLS
	ssl.provider = null
	ssl.secure.random.implementation = null
	ssl.trustmanager.algorithm = PKIX
	ssl.truststore.location = null
	ssl.truststore.password = null
	ssl.truststore.type = JKS
	value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer

2018-04-23 16:02:34.414 INFO AppInfoParser          - Kafka version : 1.0.1
2018-04-23 16:02:34.415 INFO AppInfoParser          - Kafka commitId : c0518aa65f25317e
2018-04-23 16:02:34.425 INFO hreadPoolTaskScheduler - Initializing ExecutorService 
2018-04-23 16:02:34.433 INFO ConsumerConfig         - ConsumerConfig values: 
	auto.commit.interval.ms = 1000
	auto.offset.reset = latest
	bootstrap.servers = [localhost:9092]
	check.crcs = true
	client.id = 
	connections.max.idle.ms = 540000
	enable.auto.commit = true
	exclude.internal.topics = true
	fetch.max.bytes = 52428800
	fetch.max.wait.ms = 500
	fetch.min.bytes = 1
	group.id = brengine-icn-response
	heartbeat.interval.ms = 3000
	interceptor.classes = null
	internal.leave.group.on.close = true
	isolation.level = read_uncommitted
	key.deserializer = class org.apache.kafka.common.serialization.LongDeserializer
	max.partition.fetch.bytes = 1048576
	max.poll.interval.ms = 300000
	max.poll.records = 500
	metadata.max.age.ms = 300000
	metric.reporters = []
	metrics.num.samples = 2
	metrics.recording.level = INFO
	metrics.sample.window.ms = 30000
	partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor]
	receive.buffer.bytes = 65536
	reconnect.backoff.max.ms = 1000
	reconnect.backoff.ms = 50
	request.timeout.ms = 305000
	retry.backoff.ms = 100
	sasl.jaas.config = null
	sasl.kerberos.kinit.cmd = /usr/bin/kinit
	sasl.kerberos.min.time.before.relogin = 60000
	sasl.kerberos.service.name = null
	sasl.kerberos.ticket.renew.jitter = 0.05
	sasl.kerberos.ticket.renew.window.factor = 0.8
	sasl.mechanism = GSSAPI
	security.protocol = PLAINTEXT
	send.buffer.bytes = 131072
	session.timeout.ms = 10000
	ssl.cipher.suites = null
	ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1]
	ssl.endpoint.identification.algorithm = null
	ssl.key.password = null
	ssl.keymanager.algorithm = SunX509
	ssl.keystore.location = null
	ssl.keystore.password = null
	ssl.keystore.type = JKS
	ssl.protocol = TLS
	ssl.provider = null
	ssl.secure.random.implementation = null
	ssl.trustmanager.algorithm = PKIX
	ssl.truststore.location = null
	ssl.truststore.password = null
	ssl.truststore.type = JKS
	value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer

2018-04-23 16:02:34.439 INFO AppInfoParser          - Kafka version : 1.0.1
2018-04-23 16:02:34.439 INFO AppInfoParser          - Kafka commitId : c0518aa65f25317e
2018-04-23 16:02:34.440 INFO hreadPoolTaskScheduler - Initializing ExecutorService 
2018-04-23 16:02:34.441 INFO ConsumerConfig         - ConsumerConfig values: 
	auto.commit.interval.ms = 1000
	auto.offset.reset = latest
	bootstrap.servers = [localhost:9092]
	check.crcs = true
	client.id = 
	connections.max.idle.ms = 540000
	enable.auto.commit = true
	exclude.internal.topics = true
	fetch.max.bytes = 52428800
	fetch.max.wait.ms = 500
	fetch.min.bytes = 1
	group.id = test-string-listener
	heartbeat.interval.ms = 3000
	interceptor.classes = null
	internal.leave.group.on.close = true
	isolation.level = read_uncommitted
	key.deserializer = class org.apache.kafka.common.serialization.LongDeserializer
	max.partition.fetch.bytes = 1048576
	max.poll.interval.ms = 300000
	max.poll.records = 500
	metadata.max.age.ms = 300000
	metric.reporters = []
	metrics.num.samples = 2
	metrics.recording.level = INFO
	metrics.sample.window.ms = 30000
	partition.assignment.strategy = [class org.apache.kafka.clients.consumer.RangeAssignor]
	receive.buffer.bytes = 65536
	reconnect.backoff.max.ms = 1000
	reconnect.backoff.ms = 50
	request.timeout.ms = 305000
	retry.backoff.ms = 100
	sasl.jaas.config = null
	sasl.kerberos.kinit.cmd = /usr/bin/kinit
	sasl.kerberos.min.time.before.relogin = 60000
	sasl.kerberos.service.name = null
	sasl.kerberos.ticket.renew.jitter = 0.05
	sasl.kerberos.ticket.renew.window.factor = 0.8
	sasl.mechanism = GSSAPI
	security.protocol = PLAINTEXT
	send.buffer.bytes = 131072
	session.timeout.ms = 10000
	ssl.cipher.suites = null
	ssl.enabled.protocols = [TLSv1.2, TLSv1.1, TLSv1]
	ssl.endpoint.identification.algorithm = null
	ssl.key.password = null
	ssl.keymanager.algorithm = SunX509
	ssl.keystore.location = null
	ssl.keystore.password = null
	ssl.keystore.type = JKS
	ssl.protocol = TLS
	ssl.provider = null
	ssl.secure.random.implementation = null
	ssl.trustmanager.algorithm = PKIX
	ssl.truststore.location = null
	ssl.truststore.password = null
	ssl.truststore.type = JKS
	value.deserializer = class org.apache.kafka.common.serialization.StringDeserializer

2018-04-23 16:02:34.451 INFO AppInfoParser          - Kafka version : 1.0.1
2018-04-23 16:02:34.451 INFO AppInfoParser          - Kafka commitId : c0518aa65f25317e
2018-04-23 16:02:34.452 INFO hreadPoolTaskScheduler - Initializing ExecutorService 
2018-04-23 16:02:34.468 INFO ationBeanPostProcessor - No TaskScheduler/ScheduledExecutorService bean found for scheduled processing
2018-04-23 16:02:34.485 INFO hProcessorAllRulesTest - Started BatchProcessorAllRulesTest in 12.936 seconds (JVM running for 14.543)
2018-04-23 16:02:34.572 INFO ScriptUtils            - Executing SQL script from class path resource [sql/create_tables_h2.sql]
2018-04-23 16:02:34.964 INFO ScriptUtils            - Executed SQL script from class path resource [sql/create_tables_h2.sql] in 392 ms.
2018-04-23 16:02:34.966 INFO ScriptUtils            - Executing SQL script from class path resource [sql/populate_claim.sql]
2018-04-23 16:02:35.021 INFO ScriptUtils            - Executed SQL script from class path resource [sql/populate_claim.sql] in 55 ms.
2018-04-23 16:02:35.021 INFO ScriptUtils            - Executing SQL script from class path resource [sql/populate_edi_nonconforming.sql]
2018-04-23 16:02:35.025 INFO ScriptUtils            - Executed SQL script from class path resource [sql/populate_edi_nonconforming.sql] in 3 ms.
Hibernate: 
    select
        batchinfo0_.etl_batch_id as etl_batc1_16_0_,
        batchinfo0_.batch_status as batch_st2_16_0_,
        batchinfo0_.last_updated_user as last_upd3_16_0_,
        batchinfo0_.end_date_time as end_date4_16_0_,
        batchinfo0_.source_system as source_s5_16_0_,
        batchinfo0_.last_updated_date as last_upd6_16_0_ 
    from
        claim_batch_log batchinfo0_ 
    where
        batchinfo0_.etl_batch_id=?
Hibernate: 
    /* insert gov.va.ccrs.brengine.processing.ProcessingTracker
        */ insert 
        into
            rules_batch_log
            (rules_batch_log_key, etl_batch_id, claim_type, engine_version, error, end_date_time, hostname, resume_mode, last_updated_user, number_of_claims, number_of_failures, number_of_lines, number_of_processed_claims, number_of_processed_lines, number_of_waiting_for_data, rule_names, environment_name, start_date_time, status, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.BatchInfo */ select
        batchinfo0_.etl_batch_id as etl_batc1_16_0_,
        batchinfo0_.batch_status as batch_st2_16_0_,
        batchinfo0_.last_updated_user as last_upd3_16_0_,
        batchinfo0_.end_date_time as end_date4_16_0_,
        batchinfo0_.source_system as source_s5_16_0_,
        batchinfo0_.last_updated_date as last_upd6_16_0_ 
    from
        claim_batch_log batchinfo0_ 
    where
        batchinfo0_.etl_batch_id=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.BatchInfo */ update
            claim_batch_log 
        set
            batch_status=?,
            last_updated_user=?,
            end_date_time=?,
            source_system=?,
            last_updated_date=? 
        where
            etl_batch_id=?
2018-04-23 16:02:35.331 INFO ncExecutionInterceptor - No task executor bean found for async processing: no bean of type TaskExecutor and no bean named 'taskExecutor' either
2018-04-23 16:02:35.331 INFO BatchProcessor         - Starting processing of batchId 'prof_batch_2'
2018-04-23 16:02:35.331 INFO tationBasedRuleFactory - Found the following rule beans annotated with gov.va.ccrs.brengine.rule.annotation.RuleFactoryBean
[]
2018-04-23 16:02:35.331 INFO tationBasedRuleFactory - Found the following rule beans annotated with gov.va.ccrs.brengine.rule.annotation.RuleBean
[referralRules, dollarThresholdRule, duplicateRules, episodeRules, icnRule, leieRule, paymentAuthorityRules, timelyFilingRule]
2018-04-23 16:02:35.331 INFO BatchProcessor         - Number of rules used for processing: 8
2018-04-23 16:02:35.331 INFO BatchProcessor         - Rules:
[gov.va.ccrs.brengine.rule.referral.ReferralRules@398f0516, gov.va.ccrs.brengine.rule.dollarthreshold.DollarThresholdRule@248b2b61, gov.va.ccrs.brengine.rule.duplicate.DuplicateRules@68df8c6, gov.va.ccrs.brengine.rule.seoc.EpisodeRules@4d664323, gov.va.ccrs.brengine.rule.icn.IcnRule@1eb6037d, gov.va.ccrs.brengine.rule.leie.LeieRule@7cbf4f8c, gov.va.ccrs.brengine.rule.paymentauthority.PaymentAuthorityRules@68479e8b, gov.va.ccrs.brengine.rule.timelyfiling.TimelyFilingRule@b2da3a5]
2018-04-23 16:02:35.347 INFO BatchProcessor         - Updating status of batch 'prof_batch_2' to RULES_INIT
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.ProcessingTracker */ select
        processing0_.rules_batch_log_key as rules_ba1_38_0_,
        processing0_.etl_batch_id as etl_batc2_38_0_,
        processing0_.claim_type as claim_ty3_38_0_,
        processing0_.engine_version as engine_v4_38_0_,
        processing0_.error as error5_38_0_,
        processing0_.end_date_time as end_date6_38_0_,
        processing0_.hostname as hostname7_38_0_,
        processing0_.resume_mode as resume_m8_38_0_,
        processing0_.last_updated_user as last_upd9_38_0_,
        processing0_.number_of_claims as number_10_38_0_,
        processing0_.number_of_failures as number_11_38_0_,
        processing0_.number_of_lines as number_12_38_0_,
        processing0_.number_of_processed_claims as number_13_38_0_,
        processing0_.number_of_processed_lines as number_14_38_0_,
        processing0_.number_of_waiting_for_data as number_15_38_0_,
        processing0_.rule_names as rule_na16_38_0_,
        processing0_.environment_name as environ17_38_0_,
        processing0_.start_date_time as start_d18_38_0_,
        processing0_.status as status19_38_0_,
        processing0_.last_updated_date_time as last_up20_38_0_ 
    from
        rules_batch_log processing0_ 
    where
        processing0_.rules_batch_log_key=?
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.BatchInfo */ select
        batchinfo0_.etl_batch_id as etl_batc1_16_0_,
        batchinfo0_.batch_status as batch_st2_16_0_,
        batchinfo0_.last_updated_user as last_upd3_16_0_,
        batchinfo0_.end_date_time as end_date4_16_0_,
        batchinfo0_.source_system as source_s5_16_0_,
        batchinfo0_.last_updated_date as last_upd6_16_0_ 
    from
        claim_batch_log batchinfo0_ 
    where
        batchinfo0_.etl_batch_id=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.ProcessingTracker */ update
            rules_batch_log 
        set
            etl_batch_id=?,
            claim_type=?,
            engine_version=?,
            error=?,
            end_date_time=?,
            hostname=?,
            resume_mode=?,
            last_updated_user=?,
            number_of_claims=?,
            number_of_failures=?,
            number_of_lines=?,
            number_of_processed_claims=?,
            number_of_processed_lines=?,
            number_of_waiting_for_data=?,
            rule_names=?,
            environment_name=?,
            start_date_time=?,
            status=?,
            last_updated_date_time=? 
        where
            rules_batch_log_key=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.BatchInfo */ update
            claim_batch_log 
        set
            batch_status=?,
            last_updated_user=?,
            end_date_time=?,
            source_system=?,
            last_updated_date=? 
        where
            etl_batch_id=?
Hibernate: 
    /* select
        generatedAlias0 
    from
        DollarThreshold as generatedAlias0 */ select
            dollarthre0_.charge_amount_threshold_key as charge_a1_13_,
            dollarthre0_.claim_type as claim_ty2_13_,
            dollarthre0_.last_updated_user as last_upd3_13_,
            dollarthre0_.threshold_amount as threshol4_13_,
            dollarthre0_.last_updated_date_time as last_upd5_13_ 
        from
            rules.charge_amount_threshold dollarthre0_
2018-04-23 16:02:35.378 INFO BatchProcessor         - Deleting all prior outcomes/decisions for the batch, if any
Hibernate: 
    /* delete 
    from
        ValidationFailure vf 
    where
        vf.decision.key in (
            select
                key 
            from
                Decision d 
            where
                d.batchId= ?1 
                and d.decisionType != 'REJECTED' 
        ) */ delete 
        from
            validation_failure 
        where
            decision_key in (
                select
                    decision1_.decision_key 
                from
                    decision decision1_ 
                where
                    decision1_.etl_batch_id=? 
                    and decision1_.decision<>'REJECTED'
            )
Hibernate: 
    /* delete 
    from
        Decision d 
    where
        d.batchId= ?1 
        and d.decisionType != 'REJECTED' */ delete 
        from
            decision 
        where
            etl_batch_id=? 
            and decision<>'REJECTED'
2018-04-23 16:02:35.431 INFO DecisionDaoImpl        - Deleted 0 decisions and 0 failures for batchId prof_batch_2
2018-04-23 16:02:35.446 INFO BatchProcessor         - Loading all claims for the batch prof_batch_2
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType formType 
    join
        fetch c.profClaimLines line 
    left join
        fetch c.billingProvider billProv 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch billProv.locations 
    left join
        fetch c.patient patient 
    left join
        fetch line.placeOfService 
    left join
        fetch line.renderingProvider rendProv 
    left join
        fetch rendProv.locations 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers modifier 
    where
        c.isCurrent=true 
        and line.isCurrent=true 
        and (
            modifier is null 
            or modifier.isCurrent=true 
        ) 
        and formType.code='837P' 
        and line.key not in (
            select
                claimLineKey 
            from
                Decision d 
            where
                d.claim.key=c.key
        ) 
        and c.batchId=?1 */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser7_.pos_key as pos_key1_27_3_,
            provider8_.provider_key as provider1_29_4_,
            locations9_.provider_location_key as provider1_37_5_,
            procedure10_.procedure_key as procedur1_28_6_,
            modifiers11_.claim_line_modifier_key as claim_li1_19_7_,
            provider3_.provider_key as provider1_29_8_,
            locations5_.provider_location_key as provider1_37_9_,
            provider4_.provider_key as provider1_29_10_,
            patient6_.patient_key as patient_1_25_11_,
            claim0_.etl_batch_id as etl_batc2_30_0_,
            claim0_.billing_provider_key as billing16_30_0_,
            claim0_.ccn_region as ccn_regi3_30_0_,
            claim0_.charge_amount as charge_a4_30_0_,
            claim0_.claim_id as claim_id5_30_0_,
            claim0_.end_date as end_date6_30_0_,
            claim0_.form_type_key as form_ty17_30_0_,
            claim0_.is_current as is_curre7_30_0_,
            claim0_.last_updated_date as last_upd8_30_0_,
            claim0_.other_insurance as other_in9_30_0_,
            claim0_.patient_key as patient18_30_0_,
            claim0_.patient_account_number as patient10_30_0_,
            claim0_.preauth_number as preauth11_30_0_,
            claim0_.claim_receipt_date as claim_r12_30_0_,
            claim0_.referral_number as referra13_30_0_,
            claim0_.referring_provider_key as referri19_30_0_,
            claim0_.rendering_provider_key as renderi20_30_0_,
            claim0_.source_system as source_14_30_0_,
            claim0_.start_date as start_d15_30_0_,
            claim0_.station_key as station21_30_0_,
            formtype1_.form_code as form_cod2_22_1_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser7_.pos_code as pos_code2_27_3_,
            provider8_.provider_name as provider2_29_4_,
            provider8_.npi as npi3_29_4_,
            provider8_.tax_id as tax_id4_29_4_,
            locations9_.address1 as address2_37_5_,
            locations9_.city as city3_37_5_,
            locations9_.country_code as country_4_37_5_,
            locations9_.postal_code as postal_c5_37_5_,
            locations9_.provider_key as provider8_37_5_,
            locations9_.provider_phone as provider6_37_5_,
            locations9_.state_long_name as state_lo7_37_5_,
            locations9_.provider_key as provider8_37_1__,
            locations9_.provider_location_key as provider1_37_1__,
            procedure10_.procedure_code as procedur2_28_6_,
            procedure10_.short_description as short_de3_28_6_,
            modifiers11_.modifier_code as modifier2_19_7_,
            modifiers11_.claim_detail_key_dt as claim_de4_19_7_,
            modifiers11_.claim_detail_key_in as claim_de5_19_7_,
            modifiers11_.is_current as is_curre3_19_7_,
            modifiers11_.claim_detail_key_pr as claim_de6_19_7_,
            modifiers11_.claim_detail_key_pr as claim_de6_19_2__,
            modifiers11_.claim_line_modifier_key as claim_li1_19_2__,
            provider3_.provider_name as provider2_29_8_,
            provider3_.npi as npi3_29_8_,
            provider3_.tax_id as tax_id4_29_8_,
            locations5_.address1 as address2_37_9_,
            locations5_.city as city3_37_9_,
            locations5_.country_code as country_4_37_9_,
            locations5_.postal_code as postal_c5_37_9_,
            locations5_.provider_key as provider8_37_9_,
            locations5_.provider_phone as provider6_37_9_,
            locations5_.state_long_name as state_lo7_37_9_,
            locations5_.provider_key as provider8_37_3__,
            locations5_.provider_location_key as provider1_37_3__,
            provider4_.provider_name as provider2_29_10_,
            provider4_.npi as npi3_29_10_,
            provider4_.tax_id as tax_id4_29_10_,
            patient6_.address1 as address2_25_11_,
            patient6_.address2 as address3_25_11_,
            patient6_.etl_batch_id as etl_batc4_25_11_,
            patient6_.city as city5_25_11_,
            patient6_.date_of_birth as date_of_6_25_11_,
            patient6_.first_name as first_na7_25_11_,
            patient6_.icn as icn8_25_11_,
            patient6_.insured_id as insured_9_25_11_,
            patient6_.last_name as last_na10_25_11_,
            patient6_.member_id as member_11_25_11_,
            patient6_.middle_initial as middle_12_25_11_,
            patient6_.postal_code as postal_13_25_11_,
            patient6_.sex as sex14_25_11_,
            patient6_.ssn as ssn15_25_11_,
            patient6_.state_code as state_c16_25_11_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser7_ 
                on profclaiml2_.pos_key=placeofser7_.pos_key 
        left outer join
            dim_provider provider8_ 
                on profclaiml2_.rendering_provider_key=provider8_.provider_key 
        left outer join
            provider_location locations9_ 
                on provider8_.provider_key=locations9_.provider_key 
        left outer join
            dim_procedure_code procedure10_ 
                on profclaiml2_.procedure_key=procedure10_.procedure_key 
        left outer join
            claim_line_modifier modifiers11_ 
                on profclaiml2_.claim_detail_key=modifiers11_.claim_detail_key_pr 
        left outer join
            dim_provider provider3_ 
                on claim0_.billing_provider_key=provider3_.provider_key 
        left outer join
            provider_location locations5_ 
                on provider3_.provider_key=locations5_.provider_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.rendering_provider_key=provider4_.provider_key 
        left outer join
            dim_patient patient6_ 
                on claim0_.patient_key=patient6_.patient_key 
        where
            claim0_.is_current='Y' 
            and profclaiml2_.is_current='Y' 
            and (
                modifiers11_.claim_line_modifier_key is null 
                or modifiers11_.is_current='Y'
            ) 
            and formtype1_.form_code='837P' 
            and (
                profclaiml2_.claim_detail_key not in  (
                    select
                        decision12_.claim_detail_key 
                    from
                        decision decision12_ 
                    where
                        decision12_.claim_key=claim0_.claim_key
                )
            ) 
            and claim0_.etl_batch_id=?
2018-04-23 16:02:35.581 INFO BatchProcessor         - Loaded 3 claims 4 lines
2018-04-23 16:02:35.581 INFO BatchProcessor         - Updating status of batch 'prof_batch_2' to RULES_IN_PROCESS
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.ProcessingTracker */ select
        processing0_.rules_batch_log_key as rules_ba1_38_0_,
        processing0_.etl_batch_id as etl_batc2_38_0_,
        processing0_.claim_type as claim_ty3_38_0_,
        processing0_.engine_version as engine_v4_38_0_,
        processing0_.error as error5_38_0_,
        processing0_.end_date_time as end_date6_38_0_,
        processing0_.hostname as hostname7_38_0_,
        processing0_.resume_mode as resume_m8_38_0_,
        processing0_.last_updated_user as last_upd9_38_0_,
        processing0_.number_of_claims as number_10_38_0_,
        processing0_.number_of_failures as number_11_38_0_,
        processing0_.number_of_lines as number_12_38_0_,
        processing0_.number_of_processed_claims as number_13_38_0_,
        processing0_.number_of_processed_lines as number_14_38_0_,
        processing0_.number_of_waiting_for_data as number_15_38_0_,
        processing0_.rule_names as rule_na16_38_0_,
        processing0_.environment_name as environ17_38_0_,
        processing0_.start_date_time as start_d18_38_0_,
        processing0_.status as status19_38_0_,
        processing0_.last_updated_date_time as last_up20_38_0_ 
    from
        rules_batch_log processing0_ 
    where
        processing0_.rules_batch_log_key=?
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.BatchInfo */ select
        batchinfo0_.etl_batch_id as etl_batc1_16_0_,
        batchinfo0_.batch_status as batch_st2_16_0_,
        batchinfo0_.last_updated_user as last_upd3_16_0_,
        batchinfo0_.end_date_time as end_date4_16_0_,
        batchinfo0_.source_system as source_s5_16_0_,
        batchinfo0_.last_updated_date as last_upd6_16_0_ 
    from
        claim_batch_log batchinfo0_ 
    where
        batchinfo0_.etl_batch_id=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.ProcessingTracker */ update
            rules_batch_log 
        set
            etl_batch_id=?,
            claim_type=?,
            engine_version=?,
            error=?,
            end_date_time=?,
            hostname=?,
            resume_mode=?,
            last_updated_user=?,
            number_of_claims=?,
            number_of_failures=?,
            number_of_lines=?,
            number_of_processed_claims=?,
            number_of_processed_lines=?,
            number_of_waiting_for_data=?,
            rule_names=?,
            environment_name=?,
            start_date_time=?,
            status=?,
            last_updated_date_time=? 
        where
            rules_batch_log_key=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.BatchInfo */ update
            claim_batch_log 
        set
            batch_status=?,
            last_updated_user=?,
            end_date_time=?,
            source_system=?,
            last_updated_date=? 
        where
            etl_batch_id=?
2018-04-23 16:02:35.581 INFO BatchProcessor         - Starting 3 threads to process the batch prof_batch_2
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.profClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch c.patient pt 
    left join
        fetch line.placeOfService 
    left join
        fetch line.renderingProvider 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) 
        and c.sourceSystem = 'EDI' */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser7_.pos_key as pos_key1_27_3_,
            provider8_.provider_key as provider1_29_4_,
            procedure9_.procedure_key as procedur1_28_5_,
            modifiers10_.claim_line_modifier_key as claim_li1_19_6_,
            decisions3_.decision_key as decision1_21_7_,
            provider4_.provider_key as provider1_29_8_,
            provider5_.provider_key as provider1_29_9_,
            patient6_.patient_key as patient_1_25_10_,
            claim0_.etl_batch_id as etl_batc2_30_0_,
            claim0_.billing_provider_key as billing16_30_0_,
            claim0_.ccn_region as ccn_regi3_30_0_,
            claim0_.charge_amount as charge_a4_30_0_,
            claim0_.claim_id as claim_id5_30_0_,
            claim0_.end_date as end_date6_30_0_,
            claim0_.form_type_key as form_ty17_30_0_,
            claim0_.is_current as is_curre7_30_0_,
            claim0_.last_updated_date as last_upd8_30_0_,
            claim0_.other_insurance as other_in9_30_0_,
            claim0_.patient_key as patient18_30_0_,
            claim0_.patient_account_number as patient10_30_0_,
            claim0_.preauth_number as preauth11_30_0_,
            claim0_.claim_receipt_date as claim_r12_30_0_,
            claim0_.referral_number as referra13_30_0_,
            claim0_.referring_provider_key as referri19_30_0_,
            claim0_.rendering_provider_key as renderi20_30_0_,
            claim0_.source_system as source_14_30_0_,
            claim0_.start_date as start_d15_30_0_,
            claim0_.station_key as station21_30_0_,
            formtype1_.form_code as form_cod2_22_1_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser7_.pos_code as pos_code2_27_3_,
            provider8_.provider_name as provider2_29_4_,
            provider8_.npi as npi3_29_4_,
            provider8_.tax_id as tax_id4_29_4_,
            procedure9_.procedure_code as procedur2_28_5_,
            procedure9_.short_description as short_de3_28_5_,
            modifiers10_.modifier_code as modifier2_19_6_,
            modifiers10_.claim_detail_key_dt as claim_de4_19_6_,
            modifiers10_.claim_detail_key_in as claim_de5_19_6_,
            modifiers10_.is_current as is_curre3_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_1__,
            modifiers10_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_7_,
            decisions3_.claim_key as claim_ke8_21_7_,
            decisions3_.claim_detail_key as claim_de3_21_7_,
            decisions3_.decision_date_time as decision4_21_7_,
            decisions3_.decision as decision5_21_7_,
            decisions3_.last_updated_user as last_upd6_21_7_,
            decisions3_.last_updated_date_time as last_upd7_21_7_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_8_,
            provider4_.npi as npi3_29_8_,
            provider4_.tax_id as tax_id4_29_8_,
            provider5_.provider_name as provider2_29_9_,
            provider5_.npi as npi3_29_9_,
            provider5_.tax_id as tax_id4_29_9_,
            patient6_.address1 as address2_25_10_,
            patient6_.address2 as address3_25_10_,
            patient6_.etl_batch_id as etl_batc4_25_10_,
            patient6_.city as city5_25_10_,
            patient6_.date_of_birth as date_of_6_25_10_,
            patient6_.first_name as first_na7_25_10_,
            patient6_.icn as icn8_25_10_,
            patient6_.insured_id as insured_9_25_10_,
            patient6_.last_name as last_na10_25_10_,
            patient6_.member_id as member_11_25_10_,
            patient6_.middle_initial as middle_12_25_10_,
            patient6_.postal_code as postal_13_25_10_,
            patient6_.sex as sex14_25_10_,
            patient6_.ssn as ssn15_25_10_,
            patient6_.state_code as state_c16_25_10_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser7_ 
                on profclaiml2_.pos_key=placeofser7_.pos_key 
        left outer join
            dim_provider provider8_ 
                on profclaiml2_.rendering_provider_key=provider8_.provider_key 
        left outer join
            dim_procedure_code procedure9_ 
                on profclaiml2_.procedure_key=procedure9_.procedure_key 
        left outer join
            claim_line_modifier modifiers10_ 
                on profclaiml2_.claim_detail_key=modifiers10_.claim_detail_key_pr 
        inner join
            decision decisions3_ 
                on claim0_.claim_key=decisions3_.claim_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.billing_provider_key=provider4_.provider_key 
        left outer join
            dim_provider provider5_ 
                on claim0_.rendering_provider_key=provider5_.provider_key 
        left outer join
            dim_patient patient6_ 
                on claim0_.patient_key=patient6_.patient_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            ) 
            and claim0_.source_system='EDI'
Hibernate: 
    /* select
        distinct r 
    from
        Referral r 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber */ select
            distinct referral0_.referral_key as referral1_10_0_,
            preauthori1_.preauthorization_key as preautho1_8_1_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            preauthori1_.date_from as date_fro2_8_1_,
            preauthori1_.date_to as date_to3_8_1_,
            preauthori1_.preauthorization_number as preautho4_8_1_,
            preauthori1_.referral_key as referral5_8_1_,
            preauthori1_.referral_key as referral5_8_0__,
            preauthori1_.preauthorization_key as preautho1_8_0__ 
        from
            ccra.referral referral0_ 
        left outer join
            ccra.preauthorization preauthori1_ 
                on referral0_.referral_key=preauthori1_.referral_key 
        where
            referral0_.referral_number=?
Hibernate: 
    select
        preauthori0_.preauthorization_key as preautho5_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_1_,
        preauthori0_.preauthorization_key as preautho5_9_1_,
        preauthori0_.preauthorized_service as preautho2_9_1_,
        preauthori0_.quantity as quantity3_9_1_,
        preauthori0_.subcategory as subcateg4_9_1_,
        orderset1_.orderset_key as orderset1_3_2_,
        orderset1_.code as code2_3_2_,
        orderset1_.order_set_description as order_se3_3_2_,
        orderset1_.pre_authorization_detail_key as pre_auth4_3_2_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset1_4_0_,
        ordersetda0_.date_from as date_fro2_4_0_,
        ordersetda1_.orderset_date_key as orderset3_5_1_,
        ordersetda1_.orderset_date_item_key as orderset1_5_1_,
        ordersetda1_.orderset_date_item_key as orderset1_5_2_,
        ordersetda1_.orderset_date_key as orderset3_5_2_,
        ordersetda1_.procedure_code as procedur2_5_2_,
        orderset2_.orderset_key as orderset1_3_3_,
        orderset2_.code as code2_3_3_,
        orderset2_.order_set_description as order_se3_3_3_,
        orderset2_.pre_authorization_detail_key as pre_auth4_3_3_ 
    from
        ccra.ordersetdate ordersetda0_ 
    left outer join
        ccra.ordersetdateitem ordersetda1_ 
            on ordersetda0_.orderset_date_key=ordersetda1_.orderset_date_key 
    left outer join
        ccra.orderset orderset2_ 
            on ordersetda0_.orderset_date_key=orderset2_.orderset_key 
    where
        ordersetda0_.orderset_date_key=?
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.profClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch c.patient pt 
    left join
        fetch line.placeOfService 
    left join
        fetch line.renderingProvider 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) 
        and c.sourceSystem = 'EDI' */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser7_.pos_key as pos_key1_27_3_,
            provider8_.provider_key as provider1_29_4_,
            procedure9_.procedure_key as procedur1_28_5_,
            modifiers10_.claim_line_modifier_key as claim_li1_19_6_,
            decisions3_.decision_key as decision1_21_7_,
            provider4_.provider_key as provider1_29_8_,
            provider5_.provider_key as provider1_29_9_,
            patient6_.patient_key as patient_1_25_10_,
            claim0_.etl_batch_id as etl_batc2_30_0_,
            claim0_.billing_provider_key as billing16_30_0_,
            claim0_.ccn_region as ccn_regi3_30_0_,
            claim0_.charge_amount as charge_a4_30_0_,
            claim0_.claim_id as claim_id5_30_0_,
            claim0_.end_date as end_date6_30_0_,
            claim0_.form_type_key as form_ty17_30_0_,
            claim0_.is_current as is_curre7_30_0_,
            claim0_.last_updated_date as last_upd8_30_0_,
            claim0_.other_insurance as other_in9_30_0_,
            claim0_.patient_key as patient18_30_0_,
            claim0_.patient_account_number as patient10_30_0_,
            claim0_.preauth_number as preauth11_30_0_,
            claim0_.claim_receipt_date as claim_r12_30_0_,
            claim0_.referral_number as referra13_30_0_,
            claim0_.referring_provider_key as referri19_30_0_,
            claim0_.rendering_provider_key as renderi20_30_0_,
            claim0_.source_system as source_14_30_0_,
            claim0_.start_date as start_d15_30_0_,
            claim0_.station_key as station21_30_0_,
            formtype1_.form_code as form_cod2_22_1_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser7_.pos_code as pos_code2_27_3_,
            provider8_.provider_name as provider2_29_4_,
            provider8_.npi as npi3_29_4_,
            provider8_.tax_id as tax_id4_29_4_,
            procedure9_.procedure_code as procedur2_28_5_,
            procedure9_.short_description as short_de3_28_5_,
            modifiers10_.modifier_code as modifier2_19_6_,
            modifiers10_.claim_detail_key_dt as claim_de4_19_6_,
            modifiers10_.claim_detail_key_in as claim_de5_19_6_,
            modifiers10_.is_current as is_curre3_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_1__,
            modifiers10_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_7_,
            decisions3_.claim_key as claim_ke8_21_7_,
            decisions3_.claim_detail_key as claim_de3_21_7_,
            decisions3_.decision_date_time as decision4_21_7_,
            decisions3_.decision as decision5_21_7_,
            decisions3_.last_updated_user as last_upd6_21_7_,
            decisions3_.last_updated_date_time as last_upd7_21_7_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_8_,
            provider4_.npi as npi3_29_8_,
            provider4_.tax_id as tax_id4_29_8_,
            provider5_.provider_name as provider2_29_9_,
            provider5_.npi as npi3_29_9_,
            provider5_.tax_id as tax_id4_29_9_,
            patient6_.address1 as address2_25_10_,
            patient6_.address2 as address3_25_10_,
            patient6_.etl_batch_id as etl_batc4_25_10_,
            patient6_.city as city5_25_10_,
            patient6_.date_of_birth as date_of_6_25_10_,
            patient6_.first_name as first_na7_25_10_,
            patient6_.icn as icn8_25_10_,
            patient6_.insured_id as insured_9_25_10_,
            patient6_.last_name as last_na10_25_10_,
            patient6_.member_id as member_11_25_10_,
            patient6_.middle_initial as middle_12_25_10_,
            patient6_.postal_code as postal_13_25_10_,
            patient6_.sex as sex14_25_10_,
            patient6_.ssn as ssn15_25_10_,
            patient6_.state_code as state_c16_25_10_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser7_ 
                on profclaiml2_.pos_key=placeofser7_.pos_key 
        left outer join
            dim_provider provider8_ 
                on profclaiml2_.rendering_provider_key=provider8_.provider_key 
        left outer join
            dim_procedure_code procedure9_ 
                on profclaiml2_.procedure_key=procedure9_.procedure_key 
        left outer join
            claim_line_modifier modifiers10_ 
                on profclaiml2_.claim_detail_key=modifiers10_.claim_detail_key_pr 
        inner join
            decision decisions3_ 
                on claim0_.claim_key=decisions3_.claim_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.billing_provider_key=provider4_.provider_key 
        left outer join
            dim_provider provider5_ 
                on claim0_.rendering_provider_key=provider5_.provider_key 
        left outer join
            dim_patient patient6_ 
                on claim0_.patient_key=patient6_.patient_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            ) 
            and claim0_.source_system='EDI'
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.profClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch c.patient pt 
    left join
        fetch line.placeOfService 
    left join
        fetch line.renderingProvider 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) 
        and c.sourceSystem = 'EDI' */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser7_.pos_key as pos_key1_27_3_,
            provider8_.provider_key as provider1_29_4_,
            procedure9_.procedure_key as procedur1_28_5_,
            modifiers10_.claim_line_modifier_key as claim_li1_19_6_,
            decisions3_.decision_key as decision1_21_7_,
            provider4_.provider_key as provider1_29_8_,
            provider5_.provider_key as provider1_29_9_,
            patient6_.patient_key as patient_1_25_10_,
            claim0_.etl_batch_id as etl_batc2_30_0_,
            claim0_.billing_provider_key as billing16_30_0_,
            claim0_.ccn_region as ccn_regi3_30_0_,
            claim0_.charge_amount as charge_a4_30_0_,
            claim0_.claim_id as claim_id5_30_0_,
            claim0_.end_date as end_date6_30_0_,
            claim0_.form_type_key as form_ty17_30_0_,
            claim0_.is_current as is_curre7_30_0_,
            claim0_.last_updated_date as last_upd8_30_0_,
            claim0_.other_insurance as other_in9_30_0_,
            claim0_.patient_key as patient18_30_0_,
            claim0_.patient_account_number as patient10_30_0_,
            claim0_.preauth_number as preauth11_30_0_,
            claim0_.claim_receipt_date as claim_r12_30_0_,
            claim0_.referral_number as referra13_30_0_,
            claim0_.referring_provider_key as referri19_30_0_,
            claim0_.rendering_provider_key as renderi20_30_0_,
            claim0_.source_system as source_14_30_0_,
            claim0_.start_date as start_d15_30_0_,
            claim0_.station_key as station21_30_0_,
            formtype1_.form_code as form_cod2_22_1_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser7_.pos_code as pos_code2_27_3_,
            provider8_.provider_name as provider2_29_4_,
            provider8_.npi as npi3_29_4_,
            provider8_.tax_id as tax_id4_29_4_,
            procedure9_.procedure_code as procedur2_28_5_,
            procedure9_.short_description as short_de3_28_5_,
            modifiers10_.modifier_code as modifier2_19_6_,
            modifiers10_.claim_detail_key_dt as claim_de4_19_6_,
            modifiers10_.claim_detail_key_in as claim_de5_19_6_,
            modifiers10_.is_current as is_curre3_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_6_,
            modifiers10_.claim_detail_key_pr as claim_de6_19_1__,
            modifiers10_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_7_,
            decisions3_.claim_key as claim_ke8_21_7_,
            decisions3_.claim_detail_key as claim_de3_21_7_,
            decisions3_.decision_date_time as decision4_21_7_,
            decisions3_.decision as decision5_21_7_,
            decisions3_.last_updated_user as last_upd6_21_7_,
            decisions3_.last_updated_date_time as last_upd7_21_7_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_8_,
            provider4_.npi as npi3_29_8_,
            provider4_.tax_id as tax_id4_29_8_,
            provider5_.provider_name as provider2_29_9_,
            provider5_.npi as npi3_29_9_,
            provider5_.tax_id as tax_id4_29_9_,
            patient6_.address1 as address2_25_10_,
            patient6_.address2 as address3_25_10_,
            patient6_.etl_batch_id as etl_batc4_25_10_,
            patient6_.city as city5_25_10_,
            patient6_.date_of_birth as date_of_6_25_10_,
            patient6_.first_name as first_na7_25_10_,
            patient6_.icn as icn8_25_10_,
            patient6_.insured_id as insured_9_25_10_,
            patient6_.last_name as last_na10_25_10_,
            patient6_.member_id as member_11_25_10_,
            patient6_.middle_initial as middle_12_25_10_,
            patient6_.postal_code as postal_13_25_10_,
            patient6_.sex as sex14_25_10_,
            patient6_.ssn as ssn15_25_10_,
            patient6_.state_code as state_c16_25_10_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser7_ 
                on profclaiml2_.pos_key=placeofser7_.pos_key 
        left outer join
            dim_provider provider8_ 
                on profclaiml2_.rendering_provider_key=provider8_.provider_key 
        left outer join
            dim_procedure_code procedure9_ 
                on profclaiml2_.procedure_key=procedure9_.procedure_key 
        left outer join
            claim_line_modifier modifiers10_ 
                on profclaiml2_.claim_detail_key=modifiers10_.claim_detail_key_pr 
        inner join
            decision decisions3_ 
                on claim0_.claim_key=decisions3_.claim_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.billing_provider_key=provider4_.provider_key 
        left outer join
            dim_provider provider5_ 
                on claim0_.rendering_provider_key=provider5_.provider_key 
        left outer join
            dim_patient patient6_ 
                on claim0_.patient_key=patient6_.patient_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            ) 
            and claim0_.source_system='EDI'
Hibernate: 
    /* select
        generatedAlias0 
    from
        Seoc as generatedAlias0 
    where
        generatedAlias0.seocId=:param0 */ select
            seoc0_.seoc_key as seoc_key1_39_,
            seoc0_.category_of_care as category2_39_,
            seoc0_.duration as duration3_39_,
            seoc0_.end_date as end_date4_39_,
            seoc0_.is_pal as is_pal5_39_,
            seoc0_.name as name6_39_,
            seoc0_.seoc_id as seoc_id7_39_,
            seoc0_.start_date as start_da8_39_,
            seoc0_.version as version9_39_ 
        from
            seoc seoc0_ 
        where
            seoc0_.seoc_id=?
Hibernate: 
    /* select
        distinct r 
    from
        Referral r 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber */ select
            distinct referral0_.referral_key as referral1_10_0_,
            preauthori1_.preauthorization_key as preautho1_8_1_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            preauthori1_.date_from as date_fro2_8_1_,
            preauthori1_.date_to as date_to3_8_1_,
            preauthori1_.preauthorization_number as preautho4_8_1_,
            preauthori1_.referral_key as referral5_8_1_,
            preauthori1_.referral_key as referral5_8_0__,
            preauthori1_.preauthorization_key as preautho1_8_0__ 
        from
            ccra.referral referral0_ 
        left outer join
            ccra.preauthorization preauthori1_ 
                on referral0_.referral_key=preauthori1_.referral_key 
        where
            referral0_.referral_number=?
Hibernate: 
    select
        procedures0_.seoc_key as seoc_key1_40_0_,
        procedures0_.procedure_key as procedur2_40_0_,
        procedures0_.seoc_key as seoc_key1_40_1_,
        procedures0_.procedure_key as procedur2_40_1_,
        procedure1_.procedure_key as procedur1_28_2_,
        procedure1_.procedure_code as procedur2_28_2_,
        procedure1_.short_description as short_de3_28_2_ 
    from
        seoc_procedure_junction procedures0_ 
    inner join
        dim_procedure_code procedure1_ 
            on procedures0_.procedure_key=procedure1_.procedure_key 
    where
        procedures0_.seoc_key=?
Hibernate: 
    select
        preauthori0_.preauthorization_key as preautho5_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_1_,
        preauthori0_.preauthorization_key as preautho5_9_1_,
        preauthori0_.preauthorized_service as preautho2_9_1_,
        preauthori0_.quantity as quantity3_9_1_,
        preauthori0_.subcategory as subcateg4_9_1_,
        orderset1_.orderset_key as orderset1_3_2_,
        orderset1_.code as code2_3_2_,
        orderset1_.order_set_description as order_se3_3_2_,
        orderset1_.pre_authorization_detail_key as pre_auth4_3_2_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    /* select
        distinct r 
    from
        Referral r 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber */ select
            distinct referral0_.referral_key as referral1_10_0_,
            preauthori1_.preauthorization_key as preautho1_8_1_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            preauthori1_.date_from as date_fro2_8_1_,
            preauthori1_.date_to as date_to3_8_1_,
            preauthori1_.preauthorization_number as preautho4_8_1_,
            preauthori1_.referral_key as referral5_8_1_,
            preauthori1_.referral_key as referral5_8_0__,
            preauthori1_.preauthorization_key as preautho1_8_0__ 
        from
            ccra.referral referral0_ 
        left outer join
            ccra.preauthorization preauthori1_ 
                on referral0_.referral_key=preauthori1_.referral_key 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_1_,
            preauthori2_.preauthorization_key as preautho1_8_2_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            referralpa1_.icn as icn2_11_1_,
            referralpa1_.referral_key as referral3_11_1_,
            referralpa1_.referral_key as referral3_11_0__,
            referralpa1_.referral_patient_key as referral1_11_0__,
            preauthori2_.date_from as date_fro2_8_2_,
            preauthori2_.date_to as date_to3_8_2_,
            preauthori2_.preauthorization_number as preautho4_8_2_,
            preauthori2_.referral_key as referral5_8_2_,
            preauthori2_.referral_key as referral5_8_1__,
            preauthori2_.preauthorization_key as preautho1_8_1__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        left outer join
            ccra.preauthorization preauthori2_ 
                on referral0_.referral_key=preauthori2_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_1_,
            preauthori2_.preauthorization_key as preautho1_8_2_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            referralpa1_.icn as icn2_11_1_,
            referralpa1_.referral_key as referral3_11_1_,
            referralpa1_.referral_key as referral3_11_0__,
            referralpa1_.referral_patient_key as referral1_11_0__,
            preauthori2_.date_from as date_fro2_8_2_,
            preauthori2_.date_to as date_to3_8_2_,
            preauthori2_.preauthorization_number as preautho4_8_2_,
            preauthori2_.referral_key as referral5_8_2_,
            preauthori2_.referral_key as referral5_8_1__,
            preauthori2_.preauthorization_key as preautho1_8_1__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        left outer join
            ccra.preauthorization preauthori2_ 
                on referral0_.referral_key=preauthori2_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
Hibernate: 
    /* 
from
    ProviderSanction 
where
    exclusionDate is not null 
    and (
        npi in :npis 
    ) */ select
        providersa0_.provider_sanction_key as provider1_36_,
        providersa0_.exclusion_date as exclusio2_36_,
        providersa0_.npi as npi3_36_,
        providersa0_.reinstate_date as reinstat4_36_,
        providersa0_.tax_id as tax_id5_36_ 
    from
        lkup_provider_sanction providersa0_ 
    where
        (
            providersa0_.exclusion_date is not null
        ) 
        and (
            providersa0_.npi in (
                ?
            )
        )
Hibernate: 
    /* 
from
    ProviderSanction 
where
    exclusionDate is not null 
    and (
        npi in :npis 
    ) */ select
        providersa0_.provider_sanction_key as provider1_36_,
        providersa0_.exclusion_date as exclusio2_36_,
        providersa0_.npi as npi3_36_,
        providersa0_.reinstate_date as reinstat4_36_,
        providersa0_.tax_id as tax_id5_36_ 
    from
        lkup_provider_sanction providersa0_ 
    where
        (
            providersa0_.exclusion_date is not null
        ) 
        and (
            providersa0_.npi in (
                ?
            )
        )
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        PaymentAuthorityObligation r 
    where
        r.id = :id */ select
            paymentaut0_.payment_authority_obligation_key as payment_1_7_,
            paymentaut0_.end_date as end_date2_7_,
            paymentaut0_.obligation_key as obligati4_7_,
            paymentaut0_.payment_authority_key as payment_5_7_,
            paymentaut0_.start_date as start_da3_7_ 
        from
            ccra.payment_authority_obligation paymentaut0_ 
        where
            paymentaut0_.payment_authority_obligation_key=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    left join
        fetch r.preAuthorization 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_1_,
            preauthori2_.preauthorization_key as preautho1_8_2_,
            referral0_.referral_expiration_date as referral2_10_0_,
            referral0_.payment_authority_obligation_key as payment_3_10_0_,
            referral0_.referral_date as referral4_10_0_,
            referral0_.referral_number as referral5_10_0_,
            referral0_.referring_provider as referrin6_10_0_,
            referral0_.service_requested as service_7_10_0_,
            referralpa1_.icn as icn2_11_1_,
            referralpa1_.referral_key as referral3_11_1_,
            referralpa1_.referral_key as referral3_11_0__,
            referralpa1_.referral_patient_key as referral1_11_0__,
            preauthori2_.date_from as date_fro2_8_2_,
            preauthori2_.date_to as date_to3_8_2_,
            preauthori2_.preauthorization_number as preautho4_8_2_,
            preauthori2_.referral_key as referral5_8_2_,
            preauthori2_.referral_key as referral5_8_1__,
            preauthori2_.preauthorization_key as preautho1_8_1__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        left outer join
            ccra.preauthorization preauthori2_ 
                on referral0_.referral_key=preauthori2_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
Hibernate: 
    select
        preauthori0_.preauthorization_key as preautho5_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_0_,
        preauthori0_.preauthorization_detail_key as preautho1_9_1_,
        preauthori0_.preauthorization_key as preautho5_9_1_,
        preauthori0_.preauthorized_service as preautho2_9_1_,
        preauthori0_.quantity as quantity3_9_1_,
        preauthori0_.subcategory as subcateg4_9_1_,
        orderset1_.orderset_key as orderset1_3_2_,
        orderset1_.code as code2_3_2_,
        orderset1_.order_set_description as order_se3_3_2_,
        orderset1_.pre_authorization_detail_key as pre_auth4_3_2_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset1_4_0_,
        ordersetda0_.date_from as date_fro2_4_0_,
        ordersetda1_.orderset_date_key as orderset3_5_1_,
        ordersetda1_.orderset_date_item_key as orderset1_5_1_,
        ordersetda1_.orderset_date_item_key as orderset1_5_2_,
        ordersetda1_.orderset_date_key as orderset3_5_2_,
        ordersetda1_.procedure_code as procedur2_5_2_,
        orderset2_.orderset_key as orderset1_3_3_,
        orderset2_.code as code2_3_3_,
        orderset2_.order_set_description as order_se3_3_3_,
        orderset2_.pre_authorization_detail_key as pre_auth4_3_3_ 
    from
        ccra.ordersetdate ordersetda0_ 
    left outer join
        ccra.ordersetdateitem ordersetda1_ 
            on ordersetda0_.orderset_date_key=ordersetda1_.orderset_date_key 
    left outer join
        ccra.orderset orderset2_ 
            on ordersetda0_.orderset_date_key=orderset2_.orderset_key 
    where
        ordersetda0_.orderset_date_key=?
2018-04-23 16:02:35.823 INFO IcnRule                - Found 1 referrals for the icn rule matching referral number 4321a
Hibernate: 
    /* 
from
    ProviderSanction 
where
    exclusionDate is not null 
    and (
        npi in :npis 
    ) */ select
        providersa0_.provider_sanction_key as provider1_36_,
        providersa0_.exclusion_date as exclusio2_36_,
        providersa0_.npi as npi3_36_,
        providersa0_.reinstate_date as reinstat4_36_,
        providersa0_.tax_id as tax_id5_36_ 
    from
        lkup_provider_sanction providersa0_ 
    where
        (
            providersa0_.exclusion_date is not null
        ) 
        and (
            providersa0_.npi in (
                ?
            )
        )
Hibernate: 
    /* select
        r 
    from
        Referral r 
    where
        r.referralNumber = :referralNumber */ select
            referral0_.referral_key as referral1_10_,
            referral0_.referral_expiration_date as referral2_10_,
            referral0_.payment_authority_obligation_key as payment_3_10_,
            referral0_.referral_date as referral4_10_,
            referral0_.referral_number as referral5_10_,
            referral0_.referring_provider as referrin6_10_,
            referral0_.service_requested as service_7_10_ 
        from
            ccra.referral referral0_ 
        where
            referral0_.referral_number=?
Hibernate: 
    /* select
        r 
    from
        PaymentAuthorityObligation r 
    where
        r.id = :id */ select
            paymentaut0_.payment_authority_obligation_key as payment_1_7_,
            paymentaut0_.end_date as end_date2_7_,
            paymentaut0_.obligation_key as obligati4_7_,
            paymentaut0_.payment_authority_key as payment_5_7_,
            paymentaut0_.start_date as start_da3_7_ 
        from
            ccra.payment_authority_obligation paymentaut0_ 
        where
            paymentaut0_.payment_authority_obligation_key=?
Hibernate: 
    /* select
        r 
    from
        PaymentAuthorityObligation r 
    where
        r.id = :id */ select
            paymentaut0_.payment_authority_obligation_key as payment_1_7_,
            paymentaut0_.end_date as end_date2_7_,
            paymentaut0_.obligation_key as obligati4_7_,
            paymentaut0_.payment_authority_key as payment_5_7_,
            paymentaut0_.start_date as start_da3_7_ 
        from
            ccra.payment_authority_obligation paymentaut0_ 
        where
            paymentaut0_.payment_authority_obligation_key=?
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Decision
        */ insert 
        into
            decision
            (decision_key, etl_batch_id, claim_key, claim_detail_key, decision_date_time, decision, last_updated_user, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Decision
        */ insert 
        into
            decision
            (decision_key, etl_batch_id, claim_key, claim_detail_key, decision_date_time, decision, last_updated_user, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Decision
        */ insert 
        into
            decision
            (decision_key, etl_batch_id, claim_key, claim_detail_key, decision_date_time, decision, last_updated_user, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Decision
        */ insert 
        into
            decision
            (decision_key, etl_batch_id, claim_key, claim_detail_key, decision_date_time, decision, last_updated_user, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Decision
        */ insert 
        into
            decision
            (decision_key, etl_batch_id, claim_key, claim_detail_key, decision_date_time, decision, last_updated_user, last_updated_date_time) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
2018-04-23 16:02:35.909 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-4,5,main] completed, processed 1 claims
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    /* insert gov.va.ccrs.brengine.rule.decision.Validation
        */ insert 
        into
            validation_failure
            (validation_failure_key, carc_code, decision_key, last_updated_user, message, rarc_code, rule_name, last_updated_date_time, validation_name) 
        values
            (null, ?, ?, ?, ?, ?, ?, ?, ?)
2018-04-23 16:02:35.912 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-3,5,main] completed, processed 1 claims
2018-04-23 16:02:35.913 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-2,5,main] completed, processed 1 claims
2018-04-23 16:02:35.914 INFO BatchProcessor         - Batch 'prof_batch_2', host 'JX574H2' completed successfully, processed 4 lines, 7 failures
2018-04-23 16:02:35.914 INFO BatchProcessor         - Updating status of batch 'prof_batch_2' to RULES_COMPLETED
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.ProcessingTracker */ select
        processing0_.rules_batch_log_key as rules_ba1_38_0_,
        processing0_.etl_batch_id as etl_batc2_38_0_,
        processing0_.claim_type as claim_ty3_38_0_,
        processing0_.engine_version as engine_v4_38_0_,
        processing0_.error as error5_38_0_,
        processing0_.end_date_time as end_date6_38_0_,
        processing0_.hostname as hostname7_38_0_,
        processing0_.resume_mode as resume_m8_38_0_,
        processing0_.last_updated_user as last_upd9_38_0_,
        processing0_.number_of_claims as number_10_38_0_,
        processing0_.number_of_failures as number_11_38_0_,
        processing0_.number_of_lines as number_12_38_0_,
        processing0_.number_of_processed_claims as number_13_38_0_,
        processing0_.number_of_processed_lines as number_14_38_0_,
        processing0_.number_of_waiting_for_data as number_15_38_0_,
        processing0_.rule_names as rule_na16_38_0_,
        processing0_.environment_name as environ17_38_0_,
        processing0_.start_date_time as start_d18_38_0_,
        processing0_.status as status19_38_0_,
        processing0_.last_updated_date_time as last_up20_38_0_ 
    from
        rules_batch_log processing0_ 
    where
        processing0_.rules_batch_log_key=?
Hibernate: 
    /* load gov.va.ccrs.brengine.processing.BatchInfo */ select
        batchinfo0_.etl_batch_id as etl_batc1_16_0_,
        batchinfo0_.batch_status as batch_st2_16_0_,
        batchinfo0_.last_updated_user as last_upd3_16_0_,
        batchinfo0_.end_date_time as end_date4_16_0_,
        batchinfo0_.source_system as source_s5_16_0_,
        batchinfo0_.last_updated_date as last_upd6_16_0_ 
    from
        claim_batch_log batchinfo0_ 
    where
        batchinfo0_.etl_batch_id=?
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.ProcessingTracker */ update
            rules_batch_log 
        set
            etl_batch_id=?,
            claim_type=?,
            engine_version=?,
            error=?,
            end_date_time=?,
            hostname=?,
            resume_mode=?,
            last_updated_user=?,
            number_of_claims=?,
            number_of_failures=?,
            number_of_lines=?,
            number_of_processed_claims=?,
            number_of_processed_lines=?,
            number_of_waiting_for_data=?,
            rule_names=?,
            environment_name=?,
            start_date_time=?,
            status=?,
            last_updated_date_time=? 
        where
            rules_batch_log_key=?
2018-04-23 16:02:35.923 WARN NetworkClient          - [Consumer clientId=consumer-1, groupId=brengine-batch-request] Connection to node -1 could not be established. Broker may not be available.
2018-04-23 16:02:35.926 WARN NetworkClient          - [Consumer clientId=consumer-3, groupId=test-string-listener] Connection to node -1 could not be established. Broker may not be available.
2018-04-23 16:02:35.928 WARN NetworkClient          - [Consumer clientId=consumer-2, groupId=brengine-icn-response] Connection to node -1 could not be established. Broker may not be available.
Hibernate: 
    /* update
        gov.va.ccrs.brengine.processing.BatchInfo */ update
            claim_batch_log 
        set
            batch_status=?,
            last_updated_user=?,
            end_date_time=?,
            source_system=?,
            last_updated_date=? 
        where
            etl_batch_id=?
2018-04-23 16:02:35.931 INFO EmailNotifier          - Sending email to 'alexander@myarch.com'. Subject:
Batch 'prof_batch_2', host 'JX574H2' completed successfully, processed 4 lines, 7 failures
2018-04-23 16:02:35.932 INFO EmailNotifier          - Email sending is disabled, the email won't be sent
Hibernate: 
    /* select
        d 
    from
        Decision d 
    where
        d.batchId=?1 */ select
            decision0_.decision_key as decision1_21_,
            decision0_.etl_batch_id as etl_batc2_21_,
            decision0_.claim_key as claim_ke8_21_,
            decision0_.claim_detail_key as claim_de3_21_,
            decision0_.decision_date_time as decision4_21_,
            decision0_.decision as decision5_21_,
            decision0_.last_updated_user as last_upd6_21_,
            decision0_.last_updated_date_time as last_upd7_21_ 
        from
            decision decision0_ 
        where
            decision0_.etl_batch_id=?
2018-04-23 16:02:35.958 INFO nfigApplicationContext - Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@54eb2b70: startup date [Mon Apr 23 16:02:22 EDT 2018]; root of context hierarchy
2018-04-23 16:02:35.962 INFO aultLifecycleProcessor - Stopping beans in phase 2147483547
2018-04-23 16:02:35.969 INFO hreadPoolTaskScheduler - Shutting down ExecutorService
2018-04-23 16:02:35.994 INFO hreadPoolTaskScheduler - Shutting down ExecutorService
2018-04-23 16:02:35.996 INFO hreadPoolTaskScheduler - Shutting down ExecutorService
2018-04-23 16:02:35.998 INFO ainer$ListenerConsumer - Consumer stopped
2018-04-23 16:02:35.998 INFO ainer$ListenerConsumer - Consumer stopped
2018-04-23 16:02:35.999 INFO ainer$ListenerConsumer - Consumer stopped
2018-04-23 16:02:36.000 INFO aultLifecycleProcessor - Stopping beans in phase 0
2018-04-23 16:02:36.011 INFO tityManagerFactoryBean - Closing JPA EntityManagerFactory for persistence unit 'default'
2018-04-23 16:02:36.012 INFO HikariDataSource       - HikariPool-1 - Shutdown initiated...
2018-04-23 16:02:36.019 INFO HikariDataSource       - HikariPool-1 - Shutdown completed.

