| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | /XFT/PREV_20 | Preview buffer: For rule "A" for URL generation | 2 | URL_ID | Character field, length 32 | nvarchar | 32 | 0 | | |
| TOPActivity Clipboard |
| 2 | CRMC_IC_LTX_UPA | Parameter Definition of URL based Launch Transactions | 2 | URL_ID | URL Based Launch Transaction ID | nvarchar | 30 | 0 | | |
| 3 | CRMC_IC_LTX_UPAT | Parameter Definition of URL based Launch Transactions | 2 | URL_ID | URL Based Launch Transaction ID | nvarchar | 30 | 0 | | |
| 4 | CRMC_IC_LTX_URL | Definition of URL based Launch Transactions | 2 | URL_ID | URL Based Launch Transaction ID | nvarchar | 30 | 0 | | |
| 5 | CRMC_IC_LTX_URLT | Definition of URL based Launch Transactions | 2 | URL_ID | URL Based Launch Transaction ID | nvarchar | 30 | 0 | | |
| TOPCapacity and Resource Planning |
| 6 | /MRSS/C_FAV_LINK | Favorite Links in the Left Frame | 2 | URL_ID | ID for Link URL | tinyint | 3 | 0 | | |
| 7 | /MRSS/C_FV_LNK_T | Text Table for /MRSS/C_FAV_LINK | 2 | URL_ID | Dummy for B20 int1 (Local Everywhere) | tinyint | 3 | 0 | | |
| TOPClinical System |
| 8 | N2GL_GUIDELINE | pathways Treatment Pathway | 15 | URL_ID | UUID in character form | nvarchar | 32 | 0 | | |
| 9 | N2GL_ITEM | Pathways: Item of Treatment Pathway | 18 | URL_ID | UUID in character form | nvarchar | 32 | 0 | | |
| 10 | N2GL_TM_SCHEDULE | pathways Patient Pathway | 33 | URL_ID | ID of URL | nvarchar | 32 | 0 | | |
| 11 | N2GL_TM_STEP | pathways Step of Patient Pathway | 36 | URL_ID | ID of URL | nvarchar | 32 | 0 | | |
| 12 | N2GL_URLS | URL Entries for Treatment Pathways | 3 | URL_ID | UUID in character form | nvarchar | 32 | 0 | | |
