Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gsc_instance_attribute table — gscia

> This table contains instance attributes used in the application. Instance attributes change the behavior of generic objects. For example, an application has a generic object that behaves differently in creditor and debtor systems. When the application runs, an instance attribute of creditor or debtor is posted to determine its instance-specific functionality.

> Table 7–3 lists the table’s FLA, fields, and foreign keys.

> Table 7–3: gsc_instance_attribute table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gscia | instance_attribute_obj (Decimal) attribute_code (Character) attribute_description (Character) disabled (Logical) system_owned (Logical) attribute_type (Character) | instance_attribute_obj

> Table 7–4 gives details of the table’s indexes.

> Table 7–4: gsc_instance_attribute index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgsc_instance_attribute | instance_attribute_obj | Primary Unique
> XAK1gsc_instance_attribute | attribute_code | Unique
> XAK2gsc_instance_attribute | attribute_type, attribute_code | Unique
> XIE1gsc_instance_attribute | attribute_description | Nonunique

> The instance attribute might be posted to the application by the menu option that launches the application or it might be hard-coded in the button that launches the application. For this reason, certain instance attributes are system-owned and cannot be maintained or deleted by users.

> When security structures such as field security are set up, they might be defined globally for a specific product, product module, or at an individual program level. The instance attribute is a level below the program level. It permits security settings for each instance of an application.

> Instance attributes can be used for reporting to allow reports to be printed directly from menu options. The instance attribute code must map to the `report_procedure_name` in the `report_definition` table. Whenever a report definition is created, an instance attribute should automatically be created to facilitate this functionality.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095