FINDING_AVATAR_POINTS

Description:

Avatar documentation for endoscopy findings records.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier for the finding record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	FINDING_POINT_AVATAR_C_NAME	VARCHAR	No
	The avatar type category ID for the finding. 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
4	FINDING_POINT_REGION_ID	NUMERIC	No
	The unique ID of the anatomical region (VEL) this point is associated with.
5	FINDING_POINT_REGION_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
6	FINDING_POINT_LOCATION	VARCHAR	No
	The exact x/y location of the point in the format "x,y", with x and y as decimals.
7	FINDING_POINT_LAYER	VARCHAR	No
	The layer on the avatar where this point exists.