ca_resource_family

Contains information about the family types that an asset can be grouped within

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. Resource family id.
inactive integer not null Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive)
name nvarchar(100) not null Family name. Unique.
table_extension_name nvarchar(30) with null Name of the associated table to hold extended data for this family.
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.
description nvarchar(255) with null Family description.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time
include_reconciliation integer not null Flag representing whether to include this family in reconciliation.

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.