PATIENT_AVATAR_INFO

Description:

Table to store avatar being used by the patient.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	AVATAR_TYPE_C_NAME	VARCHAR	No
	The avatar type category ID for the patient. 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