arg_join_member

Contains information about database join fields

Column Name Column Datatype Column Null Option Column Comment
join_name nvarchar(100) not null Join name. First part of the primary key. Foreign key to the arg_join_def table.
member_instance integer not null Instance number incremented for each field that is part of the join. Second part of the primary key.
left_side_table nvarchar(32) with null Optional table name for the left side of the join. First part of a foreign key to the arg_field_def table. Either table.field or value must be specified for the left side of the join.
left_side_field nvarchar(32) with null Optional field name for the left side of the join. Second part of a foreign key to the arg_field_def table. Either table.field or value must be specified for the left side of the join.
left_side_value nvarchar(255) with null Optional field value for the left side of the join. Either table.field or value must be specified for the left side of the join.
right_side_table nvarchar(32) with null Optional table name for the right side of the join. First part of a foreign key to the arg_field_def table. Either table.field or value must be specified for the right side of the join.
right_side_field nvarchar(32) with null Optional field name for the right side of the join. Second part of a foreign key to the arg_field_def table. Either table.field or value must be specified for the right side of the join.
right_side_value nvarchar(255) with null Optional field value for the right side of the join. Either table.field or value must be specified for the right side of the join.
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.

Product Name: Unicenter Asset Portfolio Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.