_435.sliding_fee_scales

Field	Type	Null	Default	Key	Extra	Comment
sfs_id	int(11)	NO		PRI	auto_increment
sfs_cus_id	int(11)	NO		MUL		Customer Id
sfs_cli_id	int(11)	NO		MUL		Client Id
sfs_name	varchar(50)	NO		UNI		User Friendly Name
sfs_bil_id	int(11)	NO				Billing Code ID
sfs_disabled	char(1)	NO				Disabled
sfs_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
sfs_created	timestamp	YES	CURRENT_TIMESTAMP
sfs_expiration_date_diff	varchar(8)	NO				Ymd format date diff. Matched against patient income verification date

References

Local Column

References

sfs_id

Table	Column
_1.encounters	enc_sfs_id
_1.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_1.sliding_fee_scale_codes	sfsc_sfs_id
_1188.encounters	enc_sfs_id
_1188.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_1188.sliding_fee_scale_codes	sfsc_sfs_id
_1218.encounters	enc_sfs_id
_1218.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_1218.sliding_fee_scale_codes	sfsc_sfs_id
_1548.encounters	enc_sfs_id
_1548.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_1548.sliding_fee_scale_codes	sfsc_sfs_id
_435.encounters	enc_sfs_id
_435.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_435.sliding_fee_scale_codes	sfsc_sfs_id
_436.encounters	enc_sfs_id
_436.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_436.sliding_fee_scale_codes	sfsc_sfs_id
_436_archive_testing.encounters	enc_sfs_id
_436_archive_testing.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_436_archive_testing.sliding_fee_scale_codes	sfsc_sfs_id
_437.encounters	enc_sfs_id
_437.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_437.sliding_fee_scale_codes	sfsc_sfs_id
_8.encounters	enc_sfs_id
_8.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_8.sliding_fee_scale_codes	sfsc_sfs_id
_81.encounters	enc_sfs_id
_81.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_81.sliding_fee_scale_codes	sfsc_sfs_id
_999.encounters	enc_sfs_id
_999.sliding_fee_scale_breakpoint_values	sfsbv_sfs_id
_999.sliding_fee_scale_codes	sfsc_sfs_id