arg_query_def

Contains information about query definitions

Column Name Column Datatype Column Null Option Column Comment
query_id integer not null Query Identifier. First part of the primary key.
instance smallint not null Query Instance. Second part of the primary key.
protected smallint with null Protected
category integer with null Category
title nvarchar(255) with null Title
export_name nvarchar(255) with null Export table/file name.
description nvarchar(255) with null Description
definition nvarchar(3000) with null Definition
export_type smallint with null Export type. 0=None, 1=Table, 2=CSV, 3=View
refresh_interval smallint with null Refresh interval
last_refresh_date date with null Last refresh date
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Creation date
last_update_user nvarchar(64) with null Last update user
last_update_date integer with null Last update date
version_number integer with null Version number

Product Name: Unicenter Asset Portfolio Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.