aurora_standard.c5cdm

Field Type Null Default Key Extra Comment
fac varchar(10) YES
dept varchar(4) YES
serv_code varchar(10) NO
bill_descrip varchar(40) YES
other_desc varchar(30) YES
rev_cd varchar(10) YES
charge_1 decimal(16,2) YES
ub_flag varchar(1) YES
flag_1500 varchar(1) YES
cpt_code varchar(10) YES
hcpcs_code varchar(10) YES
oth_cpt_code varchar(10) YES
wc_cpt_code varchar(10) YES
comm_cpt_code varchar(10) YES
mod_1 varchar(2) YES
mod_2 varchar(2) YES
md_rev varchar(4) YES
comm_rev varchar(4) YES
inactive_flag varchar(1) YES
ndc varchar(20) YES

References

Local Column References
cpt_code
TableColumn
Loinc.loinc_codeslc_cpt_code
_1.clients_fee_schedules_mapcfsm_cpt_code
_1.clinical_interventions_test_codes_mapcitcm_cpt_code
_1.immunizations_cpt_mapicm_cpt_code
_1.insurances_allowables_cpt_mapiacm_cpt_code
_1.insurances_contracted_pricingicp_cpt_code
_1.insurances_contracted_pricing_logicpl_cpt_code
_1.patients_responsibility_estimates_servicesprests_cpt_code
_1188.clients_fee_schedules_mapcfsm_cpt_code
_1188.clinical_interventions_test_codes_mapcitcm_cpt_code
_1188.immunizations_cpt_mapicm_cpt_code
_1188.insurances_allowables_cpt_mapiacm_cpt_code
_1188.insurances_contracted_pricingicp_cpt_code
_1188.insurances_contracted_pricing_logicpl_cpt_code
_1188.patients_responsibility_estimates_servicesprests_cpt_code
_1218.clients_fee_schedules_mapcfsm_cpt_code
_1218.clinical_interventions_test_codes_mapcitcm_cpt_code
_1218.immunizations_cpt_mapicm_cpt_code
_1218.insurances_allowables_cpt_mapiacm_cpt_code
_1218.insurances_contracted_pricingicp_cpt_code
_1218.insurances_contracted_pricing_logicpl_cpt_code
_1218.patients_responsibility_estimates_servicesprests_cpt_code
_1548.clients_fee_schedules_mapcfsm_cpt_code
_1548.clinical_interventions_test_codes_mapcitcm_cpt_code
_1548.immunizations_cpt_mapicm_cpt_code
_1548.insurances_allowables_cpt_mapiacm_cpt_code
_1548.insurances_contracted_pricingicp_cpt_code
_1548.insurances_contracted_pricing_logicpl_cpt_code
_1548.patients_responsibility_estimates_servicesprests_cpt_code
_435.clients_fee_schedules_mapcfsm_cpt_code
_435.clinical_interventions_test_codes_mapcitcm_cpt_code
_435.immunizations_cpt_mapicm_cpt_code
_435.insurances_allowables_cpt_mapiacm_cpt_code
_435.insurances_contracted_pricingicp_cpt_code
_435.insurances_contracted_pricing_logicpl_cpt_code
_435.patients_responsibility_estimates_servicesprests_cpt_code
_436.clients_fee_schedules_mapcfsm_cpt_code
_436.clinical_interventions_test_codes_mapcitcm_cpt_code
_436.immunizations_cpt_mapicm_cpt_code
_436.insurances_allowables_cpt_mapiacm_cpt_code
_436.insurances_contracted_pricingicp_cpt_code
_436.insurances_contracted_pricing_logicpl_cpt_code
_436.patients_responsibility_estimates_servicesprests_cpt_code
_436_archive_testing.clients_fee_schedules_mapcfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_cpt_code
_436_archive_testing.immunizations_cpt_mapicm_cpt_code
_436_archive_testing.insurances_allowables_cpt_mapiacm_cpt_code
_436_archive_testing.insurances_contracted_pricingicp_cpt_code
_436_archive_testing.insurances_contracted_pricing_logicpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_cpt_code
_437.clients_fee_schedules_mapcfsm_cpt_code
_437.clinical_interventions_test_codes_mapcitcm_cpt_code
_437.immunizations_cpt_mapicm_cpt_code
_437.insurances_allowables_cpt_mapiacm_cpt_code
_437.insurances_contracted_pricingicp_cpt_code
_437.insurances_contracted_pricing_logicpl_cpt_code
_437.patients_responsibility_estimates_servicesprests_cpt_code
_8.clients_fee_schedules_mapcfsm_cpt_code
_8.clinical_interventions_test_codes_mapcitcm_cpt_code
_8.immunizations_cpt_mapicm_cpt_code
_8.insurances_allowables_cpt_mapiacm_cpt_code
_8.insurances_contracted_pricingicp_cpt_code
_8.insurances_contracted_pricing_logicpl_cpt_code
_8.patients_responsibility_estimates_servicesprests_cpt_code
_81.clients_fee_schedules_mapcfsm_cpt_code
_81.clinical_interventions_test_codes_mapcitcm_cpt_code
_81.immunizations_cpt_mapicm_cpt_code
_81.insurances_allowables_cpt_mapiacm_cpt_code
_81.insurances_contracted_pricingicp_cpt_code
_81.insurances_contracted_pricing_logicpl_cpt_code
_81.patients_responsibility_estimates_servicesprests_cpt_code
_999.clients_fee_schedules_mapcfsm_cpt_code
_999.clinical_interventions_test_codes_mapcitcm_cpt_code
_999.immunizations_cpt_mapicm_cpt_code
_999.insurances_allowables_cpt_mapiacm_cpt_code
_999.insurances_contracted_pricingicp_cpt_code
_999.insurances_contracted_pricing_logicpl_cpt_code
_999.patients_responsibility_estimates_servicesprests_cpt_code
aurora_standard.axlscdmmd_cpt_code
aurora_standard.axlscdmci_cpt_code
aurora_standard.c5cdmdroth_cpt_code
aurora_standard.c5cdmdrwc_cpt_code
aurora_standard.c5cdmdrcomm_cpt_code
aurora_standard.c7cdmcomm_cpt_code
aurora_standard.c8cdmcomm_cpt_code
aurora_standard.chmpricaprev_cpt_code
aurora_standard.chmpricacur_cpt_code
aurora_standard.chmpricccomm_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
ndc
TableColumn
_1.charts_cpt_codeschcp_ndc
_1.configured_encounters_templates_cpt_codescetcc_ndc
_1.encounters_cpt_codesecp_ndc
_1.encounters_cpt_codes_templatesecpt_ndc
_1.immunizationsimz_ndc
_1188.charts_cpt_codeschcp_ndc
_1188.configured_encounters_templates_cpt_codescetcc_ndc
_1188.encounters_cpt_codesecp_ndc
_1188.encounters_cpt_codes_templatesecpt_ndc
_1188.immunizationsimz_ndc
_1218.charts_cpt_codeschcp_ndc
_1218.configured_encounters_templates_cpt_codescetcc_ndc
_1218.encounters_cpt_codesecp_ndc
_1218.encounters_cpt_codes_templatesecpt_ndc
_1218.immunizationsimz_ndc
_1548.charts_cpt_codeschcp_ndc
_1548.configured_encounters_templates_cpt_codescetcc_ndc
_1548.encounters_cpt_codesecp_ndc
_1548.encounters_cpt_codes_templatesecpt_ndc
_1548.immunizationsimz_ndc
_435.charts_cpt_codeschcp_ndc
_435.configured_encounters_templates_cpt_codescetcc_ndc
_435.encounters_cpt_codesecp_ndc
_435.encounters_cpt_codes_templatesecpt_ndc
_435.immunizationsimz_ndc
_436.charts_cpt_codeschcp_ndc
_436.configured_encounters_templates_cpt_codescetcc_ndc
_436.encounters_cpt_codesecp_ndc
_436.encounters_cpt_codes_templatesecpt_ndc
_436.immunizationsimz_ndc
_436_archive_testing.charts_cpt_codeschcp_ndc
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_ndc
_436_archive_testing.encounters_cpt_codesecp_ndc
_436_archive_testing.encounters_cpt_codes_templatesecpt_ndc
_436_archive_testing.immunizationsimz_ndc
_437.charts_cpt_codeschcp_ndc
_437.configured_encounters_templates_cpt_codescetcc_ndc
_437.encounters_cpt_codesecp_ndc
_437.encounters_cpt_codes_templatesecpt_ndc
_437.immunizationsimz_ndc
_8.charts_cpt_codeschcp_ndc
_8.configured_encounters_templates_cpt_codescetcc_ndc
_8.encounters_cpt_codesecp_ndc
_8.encounters_cpt_codes_templatesecpt_ndc
_8.immunizationsimz_ndc
_81.charts_cpt_codeschcp_ndc
_81.configured_encounters_templates_cpt_codescetcc_ndc
_81.encounters_cpt_codesecp_ndc
_81.encounters_cpt_codes_templatesecpt_ndc
_81.immunizationsimz_ndc
_999.charts_cpt_codeschcp_ndc
_999.configured_encounters_templates_cpt_codescetcc_ndc
_999.encounters_cpt_codesecp_ndc
_999.encounters_cpt_codes_templatesecpt_ndc
_999.immunizationsimz_ndc
template_library.encounters_cpt_codes_templatesecpt_ndc
fac
TableColumn
aurora_standard.TABLE 1424new_fac
aurora_standard.TABLE 1425new_fac
aurora_standard.chmcntrcbatch_by_fac
aurora_standard.chmpaytcpmt_fac
aurora_standard.chmpaytcadj_fac
aurora_standard.chmpaytcar_fac
aurora_standard.chpcntrccobra_cash_fac
aurora_standard.chpcntrccobra_bal_fac
aurora_standard.chpcntrccobra_fee_fac
aurora_standard.chscustddept_fac
aurora_standard.glxrefnew_fac
aurora_standard.glxrefold_fac
aurora_standard.hl7mshsend_fac
aurora_standard.hl7mshrec_fac
aurora_standard.hl7mshadsend_fac
aurora_standard.hl7mshadrec_fac
aurora_standard.hl7pd1pat_prim_fac
aurora_standard.hl7pd1adpat_prim_fac
aurora_standard.hl7pv1servicing_fac
aurora_standard.hl7pv1adservicing_fac
dept
TableColumn
aurora_standard.TABLE 1424new_dept
aurora_standard.TABLE 1425new_dept
aurora_standard.axlscdmgl_ip_dept
aurora_standard.axlscdmgl_op_dept
aurora_standard.chmpchsdrev_loc_dept
aurora_standard.chmrefndcontr_dept
aurora_standard.chpcashrcash_dept
aurora_standard.chpcemprhome_dept
aurora_standard.chpcntrceduc_dept
aurora_standard.chpcntrccobra_cash_dept
aurora_standard.chpcntrccobra_bal_dept
aurora_standard.chpcntrccobra_fee_dept
aurora_standard.chpcobpdcash_dept
aurora_standard.chpcobpdbal_dept
aurora_standard.chpempcdempl_dept
aurora_standard.chtemplrdflt_dept
aurora_standard.chteshtvdflt_dept
aurora_standard.chtsfdpdshift_dept
aurora_standard.chtsupvcsupv_dept
aurora_standard.empldepthome_dept
aurora_standard.glxrefnew_dept
aurora_standard.glxrefold_dept
aurora_standard.ohofadtldepr_dept
aurora_standard.stfactvddepr_dept
aurora_standard.stfactvvdepr_dept
aurora_standard.stfasstrdepr_dept
aurora_standard.stfasstraccm_dept
aurora_standard.stgrowpdrod_beg_dept
aurora_standard.stgrowpdrod_end_dept
aurora_standard.stoinvcetd_ds_dept
aurora_standard.stoinvcest_tx_dept
aurora_standard.stoinvceco_tx_dept
aurora_standard.stoinvceci_tx_dept
aurora_standard.stoinvcefreight_dept
aurora_standard.stoinvceasset_dept
aurora_standard.stoordrdinv_dept
aurora_standard.stoordrdsls_dept
aurora_standard.stoordrdcog_dept
aurora_standard.stxcalixmedgenix_dept
aurora_standard.stxcalixcalifornia_dept
aurora_standard.stxfinsdfin_dept
aurora_standard.styaccrrliab_dept
aurora_standard.styaccrrexpense_dept
aurora_standard.stydedcrdflt_dept
aurora_standard.styemplrhome_dept
aurora_standard.styemplrdir_dept
aurora_standard.styempodbal_dept
aurora_standard.styinccrdflt_dept
aurora_standard.styinccracru_lia_dept
aurora_standard.styoblcrdflt_dept
aurora_standard.stypayodbal_dept
aurora_standard.stytypodbal_dept
common.test_codestco_x_lab_area_dept
mod_1
TableColumn
aurora_standard.axlscdmmd_mod_1
aurora_standard.axlscdmci_mod_1
aurora_standard.chmpricaprev_mod_1
aurora_standard.chmpricacur_mod_1
mod_2
TableColumn
aurora_standard.axlscdmmd_mod_2
aurora_standard.axlscdmci_mod_2
aurora_standard.chmpricaprev_mod_2
aurora_standard.chmpricacur_mod_2
ub_flag
TableColumn
aurora_standard.axlscdmmd_ub_flag
aurora_standard.axlscdmci_ub_flag
rev_cd
TableColumn
aurora_standard.bfcdminvd_rev_cd
aurora_standard.bfcdmprod_rev_cd
aurora_standard.bfcdmrhcd_rev_cd
aurora_standard.chmsubccstart_rev_cd
aurora_standard.chmsubccend_rev_cd
aurora_standard.hl7dg1drg_grp_rev_cd
other_desc
TableColumn
aurora_standard.chmbillcform_other_desc
serv_code
TableColumn
aurora_standard.chmpcatdrad_serv_code
charge_1
TableColumn
aurora_standard.chmpriccprev_charge_1