_436_archive_testing.ledger

Field	Type	Null	Default	Key	Extra	Comment
led_id	int(11)	NO		PRI	auto_increment
led_cus_id	int(11)	NO		MUL
led_cli_id	int(11)	NO		MUL
led_usr_id	int(11)	NO		MUL
led_pat_id	int(11)	NO		MUL
led_enc_id	int(11)	NO		MUL
led_bil_id	int(11)	NO		MUL
led_ecp_id	int(11)	NO		MUL
led_apply_to_ecp_id	int(11)	NO		MUL
led_ins_id	int(11)	NO		MUL
led_ebat_id	int(11)	NO		MUL
led_epay_id	int(11)	NO		MUL
led_epel_id	int(11)	YES		MUL		Encounters Payment Grouping ID#
led_carc_id	int(11)	NO		MUL
led_group_code	varchar(2)	NO
led_pmt_led_id	int(11)	NO
led_clp_id	int(11)	NO		MUL
led_clpd_id	int(11)	NO		MUL
led_date	varchar(8)	NO		MUL
led_aging_insurance	int(10)	NO
led_aging_patient	int(10)	NO
led_led_id	int(11)	NO		MUL
led_amount	decimal(10,2)	YES		MUL		Currency amount
led_orig_amount	decimal(10,2)	YES				Original currency amount for unapplied payments
led_loc_id	int(11)	NO
led_phy_id	int(11)	NO	0	MUL		Physician column
led_unit_amount	decimal(10,2)	YES				Related to encounter cpt unit count
led_note	text	NO
led_override_primary	tinyint(1)	NO	0	MUL
led_override_secondary	tinyint(1)	NO	0	MUL
led_override_tertiary	tinyint(1)	NO	0	MUL
led_complete	tinyint(1)	NO	0
led_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
led_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

led_id

Table	Column
_1.audits	aud_led_id
_1.audits_archive	aud_led_id
_1.encounters_cpt_codes	ecp_reverse_led_id
_1.encounters_cpt_denials	ecd_pmt_led_id
_1.encounters_edi_errors	eep_led_id
_1.ledger_unapplied_payments	lup_led_id
_1.patients_payments_ledger_map	pplm_led_id
_1.voided_payments	vp_led_id
_1188.audits	aud_led_id
_1188.audits_archive	aud_led_id
_1188.encounters_cpt_denials	ecd_pmt_led_id
_1188.encounters_edi_errors	eep_led_id
_1188.encounters_payments_groupings	epg_pmt_led_id
_1188.ledger_unapplied_payments	lup_led_id
_1188.patients_payments_ledger_map	pplm_led_id
_1188.voided_payments	vp_led_id
_1218.audits	aud_led_id
_1218.audits_archive	aud_led_id
_1218.encounters_cpt_codes	ecp_reverse_led_id
_1218.encounters_cpt_denials	ecd_pmt_led_id
_1218.encounters_edi_errors	eep_led_id
_1218.encounters_payments_groupings	epg_pmt_led_id
_1218.led_temporary_ledger_table_ANM	led_pmt_led_id
_1218.led_temporary_ledger_table_ANM	led_led_id
_1218.ledger_unapplied_payments	lup_led_id
_1218.patients_payments_ledger_map	pplm_led_id
_1218.voided_payments	vp_led_id
_1548.audits	aud_led_id
_1548.audits_archive	aud_led_id
_1548.encounters_cpt_codes	ecp_reverse_led_id
_1548.encounters_cpt_denials	ecd_pmt_led_id
_1548.encounters_edi_errors	eep_led_id
_1548.ledger_unapplied_payments	lup_led_id
_1548.patients_payments_ledger_map	pplm_led_id
_1548.voided_payments	vp_led_id
_435.audits	aud_led_id
_435.audits_archive	aud_led_id
_435.encounters_cpt_codes	ecp_reverse_led_id
_435.encounters_cpt_denials	ecd_pmt_led_id
_435.encounters_edi_errors	eep_led_id
_435.encounters_payments_groupings	epg_pmt_led_id
_435.ledger_running_balance	lrb_led_id
_435.ledger_unapplied_payments	lup_led_id
_435.patients_payments_ledger_map	pplm_led_id
_435.voided_payments	vp_led_id
_436.audits	aud_led_id
_436.audits_archive	aud_led_id
_436.encounters_cpt_codes	ecp_reverse_led_id
_436.encounters_cpt_denials	ecd_pmt_led_id
_436.encounters_edi_errors	eep_led_id
_436.encounters_payments_groupings	epg_pmt_led_id
_436.ledger_running_balance	lrb_led_id
_436.ledger_unapplied_payments	lup_led_id
_436.patients_payments_ledger_map	pplm_led_id
_436.voided_payments	vp_led_id
_436_archive_testing.audits	aud_led_id
_436_archive_testing.audits_archive	aud_led_id
_436_archive_testing.encounters_cpt_codes	ecp_reverse_led_id
_436_archive_testing.encounters_cpt_denials	ecd_pmt_led_id
_436_archive_testing.encounters_edi_errors	eep_led_id
_436_archive_testing.encounters_payments_groupings	epg_pmt_led_id
_436_archive_testing.ledger_running_balance	lrb_led_id
_436_archive_testing.ledger_unapplied_payments	lup_led_id
_436_archive_testing.patients_payments_ledger_map	pplm_led_id
_436_archive_testing.voided_payments	vp_led_id
_437.audits	aud_led_id
_437.audits_archive	aud_led_id
_437.encounters_cpt_codes	ecp_reverse_led_id
_437.encounters_cpt_denials	ecd_pmt_led_id
_437.encounters_edi_errors	eep_led_id
_437.encounters_payments_groupings	epg_pmt_led_id
_437.ledger_running_balance	lrb_led_id
_437.ledger_unapplied_payments	lup_led_id
_437.patients_payments_ledger_map	pplm_led_id
_437.voided_payments	vp_led_id
_8.audits	aud_led_id
_8.audits_archive	aud_led_id
_8.daily_close_calculations	dcc_led_id
_8.encounters_cpt_codes	ecp_reverse_led_id
_8.encounters_cpt_denials	ecd_pmt_led_id
_8.encounters_edi_errors	eep_led_id
_8.ledger_unapplied_payments	lup_led_id
_8.patients_payments_ledger_map	pplm_led_id
_8.voided_payments	vp_led_id
_81.audits	aud_led_id
_81.audits_archive	aud_led_id
_81.encounters_cpt_codes	ecp_reverse_led_id
_81.encounters_cpt_denials	ecd_pmt_led_id
_81.encounters_edi_errors	eep_led_id
_81.encounters_payments_groupings	epg_pmt_led_id
_81.ledger_unapplied_payments	lup_led_id
_81.patients_payments_ledger_map	pplm_led_id
_81.voided_payments	vp_led_id
_999.audits	aud_led_id
_999.audits_archive	aud_led_id
_999.encounters_cpt_codes	ecp_reverse_led_id
_999.encounters_cpt_denials	ecd_pmt_led_id
_999.encounters_edi_errors	eep_led_id
_999.ledger_unapplied_payments	lup_led_id
_999.patients_payments_ledger_map	pplm_led_id
_999.voided_payments	vp_led_id

led_led_id

Table	Column
_8.daily_close_calculations	dcc_led_led_id

led_date

Table	Column
_8.daily_close_calculations	dcc_led_date

led_amount

Table	Column
_8.daily_close_calculations	dcc_led_amount

led_orig_amount

Table	Column
_8.daily_close_calculations	dcc_led_orig_amount

led_note

Table	Column
_8.daily_close_calculations	dcc_led_note

led_created

Table	Column
_8.daily_close_calculations	dcc_led_created