All offerings, offering is a service that can be subscribed to.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| offering_id | integer | not null | The unique id for each offering. |
| parent_id | integer | not null | The offering_id of the parent offering, -1 means this offering is the root offering, -2 means there is no parent offering. |
| base_offering | integer | not null | 1=not inherited, other wise points to an offering_id |
| top_base_offering | integer | not null | 1=not inherited, other wise points to an offering_id |
| status | integer | not null | 0=deleted, 1=available, 2=unavailable, 3=created, 4=cancelled |
| date_available | date | with null | Set when status=1 |
| date_unavailable | date | with null | Set when status=2 |
| date_created | date | not null | Set when status=3 |
| date_cancelled | date | with null | Set when status=4 |
| code | nvarchar(64) | with null | SP/ST supplies code |
| offering_name | nvarchar(128) | not null | Name of the offering |
| description | nvarchar(512) | with null | Description of the offering shown only in the catalog and no where else. |
| info_link | nvarchar(128) | with null | If it has a value in the form of a URL, a link will show up saying "more..." whenever viewing the offering through the gui. |
| notes_id | integer | with null | Currently not used. |
| selection_type | integer | with null | 0=none, 1=multiple. Setting this to 1 also allows a check box to appear to subscribe in the gui |
| is_leaf | integer | with null | 0=a node in the offering tree, 1=a leaf in the offering tree (ie: no children) |
| sort_order_type | integer | not null | 0=no sorting, 1=sort by offering_name, 2=by selection_type, 3=by code, 4=by created_date, 5=custom (ie: a sorting number will be added to sort_order_no. |
| sort_order_no | integer | not null | if sort_order_type=5 then this will have an integer value for the order in the sorted list. |
| sort_order | integer | not null | 0=ascending, 1=descending |
| sub_note_control | integer | with null | Currently not used. |
| image_file | nvarchar(64) | with null | Name of image file to be display when viewing offering. |
| domain | varchar(50) | not null | Domain to which the offering belongs. |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| offering_id | usm_subscription_detail | offering_id |
| offering_id | usm_offering | parent_id |
| offering_id | usm_offering_rateplan_inclusion | parent_id |
| offering_id | usm_offering_ratedef_inclusion | parent_id |