Queue item is used for inter process distributed communication, a request is posted to the queue_item and it is picked up by the any of the distributed servers. Eg: When a bill run is scheduled using the UI, a queue_item is posted, and any of the billing services can pick this up and handle it on the FCFS basis.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| queue_item_id | integer | not null | The unique id for the queue item |
| created_time | date | not null | Created time stamp for this item |
| priority_no | integer | not null | Priority for the item |
| status | integer | not null | Status of the item |
| type | varchar(50) | not null | |
| queue_item_name | nvarchar(50) | not null | Name of this component |
| group_id | varchar(256) | not null | |
| owner | nvarchar(128) | with null | |
| start_time | date | with null | |
| end_time | date | with null | |
| delete_item | integer | not null | |
| deleted_time | date | with null | |
| item_comment | nvarchar(128) | with null | |
| data1 | nvarchar(512) | with null | |
| data2 | nvarchar(512) | with null | |
| data3 | nvarchar(128) | with null |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| queue_item_id created_time |
usm_queue_item_detail | queue_item_id created_time |