arg_extension_rule_def

Contains information about database extensions

Column Name Column Datatype Column Null Option Column Comment
rule_id integer not null Rule ID. Primary key.
rule_name nvarchar(100) with null Rule name. Unique.
rule_description nvarchar(255) with null Rule description.
table_name nvarchar(32) with null Table name for which the extension has taken place. Foreign key to the arg_table_def table. First part of a foreign key to arg_field_def table.
field_name nvarchar(32) with null Field name for which the extension has taken place. Optional. Second part of a foreign key to arg_field_def table.
field_value nvarchar(255) with null Optional field value field extension has taken place. (e.g. "0" for Software, "1", for Hardware for the resource family field)
ext_table_name nvarchar(32) with null Extended table name.
creation_user nvarchar(64) with null User or process who created the record.
creation_date integer with null Date the record was created.
last_update_user nvarchar(64) with null User or process who 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


Copyright © 2006 CA. All rights reserved.