| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDocument Builder |
1 | /IPRO/TALTCLAUSE | table for alternative clauses | 9 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
2 | /IPRO/TCUSTELM | Document Builder Custom Elements | 8 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
3 | /IPRO/TDOCSL_ELM | Association between doc selection and elements | 5 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
4 | /IPRO/TDOCSL_RGS | Association table between TDOCSL and TRGSET | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
5 | /IPRO/TELMNT | Element table | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
6 | /IPRO/TELMORDER | Element order table | 7 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
7 | /IPRO/TELM_FMT | Maintain relationship between elements and formats | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
8 | /IPRO/TELM_GUIDE | Association table between elements and guidance | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
9 | /IPRO/TELM_PRESC | Association between elements and prescriptions | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
10 | /IPRO/TELM_PROP | Association between elements and properties | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
11 | /IPRO/TNOTE | DocB Element Note Table | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
12 | /IPRO/TRGSET | Regulation Set table | 3 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
13 | /IPRO/TRGSET_CMP | Table of Reg Set components (Ref, Presc, Guidance) | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
14 | /IPRO/TRGSET_T | Regulation Set text table | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
15 | /IPRO/TRGSTHST | Regualtion Set History table | 3 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
16 | /IPRO/TRGSTHST_T | Text table for TRGSTHST that records hist of reg set updates | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
17 | /IPRO/TTEXT | Table holding text for elemnts, reg set compnents & doc styl | 4 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
18 | /IPRO/TTEXT_T | Text table associated with TTEXT | 5 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |
19 | /IPRO/TUPDATELOG | update report table to store the log | 6 | RGSET | Regulation Set | nvarchar | 10 | 0 | | |