_436_archive_testing.clients_fee_schedules_map

Field Type Null Default Key Extra Comment
cfsm_id int(11) NO PRI auto_increment
cfsm_cus_id int(11) NO MUL
cfsm_cli_id int(11) NO MUL
cfsm_cfs_id int(11) NO MUL
cfsm_cpt_id int(11) NO MUL
cfsm_revc_id int(11) NO MUL
cfsm_rev_code varchar(4) NO
cfsm_modifier varchar(2) NO
cfsm_modifier2 varchar(2) NO
cfsm_modifier3 varchar(2) NO
cfsm_modifier4 varchar(2) NO
cfsm_num_units varchar(5) NO
cfsm_no_unit_multiply char(1) NO
cfsm_ndc_code varchar(30) NO
cfsm_ndc_unit_count varchar(10) NO
cfsm_ndc_units_of_measure varchar(2) NO
cfsm_noc varchar(80) YES
cfsm_rvu_work float NO 0
cfsm_cpt_code varchar(15) NO
cfsm_cpt_desc varchar(40) NO
cfsm_price varchar(10) NO
cfsm_price_self_pay varchar(10) NO
cfsm_ub04 char(1) NO 0
cfsm_global_indicator char(1) NO 0 MUL Flags this cpt as start of global period
cfsm_global_days int(11) NO 0 MUL Number of Days global period affects
cfsm_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
cfsm_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
cfsm_id
TableColumn
_1.insurances_allowed_amountsiam_cfsm_id
_1188.insurances_allowed_amountsiam_cfsm_id
_1218.insurances_allowed_amountsiam_cfsm_id
_1548.insurances_allowed_amountsiam_cfsm_id
_435.insurances_allowed_amountsiam_cfsm_id
_436.insurances_allowed_amountsiam_cfsm_id
_436_archive_testing.insurances_allowed_amountsiam_cfsm_id
_437.insurances_allowed_amountsiam_cfsm_id
_8.insurances_allowed_amountsiam_cfsm_id
_81.insurances_allowed_amountsiam_cfsm_id
_999.insurances_allowed_amountsiam_cfsm_id