1 CREATE TABLE IF NOT EXISTS `form_misc_billing_options` (
2 id bigint(20) NOT NULL auto_increment,
3 date datetime default NULL,
4 pid bigint(20) default NULL,
5 user varchar(255) default NULL,
6 groupname varchar(255) default NULL,
7 authorized tinyint(4) default NULL,
8 activity tinyint(4) default NULL,
9 employment_related tinyint(1) default NULL,
10 auto_accident tinyint(1) default NULL,
11 accident_state varchar(2) default NULL,
12 other_accident tinyint(1) default NULL,
13 medicaid_referral_code varchar(2) default NULL,
14 epsdt_flag tinyint(1) default NULL,
15 provider_qualifier_code varchar(2) default NULL,
16 provider_id int(11) default NULL,
17 outside_lab tinyint(1) default NULL,
18 lab_amount decimal(5,2) default NULL,
19 is_unable_to_work tinyint(1) default NULL,
20 date_initial_treatment date default NULL,
21 off_work_from date default NULL,
22 off_work_to date default NULL,
23 is_hospitalized tinyint(1) default NULL,
24 hospitalization_date_from date default NULL,
25 hospitalization_date_to date default NULL,
26 medicaid_resubmission_code varchar(10) default NULL,
27 medicaid_original_reference varchar(15) default NULL,
28 prior_auth_number varchar(20) default NULL,
29 comments varchar(255) default NULL,
30 replacement_claim tinyint(1) default 0,
31 icn_resubmission_number varchar(35) default NULL,
32 box_14_date_qual char(3) default NULL,
33 box_15_date_qual char(3) default NULL,