issue_types


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of issue_types.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains the list of issue types that medical health issue can be.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
active BOOLEAN 3 1
category VARCHAR 75 ''
type VARCHAR 75 ''
lists.type Defined in XML R
plural VARCHAR 75 ''
singular VARCHAR 75 ''
abbreviation VARCHAR 75 ''
style SMALLINT 5 0
force_show SMALLINT 5 0
ordering INT 10 0
aco_spec VARCHAR 63 'patients|med'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc category + type

Relationships