| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | GRFNDEFTYPE | Deficiency Type | 1 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 2 | GRFNDEFTYPEC | Deficiency Type for Customizing | 2 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 3 | GRFNDEFTYPECT | Deficiency Type Description for Customizing | 2 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 4 | GRFNDEFTYPET | Deficiency Type Description | 1 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 5 | GRFNDEFVALUELK | Deficiency Value Lookup | 1 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 6 | GRFNJOBPRESULT | Job Step Result - Deficiency | 4 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| TOPClinical System |
| 7 | TN1DEFDRUGS | i.s.h.med: Medidation, Mixed Drugs | 6 | DEFTYPE | Medication: Drug Category | nvarchar | 1 | 0 | | |
| TOPIncentive and Commission Management ICM |
| 8 | TCRD_CDEFT | Definition Type for Credentialing | 3 | DEFTYPE | Definition Type of Credential Type | nvarchar | 10 | 0 | | |
| 9 | TCRD_CDEFTT | Definition Type for Credentials - Text Table | 4 | DEFTYPE | Definition Type of Credential Type | nvarchar | 10 | 0 | | |
| 10 | TCRD_TYPE | Credential Types | 4 | DEFTYPE | Definition Type of Credential Type | nvarchar | 10 | 0 | | |
| TOPProcess Controls |
| 11 | GRPCDEFTYPE | Deficiency Type | 2 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
| 12 | GRPCDEFTYPET | Deficiency Type Description | 3 | DEFTYPE | Deficiency Type | nvarchar | 5 | 0 | | |
