Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gsm_user table — gsmus

> The `gsm_user` table is the central table of the User group. This table defines the users who can log into the system, in other words, the approved users of the system.

> Table 16–1 lists the table’s FLA, fields, and foreign keys.

> Table 16–1: gsm_user table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gsmus | user_obj (Decimal) user_category_obj (Decimal) user_full_name (Character) user_login_name (Character) user_creation_date (Date) user_creation_time (Integer) profile_user (Logical) created_from_profile_user_obj (Decimal) external_userid (Integer) user_password (Character) password_minimum_length (Integer) password_preexpired (Logical) password_fail_count (Integer) password_fail_date (Date) password_fail_time (Integer) password_creation_date (Date) password_creation_time (Integer) password_expiry_date (Date) password_expiry_time (Integer) update_password_history (Logical) check_password_history (Logical) last_login_date (Date) last_login_time (Integer) disabled (Logical) language_obj (Decimal) password_expiry_days (Integer) maintain_system_data (Logical) default_login_company_obj (Decimal) user_email_address (Character) development_user (Logical) security_group (Logical) default_security_group (Logical) | language_obj user_category_obj user_obj

> Table 16–2 gives details of the table’s indexes.

> Table 16–2: gsm_user index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgsm_user | user_obj | Primary Unique
> XAK2gsm_user | user_login_name | Unique
> XIE1gsm_user | user_full_name | Nonunique
> XIE2gsm_user | profile_user user_full_name | Nonunique
> XIE3gsm_user | external_userid | Nonunique
> XIE4gsm_user | user_password | Nonunique
> XIE6gsm_user | default_login_company_obj | Nonunique
> XIE7gsm_user | user_category_obj | Nonunique
> XIE8gsm_user | created_from_profile_user_ob | Nonunique
> XIE9gsm_user | language_obj | Nonunique
> XIE10gsm_user | security_group | Nonunique

> The main user details are contained in an external security system, pointed at by the `external_userid` field. This table defines extra user information for a system, and allows a user to be optionally associated with a person to enable the entering of other data, such as full name, address, and comments.

> There is a logged-in flag on the user record to enable the identification of user availability. Users are available if they are logged into the application.

> The existence of this specific user table in the Repository also aids automatic referential integrity.

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