| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N2GL_ACT | pathways Activity | 24 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 2 | N2GL_ACT_NOTE | Pathways: Comment on Activity | 15 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 3 | N2GL_GUIDELINE | pathways Treatment Pathway | 42 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 4 | N2GL_TM_SCHEDULE | pathways Patient Pathway | 47 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 5 | N2GL_TM_STEP | pathways Step of Patient Pathway | 42 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 6 | TN2CAT | Categories: Categories in Category Set | 14 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 7 | TN2CATAREA | Categories: Category Areas | 9 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 8 | TN2CATC | Categories: Categories for End Users | 10 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 9 | TN2CATCM | Categories: Main Categories | 9 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 10 | TN2CATCONT | Categories: Category Container | 11 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 11 | TN2CATSET | Categories: Category Set | 11 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| 12 | TN2PDCS2OE | IPPD: Assignments: SET - OU - Occupational Group | 12 | DELUSER | User Who Set Deletion Indicator | nvarchar | 12 | 0 | | |
| TOPData Retention Tool |
| 13 | TXW_DIR | Data file log (replaced by txw_dir2, use of guids) | 29 | DELUSER | User Name | nvarchar | 12 | 0 | | |
| 14 | TXW_DIR2 | Data file log | 30 | DELUSER | Deletion: User | nvarchar | 12 | 0 | | |
| 15 | TXW_VWLOG | View query log (replaced by txw_vwlog2: uuids) | 14 | DELUSER | User Name | nvarchar | 12 | 0 | | |
| 16 | TXW_VWLOG2 | View query log | 16 | DELUSER | Deletion: User | nvarchar | 12 | 0 | | |
