ca_job_function

Contains a list of functions which can be assigned to a contact

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key. Job function 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 Job function name
description nvarchar(255) with null Job function 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.