aurora_standard.chxlarcd

Field Type Null Default Key Extra Comment
acct_no varchar(20) YES
req_seq smallint(6) YES
seq_no smallint(6) YES
film_archive varchar(20) YES
line_no smallint(6) YES
scan_no smallint(6) YES
images smallint(6) YES
plane varchar(20) YES
comments varchar(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
comments
TableColumn
Loinc.loinc_codeslc_comments
_1.patient_amendmentspa_comments
_1.patients_allergiespalg_comments
_1.patients_medicationspms_erx_comments
_1.patients_reminderspr_comments
_1188.patient_amendmentspa_comments
_1188.patients_allergiespalg_comments
_1188.patients_medicationspms_erx_comments
_1188.patients_reminderspr_comments
_1218.patient_amendmentspa_comments
_1218.patients_allergiespalg_comments
_1218.patients_medicationspms_erx_comments
_1218.patients_reminderspr_comments
_1548.patient_amendmentspa_comments
_1548.patients_allergiespalg_comments
_1548.patients_medicationspms_erx_comments
_1548.patients_reminderspr_comments
_435.patient_amendmentspa_comments
_435.patients_allergiespalg_comments
_435.patients_medicationspms_erx_comments
_435.patients_reminderspr_comments
_436.patient_amendmentspa_comments
_436.patients_allergiespalg_comments
_436.patients_medicationspms_erx_comments
_436.patients_reminderspr_comments
_436_archive_testing.patient_amendmentspa_comments
_436_archive_testing.patients_allergiespalg_comments
_436_archive_testing.patients_medicationspms_erx_comments
_436_archive_testing.patients_reminderspr_comments
_437.patient_amendmentspa_comments
_437.patients_allergiespalg_comments
_437.patients_medicationspms_erx_comments
_437.patients_reminderspr_comments
_8.patient_amendmentspa_comments
_8.patients_allergiespalg_comments
_8.patients_medicationspms_erx_comments
_8.patients_reminderspr_comments
_81.patient_amendmentspa_comments
_81.patients_allergiespalg_comments
_81.patients_medicationspms_erx_comments
_81.patients_reminderspr_comments
_999.patient_amendmentspa_comments
_999.patients_allergiespalg_comments
_999.patients_medicationspms_erx_comments
_999.patients_reminderspr_comments
aurora_standard.cgsiflddf_comments
aurora_standard.chlrescdres_comments
aurora_standard.chpinsrdclass_comments
common.applicantsapp_comments
common.data_import_clients_meta_datadicmd_comments
common.data_import_field_typesdift_comments
common.data_import_fieldsdif_comments
common.leadslea_comments
common.loinc_codeslc_comments
images
TableColumn
ahiWiki.site_statsss_images
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
acct_no
TableColumn
aurora_standard.chmcashdnon_pat_acct_no
aurora_standard.chmnbcgdnon_pat_acct_no
aurora_standard.chmnbpydnon_pat_acct_no
aurora_standard.chmnchgdnon_pat_acct_no
aurora_standard.chmnpatrnon_pat_acct_no
aurora_standard.chmnpaydnon_pat_acct_no
aurora_standard.chmrefndcontr_acct_no
aurora_standard.chpcashrcash_acct_no
aurora_standard.chpcobpdcash_acct_no
aurora_standard.chpcobpdbal_acct_no
aurora_standard.chrcntrcrx_inv_acct_no
aurora_standard.chrcntrcrx_exp_acct_no
aurora_standard.curs_tempcash_acct_no
aurora_standard.np_statmnon_pat_acct_no
aurora_standard.sticntrcinv_acct_no
aurora_standard.sticntrcsales_acct_no
aurora_standard.sticntrccog_acct_no
aurora_standard.sticntrcadj_acct_no
aurora_standard.sticntrccount_acct_no
aurora_standard.sticntrchold_acct_no
aurora_standard.stiinvtrinv_acct_no
aurora_standard.stiinvtrcog_acct_no
aurora_standard.stiinvtrsales_acct_no
aurora_standard.stiinvtrsupp_acct_no
aurora_standard.stitrandexp_acct_no
aurora_standard.stiwhserinv_acct_no
aurora_standard.stpcntrcap_acct_no
aurora_standard.stpcntrccd_cash_acct_no
aurora_standard.stpcntrccd_disc_acct_no
aurora_standard.stpinvcedisc_acct_no
aurora_standard.stpinvceap_acct_no
aurora_standard.stpinvcecash_acct_no
aurora_standard.stpopendap_acct_no
aurora_standard.stpopendcash_acct_no
aurora_standard.stpvendrcash_acct_no
aurora_standard.stpvendrexp_acct_no
aurora_standard.stpvendrhosp_acct_no
aurora_standard.strcntrcar_acct_no
aurora_standard.strcntrcar_sales_acct_no
aurora_standard.strcntrcar_tax_acct_no
aurora_standard.strcntrcar_frght_acct_no
aurora_standard.strcntrcar_misc_acct_no
aurora_standard.strcntrcar_fc_acct_no
aurora_standard.strcntrccr_cash_acct_no
aurora_standard.strcntrccr_disc_acct_no
aurora_standard.strinvcedisc_acct_no
aurora_standard.strinvcetax_acct_no
aurora_standard.strinvcefrght_acct_no
aurora_standard.strinvcemisc_acct_no
aurora_standard.strinvcear_acct_no
aurora_standard.stropendar_acct_no
aurora_standard.stucntrcap_acct_no
aurora_standard.stucntrcdisc_acct_no
aurora_standard.stucntrcfrght_acct_no
aurora_standard.stucntrcmisc_acct_no
aurora_standard.stucntrcinv_acct_no
aurora_standard.stucntrcadj_acct_no
aurora_standard.stucntrcprepaid_acct_no
aurora_standard.stucntrcsupp_acct_no
aurora_standard.stucntrccap_acct_no
aurora_standard.stucntrcnon_acct_no
aurora_standard.stucntrcdiff_acct_no
aurora_standard.stucntrccash_acct_no
aurora_standard.stucntrcret_acct_no
aurora_standard.stucntrcret_fee_acct_no
aurora_standard.stuinvcdgl_acct_no
aurora_standard.stultyprgl_acct_no
aurora_standard.stuordrdgl_acct_no
aurora_standard.stxcurrrex_diff_acct_no
aurora_standard.stxfinsdfin_acct_no
aurora_standard.stxinforsrc_acct_no
aurora_standard.stxmtaxrar_acct_no
aurora_standard.stxmtaxrar_disc_acct_no
aurora_standard.stxmtaxrap_acct_no
aurora_standard.stxmtaxrap_disc_acct_no
aurora_standard.stycntrcco_bank_acct_no
aurora_standard.styddepdbank_acct_no
aurora_standard.styemplrbank_acct_no
aurora_standard.styempodbal_acct_no
aurora_standard.stypayodbal_acct_no
aurora_standard.stypayrecash_acct_no
aurora_standard.stypddrdbank_acct_no
aurora_standard.styrevsdcash_acct_no
aurora_standard.stytypodbal_acct_no
aurora_standard.styuimmrui_acct_no
aurora_standard.ttiinvtrinv_acct_no
aurora_standard.ttiinvtrcog_acct_no
aurora_standard.ttiinvtrsales_acct_no
aurora_standard.ttiinvtrsupp_acct_no
aurora_standard.wkactvvinv_acct_no
line_no
TableColumn
aurora_standard.chmmbc41service_line_no
aurora_standard.sticstvrrec_line_no
aurora_standard.stmnotednote_line_no
aurora_standard.stmwarrdwarr_line_no
aurora_standard.stoordrdkit_line_no
aurora_standard.stuinvcdinv_line_no
aurora_standard.stuinvcdpo_line_no
aurora_standard.stuordrdorder_line_no
aurora_standard.stuprcheinv_line_no
aurora_standard.sturectdrec_line_no
aurora_standard.sturectdpo_line_no
aurora_standard.sturqstdpo_line_no
aurora_standard.sturqstdref_line_no
aurora_standard.sturtrndret_line_no
aurora_standard.sturtrndpo_line_no
aurora_standard.sturtrndrec_line_no
aurora_standard.sturtrndinv_line_no