| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | GRACCRPROFILE | Critical Profile Rule | 8 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
2 | GRACCRROLE | Critical Role Rule | 8 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
3 | GRACFUNC | Function | 6 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
4 | GRACRULESET | Rule Set | 4 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
5 | GRACSODRISK | SOD Risk | 6 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
6 | GRACSTDROLE | Default Role | 6 | UPDUSER | Field Last Updated by Username | nvarchar | 12 | 0 | | |
TOPClinical System |
7 | N2DWSWL_TASKD | Provisional Task | 29 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
8 | N2DWSWL_WORKD | Provisional Situation | 32 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
9 | N2GL_ACT | pathways Activity | 22 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
10 | N2GL_ACT_NOTE | Pathways: Comment on Activity | 13 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
11 | N2GL_GUIDELINE | pathways Treatment Pathway | 40 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
12 | N2GL_TM_SCHEDULE | pathways Patient Pathway | 45 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
13 | N2GL_TM_STEP | pathways Step of Patient Pathway | 40 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
14 | N2PHYO_ORDER | Physician Order | 21 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
15 | N2RAD_FWL_ITEM | i.s.h.med Radiology Findings Work Station: Findings Tasks | 23 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
16 | TN2CAT | Categories: Categories in Category Set | 12 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
17 | TN2CATAREA | Categories: Category Areas | 7 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
18 | TN2CATC | Categories: Categories for End Users | 8 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
19 | TN2CATCM | Categories: Main Categories | 7 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
20 | TN2CATCONT | Categories: Category Container | 9 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
21 | TN2CATSET | Categories: Category Set | 9 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
22 | TN2PDCS2OE | IPPD: Assignments: SET - OU - Occupational Group | 10 | UPDUSER | User who Last Changed Record | nvarchar | 12 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
23 | N2DWSWL_FAVO | Hit List Entry | 14 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
24 | N2DWSWL_FAVO1 | Hit List Entry / Changes | 14 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
25 | N2DWSWL_GROUP | Groups for Template Management | 9 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
26 | N2DWSWL_INFO | Info Item | 9 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
27 | N2DWSWL_PATT | Task Template | 25 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
28 | N2DWSWL_PATT1 | Task Template / Changes | 25 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
29 | N2DWSWL_PROF | Profile Template | 17 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
30 | N2DWSWL_PROF1 | Profile Template / Changes | 17 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
31 | N2DWSWL_TASK | Task | 29 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
32 | N2DWSWL_TPACK | Profile | 17 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
33 | N2DWSWL_WORK | Situation | 32 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
34 | N2DWSWL_WS | Situation Template | 26 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
35 | N2DWSWL_WS1 | Situation Template / Changes | 26 | UPDUSER | User Who Last Changed Data Record | nvarchar | 12 | 0 | | |
TOPSets |
36 | SETHEADER | Set Header and Directory | 13 | UPDUSER | Last Changed By | nvarchar | 12 | 0 | | |
37 | T800S | FI-SL Set Table (before Release 4.0) | 8 | UPDUSER | Last Changed By | nvarchar | 12 | 0 | | |