| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDocument Builder |
1 | /IPRO/TALTCLAUSE | table for alternative clauses | 8 | ELMNT | Element | nvarchar | 20 | 0 | | |
2 | /IPRO/TCUSTELM | Document Builder Custom Elements | 7 | ELMNT | Element | nvarchar | 20 | 0 | | |
3 | /IPRO/TDOCSL_ELM | Association between doc selection and elements | 4 | ELMNT | Element | nvarchar | 20 | 0 | | |
4 | /IPRO/TELMNT | Element table | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
5 | /IPRO/TELM_FMT | Maintain relationship between elements and formats | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
6 | /IPRO/TELM_GUIDE | Association table between elements and guidance | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
7 | /IPRO/TELM_PRESC | Association between elements and prescriptions | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
8 | /IPRO/TELM_PROP | Association between elements and properties | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
9 | /IPRO/TNOTE | DocB Element Note Table | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
10 | /IPRO/TUPDATELOG | update report table to store the log | 3 | ELMNT | Element | nvarchar | 20 | 0 | | |
TOPPublic Sector |
11 | T5VPPS_ELEMENT | Element Category for Norway Public Sector | 3 | ELMNT | Element for Norway Public Sector | nvarchar | 5 | 0 | | |
12 | T5VPPS_ELEMENTT | Element Category for Norway Public Sector - Text | 4 | ELMNT | Element for Norway Public Sector | nvarchar | 5 | 0 | | |
13 | T5VPPS_ELG_CAT | Eligibility Category with Values for Norway Public Sector | 7 | ELMNT | Element for Norway Public Sector | nvarchar | 5 | 0 | | |
TOPTask Resource Management |
14 | LELMT | Resource element | 3 | ELMNT | Resource Element | nvarchar | 20 | 0 | | |
15 | LELTA | Allowed resource element type | 3 | ELMNT | Resource Element | nvarchar | 20 | 0 | | |
16 | LLGRS | Resource log | 4 | ELMNT | Resource Element | nvarchar | 20 | 0 | | |
17 | LMVRT | Variant for TRM Monitoring | 4 | ELMNT | Resource Element Defined for User | nvarchar | 12 | 0 | | |
18 | LRSWD | Workers of deactivated resources | 3 | ELMNT | Resource Element | nvarchar | 20 | 0 | | |