ORDER_AVATAR_INFO

Description: |
Used to track the avatar used in the order.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. 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.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | AVATAR_TYPE_C_NAME | VARCHAR | No |
The avatar type category ID for the order.
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