aurora_standard.chmblogd

Field	Type	Null	Key	Extra
batch_id	varchar(10)	YES	MUL
visit_no	int(11)	YES
deductible	decimal(8,2)	YES
co_insurance	decimal(8,2)	YES
non_covered	decimal(8,2)	YES
drg_no	smallint(6)	YES
drg_amt	decimal(8,2)	YES
reimburs_amt	decimal(8,2)	YES
contract_adjust	decimal(8,2)	YES
outlier_amt	decimal(8,2)	YES
lab_payment	decimal(8,2)	YES
lab_non_allow	decimal(8,2)	YES
lab_not_hcpc	decimal(8,2)	YES
other_payor_paid	decimal(8,2)	YES
other_payor_name	varchar(20)	YES
pat_resp_room	decimal(8,2)	YES
other_amt	decimal(8,2)	YES
pat_no	varchar(20)	YES
non_cov_days	smallint(6)	YES
new_fc	varchar(5)	YES
bill_id	varchar(3)	YES
pay_type	varchar(3)	YES
ins_co	smallint(6)	YES
covered_days	smallint(6)	YES
second_ub	varchar(1)	YES
seq_number	smallint(6)	YES
which_log	varchar(2)	YES
spec_hand	varchar(2)	YES
remit_type	varchar(4)	YES
network_no	varchar(6)	YES
trans_no	varchar(20)	YES
denial_code	varchar(3)	YES
denial_comment	varchar(20)	YES
resolved_date	date	YES
resolved_code	varchar(3)	YES
pay_date	date	YES
pay_time	time	YES
pay_seq	smallint(6)	YES
bill_status	varchar(3)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

batch_id

Table	Column
HSPI_Bastrop.charges	charge_batch_id
HSPI_Bastrop.claim_items	claim_batch_id
HSPI_Bastrop.claims	claim_batch_id
HSPI_Bastrop.invoice_batches_facilities_map	invoice_batch_id
HSPI_Bastrop.invoices	invoice_batch_id
HSPI_Bastrop.transactions	transaction_batch_id
HSPI_CURES2015_B1.charges	charge_batch_id
HSPI_CURES2015_B1.claim_items	claim_batch_id
HSPI_CURES2015_B1.claims	claim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_map	claim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrappers	transaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_map	invoice_batch_id
HSPI_CURES2015_B1.invoices	invoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_CURES2015_B1.transactions	transaction_batch_id
HSPI_Central_Hospital.charges	charge_batch_id
HSPI_Central_Hospital.claim_files	claim_batch_id
HSPI_Central_Hospital.claim_items	claim_batch_id
HSPI_Central_Hospital.claims	claim_batch_id
HSPI_Central_Hospital.claims_claim_batches_map	claim_batch_id
HSPI_Central_Hospital.fa_transaction_wrappers	transaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_map	invoice_batch_id
HSPI_Central_Hospital.invoices	invoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Central_Hospital.transactions	transaction_batch_id
HSPI_Dewitt.charges	charge_batch_id
HSPI_Dewitt.claim_files	claim_batch_id
HSPI_Dewitt.claim_items	claim_batch_id
HSPI_Dewitt.claims	claim_batch_id
HSPI_Dewitt.claims_claim_batches_map	claim_batch_id
HSPI_Dewitt.fa_transaction_wrappers	transaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_map	invoice_batch_id
HSPI_Dewitt.invoices	invoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Dewitt.transactions	transaction_batch_id
HSPI_Fulton.charges	charge_batch_id
HSPI_Fulton.claim_files	claim_batch_id
HSPI_Fulton.claim_items	claim_batch_id
HSPI_Fulton.claims	claim_batch_id
HSPI_Fulton.claims_claim_batches_map	claim_batch_id
HSPI_Fulton.fa_transaction_wrappers	transaction_batch_id
HSPI_Fulton.invoice_batches_facilities_map	invoice_batch_id
HSPI_Fulton.invoices	invoice_batch_id
HSPI_Fulton.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Fulton.transactions	transaction_batch_id
HSPI_Inferno.charges	charge_batch_id
HSPI_Inferno.claim_files	claim_batch_id
HSPI_Inferno.claim_items	claim_batch_id
HSPI_Inferno.claims	claim_batch_id
HSPI_Inferno.claims_claim_batches_map	claim_batch_id
HSPI_Inferno.fa_transaction_wrappers	transaction_batch_id
HSPI_Inferno.invoice_batches_facilities_map	invoice_batch_id
HSPI_Inferno.invoices	invoice_batch_id
HSPI_Inferno.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Inferno.transactions	transaction_batch_id
HSPI_MU2015_E1.charges	charge_batch_id
HSPI_MU2015_E1.claim_files	claim_batch_id
HSPI_MU2015_E1.claim_items	claim_batch_id
HSPI_MU2015_E1.claims	claim_batch_id
HSPI_MU2015_E1.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_E1.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_E1.invoices	invoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_E1.transactions	transaction_batch_id
HSPI_MU2015_G2.charges	charge_batch_id
HSPI_MU2015_G2.claim_files	claim_batch_id
HSPI_MU2015_G2.claim_items	claim_batch_id
HSPI_MU2015_G2.claims	claim_batch_id
HSPI_MU2015_G2.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G2.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G2.invoices	invoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G2.transactions	transaction_batch_id
HSPI_MU2015_G9.charges	charge_batch_id
HSPI_MU2015_G9.claim_files	claim_batch_id
HSPI_MU2015_G9.claim_items	claim_batch_id
HSPI_MU2015_G9.claims	claim_batch_id
HSPI_MU2015_G9.claims_claim_batches_map	claim_batch_id
HSPI_MU2015_G9.fa_transaction_wrappers	transaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_map	invoice_batch_id
HSPI_MU2015_G9.invoices	invoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accounts	transaction_batch_id
HSPI_MU2015_G9.transactions	transaction_batch_id
HSPI_Sandbox.charges	charge_batch_id
HSPI_Sandbox.claim_files	claim_batch_id
HSPI_Sandbox.claim_items	claim_batch_id
HSPI_Sandbox.claims	claim_batch_id
HSPI_Sandbox.claims_claim_batches_map	claim_batch_id
HSPI_Sandbox.fa_transaction_wrappers	transaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_map	invoice_batch_id
HSPI_Sandbox.invoices	invoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Sandbox.transactions	transaction_batch_id
HSPI_Summit_General.charges	charge_batch_id
HSPI_Summit_General.claim_files	claim_batch_id
HSPI_Summit_General.claim_items	claim_batch_id
HSPI_Summit_General.claims	claim_batch_id
HSPI_Summit_General.claims_claim_batches_map	claim_batch_id
HSPI_Summit_General.fa_transaction_wrappers	transaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_map	invoice_batch_id
HSPI_Summit_General.invoices	invoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accounts	transaction_batch_id
HSPI_Summit_General.transactions	transaction_batch_id
HSPI_United_Physicians.charges	charge_batch_id
HSPI_United_Physicians.claim_files	claim_batch_id
HSPI_United_Physicians.claim_items	claim_batch_id
HSPI_United_Physicians.claims	claim_batch_id
HSPI_United_Physicians.claims_claim_batches_map	claim_batch_id
HSPI_United_Physicians.fa_transaction_wrappers	transaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_map	invoice_batch_id
HSPI_United_Physicians.invoices	invoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accounts	transaction_batch_id
HSPI_United_Physicians.transactions	transaction_batch_id
MPI.charges	charge_batch_id
MPI.claim_files	claim_batch_id
MPI.claim_items	claim_batch_id
MPI.claims	claim_batch_id
MPI.claims_claim_batches_map	claim_batch_id
MPI.fa_transaction_wrappers	transaction_batch_id
MPI.invoice_batches_facilities_map	invoice_batch_id
MPI.invoices	invoice_batch_id
MPI.transaction_batch_financial_accounts	transaction_batch_id
MPI.transactions	transaction_batch_id
aurora_standard.hl7ft1	trans_batch_id
xlnt.selenium_test_queue	selenium_test_batch_id

deductible

Table	Column
_1.patients_responsibility_estimates	prest_deductible
_1.patients_responsibility_estimates_services	prests_deductible
_1188.patients_responsibility_estimates	prest_deductible
_1188.patients_responsibility_estimates_services	prests_deductible
_1218.patients_responsibility_estimates	prest_deductible
_1218.patients_responsibility_estimates_services	prests_deductible
_1548.patients_responsibility_estimates	prest_deductible
_1548.patients_responsibility_estimates_services	prests_deductible
_435.patients_responsibility_estimates	prest_deductible
_435.patients_responsibility_estimates_services	prests_deductible
_436.patients_responsibility_estimates	prest_deductible
_436.patients_responsibility_estimates_services	prests_deductible
_436_archive_testing.patients_responsibility_estimates	prest_deductible
_436_archive_testing.patients_responsibility_estimates_services	prests_deductible
_437.patients_responsibility_estimates	prest_deductible
_437.patients_responsibility_estimates_services	prests_deductible
_8.patients_responsibility_estimates	prest_deductible
_8.patients_responsibility_estimates_services	prests_deductible
_81.patients_responsibility_estimates	prest_deductible
_81.patients_responsibility_estimates_services	prests_deductible
_999.patients_responsibility_estimates	prest_deductible
_999.patients_responsibility_estimates_services	prests_deductible
aurora_standard.chminsrd	def_deductible
aurora_standard.chpinsuc	dep_deductible
aurora_standard.hl7in2	daily_deductible

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

pay_type

Table	Column
aurora_standard.audppayd	gl_pay_type
aurora_standard.chmadmid	mr_pay_type
aurora_standard.chmfcglc	remit_pay_type
aurora_standard.chminsrc	mr_pay_type
aurora_standard.chmppayd	gl_pay_type
aurora_standard.chpinsuc	mr_pay_type
aurora_standard.visit_insurances	mr_pay_type

outlier_amt

Table	Column
aurora_standard.chm835pd	pps_outlier_amt

pay_date

Table	Column
aurora_standard.chmadmqr	self_pay_date
aurora_standard.chmagesd	last_pay_date
aurora_standard.chpcobrd	first_pay_date
aurora_standard.stpinvce	to_pay_date
aurora_standard.stpopend	to_pay_date
aurora_standard.stpopend	last_pay_date
aurora_standard.stpvendr	last_pay_date
aurora_standard.strcustr	last_pay_date
aurora_standard.stropend	last_pay_date

spec_hand

Table	Column
aurora_standard.chmcolac	cur_spec_hand
aurora_standard.chmcolac	new_spec_hand
aurora_standard.chmstatc	def_spec_hand

ins_co

Table	Column
aurora_standard.chmemplr	wc_ins_co
aurora_standard.chmprica	prev_ins_co
aurora_standard.chmprica	cur_ins_co
aurora_standard.chmquesr	work_comp_ins_co
aurora_standard.chqliabd	liab_ins_co