The CHTEXTENSION table is an extension of the CHART table and stores information related to the specific patient visit. The CHTEXTENSION table is located in DBSpace1.
| Column Name | Data Type | Description |
|---|---|---|
| chtnum | bigint |
The internal unique identifier of a chart object; a foreign key to the CHART table. |
| medservicenum | bigint |
The internal unique identifier of the Medical Service associated with the chart; a foreign key to the MEDSERVICE table. |
| disposition | bigint | Not implemented. (See chtdisposition column.) |
| totalcharges | numeric(9) |
The total charges for the visit. |
| financialclass | char(50) | Character representation of the financial class for the associated visit (e.g., A = Medicare). |
| admitsource | bigint | Not implemented. (See admitsrc column.) |
| medpayornum | bigint | Uniquely identifies the visit’s payor; a foreign key to the MEDPAYOR table. |
| chtdisposition | char(50) | Stores the disposition returned from HL7 for the associated chart. The disposition is the status of the patient upon discharge (e.g., 20 = Expired). |
| admitsrc | char(50) |
Stores the admit source returned from HL7 for the associated chart. |
| referphysnum | bigint |
Internal unique identifier of the physician who referred the patient for the associated visit; a foreign key to the USERACCOUNT and PHYSICIANINFO tables. |
| primcarephysnum | bigint | Internal unique identifier of the patient’s primary care physician at the time of the associated visit; a foreign key to the USERACCOUNT and PHYSICIANINFO tables. |
The indexes for the CHTEXTENSION table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| chtextension1 | chtnum |