aurora_standard.chmgletr

Field Type Null Default Key Extra Comment
user_id char(20) YES MUL
seq_no smallint(6) YES
pname char(30) YES
mr_no char(30) YES
visit_no char(20) YES
dischg_date char(10) YES
balance char(20) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
user_id
TableColumn
HSPI_CURES2015_B1.patient_abstractscompleted_by_user_id
HSPI_Central_Hospital.patient_abstractscompleted_by_user_id
HSPI_Dewitt.patient_abstractscompleted_by_user_id
HSPI_Fulton.patient_abstractscompleted_by_user_id
HSPI_Inferno.patient_abstractscompleted_by_user_id
HSPI_MU2015_E1.patient_abstractscompleted_by_user_id
HSPI_MU2015_G2.patient_abstractscompleted_by_user_id
HSPI_MU2015_G9.patient_abstractscompleted_by_user_id
HSPI_Sandbox.patient_abstractscompleted_by_user_id
HSPI_Summit_General.patient_abstractscompleted_by_user_id
HSPI_United_Physicians.patient_abstractscompleted_by_user_id
MPI.patient_abstractscompleted_by_user_id
SSO.login_eventsspoofed_user_id
SSO.user_registrationinvited_by_user_id
balance
TableColumn
_1.encountersenc_balance
_1188.encountersenc_balance
_1218.encountersenc_balance
_1548.encountersenc_balance
_435.encountersenc_balance
_436.encountersenc_balance
_436_archive_testing.encountersenc_balance
_437.encountersenc_balance
_8.daily_close_calculationsdcc_balance
_8.encountersenc_balance
_81.encountersenc_balance
_999.encountersenc_balance
aurora_standard.chhcntrclarge_balance
aurora_standard.chhcntrcsmall_balance
aurora_standard.chmcntrclarge_balance
aurora_standard.chmcntrcsmall_balance
common.rcm_stats_generalrcmsg_hold_encounters_credit_balance
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
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmhastco_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no
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
dischg_date
TableColumn
aurora_standard.chmchdddold_dischg_date
aurora_standard.chmchdddnew_dischg_date
aurora_standard.chmchpsdchg_dischg_date
aurora_standard.hl7pv2exp_dischg_date
aurora_standard.tmpmrrptedit_dischg_date
pname
TableColumn
aurora_standard.chmnvstbpri_pname
aurora_standard.chmnvstbsec_pname
aurora_standard.chmnvstbter_pname
aurora_standard.chmnvstrpri_pname
aurora_standard.chmnvstrsec_pname
aurora_standard.chmnvstrter_pname