Code types - new in Admin->Lists

OpenEMR Development
1

tmccormi wrote on Friday, April 29, 2011:

Code types has been moved to lists now, though it seems to have it’s own table, -vs- being stored in list_options.  This is good as it was a PHP file inlcude.

However we need to know what this options mean and what programs are effected by them,
… ModLength
Justify
Mask
Fees
Relations
Hide
Diagnosis

Rod, do you have this information off the top of your head?

-Tony

2

tmccormi wrote on Friday, April 29, 2011:

In a similar question, the code table has these three columns:
superbill - how is this used and where?
related_code - how is this used and where?
taxrates - where can this be entered from? 

-Tony

3

tmccormi wrote on Friday, April 29, 2011:

Any reason not to use code_type = 4 for the CVX (vaccine) codes that are needed for certification?   They will be included in the release database.sql and upgrade sql files
-Tony

4

tmccormi wrote on Friday, April 29, 2011:

There is an error in database.sql for code_type table,  the insert is missing a column ‘ct_mask’

CREATE TABLE code_types (
  ct_key  varchar(15) NOT NULL           COMMENT 'short alphanumeric name',
  ct_id   int(11)     UNIQUE NOT NULL    COMMENT 'numeric identifier',
  ct_seq  int(11)     NOT NULL DEFAULT 0 COMMENT 'sort order',
  ct_mod  int(11)     NOT NULL DEFAULT 0 COMMENT 'length of modifier field',
  ct_just varchar(15) NOT NULL DEFAULT ''COMMENT 'ct_key of justify type, if any',
  ct_mask varchar(9)  NOT NULL DEFAULT ''COMMENT 'formatting mask for code values',
  ct_fee  tinyint(1)  NOT NULL default 0 COMMENT '1 if fees are used',
  ct_rel  tinyint(1)  NOT NULL default 0 COMMENT '1 if can relate to other code types',
  ct_nofs tinyint(1)  NOT NULL default 0 COMMENT '1 if to be hidden in the fee sheet',
  ct_diag tinyint(1)  NOT NULL default 0 COMMENT '1 if this is a diagnosis type',
  PRIMARY KEY (ct_key)
) ENGINE=MyISAM;
INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('ICD9' , 2, 1, 2, ''    , 0, 0, 0, 1);
INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('CPT4' , 1, 2, 2, 'ICD9', 1, 0, 0, 0);
INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('HCPCS', 3, 3, 2, 'ICD9', 1, 0, 0, 0);