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 BIT 1 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

Close relationships within degrees of separation