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 |