common.countries

Field	Type	Null	Key	Comment
ctry_id	int(11)	NO	PRI	Country ID
ctry_name	varchar(50)	YES		Country Name
ctry_iso3166_code	varchar(3)	YES	UNI	Country ISO 3166 Code
ctry_x12_country_id	varchar(2)	YES		X12 Country ID
ctry_hl7_country_id	varchar(2)	YES		HL7 Country ID

References

Local Column

References

ctry_id

Table	Column
_1.encounters	enc_ctry_id
_1.encounters	enc_employer_ctry_id
_1.encounters	enc_guarantor_ctry_id
_1.encounters	enc_ins1_employer_ctry_id
_1.encounters	enc_ins2_employer_ctry_id
_1.encounters	enc_ins3_employer_ctry_id
_1.insurances_repository	irep_ins_employer_ctry_id
_1.patients	pat_ctry_id
_1.patients	pat_employer_ctry_id
_1.patients	pat_guarantor_ctry_id
_1.patients	pat_ins1_employer_ctry_id
_1.patients	pat_ins2_employer_ctry_id
_1.patients	pat_ins3_employer_ctry_id
_1.patients	pat_emergency_ctry_id
_1188.encounters	enc_ctry_id
_1188.encounters	enc_employer_ctry_id
_1188.encounters	enc_guarantor_ctry_id
_1188.encounters	enc_ins1_employer_ctry_id
_1188.encounters	enc_ins2_employer_ctry_id
_1188.encounters	enc_ins3_employer_ctry_id
_1188.insurances_repository	irep_ins_employer_ctry_id
_1188.patients	pat_ctry_id
_1188.patients	pat_employer_ctry_id
_1188.patients	pat_guarantor_ctry_id
_1188.patients	pat_ins1_employer_ctry_id
_1188.patients	pat_ins2_employer_ctry_id
_1188.patients	pat_ins3_employer_ctry_id
_1188.patients	pat_emergency_ctry_id
_1218.encounters	enc_ctry_id
_1218.encounters	enc_employer_ctry_id
_1218.encounters	enc_guarantor_ctry_id
_1218.encounters	enc_ins1_employer_ctry_id
_1218.encounters	enc_ins2_employer_ctry_id
_1218.encounters	enc_ins3_employer_ctry_id
_1218.insurances_repository	irep_ins_employer_ctry_id
_1218.patients	pat_ctry_id
_1218.patients	pat_employer_ctry_id
_1218.patients	pat_guarantor_ctry_id
_1218.patients	pat_ins1_employer_ctry_id
_1218.patients	pat_ins2_employer_ctry_id
_1218.patients	pat_ins3_employer_ctry_id
_1218.patients	pat_emergency_ctry_id
_1548.encounters	enc_ctry_id
_1548.encounters	enc_employer_ctry_id
_1548.encounters	enc_guarantor_ctry_id
_1548.encounters	enc_ins1_employer_ctry_id
_1548.encounters	enc_ins2_employer_ctry_id
_1548.encounters	enc_ins3_employer_ctry_id
_1548.insurances_repository	irep_ins_employer_ctry_id
_1548.patients	pat_ctry_id
_1548.patients	pat_employer_ctry_id
_1548.patients	pat_guarantor_ctry_id
_1548.patients	pat_ins1_employer_ctry_id
_1548.patients	pat_ins2_employer_ctry_id
_1548.patients	pat_ins3_employer_ctry_id
_1548.patients	pat_emergency_ctry_id
_435.encounters	enc_ctry_id
_435.encounters	enc_employer_ctry_id
_435.encounters	enc_guarantor_ctry_id
_435.encounters	enc_ins1_employer_ctry_id
_435.encounters	enc_ins2_employer_ctry_id
_435.encounters	enc_ins3_employer_ctry_id
_435.insurances_repository	irep_ins_employer_ctry_id
_435.patients	pat_ctry_id
_435.patients	pat_employer_ctry_id
_435.patients	pat_guarantor_ctry_id
_435.patients	pat_ins1_employer_ctry_id
_435.patients	pat_ins2_employer_ctry_id
_435.patients	pat_ins3_employer_ctry_id
_435.patients	pat_emergency_ctry_id
_436.encounters	enc_ctry_id
_436.encounters	enc_employer_ctry_id
_436.encounters	enc_guarantor_ctry_id
_436.encounters	enc_ins1_employer_ctry_id
_436.encounters	enc_ins2_employer_ctry_id
_436.encounters	enc_ins3_employer_ctry_id
_436.insurances_repository	irep_ins_employer_ctry_id
_436.patients	pat_ctry_id
_436.patients	pat_employer_ctry_id
_436.patients	pat_guarantor_ctry_id
_436.patients	pat_ins1_employer_ctry_id
_436.patients	pat_ins2_employer_ctry_id
_436.patients	pat_ins3_employer_ctry_id
_436.patients	pat_emergency_ctry_id
_436_archive_testing.encounters	enc_ctry_id
_436_archive_testing.encounters	enc_employer_ctry_id
_436_archive_testing.encounters	enc_guarantor_ctry_id
_436_archive_testing.encounters	enc_ins1_employer_ctry_id
_436_archive_testing.encounters	enc_ins2_employer_ctry_id
_436_archive_testing.encounters	enc_ins3_employer_ctry_id
_436_archive_testing.insurances_repository	irep_ins_employer_ctry_id
_436_archive_testing.patients	pat_ctry_id
_436_archive_testing.patients	pat_employer_ctry_id
_436_archive_testing.patients	pat_guarantor_ctry_id
_436_archive_testing.patients	pat_ins1_employer_ctry_id
_436_archive_testing.patients	pat_ins2_employer_ctry_id
_436_archive_testing.patients	pat_ins3_employer_ctry_id
_436_archive_testing.patients	pat_emergency_ctry_id
_437.encounters	enc_ctry_id
_437.encounters	enc_employer_ctry_id
_437.encounters	enc_guarantor_ctry_id
_437.encounters	enc_ins1_employer_ctry_id
_437.encounters	enc_ins2_employer_ctry_id
_437.encounters	enc_ins3_employer_ctry_id
_437.insurances_repository	irep_ins_employer_ctry_id
_437.patients	pat_ctry_id
_437.patients	pat_employer_ctry_id
_437.patients	pat_guarantor_ctry_id
_437.patients	pat_ins1_employer_ctry_id
_437.patients	pat_ins2_employer_ctry_id
_437.patients	pat_ins3_employer_ctry_id
_437.patients	pat_emergency_ctry_id
_8.encounters	enc_ctry_id
_8.encounters	enc_employer_ctry_id
_8.encounters	enc_guarantor_ctry_id
_8.encounters	enc_ins1_employer_ctry_id
_8.encounters	enc_ins2_employer_ctry_id
_8.encounters	enc_ins3_employer_ctry_id
_8.insurances_repository	irep_ins_employer_ctry_id
_8.patients	pat_ctry_id
_8.patients	pat_employer_ctry_id
_8.patients	pat_guarantor_ctry_id
_8.patients	pat_ins1_employer_ctry_id
_8.patients	pat_ins2_employer_ctry_id
_8.patients	pat_ins3_employer_ctry_id
_8.patients	pat_emergency_ctry_id
_81.encounters	enc_ctry_id
_81.encounters	enc_employer_ctry_id
_81.encounters	enc_guarantor_ctry_id
_81.encounters	enc_ins1_employer_ctry_id
_81.encounters	enc_ins2_employer_ctry_id
_81.encounters	enc_ins3_employer_ctry_id
_81.insurances_repository	irep_ins_employer_ctry_id
_81.patients	pat_ctry_id
_81.patients	pat_employer_ctry_id
_81.patients	pat_guarantor_ctry_id
_81.patients	pat_ins1_employer_ctry_id
_81.patients	pat_ins2_employer_ctry_id
_81.patients	pat_ins3_employer_ctry_id
_81.patients	pat_emergency_ctry_id
_999.encounters	enc_ctry_id
_999.encounters	enc_employer_ctry_id
_999.encounters	enc_guarantor_ctry_id
_999.encounters	enc_ins1_employer_ctry_id
_999.encounters	enc_ins2_employer_ctry_id
_999.encounters	enc_ins3_employer_ctry_id
_999.insurances_repository	irep_ins_employer_ctry_id
_999.patients	pat_ctry_id
_999.patients	pat_employer_ctry_id
_999.patients	pat_guarantor_ctry_id
_999.patients	pat_ins1_employer_ctry_id
_999.patients	pat_ins2_employer_ctry_id
_999.patients	pat_ins3_employer_ctry_id
_999.patients	pat_emergency_ctry_id
common.states	sta_ctry_id