| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1BCEXP | Basic Cat.: Export | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
2 | N1BCEXPCFG | Basis Cat.: Export Configuration | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
3 | N1BCH | Basic Cat.: Catalog Header | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
4 | N1BCH2OU | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
5 | N1BCH2ROLE | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
6 | N1BCH2USER | OBSOLETE | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
7 | N1BCHBADI | OBSOLET | 2 | BCHID | Basiskat.: Katalogschlüssel | nvarchar | 33 | 0 | | |
8 | N1BCHCOM | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
9 | N1BCHDIAG | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
10 | N1BCHHIT | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
11 | N1BCHINTV | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
12 | N1BCHMAT | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
13 | N1BCHPROB | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
14 | N1BCHRES | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
15 | N1BCHSPEC | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
16 | N1BCHT | Basic Cat.: Catalog Header - Texts | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
17 | N1BCHTARG | OBSOLETE | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
18 | N1BCIMP | Basic Cat.: Import | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
19 | N1BCIMPCFG | Basic Cat.: Import Configuration | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
20 | N1BCIMPFPOSKEY | Basic Cat.: Import - External Item Key | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
21 | N1BCP | Basic Cat.: Catalog Item | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
22 | N1BCP2DIAG | Basic Cat.: Catalog Item to Diagnosis Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
23 | N1BCP2HIER | Basic Cat.: Catalog Item to Hierarchy Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
24 | N1BCP2MAT | Basic Cat.: Catalog Item to Material Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
25 | N1BCP2NTPK | Basic Cat.: Catalog Item to Service Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
26 | N1BCP2RC | Basic Cat.: Item - Display Configuration Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
27 | N1BCP2TASK | Basic Cat.: Catalo Item to Task Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
28 | N1BCP2URL | Basic Cat.: Catalog Item to URL Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
29 | N1BCPINTV | Basic Cat.: Additional Item Data Procedure Catalog | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
30 | N1BCPLD | OBSOLETE | 4 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
31 | N1BCPMAT | Basic Cat.: Additional Item Data Material Catalog | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
32 | N1BCPPROB | Basic Cat.: Additional Item Data Health Problem Catalog | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
33 | N1BCPT | Basic Cat.: Catalog Item - Texts | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
34 | N1BCPTARG | Basic Cat.: Additional Item Data - Goal Catalog | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
35 | N1BCRC | Basic Cat.: Display Configuration | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
36 | N1BCRCT | Basic Cat.: Display Configuration Texts | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
37 | N1BCRG | Basic Cat.: Display Group | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
38 | N1BCRGT | Basic Cat.: Display Group Texts | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
39 | N1BCSE | OBSOLETE: Basic Cat.: Basic Catalog Set Entry | 6 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
40 | N1BCSEP | OBSOLETE: Basic Cat.: Basic Catalog Set Entry Property | 6 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
41 | N1BCSMC | Basic Catalog Set: Main Catalog | 6 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
42 | N1BCSPC | Basic Catalog Set: Property Catalog | 6 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
43 | N1BCSPEC | Basic Cat.: Range | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
44 | N1BCSPEC2BCP | Basic Cat.: Range to Catalog Item Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
45 | N1BCSPEC2EBCP | Basic Cat.: Range to Excluded Catalog Item Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
46 | N1BCSPEC2OU | Basic Cat.: Range to OU Assignment | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
47 | N1BCSPECT | Basic Cat.: Range Texts | 3 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
48 | N1BCUFAVH | Basic Cat.: User-Specific Favorites - Header Data | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
49 | N1SRV | Services: Service Data | 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
50 | N1SRVPROP | Nursing Services: Service Properties | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
51 | N2AD_ALLERGY | Allergy Documentation - Allergies | 4 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
52 | N2BCPAD | Additional Data Items - Catalog Category - Allergies | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
53 | N2BCPCLIF | Additional Data Item Catalog Type Fixed Values | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
54 | N2BCPCLIM | Additional Data Item Catalog Type Clinical Measurements | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
55 | N2BCPCLIR | Additional Data Item Catalog Type Value Ranges | 2 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
56 | N2CLIM_PLDVS | Vital Signs: Definite Planned Measurement (with Time) | 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
57 | N2CLIM_SDLVS | Vital Signs: Measurement Plan for Patient (Cycles) | 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
58 | N2CLIM_VALVS | Vital Signs: Measured Values | 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
59 | TN2CLIM_COMP_OU | CLIM: Measurement - Entry Element Assignment for OU | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
60 | TN2CLIM_SPECIFY | CLIM: Specify Measurement | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
61 | TN2CLIM_SPEC_POS | CLIM: Specialize Items for Measurement | 5 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
TOPNursing |
62 | N1NRSPE | Nursing Plan: Entry | 9 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
63 | N1SNP2BCP | OBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt | 4 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
64 | N1SNPE | Standard Nursing Plan: Entry | 8 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |
65 | N1SNPH2BCP | Stnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt | 4 | BCHID | Basic Catalog: Catalog Key | nvarchar | 33 | 0 | | |