2018-04-20 16:07:31.059 INFO estContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [gov.va.ccrs.brengine.rule.DuplicateRulesSqlServerTest], using SpringBootContextLoader
2018-04-20 16:07:31.071 INFO AbstractContextLoader  - Could not detect default resource locations for test class [gov.va.ccrs.brengine.rule.DuplicateRulesSqlServerTest]: no resource found for suffixes {-context.xml, Context.groovy}.
2018-04-20 16:07:31.071 INFO nfigContextLoaderUtils - Could not detect default configuration classes for test class [gov.va.ccrs.brengine.rule.DuplicateRulesSqlServerTest]: DuplicateRulesSqlServerTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration.
2018-04-20 16:07:31.371 INFO estContextBootstrapper - Found @SpringBootConfiguration gov.va.ccrs.brengine.BrEngineApplication for test class gov.va.ccrs.brengine.rule.DuplicateRulesSqlServerTest
2018-04-20 16:07:31.538 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-20 16:07:31.560 INFO estContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@7c24b813, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@2c35e847, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@7bd4937b, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@21e360a, org.springframework.test.context.support.DirtiesContextTestExecutionListener@5ba3f27a, org.springframework.test.context.transaction.TransactionalTestExecutionListener@58d75e99, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@74751b3, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@741a8937, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@306e95ec, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@52af26ee, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@6fd83fc1, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@4f2b503c]
2018-04-20 16:07:31.992 INFO cateRulesSqlServerTest - Starting DuplicateRulesSqlServerTest on JX574H2 with PID 24192 (started by DWei in C:\Users\DWei\CCRS-BUSRULES\brengine)
2018-04-20 16:07:31.992 INFO cateRulesSqlServerTest - The following profiles are active: int
2018-04-20 16:07:32.039 INFO nfigApplicationContext - Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@407a7f2a: startup date [Fri Apr 20 16:07:32 EDT 2018]; root of context hierarchy
2018-04-20 16:07:33.362 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-20 16:07:34.964 INFO anPostProcessorChecker - Bean 'org.springframework.kafka.annotation.KafkaBootstrapConfiguration' of type [org.springframework.kafka.annotation.KafkaBootstrapConfiguration$$EnhancerBySpringCGLIB$$d67d8e4f] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-20 16:07:35.010 INFO anPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$2cb7ccc] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2018-04-20 16:07:35.749 INFO HikariDataSource       - HikariPool-1 - Starting...
2018-04-20 16:07:37.107 INFO HikariDataSource       - HikariPool-1 - Start completed.
2018-04-20 16:07:37.290 INFO tityManagerFactoryBean - Building JPA container EntityManagerFactory for persistence unit 'default'
2018-04-20 16:07:39.130 WARN RootClass              - HHH000038: Composite-id class does not override equals(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-20 16:07:39.141 WARN RootClass              - HHH000039: Composite-id class does not override hashCode(): gov.va.ccrs.brengine.seoc.SeocProcedure
2018-04-20 16:07:39.900 INFO tityManagerFactoryBean - Initialized JPA EntityManagerFactory for persistence unit 'default'
2018-04-20 16:07:41.206 INFO HoconUtils             - Loading config file from C:\Users\DWei\CCRS-BUSRULES\brengine\bin\main\rules-config.conf
2018-04-20 16:07:42.311 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-20 16:07:42.429 WARN User                   - User.withDefaultPasswordEncoder() is considered unsafe for production and is only intended for sample applications.
2018-04-20 16:07:43.020 INFO ultSecurityFilterChain - Creating filter chain: Ant [pattern='/fetchDecisions/**'], [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@6b86826a, org.springframework.security.web.context.SecurityContextPersistenceFilter@34695b23, org.springframework.security.web.header.HeaderWriterFilter@fa11fda, org.springframework.security.web.csrf.CsrfFilter@29bd2796, org.springframework.security.web.authentication.logout.LogoutFilter@65d23aa3, org.springframework.security.web.authentication.www.BasicAuthenticationFilter@cfacf0, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@6774f264, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@3dad535f, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@3c2dda7c, org.springframework.security.web.session.SessionManagementFilter@7d95166a, org.springframework.security.web.access.ExceptionTranslationFilter@598e5cb8, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@4bbc02ef]
2018-04-20 16:07:43.070 INFO ultSecurityFilterChain - Creating filter chain: org.springframework.security.web.util.matcher.AnyRequestMatcher@1, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@74f649a7, org.springframework.security.web.context.SecurityContextPersistenceFilter@31e22365, org.springframework.security.web.header.HeaderWriterFilter@41404aa2, org.springframework.security.web.authentication.logout.LogoutFilter@59c08cf1, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@7323dce7, org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter@799971ac, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@2ebf524, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@41bdaa81, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@308c65e0, org.springframework.security.web.session.SessionManagementFilter@b267745, org.springframework.security.web.access.ExceptionTranslationFilter@452ec287, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@470135da]
2018-04-20 16:07:43.283 INFO AbstractContextSource  - Property 'userDn' not set - anonymous context will be used for read-write operations
2018-04-20 16:07:44.444 INFO aultLifecycleProcessor - Starting beans in phase 2147483547
2018-04-20 16:07:44.457 INFO ationBeanPostProcessor - No TaskScheduler/ScheduledExecutorService bean found for scheduled processing
2018-04-20 16:07:44.472 INFO cateRulesSqlServerTest - Started DuplicateRulesSqlServerTest in 12.833 seconds (JVM running for 14.497)
2018-04-20 16:07:44.725 INFO cateRulesSqlServerTest - ---- testAll: 
2018-04-20 16:07:44.726 INFO cateRulesSqlServerTest - 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-20 16:07:45.271 INFO DecisionDaoImpl        - Deleted 0 decisions and 0 failures for batchId AA_20171024_A
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType formType 
    join
        fetch c.profClaimLines line 
    left join
        fetch c.billingProvider billProv 
    left join
        fetch c.renderingProvider renderingProv 
    left join
        fetch billProv.locations 
    left join
        fetch c.patient patient 
    left join
        fetch line.placeOfService 
    left join
        fetch line.renderingProvider rendProv 
    left join
        fetch rendProv.locations 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers modifier 
    where
        c.isCurrent=true 
        and line.isCurrent=true 
        and (
            modifier is null 
            or modifier.isCurrent=true 
        ) 
        and formType.code='837P' 
        and line.key not in (
            select
                claimLineKey 
            from
                Decision d 
            where
                d.claim.key=c.key
        ) 
        and c.batchId=?1 */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser7_.pos_key as pos_key1_27_3_,
            provider8_.provider_key as provider1_29_4_,
            locations9_.provider_location_key as provider1_37_5_,
            procedure10_.procedure_key as procedur1_28_6_,
            modifiers11_.claim_line_modifier_key as claim_li1_19_7_,
            provider3_.provider_key as provider1_29_8_,
            locations5_.provider_location_key as provider1_37_9_,
            provider4_.provider_key as provider1_29_10_,
            patient6_.patient_key as patient_1_25_11_,
            claim0_.etl_batch_id as etl_batc2_30_0_,
            claim0_.billing_provider_key as billing16_30_0_,
            claim0_.ccn_region as ccn_regi3_30_0_,
            claim0_.charge_amount as charge_a4_30_0_,
            claim0_.claim_id as claim_id5_30_0_,
            claim0_.end_date as end_date6_30_0_,
            claim0_.form_type_key as form_ty17_30_0_,
            claim0_.is_current as is_curre7_30_0_,
            claim0_.last_updated_date as last_upd8_30_0_,
            claim0_.other_insurance as other_in9_30_0_,
            claim0_.patient_key as patient18_30_0_,
            claim0_.patient_account_number as patient10_30_0_,
            claim0_.preauth_number as preauth11_30_0_,
            claim0_.claim_receipt_date as claim_r12_30_0_,
            claim0_.referral_number as referra13_30_0_,
            claim0_.referring_provider_key as referri19_30_0_,
            claim0_.rendering_provider_key as renderi20_30_0_,
            claim0_.source_system as source_14_30_0_,
            claim0_.start_date as start_d15_30_0_,
            claim0_.station_key as station21_30_0_,
            formtype1_.form_code as form_cod2_22_1_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser7_.pos_code as pos_code2_27_3_,
            provider8_.provider_name as provider2_29_4_,
            provider8_.npi as npi3_29_4_,
            provider8_.tax_id as tax_id4_29_4_,
            locations9_.address1 as address2_37_5_,
            locations9_.city as city3_37_5_,
            locations9_.country_code as country_4_37_5_,
            locations9_.postal_code as postal_c5_37_5_,
            locations9_.provider_key as provider8_37_5_,
            locations9_.provider_phone as provider6_37_5_,
            locations9_.state_long_name as state_lo7_37_5_,
            locations9_.provider_key as provider8_37_1__,
            locations9_.provider_location_key as provider1_37_1__,
            procedure10_.procedure_code as procedur2_28_6_,
            procedure10_.short_description as short_de3_28_6_,
            modifiers11_.modifier_code as modifier2_19_7_,
            modifiers11_.claim_detail_key_dt as claim_de4_19_7_,
            modifiers11_.claim_detail_key_in as claim_de5_19_7_,
            modifiers11_.is_current as is_curre3_19_7_,
            modifiers11_.claim_detail_key_pr as claim_de6_19_7_,
            modifiers11_.claim_detail_key_pr as claim_de6_19_2__,
            modifiers11_.claim_line_modifier_key as claim_li1_19_2__,
            provider3_.provider_name as provider2_29_8_,
            provider3_.npi as npi3_29_8_,
            provider3_.tax_id as tax_id4_29_8_,
            locations5_.address1 as address2_37_9_,
            locations5_.city as city3_37_9_,
            locations5_.country_code as country_4_37_9_,
            locations5_.postal_code as postal_c5_37_9_,
            locations5_.provider_key as provider8_37_9_,
            locations5_.provider_phone as provider6_37_9_,
            locations5_.state_long_name as state_lo7_37_9_,
            locations5_.provider_key as provider8_37_3__,
            locations5_.provider_location_key as provider1_37_3__,
            provider4_.provider_name as provider2_29_10_,
            provider4_.npi as npi3_29_10_,
            provider4_.tax_id as tax_id4_29_10_,
            patient6_.address1 as address2_25_11_,
            patient6_.address2 as address3_25_11_,
            patient6_.etl_batch_id as etl_batc4_25_11_,
            patient6_.city as city5_25_11_,
            patient6_.date_of_birth as date_of_6_25_11_,
            patient6_.first_name as first_na7_25_11_,
            patient6_.icn as icn8_25_11_,
            patient6_.insured_id as insured_9_25_11_,
            patient6_.last_name as last_na10_25_11_,
            patient6_.member_id as member_11_25_11_,
            patient6_.middle_initial as middle_12_25_11_,
            patient6_.postal_code as postal_13_25_11_,
            patient6_.sex as sex14_25_11_,
            patient6_.ssn as ssn15_25_11_,
            patient6_.state_code as state_c16_25_11_ 
        from
            dim_va_claim claim0_ 
        inner join
            dim_claim_form_type formtype1_ 
                on claim0_.form_type_key=formtype1_.form_type_key 
        inner join
            f_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser7_ 
                on profclaiml2_.pos_key=placeofser7_.pos_key 
        left outer join
            dim_provider provider8_ 
                on profclaiml2_.rendering_provider_key=provider8_.provider_key 
        left outer join
            provider_location locations9_ 
                on provider8_.provider_key=locations9_.provider_key 
        left outer join
            dim_procedure_code procedure10_ 
                on profclaiml2_.procedure_key=procedure10_.procedure_key 
        left outer join
            claim_line_modifier modifiers11_ 
                on profclaiml2_.claim_detail_key=modifiers11_.claim_detail_key_pr 
        left outer join
            dim_provider provider3_ 
                on claim0_.billing_provider_key=provider3_.provider_key 
        left outer join
            provider_location locations5_ 
                on provider3_.provider_key=locations5_.provider_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.rendering_provider_key=provider4_.provider_key 
        left outer join
            dim_patient patient6_ 
                on claim0_.patient_key=patient6_.patient_key 
        where
            claim0_.is_current='Y' 
            and profclaiml2_.is_current='Y' 
            and (
                modifiers11_.claim_line_modifier_key is null 
                or modifiers11_.is_current='Y'
            ) 
            and formtype1_.form_code='837P' 
            and (
                profclaiml2_.claim_detail_key not in  (
                    select
                        decision12_.claim_detail_key 
                    from
                        decision decision12_ 
                    where
                        decision12_.claim_key=claim0_.claim_key
                )
            ) 
            and claim0_.etl_batch_id=?
2018-04-20 16:07:45.781 INFO cateRulesSqlServerTest - ---- total claims: 6
Hibernate: 
    /* select
        distinct c 
    from
        Claim c 
    join
        fetch c.formType 
    join
        fetch c.profClaimLines line 
    join
        fetch c.decisions d 
    left join
        fetch c.billingProvider 
    left join
        fetch c.patient pt 
    left join
        fetch line.placeOfService 
    left join
        fetch line.procedure 
    left join
        fetch line.modifiers 
    where
        c.isCurrent = 'Y' 
        and d.decisionType in (
            'APPROVED', 'BILL_SENT', 'PAID'
        ) 
        and c.sourceSystem = 'EDI' */ select
            distinct claim0_.claim_key as claim_ke1_30_0_,
            formtype1_.form_type_key as form_typ1_22_1_,
            profclaiml2_.claim_detail_key as claim_de1_35_2_,
            placeofser6_.pos_key as pos_key1_27_3_,
            procedure7_.procedure_key as procedur1_28_4_,
            modifiers8_.claim_line_modifier_key as claim_li1_19_5_,
            decisions3_.decision_key as decision1_21_6_,
            provider4_.provider_key as provider1_29_7_,
            patient5_.patient_key as patient_1_25_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_,
            profclaiml2_.etl_batch_id as etl_batc2_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_2_,
            profclaiml2_.date_paid as date_pai3_35_2_,
            profclaiml2_.is_current as is_curre4_35_2_,
            profclaiml2_.line_item_control_number as line_ite5_35_2_,
            profclaiml2_.charge_amount as charge_a6_35_2_,
            profclaiml2_.pos_key as pos_key10_35_2_,
            profclaiml2_.procedure_key as procedu11_35_2_,
            profclaiml2_.rendering_provider_key as renderi12_35_2_,
            profclaiml2_.service_date_from as service_7_35_2_,
            profclaiml2_.service_date_to as service_8_35_2_,
            profclaiml2_.claim_key as claim_ke9_35_0__,
            profclaiml2_.claim_detail_key as claim_de1_35_0__,
            placeofser6_.pos_code as pos_code2_27_3_,
            procedure7_.procedure_code as procedur2_28_4_,
            procedure7_.short_description as short_de3_28_4_,
            modifiers8_.modifier_code as modifier2_19_5_,
            modifiers8_.claim_detail_key_dt as claim_de4_19_5_,
            modifiers8_.claim_detail_key_in as claim_de5_19_5_,
            modifiers8_.is_current as is_curre3_19_5_,
            modifiers8_.claim_detail_key_pr as claim_de6_19_5_,
            modifiers8_.claim_detail_key_pr as claim_de6_19_1__,
            modifiers8_.claim_line_modifier_key as claim_li1_19_1__,
            decisions3_.etl_batch_id as etl_batc2_21_6_,
            decisions3_.claim_key as claim_ke8_21_6_,
            decisions3_.claim_detail_key as claim_de3_21_6_,
            decisions3_.decision_date_time as decision4_21_6_,
            decisions3_.decision as decision5_21_6_,
            decisions3_.last_updated_user as last_upd6_21_6_,
            decisions3_.last_updated_date_time as last_upd7_21_6_,
            decisions3_.claim_key as claim_ke8_21_2__,
            decisions3_.decision_key as decision1_21_2__,
            provider4_.provider_name as provider2_29_7_,
            provider4_.npi as npi3_29_7_,
            provider4_.tax_id as tax_id4_29_7_,
            patient5_.address1 as address2_25_8_,
            patient5_.address2 as address3_25_8_,
            patient5_.etl_batch_id as etl_batc4_25_8_,
            patient5_.city as city5_25_8_,
            patient5_.date_of_birth as date_of_6_25_8_,
            patient5_.first_name as first_na7_25_8_,
            patient5_.icn as icn8_25_8_,
            patient5_.insured_id as insured_9_25_8_,
            patient5_.last_name as last_na10_25_8_,
            patient5_.member_id as member_11_25_8_,
            patient5_.middle_initial as middle_12_25_8_,
            patient5_.postal_code as postal_13_25_8_,
            patient5_.sex as sex14_25_8_,
            patient5_.ssn as ssn15_25_8_,
            patient5_.state_code as state_c16_25_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_professional_medical_claim_details profclaiml2_ 
                on claim0_.claim_key=profclaiml2_.claim_key 
        left outer join
            dim_place_of_service placeofser6_ 
                on profclaiml2_.pos_key=placeofser6_.pos_key 
        left outer join
            dim_procedure_code procedure7_ 
                on profclaiml2_.procedure_key=procedure7_.procedure_key 
        left outer join
            claim_line_modifier modifiers8_ 
                on profclaiml2_.claim_detail_key=modifiers8_.claim_detail_key_pr 
        inner join
            decision decisions3_ 
                on claim0_.claim_key=decisions3_.claim_key 
        left outer join
            dim_provider provider4_ 
                on claim0_.billing_provider_key=provider4_.provider_key 
        left outer join
            dim_patient patient5_ 
                on claim0_.patient_key=patient5_.patient_key 
        where
            claim0_.is_current='Y' 
            and (
                decisions3_.decision in (
                    'APPROVED' , 'BILL_SENT' , 'PAID'
                )
            ) 
            and claim0_.source_system='EDI'
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
Hibernate: 
    select
        provider0_.provider_key as provider1_29_0_,
        provider0_.provider_name as provider2_29_0_,
        provider0_.npi as npi3_29_0_,
        provider0_.tax_id as tax_id4_29_0_ 
    from
        dim_provider provider0_ 
    where
        provider0_.provider_key=?
2018-04-20 16:07:47.020 INFO DuplicateRules         - ---- doMatchProf() find a match (no service_date_to): line 946 : is duplicated to 422 .
2018-04-20 16:07:47.020 INFO DuplicateRules         - ---- areModifiersMatch() ignore because no modifier.
2018-04-20 16:07:47.020 INFO cateRulesSqlServerTest - ---- total outcomes: 1
2018-04-20 16:07:47.020 INFO cateRulesSqlServerTest - outcome: ValidationFailure [ruleName=duplicate, validationName=PROFESSIONAL, message=Duplicate claim line, claimKey=1234, claimLineKey=946, claim=Claim [id=1234, claimId=CLAIM0002, batchId=AA_20171024_A, isCurrent=true, formType=FormType [code=837P], referralNumber=VA0000000077, sourceSystem=EDI, startDate=2017-11-26], claimLine=ClaimLine [key=946, providerPaidDate=null]:ProfessionalClaimLine [serviceDateFrom=2017-10-01, serviceDateTo=null, chargeAmt=100.0000]]
2018-04-20 16:07:47.036 INFO nfigApplicationContext - Closing org.springframework.context.annotation.AnnotationConfigApplicationContext@407a7f2a: startup date [Fri Apr 20 16:07:32 EDT 2018]; root of context hierarchy
2018-04-20 16:07:47.036 INFO aultLifecycleProcessor - Stopping beans in phase 2147483547
2018-04-20 16:07:47.036 INFO aultLifecycleProcessor - Stopping beans in phase 0
2018-04-20 16:07:47.067 INFO tityManagerFactoryBean - Closing JPA EntityManagerFactory for persistence unit 'default'
2018-04-20 16:07:47.067 INFO HikariDataSource       - HikariPool-1 - Shutdown initiated...
2018-04-20 16:07:47.067 INFO HikariDataSource       - HikariPool-1 - Shutdown completed.

