ca_site

A classification of location information

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) Numeric 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 Text name of this item
alias nvarchar(30) with null The alias value for this ca_site.
creation_user nvarchar(64) with null The name of the person who created this record. Should be in form: LastName, FirstName
creation_date integer with null The timestamp indicating when this record was created
last_update_user nvarchar(64) with null Specifies the contact who last modified this record. Should be in form: LastName, FirstName
last_update_date integer with null Timestamp of when this record was last modified
version_number integer with null The version number value for this ca_site.
description nvarchar(255) with null Textual description of this entry
contact_uuid byte(16) with null The contact value for this ca_site.
exclude_registration integer with null The exclude registration value for this ca_site.
delete_time integer with null The delete time value for this ca_site.

Product Name: Asset

Table Type: Table


Copyright © 2006 CA. All rights reserved.