Contains information about database table definitions
| Column Name | Column Datatype | Column Null Option | Column Comment |
| table_name | nvarchar(32) | not null | Name of the table. Primary key. Unique. |
| table_description | nvarchar(255) | with null | Table description. |
| database_name | nvarchar(100) | with null | Name of the database in which the table has been built. |
| subschema_name | nvarchar(100) | with null | Name of the subschema to which this table belongs. For universal tables this could be "CA." For ITRM tables this could be "ITRM." For specific products this could be "ARGUSER," "CAAMDB," or "AHD." |
| extended | smallint | with null | Flag representing whether this table was created by the user. 0=False (not extended), 1=True (extended) |
| virtual_table | smallint | with null | Flag representing whether this table is a physical table or virtual table, e.g. a view. 0=False (physical table), 1=True (virtual table or view) |
| inactive | smallint | with null | Flag representing whether this record is active or inactive. 0=False (Active), 1=True (Inactive) |
| creation_user | nvarchar(64) | with null | User or process who 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. |
Product Name: Unicenter Asset Portfolio Management
Table Type: Table