aurora_standard.chmmichr

Field Type Null Default Key Extra Comment
visit_no int(11) YES
resource_code varchar(1) YES
medicare_status varchar(1) YES
other_ins varchar(1) YES
emergent varchar(1) YES
injury_code varchar(1) YES
discharge_status varchar(1) YES
co_ins decimal(6,2) YES
deductible decimal(6,2) YES
remarks_1 varchar(40) YES
remarks_2 varchar(40) YES
remarks_3 varchar(40) YES
remarks_4 varchar(40) YES
remarks_5 varchar(40) YES
remarks_6 varchar(40) YES
remarks_7 varchar(40) YES
remarks_8 varchar(40) YES
recipient_id varchar(9) YES
date_printed date YES
date_created date YES
attn_phy smallint(6) YES
psp_phy smallint(6) YES
msa_id varchar(1) YES
psp_phys_id varchar(11) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
deductible
TableColumn
_1.patients_responsibility_estimatesprest_deductible
_1.patients_responsibility_estimates_servicesprests_deductible
_1188.patients_responsibility_estimatesprest_deductible
_1188.patients_responsibility_estimates_servicesprests_deductible
_1218.patients_responsibility_estimatesprest_deductible
_1218.patients_responsibility_estimates_servicesprests_deductible
_1548.patients_responsibility_estimatesprest_deductible
_1548.patients_responsibility_estimates_servicesprests_deductible
_435.patients_responsibility_estimatesprest_deductible
_435.patients_responsibility_estimates_servicesprests_deductible
_436.patients_responsibility_estimatesprest_deductible
_436.patients_responsibility_estimates_servicesprests_deductible
_436_archive_testing.patients_responsibility_estimatesprest_deductible
_436_archive_testing.patients_responsibility_estimates_servicesprests_deductible
_437.patients_responsibility_estimatesprest_deductible
_437.patients_responsibility_estimates_servicesprests_deductible
_8.patients_responsibility_estimatesprest_deductible
_8.patients_responsibility_estimates_servicesprests_deductible
_81.patients_responsibility_estimatesprest_deductible
_81.patients_responsibility_estimates_servicesprests_deductible
_999.patients_responsibility_estimatesprest_deductible
_999.patients_responsibility_estimates_servicesprests_deductible
aurora_standard.chminsrddef_deductible
aurora_standard.chpinsucdep_deductible
aurora_standard.hl7in2daily_deductible
co_ins
TableColumn
_1.patients_responsibility_estimatesprest_co_ins
_1.patients_responsibility_estimates_servicesprests_co_ins
_1188.patients_responsibility_estimatesprest_co_ins
_1188.patients_responsibility_estimates_servicesprests_co_ins
_1218.patients_responsibility_estimatesprest_co_ins
_1218.patients_responsibility_estimates_servicesprests_co_ins
_1548.patients_responsibility_estimatesprest_co_ins
_1548.patients_responsibility_estimates_servicesprests_co_ins
_435.patients_responsibility_estimatesprest_co_ins
_435.patients_responsibility_estimates_servicesprests_co_ins
_436.patients_responsibility_estimatesprest_co_ins
_436.patients_responsibility_estimates_servicesprests_co_ins
_436_archive_testing.patients_responsibility_estimatesprest_co_ins
_436_archive_testing.patients_responsibility_estimates_servicesprests_co_ins
_437.patients_responsibility_estimatesprest_co_ins
_437.patients_responsibility_estimates_servicesprests_co_ins
_8.patients_responsibility_estimatesprest_co_ins
_8.patients_responsibility_estimates_servicesprests_co_ins
_81.patients_responsibility_estimatesprest_co_ins
_81.patients_responsibility_estimates_servicesprests_co_ins
_999.patients_responsibility_estimatesprest_co_ins
_999.patients_responsibility_estimates_servicesprests_co_ins
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
date_created
TableColumn
common.service_tickets_commentsstcp_date_created