Holds rate plan, a rate plan consists of one or more rate items and will be included in a offering to allow for subscription to Accounts
| Column Name | Column Datatype | Column Null Option | Column Comment |
| rate_plan_id | integer | not null | The unique id for each rate plan |
| rate_plan_name | nvarchar(128) | not null | Name of the rate plan |
| rate_plan_type | integer | not null | 0=fixed, 1=tiered |
| selection_type | integer | not null | 0=no selection, 1=single selection, 2=multiple selection |
| status | integer | not null | 0=deleted, 1=available, 2=unavailable, 3=created, 4=cancelled |
| code | nvarchar(64) | with null | Set when status=1 |
| date_available | date | with null | Set when status=2 |
| date_unavailable | date | with null | Set when status=3 |
| date_created | date | not null | Set when status=4 |
| date_cancelled | date | with null | SP/ST supplies code |
| is_inherited | integer | not null | 0=a base rate plan, 1=rate plan inherits some or all of it |
| has_header | integer | not null | 0=no header rate items, 1=has header rate items |
| total_rows | integer | not null | Number of rows in the rate plan |
| total_cols | integer | not null | Number of columns in the rate plan |
| description | nvarchar(128) | with null | SP/ST admin description of the rate plan |
| notes_id | integer | with null | Currently not used. |
| sub_note_control | integer | with null | Currently not used. |
| domain | varchar(50) | with null | |
| folder | nvarchar(64) | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| rate_plan_id | usm_subscription_detail | rate_plan_id |
| rate_plan_id | usm_rateplan_inheritance | derived_id |
| rate_plan_id | usm_rateplan_inclusion | parent_id |
| rate_plan_id | usm_offering_rateplan_inclusion | child_id |
| rate_plan_id | usm_offering_ratedef_inclusion | rate_plan_id |
| rate_plan_id | usm_rate_definition | rate_plan_id |