| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOffice Suite Program |
1 | /OSP/TA_BM_RV | Rule Violation Types | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
2 | /OSP/TA_BM_RVT | Text table for Rule Violation types | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
3 | /OSP/T_ALTREG | Alert Regions | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
4 | /OSP/T_ALTRGFLD | Alert - Regions - Fields | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
5 | /OSP/T_BM_RLV | Rule Violation Types | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
6 | /OSP/T_BM_RLVT | Text table for Rule Violation types | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
7 | /OSP/T_FIELD | Alerts Fields Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
8 | /OSP/T_FIELDT | Fields Text Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
9 | /OSP/T_RAUI_CHR | OSP Chart Reports Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
10 | /OSP/T_RAUI_CHRT | OSP Chart Reports Text Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
11 | /OSP/T_RAUI_CMVL | OSP Chart Report Parameter Multiple Values Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
12 | /OSP/T_RAUI_CPVL | OSP Chart Report Parameterization Value Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
13 | /OSP/T_RAUI_CPVT | OSP Chart Report Parameter Text Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
14 | /OSP/T_RAUI_CSER | OSP Chart Reports Settings Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
15 | /OSP/T_RAUI_CSET | OSP Chart Reports Settings Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
16 | /OSP/T_RAUI_CSTT | OSP Chart Reports Settings Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
17 | /OSP/T_RAUI_TMVL | OSP : Triggered Report Parameter Multiple Value | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
18 | /OSP/T_RAUI_TPBH | OSP Triggered Report Parameterization Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
19 | /OSP/T_RAUI_TPBT | OSP: Triggered Report Parameters Text Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
20 | /OSP/T_RAUI_TREL | OSP Triggered Reports Relations Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
21 | /OSP/T_RAUI_TRG | OSP Triggered Reports Table | 2 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |
22 | /OSP/T_RAUI_TRGT | OSP Triggered Reports Text Table | 3 | RV_TYPE | Rule violation type code | nvarchar | 4 | 0 | | |