| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | BBP_SUS_STG_MAIL | staging mail table | 9 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| 2 | NWS_EXT_ADSM2 | Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt) | 10 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| 3 | NWS_EXT_ADSMT | Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt) | 10 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 4 | ADR6 | E-Mail Addresses (Business Address Services) | 13 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| 5 | ADR6S | Shadow Table: SMTP Numbers (Business Address Services) | 14 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| 6 | ADR6S2 | Shadow Table 2: SMTP Numbers (Business Address Services) | 14 | ENCODE | Desired Data Coding (E-Mail) | nvarchar | 1 | 0 | | |
| TOPClinical System |
| 7 | N2GL_DES | IS-H*MED: Description of Treatment Pathway | 5 | ENCODE | Coding Format | ntext | 1073741823 | 0 | | |
