aurora_standard.chmtxstr

Field Type Null Default Key Extra Comment
rec_type char(4) YES
pt_cntrl char(50) YES
bill_type char(4) YES
prov_no char(20) YES
sub_id char(4) YES
from_date char(8) YES
to_date char(8) YES
pat_dob char(8) YES
admit_date char(8) YES
mr_no char(30) YES
filler1 char(10) YES
pat_zip char(5) YES
pat_zip4 char(4) YES
pat_sex char(1) YES
pat_race char(3) YES
pat_ethnicity char(3) YES
adm_typ char(3) YES
adm_src char(3) YES
dis_status char(3) YES
dis_date char(8) YES
adm_hr char(2) YES
dis_hr char(2) YES
obs_hrs char(2) YES
pat_fname char(30) YES
pat_mi char(1) YES
pat_lname char(30) YES
pat_add1 char(30) YES
pat_add2 char(30) YES
pat_city char(30) YES
pat_st char(2) YES
tot_charges char(15) YES
tot_reim char(15) YES
pat_ssn char(9) YES
birth_wt char(4) YES
rcode01 char(4) YES
rate01 char(8) YES
units01 char(7) YES
date01 char(8) YES
chg01 char(11) YES
hcpcs01 char(8) YES
hc01mod1 char(2) YES
hc01mod2 char(2) YES
hc01mod3 char(2) YES
hc01mod4 char(2) YES
rcode02 char(4) YES
rate02 char(8) YES
units02 char(7) YES
date02 char(8) YES
chg02 char(11) YES
hcpcs02 char(8) YES
hc02mod1 char(2) YES
hc02mod2 char(2) YES
hc02mod3 char(2) YES
hc02mod4 char(2) YES
rcode03 char(4) YES
rate03 char(8) YES
units03 char(7) YES
date03 char(8) YES
chg03 char(11) YES
hcpcs03 char(8) YES
hc03mod1 char(2) YES
hc03mod2 char(2) YES
hc03mod3 char(2) YES
hc03mod4 char(2) YES
rcode04 char(4) YES
rate04 char(8) YES
units04 char(7) YES
date04 char(8) YES
chg04 char(11) YES
hcpcs04 char(8) YES
hc04mod1 char(2) YES
hc04mod2 char(2) YES
hc04mod3 char(2) YES
hc04mod4 char(2) YES
rcode05 char(4) YES
rate05 char(8) YES
units05 char(7) YES
date05 char(8) YES
chg05 char(11) YES
hcpcs05 char(8) YES
hc05mod1 char(2) YES
hc05mod2 char(2) YES
hc05mod3 char(2) YES
hc05mod4 char(2) YES
rcode06 char(4) YES
rate06 char(8) YES
units06 char(7) YES
date06 char(8) YES
chg06 char(11) YES
hcpcs06 char(8) YES
hc06mod1 char(2) YES
hc06mod2 char(2) YES
hc06mod3 char(2) YES
hc06mod4 char(2) YES
rcode07 char(4) YES
rate07 char(8) YES
units07 char(7) YES
date07 char(8) YES
chg07 char(11) YES
hcpcs07 char(8) YES
hc07mod1 char(2) YES
hc07mod2 char(2) YES
hc07mod3 char(2) YES
hc07mod4 char(2) YES
rcode08 char(4) YES
rate08 char(8) YES
units08 char(7) YES
date08 char(8) YES
chg08 char(11) YES
hcpcs08 char(8) YES
hc08mod1 char(2) YES
hc08mod2 char(2) YES
hc08mod3 char(2) YES
hc08mod4 char(2) YES
rcode09 char(4) YES
rate09 char(8) YES
units09 char(7) YES
date09 char(8) YES
chg09 char(11) YES
hcpcs09 char(8) YES
hc09mod1 char(2) YES
hc09mod2 char(2) YES
hc09mod3 char(2) YES
hc09mod4 char(2) YES
rcode10 char(4) YES
rate10 char(8) YES
units10 char(7) YES
date10 char(8) YES
chg10 char(11) YES
hcpcs10 char(8) YES
hc10mod1 char(2) YES
hc10mod2 char(2) YES
hc10mod3 char(2) YES
hc10mod4 char(2) YES
rcode11 char(4) YES
rate11 char(8) YES
units11 char(7) YES
date11 char(8) YES
chg11 char(11) YES
hcpcs11 char(8) YES
hc11mod1 char(2) YES
hc11mod2 char(2) YES
hc11mod3 char(2) YES
hc11mod4 char(2) YES
rcode12 char(4) YES
rate12 char(8) YES
units12 char(7) YES
date12 char(8) YES
chg12 char(11) YES
hcpcs12 char(8) YES
hc12mod1 char(2) YES
hc12mod2 char(2) YES
hc12mod3 char(2) YES
hc12mod4 char(2) YES
rcode13 char(4) YES
rate13 char(8) YES
units13 char(7) YES
date13 char(8) YES
chg13 char(11) YES
hcpcs13 char(8) YES
hc13mod1 char(2) YES
hc13mod2 char(2) YES
hc13mod3 char(2) YES
hc13mod4 char(2) YES
rcode14 char(4) YES
rate14 char(8) YES
units14 char(7) YES
date14 char(8) YES
chg14 char(11) YES
hcpcs14 char(8) YES
hc14mod1 char(2) YES
hc14mod2 char(2) YES
hc14mod3 char(2) YES
hc14mod4 char(2) YES
rcode15 char(4) YES
rate15 char(8) YES
units15 char(7) YES
date15 char(8) YES
chg15 char(11) YES
hcpcs15 char(8) YES
hc15mod1 char(2) YES
hc15mod2 char(2) YES
hc15mod3 char(2) YES
hc15mod4 char(2) YES
rcode16 char(4) YES
rate16 char(8) YES
units16 char(7) YES
date16 char(8) YES
chg16 char(11) YES
hcpcs16 char(8) YES
hc16mod1 char(2) YES
hc16mod2 char(2) YES
hc16mod3 char(2) YES
hc16mod4 char(2) YES
rcode17 char(4) YES
rate17 char(8) YES
units17 char(7) YES
date17 char(8) YES
chg17 char(11) YES
hcpcs17 char(8) YES
hc17mod1 char(2) YES
hc17mod2 char(2) YES
hc17mod3 char(2) YES
hc17mod4 char(2) YES
rcode18 char(4) YES
rate18 char(8) YES
units18 char(7) YES
date18 char(8) YES
chg18 char(11) YES
hcpcs18 char(8) YES
hc18mod1 char(2) YES
hc18mod2 char(2) YES
hc18mod3 char(2) YES
hc18mod4 char(2) YES
rcode19 char(4) YES
rate19 char(8) YES
units19 char(7) YES
date19 char(8) YES
chg19 char(11) YES
hcpcs19 char(8) YES
hc19mod1 char(2) YES
hc19mod2 char(2) YES
hc19mod3 char(2) YES
hc19mod4 char(2) YES
rcode20 char(4) YES
rate20 char(8) YES
units20 char(7) YES
date20 char(8) YES
chg20 char(11) YES
hcpcs20 char(8) YES
hc20mod1 char(2) YES
hc20mod2 char(2) YES
hc20mod3 char(2) YES
hc20mod4 char(2) YES
rcode21 char(4) YES
rate21 char(8) YES
units21 char(7) YES
date21 char(8) YES
chg21 char(11) YES
hcpcs21 char(8) YES
hc21mod1 char(2) YES
hc21mod2 char(2) YES
hc21mod3 char(2) YES
hc21mod4 char(2) YES
rcode22 char(4) YES
rate22 char(8) YES
units22 char(7) YES
date22 char(8) YES
chg22 char(11) YES
hcpcs22 char(8) YES
hc22mod1 char(2) YES
hc22mod2 char(2) YES
hc22mod3 char(2) YES
hc22mod4 char(2) YES
rcode23 char(4) YES
rate23 char(8) YES
units23 char(7) YES
date23 char(8) YES
chg23 char(11) YES
hcpcs23 char(8) YES
hc23mod1 char(2) YES
hc23mod2 char(2) YES
hc23mod3 char(2) YES
hc23mod4 char(2) YES
rcode24 char(4) YES
rate24 char(8) YES
units24 char(7) YES
date24 char(8) YES
chg24 char(11) YES
hcpcs24 char(8) YES
hc24mod1 char(2) YES
hc24mod2 char(2) YES
hc24mod3 char(2) YES
hc24mod4 char(2) YES
rcode25 char(4) YES
rate25 char(8) YES
units25 char(7) YES
date25 char(8) YES
chg25 char(11) YES
hcpcs25 char(8) YES
hc25mod1 char(2) YES
hc25mod2 char(2) YES
hc25mod3 char(2) YES
hc25mod4 char(2) YES
rcode26 char(4) YES
rate26 char(8) YES
units26 char(7) YES
date26 char(8) YES
chg26 char(11) YES
hcpcs26 char(8) YES
hc26mod1 char(2) YES
hc26mod2 char(2) YES
hc26mod3 char(2) YES
hc26mod4 char(2) YES
rcode27 char(4) YES
rate27 char(8) YES
units27 char(7) YES
date27 char(8) YES
chg27 char(11) YES
hcpcs27 char(8) YES
hc27mod1 char(2) YES
hc27mod2 char(2) YES
hc27mod3 char(2) YES
hc27mod4 char(2) YES
rcode28 char(4) YES
rate28 char(8) YES
units28 char(7) YES
date28 char(8) YES
chg28 char(11) YES
hcpcs28 char(8) YES
hc28mod1 char(2) YES
hc28mod2 char(2) YES
hc28mod3 char(2) YES
hc28mod4 char(2) YES
rcode29 char(4) YES
rate29 char(8) YES
units29 char(7) YES
date29 char(8) YES
chg29 char(11) YES
hcpcs29 char(8) YES
hc29mod1 char(2) YES
hc29mod2 char(2) YES
hc29mod3 char(2) YES
hc29mod4 char(2) YES
rcode30 char(4) YES
rate30 char(8) YES
units30 char(7) YES
date30 char(8) YES
chg30 char(11) YES
hcpcs30 char(8) YES
hc30mod1 char(2) YES
hc30mod2 char(2) YES
hc30mod3 char(2) YES
hc30mod4 char(2) YES
icd_version char(1) YES
admit_dx char(8) YES
pri_dx char(8) YES
pri_poa char(1) YES
dx01 char(8) YES
poa01 char(1) YES
dx02 char(8) YES
poa02 char(1) YES
dx03 char(8) YES
poa03 char(1) YES
dx04 char(8) YES
poa04 char(1) YES
dx05 char(8) YES
poa05 char(1) YES
dx06 char(8) YES
poa06 char(1) YES
dx07 char(8) YES
poa07 char(1) YES
dx08 char(8) YES
poa08 char(1) YES
dx09 char(8) YES
poa09 char(1) YES
dx10 char(8) YES
poa10 char(1) YES
dx11 char(8) YES
poa11 char(1) YES
dx12 char(8) YES
poa12 char(1) YES
dx13 char(8) YES
poa13 char(1) YES
dx14 char(8) YES
poa14 char(1) YES
dx15 char(8) YES
poa15 char(1) YES
dx16 char(8) YES
poa16 char(1) YES
dx17 char(8) YES
poa17 char(1) YES
dx18 char(8) YES
poa18 char(1) YES
dx19 char(8) YES
poa19 char(1) YES
dx20 char(8) YES
poa20 char(1) YES
dx21 char(8) YES
poa21 char(1) YES
dx22 char(8) YES
poa22 char(1) YES
dx23 char(8) YES
poa23 char(1) YES
dx24 char(8) YES
poa24 char(1) YES
dx25 char(8) YES
poa25 char(1) YES
dx26 char(8) YES
poa26 char(1) YES
dx27 char(8) YES
poa27 char(1) YES
dx28 char(8) YES
poa28 char(1) YES
dx29 char(8) YES
poa29 char(1) YES
dx30 char(8) YES
poa30 char(1) YES
e_cde1 char(8) YES
e_poa1 char(1) YES
e_cde2 char(8) YES
e_poa2 char(1) YES
e_cde3 char(8) YES
e_poa3 char(1) YES
e_cde4 char(8) YES
e_poa4 char(1) YES
e_cde5 char(8) YES
e_poa5 char(1) YES
reason_1 char(8) YES
reason_2 char(8) YES
reason_3 char(8) YES
prin_proc char(8) YES
prin_pro_dt char(8) YES
prin_proc_phys char(22) YES
proc01 char(8) YES
proc01_dt char(8) YES
proc_phy01 char(22) YES
proc02 char(8) YES
proc02_dt char(8) YES
proc_phy02 char(22) YES
proc03 char(8) YES
proc03_dt char(8) YES
proc_phy03 char(22) YES
proc04 char(8) YES
proc04_dt char(8) YES
proc_phy04 char(22) YES
proc05 char(8) YES
proc05_dt char(8) YES
proc_phy05 char(22) YES
proc06 char(8) YES
proc06_dt char(8) YES
proc_phy06 char(22) YES
proc07 char(8) YES
proc07_dt char(8) YES
proc_phy07 char(22) YES
proc08 char(8) YES
proc08_dt char(8) YES
proc_phy08 char(22) YES
proc09 char(8) YES
proc09_dt char(8) YES
proc_phy09 char(22) YES
proc10 char(8) YES
proc10_dt char(8) YES
proc_phy10 char(22) YES
proc11 char(8) YES
proc11_dt char(8) YES
proc_phy11 char(22) YES
proc12 char(8) YES
proc12_dt char(8) YES
proc_phy12 char(22) YES
proc13 char(8) YES
proc13_dt char(8) YES
proc_phy13 char(22) YES
proc14 char(8) YES
proc14_dt char(8) YES
proc_phy14 char(22) YES
proc15 char(8) YES
proc15_dt char(8) YES
proc_phy15 char(22) YES
proc16 char(8) YES
proc16_dt char(8) YES
proc_phy16 char(22) YES
proc17 char(8) YES
proc17_dt char(8) YES
proc_phy17 char(22) YES
proc18 char(8) YES
proc18_dt char(8) YES
proc_phy18 char(22) YES
proc19 char(8) YES
proc19_dt char(8) YES
proc_phy19 char(22) YES
proc20 char(8) YES
proc20_dt char(8) YES
proc_phy20 char(22) YES
proc21 char(8) YES
proc21_dt char(8) YES
proc_phy21 char(22) YES
proc22 char(8) YES
proc22_dt char(8) YES
proc_phy22 char(22) YES
proc23 char(8) YES
proc23_dt char(8) YES
proc_phy23 char(22) YES
proc24 char(8) YES
proc24_dt char(8) YES
proc_phy24 char(22) YES
proc25 char(8) YES
proc25_dt char(8) YES
proc_phy25 char(22) YES
proc26 char(8) YES
proc26_dt char(8) YES
proc_phy26 char(22) YES
proc27 char(8) YES
proc27_dt char(8) YES
proc_phy27 char(22) YES
proc28 char(8) YES
proc28_dt char(8) YES
proc_phy28 char(22) YES
proc29 char(8) YES
proc29_dt char(8) YES
proc_phy29 char(22) YES
proc30 char(8) YES
proc30_dt char(8) YES
proc_phy30 char(22) YES
phy_id_type char(2) YES
att_phy_id char(22) YES
adm_phy_id char(22) YES
op_phy_id char(22) YES
ref_phy_id char(22) YES
cons_phy_id char(22) YES
cons_phy_id2 char(22) YES
cons_phy_id3 char(22) YES
oth_phy_id char(22) YES
empl_stat_cde char(1) YES
pat_empl_nm char(24) YES
pat_marital char(1) YES
pat_empl_zip char(9) YES
md_prov_num char(12) YES
mc_prov_num char(12) YES
pri_payer_num char(5) YES
pri_payer char(5) YES
pri_payer_nm char(25) YES
pri_payer_cert char(19) YES
pri_ins_grp char(20) YES
pri_pat_rel char(2) YES
pri_payer_subid char(4) YES
sec_payer_num char(5) YES
sec_payer char(5) YES
sec_payer_nm char(25) YES
sec_payer_cert char(19) YES
sec_ins_grp char(20) YES
sec_pat_rel char(2) YES
sec_payer_subid char(4) YES
ter_payer_num char(5) YES
ter_payer char(5) YES
ter_payer_nm char(25) YES
ter_payer_cert char(19) YES
ter_ins_grp char(20) YES
ter_pat_rel char(2) YES
ter_payer_subid char(4) YES
pat_type char(10) YES
cln_svc_code char(2) YES
ud_fld01 char(20) YES
ud_fld02 char(20) YES
ud_fld03 char(20) YES
ud_fld04 char(20) YES
ud_fld05 char(20) YES
ud_fld06 char(20) YES
ud_fld07 char(20) YES
ud_fld08 char(20) YES
ud_fld09 char(20) YES
ud_fld10 char(20) YES
ud_fld11 char(20) YES
ud_fld12 char(20) YES
ud_fld13 char(20) YES
ud_fld14 char(20) YES
ud_fld15 char(20) YES
ud_fld16 char(20) YES
ud_fld17 char(20) YES
ud_fld18 char(20) YES
ud_fld19 char(20) YES
ud_fld20 char(20) YES
att_phy_fname char(8) YES
att_phy_mi char(1) YES
att_phy_lname char(16) YES
op_phy_fname char(8) YES
op_phy_mi char(1) YES
op_phy_lname char(16) YES
cons_phy_fname char(8) YES
cons_phy_mi char(1) YES
cons_phy_lname char(16) YES
cond_code1 char(2) YES
cond_code2 char(2) YES
cond_code3 char(2) YES
cond_code4 char(2) YES
cond_code5 char(2) YES
val_code1 char(2) YES
val_amt1 char(9) YES
val_code2 char(2) YES
val_amt2 char(9) YES
val_code3 char(2) YES
val_amt3 char(9) YES
val_code4 char(2) YES
val_amt4 char(9) YES
val_code5 char(2) YES
val_amt5 char(9) YES
occ_code1 char(2) YES
occ_date1 char(8) YES
occ_code2 char(2) YES
occ_date2 char(8) YES
occ_code3 char(2) YES
occ_date3 char(8) YES
occ_code4 char(2) YES
occ_date4 char(8) YES
occ_code5 char(2) YES
occ_date5 char(8) YES
occ_spcode1 char(2) YES
occ_frdate1 char(8) YES
occ_todate1 char(8) YES
occ_spcode2 char(2) YES
occ_frdate2 char(8) YES
occ_todate2 char(8) YES
occ_spcode3 char(2) YES
occ_frdate3 char(8) YES
occ_todate3 char(8) YES
occ_spcode4 char(2) YES
occ_frdate4 char(8) YES
occ_todate4 char(8) YES
pat_cntry_code char(3) YES
filler2 char(251) YES
filler3 char(251) YES

References

Local Column References
bill_type
TableColumn
_1.chartschrt_bill_type
_1.encountersenc_bill_type
_1.encounters_cpt_codesecp_next_payer_bill_type
_1.encounters_paymentsepay_bill_type
_1.insurancesins_ub04_bill_type
_1.locationsloc_ub04_bill_type
_1.ordersord_bill_type
_1.patientspat_bill_type
_1.patients_demographics_snapshotspds_bill_type
_1.physiciansphy_ub04_bill_type
_1.precertspre_bill_type
_1.radiology_ordersrad_bill_type
_1188.chartschrt_bill_type
_1188.encountersenc_bill_type
_1188.encounters_cpt_codesecp_next_payer_bill_type
_1188.encounters_paymentsepay_bill_type
_1188.insurancesins_ub04_bill_type
_1188.locationsloc_ub04_bill_type
_1188.ordersord_bill_type
_1188.patientspat_bill_type
_1188.patients_demographics_snapshotspds_bill_type
_1188.physiciansphy_ub04_bill_type
_1188.precertspre_bill_type
_1188.radiology_ordersrad_bill_type
_1218.chartschrt_bill_type
_1218.encountersenc_bill_type
_1218.encounters_cpt_codesecp_next_payer_bill_type
_1218.encounters_paymentsepay_bill_type
_1218.insurancesins_ub04_bill_type
_1218.locationsloc_ub04_bill_type
_1218.ordersord_bill_type
_1218.patientspat_bill_type
_1218.patients_demographics_snapshotspds_bill_type
_1218.physiciansphy_ub04_bill_type
_1218.precertspre_bill_type
_1218.radiology_ordersrad_bill_type
_1548.chartschrt_bill_type
_1548.encountersenc_bill_type
_1548.encounters_cpt_codesecp_next_payer_bill_type
_1548.encounters_paymentsepay_bill_type
_1548.insurancesins_ub04_bill_type
_1548.locationsloc_ub04_bill_type
_1548.ordersord_bill_type
_1548.patientspat_bill_type
_1548.patients_demographics_snapshotspds_bill_type
_1548.physiciansphy_ub04_bill_type
_1548.precertspre_bill_type
_1548.radiology_ordersrad_bill_type
_435.chartschrt_bill_type
_435.encountersenc_bill_type
_435.encounters_cpt_codesecp_next_payer_bill_type
_435.encounters_paymentsepay_bill_type
_435.insurancesins_ub04_bill_type
_435.ledger_running_balancelrb_next_payer_bill_type
_435.locationsloc_ub04_bill_type
_435.ordersord_bill_type
_435.patientspat_bill_type
_435.patients_demographics_snapshotspds_bill_type
_435.physiciansphy_ub04_bill_type
_435.precertspre_bill_type
_435.radiology_ordersrad_bill_type
_436.chartschrt_bill_type
_436.encountersenc_bill_type
_436.encounters_cpt_codesecp_next_payer_bill_type
_436.encounters_paymentsepay_bill_type
_436.insurancesins_ub04_bill_type
_436.ledger_running_balancelrb_next_payer_bill_type
_436.locationsloc_ub04_bill_type
_436.ordersord_bill_type
_436.patientspat_bill_type
_436.patients_demographics_snapshotspds_bill_type
_436.physiciansphy_ub04_bill_type
_436.precertspre_bill_type
_436.radiology_ordersrad_bill_type
_436_archive_testing.chartschrt_bill_type
_436_archive_testing.encountersenc_bill_type
_436_archive_testing.encounters_cpt_codesecp_next_payer_bill_type
_436_archive_testing.encounters_paymentsepay_bill_type
_436_archive_testing.insurancesins_ub04_bill_type
_436_archive_testing.ledger_running_balancelrb_next_payer_bill_type
_436_archive_testing.locationsloc_ub04_bill_type
_436_archive_testing.ordersord_bill_type
_436_archive_testing.patientspat_bill_type
_436_archive_testing.patients_demographics_snapshotspds_bill_type
_436_archive_testing.physiciansphy_ub04_bill_type
_436_archive_testing.precertspre_bill_type
_436_archive_testing.radiology_ordersrad_bill_type
_437.chartschrt_bill_type
_437.encountersenc_bill_type
_437.encounters_cpt_codesecp_next_payer_bill_type
_437.encounters_paymentsepay_bill_type
_437.insurancesins_ub04_bill_type
_437.ledger_running_balancelrb_next_payer_bill_type
_437.locationsloc_ub04_bill_type
_437.ordersord_bill_type
_437.patientspat_bill_type
_437.patients_demographics_snapshotspds_bill_type
_437.physiciansphy_ub04_bill_type
_437.precertspre_bill_type
_437.radiology_ordersrad_bill_type
_8.chartschrt_bill_type
_8.daily_close_calculationsdcc_next_payer_bill_type
_8.daily_close_calculationsdcc_enc_bill_type
_8.encountersenc_bill_type
_8.encounters_cpt_codesecp_next_payer_bill_type
_8.encounters_paymentsepay_bill_type
_8.insurancesins_ub04_bill_type
_8.locationsloc_ub04_bill_type
_8.ordersord_bill_type
_8.patientspat_bill_type
_8.patients_demographics_snapshotspds_bill_type
_8.physiciansphy_ub04_bill_type
_8.precertspre_bill_type
_8.radiology_ordersrad_bill_type
_81.chartschrt_bill_type
_81.encountersenc_bill_type
_81.encounters_cpt_codesecp_next_payer_bill_type
_81.encounters_paymentsepay_bill_type
_81.insurancesins_ub04_bill_type
_81.locationsloc_ub04_bill_type
_81.ordersord_bill_type
_81.patientspat_bill_type
_81.patients_demographics_snapshotspds_bill_type
_81.physiciansphy_ub04_bill_type
_81.precertspre_bill_type
_81.radiology_ordersrad_bill_type
_999.chartschrt_bill_type
_999.encountersenc_bill_type
_999.encounters_cpt_codesecp_next_payer_bill_type
_999.encounters_paymentsepay_bill_type
_999.insurancesins_ub04_bill_type
_999.locationsloc_ub04_bill_type
_999.ordersord_bill_type
_999.patientspat_bill_type
_999.patients_demographics_snapshotspds_bill_type
_999.physiciansphy_ub04_bill_type
_999.precertspre_bill_type
_999.radiology_ordersrad_bill_type
common.clientscli_ub04_bill_type
pat_sex
TableColumn
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
dx10
TableColumn
_1.encounters_cpt_codesecp_dx10
_1188.encounters_cpt_codesecp_dx10
_1218.encounters_cpt_codesecp_dx10
_1548.encounters_cpt_codesecp_dx10
_435.encounters_cpt_codesecp_dx10
_436.encounters_cpt_codesecp_dx10
_436_archive_testing.encounters_cpt_codesecp_dx10
_437.encounters_cpt_codesecp_dx10
_8.encounters_cpt_codesecp_dx10
_81.encounters_cpt_codesecp_dx10
_999.encounters_cpt_codesecp_dx10
aurora_standard.chmmhastother_dx10
aurora_standard.chmmhastpoa_dx10
from_date
TableColumn
_1.encounters_ub04enc_ub04_06_from_date
_1.schedulessch_from_date
_1.schedules_eventssevnt_from_date
_1.taskstask_from_date
_1188.encounters_ub04enc_ub04_06_from_date
_1188.schedulessch_from_date
_1188.schedules_eventssevnt_from_date
_1188.taskstask_from_date
_1218.encounters_ub04enc_ub04_06_from_date
_1218.schedulessch_from_date
_1218.schedules_eventssevnt_from_date
_1218.taskstask_from_date
_1548.encounters_ub04enc_ub04_06_from_date
_1548.schedulessch_from_date
_1548.schedules_eventssevnt_from_date
_1548.taskstask_from_date
_435.encounters_ub04enc_ub04_06_from_date
_435.schedulessch_from_date
_435.schedules_eventssevnt_from_date
_435.taskstask_from_date
_436.encounters_ub04enc_ub04_06_from_date
_436.schedulessch_from_date
_436.schedules_eventssevnt_from_date
_436.taskstask_from_date
_436_archive_testing.encounters_ub04enc_ub04_06_from_date
_436_archive_testing.schedulessch_from_date
_436_archive_testing.schedules_eventssevnt_from_date
_436_archive_testing.taskstask_from_date
_437.encounters_ub04enc_ub04_06_from_date
_437.schedulessch_from_date
_437.schedules_eventssevnt_from_date
_437.taskstask_from_date
_8.encounters_ub04enc_ub04_06_from_date
_8.schedulessch_from_date
_8.schedules_eventssevnt_from_date
_8.taskstask_from_date
_81.encounters_ub04enc_ub04_06_from_date
_81.schedulessch_from_date
_81.schedules_eventssevnt_from_date
_81.taskstask_from_date
_999.encounters_ub04enc_ub04_06_from_date
_999.schedulessch_from_date
_999.schedules_eventssevnt_from_date
_999.taskstask_from_date
aurora_standard.chmardydrev_from_date
aurora_standard.chmcptvceff_from_date
aurora_standard.chmvrsnceff_from_date
common.rcm_stats_generalrcmsg_from_date
common.rcm_stats_practice_analysisrcmspa_from_date
to_date
TableColumn
_1.schedulessch_to_date
_1.schedules_eventssevnt_to_date
_1.taskstask_to_date
_1188.schedulessch_to_date
_1188.schedules_eventssevnt_to_date
_1188.taskstask_to_date
_1218.schedulessch_to_date
_1218.schedules_eventssevnt_to_date
_1218.taskstask_to_date
_1548.schedulessch_to_date
_1548.schedules_eventssevnt_to_date
_1548.taskstask_to_date
_435.schedulessch_to_date
_435.schedules_eventssevnt_to_date
_435.taskstask_to_date
_436.schedulessch_to_date
_436.schedules_eventssevnt_to_date
_436.taskstask_to_date
_436_archive_testing.schedulessch_to_date
_436_archive_testing.schedules_eventssevnt_to_date
_436_archive_testing.taskstask_to_date
_437.schedulessch_to_date
_437.schedules_eventssevnt_to_date
_437.taskstask_to_date
_8.schedulessch_to_date
_8.schedules_eventssevnt_to_date
_8.taskstask_to_date
_81.schedulessch_to_date
_81.schedules_eventssevnt_to_date
_81.taskstask_to_date
_999.schedulessch_to_date
_999.schedules_eventssevnt_to_date
_999.taskstask_to_date
common.rcm_stats_agingrcmsa_to_date
common.rcm_stats_generalrcmsg_to_date
common.rcm_stats_practice_analysisrcmspa_to_date
adm_hr
TableColumn
aurora_standard.bhppatlast_adm_hr
aurora_standard.bhtppatlast_adm_hr
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
sub_id
TableColumn
aurora_standard.chhcntrcreceiver_sub_id
aurora_standard.chmarstfederal_sub_id
aurora_standard.chmarstifederal_sub_id
aurora_standard.chmarsttifederal_sub_id
aurora_standard.chmarsttrfederal_sub_id
aurora_standard.chmcntrcreceiver_sub_id
aurora_standard.chmcostafed_tax_sub_id
aurora_standard.chmhid4afed_tax_sub_id
filler1
TableColumn
aurora_standard.chltrnsds_filler1
reason_1
TableColumn
aurora_standard.chm835pdadj_reason_1
aurora_standard.chm835pssvc_reason_1
reason_2
TableColumn
aurora_standard.chm835pdadj_reason_2
aurora_standard.chm835pssvc_reason_2
reason_3
TableColumn
aurora_standard.chm835pdadj_reason_3
aurora_standard.chm835pssvc_reason_3
admit_date
TableColumn
aurora_standard.chmadmtrlast_admit_date
aurora_standard.hhmadmtrlast_admit_date
aurora_standard.hl7pv2expect_admit_date
dis_date
TableColumn
aurora_standard.chmadmtrlast_dis_date
aurora_standard.hhmadmtrlast_dis_date
dx11
TableColumn
aurora_standard.chmmhastother_dx11
aurora_standard.chmmhastpoa_dx11
dx12
TableColumn
aurora_standard.chmmhastother_dx12
aurora_standard.chmmhastpoa_dx12
dx13
TableColumn
aurora_standard.chmmhastother_dx13
aurora_standard.chmmhastpoa_dx13
dx14
TableColumn
aurora_standard.chmmhastother_dx14
aurora_standard.chmmhastpoa_dx14
dx15
TableColumn
aurora_standard.chmmhastother_dx15
aurora_standard.chmmhastpoa_dx15
dx16
TableColumn
aurora_standard.chmmhastother_dx16
aurora_standard.chmmhastpoa_dx16
dx17
TableColumn
aurora_standard.chmmhastother_dx17
aurora_standard.chmmhastpoa_dx17
dx18
TableColumn
aurora_standard.chmmhastother_dx18
aurora_standard.chmmhastpoa_dx18
dx19
TableColumn
aurora_standard.chmmhastother_dx19
aurora_standard.chmmhastpoa_dx19
dx20
TableColumn
aurora_standard.chmmhastother_dx20
aurora_standard.chmmhastpoa_dx20
dx21
TableColumn
aurora_standard.chmmhastother_dx21
aurora_standard.chmmhastpoa_dx21
dx22
TableColumn
aurora_standard.chmmhastother_dx22
aurora_standard.chmmhastpoa_dx22
dx23
TableColumn
aurora_standard.chmmhastother_dx23
aurora_standard.chmmhastpoa_dx23
dx24
TableColumn
aurora_standard.chmmhastother_dx24
aurora_standard.chmmhastpoa_dx24
dx25
TableColumn
aurora_standard.chmmhastother_dx25
aurora_standard.chmmhastpoa_dx25
dx26
TableColumn
aurora_standard.chmmhastother_dx26
aurora_standard.chmmhastpoa_dx26
dx27
TableColumn
aurora_standard.chmmhastother_dx27
aurora_standard.chmmhastpoa_dx27
dx28
TableColumn
aurora_standard.chmmhastother_dx28
aurora_standard.chmmhastpoa_dx28
dx29
TableColumn
aurora_standard.chmmhastother_dx29
aurora_standard.chmmhastpoa_dx29
adm_src
TableColumn
aurora_standard.chmstatcdef_adm_src
adm_typ
TableColumn
aurora_standard.chmstatcdef_adm_typ
prin_proc
TableColumn
aurora_standard.chmutah7cpt_prin_proc
aurora_standard.chmutahacpt_prin_proc
aurora_standard.chmutahaicd9_prin_proc
proc01
TableColumn
aurora_standard.chmutah7cpt_proc01
aurora_standard.chmutahacpt_proc01
aurora_standard.chmutahaicd9_proc01
proc02
TableColumn
aurora_standard.chmutah7cpt_proc02
aurora_standard.chmutahacpt_proc02
aurora_standard.chmutahaicd9_proc02
proc03
TableColumn
aurora_standard.chmutah7cpt_proc03
aurora_standard.chmutahacpt_proc03
aurora_standard.chmutahaicd9_proc03
proc04
TableColumn
aurora_standard.chmutah7cpt_proc04
aurora_standard.chmutahacpt_proc04
aurora_standard.chmutahaicd9_proc04
proc05
TableColumn
aurora_standard.chmutah7cpt_proc05
aurora_standard.chmutahacpt_proc05
aurora_standard.chmutahaicd9_proc05