The CHARTXITEMDATA table is a cross reference table that links documents to charts. The CHARTXITEMDATA 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. |
| itemnum | bigint |
The internal unique identifier of a document; a foreign key to the ITEMDATA table. |
| analysisstatus | bigint | Indicates the document’s status within the Analysis context; 0 = undefined, 1 = normal, 2 = loose document. |
| currentpage | bigint |
Not implemented. |
| itemtypenum | bigint | The document type of the referenced document; a foreign key to the DOCTYPE table. |
| hl7externaldocid | char(63) |
Stores the external report ID for the document. |
| segnum | bigint |
Determines how documents are ordered within a tab or document list. This value is set by users manually sorting the document list. |
| relateditemnum | bigint | Reference to a related document; a foreign key to the ITEMDATA table. |
| relatedpagenum | bigint | Reference to a specific page of a related document (relateditemnum); a foreign key to the ITEMDATAPAGE table. |
The indexes for the CHARTXITEMDATA table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| chartxitemdata1 |
analysisstatus, chtnum |
| chartxitemdata2 |
itemtypenum |
| chartxitemdata3 |
chtnum, itemtypenum |
| chartxitemdata4 |
itemnum |
| chartxitemdata5 |
relateditemnum |