You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
92 lines
4.1 KiB
92 lines
4.1 KiB
2 years ago
|
#IfMissingColumn form_misc_billing_options replacement_claim
|
||
|
|
ALTER TABLE form_misc_billing_options
|
||
|
|
ADD replacement_claim tinyint(1) DEFAULT 0;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn insurance_data accept_assignment
|
||
|
|
ALTER TABLE insurance_data
|
||
|
|
ADD accept_assignment varchar(5) NOT NULL DEFAULT 'TRUE';
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn forms deleted
|
||
|
|
ALTER TABLE forms
|
||
|
|
ADD deleted TINYINT DEFAULT '0' NOT NULL COMMENT 'flag indicates form has been deleted';
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn immunizations vis_date
|
||
|
|
ALTER TABLE immunizations
|
||
|
|
ADD `vis_date` date default NULL COMMENT 'Date of VIS Statement',
|
||
|
|
ADD `administered_by` VARCHAR( 255 ) default NULL COMMENT 'Alternative to administered_by_id';
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotTable chart_tracker
|
||
|
|
CREATE TABLE chart_tracker (
|
||
|
|
ct_pid int(11) NOT NULL,
|
||
|
|
ct_when datetime NOT NULL,
|
||
|
|
ct_userid bigint(20) NOT NULL DEFAULT 0,
|
||
|
|
ct_location varchar(31) NOT NULL DEFAULT '',
|
||
|
|
PRIMARY KEY (ct_pid, ct_when)
|
||
|
|
) ENGINE=MyISAM;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotRow list_options list_id chartloc
|
||
|
|
INSERT INTO list_options VALUES ('lists' ,'chartloc','Chart Storage Locations',1,0,0);
|
||
|
|
INSERT INTO list_options VALUES ('chartloc','fileroom','File Room' ,1,0,0);
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn form_encounter last_level_billed
|
||
|
|
ALTER TABLE form_encounter
|
||
|
|
ADD last_level_billed int NOT NULL DEFAULT 0 COMMENT '0=none, 1=ins1, 2=ins2, etc',
|
||
|
|
ADD last_level_closed int NOT NULL DEFAULT 0 COMMENT '0=none, 1=ins1, 2=ins2, etc',
|
||
|
|
ADD last_stmt_date date DEFAULT NULL,
|
||
|
|
ADD stmt_count int NOT NULL DEFAULT 0;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotTable ar_session
|
||
|
|
CREATE TABLE ar_session (
|
||
|
|
session_id int unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
payer_id int(11) NOT NULL COMMENT '0=pt else references insurance_companies.id',
|
||
|
|
user_id int(11) NOT NULL COMMENT 'references users.id for session owner',
|
||
|
|
closed tinyint(1) NOT NULL DEFAULT 0 COMMENT '0=no, 1=yes',
|
||
|
|
reference varchar(255) NOT NULL DEFAULT '' COMMENT 'check or EOB number',
|
||
|
|
check_date date DEFAULT NULL,
|
||
|
|
deposit_date date DEFAULT NULL,
|
||
|
|
pay_total decimal(12,2) NOT NULL DEFAULT 0,
|
||
|
|
PRIMARY KEY (session_id),
|
||
|
|
KEY user_closed (user_id, closed),
|
||
|
|
KEY deposit_date (deposit_date)
|
||
|
|
) ENGINE=MyISAM;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotTable ar_activity
|
||
|
|
CREATE TABLE ar_activity (
|
||
|
|
pid int(11) NOT NULL,
|
||
|
|
encounter int(11) NOT NULL,
|
||
|
|
sequence_no int unsigned NOT NULL AUTO_INCREMENT,
|
||
|
|
code varchar(9) NOT NULL COMMENT 'empty means claim level',
|
||
|
|
modifier varchar(5) NOT NULL DEFAULT '',
|
||
|
|
payer_type int NOT NULL COMMENT '0=pt, 1=ins1, 2=ins2, etc',
|
||
|
|
post_time datetime NOT NULL,
|
||
|
|
post_user int(11) NOT NULL COMMENT 'references users.id',
|
||
|
|
session_id int unsigned NOT NULL COMMENT 'references ar_session.session_id',
|
||
|
|
memo varchar(255) NOT NULL DEFAULT '' COMMENT 'adjustment reasons go here',
|
||
|
|
pay_amount decimal(12,2) NOT NULL DEFAULT 0 COMMENT 'either pay or adj will always be 0',
|
||
|
|
adj_amount decimal(12,2) NOT NULL DEFAULT 0,
|
||
|
|
PRIMARY KEY (pid, encounter, sequence_no),
|
||
|
|
KEY session_id (session_id)
|
||
|
|
) ENGINE=MyISAM;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn users ssi_relayhealth
|
||
|
|
ALTER TABLE users
|
||
|
|
ADD ssi_relayhealth varchar(64) NULL;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
update layout_options set group_name = concat('1', substring(group_name, 2)) where group_name like 'a%';
|
||
|
|
update layout_options set group_name = concat('2', substring(group_name, 2)) where group_name like 'b%';
|
||
|
|
update layout_options set group_name = concat('3', substring(group_name, 2)) where group_name like 'c%';
|
||
|
|
update layout_options set group_name = concat('4', substring(group_name, 2)) where group_name like 'd%';
|
||
|
|
update layout_options set group_name = concat('5', substring(group_name, 2)) where group_name like 'e%';
|
||
|
|
update layout_options set group_name = concat('6', substring(group_name, 2)) where group_name like 'f%';
|
||
|
|
update layout_options set group_name = concat('7', substring(group_name, 2)) where group_name like 'g%';
|