| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPClinical System |
1 | N1BCIMPFPOSKEY | Basic Cat.: Import - External Item Key | 6 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
2 | N1BCP | Basic Cat.: Catalog Item | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
3 | N1BCP2DIAG | Basic Cat.: Catalog Item to Diagnosis Assignment | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
4 | N1BCP2MAT | Basic Cat.: Catalog Item to Material Assignment | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
5 | N1BCP2NTPK | Basic Cat.: Catalog Item to Service Assignment | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
6 | N1BCP2RC | Basic Cat.: Item - Display Configuration Assignment | 4 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
7 | N1BCP2TASK | Basic Cat.: Catalo Item to Task Assignment | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
8 | N1BCP2URL | Basic Cat.: Catalog Item to URL Assignment | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
9 | N1BCPBADI | OBSOLET | 2 | BCPID | Basiskat.: Positionsschlüssel | nvarchar | 33 | 0 | | |
10 | N1BCPCOM | OBSOLETE | 2 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
11 | N1BCPDIAG | OBSOLETE | 2 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
12 | N1BCPINTV | Basic Cat.: Additional Item Data Procedure Catalog | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
13 | N1BCPLD | OBSOLETE | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
14 | N1BCPMAT | Basic Cat.: Additional Item Data Material Catalog | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
15 | N1BCPPROB | Basic Cat.: Additional Item Data Health Problem Catalog | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
16 | N1BCPRES | OBSOLETE | 2 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
17 | N1BCPT | Basic Cat.: Catalog Item - Texts | 4 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
18 | N1BCPTARG | Basic Cat.: Additional Item Data - Goal Catalog | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
19 | N1BCSPEC2BCP | Basic Cat.: Range to Catalog Item Assignment | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
20 | N1BCSPEC2EBCP | Basic Cat.: Range to Excluded Catalog Item Assignment | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
21 | N1BCUFAVP | Basic Cat.: User-Specific Favorites - Items | 4 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
22 | N1SRV | Services: Service Data | 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
23 | N1SRVPROP | Nursing Services: Service Properties | 6 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
24 | N2AD_ALLERGY | Allergy Documentation - Allergies | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
25 | N2BCPAD | Additional Data Items - Catalog Category - Allergies | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
26 | N2BCPCLIF | Additional Data Item Catalog Type Fixed Values | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
27 | N2BCPCLIM | Additional Data Item Catalog Type Clinical Measurements | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
28 | N2BCPCLIR | Additional Data Item Catalog Type Value Ranges | 3 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
29 | N2CLIM_PLDVS | Vital Signs: Definite Planned Measurement (with Time) | 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
30 | N2CLIM_SDLVS | Vital Signs: Measurement Plan for Patient (Cycles) | 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
31 | N2CLIM_VALVS | Vital Signs: Measured Values | 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
32 | TN2CLIM_COMP_OU | CLIM: Measurement - Entry Element Assignment for OU | 6 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
33 | TN2CLIM_SPECIFY | CLIM: Specify Measurement | 6 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
34 | TN2CLIM_SPEC_POS | CLIM: Specialize Items for Measurement | 6 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
TOPNursing |
35 | N1NRSPE | Nursing Plan: Entry | 10 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
36 | N1SNP2BCP | OBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
37 | N1SNPE | Standard Nursing Plan: Entry | 9 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
38 | N1SNPH2BCP | Stnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |
39 | N1SNPP | OBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item | 5 | BCPID | Basic Cat.: Item Key | nvarchar | 33 | 0 | | |