| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | PIQDB_DE_TRH | Transcript Header | 4 | MONTH_COUNT | Duration of Study in Months | decimal | 3 | 0 | | |
| TOPMaster Data |
| 2 | EWATSPCMPNTSF | Service Frequency | 8 | MONTH_COUNT | Frequency of Service in Months | nvarchar | 2 | 0 | | |
| TOPWaste Management |
| 3 | EWAOBJH | Service Frequency -> Services (History for EWAOBJ) | 34 | MONTH_COUNT | Frequency of Service in Months | nvarchar | 2 | 0 | | |
| 4 | EWA_BILL_RELEVNT | Valuation of Fields Relevant for Billing in Waste Bill.Cat. | 17 | MONTH_COUNT | Frequency of Service in Months | nvarchar | 2 | 0 | | |
| 5 | TEWASERVGRPTMPL | Default Values for Service Grouping | 6 | MONTH_COUNT | Frequency of Service in Months | nvarchar | 2 | 0 | | |
| 6 | TEWASERVICETMPL | Default Values for Service Type for Service Product | 6 | MONTH_COUNT | Frequency of Service in Months | nvarchar | 2 | 0 | | |
