aurora_standard.chmpread

Field Type Null Default Key Extra Comment
visit_no int(11) YES
fin_class varchar(5) YES
date_precert date YES
date_con_start date YES
date_con_end date YES
date_pa_input date YES
date_pa_start date YES
date_pa_end date YES
pa_ub92 varchar(20) YES
pa_1500 varchar(20) YES
bill_status varchar(3) YES
input_by int(11) YES
pa_status varchar(1) YES
ext_request varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
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
fin_class
TableColumn
aurora_standard.chmarsicur_fin_class
aurora_standard.chmcampicur_fin_class
aurora_standard.chmerafcnew_fin_class
aurora_standard.chmexmpicur_fin_class
aurora_standard.hl7gt1guar_fin_class