aurora_standard.logdetld

Field	Type	Null	Default	Key	Extra	Comment
visit_no	int(11)	YES		MUL
dischg_date	date	YES
admit_date	date	YES
remit_date	date	YES
last_name	varchar(15)	YES
first_name	varchar(15)	YES
mid_name	varchar(10)	YES
pat_status	varchar(3)	YES
est_drg	decimal(10,2)	YES
reimburs_amt	decimal(10,2)	YES
adjust_amt	decimal(10,2)	YES
drg_amt	decimal(10,2)	YES
co_insurance	decimal(10,2)	YES
non_covered	decimal(10,2)	YES
deductible	decimal(10,2)	YES
covered_days	smallint(6)	YES
outlier_amt	decimal(10,2)	YES
lab_payment	decimal(10,2)	YES
lab_non_allow	decimal(10,2)	YES
lab_not_hcpc	decimal(10,2)	YES
other_payor_paid	decimal(10,2)	YES
pat_resp_room	decimal(10,2)	YES
other_amt	decimal(10,2)	YES
non_cov_days	smallint(6)	YES
acct_period	smallint(6)	YES
acct_year	varchar(4)	YES
tot_billed	decimal(10,2)	YES
tot_1500_amt	decimal(10,2)	YES
ub_amt	decimal(10,2)	YES
los	smallint(6)	YES
which_log	varchar(2)	YES
mhb	decimal(10,2)	YES
mmap	decimal(10,2)	YES
processing_date	date	YES		MUL
remit_id	varchar(10)	YES		MUL
bill_id	varchar(3)	YES
lock_remit	varchar(1)	YES
fac_no	varchar(3)	YES
drg_no	smallint(6)	YES
remit_type	varchar(4)	YES
add_charges	varchar(1)	YES
chs_rowID	bigint(20) unsigned	NO		PRI	auto_increment

References

Local Column

References

deductible

Table	Column
_1.patients_responsibility_estimates	prest_deductible
_1.patients_responsibility_estimates_services	prests_deductible
_1188.patients_responsibility_estimates	prest_deductible
_1188.patients_responsibility_estimates_services	prests_deductible
_1218.patients_responsibility_estimates	prest_deductible
_1218.patients_responsibility_estimates_services	prests_deductible
_1548.patients_responsibility_estimates	prest_deductible
_1548.patients_responsibility_estimates_services	prests_deductible
_435.patients_responsibility_estimates	prest_deductible
_435.patients_responsibility_estimates_services	prests_deductible
_436.patients_responsibility_estimates	prest_deductible
_436.patients_responsibility_estimates_services	prests_deductible
_436_archive_testing.patients_responsibility_estimates	prest_deductible
_436_archive_testing.patients_responsibility_estimates_services	prests_deductible
_437.patients_responsibility_estimates	prest_deductible
_437.patients_responsibility_estimates_services	prests_deductible
_8.patients_responsibility_estimates	prest_deductible
_8.patients_responsibility_estimates_services	prests_deductible
_81.patients_responsibility_estimates	prest_deductible
_81.patients_responsibility_estimates_services	prests_deductible
_999.patients_responsibility_estimates	prest_deductible
_999.patients_responsibility_estimates_services	prests_deductible
aurora_standard.chminsrd	def_deductible
aurora_standard.chpinsuc	dep_deductible
aurora_standard.hl7in2	daily_deductible

visit_no

Table	Column
aurora_standard.anotesd	an_visit_no
aurora_standard.bdfiled	bd_visit_no
aurora_standard.chmarsi	pat_visit_no
aurora_standard.chmcampi	pat_visit_no
aurora_standard.chmcombr	to_visit_no
aurora_standard.chmexmpi	pat_visit_no
aurora_standard.chmokipd	pat_visit_no
aurora_standard.chmokopd	pat_visit_no
aurora_standard.chmraded	pat_visit_no
aurora_standard.chmradex	pat_visit_no
aurora_standard.chrcombr	to_visit_no
aurora_standard.ncexmpi	pat_visit_no

last_name

Table	Column
aurora_standard.c7insur2	p_last_name
aurora_standard.c7insur3	p_last_name
aurora_standard.chm1500r	pat_last_name
aurora_standard.chmcmhed	pat_last_name
aurora_standard.chmstmtd	g_last_name

first_name

Table	Column
aurora_standard.c7insur2	p_first_name
aurora_standard.c7insur3	p_first_name
aurora_standard.chm1500r	pat_first_name
aurora_standard.chmcmhed	pat_first_name
aurora_standard.chmstmtd	g_first_name

mid_name

Table	Column
aurora_standard.c7insur2	p_mid_name
aurora_standard.c7insur3	p_mid_name
aurora_standard.chmstmtd	g_mid_name

outlier_amt

Table	Column
aurora_standard.chm835pd	pps_outlier_amt

los

Table	Column
aurora_standard.chmabstr	mean_los
aurora_standard.chmdrgcc	mean_los
aurora_standard.chmmhast	outlier_los
aurora_standard.workdrg	mean_los

admit_date

Table	Column
aurora_standard.chmadmtr	last_admit_date
aurora_standard.hhmadmtr	last_admit_date
aurora_standard.hl7pv2	expect_admit_date

dischg_date

Table	Column
aurora_standard.chmchddd	old_dischg_date
aurora_standard.chmchddd	new_dischg_date
aurora_standard.chmchpsd	chg_dischg_date
aurora_standard.hl7pv2	exp_dischg_date
aurora_standard.tmpmrrpt	edit_dischg_date

pat_status

Table	Column
aurora_standard.chmgltcd	a_pat_status
aurora_standard.chmgltcd	b_pat_status
aurora_standard.chmprica	prev_pat_status
aurora_standard.chmprica	cur_pat_status

fac_no

Table	Column
aurora_standard.chmprica	prev_fac_no
aurora_standard.chmprica	cur_fac_no
aurora_standard.chpcashr	cash_fac_no
aurora_standard.chpcobpd	cash_fac_no
aurora_standard.chpcobpd	bal_fac_no
aurora_standard.chscustd	dept_fac_no
aurora_standard.chshotlr	dept_fac_no
aurora_standard.chtemplr	dflt_fac_no
aurora_standard.curs_temp	cash_fac_no
aurora_standard.curs_temp	ap_fac_no
aurora_standard.stgrowpd	rod_beg_fac_no
aurora_standard.stgrowpd	rod_end_fac_no
aurora_standard.stpcashd	dist_fac_no
aurora_standard.stpcashd	disc_fac_no
aurora_standard.stpcashe	cash_fac_no
aurora_standard.stpcntrc	cash_fac_no
aurora_standard.stpcntrc	disc_fac_no
aurora_standard.stpinvce	cash_fac_no
aurora_standard.stpopend	ap_fac_no
aurora_standard.stpopend	cash_fac_no
aurora_standard.stucntrc	cash_fac_no
aurora_standard.stuinvce	cash_fac_no
aurora_standard.stxfinsd	fin_fac_no
aurora_standard.styaccrr	liab_fac_no
aurora_standard.styaccrr	expense_fac_no
aurora_standard.styemplr	cash_fac_no
aurora_standard.stypayfd	cash_fac_no
aurora_standard.stypayod	bal_fac_no
aurora_standard.stypayre	cash_fac_no
aurora_standard.styrevsd	cash_fac_no
aurora_standard.stytyper	cash_fac_no