aurora_standard.chm835pr

Field Type Null Default Key Extra Comment
batch_id char(10) NO UNI
batch_complete varchar(1) YES
remit_date date NO
npi_no char(20) NO
remit_type varchar(2) YES
trace_id char(20) NO UNI
payer_cd char(1) NO
payer_name char(30) NO
file_name char(20) NO
production_flag char(1) NO
date_loaded date NO
time_loaded time NO
tot_visits smallint(6) NO
tot_records smallint(6) NO
input_by int(11) YES
total_reimb decimal(16,2) YES
chs_rowID bigint(255) NO PRI auto_increment

References

Local Column References
batch_id
TableColumn
HSPI_Bastrop.chargescharge_batch_id
HSPI_Bastrop.claim_itemsclaim_batch_id
HSPI_Bastrop.claimsclaim_batch_id
HSPI_Bastrop.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Bastrop.invoicesinvoice_batch_id
HSPI_Bastrop.transactionstransaction_batch_id
HSPI_CURES2015_B1.chargescharge_batch_id
HSPI_CURES2015_B1.claim_itemsclaim_batch_id
HSPI_CURES2015_B1.claimsclaim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_mapclaim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrapperstransaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_CURES2015_B1.invoicesinvoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accountstransaction_batch_id
HSPI_CURES2015_B1.transactionstransaction_batch_id
HSPI_Central_Hospital.chargescharge_batch_id
HSPI_Central_Hospital.claim_filesclaim_batch_id
HSPI_Central_Hospital.claim_itemsclaim_batch_id
HSPI_Central_Hospital.claimsclaim_batch_id
HSPI_Central_Hospital.claims_claim_batches_mapclaim_batch_id
HSPI_Central_Hospital.fa_transaction_wrapperstransaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Central_Hospital.invoicesinvoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accountstransaction_batch_id
HSPI_Central_Hospital.transactionstransaction_batch_id
HSPI_Dewitt.chargescharge_batch_id
HSPI_Dewitt.claim_filesclaim_batch_id
HSPI_Dewitt.claim_itemsclaim_batch_id
HSPI_Dewitt.claimsclaim_batch_id
HSPI_Dewitt.claims_claim_batches_mapclaim_batch_id
HSPI_Dewitt.fa_transaction_wrapperstransaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Dewitt.invoicesinvoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accountstransaction_batch_id
HSPI_Dewitt.transactionstransaction_batch_id
HSPI_Fulton.chargescharge_batch_id
HSPI_Fulton.claim_filesclaim_batch_id
HSPI_Fulton.claim_itemsclaim_batch_id
HSPI_Fulton.claimsclaim_batch_id
HSPI_Fulton.claims_claim_batches_mapclaim_batch_id
HSPI_Fulton.fa_transaction_wrapperstransaction_batch_id
HSPI_Fulton.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Fulton.invoicesinvoice_batch_id
HSPI_Fulton.transaction_batch_financial_accountstransaction_batch_id
HSPI_Fulton.transactionstransaction_batch_id
HSPI_Inferno.chargescharge_batch_id
HSPI_Inferno.claim_filesclaim_batch_id
HSPI_Inferno.claim_itemsclaim_batch_id
HSPI_Inferno.claimsclaim_batch_id
HSPI_Inferno.claims_claim_batches_mapclaim_batch_id
HSPI_Inferno.fa_transaction_wrapperstransaction_batch_id
HSPI_Inferno.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Inferno.invoicesinvoice_batch_id
HSPI_Inferno.transaction_batch_financial_accountstransaction_batch_id
HSPI_Inferno.transactionstransaction_batch_id
HSPI_MU2015_E1.chargescharge_batch_id
HSPI_MU2015_E1.claim_filesclaim_batch_id
HSPI_MU2015_E1.claim_itemsclaim_batch_id
HSPI_MU2015_E1.claimsclaim_batch_id
HSPI_MU2015_E1.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_E1.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_E1.invoicesinvoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_E1.transactionstransaction_batch_id
HSPI_MU2015_G2.chargescharge_batch_id
HSPI_MU2015_G2.claim_filesclaim_batch_id
HSPI_MU2015_G2.claim_itemsclaim_batch_id
HSPI_MU2015_G2.claimsclaim_batch_id
HSPI_MU2015_G2.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G2.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G2.invoicesinvoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G2.transactionstransaction_batch_id
HSPI_MU2015_G9.chargescharge_batch_id
HSPI_MU2015_G9.claim_filesclaim_batch_id
HSPI_MU2015_G9.claim_itemsclaim_batch_id
HSPI_MU2015_G9.claimsclaim_batch_id
HSPI_MU2015_G9.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G9.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G9.invoicesinvoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G9.transactionstransaction_batch_id
HSPI_Sandbox.chargescharge_batch_id
HSPI_Sandbox.claim_filesclaim_batch_id
HSPI_Sandbox.claim_itemsclaim_batch_id
HSPI_Sandbox.claimsclaim_batch_id
HSPI_Sandbox.claims_claim_batches_mapclaim_batch_id
HSPI_Sandbox.fa_transaction_wrapperstransaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Sandbox.invoicesinvoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accountstransaction_batch_id
HSPI_Sandbox.transactionstransaction_batch_id
HSPI_Summit_General.chargescharge_batch_id
HSPI_Summit_General.claim_filesclaim_batch_id
HSPI_Summit_General.claim_itemsclaim_batch_id
HSPI_Summit_General.claimsclaim_batch_id
HSPI_Summit_General.claims_claim_batches_mapclaim_batch_id
HSPI_Summit_General.fa_transaction_wrapperstransaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Summit_General.invoicesinvoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accountstransaction_batch_id
HSPI_Summit_General.transactionstransaction_batch_id
HSPI_United_Physicians.chargescharge_batch_id
HSPI_United_Physicians.claim_filesclaim_batch_id
HSPI_United_Physicians.claim_itemsclaim_batch_id
HSPI_United_Physicians.claimsclaim_batch_id
HSPI_United_Physicians.claims_claim_batches_mapclaim_batch_id
HSPI_United_Physicians.fa_transaction_wrapperstransaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_mapinvoice_batch_id
HSPI_United_Physicians.invoicesinvoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accountstransaction_batch_id
HSPI_United_Physicians.transactionstransaction_batch_id
MPI.chargescharge_batch_id
MPI.claim_filesclaim_batch_id
MPI.claim_itemsclaim_batch_id
MPI.claimsclaim_batch_id
MPI.claims_claim_batches_mapclaim_batch_id
MPI.fa_transaction_wrapperstransaction_batch_id
MPI.invoice_batches_facilities_mapinvoice_batch_id
MPI.invoicesinvoice_batch_id
MPI.transaction_batch_financial_accountstransaction_batch_id
MPI.transactionstransaction_batch_id
aurora_standard.hl7ft1trans_batch_id
xlnt.selenium_test_queueselenium_test_batch_id
payer_name
TableColumn
_8.daily_close_calculationsdcc_next_payer_name
common.clients_contract_dataccd_payer_name
payer_cd
TableColumn
aurora_standard.abmmpii1_payer_cd
aurora_standard.abmmpii2_payer_cd
aurora_standard.abmmpii3_payer_cd
aurora_standard.abmvisi1_payer_cd
aurora_standard.abmvisi2_payer_cd
aurora_standard.abmvisi3_payer_cd
file_name
TableColumn
aurora_standard.printoutsoriginal_file_name
common.data_import_clients_meta_datadicmd_file_name