Contains information about task configurations. Task configurations include the processing options selected and actions to be performed by the reconciliation engine. A record is appended to this table when a task is defined.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| task_uuid | byte(16) | not null | Task uuid. Primary key. |
| task_name | nvarchar(100) | with null | Task Name |
| task_description | nvarchar(255) | with null | Task Description |
| match_indicator | smallint | with null | Flag representing match option setting. 0=None, 1=Manual, 2=Auto |
| add_assets_indicator | smallint | with null | Flag representing add assets option setting. 0=None, 1=Manual, 2=Auto |
| asset_changes_indicator | smallint | with null | Flag representing asset changes option setting. 0=None, 1=Manual, 2=Auto |
| own_resource_deletes_indicator | smallint | with null | Flag representing owned deleted option setting. 0=None, 1=Manual, 2=Auto |
| own_resource_deactiv_indicator | smallint | with null | Flag representing owned deactivated option setting. 0=None, 1=Manual, 2=Auto |
| discovery_deleted_indicator | smallint | with null | Flag representing discovery deleted option setting. 0=None, 1=Manual, 2=Auto |
| undo_match_indicator | smallint | with null | Flag representing undo match option setting. 0=None, 1=Manual |
| send_msg_to_queue_switch | smallint | with null | Flag representing whether or not to send messages to the queue. 0=False, 1=True |
| send_msg_to_event_log_switch | smallint | with null | Flag representing whether or not to send messages to the event log. 0=False, 1=True |
| send_msg_to_email_switch | smallint | with null | Flag representing whether or not to send messages to email. 0=False, 1=True |
| email_ids | nvarchar(255) | with null | List of email ID's. |
| watch_os_switch | smallint | with null | Flag representing whether or not to watch discovery operating system. 0=False, 1=True |
| watch_computer_name_switch | smallint | with null | Flag representing whether or not to watch discovery computer name. 0=False, 1=True |
| watch_capacity_indicator | smallint | with null | Flag representing which discovery capacity to watch. 0=None, 1=Memory, 2=Disk Space |
| load_capacity_indicator | smallint | with null | Flag representing which discovery capacity to load. 0=None, 1=Memory, 2=Disk Space |
| set_contact_switch | smallint | with null | Flag representing whether or not to set the contact. 0=False, 1=True |
| add_item_switch | smallint | with null | Flag representing whether or not to add an item during an asset add. 0=False, 1=True |
| item_translation_list_id | integer | with null | Foreign key to the ldid field of the arg_listdef table for the translation list used to translate item names. |
| os_translation_list_id | integer | with null | Foreign key to the ldid field of the arg_listdef table for the translation list used to translate operating system names. |
| new_asset_status | integer | with null | Foreign key to the id field of the ca_resource_status table for the status to be used for new assets. |
| missing_asset_status | integer | with null | Foreign key to the id field of the ca_resource_status table for the status to be used for missing assets. |
| deactivated_asset_status | integer | with null | Foreign key to the id field of the ca_resource_status table for the status to be used for deactivated assets. |
| external_sys_id | integer | with null | Foreign key to the dlkey field of the arg_drpdnlst table for the external system list. |
| locking_flag | smallint | with null | Flag representing whether or not this task is being locked by the engine. 0=False, 1=True |
| refresh_interval | integer | with null | Number of minutes to wait before refreshing the engine locking status. |
| last_refresh_date | date | with null | Last date the engine refreshed the locking status. |
| creation_user | nvarchar(64) | with null | User or process that created the record. |
| creation_date | integer | with null | Date the record was created. |
| last_update_user | nvarchar(64) | with null | User or process that last updated the record. |
| last_update_date | integer | with null | Date the record was last updated. |
| version_number | integer | with null | Version number for transaction integrity. |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table