2018-04-17 08:25:07.532 INFO estContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [gov.va.ccrs.brengine.BatchProcessorAllRulesTest], using SpringBootContextLoader
2018-04-17 08:25:07.532 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-17 08:25:07.548 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-17 08:25:07.771 INFO estContextBootstrapper - Found @SpringBootConfiguration gov.va.ccrs.brengine.BrEngineApplication for test class gov.va.ccrs.brengine.BatchProcessorAllRulesTest
2018-04-17 08:25:07.971 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-17 08:25:08.002 INFO estContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@4d0f2471, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@7133da86, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@3232a28a, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@73e22a3d, org.springframework.test.context.support.DirtiesContextTestExecutionListener@47faa49c, org.springframework.test.context.transaction.TransactionalTestExecutionListener@28f2a10f, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@f736069, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@6da21078, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@7fee8714, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@4229bb3f, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@56cdfb3b, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@2b91004a]
2018-04-17 08:25:08.503 INFO hProcessorAllRulesTest - Starting BatchProcessorAllRulesTest on JX574H2 with PID 21108 (started by DWei in C:\Users\DWei\CCRS-BUSRULES\brengine)
2018-04-17 08:25:08.503 INFO hProcessorAllRulesTest - The following profiles are active: ut
2018-04-17 08:25:08.550 INFO nfigApplicationContext - Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@13bc8645: startup date [Tue Apr 17 08:25:08 EDT 2018]; root of context hierarchy
2018-04-17 08:25:10.040 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-17 08:25:10.188 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-17 08:25:11.556 INFO anPostProcessorChecker - Bean 'org.springframework.kafka.annotation.KafkaBootstrapConfiguration' of type [org.springframework.kafka.annotation.KafkaBootstrapConfiguration$$EnhancerBySpringCGLIB$$bcc0eb57] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-17 08:25:11.606 INFO anPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$e90ed9d4] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-17 08:25:12.393 INFO HikariDataSource       - HikariPool-1 - Starting...
2018-04-17 08:25:12.772 INFO HikariDataSource       - HikariPool-1 - Start completed.
2018-04-17 08:25:12.931 INFO tityManagerFactoryBean - Building JPA container EntityManagerFactory for persistence unit 'default'
2018-04-17 08:25:14.335 WARN RootClass              - HHH000038: Composite-id class does not override equals(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-17 08:25:14.335 WARN RootClass              - HHH000039: Composite-id class does not override hashCode(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-17 08:25:15.101 INFO tityManagerFactoryBean - Initialized JPA EntityManagerFactory for persistence unit 'default'
2018-04-17 08:25:16.353 INFO HoconUtils             - Loading config file from C:\Users\DWei\CCRS-BUSRULES\brengine\bin\main\rules-config.conf
2018-04-17 08:25:17.180 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-17 08:25:17.312 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-17 08:25:18.172 INFO ultSecurityFilterChain - Creating filter chain: Ant [pattern='/fetchDecisions/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2739ecc0, org.springframework.security.web.context.SecurityContextPersistenceFilter@2cc34cd5, org.springframework.security.web.header.HeaderWriterFilter@45b8bbbf, org.springframework.security.web.csrf.CsrfFilter@17f41739, org.springframework.security.web.authentication.logout.LogoutFilter@4e26564d, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@2b1d1a5, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2de7c84a, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@3f4964f2, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@2932e15f, org.springframework.security.web.session.SessionManagementFilter@57927bc9, org.springframework.security.web.access.ExceptionTranslationFilter@1c788d08, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@1b8ee69d]
2018-04-17 08:25:18.235 INFO ultSecurityFilterChain - Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@57839834, org.springframework.security.web.context.SecurityContextPersistenceFilter@27b490de, org.springframework.security.web.header.HeaderWriterFilter@708f7386, org.springframework.security.web.authentication.logout.LogoutFilter@7d5ef1c3, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@1e194966, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@7eefaca0, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@36cf16a6, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@3dd750ba, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3355b8ff, org.springframework.security.web.session.SessionManagementFilter@377e90b0, org.springframework.security.web.access.ExceptionTranslationFilter@7b2d58e6, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@395eb363]
2018-04-17 08:25:18.483 INFO AbstractContextSource  - Property 'userDn' not set - anonymous context will be used for read-write operations
2018-04-17 08:25:19.630 INFO aultLifecycleProcessor - Starting beans in phase 2147483547
2018-04-17 08:25:19.643 INFO ationBeanPostProcessor - No TaskScheduler/ScheduledExecutorService bean found for scheduled processing
2018-04-17 08:25:19.655 INFO hProcessorAllRulesTest - Started BatchProcessorAllRulesTest in 11.586 seconds (JVM running for 12.948)
2018-04-17 08:25:19.704 INFO ScriptUtils            - Executing SQL script from class path resource [sql/create_tables_h2.sql]
2018-04-17 08:25:19.980 INFO ScriptUtils            - Executed SQL script from class path resource [sql/create_tables_h2.sql] in 276 ms.
2018-04-17 08:25:19.980 INFO ScriptUtils            - Executing SQL script from class path resource [sql/populate_claim.sql]
2018-04-17 08:25:20.080 INFO ScriptUtils            - Executed SQL script from class path resource [sql/populate_claim.sql] in 99 ms.
2018-04-17 08:25:20.081 INFO ScriptUtils            - Executing SQL script from class path resource [sql/populate_edi_nonconforming.sql]
2018-04-17 08:25:20.084 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.batchprocessing.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.batchprocessing.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.batchprocessing.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-17 08:25:20.357 INFO ncExecutionInterceptor - No task executor bean found for async processing: no bean of type TaskExecutor and no bean named 'taskExecutor' either
2018-04-17 08:25:20.361 INFO BatchProcessor         - Starting processing of batchId 'inst_batch_1'
2018-04-17 08:25:20.364 INFO tationBasedRuleFactory - Found the following rule beans annotated with gov.va.ccrs.brengine.rule.annotation.RuleFactoryBean
[]
2018-04-17 08:25:20.371 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-17 08:25:20.372 INFO BatchProcessor         - Number of rules used for processing: 8
2018-04-17 08:25:20.373 INFO BatchProcessor         - Rules:
[gov.va.ccrs.brengine.rule.referral.ReferralRules@56881196, gov.va.ccrs.brengine.rule.dollarthreshold.DollarThresholdRule@592cb470, gov.va.ccrs.brengine.rule.duplicate.DuplicateRules@6200b644, gov.va.ccrs.brengine.rule.seoc.EpisodeRules@28519bfb, gov.va.ccrs.brengine.rule.icn.IcnRule@3fd5d679, gov.va.ccrs.brengine.rule.leie.LeieRule@2a42019a, gov.va.ccrs.brengine.rule.paymentauthority.PaymentAuthorityRules@290c266c, gov.va.ccrs.brengine.rule.timelyfiling.TimelyFilingRule@68d8ae27]
2018-04-17 08:25:20.373 INFO BatchProcessor         - Updating status of batch 'inst_batch_1' to RULES_INIT
Hibernate: 
    /* load gov.va.ccrs.brengine.batchprocessing.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.batchprocessing.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.batchprocessing.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.batchprocessing.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-17 08:25:20.425 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-17 08:25:20.459 INFO DecisionDaoImpl        - Deleted 0 decisions and 0 failures for batchId inst_batch_1
2018-04-17 08:25:20.463 INFO BatchProcessor         - Loading all claims for the batch inst_batch_1
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType formType 
    join
        fetch c.instClaimLines line 
    left join
        fetch c.billingProvider billProv 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch billProv.locations 
    left join
        fetch c.patient patient 
    join
        fetch c.instClaim instClaim 
    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='837I' 
        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_,
            instclaiml2_.claim_detail_key as claim_de1_33_2_,
            procedure8_.procedure_key as procedur1_28_3_,
            modifiers9_.claim_line_modifier_key as claim_li1_19_4_,
            provider3_.provider_key as provider1_29_5_,
            locations5_.provider_location_key as provider1_37_6_,
            provider4_.provider_key as provider1_29_7_,
            patient6_.patient_key as patient_1_25_8_,
            institutio7_.claim_key as claim_ke1_24_9_,
            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_,
            instclaiml2_.etl_batch_id as etl_batc2_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_2_,
            instclaiml2_.date_paid as date_pai3_33_2_,
            instclaiml2_.is_current as is_curre4_33_2_,
            instclaiml2_.line_item_control_number as line_ite5_33_2_,
            instclaiml2_.charge_amount as charge_a6_33_2_,
            instclaiml2_.procedure_key as procedu10_33_2_,
            instclaiml2_.revenue_code as revenue_7_33_2_,
            instclaiml2_.service_date as service_8_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_0__,
            instclaiml2_.claim_detail_key as claim_de1_33_0__,
            procedure8_.procedure_code as procedur2_28_3_,
            procedure8_.short_description as short_de3_28_3_,
            modifiers9_.modifier_code as modifier2_19_4_,
            modifiers9_.claim_detail_key_dt as claim_de4_19_4_,
            modifiers9_.claim_detail_key_in as claim_de5_19_4_,
            modifiers9_.is_current as is_curre3_19_4_,
            modifiers9_.claim_detail_key_pr as claim_de6_19_4_,
            modifiers9_.claim_detail_key_in as claim_de5_19_1__,
            modifiers9_.claim_line_modifier_key as claim_li1_19_1__,
            provider3_.provider_name as provider2_29_5_,
            provider3_.npi as npi3_29_5_,
            provider3_.tax_id as tax_id4_29_5_,
            locations5_.address1 as address2_37_6_,
            locations5_.city as city3_37_6_,
            locations5_.country_code as country_4_37_6_,
            locations5_.postal_code as postal_c5_37_6_,
            locations5_.provider_key as provider8_37_6_,
            locations5_.provider_phone as provider6_37_6_,
            locations5_.state_long_name as state_lo7_37_6_,
            locations5_.provider_key as provider8_37_2__,
            locations5_.provider_location_key as provider1_37_2__,
            provider4_.provider_name as provider2_29_7_,
            provider4_.npi as npi3_29_7_,
            provider4_.tax_id as tax_id4_29_7_,
            patient6_.address1 as address2_25_8_,
            patient6_.address2 as address3_25_8_,
            patient6_.etl_batch_id as etl_batc4_25_8_,
            patient6_.city as city5_25_8_,
            patient6_.date_of_birth as date_of_6_25_8_,
            patient6_.first_name as first_na7_25_8_,
            patient6_.icn as icn8_25_8_,
            patient6_.insured_id as insured_9_25_8_,
            patient6_.last_name as last_na10_25_8_,
            patient6_.member_id as member_11_25_8_,
            patient6_.middle_initial as middle_12_25_8_,
            patient6_.postal_code as postal_13_25_8_,
            patient6_.sex as sex14_25_8_,
            patient6_.ssn as ssn15_25_8_,
            patient6_.state_code as state_c16_25_8_,
            institutio7_.admission_date as admissio2_24_9_,
            institutio7_.statement_from_date as statemen3_24_9_,
            institutio7_.statement_to_date as statemen4_24_9_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_institutional_medical_claim_details instclaiml2_ 
                on claim0_.claim_key=instclaiml2_.claim_key 
        left outer join
            dim_procedure_code procedure8_ 
                on instclaiml2_.procedure_key=procedure8_.procedure_key 
        left outer join
            claim_line_modifier modifiers9_ 
                on instclaiml2_.claim_detail_key=modifiers9_.claim_detail_key_in 
        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 
        inner join
            dim_institutional_claim institutio7_ 
                on claim0_.claim_key=institutio7_.claim_key 
        where
            claim0_.is_current='Y' 
            and instclaiml2_.is_current='Y' 
            and (
                modifiers9_.claim_line_modifier_key is null 
                or modifiers9_.is_current='Y'
            ) 
            and formtype1_.form_code='837I' 
            and (
                instclaiml2_.claim_detail_key not in  (
                    select
                        decision10_.claim_detail_key 
                    from
                        decision decision10_ 
                    where
                        decision10_.claim_key=claim0_.claim_key
                )
            ) 
            and claim0_.etl_batch_id=?
2018-04-17 08:25:20.579 INFO BatchProcessor         - Loaded 7 claims 7 lines
2018-04-17 08:25:20.581 INFO BatchProcessor         - Updating status of batch 'inst_batch_1' to RULES_IN_PROCESS
Hibernate: 
    /* load gov.va.ccrs.brengine.batchprocessing.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.batchprocessing.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.batchprocessing.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.batchprocessing.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-17 08:25:20.595 INFO BatchProcessor         - Starting 3 threads to process the batch inst_batch_1
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.instClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.patient pt 
    join
        fetch c.instClaim 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            instclaiml2_.claim_detail_key as claim_de1_33_2_,
            procedure7_.procedure_key as procedur1_28_3_,
            modifiers8_.claim_line_modifier_key as claim_li1_19_4_,
            decisions3_.decision_key as decision1_21_5_,
            provider4_.provider_key as provider1_29_6_,
            patient5_.patient_key as patient_1_25_7_,
            institutio6_.claim_key as claim_ke1_24_8_,
            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_,
            instclaiml2_.etl_batch_id as etl_batc2_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_2_,
            instclaiml2_.date_paid as date_pai3_33_2_,
            instclaiml2_.is_current as is_curre4_33_2_,
            instclaiml2_.line_item_control_number as line_ite5_33_2_,
            instclaiml2_.charge_amount as charge_a6_33_2_,
            instclaiml2_.procedure_key as procedu10_33_2_,
            instclaiml2_.revenue_code as revenue_7_33_2_,
            instclaiml2_.service_date as service_8_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_0__,
            instclaiml2_.claim_detail_key as claim_de1_33_0__,
            procedure7_.procedure_code as procedur2_28_3_,
            procedure7_.short_description as short_de3_28_3_,
            modifiers8_.modifier_code as modifier2_19_4_,
            modifiers8_.claim_detail_key_dt as claim_de4_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_4_,
            modifiers8_.is_current as is_curre3_19_4_,
            modifiers8_.claim_detail_key_pr as claim_de6_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_1__,
            modifiers8_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_5_,
            decisions3_.claim_key as claim_ke8_21_5_,
            decisions3_.claim_detail_key as claim_de3_21_5_,
            decisions3_.decision_date_time as decision4_21_5_,
            decisions3_.decision as decision5_21_5_,
            decisions3_.last_updated_user as last_upd6_21_5_,
            decisions3_.last_updated_date_time as last_upd7_21_5_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_6_,
            provider4_.npi as npi3_29_6_,
            provider4_.tax_id as tax_id4_29_6_,
            patient5_.address1 as address2_25_7_,
            patient5_.address2 as address3_25_7_,
            patient5_.etl_batch_id as etl_batc4_25_7_,
            patient5_.city as city5_25_7_,
            patient5_.date_of_birth as date_of_6_25_7_,
            patient5_.first_name as first_na7_25_7_,
            patient5_.icn as icn8_25_7_,
            patient5_.insured_id as insured_9_25_7_,
            patient5_.last_name as last_na10_25_7_,
            patient5_.member_id as member_11_25_7_,
            patient5_.middle_initial as middle_12_25_7_,
            patient5_.postal_code as postal_13_25_7_,
            patient5_.sex as sex14_25_7_,
            patient5_.ssn as ssn15_25_7_,
            patient5_.state_code as state_c16_25_7_,
            institutio6_.admission_date as admissio2_24_8_,
            institutio6_.statement_from_date as statemen3_24_8_,
            institutio6_.statement_to_date as statemen4_24_8_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_institutional_medical_claim_details instclaiml2_ 
                on claim0_.claim_key=instclaiml2_.claim_key 
        left outer join
            dim_procedure_code procedure7_ 
                on instclaiml2_.procedure_key=procedure7_.procedure_key 
        left outer join
            claim_line_modifier modifiers8_ 
                on instclaiml2_.claim_detail_key=modifiers8_.claim_detail_key_in 
        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_patient patient5_ 
                on claim0_.patient_key=patient5_.patient_key 
        inner join
            dim_institutional_claim institutio6_ 
                on claim0_.claim_key=institutio6_.claim_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            )
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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset3_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_1_,
        ordersetda0_.orderset_date_key as orderset3_5_1_,
        ordersetda0_.procedure_code as procedur2_5_1_ 
    from
        ccra.ordersetdateitem ordersetda0_ 
    where
        ordersetda0_.orderset_date_key=?
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.instClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.patient pt 
    join
        fetch c.instClaim 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            instclaiml2_.claim_detail_key as claim_de1_33_2_,
            procedure7_.procedure_key as procedur1_28_3_,
            modifiers8_.claim_line_modifier_key as claim_li1_19_4_,
            decisions3_.decision_key as decision1_21_5_,
            provider4_.provider_key as provider1_29_6_,
            patient5_.patient_key as patient_1_25_7_,
            institutio6_.claim_key as claim_ke1_24_8_,
            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_,
            instclaiml2_.etl_batch_id as etl_batc2_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_2_,
            instclaiml2_.date_paid as date_pai3_33_2_,
            instclaiml2_.is_current as is_curre4_33_2_,
            instclaiml2_.line_item_control_number as line_ite5_33_2_,
            instclaiml2_.charge_amount as charge_a6_33_2_,
            instclaiml2_.procedure_key as procedu10_33_2_,
            instclaiml2_.revenue_code as revenue_7_33_2_,
            instclaiml2_.service_date as service_8_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_0__,
            instclaiml2_.claim_detail_key as claim_de1_33_0__,
            procedure7_.procedure_code as procedur2_28_3_,
            procedure7_.short_description as short_de3_28_3_,
            modifiers8_.modifier_code as modifier2_19_4_,
            modifiers8_.claim_detail_key_dt as claim_de4_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_4_,
            modifiers8_.is_current as is_curre3_19_4_,
            modifiers8_.claim_detail_key_pr as claim_de6_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_1__,
            modifiers8_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_5_,
            decisions3_.claim_key as claim_ke8_21_5_,
            decisions3_.claim_detail_key as claim_de3_21_5_,
            decisions3_.decision_date_time as decision4_21_5_,
            decisions3_.decision as decision5_21_5_,
            decisions3_.last_updated_user as last_upd6_21_5_,
            decisions3_.last_updated_date_time as last_upd7_21_5_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_6_,
            provider4_.npi as npi3_29_6_,
            provider4_.tax_id as tax_id4_29_6_,
            patient5_.address1 as address2_25_7_,
            patient5_.address2 as address3_25_7_,
            patient5_.etl_batch_id as etl_batc4_25_7_,
            patient5_.city as city5_25_7_,
            patient5_.date_of_birth as date_of_6_25_7_,
            patient5_.first_name as first_na7_25_7_,
            patient5_.icn as icn8_25_7_,
            patient5_.insured_id as insured_9_25_7_,
            patient5_.last_name as last_na10_25_7_,
            patient5_.member_id as member_11_25_7_,
            patient5_.middle_initial as middle_12_25_7_,
            patient5_.postal_code as postal_13_25_7_,
            patient5_.sex as sex14_25_7_,
            patient5_.ssn as ssn15_25_7_,
            patient5_.state_code as state_c16_25_7_,
            institutio6_.admission_date as admissio2_24_8_,
            institutio6_.statement_from_date as statemen3_24_8_,
            institutio6_.statement_to_date as statemen4_24_8_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_institutional_medical_claim_details instclaiml2_ 
                on claim0_.claim_key=instclaiml2_.claim_key 
        left outer join
            dim_procedure_code procedure7_ 
                on instclaiml2_.procedure_key=procedure7_.procedure_key 
        left outer join
            claim_line_modifier modifiers8_ 
                on instclaiml2_.claim_detail_key=modifiers8_.claim_detail_key_in 
        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_patient patient5_ 
                on claim0_.patient_key=patient5_.patient_key 
        inner join
            dim_institutional_claim institutio6_ 
                on claim0_.claim_key=institutio6_.claim_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            )
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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset3_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_1_,
        ordersetda0_.orderset_date_key as orderset3_5_1_,
        ordersetda0_.procedure_code as procedur2_5_1_ 
    from
        ccra.ordersetdateitem ordersetda0_ 
    where
        ordersetda0_.orderset_date_key=?
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.instClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.patient pt 
    join
        fetch c.instClaim 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            instclaiml2_.claim_detail_key as claim_de1_33_2_,
            procedure7_.procedure_key as procedur1_28_3_,
            modifiers8_.claim_line_modifier_key as claim_li1_19_4_,
            decisions3_.decision_key as decision1_21_5_,
            provider4_.provider_key as provider1_29_6_,
            patient5_.patient_key as patient_1_25_7_,
            institutio6_.claim_key as claim_ke1_24_8_,
            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_,
            instclaiml2_.etl_batch_id as etl_batc2_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_2_,
            instclaiml2_.date_paid as date_pai3_33_2_,
            instclaiml2_.is_current as is_curre4_33_2_,
            instclaiml2_.line_item_control_number as line_ite5_33_2_,
            instclaiml2_.charge_amount as charge_a6_33_2_,
            instclaiml2_.procedure_key as procedu10_33_2_,
            instclaiml2_.revenue_code as revenue_7_33_2_,
            instclaiml2_.service_date as service_8_33_2_,
            instclaiml2_.claim_key as claim_ke9_33_0__,
            instclaiml2_.claim_detail_key as claim_de1_33_0__,
            procedure7_.procedure_code as procedur2_28_3_,
            procedure7_.short_description as short_de3_28_3_,
            modifiers8_.modifier_code as modifier2_19_4_,
            modifiers8_.claim_detail_key_dt as claim_de4_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_4_,
            modifiers8_.is_current as is_curre3_19_4_,
            modifiers8_.claim_detail_key_pr as claim_de6_19_4_,
            modifiers8_.claim_detail_key_in as claim_de5_19_1__,
            modifiers8_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_5_,
            decisions3_.claim_key as claim_ke8_21_5_,
            decisions3_.claim_detail_key as claim_de3_21_5_,
            decisions3_.decision_date_time as decision4_21_5_,
            decisions3_.decision as decision5_21_5_,
            decisions3_.last_updated_user as last_upd6_21_5_,
            decisions3_.last_updated_date_time as last_upd7_21_5_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_6_,
            provider4_.npi as npi3_29_6_,
            provider4_.tax_id as tax_id4_29_6_,
            patient5_.address1 as address2_25_7_,
            patient5_.address2 as address3_25_7_,
            patient5_.etl_batch_id as etl_batc4_25_7_,
            patient5_.city as city5_25_7_,
            patient5_.date_of_birth as date_of_6_25_7_,
            patient5_.first_name as first_na7_25_7_,
            patient5_.icn as icn8_25_7_,
            patient5_.insured_id as insured_9_25_7_,
            patient5_.last_name as last_na10_25_7_,
            patient5_.member_id as member_11_25_7_,
            patient5_.middle_initial as middle_12_25_7_,
            patient5_.postal_code as postal_13_25_7_,
            patient5_.sex as sex14_25_7_,
            patient5_.ssn as ssn15_25_7_,
            patient5_.state_code as state_c16_25_7_,
            institutio6_.admission_date as admissio2_24_8_,
            institutio6_.statement_from_date as statemen3_24_8_,
            institutio6_.statement_to_date as statemen4_24_8_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_institutional_medical_claim_details instclaiml2_ 
                on claim0_.claim_key=instclaiml2_.claim_key 
        left outer join
            dim_procedure_code procedure7_ 
                on instclaiml2_.procedure_key=procedure7_.procedure_key 
        left outer join
            claim_line_modifier modifiers8_ 
                on instclaiml2_.claim_detail_key=modifiers8_.claim_detail_key_in 
        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_patient patient5_ 
                on claim0_.patient_key=patient5_.patient_key 
        inner join
            dim_institutional_claim institutio6_ 
                on claim0_.claim_key=institutio6_.claim_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            )
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 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
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
        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
        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
        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
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.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: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
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: 
    /* 
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
        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 
    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
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.obligation_key=?
Hibernate: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_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: 
    select
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.obligation_key=?
Hibernate: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_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.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.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: 
    /* 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 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
        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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset3_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_1_,
        ordersetda0_.orderset_date_key as orderset3_5_1_,
        ordersetda0_.procedure_code as procedur2_5_1_ 
    from
        ccra.ordersetdateitem ordersetda0_ 
    where
        ordersetda0_.orderset_date_key=?
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
        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
        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
        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
        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 
    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 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
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.obligation_key=?
Hibernate: 
    /* select
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.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: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_key=?
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset3_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_1_,
        ordersetda0_.orderset_date_key as orderset3_5_1_,
        ordersetda0_.procedure_code as procedur2_5_1_ 
    from
        ccra.ordersetdateitem ordersetda0_ 
    where
        ordersetda0_.orderset_date_key=?
2018-04-17 08:25:20.961 INFO LeieRule               - LEIE rules was triggered for line 1211: Provider with npi or tax ID '21' was on the OIG exclusion list as of the date of service for this invoice/line. Date of service: 01/02/17, date of exclusion: 01/02/17.
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
        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: 
    /* 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: 
    /* 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
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.obligation_key=?
Hibernate: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_key=?
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
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.referral_key 
        where
            referral0_.referral_number=? 
            and referral0_.referral_date<=?
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: 
    /* 
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
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.obligation_key=?
Hibernate: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_key=?
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: 
    /* 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 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_,
        ordersetda2_.orderset_date_key as orderset1_4_3_,
        ordersetda2_.date_from as date_fro2_4_3_,
        orderset3_.orderset_key as orderset1_3_4_,
        orderset3_.code as code2_3_4_,
        orderset3_.order_set_description as order_se3_3_4_,
        orderset3_.pre_authorization_detail_key as pre_auth4_3_4_ 
    from
        ccra.preauthorization_detail preauthori0_ 
    left outer join
        ccra.orderset orderset1_ 
            on preauthori0_.preauthorization_detail_key=orderset1_.pre_authorization_detail_key 
    left outer join
        ccra.ordersetdate ordersetda2_ 
            on orderset1_.orderset_key=ordersetda2_.orderset_date_key 
    left outer join
        ccra.orderset orderset3_ 
            on ordersetda2_.orderset_date_key=orderset3_.orderset_key 
    where
        preauthori0_.preauthorization_key=?
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-17 08:25:21.000 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-3,5,main] completed, processed 2 claims
Hibernate: 
    select
        ordersetda0_.orderset_date_key as orderset3_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_0_,
        ordersetda0_.orderset_date_item_key as orderset1_5_1_,
        ordersetda0_.orderset_date_key as orderset3_5_1_,
        ordersetda0_.procedure_code as procedur2_5_1_ 
    from
        ccra.ordersetdateitem ordersetda0_ 
    where
        ordersetda0_.orderset_date_key=?
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
        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
        r 
    from
        Referral r 
    join
        fetch r.referralPatients patient 
    where
        r.referralNumber = :referralNumber 
        and r.referralDate<=:serviceFromDate */ select
            referral0_.referral_key as referral1_10_0_,
            referralpa1_.referral_patient_key as referral1_11_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_,
            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__ 
        from
            ccra.referral referral0_ 
        inner join
            ccra.referral_patient referralpa1_ 
                on referral0_.referral_key=referralpa1_.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: 
    /* 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
        obligation0_.obligation_key as obligati1_1_0_,
        obligation0_.acc as acc2_1_0_,
        obligation0_.category_of_care as category3_1_0_,
        obligation0_.category_of_care_subset as category4_1_0_,
        obligation0_.cost_center_boc as cost_cen5_1_0_,
        obligation0_.fund as fund6_1_0_,
        obligation0_.last_updated_date as last_upd7_1_0_,
        obligation0_.last_updated_user as last_upd8_1_0_,
        obligation0_.mnemonics as mnemonic9_1_0_,
        obligation0_.obligation_number as obligat10_1_0_,
        cptobligat1_.obligation_key as obligati4_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_1_,
        cptobligat1_.cpt_obligation_key as cpt_obli1_0_2_,
        cptobligat1_.end_date as end_date2_0_2_,
        cptobligat1_.obligation_key as obligati4_0_2_,
        cptobligat1_.procedure_key as procedur5_0_2_,
        cptobligat1_.start_date as start_da3_0_2_,
        procedure2_.procedure_key as procedur1_28_3_,
        procedure2_.procedure_code as procedur2_28_3_,
        procedure2_.short_description as short_de3_28_3_ 
    from
        ccra.obligation obligation0_ 
    left outer join
        ccra.cpt_obligation cptobligat1_ 
            on obligation0_.obligation_key=cptobligat1_.obligation_key 
    left outer join
        dim_procedure_code procedure2_ 
            on cptobligat1_.procedure_key=procedure2_.procedure_key 
    where
        obligation0_.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.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-17 08:25:21.029 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-2,5,main] completed, processed 2 claims
Hibernate: 
    select
        paymentaut0_.payment_authority_key as payment_1_6_0_,
        paymentaut0_.code as code2_6_0_,
        paymentaut0_.description as descript3_6_0_,
        paymentaut0_.name as name4_6_0_,
        paymentaut1_.payment_authority_key as payment_5_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_1_,
        paymentaut1_.payment_authority_obligation_key as payment_1_7_2_,
        paymentaut1_.end_date as end_date2_7_2_,
        paymentaut1_.obligation_key as obligati4_7_2_,
        paymentaut1_.payment_authority_key as payment_5_7_2_,
        paymentaut1_.start_date as start_da3_7_2_,
        obligation2_.obligation_key as obligati1_1_3_,
        obligation2_.acc as acc2_1_3_,
        obligation2_.category_of_care as category3_1_3_,
        obligation2_.category_of_care_subset as category4_1_3_,
        obligation2_.cost_center_boc as cost_cen5_1_3_,
        obligation2_.fund as fund6_1_3_,
        obligation2_.last_updated_date as last_upd7_1_3_,
        obligation2_.last_updated_user as last_upd8_1_3_,
        obligation2_.mnemonics as mnemonic9_1_3_,
        obligation2_.obligation_number as obligat10_1_3_,
        cptobligat3_.obligation_key as obligati4_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_4_,
        cptobligat3_.cpt_obligation_key as cpt_obli1_0_5_,
        cptobligat3_.end_date as end_date2_0_5_,
        cptobligat3_.obligation_key as obligati4_0_5_,
        cptobligat3_.procedure_key as procedur5_0_5_,
        cptobligat3_.start_date as start_da3_0_5_,
        procedure4_.procedure_key as procedur1_28_6_,
        procedure4_.procedure_code as procedur2_28_6_,
        procedure4_.short_description as short_de3_28_6_ 
    from
        ccra.payment_authority paymentaut0_ 
    left outer join
        ccra.payment_authority_obligation paymentaut1_ 
            on paymentaut0_.payment_authority_key=paymentaut1_.payment_authority_key 
    left outer join
        ccra.obligation obligation2_ 
            on paymentaut1_.obligation_key=obligation2_.obligation_key 
    left outer join
        ccra.cpt_obligation cptobligat3_ 
            on obligation2_.obligation_key=cptobligat3_.obligation_key 
    left outer join
        dim_procedure_code procedure4_ 
            on cptobligat3_.procedure_key=procedure4_.procedure_key 
    where
        paymentaut0_.payment_authority_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.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-17 08:25:21.038 INFO BatchProcessor         - Claim processing thread Thread[SimpleAsyncTaskExecutor-4,5,main] completed, processed 3 claims
2018-04-17 08:25:21.038 INFO BatchProcessor         - Batch 'inst_batch_1', host 'JX574H2' completed successfully, processed 7 lines, 15 failures
2018-04-17 08:25:21.039 INFO BatchProcessor         - Updating status of batch 'inst_batch_1' to RULES_COMPLETED
Hibernate: 
    /* load gov.va.ccrs.brengine.batchprocessing.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.batchprocessing.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.batchprocessing.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.batchprocessing.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-17 08:25:21.048 INFO EmailNotifier          - Sending email to 'alexander@myarch.com'. Subject:
Batch 'inst_batch_1', host 'JX574H2' completed successfully, processed 7 lines, 15 failures
2018-04-17 08:25:21.048 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-17 08:25:21.065 INFO nfigApplicationContext - Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@13bc8645: startup date [Tue Apr 17 08:25:08 EDT 2018]; root of context hierarchy
2018-04-17 08:25:21.071 INFO aultLifecycleProcessor - Stopping beans in phase 2147483547
2018-04-17 08:25:21.071 INFO aultLifecycleProcessor - Stopping beans in phase 0
2018-04-17 08:25:21.084 INFO tityManagerFactoryBean - Closing JPA EntityManagerFactory for persistence unit 'default'
2018-04-17 08:25:21.088 INFO HikariDataSource       - HikariPool-1 - Shutdown initiated...
2018-04-17 08:25:21.107 INFO HikariDataSource       - HikariPool-1 - Shutdown completed.
