From 2b8568a9c565c4bf48140581a66e3ac69a4529a1 Mon Sep 17 00:00:00 2001 From: bradymiller Date: Thu, 17 Jan 2013 18:24:47 -0800 Subject: [PATCH] Support for larger size codes (such as SNOMED US Extension codes) --- sql/4_1_1-to-4_1_2_upgrade.sql | 8 ++++++++ sql/database.sql | 4 ++-- version.php | 2 +- 3 files changed, 11 insertions(+), 3 deletions(-) diff --git a/sql/4_1_1-to-4_1_2_upgrade.sql b/sql/4_1_1-to-4_1_2_upgrade.sql index 077f58ba0..bd136ba5a 100644 --- a/sql/4_1_1-to-4_1_2_upgrade.sql +++ b/sql/4_1_1-to-4_1_2_upgrade.sql @@ -120,3 +120,11 @@ DROP TABLE `temp_table_one`; ALTER TABLE `codes` CHANGE `code` `code` varchar(25) NOT NULL default ''; #EndIf +#IfNotColumnType billing code varchar(20) +ALTER TABLE `billing` CHANGE `code` `code` varchar(20) default NULL; +#EndIf + +#IfNotColumnType ar_activity code varchar(20) +ALTER TABLE `ar_activity` CHANGE `code` `code` varchar(20) NOT NULL COMMENT 'empty means claim level'; +#EndIf + diff --git a/sql/database.sql b/sql/database.sql index 9e04b7e20..cedf3ab39 100644 --- a/sql/database.sql +++ b/sql/database.sql @@ -113,7 +113,7 @@ CREATE TABLE `billing` ( `id` int(11) NOT NULL auto_increment, `date` datetime default NULL, `code_type` varchar(15) default NULL, - `code` varchar(9) default NULL, + `code` varchar(20) default NULL, `pid` int(11) default NULL, `provider_id` int(11) default NULL, `user` int(11) default NULL, @@ -5291,7 +5291,7 @@ CREATE TABLE ar_activity ( encounter int(11) NOT NULL, sequence_no int unsigned NOT NULL AUTO_INCREMENT, `code_type` varchar(12) NOT NULL DEFAULT '', - code varchar(9) NOT NULL COMMENT 'empty means claim level', + code varchar(20) NOT NULL COMMENT 'empty means claim level', modifier varchar(12) NOT NULL DEFAULT '', payer_type int NOT NULL COMMENT '0=pt, 1=ins1, 2=ins2, etc', post_time datetime NOT NULL, diff --git a/version.php b/version.php index fcd3456ee..d7cd68d5e 100644 --- a/version.php +++ b/version.php @@ -17,7 +17,7 @@ $v_realpatch = '0'; // is a database change in the course of development. It is used // internally to determine when a database upgrade is needed. // -$v_database = 84; +$v_database = 85; // Access control version identifier, this is to be incremented whenever there // is a access control change in the course of development. It is used -- 2.11.4.GIT