1007600125.08 GSMUS gsm_user - User Table yes no yes no yes yes 1007600126.08 1007600125.08 1 GSMUS yes user_login_name yes yes no no 0 gsm_user ICFDB 500378.24 1007600125.08 2 GSMGA no GSMUS user_obj,user_obj yes yes no no 0 gsm_group_allocation ICFDB 964088.24 1007600125.08 3 GSMUL no GSMUS user_obj,user_obj yes yes no no 0 gsm_user_allocation ICFDB gsm_user icfdb XAK2gsm_user,1,0,0,user_login_name,0 XIE10gsm_user,0,0,0,security_group,0 XIE1gsm_user,0,0,0,user_full_name,0 XIE2gsm_user,0,0,0,profile_user,0,user_full_name,0 XIE3gsm_user,0,0,0,external_userid,0 XIE4gsm_user,0,0,0,user_password,0 XIE6gsm_user,0,0,0,default_login_company_obj,0 XIE7gsm_user,0,0,0,user_category_obj,0 XIE8gsm_user,0,0,0,created_from_profile_user_obj,0 XIE9gsm_user,0,0,0,language_obj,0 XPKgsm_user,1,1,0,user_obj,0 user_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 User obj User obj user_category_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 User category obj User category obj user_full_name character 0 X(70) User full name User full name user_login_name character 0 X(15) User login name User login name user_creation_date date 0 99/99/9999 10/21/2003 User creation date User creation date user_creation_time integer 0 >>>>9 0 User creation time User creation time profile_user logical 0 YES/NO NO Profile user Profile user created_from_profile_user_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Created from profile user obj Created from profile user obj external_userid integer 0 ->>>>>>>9 0 External userid External userid user_password character 0 X(35) User password User password password_minimum_length integer 0 ->9 0 Password minimum length Password minimum length password_preexpired logical 0 YES/NO NO Password preexpired Password preexpired password_fail_count integer 0 ->>9 0 Password fail count Password fail count password_fail_date date 0 99/99/9999 Password fail date Password fail date password_fail_time integer 0 >>>>9 0 Password fail time Password fail time password_creation_date date 0 99/99/9999 Password creation date Password creation date password_creation_time integer 0 >>>>9 0 Password creation time Password creation time password_expiry_date date 0 99/99/9999 Password expiry date Password expiry date password_expiry_time integer 0 >>>>9 0 Password expiry time Password expiry time update_password_history logical 0 YES/NO NO Update password history Update password history check_password_history logical 0 YES/NO NO Check password history Check password history last_login_date date 0 99/99/9999 Last login date Last login date last_login_time integer 0 >>>>9 0 Last login time Last login time disabled logical 0 YES/NO NO Disabled Disabled language_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Language obj Language obj password_expiry_days integer 0 ->>9 0 Password expiry days Password expiry days maintain_system_data logical 0 YES/NO NO Maintain system data Maintain system data default_login_company_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Default login company obj Default login company obj user_email_address character 0 X(35) User email address User email address development_user logical 0 YES/NO NO Development user Development user security_group logical 0 YES/NO NO Security group Security group default_security_group logical 0 YES/NO NO Default security group Default security group gsm_group_allocation icfdb XAK1gsm_group_allocation,1,0,0,group_user_obj,0,user_obj,0,login_company_obj,0 XIE1gsm_group_allocation,0,0,0,user_obj,0 XIE2gsm_group_allocation,0,0,0,login_company_obj,0 XPKgsm_group_allocation,1,1,0,group_allocation_obj,0 group_allocation_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Group allocation obj Group allocation obj group_user_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Group user obj Group user obj user_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 User obj User obj login_company_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Login company obj Login company obj gsm_user_allocation icfdb XAK1gsm_user_allocation,1,0,0,user_allocation_obj,0 XIE1gsm_user_allocation,0,0,0,login_organisation_obj,0,user_obj,0,owning_entity_mnemonic,0,owning_obj,0 XIE2gsm_user_allocation,0,0,0,owning_entity_mnemonic,0,owning_obj,0,user_obj,0,login_organisation_obj,0 XIE3gsm_user_allocation,0,0,0,owning_entity_mnemonic,0,owning_obj,0,login_organisation_obj,0,user_obj,0 XIE4gsm_user_allocation,0,0,0,owning_obj,0 XPKgsm_user_allocation,1,1,0,user_obj,0,login_organisation_obj,0,owning_entity_mnemonic,0,owning_obj,0 user_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 User obj User obj login_organisation_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Login organisation obj Login organisation obj owning_entity_mnemonic character 0 X(8) Owning entity Owning entity owning_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 Owning obj Owning obj user_allocation_value1 character 0 X(70) User allocation value1 User allocation value1 user_allocation_value2 character 0 X(70) User allocation value2 User allocation value2 user_allocation_obj decimal 0 ->>>>>>>>>>>>>>>>>9.999999999 0.000000000 User allocation obj User allocation obj 22042 926 Admin User admin 07/19/99 58713 yes 0 0 0 no 0 ? 0 04/18/01 56716 ? 0 no no 10/21/03 33383 no 426 0 yes 1008000220.09 yes no no 3000004934.09 1004834867.09 anonymous anonymous 07/02/02 28476 no 0 0 0 no 0 ? 0 07/02/02 28476 ? 0 no no ? 0 yes 0 0 no 0 no no no