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
Retrograde Enteroscopy
Ileoscopy