Created
March 16, 2016 21:22
-
-
Save elmatt/b000bc28909453effc95 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Hibernate: | |
select | |
person0_.ID as ID1_17_0_, | |
person0_.ADDRESS_1 as ADDRESS_2_17_0_, | |
person0_.ADDRESS_2 as ADDRESS_3_17_0_, | |
person0_.CITY as CITY4_17_0_, | |
person0_.DATE_OF_BIRTH as DATE_OF_5_17_0_, | |
person0_.FIRST_NAME as FIRST_NA6_17_0_, | |
person0_.GENDER as GENDER7_17_0_, | |
person0_.LAST_NAME as LAST_NAM8_17_0_, | |
person0_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_0_, | |
person0_.MIDDLE_NAME as MIDDLE_10_17_0_, | |
person0_.PHONE_NUMBER as PHONE_N11_17_0_, | |
person0_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_0_, | |
person0_.STATE as STATE13_17_0_, | |
person0_.TENANT_ID as TENANT_14_17_0_, | |
person0_.VERSION as VERSION15_17_0_, | |
person0_.ZIP_CODE as ZIP_COD16_17_0_, | |
activities1_.MEMBER_ID as MEMBER_I9_17_1_, | |
activities1_.ID as ID1_0_1_, | |
activities1_.ID as ID1_0_2_, | |
activities1_.ACTIVITY_DATE as ACTIVITY2_0_2_, | |
activities1_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_2_, | |
activities1_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_2_, | |
activities1_.CASE_ID as CASE_ID7_0_2_, | |
activities1_.CLAIM_ID as CLAIM_ID8_0_2_, | |
activities1_.CREATED_BY_ID as CREATED_4_0_2_, | |
activities1_.CREATED_BY_NAME as CREATED_5_0_2_, | |
activities1_.MEMBER_ID as MEMBER_I9_0_2_, | |
code2_.ID as ID1_6_3_, | |
code2_.DISPLAY as DISPLAY2_6_3_, | |
code2_.CODE_GROUP as CODE_GRO3_6_3_, | |
code2_.CODE_KEY as CODE_KEY4_6_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
claim4_.ID as ID1_4_5_, | |
claim4_.CASE_ID as CASE_ID19_4_5_, | |
claim4_.ADMISSION_DATE as ADMISSIO2_4_5_, | |
claim4_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_5_, | |
claim4_.CLAIM_NUMBER as CLAIM_NU4_4_5_, | |
claim4_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_5_, | |
claim4_.CLAIM_STATUS_CODE as CLAIM_S21_4_5_, | |
claim4_.CLAIM_TYPE_CODE as CLAIM_T22_4_5_, | |
claim4_.DONOR_ID as DONOR_I23_4_5_, | |
claim4_.DRG_CODE as DRG_CODE5_4_5_, | |
claim4_.FACILITY_NPI as FACILITY6_4_5_, | |
claim4_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_5_, | |
claim4_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_5_, | |
claim4_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_5_, | |
claim4_.PROVIDER_FACILITY_NAME as PROVIDE10_4_5_, | |
claim4_.PROVIDER_TAX_ID as PROVIDE11_4_5_, | |
claim4_.RECEIVED_DATE as RECEIVE12_4_5_, | |
claim4_.SERVICE_FROM_DATE as SERVICE13_4_5_, | |
claim4_.SERVICE_TO_DATE as SERVICE14_4_5_, | |
claim4_.STATEMENT_FROM_DATE as STATEME15_4_5_, | |
claim4_.STATEMENT_TO_DATE as STATEME16_4_5_, | |
claim4_.TENANT_ID as TENANT_17_4_5_, | |
claim4_.TOTAL_CHARGES as TOTAL_C18_4_5_, | |
cases5_.MEMBER_PERSON_ID as MEMBER_19_17_6_, | |
cases5_.ID as ID1_3_6_, | |
cases5_.ID as ID1_3_7_, | |
cases5_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_7_, | |
cases5_.BEGIN_DATE as BEGIN_DA3_3_7_, | |
cases5_.CASE_MANAGER_ID as CASE_MAN4_3_7_, | |
cases5_.CASE_MANAGER_NAME as CASE_MAN5_3_7_, | |
cases5_.CASE_NUMBER as CASE_NUM6_3_7_, | |
cases5_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_7_, | |
cases5_.CASE_RATE as CASE_RAT8_3_7_, | |
cases5_.CASE_STATUS_CODE as CASE_ST17_3_7_, | |
cases5_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_7_, | |
cases5_.CLOSED_DATE as CLOSED_D9_3_7_, | |
cases5_.DESCRIPTION as DESCRIP10_3_7_, | |
cases5_.END_DATE as END_DAT11_3_7_, | |
cases5_.GLOBAL_END_DATE as GLOBAL_12_3_7_, | |
cases5_.GLOBAL_START_DATE as GLOBAL_13_3_7_, | |
cases5_.HIC_NUMBER as HIC_NUM14_3_7_, | |
cases5_.MEMBER_PERSON_ID as MEMBER_19_3_7_, | |
cases5_.PAYER_CONTRACT_ID as PAYER_C20_3_7_, | |
cases5_.TENANT_ID as TENANT_15_3_7_, | |
cases5_.VERSION as VERSION16_3_7_, | |
code6_.ID as ID1_6_8_, | |
code6_.DISPLAY as DISPLAY2_6_8_, | |
code6_.CODE_GROUP as CODE_GRO3_6_8_, | |
code6_.CODE_KEY as CODE_KEY4_6_8_, | |
claims7_.CASE_ID as CASE_ID19_3_9_, | |
claims7_.ID as ID1_4_9_, | |
claims7_.ID as ID1_4_10_, | |
claims7_.CASE_ID as CASE_ID19_4_10_, | |
claims7_.ADMISSION_DATE as ADMISSIO2_4_10_, | |
claims7_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_10_, | |
claims7_.CLAIM_NUMBER as CLAIM_NU4_4_10_, | |
claims7_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_10_, | |
claims7_.CLAIM_STATUS_CODE as CLAIM_S21_4_10_, | |
claims7_.CLAIM_TYPE_CODE as CLAIM_T22_4_10_, | |
claims7_.DONOR_ID as DONOR_I23_4_10_, | |
claims7_.DRG_CODE as DRG_CODE5_4_10_, | |
claims7_.FACILITY_NPI as FACILITY6_4_10_, | |
claims7_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_10_, | |
claims7_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_10_, | |
claims7_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_10_, | |
claims7_.PROVIDER_FACILITY_NAME as PROVIDE10_4_10_, | |
claims7_.PROVIDER_TAX_ID as PROVIDE11_4_10_, | |
claims7_.RECEIVED_DATE as RECEIVE12_4_10_, | |
claims7_.SERVICE_FROM_DATE as SERVICE13_4_10_, | |
claims7_.SERVICE_TO_DATE as SERVICE14_4_10_, | |
claims7_.STATEMENT_FROM_DATE as STATEME15_4_10_, | |
claims7_.STATEMENT_TO_DATE as STATEME16_4_10_, | |
claims7_.TENANT_ID as TENANT_17_4_10_, | |
claims7_.TOTAL_CHARGES as TOTAL_C18_4_10_, | |
code8_.ID as ID1_6_11_, | |
code8_.DISPLAY as DISPLAY2_6_11_, | |
code8_.CODE_GROUP as CODE_GRO3_6_11_, | |
code8_.CODE_KEY as CODE_KEY4_6_11_, | |
donors9_.CASE_ID as CASE_ID4_3_12_, | |
donors9_.ID as ID1_8_12_, | |
donors9_.ID as ID1_8_13_, | |
donors9_.authorization_number as authoriz2_8_13_, | |
donors9_.CASE_ID as CASE_ID4_8_13_, | |
donors9_.name as name3_8_13_, | |
donors9_.TYPE_CODE as TYPE_COD5_8_13_, | |
notes10_.CASE_ID as CASE_ID3_3_14_, | |
notes10_.ID as ID1_14_14_, | |
notes10_.ID as ID1_14_15_, | |
notes10_.CASE_ID as CASE_ID3_14_15_, | |
notes10_.NOTE as NOTE2_14_15_, | |
payercontr11_.ID as ID1_16_16_, | |
payercontr11_.BASE_CONTRACT_RATE as BASE_CON2_16_16_, | |
payercontr11_.BEGIN_DATE as BEGIN_DA3_16_16_, | |
payercontr11_.DESCRIPTION as DESCRIPT4_16_16_, | |
payercontr11_.DONOR_CLAIM_PHASE as DONOR_CL5_16_16_, | |
payercontr11_.END_DATE as END_DATE6_16_16_, | |
payercontr11_.GLOBAL_START_PHASE as GLOBAL_S7_16_16_, | |
payercontr11_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_16_, | |
payercontr11_.PAYER_ID as PAYER_I14_16_16_, | |
payercontr11_.STOPLOSS_AMOUNT as STOPLOSS9_16_16_, | |
payercontr11_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_16_, | |
payercontr11_.TENANT_ID as TENANT_11_16_16_, | |
payercontr11_.TIMELY_FILING_DAYS as TIMELY_12_16_16_, | |
payercontr11_.TYPE_CODE as TYPE_CO15_16_16_, | |
payercontr11_.VERSION as VERSION13_16_16_, | |
phasedates12_.CASE_ID as CASE_ID6_3_17_, | |
phasedates12_.ID as ID1_26_17_, | |
phasedates12_.ID as ID1_26_18_, | |
phasedates12_.BEGIN_DATE as BEGIN_DA2_26_18_, | |
phasedates12_.CASE_ID as CASE_ID6_26_18_, | |
phasedates12_.END_DATE as END_DATE3_26_18_, | |
phasedates12_.FIN_NUMBER as FIN_NUMB4_26_18_, | |
phasedates12_.PHASE_NAME as PHASE_NA5_26_18_, | |
healthplan13_.MEMBER_PERSON_ID as MEMBER_10_17_19_, | |
healthplan13_.ID as ID1_12_19_, | |
healthplan13_.ID as ID1_12_20_, | |
healthplan13_.GROUP_NUMBER as GROUP_NU2_12_20_, | |
healthplan13_.MEMBER_PERSON_ID as MEMBER_10_12_20_, | |
healthplan13_.MEMBER_NUMBER as MEMBER_N3_12_20_, | |
healthplan13_.PAYER_ID as PAYER_I11_12_20_, | |
healthplan13_.PLAN_NAME as PLAN_NAM4_12_20_, | |
healthplan13_.PLAN_SEQUENCE as PLAN_SEQ5_12_20_, | |
healthplan13_.POLICY_TYPE as POLICY_T6_12_20_, | |
healthplan13_.removeFromMember as removeFr7_12_20_, | |
healthplan13_.SUBSCRIBER_NAME as SUBSCRIB8_12_20_, | |
healthplan13_.TENANT_ID as TENANT_I9_12_20_ | |
from | |
vbr.Person person0_ | |
left outer join | |
vbr.Activities activities1_ | |
on person0_.ID=activities1_.MEMBER_ID | |
left outer join | |
vbr.Code code2_ | |
on activities1_.ACTIVITY_TYPE_CODE=code2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on activities1_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Claim claim4_ | |
on activities1_.CLAIM_ID=claim4_.ID | |
left outer join | |
vbr.Cases cases5_ | |
on person0_.ID=cases5_.MEMBER_PERSON_ID | |
left outer join | |
vbr.Code code6_ | |
on cases5_.CASE_STATUS_CODE=code6_.ID | |
left outer join | |
vbr.Claim claims7_ | |
on cases5_.ID=claims7_.CASE_ID | |
left outer join | |
vbr.Code code8_ | |
on cases5_.CLOSED_CASE_REASON_CODE=code8_.ID | |
left outer join | |
vbr.Donor donors9_ | |
on cases5_.ID=donors9_.CASE_ID | |
left outer join | |
vbr.NOTES notes10_ | |
on cases5_.ID=notes10_.CASE_ID | |
left outer join | |
vbr.PayerContract payercontr11_ | |
on cases5_.PAYER_CONTRACT_ID=payercontr11_.ID | |
left outer join | |
vbr.phasedates phasedates12_ | |
on cases5_.ID=phasedates12_.CASE_ID | |
left outer join | |
vbr.HealthPlan healthplan13_ | |
on person0_.ID=healthplan13_.MEMBER_PERSON_ID | |
where | |
person0_.ID=? | |
order by | |
phasedates12_.BEGIN_DATE | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
providerpa0_.CLAIM_ID as CLAIM_ID6_4_0_, | |
providerpa0_.ID as ID1_22_0_, | |
providerpa0_.ID as ID1_22_1_, | |
providerpa0_.AMOUNT as AMOUNT2_22_1_, | |
providerpa0_.CHECK_DATE as CHECK_DA3_22_1_, | |
providerpa0_.CHECK_NUMBER as CHECK_NU4_22_1_, | |
providerpa0_.CLAIM_ID as CLAIM_ID6_22_1_, | |
providerpa0_.DENIAL_REASON as DENIAL_R5_22_1_ | |
from | |
vbr.ProviderPayment providerpa0_ | |
where | |
providerpa0_.CLAIM_ID=? | |
Hibernate: | |
select | |
lineitems0_.CLAIM_ID as CLAIM_I26_4_0_, | |
lineitems0_.ID as ID1_13_0_, | |
lineitems0_.ID as ID1_13_1_, | |
lineitems0_.CHARGES as CHARGES2_13_1_, | |
lineitems0_.POINTER as POINTER3_13_1_, | |
lineitems0_.CLAIM_ID as CLAIM_I26_13_1_, | |
lineitems0_.COVERED_CHARGES as COVERED_4_13_1_, | |
lineitems0_.CPT_CODE as CPT_CODE5_13_1_, | |
lineitems0_.DESCRIPTION as DESCRIPT6_13_1_, | |
lineitems0_.EMG as EMG7_13_1_, | |
lineitems0_.FAMILY_PLAN as FAMILY_P8_13_1_, | |
lineitems0_.FROM_DATE as FROM_DAT9_13_1_, | |
lineitems0_.LINE_ITEM_NUMBER as LINE_IT10_13_1_, | |
lineitems0_.MODIFIER as MODIFIE11_13_1_, | |
lineitems0_.MODIFIER1 as MODIFIE12_13_1_, | |
lineitems0_.MODIFIER2 as MODIFIE13_13_1_, | |
lineitems0_.MODIFIER3 as MODIFIE14_13_1_, | |
lineitems0_.NON_COVERED_CHARGES as NON_COV15_13_1_, | |
lineitems0_.PLACE_OF_SERVICE as PLACE_O16_13_1_, | |
lineitems0_.QUALIFIER_ID as QUALIFI17_13_1_, | |
lineitems0_.RATE as RATE18_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_1_, | |
lineitems0_.REVENUE_CODE as REVENUE21_13_1_, | |
lineitems0_.SERVICE_DATE as SERVICE22_13_1_, | |
lineitems0_.TO_DATE as TO_DATE23_13_1_, | |
lineitems0_.TOTAL_CHARGES as TOTAL_C24_13_1_, | |
lineitems0_.UNITS as UNITS25_13_1_ | |
from | |
vbr.LineItem lineitems0_ | |
where | |
lineitems0_.CLAIM_ID=? | |
Hibernate: | |
select | |
eobs0_.CLAIM_ID as CLAIM_I12_4_0_, | |
eobs0_.ID as ID1_10_0_, | |
eobs0_.ID as ID1_10_1_, | |
eobs0_.CLAIM_ID as CLAIM_I12_10_1_, | |
eobs0_.CLAIM_DRG_CODE as CLAIM_DR2_10_1_, | |
eobs0_.CLAIM_NUMBER as CLAIM_NU3_10_1_, | |
eobs0_.CLAIM_PAYER_CONTROL_NUMBER as CLAIM_PA4_10_1_, | |
eobs0_.CLAIM_PROCESSING_METHOD as CLAIM_PR5_10_1_, | |
eobs0_.DETAIL_TYPE_CODE as DETAIL_13_10_1_, | |
eobs0_.INTEREST as INTEREST6_10_1_, | |
eobs0_.LINE_ITEM_ID as LINE_IT14_10_1_, | |
eobs0_.LINE_ITEM_NUMBER as LINE_ITE7_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_CODE as LINE_ITE8_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_TYPE as LINE_ITE9_10_1_, | |
eobs0_.PAYMENT as PAYMENT10_10_1_, | |
eobs0_.REMITTANCE_ID as REMITTA15_10_1_, | |
eobs0_.VERSION as VERSION11_10_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
lineitem2_.ID as ID1_13_3_, | |
lineitem2_.CHARGES as CHARGES2_13_3_, | |
lineitem2_.POINTER as POINTER3_13_3_, | |
lineitem2_.CLAIM_ID as CLAIM_I26_13_3_, | |
lineitem2_.COVERED_CHARGES as COVERED_4_13_3_, | |
lineitem2_.CPT_CODE as CPT_CODE5_13_3_, | |
lineitem2_.DESCRIPTION as DESCRIPT6_13_3_, | |
lineitem2_.EMG as EMG7_13_3_, | |
lineitem2_.FAMILY_PLAN as FAMILY_P8_13_3_, | |
lineitem2_.FROM_DATE as FROM_DAT9_13_3_, | |
lineitem2_.LINE_ITEM_NUMBER as LINE_IT10_13_3_, | |
lineitem2_.MODIFIER as MODIFIE11_13_3_, | |
lineitem2_.MODIFIER1 as MODIFIE12_13_3_, | |
lineitem2_.MODIFIER2 as MODIFIE13_13_3_, | |
lineitem2_.MODIFIER3 as MODIFIE14_13_3_, | |
lineitem2_.NON_COVERED_CHARGES as NON_COV15_13_3_, | |
lineitem2_.PLACE_OF_SERVICE as PLACE_O16_13_3_, | |
lineitem2_.QUALIFIER_ID as QUALIFI17_13_3_, | |
lineitem2_.RATE as RATE18_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_3_, | |
lineitem2_.REVENUE_CODE as REVENUE21_13_3_, | |
lineitem2_.SERVICE_DATE as SERVICE22_13_3_, | |
lineitem2_.TO_DATE as TO_DATE23_13_3_, | |
lineitem2_.TOTAL_CHARGES as TOTAL_C24_13_3_, | |
lineitem2_.UNITS as UNITS25_13_3_ | |
from | |
vbr.EOB eobs0_ | |
left outer join | |
vbr.Code code1_ | |
on eobs0_.DETAIL_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.LineItem lineitem2_ | |
on eobs0_.LINE_ITEM_ID=lineitem2_.ID | |
where | |
eobs0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CLAIM_ID as CLAIM_ID8_4_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
case2_.ID as ID1_3_3_, | |
case2_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_3_, | |
case2_.BEGIN_DATE as BEGIN_DA3_3_3_, | |
case2_.CASE_MANAGER_ID as CASE_MAN4_3_3_, | |
case2_.CASE_MANAGER_NAME as CASE_MAN5_3_3_, | |
case2_.CASE_NUMBER as CASE_NUM6_3_3_, | |
case2_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_3_, | |
case2_.CASE_RATE as CASE_RAT8_3_3_, | |
case2_.CASE_STATUS_CODE as CASE_ST17_3_3_, | |
case2_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_3_, | |
case2_.CLOSED_DATE as CLOSED_D9_3_3_, | |
case2_.DESCRIPTION as DESCRIP10_3_3_, | |
case2_.END_DATE as END_DAT11_3_3_, | |
case2_.GLOBAL_END_DATE as GLOBAL_12_3_3_, | |
case2_.GLOBAL_START_DATE as GLOBAL_13_3_3_, | |
case2_.HIC_NUMBER as HIC_NUM14_3_3_, | |
case2_.MEMBER_PERSON_ID as MEMBER_19_3_3_, | |
case2_.PAYER_CONTRACT_ID as PAYER_C20_3_3_, | |
case2_.TENANT_ID as TENANT_15_3_3_, | |
case2_.VERSION as VERSION16_3_3_, | |
code3_.ID as ID1_6_4_, | |
code3_.DISPLAY as DISPLAY2_6_4_, | |
code3_.CODE_GROUP as CODE_GRO3_6_4_, | |
code3_.CODE_KEY as CODE_KEY4_6_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
person5_.ID as ID1_17_6_, | |
person5_.ADDRESS_1 as ADDRESS_2_17_6_, | |
person5_.ADDRESS_2 as ADDRESS_3_17_6_, | |
person5_.CITY as CITY4_17_6_, | |
person5_.DATE_OF_BIRTH as DATE_OF_5_17_6_, | |
person5_.FIRST_NAME as FIRST_NA6_17_6_, | |
person5_.GENDER as GENDER7_17_6_, | |
person5_.LAST_NAME as LAST_NAM8_17_6_, | |
person5_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_6_, | |
person5_.MIDDLE_NAME as MIDDLE_10_17_6_, | |
person5_.PHONE_NUMBER as PHONE_N11_17_6_, | |
person5_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_6_, | |
person5_.STATE as STATE13_17_6_, | |
person5_.TENANT_ID as TENANT_14_17_6_, | |
person5_.VERSION as VERSION15_17_6_, | |
person5_.ZIP_CODE as ZIP_COD16_17_6_, | |
payercontr6_.ID as ID1_16_7_, | |
payercontr6_.BASE_CONTRACT_RATE as BASE_CON2_16_7_, | |
payercontr6_.BEGIN_DATE as BEGIN_DA3_16_7_, | |
payercontr6_.DESCRIPTION as DESCRIPT4_16_7_, | |
payercontr6_.DONOR_CLAIM_PHASE as DONOR_CL5_16_7_, | |
payercontr6_.END_DATE as END_DATE6_16_7_, | |
payercontr6_.GLOBAL_START_PHASE as GLOBAL_S7_16_7_, | |
payercontr6_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_7_, | |
payercontr6_.PAYER_ID as PAYER_I14_16_7_, | |
payercontr6_.STOPLOSS_AMOUNT as STOPLOSS9_16_7_, | |
payercontr6_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_7_, | |
payercontr6_.TENANT_ID as TENANT_11_16_7_, | |
payercontr6_.TIMELY_FILING_DAYS as TIMELY_12_16_7_, | |
payercontr6_.TYPE_CODE as TYPE_CO15_16_7_, | |
payercontr6_.VERSION as VERSION13_16_7_, | |
person7_.ID as ID1_17_8_, | |
person7_.ADDRESS_1 as ADDRESS_2_17_8_, | |
person7_.ADDRESS_2 as ADDRESS_3_17_8_, | |
person7_.CITY as CITY4_17_8_, | |
person7_.DATE_OF_BIRTH as DATE_OF_5_17_8_, | |
person7_.FIRST_NAME as FIRST_NA6_17_8_, | |
person7_.GENDER as GENDER7_17_8_, | |
person7_.LAST_NAME as LAST_NAM8_17_8_, | |
person7_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_8_, | |
person7_.MIDDLE_NAME as MIDDLE_10_17_8_, | |
person7_.PHONE_NUMBER as PHONE_N11_17_8_, | |
person7_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_8_, | |
person7_.STATE as STATE13_17_8_, | |
person7_.TENANT_ID as TENANT_14_17_8_, | |
person7_.VERSION as VERSION15_17_8_, | |
person7_.ZIP_CODE as ZIP_COD16_17_8_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Cases case2_ | |
on activities0_.CASE_ID=case2_.ID | |
left outer join | |
vbr.Code code3_ | |
on case2_.CASE_STATUS_CODE=code3_.ID | |
left outer join | |
vbr.Code code4_ | |
on case2_.CLOSED_CASE_REASON_CODE=code4_.ID | |
left outer join | |
vbr.Person person5_ | |
on case2_.MEMBER_PERSON_ID=person5_.ID | |
left outer join | |
vbr.PayerContract payercontr6_ | |
on case2_.PAYER_CONTRACT_ID=payercontr6_.ID | |
left outer join | |
vbr.Person person7_ | |
on activities0_.MEMBER_ID=person7_.ID | |
where | |
activities0_.CLAIM_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
providerpa0_.CLAIM_ID as CLAIM_ID6_4_0_, | |
providerpa0_.ID as ID1_22_0_, | |
providerpa0_.ID as ID1_22_1_, | |
providerpa0_.AMOUNT as AMOUNT2_22_1_, | |
providerpa0_.CHECK_DATE as CHECK_DA3_22_1_, | |
providerpa0_.CHECK_NUMBER as CHECK_NU4_22_1_, | |
providerpa0_.CLAIM_ID as CLAIM_ID6_22_1_, | |
providerpa0_.DENIAL_REASON as DENIAL_R5_22_1_ | |
from | |
vbr.ProviderPayment providerpa0_ | |
where | |
providerpa0_.CLAIM_ID=? | |
Hibernate: | |
select | |
lineitems0_.CLAIM_ID as CLAIM_I26_4_0_, | |
lineitems0_.ID as ID1_13_0_, | |
lineitems0_.ID as ID1_13_1_, | |
lineitems0_.CHARGES as CHARGES2_13_1_, | |
lineitems0_.POINTER as POINTER3_13_1_, | |
lineitems0_.CLAIM_ID as CLAIM_I26_13_1_, | |
lineitems0_.COVERED_CHARGES as COVERED_4_13_1_, | |
lineitems0_.CPT_CODE as CPT_CODE5_13_1_, | |
lineitems0_.DESCRIPTION as DESCRIPT6_13_1_, | |
lineitems0_.EMG as EMG7_13_1_, | |
lineitems0_.FAMILY_PLAN as FAMILY_P8_13_1_, | |
lineitems0_.FROM_DATE as FROM_DAT9_13_1_, | |
lineitems0_.LINE_ITEM_NUMBER as LINE_IT10_13_1_, | |
lineitems0_.MODIFIER as MODIFIE11_13_1_, | |
lineitems0_.MODIFIER1 as MODIFIE12_13_1_, | |
lineitems0_.MODIFIER2 as MODIFIE13_13_1_, | |
lineitems0_.MODIFIER3 as MODIFIE14_13_1_, | |
lineitems0_.NON_COVERED_CHARGES as NON_COV15_13_1_, | |
lineitems0_.PLACE_OF_SERVICE as PLACE_O16_13_1_, | |
lineitems0_.QUALIFIER_ID as QUALIFI17_13_1_, | |
lineitems0_.RATE as RATE18_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_1_, | |
lineitems0_.REVENUE_CODE as REVENUE21_13_1_, | |
lineitems0_.SERVICE_DATE as SERVICE22_13_1_, | |
lineitems0_.TO_DATE as TO_DATE23_13_1_, | |
lineitems0_.TOTAL_CHARGES as TOTAL_C24_13_1_, | |
lineitems0_.UNITS as UNITS25_13_1_ | |
from | |
vbr.LineItem lineitems0_ | |
where | |
lineitems0_.CLAIM_ID=? | |
Hibernate: | |
select | |
eobs0_.CLAIM_ID as CLAIM_I12_4_0_, | |
eobs0_.ID as ID1_10_0_, | |
eobs0_.ID as ID1_10_1_, | |
eobs0_.CLAIM_ID as CLAIM_I12_10_1_, | |
eobs0_.CLAIM_DRG_CODE as CLAIM_DR2_10_1_, | |
eobs0_.CLAIM_NUMBER as CLAIM_NU3_10_1_, | |
eobs0_.CLAIM_PAYER_CONTROL_NUMBER as CLAIM_PA4_10_1_, | |
eobs0_.CLAIM_PROCESSING_METHOD as CLAIM_PR5_10_1_, | |
eobs0_.DETAIL_TYPE_CODE as DETAIL_13_10_1_, | |
eobs0_.INTEREST as INTEREST6_10_1_, | |
eobs0_.LINE_ITEM_ID as LINE_IT14_10_1_, | |
eobs0_.LINE_ITEM_NUMBER as LINE_ITE7_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_CODE as LINE_ITE8_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_TYPE as LINE_ITE9_10_1_, | |
eobs0_.PAYMENT as PAYMENT10_10_1_, | |
eobs0_.REMITTANCE_ID as REMITTA15_10_1_, | |
eobs0_.VERSION as VERSION11_10_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
lineitem2_.ID as ID1_13_3_, | |
lineitem2_.CHARGES as CHARGES2_13_3_, | |
lineitem2_.POINTER as POINTER3_13_3_, | |
lineitem2_.CLAIM_ID as CLAIM_I26_13_3_, | |
lineitem2_.COVERED_CHARGES as COVERED_4_13_3_, | |
lineitem2_.CPT_CODE as CPT_CODE5_13_3_, | |
lineitem2_.DESCRIPTION as DESCRIPT6_13_3_, | |
lineitem2_.EMG as EMG7_13_3_, | |
lineitem2_.FAMILY_PLAN as FAMILY_P8_13_3_, | |
lineitem2_.FROM_DATE as FROM_DAT9_13_3_, | |
lineitem2_.LINE_ITEM_NUMBER as LINE_IT10_13_3_, | |
lineitem2_.MODIFIER as MODIFIE11_13_3_, | |
lineitem2_.MODIFIER1 as MODIFIE12_13_3_, | |
lineitem2_.MODIFIER2 as MODIFIE13_13_3_, | |
lineitem2_.MODIFIER3 as MODIFIE14_13_3_, | |
lineitem2_.NON_COVERED_CHARGES as NON_COV15_13_3_, | |
lineitem2_.PLACE_OF_SERVICE as PLACE_O16_13_3_, | |
lineitem2_.QUALIFIER_ID as QUALIFI17_13_3_, | |
lineitem2_.RATE as RATE18_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_3_, | |
lineitem2_.REVENUE_CODE as REVENUE21_13_3_, | |
lineitem2_.SERVICE_DATE as SERVICE22_13_3_, | |
lineitem2_.TO_DATE as TO_DATE23_13_3_, | |
lineitem2_.TOTAL_CHARGES as TOTAL_C24_13_3_, | |
lineitem2_.UNITS as UNITS25_13_3_ | |
from | |
vbr.EOB eobs0_ | |
left outer join | |
vbr.Code code1_ | |
on eobs0_.DETAIL_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.LineItem lineitem2_ | |
on eobs0_.LINE_ITEM_ID=lineitem2_.ID | |
where | |
eobs0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CLAIM_ID as CLAIM_ID8_4_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
case2_.ID as ID1_3_3_, | |
case2_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_3_, | |
case2_.BEGIN_DATE as BEGIN_DA3_3_3_, | |
case2_.CASE_MANAGER_ID as CASE_MAN4_3_3_, | |
case2_.CASE_MANAGER_NAME as CASE_MAN5_3_3_, | |
case2_.CASE_NUMBER as CASE_NUM6_3_3_, | |
case2_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_3_, | |
case2_.CASE_RATE as CASE_RAT8_3_3_, | |
case2_.CASE_STATUS_CODE as CASE_ST17_3_3_, | |
case2_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_3_, | |
case2_.CLOSED_DATE as CLOSED_D9_3_3_, | |
case2_.DESCRIPTION as DESCRIP10_3_3_, | |
case2_.END_DATE as END_DAT11_3_3_, | |
case2_.GLOBAL_END_DATE as GLOBAL_12_3_3_, | |
case2_.GLOBAL_START_DATE as GLOBAL_13_3_3_, | |
case2_.HIC_NUMBER as HIC_NUM14_3_3_, | |
case2_.MEMBER_PERSON_ID as MEMBER_19_3_3_, | |
case2_.PAYER_CONTRACT_ID as PAYER_C20_3_3_, | |
case2_.TENANT_ID as TENANT_15_3_3_, | |
case2_.VERSION as VERSION16_3_3_, | |
code3_.ID as ID1_6_4_, | |
code3_.DISPLAY as DISPLAY2_6_4_, | |
code3_.CODE_GROUP as CODE_GRO3_6_4_, | |
code3_.CODE_KEY as CODE_KEY4_6_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
person5_.ID as ID1_17_6_, | |
person5_.ADDRESS_1 as ADDRESS_2_17_6_, | |
person5_.ADDRESS_2 as ADDRESS_3_17_6_, | |
person5_.CITY as CITY4_17_6_, | |
person5_.DATE_OF_BIRTH as DATE_OF_5_17_6_, | |
person5_.FIRST_NAME as FIRST_NA6_17_6_, | |
person5_.GENDER as GENDER7_17_6_, | |
person5_.LAST_NAME as LAST_NAM8_17_6_, | |
person5_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_6_, | |
person5_.MIDDLE_NAME as MIDDLE_10_17_6_, | |
person5_.PHONE_NUMBER as PHONE_N11_17_6_, | |
person5_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_6_, | |
person5_.STATE as STATE13_17_6_, | |
person5_.TENANT_ID as TENANT_14_17_6_, | |
person5_.VERSION as VERSION15_17_6_, | |
person5_.ZIP_CODE as ZIP_COD16_17_6_, | |
payercontr6_.ID as ID1_16_7_, | |
payercontr6_.BASE_CONTRACT_RATE as BASE_CON2_16_7_, | |
payercontr6_.BEGIN_DATE as BEGIN_DA3_16_7_, | |
payercontr6_.DESCRIPTION as DESCRIPT4_16_7_, | |
payercontr6_.DONOR_CLAIM_PHASE as DONOR_CL5_16_7_, | |
payercontr6_.END_DATE as END_DATE6_16_7_, | |
payercontr6_.GLOBAL_START_PHASE as GLOBAL_S7_16_7_, | |
payercontr6_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_7_, | |
payercontr6_.PAYER_ID as PAYER_I14_16_7_, | |
payercontr6_.STOPLOSS_AMOUNT as STOPLOSS9_16_7_, | |
payercontr6_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_7_, | |
payercontr6_.TENANT_ID as TENANT_11_16_7_, | |
payercontr6_.TIMELY_FILING_DAYS as TIMELY_12_16_7_, | |
payercontr6_.TYPE_CODE as TYPE_CO15_16_7_, | |
payercontr6_.VERSION as VERSION13_16_7_, | |
person7_.ID as ID1_17_8_, | |
person7_.ADDRESS_1 as ADDRESS_2_17_8_, | |
person7_.ADDRESS_2 as ADDRESS_3_17_8_, | |
person7_.CITY as CITY4_17_8_, | |
person7_.DATE_OF_BIRTH as DATE_OF_5_17_8_, | |
person7_.FIRST_NAME as FIRST_NA6_17_8_, | |
person7_.GENDER as GENDER7_17_8_, | |
person7_.LAST_NAME as LAST_NAM8_17_8_, | |
person7_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_8_, | |
person7_.MIDDLE_NAME as MIDDLE_10_17_8_, | |
person7_.PHONE_NUMBER as PHONE_N11_17_8_, | |
person7_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_8_, | |
person7_.STATE as STATE13_17_8_, | |
person7_.TENANT_ID as TENANT_14_17_8_, | |
person7_.VERSION as VERSION15_17_8_, | |
person7_.ZIP_CODE as ZIP_COD16_17_8_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Cases case2_ | |
on activities0_.CASE_ID=case2_.ID | |
left outer join | |
vbr.Code code3_ | |
on case2_.CASE_STATUS_CODE=code3_.ID | |
left outer join | |
vbr.Code code4_ | |
on case2_.CLOSED_CASE_REASON_CODE=code4_.ID | |
left outer join | |
vbr.Person person5_ | |
on case2_.MEMBER_PERSON_ID=person5_.ID | |
left outer join | |
vbr.PayerContract payercontr6_ | |
on case2_.PAYER_CONTRACT_ID=payercontr6_.ID | |
left outer join | |
vbr.Person person7_ | |
on activities0_.MEMBER_ID=person7_.ID | |
where | |
activities0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
yo 1332 milliseconds | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
bundles0_.CLAIM_ID as CLAIM_ID2_4_0_, | |
bundles0_.BUNDLE_ID as BUNDLE_I1_25_0_, | |
bundle1_.ID as ID1_1_1_, | |
bundle1_.pdf_blob as pdf_blob2_1_1_ | |
from | |
vbr.bundleclaimrltn bundles0_ | |
inner join | |
vbr.Bundle bundle1_ | |
on bundles0_.BUNDLE_ID=bundle1_.ID | |
where | |
bundles0_.CLAIM_ID=? | |
Hibernate: | |
select | |
bundles0_.CLAIM_ID as CLAIM_ID2_4_0_, | |
bundles0_.BUNDLE_ID as BUNDLE_I1_25_0_, | |
bundle1_.ID as ID1_1_1_, | |
bundle1_.pdf_blob as pdf_blob2_1_1_ | |
from | |
vbr.bundleclaimrltn bundles0_ | |
inner join | |
vbr.Bundle bundle1_ | |
on bundles0_.BUNDLE_ID=bundle1_.ID | |
where | |
bundles0_.CLAIM_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
update | |
vbr.Person | |
set | |
ADDRESS_1=?, | |
ADDRESS_2=?, | |
CITY=?, | |
DATE_OF_BIRTH=?, | |
FIRST_NAME=?, | |
GENDER=?, | |
LAST_NAME=?, | |
MEDICAL_RECORD_NUMBER=?, | |
MIDDLE_NAME=?, | |
PHONE_NUMBER=?, | |
SOCIAL_SECURITY_NUMBER=?, | |
STATE=?, | |
VERSION=?, | |
ZIP_CODE=? | |
where | |
ID=? | |
and VERSION=? | |
Hibernate: | |
select | |
person0_.ID as ID1_17_0_, | |
person0_.ADDRESS_1 as ADDRESS_2_17_0_, | |
person0_.ADDRESS_2 as ADDRESS_3_17_0_, | |
person0_.CITY as CITY4_17_0_, | |
person0_.DATE_OF_BIRTH as DATE_OF_5_17_0_, | |
person0_.FIRST_NAME as FIRST_NA6_17_0_, | |
person0_.GENDER as GENDER7_17_0_, | |
person0_.LAST_NAME as LAST_NAM8_17_0_, | |
person0_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_0_, | |
person0_.MIDDLE_NAME as MIDDLE_10_17_0_, | |
person0_.PHONE_NUMBER as PHONE_N11_17_0_, | |
person0_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_0_, | |
person0_.STATE as STATE13_17_0_, | |
person0_.TENANT_ID as TENANT_14_17_0_, | |
person0_.VERSION as VERSION15_17_0_, | |
person0_.ZIP_CODE as ZIP_COD16_17_0_, | |
activities1_.MEMBER_ID as MEMBER_I9_17_1_, | |
activities1_.ID as ID1_0_1_, | |
activities1_.ID as ID1_0_2_, | |
activities1_.ACTIVITY_DATE as ACTIVITY2_0_2_, | |
activities1_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_2_, | |
activities1_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_2_, | |
activities1_.CASE_ID as CASE_ID7_0_2_, | |
activities1_.CLAIM_ID as CLAIM_ID8_0_2_, | |
activities1_.CREATED_BY_ID as CREATED_4_0_2_, | |
activities1_.CREATED_BY_NAME as CREATED_5_0_2_, | |
activities1_.MEMBER_ID as MEMBER_I9_0_2_, | |
code2_.ID as ID1_6_3_, | |
code2_.DISPLAY as DISPLAY2_6_3_, | |
code2_.CODE_GROUP as CODE_GRO3_6_3_, | |
code2_.CODE_KEY as CODE_KEY4_6_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
claim4_.ID as ID1_4_5_, | |
claim4_.CASE_ID as CASE_ID19_4_5_, | |
claim4_.ADMISSION_DATE as ADMISSIO2_4_5_, | |
claim4_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_5_, | |
claim4_.CLAIM_NUMBER as CLAIM_NU4_4_5_, | |
claim4_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_5_, | |
claim4_.CLAIM_STATUS_CODE as CLAIM_S21_4_5_, | |
claim4_.CLAIM_TYPE_CODE as CLAIM_T22_4_5_, | |
claim4_.DONOR_ID as DONOR_I23_4_5_, | |
claim4_.DRG_CODE as DRG_CODE5_4_5_, | |
claim4_.FACILITY_NPI as FACILITY6_4_5_, | |
claim4_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_5_, | |
claim4_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_5_, | |
claim4_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_5_, | |
claim4_.PROVIDER_FACILITY_NAME as PROVIDE10_4_5_, | |
claim4_.PROVIDER_TAX_ID as PROVIDE11_4_5_, | |
claim4_.RECEIVED_DATE as RECEIVE12_4_5_, | |
claim4_.SERVICE_FROM_DATE as SERVICE13_4_5_, | |
claim4_.SERVICE_TO_DATE as SERVICE14_4_5_, | |
claim4_.STATEMENT_FROM_DATE as STATEME15_4_5_, | |
claim4_.STATEMENT_TO_DATE as STATEME16_4_5_, | |
claim4_.TENANT_ID as TENANT_17_4_5_, | |
claim4_.TOTAL_CHARGES as TOTAL_C18_4_5_, | |
cases5_.MEMBER_PERSON_ID as MEMBER_19_17_6_, | |
cases5_.ID as ID1_3_6_, | |
cases5_.ID as ID1_3_7_, | |
cases5_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_7_, | |
cases5_.BEGIN_DATE as BEGIN_DA3_3_7_, | |
cases5_.CASE_MANAGER_ID as CASE_MAN4_3_7_, | |
cases5_.CASE_MANAGER_NAME as CASE_MAN5_3_7_, | |
cases5_.CASE_NUMBER as CASE_NUM6_3_7_, | |
cases5_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_7_, | |
cases5_.CASE_RATE as CASE_RAT8_3_7_, | |
cases5_.CASE_STATUS_CODE as CASE_ST17_3_7_, | |
cases5_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_7_, | |
cases5_.CLOSED_DATE as CLOSED_D9_3_7_, | |
cases5_.DESCRIPTION as DESCRIP10_3_7_, | |
cases5_.END_DATE as END_DAT11_3_7_, | |
cases5_.GLOBAL_END_DATE as GLOBAL_12_3_7_, | |
cases5_.GLOBAL_START_DATE as GLOBAL_13_3_7_, | |
cases5_.HIC_NUMBER as HIC_NUM14_3_7_, | |
cases5_.MEMBER_PERSON_ID as MEMBER_19_3_7_, | |
cases5_.PAYER_CONTRACT_ID as PAYER_C20_3_7_, | |
cases5_.TENANT_ID as TENANT_15_3_7_, | |
cases5_.VERSION as VERSION16_3_7_, | |
code6_.ID as ID1_6_8_, | |
code6_.DISPLAY as DISPLAY2_6_8_, | |
code6_.CODE_GROUP as CODE_GRO3_6_8_, | |
code6_.CODE_KEY as CODE_KEY4_6_8_, | |
claims7_.CASE_ID as CASE_ID19_3_9_, | |
claims7_.ID as ID1_4_9_, | |
claims7_.ID as ID1_4_10_, | |
claims7_.CASE_ID as CASE_ID19_4_10_, | |
claims7_.ADMISSION_DATE as ADMISSIO2_4_10_, | |
claims7_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_10_, | |
claims7_.CLAIM_NUMBER as CLAIM_NU4_4_10_, | |
claims7_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_10_, | |
claims7_.CLAIM_STATUS_CODE as CLAIM_S21_4_10_, | |
claims7_.CLAIM_TYPE_CODE as CLAIM_T22_4_10_, | |
claims7_.DONOR_ID as DONOR_I23_4_10_, | |
claims7_.DRG_CODE as DRG_CODE5_4_10_, | |
claims7_.FACILITY_NPI as FACILITY6_4_10_, | |
claims7_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_10_, | |
claims7_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_10_, | |
claims7_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_10_, | |
claims7_.PROVIDER_FACILITY_NAME as PROVIDE10_4_10_, | |
claims7_.PROVIDER_TAX_ID as PROVIDE11_4_10_, | |
claims7_.RECEIVED_DATE as RECEIVE12_4_10_, | |
claims7_.SERVICE_FROM_DATE as SERVICE13_4_10_, | |
claims7_.SERVICE_TO_DATE as SERVICE14_4_10_, | |
claims7_.STATEMENT_FROM_DATE as STATEME15_4_10_, | |
claims7_.STATEMENT_TO_DATE as STATEME16_4_10_, | |
claims7_.TENANT_ID as TENANT_17_4_10_, | |
claims7_.TOTAL_CHARGES as TOTAL_C18_4_10_, | |
code8_.ID as ID1_6_11_, | |
code8_.DISPLAY as DISPLAY2_6_11_, | |
code8_.CODE_GROUP as CODE_GRO3_6_11_, | |
code8_.CODE_KEY as CODE_KEY4_6_11_, | |
donors9_.CASE_ID as CASE_ID4_3_12_, | |
donors9_.ID as ID1_8_12_, | |
donors9_.ID as ID1_8_13_, | |
donors9_.authorization_number as authoriz2_8_13_, | |
donors9_.CASE_ID as CASE_ID4_8_13_, | |
donors9_.name as name3_8_13_, | |
donors9_.TYPE_CODE as TYPE_COD5_8_13_, | |
notes10_.CASE_ID as CASE_ID3_3_14_, | |
notes10_.ID as ID1_14_14_, | |
notes10_.ID as ID1_14_15_, | |
notes10_.CASE_ID as CASE_ID3_14_15_, | |
notes10_.NOTE as NOTE2_14_15_, | |
payercontr11_.ID as ID1_16_16_, | |
payercontr11_.BASE_CONTRACT_RATE as BASE_CON2_16_16_, | |
payercontr11_.BEGIN_DATE as BEGIN_DA3_16_16_, | |
payercontr11_.DESCRIPTION as DESCRIPT4_16_16_, | |
payercontr11_.DONOR_CLAIM_PHASE as DONOR_CL5_16_16_, | |
payercontr11_.END_DATE as END_DATE6_16_16_, | |
payercontr11_.GLOBAL_START_PHASE as GLOBAL_S7_16_16_, | |
payercontr11_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_16_, | |
payercontr11_.PAYER_ID as PAYER_I14_16_16_, | |
payercontr11_.STOPLOSS_AMOUNT as STOPLOSS9_16_16_, | |
payercontr11_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_16_, | |
payercontr11_.TENANT_ID as TENANT_11_16_16_, | |
payercontr11_.TIMELY_FILING_DAYS as TIMELY_12_16_16_, | |
payercontr11_.TYPE_CODE as TYPE_CO15_16_16_, | |
payercontr11_.VERSION as VERSION13_16_16_, | |
phasedates12_.CASE_ID as CASE_ID6_3_17_, | |
phasedates12_.ID as ID1_26_17_, | |
phasedates12_.ID as ID1_26_18_, | |
phasedates12_.BEGIN_DATE as BEGIN_DA2_26_18_, | |
phasedates12_.CASE_ID as CASE_ID6_26_18_, | |
phasedates12_.END_DATE as END_DATE3_26_18_, | |
phasedates12_.FIN_NUMBER as FIN_NUMB4_26_18_, | |
phasedates12_.PHASE_NAME as PHASE_NA5_26_18_, | |
healthplan13_.MEMBER_PERSON_ID as MEMBER_10_17_19_, | |
healthplan13_.ID as ID1_12_19_, | |
healthplan13_.ID as ID1_12_20_, | |
healthplan13_.GROUP_NUMBER as GROUP_NU2_12_20_, | |
healthplan13_.MEMBER_PERSON_ID as MEMBER_10_12_20_, | |
healthplan13_.MEMBER_NUMBER as MEMBER_N3_12_20_, | |
healthplan13_.PAYER_ID as PAYER_I11_12_20_, | |
healthplan13_.PLAN_NAME as PLAN_NAM4_12_20_, | |
healthplan13_.PLAN_SEQUENCE as PLAN_SEQ5_12_20_, | |
healthplan13_.POLICY_TYPE as POLICY_T6_12_20_, | |
healthplan13_.removeFromMember as removeFr7_12_20_, | |
healthplan13_.SUBSCRIBER_NAME as SUBSCRIB8_12_20_, | |
healthplan13_.TENANT_ID as TENANT_I9_12_20_ | |
from | |
vbr.Person person0_ | |
left outer join | |
vbr.Activities activities1_ | |
on person0_.ID=activities1_.MEMBER_ID | |
left outer join | |
vbr.Code code2_ | |
on activities1_.ACTIVITY_TYPE_CODE=code2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on activities1_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Claim claim4_ | |
on activities1_.CLAIM_ID=claim4_.ID | |
left outer join | |
vbr.Cases cases5_ | |
on person0_.ID=cases5_.MEMBER_PERSON_ID | |
left outer join | |
vbr.Code code6_ | |
on cases5_.CASE_STATUS_CODE=code6_.ID | |
left outer join | |
vbr.Claim claims7_ | |
on cases5_.ID=claims7_.CASE_ID | |
left outer join | |
vbr.Code code8_ | |
on cases5_.CLOSED_CASE_REASON_CODE=code8_.ID | |
left outer join | |
vbr.Donor donors9_ | |
on cases5_.ID=donors9_.CASE_ID | |
left outer join | |
vbr.NOTES notes10_ | |
on cases5_.ID=notes10_.CASE_ID | |
left outer join | |
vbr.PayerContract payercontr11_ | |
on cases5_.PAYER_CONTRACT_ID=payercontr11_.ID | |
left outer join | |
vbr.phasedates phasedates12_ | |
on cases5_.ID=phasedates12_.CASE_ID | |
left outer join | |
vbr.HealthPlan healthplan13_ | |
on person0_.ID=healthplan13_.MEMBER_PERSON_ID | |
where | |
person0_.ID=? | |
order by | |
phasedates12_.BEGIN_DATE | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
code0_.ID as ID1_6_0_, | |
code0_.DISPLAY as DISPLAY2_6_0_, | |
code0_.CODE_GROUP as CODE_GRO3_6_0_, | |
code0_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code code0_ | |
where | |
code0_.ID=? | |
Hibernate: | |
select | |
payer0_.ID as ID1_15_0_, | |
payer0_.ADDRESS as ADDRESS2_15_0_, | |
payer0_.NAME as NAME3_15_0_, | |
payer0_.NPI as NPI4_15_0_, | |
payer0_.TENANT_ID as TENANT_I5_15_0_, | |
healthplan1_.PAYER_ID as PAYER_I11_15_1_, | |
healthplan1_.ID as ID1_12_1_, | |
healthplan1_.ID as ID1_12_2_, | |
healthplan1_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan1_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan1_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan1_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan1_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan1_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan1_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan1_.removeFromMember as removeFr7_12_2_, | |
healthplan1_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan1_.TENANT_ID as TENANT_I9_12_2_ | |
from | |
vbr.Payer payer0_ | |
left outer join | |
vbr.HealthPlan healthplan1_ | |
on payer0_.ID=healthplan1_.PAYER_ID | |
where | |
payer0_.ID=? | |
Hibernate: | |
select | |
providerpa0_.CLAIM_ID as CLAIM_ID6_4_0_, | |
providerpa0_.ID as ID1_22_0_, | |
providerpa0_.ID as ID1_22_1_, | |
providerpa0_.AMOUNT as AMOUNT2_22_1_, | |
providerpa0_.CHECK_DATE as CHECK_DA3_22_1_, | |
providerpa0_.CHECK_NUMBER as CHECK_NU4_22_1_, | |
providerpa0_.CLAIM_ID as CLAIM_ID6_22_1_, | |
providerpa0_.DENIAL_REASON as DENIAL_R5_22_1_ | |
from | |
vbr.ProviderPayment providerpa0_ | |
where | |
providerpa0_.CLAIM_ID=? | |
Hibernate: | |
select | |
lineitems0_.CLAIM_ID as CLAIM_I26_4_0_, | |
lineitems0_.ID as ID1_13_0_, | |
lineitems0_.ID as ID1_13_1_, | |
lineitems0_.CHARGES as CHARGES2_13_1_, | |
lineitems0_.POINTER as POINTER3_13_1_, | |
lineitems0_.CLAIM_ID as CLAIM_I26_13_1_, | |
lineitems0_.COVERED_CHARGES as COVERED_4_13_1_, | |
lineitems0_.CPT_CODE as CPT_CODE5_13_1_, | |
lineitems0_.DESCRIPTION as DESCRIPT6_13_1_, | |
lineitems0_.EMG as EMG7_13_1_, | |
lineitems0_.FAMILY_PLAN as FAMILY_P8_13_1_, | |
lineitems0_.FROM_DATE as FROM_DAT9_13_1_, | |
lineitems0_.LINE_ITEM_NUMBER as LINE_IT10_13_1_, | |
lineitems0_.MODIFIER as MODIFIE11_13_1_, | |
lineitems0_.MODIFIER1 as MODIFIE12_13_1_, | |
lineitems0_.MODIFIER2 as MODIFIE13_13_1_, | |
lineitems0_.MODIFIER3 as MODIFIE14_13_1_, | |
lineitems0_.NON_COVERED_CHARGES as NON_COV15_13_1_, | |
lineitems0_.PLACE_OF_SERVICE as PLACE_O16_13_1_, | |
lineitems0_.QUALIFIER_ID as QUALIFI17_13_1_, | |
lineitems0_.RATE as RATE18_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_1_, | |
lineitems0_.REVENUE_CODE as REVENUE21_13_1_, | |
lineitems0_.SERVICE_DATE as SERVICE22_13_1_, | |
lineitems0_.TO_DATE as TO_DATE23_13_1_, | |
lineitems0_.TOTAL_CHARGES as TOTAL_C24_13_1_, | |
lineitems0_.UNITS as UNITS25_13_1_ | |
from | |
vbr.LineItem lineitems0_ | |
where | |
lineitems0_.CLAIM_ID=? | |
Hibernate: | |
select | |
eobs0_.CLAIM_ID as CLAIM_I12_4_0_, | |
eobs0_.ID as ID1_10_0_, | |
eobs0_.ID as ID1_10_1_, | |
eobs0_.CLAIM_ID as CLAIM_I12_10_1_, | |
eobs0_.CLAIM_DRG_CODE as CLAIM_DR2_10_1_, | |
eobs0_.CLAIM_NUMBER as CLAIM_NU3_10_1_, | |
eobs0_.CLAIM_PAYER_CONTROL_NUMBER as CLAIM_PA4_10_1_, | |
eobs0_.CLAIM_PROCESSING_METHOD as CLAIM_PR5_10_1_, | |
eobs0_.DETAIL_TYPE_CODE as DETAIL_13_10_1_, | |
eobs0_.INTEREST as INTEREST6_10_1_, | |
eobs0_.LINE_ITEM_ID as LINE_IT14_10_1_, | |
eobs0_.LINE_ITEM_NUMBER as LINE_ITE7_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_CODE as LINE_ITE8_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_TYPE as LINE_ITE9_10_1_, | |
eobs0_.PAYMENT as PAYMENT10_10_1_, | |
eobs0_.REMITTANCE_ID as REMITTA15_10_1_, | |
eobs0_.VERSION as VERSION11_10_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
lineitem2_.ID as ID1_13_3_, | |
lineitem2_.CHARGES as CHARGES2_13_3_, | |
lineitem2_.POINTER as POINTER3_13_3_, | |
lineitem2_.CLAIM_ID as CLAIM_I26_13_3_, | |
lineitem2_.COVERED_CHARGES as COVERED_4_13_3_, | |
lineitem2_.CPT_CODE as CPT_CODE5_13_3_, | |
lineitem2_.DESCRIPTION as DESCRIPT6_13_3_, | |
lineitem2_.EMG as EMG7_13_3_, | |
lineitem2_.FAMILY_PLAN as FAMILY_P8_13_3_, | |
lineitem2_.FROM_DATE as FROM_DAT9_13_3_, | |
lineitem2_.LINE_ITEM_NUMBER as LINE_IT10_13_3_, | |
lineitem2_.MODIFIER as MODIFIE11_13_3_, | |
lineitem2_.MODIFIER1 as MODIFIE12_13_3_, | |
lineitem2_.MODIFIER2 as MODIFIE13_13_3_, | |
lineitem2_.MODIFIER3 as MODIFIE14_13_3_, | |
lineitem2_.NON_COVERED_CHARGES as NON_COV15_13_3_, | |
lineitem2_.PLACE_OF_SERVICE as PLACE_O16_13_3_, | |
lineitem2_.QUALIFIER_ID as QUALIFI17_13_3_, | |
lineitem2_.RATE as RATE18_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_3_, | |
lineitem2_.REVENUE_CODE as REVENUE21_13_3_, | |
lineitem2_.SERVICE_DATE as SERVICE22_13_3_, | |
lineitem2_.TO_DATE as TO_DATE23_13_3_, | |
lineitem2_.TOTAL_CHARGES as TOTAL_C24_13_3_, | |
lineitem2_.UNITS as UNITS25_13_3_ | |
from | |
vbr.EOB eobs0_ | |
left outer join | |
vbr.Code code1_ | |
on eobs0_.DETAIL_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.LineItem lineitem2_ | |
on eobs0_.LINE_ITEM_ID=lineitem2_.ID | |
where | |
eobs0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CLAIM_ID as CLAIM_ID8_4_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
case2_.ID as ID1_3_3_, | |
case2_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_3_, | |
case2_.BEGIN_DATE as BEGIN_DA3_3_3_, | |
case2_.CASE_MANAGER_ID as CASE_MAN4_3_3_, | |
case2_.CASE_MANAGER_NAME as CASE_MAN5_3_3_, | |
case2_.CASE_NUMBER as CASE_NUM6_3_3_, | |
case2_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_3_, | |
case2_.CASE_RATE as CASE_RAT8_3_3_, | |
case2_.CASE_STATUS_CODE as CASE_ST17_3_3_, | |
case2_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_3_, | |
case2_.CLOSED_DATE as CLOSED_D9_3_3_, | |
case2_.DESCRIPTION as DESCRIP10_3_3_, | |
case2_.END_DATE as END_DAT11_3_3_, | |
case2_.GLOBAL_END_DATE as GLOBAL_12_3_3_, | |
case2_.GLOBAL_START_DATE as GLOBAL_13_3_3_, | |
case2_.HIC_NUMBER as HIC_NUM14_3_3_, | |
case2_.MEMBER_PERSON_ID as MEMBER_19_3_3_, | |
case2_.PAYER_CONTRACT_ID as PAYER_C20_3_3_, | |
case2_.TENANT_ID as TENANT_15_3_3_, | |
case2_.VERSION as VERSION16_3_3_, | |
code3_.ID as ID1_6_4_, | |
code3_.DISPLAY as DISPLAY2_6_4_, | |
code3_.CODE_GROUP as CODE_GRO3_6_4_, | |
code3_.CODE_KEY as CODE_KEY4_6_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
person5_.ID as ID1_17_6_, | |
person5_.ADDRESS_1 as ADDRESS_2_17_6_, | |
person5_.ADDRESS_2 as ADDRESS_3_17_6_, | |
person5_.CITY as CITY4_17_6_, | |
person5_.DATE_OF_BIRTH as DATE_OF_5_17_6_, | |
person5_.FIRST_NAME as FIRST_NA6_17_6_, | |
person5_.GENDER as GENDER7_17_6_, | |
person5_.LAST_NAME as LAST_NAM8_17_6_, | |
person5_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_6_, | |
person5_.MIDDLE_NAME as MIDDLE_10_17_6_, | |
person5_.PHONE_NUMBER as PHONE_N11_17_6_, | |
person5_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_6_, | |
person5_.STATE as STATE13_17_6_, | |
person5_.TENANT_ID as TENANT_14_17_6_, | |
person5_.VERSION as VERSION15_17_6_, | |
person5_.ZIP_CODE as ZIP_COD16_17_6_, | |
payercontr6_.ID as ID1_16_7_, | |
payercontr6_.BASE_CONTRACT_RATE as BASE_CON2_16_7_, | |
payercontr6_.BEGIN_DATE as BEGIN_DA3_16_7_, | |
payercontr6_.DESCRIPTION as DESCRIPT4_16_7_, | |
payercontr6_.DONOR_CLAIM_PHASE as DONOR_CL5_16_7_, | |
payercontr6_.END_DATE as END_DATE6_16_7_, | |
payercontr6_.GLOBAL_START_PHASE as GLOBAL_S7_16_7_, | |
payercontr6_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_7_, | |
payercontr6_.PAYER_ID as PAYER_I14_16_7_, | |
payercontr6_.STOPLOSS_AMOUNT as STOPLOSS9_16_7_, | |
payercontr6_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_7_, | |
payercontr6_.TENANT_ID as TENANT_11_16_7_, | |
payercontr6_.TIMELY_FILING_DAYS as TIMELY_12_16_7_, | |
payercontr6_.TYPE_CODE as TYPE_CO15_16_7_, | |
payercontr6_.VERSION as VERSION13_16_7_, | |
person7_.ID as ID1_17_8_, | |
person7_.ADDRESS_1 as ADDRESS_2_17_8_, | |
person7_.ADDRESS_2 as ADDRESS_3_17_8_, | |
person7_.CITY as CITY4_17_8_, | |
person7_.DATE_OF_BIRTH as DATE_OF_5_17_8_, | |
person7_.FIRST_NAME as FIRST_NA6_17_8_, | |
person7_.GENDER as GENDER7_17_8_, | |
person7_.LAST_NAME as LAST_NAM8_17_8_, | |
person7_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_8_, | |
person7_.MIDDLE_NAME as MIDDLE_10_17_8_, | |
person7_.PHONE_NUMBER as PHONE_N11_17_8_, | |
person7_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_8_, | |
person7_.STATE as STATE13_17_8_, | |
person7_.TENANT_ID as TENANT_14_17_8_, | |
person7_.VERSION as VERSION15_17_8_, | |
person7_.ZIP_CODE as ZIP_COD16_17_8_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Cases case2_ | |
on activities0_.CASE_ID=case2_.ID | |
left outer join | |
vbr.Code code3_ | |
on case2_.CASE_STATUS_CODE=code3_.ID | |
left outer join | |
vbr.Code code4_ | |
on case2_.CLOSED_CASE_REASON_CODE=code4_.ID | |
left outer join | |
vbr.Person person5_ | |
on case2_.MEMBER_PERSON_ID=person5_.ID | |
left outer join | |
vbr.PayerContract payercontr6_ | |
on case2_.PAYER_CONTRACT_ID=payercontr6_.ID | |
left outer join | |
vbr.Person person7_ | |
on activities0_.MEMBER_ID=person7_.ID | |
where | |
activities0_.CLAIM_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
providerpa0_.CLAIM_ID as CLAIM_ID6_4_0_, | |
providerpa0_.ID as ID1_22_0_, | |
providerpa0_.ID as ID1_22_1_, | |
providerpa0_.AMOUNT as AMOUNT2_22_1_, | |
providerpa0_.CHECK_DATE as CHECK_DA3_22_1_, | |
providerpa0_.CHECK_NUMBER as CHECK_NU4_22_1_, | |
providerpa0_.CLAIM_ID as CLAIM_ID6_22_1_, | |
providerpa0_.DENIAL_REASON as DENIAL_R5_22_1_ | |
from | |
vbr.ProviderPayment providerpa0_ | |
where | |
providerpa0_.CLAIM_ID=? | |
Hibernate: | |
select | |
lineitems0_.CLAIM_ID as CLAIM_I26_4_0_, | |
lineitems0_.ID as ID1_13_0_, | |
lineitems0_.ID as ID1_13_1_, | |
lineitems0_.CHARGES as CHARGES2_13_1_, | |
lineitems0_.POINTER as POINTER3_13_1_, | |
lineitems0_.CLAIM_ID as CLAIM_I26_13_1_, | |
lineitems0_.COVERED_CHARGES as COVERED_4_13_1_, | |
lineitems0_.CPT_CODE as CPT_CODE5_13_1_, | |
lineitems0_.DESCRIPTION as DESCRIPT6_13_1_, | |
lineitems0_.EMG as EMG7_13_1_, | |
lineitems0_.FAMILY_PLAN as FAMILY_P8_13_1_, | |
lineitems0_.FROM_DATE as FROM_DAT9_13_1_, | |
lineitems0_.LINE_ITEM_NUMBER as LINE_IT10_13_1_, | |
lineitems0_.MODIFIER as MODIFIE11_13_1_, | |
lineitems0_.MODIFIER1 as MODIFIE12_13_1_, | |
lineitems0_.MODIFIER2 as MODIFIE13_13_1_, | |
lineitems0_.MODIFIER3 as MODIFIE14_13_1_, | |
lineitems0_.NON_COVERED_CHARGES as NON_COV15_13_1_, | |
lineitems0_.PLACE_OF_SERVICE as PLACE_O16_13_1_, | |
lineitems0_.QUALIFIER_ID as QUALIFI17_13_1_, | |
lineitems0_.RATE as RATE18_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_1_, | |
lineitems0_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_1_, | |
lineitems0_.REVENUE_CODE as REVENUE21_13_1_, | |
lineitems0_.SERVICE_DATE as SERVICE22_13_1_, | |
lineitems0_.TO_DATE as TO_DATE23_13_1_, | |
lineitems0_.TOTAL_CHARGES as TOTAL_C24_13_1_, | |
lineitems0_.UNITS as UNITS25_13_1_ | |
from | |
vbr.LineItem lineitems0_ | |
where | |
lineitems0_.CLAIM_ID=? | |
Hibernate: | |
select | |
eobs0_.CLAIM_ID as CLAIM_I12_4_0_, | |
eobs0_.ID as ID1_10_0_, | |
eobs0_.ID as ID1_10_1_, | |
eobs0_.CLAIM_ID as CLAIM_I12_10_1_, | |
eobs0_.CLAIM_DRG_CODE as CLAIM_DR2_10_1_, | |
eobs0_.CLAIM_NUMBER as CLAIM_NU3_10_1_, | |
eobs0_.CLAIM_PAYER_CONTROL_NUMBER as CLAIM_PA4_10_1_, | |
eobs0_.CLAIM_PROCESSING_METHOD as CLAIM_PR5_10_1_, | |
eobs0_.DETAIL_TYPE_CODE as DETAIL_13_10_1_, | |
eobs0_.INTEREST as INTEREST6_10_1_, | |
eobs0_.LINE_ITEM_ID as LINE_IT14_10_1_, | |
eobs0_.LINE_ITEM_NUMBER as LINE_ITE7_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_CODE as LINE_ITE8_10_1_, | |
eobs0_.LINE_ITEM_PROCEDURE_TYPE as LINE_ITE9_10_1_, | |
eobs0_.PAYMENT as PAYMENT10_10_1_, | |
eobs0_.REMITTANCE_ID as REMITTA15_10_1_, | |
eobs0_.VERSION as VERSION11_10_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
lineitem2_.ID as ID1_13_3_, | |
lineitem2_.CHARGES as CHARGES2_13_3_, | |
lineitem2_.POINTER as POINTER3_13_3_, | |
lineitem2_.CLAIM_ID as CLAIM_I26_13_3_, | |
lineitem2_.COVERED_CHARGES as COVERED_4_13_3_, | |
lineitem2_.CPT_CODE as CPT_CODE5_13_3_, | |
lineitem2_.DESCRIPTION as DESCRIPT6_13_3_, | |
lineitem2_.EMG as EMG7_13_3_, | |
lineitem2_.FAMILY_PLAN as FAMILY_P8_13_3_, | |
lineitem2_.FROM_DATE as FROM_DAT9_13_3_, | |
lineitem2_.LINE_ITEM_NUMBER as LINE_IT10_13_3_, | |
lineitem2_.MODIFIER as MODIFIE11_13_3_, | |
lineitem2_.MODIFIER1 as MODIFIE12_13_3_, | |
lineitem2_.MODIFIER2 as MODIFIE13_13_3_, | |
lineitem2_.MODIFIER3 as MODIFIE14_13_3_, | |
lineitem2_.NON_COVERED_CHARGES as NON_COV15_13_3_, | |
lineitem2_.PLACE_OF_SERVICE as PLACE_O16_13_3_, | |
lineitem2_.QUALIFIER_ID as QUALIFI17_13_3_, | |
lineitem2_.RATE as RATE18_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_0 as RENDERI19_13_3_, | |
lineitem2_.RENDERING_PROVIDER_ID_1 as RENDERI20_13_3_, | |
lineitem2_.REVENUE_CODE as REVENUE21_13_3_, | |
lineitem2_.SERVICE_DATE as SERVICE22_13_3_, | |
lineitem2_.TO_DATE as TO_DATE23_13_3_, | |
lineitem2_.TOTAL_CHARGES as TOTAL_C24_13_3_, | |
lineitem2_.UNITS as UNITS25_13_3_ | |
from | |
vbr.EOB eobs0_ | |
left outer join | |
vbr.Code code1_ | |
on eobs0_.DETAIL_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.LineItem lineitem2_ | |
on eobs0_.LINE_ITEM_ID=lineitem2_.ID | |
where | |
eobs0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CLAIM_ID as CLAIM_ID8_4_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
case2_.ID as ID1_3_3_, | |
case2_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_3_, | |
case2_.BEGIN_DATE as BEGIN_DA3_3_3_, | |
case2_.CASE_MANAGER_ID as CASE_MAN4_3_3_, | |
case2_.CASE_MANAGER_NAME as CASE_MAN5_3_3_, | |
case2_.CASE_NUMBER as CASE_NUM6_3_3_, | |
case2_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_3_, | |
case2_.CASE_RATE as CASE_RAT8_3_3_, | |
case2_.CASE_STATUS_CODE as CASE_ST17_3_3_, | |
case2_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_3_, | |
case2_.CLOSED_DATE as CLOSED_D9_3_3_, | |
case2_.DESCRIPTION as DESCRIP10_3_3_, | |
case2_.END_DATE as END_DAT11_3_3_, | |
case2_.GLOBAL_END_DATE as GLOBAL_12_3_3_, | |
case2_.GLOBAL_START_DATE as GLOBAL_13_3_3_, | |
case2_.HIC_NUMBER as HIC_NUM14_3_3_, | |
case2_.MEMBER_PERSON_ID as MEMBER_19_3_3_, | |
case2_.PAYER_CONTRACT_ID as PAYER_C20_3_3_, | |
case2_.TENANT_ID as TENANT_15_3_3_, | |
case2_.VERSION as VERSION16_3_3_, | |
code3_.ID as ID1_6_4_, | |
code3_.DISPLAY as DISPLAY2_6_4_, | |
code3_.CODE_GROUP as CODE_GRO3_6_4_, | |
code3_.CODE_KEY as CODE_KEY4_6_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
person5_.ID as ID1_17_6_, | |
person5_.ADDRESS_1 as ADDRESS_2_17_6_, | |
person5_.ADDRESS_2 as ADDRESS_3_17_6_, | |
person5_.CITY as CITY4_17_6_, | |
person5_.DATE_OF_BIRTH as DATE_OF_5_17_6_, | |
person5_.FIRST_NAME as FIRST_NA6_17_6_, | |
person5_.GENDER as GENDER7_17_6_, | |
person5_.LAST_NAME as LAST_NAM8_17_6_, | |
person5_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_6_, | |
person5_.MIDDLE_NAME as MIDDLE_10_17_6_, | |
person5_.PHONE_NUMBER as PHONE_N11_17_6_, | |
person5_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_6_, | |
person5_.STATE as STATE13_17_6_, | |
person5_.TENANT_ID as TENANT_14_17_6_, | |
person5_.VERSION as VERSION15_17_6_, | |
person5_.ZIP_CODE as ZIP_COD16_17_6_, | |
payercontr6_.ID as ID1_16_7_, | |
payercontr6_.BASE_CONTRACT_RATE as BASE_CON2_16_7_, | |
payercontr6_.BEGIN_DATE as BEGIN_DA3_16_7_, | |
payercontr6_.DESCRIPTION as DESCRIPT4_16_7_, | |
payercontr6_.DONOR_CLAIM_PHASE as DONOR_CL5_16_7_, | |
payercontr6_.END_DATE as END_DATE6_16_7_, | |
payercontr6_.GLOBAL_START_PHASE as GLOBAL_S7_16_7_, | |
payercontr6_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_7_, | |
payercontr6_.PAYER_ID as PAYER_I14_16_7_, | |
payercontr6_.STOPLOSS_AMOUNT as STOPLOSS9_16_7_, | |
payercontr6_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_7_, | |
payercontr6_.TENANT_ID as TENANT_11_16_7_, | |
payercontr6_.TIMELY_FILING_DAYS as TIMELY_12_16_7_, | |
payercontr6_.TYPE_CODE as TYPE_CO15_16_7_, | |
payercontr6_.VERSION as VERSION13_16_7_, | |
person7_.ID as ID1_17_8_, | |
person7_.ADDRESS_1 as ADDRESS_2_17_8_, | |
person7_.ADDRESS_2 as ADDRESS_3_17_8_, | |
person7_.CITY as CITY4_17_8_, | |
person7_.DATE_OF_BIRTH as DATE_OF_5_17_8_, | |
person7_.FIRST_NAME as FIRST_NA6_17_8_, | |
person7_.GENDER as GENDER7_17_8_, | |
person7_.LAST_NAME as LAST_NAM8_17_8_, | |
person7_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_8_, | |
person7_.MIDDLE_NAME as MIDDLE_10_17_8_, | |
person7_.PHONE_NUMBER as PHONE_N11_17_8_, | |
person7_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_8_, | |
person7_.STATE as STATE13_17_8_, | |
person7_.TENANT_ID as TENANT_14_17_8_, | |
person7_.VERSION as VERSION15_17_8_, | |
person7_.ZIP_CODE as ZIP_COD16_17_8_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Cases case2_ | |
on activities0_.CASE_ID=case2_.ID | |
left outer join | |
vbr.Code code3_ | |
on case2_.CASE_STATUS_CODE=code3_.ID | |
left outer join | |
vbr.Code code4_ | |
on case2_.CLOSED_CASE_REASON_CODE=code4_.ID | |
left outer join | |
vbr.Person person5_ | |
on case2_.MEMBER_PERSON_ID=person5_.ID | |
left outer join | |
vbr.PayerContract payercontr6_ | |
on case2_.PAYER_CONTRACT_ID=payercontr6_.ID | |
left outer join | |
vbr.Person person7_ | |
on activities0_.MEMBER_ID=person7_.ID | |
where | |
activities0_.CLAIM_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_16_0_, | |
phaserates0_.ID as ID1_18_0_, | |
phaserates0_.ID as ID1_18_1_, | |
phaserates0_.INSTITUTIONAL_RATE as INSTITUT2_18_1_, | |
phaserates0_.PAYER_CONTRACT_ID as PAYER_CO6_18_1_, | |
phaserates0_.PHASE as PHASE3_18_1_, | |
phaserates0_.PHASE_NAME as PHASE_NA4_18_1_, | |
phaserates0_.PROFESSIONAL_RATE as PROFESSI5_18_1_, | |
phaserates0_.RATE_TYPE_CODE as RATE_TYP7_18_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_ | |
from | |
vbr.PhaseRates phaserates0_ | |
left outer join | |
vbr.Code code1_ | |
on phaserates0_.RATE_TYPE_CODE=code1_.ID | |
where | |
phaserates0_.PAYER_CONTRACT_ID=? | |
order by | |
phaserates0_.PHASE | |
Hibernate: | |
select | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_16_0_, | |
drgrates0_.ID as ID1_9_0_, | |
drgrates0_.ID as ID1_9_1_, | |
drgrates0_.DRG as DRG2_9_1_, | |
drgrates0_.HOSPITAL_RATE as HOSPITAL3_9_1_, | |
drgrates0_.PART_B_RATE as PART_B_R4_9_1_, | |
drgrates0_.PAYER_CONTRACT_ID as PAYER_CO5_9_1_ | |
from | |
vbr.DrgRates drgrates0_ | |
where | |
drgrates0_.PAYER_CONTRACT_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
Hibernate: | |
select | |
activities0_.CASE_ID as CASE_ID7_3_0_, | |
activities0_.ID as ID1_0_0_, | |
activities0_.ID as ID1_0_1_, | |
activities0_.ACTIVITY_DATE as ACTIVITY2_0_1_, | |
activities0_.ACTIVITY_DESCRIPTION as ACTIVITY3_0_1_, | |
activities0_.ACTIVITY_TYPE_CODE as ACTIVITY6_0_1_, | |
activities0_.CASE_ID as CASE_ID7_0_1_, | |
activities0_.CLAIM_ID as CLAIM_ID8_0_1_, | |
activities0_.CREATED_BY_ID as CREATED_4_0_1_, | |
activities0_.CREATED_BY_NAME as CREATED_5_0_1_, | |
activities0_.MEMBER_ID as MEMBER_I9_0_1_, | |
code1_.ID as ID1_6_2_, | |
code1_.DISPLAY as DISPLAY2_6_2_, | |
code1_.CODE_GROUP as CODE_GRO3_6_2_, | |
code1_.CODE_KEY as CODE_KEY4_6_2_, | |
claim2_.ID as ID1_4_3_, | |
claim2_.CASE_ID as CASE_ID19_4_3_, | |
claim2_.ADMISSION_DATE as ADMISSIO2_4_3_, | |
claim2_.CLAIM_CLOB_STORAGE as CLAIM_CL3_4_3_, | |
claim2_.CLAIM_NUMBER as CLAIM_NU4_4_3_, | |
claim2_.CLAIM_SUB_TYPE_CODE as CLAIM_S20_4_3_, | |
claim2_.CLAIM_STATUS_CODE as CLAIM_S21_4_3_, | |
claim2_.CLAIM_TYPE_CODE as CLAIM_T22_4_3_, | |
claim2_.DONOR_ID as DONOR_I23_4_3_, | |
claim2_.DRG_CODE as DRG_CODE5_4_3_, | |
claim2_.FACILITY_NPI as FACILITY6_4_3_, | |
claim2_.HEALTH_PLAN_GROUP_ID as HEALTH_P7_4_3_, | |
claim2_.HEALTH_PLAN_MEMBER_ID as HEALTH_P8_4_3_, | |
claim2_.PROVIDER_FACILITY_ADDRESS as PROVIDER9_4_3_, | |
claim2_.PROVIDER_FACILITY_NAME as PROVIDE10_4_3_, | |
claim2_.PROVIDER_TAX_ID as PROVIDE11_4_3_, | |
claim2_.RECEIVED_DATE as RECEIVE12_4_3_, | |
claim2_.SERVICE_FROM_DATE as SERVICE13_4_3_, | |
claim2_.SERVICE_TO_DATE as SERVICE14_4_3_, | |
claim2_.STATEMENT_FROM_DATE as STATEME15_4_3_, | |
claim2_.STATEMENT_TO_DATE as STATEME16_4_3_, | |
claim2_.TENANT_ID as TENANT_17_4_3_, | |
claim2_.TOTAL_CHARGES as TOTAL_C18_4_3_, | |
case3_.ID as ID1_3_4_, | |
case3_.AUTHORIZATION_NUMBER as AUTHORIZ2_3_4_, | |
case3_.BEGIN_DATE as BEGIN_DA3_3_4_, | |
case3_.CASE_MANAGER_ID as CASE_MAN4_3_4_, | |
case3_.CASE_MANAGER_NAME as CASE_MAN5_3_4_, | |
case3_.CASE_NUMBER as CASE_NUM6_3_4_, | |
case3_.CASE_NUMBER_FORMATTED as CASE_NUM7_3_4_, | |
case3_.CASE_RATE as CASE_RAT8_3_4_, | |
case3_.CASE_STATUS_CODE as CASE_ST17_3_4_, | |
case3_.CLOSED_CASE_REASON_CODE as CLOSED_18_3_4_, | |
case3_.CLOSED_DATE as CLOSED_D9_3_4_, | |
case3_.DESCRIPTION as DESCRIP10_3_4_, | |
case3_.END_DATE as END_DAT11_3_4_, | |
case3_.GLOBAL_END_DATE as GLOBAL_12_3_4_, | |
case3_.GLOBAL_START_DATE as GLOBAL_13_3_4_, | |
case3_.HIC_NUMBER as HIC_NUM14_3_4_, | |
case3_.MEMBER_PERSON_ID as MEMBER_19_3_4_, | |
case3_.PAYER_CONTRACT_ID as PAYER_C20_3_4_, | |
case3_.TENANT_ID as TENANT_15_3_4_, | |
case3_.VERSION as VERSION16_3_4_, | |
code4_.ID as ID1_6_5_, | |
code4_.DISPLAY as DISPLAY2_6_5_, | |
code4_.CODE_GROUP as CODE_GRO3_6_5_, | |
code4_.CODE_KEY as CODE_KEY4_6_5_, | |
code5_.ID as ID1_6_6_, | |
code5_.DISPLAY as DISPLAY2_6_6_, | |
code5_.CODE_GROUP as CODE_GRO3_6_6_, | |
code5_.CODE_KEY as CODE_KEY4_6_6_, | |
code6_.ID as ID1_6_7_, | |
code6_.DISPLAY as DISPLAY2_6_7_, | |
code6_.CODE_GROUP as CODE_GRO3_6_7_, | |
code6_.CODE_KEY as CODE_KEY4_6_7_, | |
donor7_.ID as ID1_8_8_, | |
donor7_.authorization_number as authoriz2_8_8_, | |
donor7_.CASE_ID as CASE_ID4_8_8_, | |
donor7_.name as name3_8_8_, | |
donor7_.TYPE_CODE as TYPE_COD5_8_8_, | |
person8_.ID as ID1_17_9_, | |
person8_.ADDRESS_1 as ADDRESS_2_17_9_, | |
person8_.ADDRESS_2 as ADDRESS_3_17_9_, | |
person8_.CITY as CITY4_17_9_, | |
person8_.DATE_OF_BIRTH as DATE_OF_5_17_9_, | |
person8_.FIRST_NAME as FIRST_NA6_17_9_, | |
person8_.GENDER as GENDER7_17_9_, | |
person8_.LAST_NAME as LAST_NAM8_17_9_, | |
person8_.MEDICAL_RECORD_NUMBER as MEDICAL_9_17_9_, | |
person8_.MIDDLE_NAME as MIDDLE_10_17_9_, | |
person8_.PHONE_NUMBER as PHONE_N11_17_9_, | |
person8_.SOCIAL_SECURITY_NUMBER as SOCIAL_12_17_9_, | |
person8_.STATE as STATE13_17_9_, | |
person8_.TENANT_ID as TENANT_14_17_9_, | |
person8_.VERSION as VERSION15_17_9_, | |
person8_.ZIP_CODE as ZIP_COD16_17_9_ | |
from | |
vbr.Activities activities0_ | |
left outer join | |
vbr.Code code1_ | |
on activities0_.ACTIVITY_TYPE_CODE=code1_.ID | |
left outer join | |
vbr.Claim claim2_ | |
on activities0_.CLAIM_ID=claim2_.ID | |
left outer join | |
vbr.Cases case3_ | |
on claim2_.CASE_ID=case3_.ID | |
left outer join | |
vbr.Code code4_ | |
on claim2_.CLAIM_SUB_TYPE_CODE=code4_.ID | |
left outer join | |
vbr.Code code5_ | |
on claim2_.CLAIM_STATUS_CODE=code5_.ID | |
left outer join | |
vbr.Code code6_ | |
on claim2_.CLAIM_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Donor donor7_ | |
on claim2_.DONOR_ID=donor7_.ID | |
left outer join | |
vbr.Person person8_ | |
on activities0_.MEMBER_ID=person8_.ID | |
where | |
activities0_.CASE_ID=? | |
yo 511 milliseconds | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
bundles0_.CLAIM_ID as CLAIM_ID2_4_0_, | |
bundles0_.BUNDLE_ID as BUNDLE_I1_25_0_, | |
bundle1_.ID as ID1_1_1_, | |
bundle1_.pdf_blob as pdf_blob2_1_1_ | |
from | |
vbr.bundleclaimrltn bundles0_ | |
inner join | |
vbr.Bundle bundle1_ | |
on bundles0_.BUNDLE_ID=bundle1_.ID | |
where | |
bundles0_.CLAIM_ID=? | |
Hibernate: | |
select | |
bundles0_.CLAIM_ID as CLAIM_ID2_4_0_, | |
bundles0_.BUNDLE_ID as BUNDLE_I1_25_0_, | |
bundle1_.ID as ID1_1_1_, | |
bundle1_.pdf_blob as pdf_blob2_1_1_ | |
from | |
vbr.bundleclaimrltn bundles0_ | |
inner join | |
vbr.Bundle bundle1_ | |
on bundles0_.BUNDLE_ID=bundle1_.ID | |
where | |
bundles0_.CLAIM_ID=? | |
Hibernate: | |
select | |
drgcodes0_.CASE_ID as CASE_ID1_3_0_, | |
drgcodes0_.DRG_CODE as DRG_CODE2_2_0_ | |
from | |
vbr.CASE_DRGS drgcodes0_ | |
where | |
drgcodes0_.CASE_ID=? | |
Hibernate: | |
select | |
this_.ID as ID1_6_0_, | |
this_.DISPLAY as DISPLAY2_6_0_, | |
this_.CODE_GROUP as CODE_GRO3_6_0_, | |
this_.CODE_KEY as CODE_KEY4_6_0_ | |
from | |
vbr.Code this_ | |
Hibernate: | |
select | |
this_.ID as ID1_16_6_, | |
this_.BASE_CONTRACT_RATE as BASE_CON2_16_6_, | |
this_.BEGIN_DATE as BEGIN_DA3_16_6_, | |
this_.DESCRIPTION as DESCRIPT4_16_6_, | |
this_.DONOR_CLAIM_PHASE as DONOR_CL5_16_6_, | |
this_.END_DATE as END_DATE6_16_6_, | |
this_.GLOBAL_START_PHASE as GLOBAL_S7_16_6_, | |
this_.MINIMUM_CLOSE_DAYS as MINIMUM_8_16_6_, | |
this_.PAYER_ID as PAYER_I14_16_6_, | |
this_.STOPLOSS_AMOUNT as STOPLOSS9_16_6_, | |
this_.STOPLOSS_REIMBURSEMENT_PERCENTAGE as STOPLOS10_16_6_, | |
this_.TENANT_ID as TENANT_11_16_6_, | |
this_.TIMELY_FILING_DAYS as TIMELY_12_16_6_, | |
this_.TYPE_CODE as TYPE_CO15_16_6_, | |
this_.VERSION as VERSION13_16_6_, | |
drgrates2_.PAYER_CONTRACT_ID as PAYER_CO5_16_8_, | |
drgrates2_.ID as ID1_9_8_, | |
drgrates2_.ID as ID1_9_0_, | |
drgrates2_.DRG as DRG2_9_0_, | |
drgrates2_.HOSPITAL_RATE as HOSPITAL3_9_0_, | |
drgrates2_.PART_B_RATE as PART_B_R4_9_0_, | |
drgrates2_.PAYER_CONTRACT_ID as PAYER_CO5_9_0_, | |
payer3_.ID as ID1_15_1_, | |
payer3_.ADDRESS as ADDRESS2_15_1_, | |
payer3_.NAME as NAME3_15_1_, | |
payer3_.NPI as NPI4_15_1_, | |
payer3_.TENANT_ID as TENANT_I5_15_1_, | |
healthplan4_.PAYER_ID as PAYER_I11_15_9_, | |
healthplan4_.ID as ID1_12_9_, | |
healthplan4_.ID as ID1_12_2_, | |
healthplan4_.GROUP_NUMBER as GROUP_NU2_12_2_, | |
healthplan4_.MEMBER_PERSON_ID as MEMBER_10_12_2_, | |
healthplan4_.MEMBER_NUMBER as MEMBER_N3_12_2_, | |
healthplan4_.PAYER_ID as PAYER_I11_12_2_, | |
healthplan4_.PLAN_NAME as PLAN_NAM4_12_2_, | |
healthplan4_.PLAN_SEQUENCE as PLAN_SEQ5_12_2_, | |
healthplan4_.POLICY_TYPE as POLICY_T6_12_2_, | |
healthplan4_.removeFromMember as removeFr7_12_2_, | |
healthplan4_.SUBSCRIBER_NAME as SUBSCRIB8_12_2_, | |
healthplan4_.TENANT_ID as TENANT_I9_12_2_, | |
phaserates5_.PAYER_CONTRACT_ID as PAYER_CO6_16_10_, | |
phaserates5_.ID as ID1_18_10_, | |
phaserates5_.ID as ID1_18_3_, | |
phaserates5_.INSTITUTIONAL_RATE as INSTITUT2_18_3_, | |
phaserates5_.PAYER_CONTRACT_ID as PAYER_CO6_18_3_, | |
phaserates5_.PHASE as PHASE3_18_3_, | |
phaserates5_.PHASE_NAME as PHASE_NA4_18_3_, | |
phaserates5_.PROFESSIONAL_RATE as PROFESSI5_18_3_, | |
phaserates5_.RATE_TYPE_CODE as RATE_TYP7_18_3_, | |
code6_.ID as ID1_6_4_, | |
code6_.DISPLAY as DISPLAY2_6_4_, | |
code6_.CODE_GROUP as CODE_GRO3_6_4_, | |
code6_.CODE_KEY as CODE_KEY4_6_4_, | |
code7_.ID as ID1_6_5_, | |
code7_.DISPLAY as DISPLAY2_6_5_, | |
code7_.CODE_GROUP as CODE_GRO3_6_5_, | |
code7_.CODE_KEY as CODE_KEY4_6_5_ | |
from | |
vbr.PayerContract this_ | |
left outer join | |
vbr.DrgRates drgrates2_ | |
on this_.ID=drgrates2_.PAYER_CONTRACT_ID | |
left outer join | |
vbr.Payer payer3_ | |
on this_.PAYER_ID=payer3_.ID | |
left outer join | |
vbr.HealthPlan healthplan4_ | |
on payer3_.ID=healthplan4_.PAYER_ID | |
left outer join | |
vbr.PhaseRates phaserates5_ | |
on this_.ID=phaserates5_.PAYER_CONTRACT_ID | |
left outer join | |
vbr.Code code6_ | |
on phaserates5_.RATE_TYPE_CODE=code6_.ID | |
left outer join | |
vbr.Code code7_ | |
on this_.TYPE_CODE=code7_.ID | |
where | |
this_.tenant_id=? | |
order by | |
phaserates5_.PHASE |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment