aurora_standard.chmphysd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
seq_no smallint(6) YES
phy_no smallint(6) YES MUL
phy_type varchar(3) YES
from_dt date YES
thru_dt date YES
phy_service varchar(2) YES
phy_chart_sig varchar(1) YES
input_by int(11) YES
loc_code varchar(10) YES
phy_dfy varchar(1) YES
color_code varchar(10) 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
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no
from_dt
TableColumn
aurora_standard.chmabstratt_from_dt
thru_dt
TableColumn
aurora_standard.chmabstratt_thru_dt
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
phy_type
TableColumn
aurora_standard.chmutah3res_phy_type