| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPClinical System |
| 1 | N2GL_GUIDELINE | pathways Treatment Pathway | 45 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
| 2 | TN2CAT | Categories: Categories in Category Set | 3 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
| 3 | TN2CATSET | Categories: Category Set | 3 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
| 4 | TN2CATSETT | Categories: Category Set (Texts) | 3 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
| 5 | TN2GL_ACT_CUST | Pathways: Settings for Activities | 3 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
| 6 | TN2PDCS2OE | IPPD: Assignments: SET - OU - Occupational Group | 6 | CATSET_ID | Categories: Category Set Key | nvarchar | 6 | 0 | | |
