HSPI_Inferno.patient_addresses_map

Field Type Null Default Key Extra Comment
patient_id char(36) NO PRI (DC2Type:uuid)
address_id int(11) NO PRI

References

Local Column References
address_id
TableColumn
HSPI_CURES2015_B1.billing_controlsub04_pay_to_address_id
HSPI_CURES2015_B1.billing_controlscms_1500_pay_to_address_id
HSPI_CURES2015_B1.claimsub04_pay_to_address_id
HSPI_CURES2015_B1.claimscms_1500_pay_to_address_id
HSPI_CURES2015_B1.patient_status_codesservice_facililiy_location_address_id
HSPI_Central_Hospital.billing_controlsub04_pay_to_address_id
HSPI_Central_Hospital.billing_controlscms_1500_pay_to_address_id
HSPI_Central_Hospital.claimsub04_pay_to_address_id
HSPI_Central_Hospital.claimscms_1500_pay_to_address_id
HSPI_Central_Hospital.patient_status_codesservice_facililiy_location_address_id
HSPI_Dewitt.billing_controlsub04_pay_to_address_id
HSPI_Dewitt.billing_controlscms_1500_pay_to_address_id
HSPI_Dewitt.claimsub04_pay_to_address_id
HSPI_Dewitt.claimscms_1500_pay_to_address_id
HSPI_Dewitt.patient_status_codesservice_facililiy_location_address_id
HSPI_Fulton.billing_controlsub04_pay_to_address_id
HSPI_Fulton.billing_controlscms_1500_pay_to_address_id
HSPI_Fulton.claimsub04_pay_to_address_id
HSPI_Fulton.claimscms_1500_pay_to_address_id
HSPI_Fulton.patient_status_codesservice_facililiy_location_address_id
HSPI_Inferno.billing_controlsub04_pay_to_address_id
HSPI_Inferno.billing_controlscms_1500_pay_to_address_id
HSPI_Inferno.claimsub04_pay_to_address_id
HSPI_Inferno.claimscms_1500_pay_to_address_id
HSPI_Inferno.patient_status_codesservice_facililiy_location_address_id
HSPI_MU2015_E1.billing_controlsub04_pay_to_address_id
HSPI_MU2015_E1.billing_controlscms_1500_pay_to_address_id
HSPI_MU2015_E1.claimsub04_pay_to_address_id
HSPI_MU2015_E1.claimscms_1500_pay_to_address_id
HSPI_MU2015_E1.patient_status_codesservice_facililiy_location_address_id
HSPI_MU2015_G2.billing_controlsub04_pay_to_address_id
HSPI_MU2015_G2.billing_controlscms_1500_pay_to_address_id
HSPI_MU2015_G2.claimsub04_pay_to_address_id
HSPI_MU2015_G2.claimscms_1500_pay_to_address_id
HSPI_MU2015_G2.patient_status_codesservice_facililiy_location_address_id
HSPI_MU2015_G9.billing_controlsub04_pay_to_address_id
HSPI_MU2015_G9.billing_controlscms_1500_pay_to_address_id
HSPI_MU2015_G9.claimsub04_pay_to_address_id
HSPI_MU2015_G9.claimscms_1500_pay_to_address_id
HSPI_MU2015_G9.patient_status_codesservice_facililiy_location_address_id
HSPI_Sandbox.billing_controlsub04_pay_to_address_id
HSPI_Sandbox.billing_controlscms_1500_pay_to_address_id
HSPI_Sandbox.claimsub04_pay_to_address_id
HSPI_Sandbox.claimscms_1500_pay_to_address_id
HSPI_Sandbox.patient_status_codesservice_facililiy_location_address_id
HSPI_Summit_General.billing_controlsub04_pay_to_address_id
HSPI_Summit_General.billing_controlscms_1500_pay_to_address_id
HSPI_Summit_General.claimsub04_pay_to_address_id
HSPI_Summit_General.claimscms_1500_pay_to_address_id
HSPI_Summit_General.patient_status_codesservice_facililiy_location_address_id
HSPI_United_Physicians.billing_controlsub04_pay_to_address_id
HSPI_United_Physicians.billing_controlscms_1500_pay_to_address_id
HSPI_United_Physicians.claimsub04_pay_to_address_id
HSPI_United_Physicians.claimscms_1500_pay_to_address_id
HSPI_United_Physicians.patient_status_codesservice_facililiy_location_address_id
MPI.billing_controlsub04_pay_to_address_id
MPI.billing_controlscms_1500_pay_to_address_id
MPI.claimsub04_pay_to_address_id
MPI.claimscms_1500_pay_to_address_id
MPI.patient_status_codesservice_facililiy_location_address_id
patient_id
TableColumn
HSPI_CURES2015_B1.document_referencesauthor_patient_id
HSPI_Central_Hospital.document_referencesauthor_patient_id
HSPI_Dewitt.document_referencesauthor_patient_id
HSPI_Fulton.document_referencesauthor_patient_id
HSPI_Inferno.document_referencesauthor_patient_id
HSPI_MU2015_E1.document_referencesauthor_patient_id
HSPI_MU2015_G2.document_referencesauthor_patient_id
HSPI_MU2015_G9.document_referencesauthor_patient_id
HSPI_Sandbox.document_referencesauthor_patient_id
HSPI_Summit_General.document_referencesauthor_patient_id
HSPI_United_Physicians.document_referencesauthor_patient_id
MPI.document_referencesauthor_patient_id