Contains information about database field definitions
| Column Name | Column Datatype | Column Null Option | Column Comment |
| table_name | nvarchar(32) | not null | Name of the table. First part of the primary key. Foreign key to the arg_table_def table. |
| field_name | nvarchar(32) | not null | Name of the field. Second part of the primary key. Unique within table. |
| field_description | nvarchar(255) | with null | Field description. |
| additional_info | nvarchar(255) | with null | Additional notes. |
| actual_table_name | nvarchar(32) | with null | Actual name of the physical table used in a view definition. Foreign key to the arg_table_def table for records representing views. |
| actual_field_name | nvarchar(32) | with null | Actual name of the physical field used in a view definition. |
| data_type | smallint | with null | Enumerated constant specifying the datatype of the field. |
| data_size | smallint | with null | Size of the field. |
| field_unique | smallint | with null | Flag representing whether the field requires unique values. 0=False (not unique), 1=True (unique) |
| field_required | smallint | with null | Flag representing whether the field is required. 0=False (not required), 1=True (required) |
| primary_key | smallint | with null | Flag representing whether this field is part of the primary key of this table. 0=False (not a primary key field), 1=True (primary key field) |
| foreign_key | smallint | with null | Flag representing whether this field is a foreign key to another table. 0=False (not a foreign key field), 1=True (foreign key field) |
| extended | smallint | with null | Flag representing whether this field was created by the user. 0=False (not extended), 1=True (extended) |
| generate_reminder | smallint | with null | Flag representing whether this field can be used to generate reminders. 0=False (no reminders), 1=True (reminders) |
| generate_event | smallint | with null | Flag representing whether this field can be used to generate events. 0=False (no events), 1=True (events) |
| auditable | smallint | with null | Flag representing whether this field can be tracked with audits. 0=False (no audits), 1=True (audits) |
| attribute_popup | smallint | with null | Flag representing whether this field has a popup button associated with it. 0=False (not a popup), 1=True (popup) |
| attribute_autopopup | smallint | with null | Flag representing whether this field has an autopopup button associated with it. 0=False (not an autopopup), 1=True (autopopup) |
| attribute_formatted | smallint | with null | Flag representing whether this field has formatting associated with it. 0=False (not formatted), 1=True (formatted) |
| attribute_hidden | smallint | with null | Flag representing whether this field is hidden. 0=False (not hidden), 1=True (hidden) |
| attribute_codedpopup | smallint | with null | Flag representing whether this field has a coded popup button associated with it. 0=False (not a coded popup), 1=True (coded popup) |
| attribute_audited | smallint | with null | Flag representing whether this field is being audited for changes. 0=False (not audited), 1=True (audited). |
| mass_change | smallint | with null | Flag representing whether this field is available for mass change. 0=False (no mass change), 1=True (mass change) |
| label_customizable | smallint | with null | Flag representing whether the label for attributes using this field can be customized. 0=False (not customizable), 1=True (customizable). |
| user_field | smallint | with null | Flag representing whether this field is a user field. 0=False (not user field), 1=True (user field). |
| report_included | smallint | with null | Flag representing whether this field can be included in a report. 0=False (not included), 1=True (included). |
| lookup_included | nvarchar(30) | with null | List of object id's for which this field can be included in a lookup results list. |
| list_id | integer | with null | List ID. Foreign key to the arg_listdef table for fields which have an associated list. |
| 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 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. |
| instance | smallint | with null | |
| location_type_id | integer | with null | Foreign key to the id field of the ca_location_type table for location type (i.e. manufacturer, vendor, publisher, internal, external). |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table