Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## Table description

> This table defines login companies (organizations) and provides a list of valid companies the user can log into at run time.

> You can link this table into an external application database where additional details are stored for the login company, such as address and contact information. The code or the object field could be used as the cross-reference into the external application database. The Progress Dynamics framework uses this table in the generic setup of framework data specific to login companies, such as security allocations and automatic reference numbers.

> The existence of a login company in the framework supports the concept of holding application data for multiple companies in a single database, instead of having separate databases for each company. Application databases have to link to this table, or a corresponding table in their database design, to filter appropriate data for each login company.

> Table 18–5 lists the table’s FLA, fields, and foreign keys.

> Table 18–5: gsm_login_company table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gsmlg | login_company_obj (Decimal) login_company_code (Character) login_company_short_name (Character) login_company_name (Character) login_company_email (Character) login_company_disabled (Logical) | login_company_obj

> Table 18–6 gives details of the table’s indexes.

> Table 18–6: gsm_login_company index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgsm_login_company | login_company_obj | Primary Unique
> XAK1gsm_login_company | login_company_code | Unique
> XIE1gsm_login_company | login_company_short_name | Nonunique
> XIE2gsm_login_company | login_company_name | Nonunique

> This table only holds the minimum details required by the framework. In order to simplify and synchronize maintenance of this data, applications that also have an organization table should replicate modifications from their full organization table into this table.

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