ORDER_RES_OT

Description: |
This table stores tracked recommendation information and Blood result dispense status for orders-related results. This table can also store Dermatology Skin Findings.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique ID of the finding record corresponding to this result.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | REC_STATUS_C_NAME | VARCHAR | No |
The recommendation status category ID for a result finding.
May contain organization-specific values: Yes
Category Entries:
Needs Follow-up
Closed
Resolved
5 | ADMINPX_ORD_DAT | VARCHAR | No |
A unique contact date in decimal format from which the corresponding order's tracked result originated. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
6 | ADMINPX_BLOODSTAT_C_NAME | VARCHAR | No |
The blood product status history category ID for the order, as sent via a results interface from a blood bank.
May contain organization-specific values: Yes
Category Entries:
Requested
Selected
Issued
Transfusing
Transfused
Returned
Expired/Released
7 | LESION_REMOVE_CMT | VARCHAR | No |
The comments entered by the user when a lesion was removed from a patient's record.
8 | LAST_DOC_DTTM | DATETIME (UTC) | No |
The date and time when this finding was last documented on.
9 | LESION_REMOVE_RSN_C_NAME | VARCHAR | No |
The removal reason category ID for the lesion.
May contain organization-specific values: Yes
Category Entries:
Other
Removing incorrect data
10 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
11 | NOTE_ID | VARCHAR | No |
The unique ID of the note associated with this finding.
12 | REGION_ID | NUMERIC | No |
The unique ID of the anatomic region where a finding was placed.
13 | REGION_ID_RECORD_NAME | VARCHAR | No |
Stores record name (.2)
14 | BACKGROUND_AVATAR_C_NAME | VARCHAR | No |
The avatar image category ID that was showing when the result finding was placed onto a location on the body.
May contain organization-specific values: No
Category Entries:
Adult Male
Adult Female
Adult Neutral
Oropharynx
Adult Hands
Adult Feet
Male Genitalia
Female Genitalia
Adult Head
Child Neutral
Standard Colon
Standard Upper GI Tract
EUS
ERCP
Pulm
Left Hemicolectomy
Right Hemicolectomy
Sigmoid Colectomy
Colostomy
J-Pouch
Sigmoidoscopy
Billroth I
Billroth II
Roux-en-Y Gastric Bypass
Nissen Fundoplication
Sleeve Gastrectomy
Lower EUS
Remote Client
Enteroscopy
Enteroscopy Whipple
Enteroscopy Roux-en-Y Hepaticojejunostomy
ERCP Roux-en-Y Gastric Bypass
ERCP Nissen Fundoplication
ERCP Sleeve Gastrectomy
ERCP Whipple
ERCP Pylorus-preserving Whipple
ERCP Roux-en-Y Hepaticojejunostomy
ERCP Billroth I
ERCP Billroth II
EUS Roux-en-Y Gastric Bypass
EUS Nissen Fundoplication
EUS Sleeve Gastrectomy
EUS Whipple
EUS Roux-en-Y Hepaticojejunostomy
EGD Whipple
EGD Hepaticojejunostomy
EUS Pylorus-preserving Whipple
EGD Pylorus-preserving Whipple
Enteroscopy Pylorus-preserving Whipple
Retrograde Enteroscopy
Ileoscopy
Hartmann's Pouch
15 | DERM_FINDING_COUNT | INTEGER | No |
The number of findings in this result finding record. Allows user to document like findings in the same anatomical region under one result finding record
16 | FINDING_LOC_SUFFIX | VARCHAR | Yes |
This items stores a suffix string that was added by the user to make a finding location unique.
17 | FINDING_LOC_NAME | VARCHAR | No |
This items stores an override name string that was added by the user to make a finding location unique.
18 | GROUP_NOTE_ID | VARCHAR | No |
The unique ID of the group note associated with this finding.
19 | PLAN_NOTE_ID | VARCHAR | No |
The unique ID of the plan note associated with this finding.
20 | FOLLOWUP_RESP_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
21 | BB_BLD_REQ_STATUS_C_NAME | NUMERIC | No |
The status of a request for a blood product
May contain organization-specific values: No
Category Entries:
Requested
Assigned
Issued