aurora_standard.cadrg

Field	Type	Null	Key
stupid_no	varchar(20)	YES
vis_no	int(11)	YES	MUL
mr_no	varchar(20)	YES	MUL
evo_no	varchar(20)	YES
abs_status	varchar(6)	YES
drg	varchar(3)	YES
drg_desc	varchar(30)	YES
mdc	varchar(3)	YES
mdc_desc	varchar(30)	YES
drg_reimb	decimal(16,2)	YES
deduct	decimal(16,2)	YES
outl	decimal(16,2)	YES
weight	decimal(10,4)	YES
p_rate	decimal(16,2)	YES
tdsh	decimal(16,2)	YES
c_by	varchar(6)	YES
c_date	varchar(10)	YES
ch_by	varchar(2)	YES
ch_on	varchar(2)	YES
drglos	varchar(2)	YES

References

Local Column

References

drg

Table	Column
Icd.apr_drg_codes	apr_drg_desc
aurora_standard.abshl7d	i9_drg
aurora_standard.chmabstr	est_drg
aurora_standard.chmabstr	actual_drg
aurora_standard.chmclaim	fin_drg
aurora_standard.chmclaim	ms_drg
aurora_standard.chmcosta	ms_drg
aurora_standard.chmhidia	est_drg
aurora_standard.chmpresg	ms_drg
aurora_standard.chmpresg2	ms_drg
aurora_standard.chmvtotd	est_drg
aurora_standard.drg_work	w_drg
aurora_standard.logdetld	est_drg
aurora_standard.ohocpt	cpt_drg
aurora_standard.workdesc	w_drg

deduct

Table	Column
_1.encounters_payments_edi_logs	epel_deduct
_1188.encounters_payments_edi_logs	epel_deduct
_1218.encounters_payments_edi_logs	epel_deduct
_1548.encounters_payments_edi_logs	epel_deduct
_435.encounters_payments_edi_logs	epel_deduct
_437.encounters_payments_edi_logs	epel_deduct
_8.encounters_payments_edi_logs	epel_deduct
_81.encounters_payments_edi_logs	epel_deduct
_999.encounters_payments_edi_logs	epel_deduct
aurora_standard.chhl7in1	policy_deduct
aurora_standard.chhl7in2	blood_deduct
aurora_standard.hl7in1	policy_deduct
aurora_standard.hl7in1ad	policy_deduct
aurora_standard.hl7in2	blood_deduct
aurora_standard.hl7in2ad	blood_deduct

weight

Table	Column
_1.encounters_soap_vitals	espv_weight
_1.orders_afps	oafp_weight
_1.patients_vitals	pvs_weight
_1188.encounters_soap_vitals	espv_weight
_1188.orders_afps	oafp_weight
_1188.patients_vitals	pvs_weight
_1218.encounters_soap_vitals	espv_weight
_1218.orders_afps	oafp_weight
_1218.patients_vitals	pvs_weight
_1548.encounters_soap_vitals	espv_weight
_1548.orders_afps	oafp_weight
_1548.patients_vitals	pvs_weight
_435.encounters_soap_vitals	espv_weight
_435.orders_afps	oafp_weight
_435.patients_vitals	pvs_weight
_436.encounters_soap_vitals	espv_weight
_436.orders_afps	oafp_weight
_436.patients_vitals	pvs_weight
_436_archive_testing.encounters_soap_vitals	espv_weight
_436_archive_testing.orders_afps	oafp_weight
_436_archive_testing.patients_vitals	pvs_weight
_437.encounters_soap_vitals	espv_weight
_437.orders_afps	oafp_weight
_437.patients_vitals	pvs_weight
_8.encounters_soap_vitals	espv_weight
_8.orders_afps	oafp_weight
_8.patients_vitals	pvs_weight
_81.encounters_soap_vitals	espv_weight
_81.orders_afps	oafp_weight
_81.patients_vitals	pvs_weight
_999.encounters_soap_vitals	espv_weight
_999.orders_afps	oafp_weight
_999.patients_vitals	pvs_weight
aurora_standard.chmarsthi	b_weight
aurora_standard.chmdrgcc	rel_weight
aurora_standard.chxhistr	h_weight
aurora_standard.orders	ship_weight
aurora_standard.stoinvce	ship_weight
aurora_standard.stoordrd	ship_weight
aurora_standard.stoordre	ship_weight
aurora_standard.stoshipd	ship_weight
aurora_standard.stuordre	total_weight
aurora_standard.workdrg	rel_weight
common.encounters_statuses	ess_weight
common.precerts_statuses	pss_weight
common.precerts_statuses	ps_weight

c_date

Table	Column
_1.encounters_ub04	enc_ub04_74_c_date
_1188.encounters_ub04	enc_ub04_74_c_date
_1218.encounters_ub04	enc_ub04_74_c_date
_1548.encounters_ub04	enc_ub04_74_c_date
_435.encounters_ub04	enc_ub04_74_c_date
_436.encounters_ub04	enc_ub04_74_c_date
_436_archive_testing.encounters_ub04	enc_ub04_74_c_date
_437.encounters_ub04	enc_ub04_74_c_date
_8.encounters_ub04	enc_ub04_74_c_date
_81.encounters_ub04	enc_ub04_74_c_date
_999.encounters_ub04	enc_ub04_74_c_date

mdc

Table	Column
aurora_standard.abshl7d	i9_mdc
aurora_standard.chmabstr	est_mdc
aurora_standard.chmabstr	actual_mdc

vis_no

Table	Column
aurora_standard.bmvis	moms_vis_no

mr_no

Table	Column
aurora_standard.bsinsur	snf_mr_no
aurora_standard.bsinsur	prev_mr_no
aurora_standard.chhcntrc	auto_snf_mr_no
aurora_standard.chhcntrc	auto_mr_no
aurora_standard.chmarbex	pat_mr_no
aurora_standard.chmarsi	pat_mr_no
aurora_standard.chmbatex	pat_mr_no
aurora_standard.chmcampi	pat_mr_no
aurora_standard.chmcntrc	auto_snf_mr_no
aurora_standard.chmcntrc	auto_mr_no
aurora_standard.chmexmpi	pat_mr_no
aurora_standard.chmhstmr	pat_mr_no
aurora_standard.chmhstrm	pat_mr_no
aurora_standard.chmlastr	mother_mr_no
aurora_standard.chmmhast	co_mr_no
aurora_standard.chmmrhdr	upd_mr_no
aurora_standard.chmnrcex	pat_mr_no
aurora_standard.chmokipd	pat_mr_no
aurora_standard.chmokopd	pat_mr_no
aurora_standard.chmpatmr	snf_mr_no
aurora_standard.chmpatmr	prev_mr_no
aurora_standard.chmraded	pat_mr_no
aurora_standard.chmradex	pat_mr_no
aurora_standard.chmreqsr	ofc_mr_no
aurora_standard.ncexmpi	pat_mr_no