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
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	REC_REASON_C_NAME	VARCHAR	No
	Stores the reasons why a screening program recommendation was selected. May contain organization-specific values: Yes Category Entries: Inadequate bowel preparation Inflammatory bowel disease Personal history of colon polyps Personal history of colon cancer Family history of colon polyps Family history of colon cancer Age greater than 65 Gastric ulcer surveillance Barrett's esophagus surveillance Dysphagia Reflux symptoms Dyspepsia Abnormal pathology Incomplete procedure Patient preference Life expectancy is less than 10 years Overall health Prior screening history Abnormal pathology Incomplete procedure
21	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.