Table s_user

Description:
List of users

PRIMARY KEY
s_user_id_c varchar (20) NOT NULL	This identifies who the current user is

s_email_address_c varchar (100)
s_first_name_c varchar (64)
s_last_name_c varchar (64)
s_password_hash_c varchar (64)	The .NET hash value of the user's salted password
s_password_salt_c varchar (64)	The salt value used to hide the password even more (cannot recognise 2 same passwords)
s_password_needs_change_l boolean default: '0'	Forces change of password at next login. Set by either Petra 2.2 installation or if the SYSADMIN changes a password for a user (not yet implemented)
s_failed_logins_i integer default: 0
s_retired_l boolean default: '0'
s_last_login_time_i integer default: 0
s_last_login_date_d date	The date the user last logged in.
s_language_code_c varchar (20) default: '99'	This is the code used to identify a language.
s_can_modify_l boolean default: '1'	This defines if the code can be modified
s_record_delete_l boolean default: '0'
s_acquisition_code_c varchar (16)	This code identifies the method of aquisition.
a_default_ledger_number_i integer default: 0	This is used as a key field in most of the accounting system files
s_failed_login_time_i integer default: 0	The last time a user failed to log in
s_failed_login_date_d date	The last date a user failed to log in.
p_partner_key_n bigint default: NULL	If the user has a Partner record this is the key to it	p_partner
s_date_created_d date default: CURRENT_DATE	The date the record was created.
s_created_by_c varchar (20)	User ID of who created this record.
s_date_modified_d date	The date the record was modified.
s_modified_by_c varchar (20)	User ID of who last modified this record.
s_modification_id_t timestamp	This identifies the current version of the record.
FOREIGN KEY s_user_fk1: p_partner_key_n => p_partner
REFERENCED BY p_language, p_language, a_frequency, a_frequency, p_international_postal_type, p_international_postal_type, p_country, p_country, a_currency, a_currency, s_form, s_form, s_group, s_group, s_user_group, s_user_group, s_user_group, s_module, s_module, s_valid_output_form, s_valid_output_form, s_group_module_access_permission, s_group_module_access_permission, s_group_table_access_permission, s_group_table_access_permission, s_user_module_access_permission, s_user_module_access_permission, s_user_module_access_permission, s_user_table_access_permission, s_user_table_access_permission, s_user_table_access_permission, s_language_specific, s_language_specific, s_login, s_login, s_logon_message, s_logon_message, s_patch_log, s_patch_log, s_patch_log, s_reports_to_archive, s_reports_to_archive, s_system_status, s_system_status, s_system_status, s_user_defaults, s_user_defaults, s_user_defaults, s_system_defaults, s_system_defaults, s_error_log, s_error_log, s_error_log, p_partner_status, p_partner_status, p_acquisition, p_acquisition, p_addressee_type, p_addressee_type, p_title, p_title, p_partner_classes, p_partner_classes, p_partner, p_partner, p_recent_partners, p_recent_partners, p_recent_partners, p_partner_graphic, p_partner_graphic, p_location, p_location, p_location_type, p_location_type, p_partner_location, p_partner_location, p_partner_attribute_type, p_partner_attribute_type, p_partner_attribute, p_partner_attribute, u_unit_type, u_unit_type, p_unit, p_unit, um_unit_structure, um_unit_structure, p_family, p_family, pt_marital_status, pt_marital_status, p_occupation, p_occupation, p_person, p_person, p_denomination, p_denomination, p_church, p_church, p_business, p_business, p_organisation, p_organisation, p_bank, p_bank, p_venue, p_venue, p_banking_type, p_banking_type, p_banking_details, p_banking_details, p_partner_banking_details, p_partner_banking_details, p_banking_details_usage_type, p_banking_details_usage_type, p_banking_details_usage, p_banking_details_usage, p_partner_tax_deductible_pct, p_partner_tax_deductible_pct, a_ep_account, a_ep_account, a_ep_statement, a_ep_statement, a_ep_match, a_ep_match, a_ep_transaction, a_ep_transaction, p_type, p_type, p_type_category, p_type_category, p_partner_type, p_partner_type, p_relation_category, p_relation_category, p_relation, p_relation, p_partner_relationship, p_partner_relationship, p_partner_ledger, p_partner_ledger, m_extract_master, m_extract_master, m_extract_master, m_extract, m_extract, m_extract_type, m_extract_type, m_extract_parameter, m_extract_parameter, p_mailing, p_mailing, p_address_layout_code, p_address_layout_code, p_address_layout, p_address_layout, p_address_element, p_address_element, p_address_line, p_address_line, p_addressee_title_override, p_addressee_title_override, p_customised_greeting, p_customised_greeting, p_customised_greeting, p_formality, p_formality, p_label, p_label, p_merge_form, p_merge_form, p_merge_field, p_merge_field, p_postcode_range, p_postcode_range, p_postcode_region, p_postcode_region, p_publication, p_publication, p_publication_cost, p_publication_cost, p_reason_subscription_given, p_reason_subscription_given, p_reason_subscription_cancelled, p_reason_subscription_cancelled, p_subscription, p_subscription, p_contact_attribute, p_contact_attribute, p_contact_attribute_detail, p_contact_attribute_detail, p_method_of_contact, p_method_of_contact, p_partner_contact, p_partner_contact, p_partner_contact, p_partner_contact_attribute, p_partner_contact_attribute, a_sub_system, a_sub_system, a_tax_type, a_tax_type, a_ledger, a_ledger, a_tax_table, a_tax_table, a_ledger_init_flag, a_ledger_init_flag, a_budget_type, a_budget_type, a_account, a_account, a_account_property_code, a_account_property_code, a_account_property, a_account_property, a_account_hierarchy, a_account_hierarchy, a_account_hierarchy_detail, a_account_hierarchy_detail, a_cost_centre_types, a_cost_centre_types, a_cost_centre, a_cost_centre, a_valid_ledger_number, a_valid_ledger_number, a_budget_revision, a_budget_revision, a_budget, a_budget, a_budget_period, a_budget_period, a_accounting_period, a_accounting_period, a_accounting_system_parameter, a_accounting_system_parameter, a_analysis_store_table, a_analysis_store_table, a_analysis_type, a_analysis_type, a_analysis_attribute, a_analysis_attribute, a_corporate_exchange_rate, a_corporate_exchange_rate, a_daily_exchange_rate, a_daily_exchange_rate, p_email, p_email, a_email_destination, a_email_destination, a_fees_payable, a_fees_payable, a_fees_receivable, a_fees_receivable, a_form, a_form, a_form_element_type, a_form_element_type, a_form_element, a_form_element, a_freeform_analysis, a_freeform_analysis, a_general_ledger_master, a_general_ledger_master, a_general_ledger_master_period, a_general_ledger_master_period, a_ich_stewardship, a_ich_stewardship, a_method_of_giving, a_method_of_giving, a_method_of_payment, a_method_of_payment, a_motivation_group, a_motivation_group, a_motivation_detail, a_motivation_detail, a_motivation_detail_fee, a_motivation_detail_fee, a_processed_fee, a_processed_fee, a_transaction_type, a_transaction_type, a_recurring_batch, a_recurring_batch, a_recurring_batch, a_recurring_journal, a_recurring_journal, a_recurring_transaction, a_recurring_transaction, a_recurring_transaction, a_recurring_trans_anal_attrib, a_recurring_trans_anal_attrib, a_recurring_gift_batch, a_recurring_gift_batch, a_recurring_gift, a_recurring_gift, a_recurring_gift_detail, a_recurring_gift_detail, a_gift_batch, a_gift_batch, a_gift, a_gift, a_gift_detail, a_gift_detail, a_batch, a_batch, a_journal, a_journal, a_transaction, a_transaction, a_trans_anal_attrib, a_trans_anal_attrib, a_suspense_account, a_suspense_account, a_special_trans_type, a_special_trans_type, a_system_interface, a_system_interface, a_currency_language, a_currency_language, a_ap_supplier, a_ap_supplier, a_ap_document, a_ap_document, a_crdt_note_invoice_link, a_crdt_note_invoice_link, a_ap_document_detail, a_ap_document_detail, a_ap_payment, a_ap_payment, a_ap_payment, a_ap_document_payment, a_ap_document_payment, a_ep_payment, a_ep_payment, a_ep_payment, a_ep_document_payment, a_ep_document_payment, a_ap_anal_attrib, a_ap_anal_attrib, a_ar_category, a_ar_category, a_ar_article, a_ar_article, a_ar_article_price, a_ar_article_price, a_ar_discount, a_ar_discount, a_ar_discount_per_category, a_ar_discount_per_category, a_ar_default_discount, a_ar_default_discount, a_ar_invoice, a_ar_invoice, a_ar_invoice_detail, a_ar_invoice_detail, a_ar_invoice_discount, a_ar_invoice_discount, a_ar_invoice_detail_discount, a_ar_invoice_detail_discount, pt_applicant_status, pt_applicant_status, pt_application_type, pt_application_type, pt_contact, pt_contact, pm_general_application, pm_general_application, pm_general_application, pm_application_status_history, pm_application_status_history, pt_special_applicant, pt_special_applicant, pt_leadership_rating, pt_leadership_rating, pt_arrival_point, pt_arrival_point, pt_outreach_preference_level, pt_outreach_preference_level, pt_congress_code, pt_congress_code, pt_travel_type, pt_travel_type, pm_short_term_application, pm_short_term_application, pm_year_program_application, pm_year_program_application, pm_document_category, pm_document_category, pm_document_type, pm_document_type, pm_document, pm_document, pt_passport_type, pt_passport_type, pm_passport_details, pm_passport_details, pt_language_level, pt_language_level, pm_person_language, pm_person_language, pm_past_experience, pm_past_experience, pt_ability_area, pt_ability_area, pt_ability_level, pt_ability_level, pm_person_ability, pm_person_ability, pt_qualification_area, pt_qualification_area, pt_qualification_level, pt_qualification_level, pm_person_qualification, pm_person_qualification, pt_skill_category, pt_skill_category, pt_skill_level, pt_skill_level, pm_person_skill, pm_person_skill, pm_formal_education, pm_formal_education, pt_driver_status, pt_driver_status, pm_personal_data, pm_personal_data, p_data_label, p_data_label, p_data_label_use, p_data_label_use, p_data_label_value_partner, p_data_label_value_partner, p_data_label_value_application, p_data_label_value_application, p_data_label_lookup_category, p_data_label_lookup_category, p_data_label_lookup, p_data_label_lookup, pm_person_evaluation, pm_person_evaluation, pm_person_absence, pm_person_absence, pm_special_need, pm_special_need, pm_staff_data, pm_staff_data, pm_commitment_status, pm_commitment_status, pm_person_commitment_status, pm_person_commitment_status, pt_position, pt_position, um_job, um_job, um_job_requirement, um_job_requirement, um_job_language, um_job_language, um_job_qualification, um_job_qualification, pt_assignment_type, pt_assignment_type, pt_leaving_code, pt_leaving_code, pm_job_assignment, pm_job_assignment, um_unit_ability, um_unit_ability, um_unit_language, um_unit_language, um_unit_cost, um_unit_cost, um_unit_evaluation, um_unit_evaluation, pc_conference, pc_conference, pc_cost_type, pc_cost_type, pc_conference_option_type, pc_conference_option_type, pc_conference_option, pc_conference_option, pc_discount_criteria, pc_discount_criteria, pc_discount, pc_discount, pc_attendee, pc_attendee, pc_conference_cost, pc_conference_cost, pc_extra_cost, pc_extra_cost, pc_early_late, pc_early_late, pc_group, pc_group, pc_supplement, pc_supplement, pc_building, pc_building, pc_room, pc_room, pc_room_alloc, pc_room_alloc, pc_room_attribute_type, pc_room_attribute_type, pc_room_attribute, pc_room_attribute, pc_conference_venue, pc_conference_venue, ph_room_booking, ph_room_booking, ph_booking, ph_booking, p_tax, p_tax, p_interest_category, p_interest_category, p_interest, p_interest, p_partner_interest, p_partner_interest, p_partner_merge, p_partner_merge, p_partner_merge, p_reminder_category, p_reminder_category, p_partner_reminder, p_partner_reminder, p_partner_reminder, p_partner_reminder, p_partner_field_of_service, p_partner_field_of_service, p_partner_short_code, p_partner_short_code, p_process, p_process, p_state, p_state, p_action, p_action, p_partner_state, p_partner_state, p_partner_action, p_partner_action, p_partner_action, p_partner_action, p_first_contact, p_first_contact, a_key_focus_area, a_key_focus_area, s_group_function, s_group_function, s_function, s_function, s_job_group, s_job_group, s_group_partner_set, s_group_partner_set, p_partner_set, p_partner_set, p_partner_set_partner, p_partner_set_partner, s_group_gift, s_group_gift, s_group_motivation, s_group_motivation, s_group_partner_contact, s_group_partner_contact, s_group_partner_reminder, s_group_partner_reminder, s_group_location, s_group_location, s_group_partner_location, s_group_partner_location, s_group_data_label, s_group_data_label, s_group_ledger, s_group_ledger, s_group_cost_centre, s_group_cost_centre, s_group_extract, s_group_extract, s_change_event, s_change_event, s_label, s_label, p_partner_comment, p_partner_comment, p_proposal_submission_type, p_proposal_submission_type, p_foundation, p_foundation, p_foundation_proposal_status, p_foundation_proposal_status, p_foundation_proposal, p_foundation_proposal, p_foundation_proposal_detail, p_foundation_proposal_detail, p_foundation_deadline, p_foundation_deadline, s_workflow_definition, s_workflow_definition, s_workflow_user, s_workflow_user, s_workflow_user, s_workflow_group, s_workflow_group, s_workflow_step, s_workflow_step, s_function_relationship, s_function_relationship, s_workflow_instance, s_workflow_instance, s_workflow_instance_step, s_workflow_instance_step, s_workflow_instance_step, p_file_info, p_file_info, p_partner_file, p_partner_file, pm_person_file, pm_person_file, p_partner_contact_file, p_partner_contact_file, pm_document_file, pm_document_file, pm_application_file, pm_application_file, s_volume, s_volume, s_default_file_volume, s_default_file_volume, s_volume_partner_group, s_volume_partner_group, s_volume_partner_group_partner, s_volume_partner_group_partner, s_group_file_info, s_group_file_info