The DFCYTXLOG table stores the transaction log of activity occurring on a chart throughout its existence. Each chart will typically have multiple related rows in this table. The DFCYTXLOG table is located in DBSpace1.
Column Name | Data Type | Description |
---|---|---|
dfcytxlognum | bigint | The internal unique identifier of the transaction being logged. |
chtnum | bigint |
The internal unique identifier of the chart; a foreign key to the CHART table. |
logdate | datetime |
The date and time that the transaction occurred. |
action | bigint | An enumeration value indicating a specific activity for the transaction. (See Appendix for enumeration values.) |
usernum | bigint | The internal unique identifier of the user who performed the transaction. |
itemnum | bigint | The internal unique identifier of the document on which the transaction was performed, if applicable. |
extrainfo1 | bigint | Stores additional information about the transaction, dependent on the value in the action column. |
extrainfo2 | bigint | Stores additional information about the transaction, dependent on the value in the action column. |
extrainfo3 | bigint | Stores additional information about the transaction, dependent on the value in the action column. |
dfcynum | bigint |
The internal unique identifier of the deficiency that the transaction is related to, if applicable. |
messagetext | char(200) | Text description of the transaction that is being logged. |
registernum | bigint |
The internal unique identifier of the workstation on which the transaction occurred; a foreign key to the REGISTEREDUSERS table. |
actionnum | bigint | Not currently implemented. |
subactionnum | bigint | Not currently implemented. |
severityflag | bigint |
For future use. |
tracelvl | bigint | Logging detail level. |
The indexes for the DFCYTXLOG table are located in DBSpace1.
Index Name | Included Columns |
---|---|
dfcytxlog1 | logdate, action |
dfcytxlog2 | action |
dfcytxlog3 | chtnum, action |
dfcytxlog4 | usernum, action |