ca_resource_department

Contains information about the departments which can be assigned to an asset

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. Resource department 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 Department name. Unique.
description nvarchar(255) with null Department description.
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.
exclude_registration integer with null Exclude Registration
delete_time integer with null Delete Time

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.