Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
procedure_type_id | BIGINT | 19 | √ | null |
|
|
Surrogate id of the record used as the primary incrementing key |
|||||||
parent | BIGINT | 19 | 0 |
|
|
References procedure_type.procedure_type_id for heirarchies of procedure types |
||||||||
name | VARCHAR | 63 | '' |
|
|
Name for this category, procedure or result type |
||||||||
lab_id | BIGINT | 19 | 0 |
|
|
References procedure_providers.ppid, 0 means default to parent |
||||||||
procedure_code | VARCHAR | 64 | '' |
|
|
Code and code system identifying this procedure in the format of codesystem:code |
||||||||
procedure_type | VARCHAR | 31 | '' |
|
|
Comes from the list_options.list_id=‘proc_type’ and represents the kind of procedure_type this is (‘group’, ‘order’, ‘discrete_result’, etc’) |
||||||||
body_site | VARCHAR | 31 | '' |
|
|
Where to do injection, e.g. arm, buttock |
||||||||
specimen | VARCHAR | 31 | '' |
|
|
Blood, urine, saliva, etc. |
||||||||
route_admin | VARCHAR | 31 | '' |
|
|
Oral, injection |
||||||||
laterality | VARCHAR | 31 | '' |
|
|
Left, right, … |
||||||||
description | VARCHAR | 255 | '' |
|
|
Descriptive text for procedure_code |
||||||||
standard_code | VARCHAR | 255 | '' |
|
|
Industry standard code type and code (e.g. CPT4:12345) |
||||||||
VARCHAR | 255 | '' |
|
|
Suggested code(s) for follow-up services if result is abnormal |
|||||||||
units | VARCHAR | 31 | '' |
|
|
Default for procedure_result.units |
||||||||
range | VARCHAR | 255 | '' |
|
|
Default for procedure_result.range |
||||||||
seq | INT | 10 | 0 |
|
|
Sequence number for ordering |
||||||||
activity | BOOLEAN | 3 | 1 |
|
|
1=active, 0=inactive |
||||||||
notes | VARCHAR | 255 | '' |
|
|
Additional notes to enhance description |
||||||||
transport | VARCHAR | 31 | √ | NULL |
|
|
||||||||
procedure_type_name | VARCHAR | 64 | √ | NULL |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | procedure_type_id |
parent | Performance | Asc | parent |
ptype_procedure_code | Performance | Asc | procedure_code |