aurora_standard.chmesins

Field Type Null Default Key Extra Comment
patient_id char(20) YES
cardholder_f_name char(15) YES
cardholder_l_name char(20) YES
cardholder_id char(20) YES
group_no char(20) YES
ins_plan_code char(10) YES
date_entered date YES
policy_no char(15) YES
primary_secondary char(1) YES
effective_date date YES
expired_date date YES

References

Local Column References
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
effective_date
TableColumn
Icd.icd10_snomed_mapi10snom_effective_date
_1.patients_smoking_statuspss_effective_date
_1188.patients_smoking_statuspss_effective_date
_1218.patients_smoking_statuspss_effective_date
_1548.patients_smoking_statuspss_effective_date
_435.patients_smoking_statuspss_effective_date
_436.patients_smoking_statuspss_effective_date
_436_archive_testing.patients_smoking_statuspss_effective_date
_437.patients_smoking_statuspss_effective_date
_8.patients_smoking_statuspss_effective_date
_81.patients_smoking_statuspss_effective_date
_999.patients_smoking_statuspss_effective_date
primary_secondary
TableColumn
_1.insurances_repositoryirep_primary_secondary
_1188.insurances_repositoryirep_primary_secondary
_1218.insurances_repositoryirep_primary_secondary
_1548.insurances_repositoryirep_primary_secondary
_435.insurances_repositoryirep_primary_secondary
_436.insurances_repositoryirep_primary_secondary
_436_archive_testing.insurances_repositoryirep_primary_secondary
_437.insurances_repositoryirep_primary_secondary
_8.insurances_repositoryirep_primary_secondary
_81.insurances_repositoryirep_primary_secondary
_999.insurances_repositoryirep_primary_secondary
group_no
TableColumn
aurora_standard.chmarsiins1_group_no
aurora_standard.chmarsiins2_group_no
aurora_standard.chmarsiins3_group_no
aurora_standard.chmcampiins1_group_no
aurora_standard.chmcampiins2_group_no
aurora_standard.chmcampiins3_group_no
aurora_standard.chmexmpiins1_group_no
aurora_standard.chmexmpiins2_group_no
aurora_standard.chmexmpiins3_group_no
aurora_standard.chmexvisins1_group_no
aurora_standard.chmexvisins2_group_no
aurora_standard.chmexvisins3_group_no
aurora_standard.chmpdemoins1_group_no
aurora_standard.chmpdemoins2_group_no
aurora_standard.chmpdemoins3_group_no
aurora_standard.chmradexins1_group_no
aurora_standard.chmradexins2_group_no
aurora_standard.chmradexins3_group_no
aurora_standard.chpcobrdcobra_group_no
policy_no
TableColumn
aurora_standard.chqliabdliab_policy_no