| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBank Customer Accounts |
| 1 | RTP_US_ACC | Linking table between a retirement plan and an account | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 2 | RTP_US_BEN | Beneficiary table for a retirement plan | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 3 | RTP_US_BP_PLAN | Business partners associated with a retirement plan | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 4 | RTP_US_HIST | Retirement plan history and audit table | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 5 | RTP_US_PLAN | Retirement plan data (US enhancement) | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 6 | RTP_US_RMD | Required minimum distribution | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
| 7 | RTP_US_TOT | Total amounts for a retirement plan | 3 | PLAN_NUMBER | Plan number of a retirement plan | nvarchar | 15 | 0 | | |
