| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVTDMS16_PARAMS | Parameter List For System Analysis | 3 | PKEY | Data Element for Parameter Key | nvarchar | 40 | 0 | | |
| TOPClinical System |
| 2 | N1IPBA | IS-H*MED: Asnmt. of Indiv. Nurs. Plan to Basic HospCat.Entry | 4 | PKEY | Code of Basic Nursing Catalog | nvarchar | 20 | 0 | | |
| 3 | N1PLBA | IS-H*MED: Assignment basic hosp.cat.entry to hour.nurs.plans | 6 | PKEY | Code of Basic Nursing Catalog | nvarchar | 20 | 0 | | |
| 4 | N2BK | IS-H*MED: Basic Nursing Catalog | 4 | PKEY | Code of Basic Nursing Catalog | nvarchar | 20 | 0 | | |
| 5 | N2BKGZ | IS-H*MED: Nursing basic catalog - classif. areas assignment | 5 | PKEY | Code of Basic Nursing Catalog | nvarchar | 20 | 0 | | |
| 6 | N2SPGZ | IS-H*MED: Standard nursing plan - classif. areas asgmt | 5 | PKEY | Code of Basic Nursing Catalog | nvarchar | 20 | 0 | | |
| TOPCollectionsDisbursements |
| 7 | DIMAIOBPAR | IO: Insurance Object-Partner Relationship in FS-CD | 58 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 8 | DIMAPARPPLAN | IO: Payment Plan Changes in Insurance Object | 6 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 9 | DIMAPARSCPOS | IO: Change to Scheduling Items | 20 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 10 | TVS010B | IS-IS Scheduling: Paymt Plan | 2 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 11 | TVS010BT | IS-IS Scheduling: Paymt Plan Texts | 3 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 12 | TVS010H | IS-IS Scheduling: Percentage Distribution in Paymt Plan | 2 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 13 | TVS010I | IS-IS Scheduling: Assignment of Activities to Posting Event | 2 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 14 | TVS010J | IS-IS Scheduling: Assignment of Activities to Change Event | 2 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 15 | TVS020A | IS-IS Scheduling: Assigning Payment Plan to Payment Option | 3 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 16 | VVSCITEM | Bill Scheduling: Scheduling Document | 28 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 17 | VVSCITEM_MAN | Scheduling Items: Temp. Storage for Manual -> Auto Change | 28 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| 18 | VVSCPOS | Payment Plan Item | 52 | PKEY | Payment Plan Key | nvarchar | 2 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 19 | TCACS_LOS_ST_OD | Logical Service: Parameters for Std Tool (Object-Dependent) | 11 | PKEY | Payment Plan Key (Copy VVSC) | nvarchar | 2 | 0 | | |
| TOPTranslation Tools |
| 20 | LXE_KEY_VALUE | Properties | 1 | PKEY | | nvarchar | 32 | 0 | | |
| 21 | LXE_XT_OBJ_ATTR | Object Attributes | 3 | PKEY | Parameter Key | nvarchar | 32 | 0 | | |
| 22 | LXE_XT_TXT_ATTR | Text Attributes | 4 | PKEY | Parameter Key | nvarchar | 32 | 0 | | |
