aurora_standard.chmnvstb

Field Type Null Default Key Extra Comment
prov_name char(25) YES
prov_addr char(25) YES
prov_city char(12) YES
prov_st char(2) YES
prov_zip char(10) YES
prov_phone char(12) YES
prov_fax char(12) YES
prov_cntry char(2) YES
payto_name char(25) YES
payto_addr char(25) YES
payto_city char(16) YES
payto_st char(2) YES
payto_zip char(5) YES
fl02_res char(25) YES
visit_no char(20) NO MUL
mr_no char(24) YES
tob char(3) YES
tob4 char(1) YES
sub_id char(4) YES
tax_id char(10) YES
from_date char(10) YES
to_date char(10) YES
fl07a char(7) YES
ssn char(9) YES
pfname char(20) YES
pmi char(1) YES
plname char(30) YES
psuffix char(5) YES
paddr char(40) YES
pcity char(30) YES
pst char(2) YES
pzip char(9) YES
pcntry char(2) YES
pdob char(10) YES
gender char(1) YES
mstat char(1) YES
race char(1) YES
admit_date char(10) YES
adm_hr char(2) YES
adm_typ char(1) YES
adm_src char(1) YES
dis_hr char(2) YES
dis_status char(2) YES
ccde1 char(2) YES
ccde2 char(2) YES
ccde3 char(2) YES
ccde4 char(2) YES
ccde5 char(2) YES
ccde6 char(2) YES
ccde7 char(2) YES
ccde8 char(2) YES
ccde9 char(2) YES
ccde10 char(2) YES
ccde11 char(2) YES
acc_st char(2) YES
fl30a char(11) YES
fl30b char(13) YES
ocde1 char(2) YES
odte1 char(10) YES
ocde2 char(2) YES
odte2 char(10) YES
ocde3 char(2) YES
odte3 char(10) YES
ocde4 char(2) YES
odte4 char(10) YES
ocde5 char(2) YES
odte5 char(10) YES
ocde6 char(2) YES
odte6 char(10) YES
ocde7 char(2) YES
odte7 char(10) YES
ocde8 char(2) YES
odte8 char(10) YES
occ_spcode1 char(2) YES
occ_frdate1 char(10) YES
occ_todate1 char(10) YES
occ_spcode2 char(2) YES
occ_frdate2 char(10) YES
occ_todate2 char(10) YES
occ_spcode3 char(2) YES
occ_frdate3 char(10) YES
occ_todate3 char(10) YES
occ_spcode4 char(2) YES
occ_frdate4 char(10) YES
occ_todate4 char(10) YES
fl37 char(8) YES
rparty char(40) YES
rparty2 char(40) YES
rparty3 char(40) YES
rparty4 char(40) YES
rparty5 char(40) YES
v_code39a char(2) YES
v_amt39a char(9) YES
v_code39b char(2) YES
v_amt39b char(9) YES
v_code39c char(2) YES
v_amt39c char(9) YES
v_code39d char(2) YES
v_amt39d char(9) YES
v_code40a char(2) YES
v_amt40a char(9) YES
v_code40b char(2) YES
v_amt40b char(9) YES
v_code40c char(2) YES
v_amt40c char(9) YES
v_code40d char(2) YES
v_amt40d char(9) YES
v_code41a char(2) YES
v_amt41a char(9) YES
v_code41b char(2) YES
v_amt41b char(9) YES
v_code41c char(2) YES
v_amt41c char(9) YES
v_code41d char(2) YES
v_amt41d char(9) YES
rcode01 char(4) YES
rdesc1 char(24) YES
hcpcs01 char(14) YES
date01 char(10) YES
units01 char(7) YES
chg01 char(9) YES
ncvr1 char(9) YES
fl4901 char(2) YES
rcode02 char(4) YES
rdesc2 char(24) YES
hcpcs02 char(14) YES
date02 char(10) YES
units02 char(7) YES
chg02 char(9) YES
ncvr2 char(9) YES
fl4902 char(2) YES
rcode03 char(4) YES
rdesc3 char(24) YES
hcpcs03 char(14) YES
date03 char(10) YES
units03 char(7) YES
chg03 char(9) YES
ncvr3 char(9) YES
fl4903 char(2) YES
rcode04 char(4) YES
rdesc4 char(24) YES
hcpcs04 char(14) YES
date04 char(10) YES
units04 char(7) YES
chg04 char(9) YES
ncvr4 char(9) YES
fl4904 char(2) YES
rcode05 char(4) YES
rdesc5 char(24) YES
hcpcs05 char(14) YES
date05 char(10) YES
units05 char(7) YES
chg05 char(9) YES
ncvr5 char(9) YES
fl4905 char(2) YES
rcode06 char(4) YES
rdesc6 char(24) YES
hcpcs06 char(14) YES
date06 char(10) YES
units06 char(7) YES
chg06 char(9) YES
ncvr6 char(9) YES
fl4906 char(2) YES
rcode07 char(4) YES
rdesc7 char(24) YES
hcpcs07 char(14) YES
date07 char(10) YES
units07 char(7) YES
chg07 char(9) YES
ncvr7 char(9) YES
fl4907 char(2) YES
rcode08 char(4) YES
rdesc8 char(24) YES
hcpcs08 char(14) YES
date08 char(10) YES
units08 char(7) YES
chg08 char(9) YES
ncvr8 char(9) YES
fl4908 char(2) YES
rcode09 char(4) YES
rdesc9 char(24) YES
hcpcs09 char(14) YES
date09 char(10) YES
units09 char(7) YES
chg09 char(9) YES
ncvr9 char(9) YES
fl4909 char(2) YES
rcode10 char(4) YES
rdesc10 char(24) YES
hcpcs10 char(14) YES
date10 char(10) YES
units10 char(7) YES
chg10 char(9) YES
ncvr10 char(9) YES
fl4910 char(2) YES
rcode11 char(4) YES
rdesc11 char(24) YES
hcpcs11 char(14) YES
date11 char(10) YES
units11 char(7) YES
chg11 char(9) YES
ncvr11 char(9) YES
fl4911 char(2) YES
rcode12 char(4) YES
rdesc12 char(24) YES
hcpcs12 char(14) YES
date12 char(10) YES
units12 char(7) YES
chg12 char(9) YES
ncvr12 char(9) YES
fl4912 char(2) YES
rcode13 char(4) YES
rdesc13 char(24) YES
hcpcs13 char(14) YES
date13 char(10) YES
units13 char(7) YES
chg13 char(9) YES
ncvr13 char(9) YES
fl4913 char(2) YES
rcode14 char(4) YES
rdesc14 char(24) YES
hcpcs14 char(14) YES
date14 char(10) YES
units14 char(7) YES
chg14 char(9) YES
ncvr14 char(9) YES
fl4914 char(2) YES
rcode15 char(4) YES
rdesc15 char(24) YES
hcpcs15 char(14) YES
date15 char(10) YES
units15 char(7) YES
chg15 char(9) YES
ncvr15 char(9) YES
fl4915 char(2) YES
rcode16 char(4) YES
rdesc16 char(24) YES
hcpcs16 char(14) YES
date16 char(10) YES
units16 char(7) YES
chg16 char(9) YES
ncvr16 char(9) YES
fl4916 char(2) YES
rcode17 char(4) YES
rdesc17 char(24) YES
hcpcs17 char(14) YES
date17 char(10) YES
units17 char(7) YES
chg17 char(9) YES
ncvr17 char(9) YES
fl4917 char(2) YES
rcode18 char(4) YES
rdesc18 char(24) YES
hcpcs18 char(14) YES
date18 char(10) YES
units18 char(7) YES
chg18 char(9) YES
ncvr18 char(9) YES
fl4918 char(2) YES
rcode19 char(4) YES
rdesc19 char(24) YES
hcpcs19 char(14) YES
date19 char(10) YES
units19 char(7) YES
chg19 char(9) YES
ncvr19 char(9) YES
fl4919 char(2) YES
rcode20 char(4) YES
rdesc20 char(24) YES
hcpcs20 char(14) YES
date20 char(10) YES
units20 char(7) YES
chg20 char(9) YES
ncvr20 char(9) YES
fl4920 char(2) YES
rcode21 char(4) YES
rdesc21 char(24) YES
hcpcs21 char(14) YES
date21 char(10) YES
units21 char(7) YES
chg21 char(9) YES
ncvr21 char(9) YES
fl4921 char(2) YES
rcode22 char(4) YES
rdesc22 char(24) YES
hcpcs22 char(14) YES
date22 char(10) YES
units22 char(7) YES
chg22 char(9) YES
ncvr22 char(9) YES
fl4922 char(2) YES
rcode23 char(4) YES
chg23 char(9) YES
ncvr23 char(9) YES
fl4923 char(2) YES
cpage char(3) YES
tpage char(3) YES
cdate char(10) YES
pri_pname char(23) YES
sec_pname char(23) YES
ter_pname char(23) YES
hplana char(15) YES
hplanb char(15) YES
hplanc char(15) YES
irpri char(1) YES
irsec char(1) YES
irter char(1) YES
bapri char(1) YES
basec char(1) YES
bater char(1) YES
pri_priorpmt char(9) YES
sec_priorpmt char(9) YES
ter_priorpmt char(9) YES
pri_estamt char(9) YES
sec_estamt char(9) YES
ter_estamt char(9) YES
npi char(15) YES
other_pri char(15) YES
other_sec char(15) YES
other_ter char(15) YES
pri_payer_nm char(25) YES
sec_payer_nm char(25) YES
ter_payer_nm char(25) YES
pri_pat_rel char(2) YES
sec_pat_rel char(2) YES
ter_pat_rel char(2) YES
pri_unique char(20) YES
sec_unique char(20) YES
ter_unique char(20) YES
pri_ins_grpnme char(14) YES
sec_ins_grpnme char(14) YES
ter_ins_grpnme char(14) YES
pri_ins_grpnum char(17) YES
sec_ins_grpnum char(17) YES
ter_ins_grpnum char(17) YES
pri_tauth char(30) YES
sec_tauth char(30) YES
ter_tauth char(30) YES
dcn_a char(26) YES
dcn_b char(26) YES
dcn_c char(26) YES
pri_empname char(25) YES
sec_empname char(25) YES
ter_empname char(25) YES
icd_version char(1) YES
pri_dx char(8) YES
dx01 char(8) YES
dx02 char(8) YES
dx03 char(8) YES
dx04 char(8) YES
dx05 char(8) YES
dx06 char(8) YES
dx07 char(8) YES
dx08 char(8) YES
dx09 char(8) YES
dx10 char(8) YES
dx11 char(8) YES
dx12 char(8) YES
dx13 char(8) YES
dx14 char(8) YES
dx15 char(8) YES
dx16 char(8) YES
dx17 char(8) YES
fl68a char(8) YES
fl68b char(9) YES
adm_dx char(7) YES
reason_1 char(7) YES
reason_2 char(7) YES
reason_3 char(7) YES
pps_code char(4) YES
filler1 char(8) YES
filler2 char(8) YES
filler3 char(8) YES
fl73 char(1) YES
prin_proc char(7) YES
prin_pro_dt char(10) YES
proc01 char(7) YES
proc01_dt char(10) YES
proc02 char(7) YES
proc02_dt char(10) YES
proc03 char(7) YES
proc03_dt char(10) YES
proc04 char(7) YES
proc04_dt char(10) YES
proc05 char(7) YES
proc05_dt char(10) YES
fl75a char(4) YES
fl75b char(4) YES
fl75c char(4) YES
fl75d char(4) YES
att_npi char(11) YES
att_qual char(2) YES
att_id char(9) YES
att_last char(16) YES
att_first char(12) YES
op_npi char(11) YES
op_qual char(2) YES
op_id char(9) YES
op_last char(16) YES
op_first char(12) YES
oth_npi char(11) YES
oth_qual char(2) YES
oth_id char(9) YES
oth_last char(16) YES
oth_first char(12) YES
othb_npi char(11) YES
othb_qual char(2) YES
othb_id char(9) YES
othb_last char(16) YES
othb_first char(12) YES
pri_paycode char(2) YES
sec_paycode char(2) YES
ter_paycode char(2) YES
remark1 char(19) YES
remark2 char(24) YES
remark3 char(24) YES
remark4 char(24) YES
ccquala char(2) YES
cccodea char(10) YES
ccvaluea char(12) YES
ccqualb char(2) YES
cccodeb char(10) YES
ccvalueb char(12) YES
ccqualc char(2) YES
cccodec char(10) YES
ccvaluec char(12) YES
ccquald char(2) YES
cccoded char(10) YES
ccvalued char(12) YES

References

Local Column References
ssn
TableColumn
Azalea.employeesemp_ssn
_1.chartschrt_ssn
_1.cpoe_responsescpoe_res_ssn
_1.encountersenc_ssn
_1.encountersenc_guarantor_ssn
_1.encountersenc_ins1_insured_ssn
_1.encountersenc_ins2_insured_ssn
_1.encountersenc_ins3_insured_ssn
_1.examplesexa_ssn
_1.hl7_accessionsacc_ssn
_1.insurances_repositoryirep_ins_insured_ssn
_1.non_patientsnpat_ssn
_1.ordersord_ssn
_1.patientspat_ssn
_1.patientspat_guarantor_ssn
_1.patientspat_ins1_insured_ssn
_1.patientspat_ins2_insured_ssn
_1.patientspat_ins3_insured_ssn
_1.patients_demographics_snapshotspds_ssn
_1.patients_demographics_snapshotspds_guarantor_ssn
_1.patients_demographics_snapshotspds_ins1_insured_ssn
_1.patients_demographics_snapshotspds_ins2_insured_ssn
_1.patients_demographics_snapshotspds_ins3_insured_ssn
_1.patients_responsibility_estimatesprest_ssn
_1.physiciansphy_ssn_federal_tax_id
_1.precertspre_ssn
_1.precertspre_guarantor_ssn
_1.precertspre_ins1_insured_ssn
_1.precertspre_ins2_insured_ssn
_1.radiology_ordersrad_ssn
_1.radiology_resultsrad_res_ssn
_1188.chartschrt_ssn
_1188.cpoe_responsescpoe_res_ssn
_1188.encountersenc_ssn
_1188.encountersenc_guarantor_ssn
_1188.encountersenc_ins1_insured_ssn
_1188.encountersenc_ins2_insured_ssn
_1188.encountersenc_ins3_insured_ssn
_1188.examplesexa_ssn
_1188.hl7_accessionsacc_ssn
_1188.insurances_repositoryirep_ins_insured_ssn
_1188.non_patientsnpat_ssn
_1188.ordersord_ssn
_1188.patientspat_ssn
_1188.patientspat_guarantor_ssn
_1188.patientspat_ins1_insured_ssn
_1188.patientspat_ins2_insured_ssn
_1188.patientspat_ins3_insured_ssn
_1188.patients_demographics_snapshotspds_ssn
_1188.patients_demographics_snapshotspds_guarantor_ssn
_1188.patients_demographics_snapshotspds_ins1_insured_ssn
_1188.patients_demographics_snapshotspds_ins2_insured_ssn
_1188.patients_demographics_snapshotspds_ins3_insured_ssn
_1188.patients_responsibility_estimatesprest_ssn
_1188.physiciansphy_ssn_federal_tax_id
_1188.precertspre_ssn
_1188.precertspre_guarantor_ssn
_1188.precertspre_ins1_insured_ssn
_1188.precertspre_ins2_insured_ssn
_1188.radiology_ordersrad_ssn
_1188.radiology_resultsrad_res_ssn
_1218.chartschrt_ssn
_1218.cpoe_responsescpoe_res_ssn
_1218.encountersenc_ssn
_1218.encountersenc_guarantor_ssn
_1218.encountersenc_ins1_insured_ssn
_1218.encountersenc_ins2_insured_ssn
_1218.encountersenc_ins3_insured_ssn
_1218.examplesexa_ssn
_1218.hl7_accessionsacc_ssn
_1218.insurances_repositoryirep_ins_insured_ssn
_1218.non_patientsnpat_ssn
_1218.ordersord_ssn
_1218.patientspat_ssn
_1218.patientspat_guarantor_ssn
_1218.patientspat_ins1_insured_ssn
_1218.patientspat_ins2_insured_ssn
_1218.patientspat_ins3_insured_ssn
_1218.patients_demographics_snapshotspds_ssn
_1218.patients_demographics_snapshotspds_guarantor_ssn
_1218.patients_demographics_snapshotspds_ins1_insured_ssn
_1218.patients_demographics_snapshotspds_ins2_insured_ssn
_1218.patients_demographics_snapshotspds_ins3_insured_ssn
_1218.patients_responsibility_estimatesprest_ssn
_1218.physiciansphy_ssn_federal_tax_id
_1218.precertspre_ssn
_1218.precertspre_guarantor_ssn
_1218.precertspre_ins1_insured_ssn
_1218.precertspre_ins2_insured_ssn
_1218.radiology_ordersrad_ssn
_1218.radiology_resultsrad_res_ssn
_1548.chartschrt_ssn
_1548.cpoe_responsescpoe_res_ssn
_1548.encountersenc_ssn
_1548.encountersenc_guarantor_ssn
_1548.encountersenc_ins1_insured_ssn
_1548.encountersenc_ins2_insured_ssn
_1548.encountersenc_ins3_insured_ssn
_1548.examplesexa_ssn
_1548.hl7_accessionsacc_ssn
_1548.insurances_repositoryirep_ins_insured_ssn
_1548.non_patientsnpat_ssn
_1548.ordersord_ssn
_1548.patientspat_ssn
_1548.patientspat_guarantor_ssn
_1548.patientspat_ins1_insured_ssn
_1548.patientspat_ins2_insured_ssn
_1548.patientspat_ins3_insured_ssn
_1548.patients_demographics_snapshotspds_ssn
_1548.patients_demographics_snapshotspds_guarantor_ssn
_1548.patients_demographics_snapshotspds_ins1_insured_ssn
_1548.patients_demographics_snapshotspds_ins2_insured_ssn
_1548.patients_demographics_snapshotspds_ins3_insured_ssn
_1548.patients_responsibility_estimatesprest_ssn
_1548.physiciansphy_ssn_federal_tax_id
_1548.precertspre_ssn
_1548.precertspre_guarantor_ssn
_1548.precertspre_ins1_insured_ssn
_1548.precertspre_ins2_insured_ssn
_1548.radiology_ordersrad_ssn
_1548.radiology_resultsrad_res_ssn
_435.chartschrt_ssn
_435.cpoe_responsescpoe_res_ssn
_435.encountersenc_ssn
_435.encountersenc_guarantor_ssn
_435.encountersenc_ins1_insured_ssn
_435.encountersenc_ins2_insured_ssn
_435.encountersenc_ins3_insured_ssn
_435.examplesexa_ssn
_435.hl7_accessionsacc_ssn
_435.insurances_repositoryirep_ins_insured_ssn
_435.non_patientsnpat_ssn
_435.ordersord_ssn
_435.patientspat_ssn
_435.patientspat_guarantor_ssn
_435.patientspat_ins1_insured_ssn
_435.patientspat_ins2_insured_ssn
_435.patientspat_ins3_insured_ssn
_435.patients_demographics_snapshotspds_ssn
_435.patients_demographics_snapshotspds_guarantor_ssn
_435.patients_demographics_snapshotspds_ins1_insured_ssn
_435.patients_demographics_snapshotspds_ins2_insured_ssn
_435.patients_demographics_snapshotspds_ins3_insured_ssn
_435.patients_responsibility_estimatesprest_ssn
_435.physiciansphy_ssn_federal_tax_id
_435.precertspre_ssn
_435.precertspre_guarantor_ssn
_435.precertspre_ins1_insured_ssn
_435.precertspre_ins2_insured_ssn
_435.radiology_ordersrad_ssn
_435.radiology_resultsrad_res_ssn
_436.chartschrt_ssn
_436.cpoe_responsescpoe_res_ssn
_436.encountersenc_ssn
_436.encountersenc_guarantor_ssn
_436.encountersenc_ins1_insured_ssn
_436.encountersenc_ins2_insured_ssn
_436.encountersenc_ins3_insured_ssn
_436.examplesexa_ssn
_436.hl7_accessionsacc_ssn
_436.insurances_repositoryirep_ins_insured_ssn
_436.non_patientsnpat_ssn
_436.ordersord_ssn
_436.patientspat_ssn
_436.patientspat_guarantor_ssn
_436.patientspat_ins1_insured_ssn
_436.patientspat_ins2_insured_ssn
_436.patientspat_ins3_insured_ssn
_436.patients_demographics_snapshotspds_ssn
_436.patients_demographics_snapshotspds_guarantor_ssn
_436.patients_demographics_snapshotspds_ins1_insured_ssn
_436.patients_demographics_snapshotspds_ins2_insured_ssn
_436.patients_demographics_snapshotspds_ins3_insured_ssn
_436.patients_responsibility_estimatesprest_ssn
_436.physiciansphy_ssn_federal_tax_id
_436.precertspre_ssn
_436.precertspre_guarantor_ssn
_436.precertspre_ins1_insured_ssn
_436.precertspre_ins2_insured_ssn
_436.radiology_ordersrad_ssn
_436.radiology_resultsrad_res_ssn
_436_archive_testing.chartschrt_ssn
_436_archive_testing.cpoe_responsescpoe_res_ssn
_436_archive_testing.encountersenc_ssn
_436_archive_testing.encountersenc_guarantor_ssn
_436_archive_testing.encountersenc_ins1_insured_ssn
_436_archive_testing.encountersenc_ins2_insured_ssn
_436_archive_testing.encountersenc_ins3_insured_ssn
_436_archive_testing.examplesexa_ssn
_436_archive_testing.hl7_accessionsacc_ssn
_436_archive_testing.insurances_repositoryirep_ins_insured_ssn
_436_archive_testing.non_patientsnpat_ssn
_436_archive_testing.ordersord_ssn
_436_archive_testing.patientspat_ssn
_436_archive_testing.patientspat_guarantor_ssn
_436_archive_testing.patientspat_ins1_insured_ssn
_436_archive_testing.patientspat_ins2_insured_ssn
_436_archive_testing.patientspat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ssn
_436_archive_testing.patients_demographics_snapshotspds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshotspds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimatesprest_ssn
_436_archive_testing.physiciansphy_ssn_federal_tax_id
_436_archive_testing.precertspre_ssn
_436_archive_testing.precertspre_guarantor_ssn
_436_archive_testing.precertspre_ins1_insured_ssn
_436_archive_testing.precertspre_ins2_insured_ssn
_436_archive_testing.radiology_ordersrad_ssn
_436_archive_testing.radiology_resultsrad_res_ssn
_437.chartschrt_ssn
_437.cpoe_responsescpoe_res_ssn
_437.encountersenc_ssn
_437.encountersenc_guarantor_ssn
_437.encountersenc_ins1_insured_ssn
_437.encountersenc_ins2_insured_ssn
_437.encountersenc_ins3_insured_ssn
_437.examplesexa_ssn
_437.hl7_accessionsacc_ssn
_437.insurances_repositoryirep_ins_insured_ssn
_437.non_patientsnpat_ssn
_437.ordersord_ssn
_437.patientspat_ssn
_437.patientspat_guarantor_ssn
_437.patientspat_ins1_insured_ssn
_437.patientspat_ins2_insured_ssn
_437.patientspat_ins3_insured_ssn
_437.patients_demographics_snapshotspds_ssn
_437.patients_demographics_snapshotspds_guarantor_ssn
_437.patients_demographics_snapshotspds_ins1_insured_ssn
_437.patients_demographics_snapshotspds_ins2_insured_ssn
_437.patients_demographics_snapshotspds_ins3_insured_ssn
_437.patients_responsibility_estimatesprest_ssn
_437.physiciansphy_ssn_federal_tax_id
_437.precertspre_ssn
_437.precertspre_guarantor_ssn
_437.precertspre_ins1_insured_ssn
_437.precertspre_ins2_insured_ssn
_437.radiology_ordersrad_ssn
_437.radiology_resultsrad_res_ssn
_8.chartschrt_ssn
_8.cpoe_responsescpoe_res_ssn
_8.encountersenc_ssn
_8.encountersenc_guarantor_ssn
_8.encountersenc_ins1_insured_ssn
_8.encountersenc_ins2_insured_ssn
_8.encountersenc_ins3_insured_ssn
_8.examplesexa_ssn
_8.hl7_accessionsacc_ssn
_8.insurances_repositoryirep_ins_insured_ssn
_8.non_patientsnpat_ssn
_8.ordersord_ssn
_8.patientspat_ssn
_8.patientspat_guarantor_ssn
_8.patientspat_ins1_insured_ssn
_8.patientspat_ins2_insured_ssn
_8.patientspat_ins3_insured_ssn
_8.patients_demographics_snapshotspds_ssn
_8.patients_demographics_snapshotspds_guarantor_ssn
_8.patients_demographics_snapshotspds_ins1_insured_ssn
_8.patients_demographics_snapshotspds_ins2_insured_ssn
_8.patients_demographics_snapshotspds_ins3_insured_ssn
_8.patients_responsibility_estimatesprest_ssn
_8.physiciansphy_ssn_federal_tax_id
_8.precertspre_ssn
_8.precertspre_guarantor_ssn
_8.precertspre_ins1_insured_ssn
_8.precertspre_ins2_insured_ssn
_8.radiology_ordersrad_ssn
_8.radiology_resultsrad_res_ssn
_81.chartschrt_ssn
_81.cpoe_responsescpoe_res_ssn
_81.encountersenc_ssn
_81.encountersenc_guarantor_ssn
_81.encountersenc_ins1_insured_ssn
_81.encountersenc_ins2_insured_ssn
_81.encountersenc_ins3_insured_ssn
_81.examplesexa_ssn
_81.hl7_accessionsacc_ssn
_81.insurances_repositoryirep_ins_insured_ssn
_81.non_patientsnpat_ssn
_81.ordersord_ssn
_81.patientspat_ssn
_81.patientspat_guarantor_ssn
_81.patientspat_ins1_insured_ssn
_81.patientspat_ins2_insured_ssn
_81.patientspat_ins3_insured_ssn
_81.patients_demographics_snapshotspds_ssn
_81.patients_demographics_snapshotspds_guarantor_ssn
_81.patients_demographics_snapshotspds_ins1_insured_ssn
_81.patients_demographics_snapshotspds_ins2_insured_ssn
_81.patients_demographics_snapshotspds_ins3_insured_ssn
_81.patients_responsibility_estimatesprest_ssn
_81.physiciansphy_ssn_federal_tax_id
_81.precertspre_ssn
_81.precertspre_guarantor_ssn
_81.precertspre_ins1_insured_ssn
_81.precertspre_ins2_insured_ssn
_81.radiology_ordersrad_ssn
_81.radiology_resultsrad_res_ssn
_999.chartschrt_ssn
_999.cpoe_responsescpoe_res_ssn
_999.encountersenc_ssn
_999.encountersenc_guarantor_ssn
_999.encountersenc_ins1_insured_ssn
_999.encountersenc_ins2_insured_ssn
_999.encountersenc_ins3_insured_ssn
_999.examplesexa_ssn
_999.hl7_accessionsacc_ssn
_999.insurances_repositoryirep_ins_insured_ssn
_999.non_patientsnpat_ssn
_999.ordersord_ssn
_999.patientspat_ssn
_999.patientspat_guarantor_ssn
_999.patientspat_ins1_insured_ssn
_999.patientspat_ins2_insured_ssn
_999.patientspat_ins3_insured_ssn
_999.patients_demographics_snapshotspds_ssn
_999.patients_demographics_snapshotspds_guarantor_ssn
_999.patients_demographics_snapshotspds_ins1_insured_ssn
_999.patients_demographics_snapshotspds_ins2_insured_ssn
_999.patients_demographics_snapshotspds_ins3_insured_ssn
_999.patients_responsibility_estimatesprest_ssn
_999.physiciansphy_ssn_federal_tax_id
_999.precertspre_ssn
_999.precertspre_guarantor_ssn
_999.precertspre_ins1_insured_ssn
_999.precertspre_ins2_insured_ssn
_999.radiology_ordersrad_ssn
_999.radiology_resultsrad_res_ssn
aurora_standard.abmmpigu_ssn
aurora_standard.abmvisgu_ssn
aurora_standard.adupguguar_ssn
aurora_standard.aswguarguar_ssn
aurora_standard.b2baddp_ssn
aurora_standard.b2mrdrp_ssn
aurora_standard.bdallvispat_ssn
aurora_standard.bdguarguar_ssn
aurora_standard.bdmpip_ssn
aurora_standard.bdmpisp_ssn
aurora_standard.bdvispat_ssn
aurora_standard.bevisp_ssn
aurora_standard.bevisbdp_ssn
aurora_standard.bevisbd2p_ssn
aurora_standard.bharp_ssn
aurora_standard.bharnew_ssn
aurora_standard.bharg_ssn
aurora_standard.bhbaddp_ssn
aurora_standard.bhguarguar_ssn
aurora_standard.bhldgrp_ssn
aurora_standard.bhldgrguar_ssn
aurora_standard.bhmrdrp_ssn
aurora_standard.bhppatp_ssn
aurora_standard.bhtguarguar_ssn
aurora_standard.bhtldgrp_ssn
aurora_standard.bhtldgrguar_ssn
aurora_standard.bhtmrdrp_ssn
aurora_standard.bhtppatp_ssn
aurora_standard.bmguarguar_ssn
aurora_standard.bmmpip_ssn
aurora_standard.bmnkinn_ssn
aurora_standard.bmpactp_ssn
aurora_standard.bmpatp_ssn
aurora_standard.bparp_ssn
aurora_standard.bparnew_ssn
aurora_standard.bparg_ssn
aurora_standard.bpar2p_ssn
aurora_standard.bpar2new_ssn
aurora_standard.bpar2g_ssn
aurora_standard.bpmpip_ssn
aurora_standard.bpmpi2p_ssn
aurora_standard.bpmrp_ssn
aurora_standard.bpmr2p_ssn
aurora_standard.bsguarguar_ssn
aurora_standard.bsinsurspouse_ssn
aurora_standard.bsvispat_ssn
aurora_standard.bsvisbdpat_ssn
aurora_standard.bvguargu_ssn
aurora_standard.bvmpip_ssn
aurora_standard.bvmpi2p_ssn
aurora_standard.c7guarrguar_ssn
aurora_standard.c7mpip_ssn
aurora_standard.c7mpigu_ssn
aurora_standard.c7vispat_ssn
aurora_standard.c8dtlsp_ssn
aurora_standard.c8guarguar_ssn
aurora_standard.c8guar2guar_ssn
aurora_standard.c9mpip_ssn
aurora_standard.c9visp_ssn
aurora_standard.cafcpat_ssn
aurora_standard.caguarrguar_ssn
aurora_standard.campispouse_ssn
aurora_standard.cavispat_ssn
aurora_standard.cavishpat_ssn
aurora_standard.chhl7in2ins_ssn
aurora_standard.chlmdssdprev_ssn
aurora_standard.chltrnsdprev_ssn
aurora_standard.chmarcnbfg_ssn
aurora_standard.chmarcnbfp_ssn
aurora_standard.chmarsipat_ssn
aurora_standard.chmarsigu_ssn
aurora_standard.chmarsisp_ssn
aurora_standard.chmazstdpat_ssn
aurora_standard.chmazstipat_ssn
aurora_standard.chmazstopat_ssn
aurora_standard.chmcampipat_ssn
aurora_standard.chmcampigu_ssn
aurora_standard.chmcampisp_ssn
aurora_standard.chmcmheddebtor_1_ssn
aurora_standard.chmcmheddebtor_2_ssn
aurora_standard.chmcmhedpat_ssn
aurora_standard.chmcssndnew_ssn
aurora_standard.chmcssndold_ssn
aurora_standard.chmexmpipat_ssn
aurora_standard.chmexmpigu_ssn
aurora_standard.chmexmpisp_ssn
aurora_standard.chmexvispat_ssn
aurora_standard.chmguarrguar_ssn
aurora_standard.chmhistpp_ssn
aurora_standard.chmlastrpat_ssn
aurora_standard.chmmhastpat_ssn
aurora_standard.chmokipdpat_ssn
aurora_standard.chmokopdpat_ssn
aurora_standard.chmopercauto_ssn
aurora_standard.chmozpcddebtor_1_ssn
aurora_standard.chmozpcddebtor_2_ssn
aurora_standard.chmpatmrspouse_ssn
aurora_standard.chmpatwcmom_ssn
aurora_standard.chmpatwcdad_ssn
aurora_standard.chmpdemop_ssn
aurora_standard.chmpdemosp_ssn
aurora_standard.chmpdemogu_ssn
aurora_standard.chmradexpat_ssn
aurora_standard.chmradexgu_ssn
aurora_standard.chmradexsp_ssn
aurora_standard.chmtxstrpat_ssn
aurora_standard.chpcobdddep_ssn
aurora_standard.chpdepeddepend_ssn
aurora_standard.chpempddperson_ssn
aurora_standard.chxcntrcid_is_ssn
aurora_standard.hl7gt1guar_ssn
aurora_standard.hl7gt1adguar_ssn
aurora_standard.hl7in2ins_ssn
aurora_standard.hl7in2adins_ssn
aurora_standard.hl7pidpat_ssn
aurora_standard.hl7pidadpat_ssn
aurora_standard.kcvispat_ssn
aurora_standard.kcvisitpat_ssn
aurora_standard.nbspousespouse_ssn
aurora_standard.ncexmpipat_ssn
aurora_standard.oddpayddempl_ssn
aurora_standard.oddpayidempl_ssn
aurora_standard.oddpayodempl_ssn
aurora_standard.oddpayreempl_ssn
aurora_standard.odhpayddempl_ssn
aurora_standard.odhpayidempl_ssn
aurora_standard.odhpayodempl_ssn
aurora_standard.odhpayreempl_ssn
aurora_standard.styoempddepend_ssn
common.customerscus_require_ssn
gender
TableColumn
Azalea.employeesemp_gender
_1.systems_componentsscmp_gender
_1188.systems_componentsscmp_gender
_1218.systems_componentsscmp_gender
_1548.systems_componentsscmp_gender
_435.systems_componentsscmp_gender
_436.systems_componentsscmp_gender
_436_archive_testing.systems_componentsscmp_gender
_437.systems_componentsscmp_gender
_8.systems_componentsscmp_gender
_81.systems_componentsscmp_gender
_999.systems_componentsscmp_gender
aurora_standard.chmclaimpat_gender
template_library.systems_componentsscmp_gender
tax_id
TableColumn
_1.billing_providersbp_federal_tax_id
_1.locationsloc_tax_id
_1.physiciansphy_federal_tax_id
_1188.billing_providersbp_federal_tax_id
_1188.locationsloc_tax_id
_1188.physiciansphy_federal_tax_id
_1218.billing_providersbp_federal_tax_id
_1218.locationsloc_tax_id
_1218.physiciansphy_federal_tax_id
_1548.billing_providersbp_federal_tax_id
_1548.locationsloc_tax_id
_1548.physiciansphy_federal_tax_id
_435.billing_providersbp_federal_tax_id
_435.locationsloc_tax_id
_435.physiciansphy_federal_tax_id
_436.billing_providersbp_federal_tax_id
_436.locationsloc_tax_id
_436.physiciansphy_federal_tax_id
_436_archive_testing.billing_providersbp_federal_tax_id
_436_archive_testing.locationsloc_tax_id
_436_archive_testing.physiciansphy_federal_tax_id
_437.billing_providersbp_federal_tax_id
_437.locationsloc_tax_id
_437.physiciansphy_federal_tax_id
_8.billing_providersbp_federal_tax_id
_8.locationsloc_tax_id
_8.physiciansphy_federal_tax_id
_81.billing_providersbp_federal_tax_id
_81.locationsloc_tax_id
_81.physiciansphy_federal_tax_id
_999.billing_providersbp_federal_tax_id
_999.locationsloc_tax_id
_999.physiciansphy_federal_tax_id
aurora_standard.chmcostafed_tax_id
aurora_standard.chmhid4afed_tax_id
aurora_standard.stpcntrcfederal_tax_id
aurora_standard.stpvendrfederal_tax_id
common.clientscli_federal_tax_id
npi
TableColumn
_1.billing_providersbp_npi
_1.erx_notificationserx_nots_provider_npi
_1.insurances_group_billingigb_use_individual_npi
_1.locationsloc_npi
_1.patients_prescriptionsprx_provider_npi
_1.patients_prescriptionsprx_pharmacy_npi
_1.physiciansphy_npi
_1.physiciansphy_verify_npi
_1188.billing_providersbp_npi
_1188.erx_notificationserx_nots_provider_npi
_1188.insurances_group_billingigb_use_individual_npi
_1188.locationsloc_npi
_1188.patients_prescriptionsprx_provider_npi
_1188.patients_prescriptionsprx_pharmacy_npi
_1188.physiciansphy_npi
_1188.physiciansphy_verify_npi
_1218.billing_providersbp_npi
_1218.erx_notificationserx_nots_provider_npi
_1218.insurances_group_billingigb_use_individual_npi
_1218.locationsloc_npi
_1218.patients_prescriptionsprx_provider_npi
_1218.patients_prescriptionsprx_pharmacy_npi
_1218.physiciansphy_npi
_1218.physiciansphy_verify_npi
_1548.billing_providersbp_npi
_1548.erx_notificationserx_nots_provider_npi
_1548.insurances_group_billingigb_use_individual_npi
_1548.locationsloc_npi
_1548.patients_prescriptionsprx_provider_npi
_1548.patients_prescriptionsprx_pharmacy_npi
_1548.physiciansphy_npi
_1548.physiciansphy_verify_npi
_435.billing_providersbp_npi
_435.erx_notificationserx_nots_provider_npi
_435.insurances_group_billingigb_use_individual_npi
_435.locationsloc_npi
_435.patients_prescriptionsprx_provider_npi
_435.patients_prescriptionsprx_pharmacy_npi
_435.physiciansphy_npi
_435.physiciansphy_verify_npi
_436.billing_providersbp_npi
_436.erx_notificationserx_nots_provider_npi
_436.insurances_group_billingigb_use_individual_npi
_436.locationsloc_npi
_436.patients_prescriptionsprx_provider_npi
_436.patients_prescriptionsprx_pharmacy_npi
_436.physiciansphy_npi
_436.physiciansphy_verify_npi
_436_archive_testing.billing_providersbp_npi
_436_archive_testing.erx_notificationserx_nots_provider_npi
_436_archive_testing.insurances_group_billingigb_use_individual_npi
_436_archive_testing.locationsloc_npi
_436_archive_testing.patients_prescriptionsprx_provider_npi
_436_archive_testing.patients_prescriptionsprx_pharmacy_npi
_436_archive_testing.physiciansphy_npi
_436_archive_testing.physiciansphy_verify_npi
_437.billing_providersbp_npi
_437.erx_notificationserx_nots_provider_npi
_437.insurances_group_billingigb_use_individual_npi
_437.locationsloc_npi
_437.patients_prescriptionsprx_provider_npi
_437.patients_prescriptionsprx_pharmacy_npi
_437.physiciansphy_npi
_437.physiciansphy_verify_npi
_8.billing_providersbp_npi
_8.erx_notificationserx_nots_provider_npi
_8.insurances_group_billingigb_use_individual_npi
_8.locationsloc_npi
_8.patients_prescriptionsprx_provider_npi
_8.patients_prescriptionsprx_pharmacy_npi
_8.physiciansphy_npi
_8.physiciansphy_verify_npi
_81.billing_providersbp_npi
_81.erx_notificationserx_nots_provider_npi
_81.insurances_group_billingigb_use_individual_npi
_81.locationsloc_npi
_81.patients_prescriptionsprx_provider_npi
_81.patients_prescriptionsprx_pharmacy_npi
_81.physiciansphy_npi
_81.physiciansphy_verify_npi
_999.billing_providersbp_npi
_999.erx_notificationserx_nots_provider_npi
_999.insurances_group_billingigb_use_individual_npi
_999.locationsloc_npi
_999.patients_prescriptionsprx_provider_npi
_999.patients_prescriptionsprx_pharmacy_npi
_999.physiciansphy_npi
_999.physiciansphy_verify_npi
aurora_standard.apsphymc_npi
aurora_standard.apsphymd_npi
aurora_standard.chm1500rn_17b_npi
aurora_standard.chm1500rn_32a_npi
aurora_standard.chm1500rn_33a_npi
aurora_standard.chm15chdn24j_npi
aurora_standard.chmarsifam_phy_npi
aurora_standard.chmarsiattend_phy_npi
aurora_standard.chmarsiadmit_phy_npi
aurora_standard.chmarstfacility_npi
aurora_standard.chmarstmedicaid_npi
aurora_standard.chmarstifacility_npi
aurora_standard.chmarstimedicaid_npi
aurora_standard.chmarstphatt_npi
aurora_standard.chmarstphsur_npi
aurora_standard.chmarstpoatt_npi
aurora_standard.chmarstposur_npi
aurora_standard.chmazstdatt_phy_npi
aurora_standard.chmazstdproc_phy_npi
aurora_standard.chmazstdoth_phy_npi
aurora_standard.chmazstiatt_phy_npi
aurora_standard.chmazstiproc_phy_npi
aurora_standard.chmazstioth_phy_npi
aurora_standard.chmazstoatt_phy_npi
aurora_standard.chmazstoproc_phy_npi
aurora_standard.chmazstooth_phy_npi
aurora_standard.chmcampifam_phy_npi
aurora_standard.chmcampiattend_phy_npi
aurora_standard.chmcampiadmit_phy_npi
aurora_standard.chmexmpifam_phy_npi
aurora_standard.chmexmpiattend_phy_npi
aurora_standard.chmexmpiadmit_phy_npi
aurora_standard.chmexvisattend_phy_npi
aurora_standard.chmexvisadmit_phy_npi
aurora_standard.chmhcahpclinic_npi
aurora_standard.chmhcahpdr_npi
aurora_standard.chmhid4afacility_npi
aurora_standard.chmhid4aatt_npi
aurora_standard.chmhid4asur_npi
aurora_standard.chmhid4aother1_qual_npi
aurora_standard.chmhid4aother2_qual_npi
aurora_standard.chmhid4bfacility_npi
aurora_standard.chmhid4cfacility_npi
aurora_standard.chmhid4dfac_npi
aurora_standard.chmhid4gfacility_npi
aurora_standard.chmlastratt_phy_npi
aurora_standard.chmlastrop_phy_npi
aurora_standard.chmlastroth_phy_npi
aurora_standard.chmlastrrnd_phy_npi
aurora_standard.chmlastradm_phy_npi
aurora_standard.chmlastrref_phy_npi
aurora_standard.chmmhastfac_npi
aurora_standard.chmmhastatt_phy_npi
aurora_standard.chmmhastsurg_npi
aurora_standard.chmnvstratt_npi
aurora_standard.chmnvstrop_npi
aurora_standard.chmnvstroth_npi
aurora_standard.chmnvstrothb_npi
aurora_standard.chmp340bprescriber_npi
aurora_standard.chmpdemofam_phy_npi
aurora_standard.chmpdemoattend_phy_npi
aurora_standard.chmpdemoadmit_phy_npi
aurora_standard.chmphynebox_17b_npi
aurora_standard.chmphynebox_24j_npi
aurora_standard.chmphynebox_33a_npi
aurora_standard.chmradedphy_npi
aurora_standard.chmradexfam_phy_npi
aurora_standard.chmradexattend_phy_npi
aurora_standard.chmradexadmit_phy_npi
aurora_standard.chmub04bf_56_npi
aurora_standard.chmub04bf_76_npi
aurora_standard.chmub04bf_77_npi
aurora_standard.chmub04bf_78_npi
aurora_standard.chmub04bf_79_npi
aurora_standard.tmpub04rf_56_npi
aurora_standard.tmpub04rf_76_npi
aurora_standard.tmpub04rf_77_npi
aurora_standard.tmpub04rf_78_npi
aurora_standard.tmpub04rf_79_npi
common.clientscli_npi
common.clientscli_verify_npi
common.reports_filters_options_maprfom_use_npi
race
TableColumn
_1.chartschrt_race
_1.encountersenc_race
_1.orders_afpsoafp_race
_1.patientspat_race
_1.precertspre_race
_1188.chartschrt_race
_1188.encountersenc_race
_1188.orders_afpsoafp_race
_1188.patientspat_race
_1188.precertspre_race
_1218.chartschrt_race
_1218.encountersenc_race
_1218.orders_afpsoafp_race
_1218.patientspat_race
_1218.precertspre_race
_1548.chartschrt_race
_1548.encountersenc_race
_1548.orders_afpsoafp_race
_1548.patientspat_race
_1548.precertspre_race
_435.chartschrt_race
_435.encountersenc_race
_435.orders_afpsoafp_race
_435.patientspat_race
_435.precertspre_race
_436.chartschrt_race
_436.encountersenc_race
_436.orders_afpsoafp_race
_436.patientspat_race
_436.precertspre_race
_436_archive_testing.chartschrt_race
_436_archive_testing.encountersenc_race
_436_archive_testing.orders_afpsoafp_race
_436_archive_testing.patientspat_race
_436_archive_testing.precertspre_race
_437.chartschrt_race
_437.encountersenc_race
_437.orders_afpsoafp_race
_437.patientspat_race
_437.precertspre_race
_8.chartschrt_race
_8.encountersenc_race
_8.orders_afpsoafp_race
_8.patientspat_race
_8.precertspre_race
_81.chartschrt_race
_81.encountersenc_race
_81.orders_afpsoafp_race
_81.patientspat_race
_81.precertspre_race
_999.chartschrt_race
_999.encountersenc_race
_999.orders_afpsoafp_race
_999.patientspat_race
_999.precertspre_race
aurora_standard.bharp_race
aurora_standard.bharg_race
aurora_standard.bhguarg_race
aurora_standard.bhtguarg_race
aurora_standard.bparp_race
aurora_standard.bparg_race
aurora_standard.bpar2p_race
aurora_standard.bpar2g_race
aurora_standard.bpmpip_race
aurora_standard.bpmpi2p_race
aurora_standard.chmazstdpat_race
aurora_standard.chmazstipat_race
aurora_standard.chmazstopat_race
aurora_standard.chmhistpp_race
aurora_standard.chmlastrpat_race
aurora_standard.chmmhastpat_race
aurora_standard.chmokipdpat_race
aurora_standard.chmokopdpat_race
aurora_standard.chmtxstrpat_race
aurora_standard.hl7gt1guar_race
aurora_standard.tmpmrrptsex_race
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
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
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
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
adm_src
TableColumn
aurora_standard.chmstatcdef_adm_src
adm_typ
TableColumn
aurora_standard.chmstatcdef_adm_typ
acc_st
TableColumn
aurora_standard.chmub04rf_29_acc_st
aurora_standard.tmpub04rf_29_acc_st
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