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)
Hash value of the user's Salted password
s_password_salt_c
varchar (64)
The Salt value used for hashing the password (two identical passwords will not yield the same Hash value with different Salt values)
s_pwd_scheme_version_i
integer default: 1
Version Number of the password hashing scheme (source code gives details about what algorithm/parameters combination is used for each number).
s_password_needs_change_l
boolean default: '0'
Forces change of password at next login. Set when the SYSADMIN changes a password for a user. Also, data migration from legacy system will set this. Further to this it can *optionally* be set if a new password hashing scheme got introduced and the user should be forced to change to it by means of an enforced password change.
s_failed_logins_i
integer default: 0
s_account_locked_l
boolean 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_password_reset_token_c
varchar (64)
If this token is set and it is still valid, then the user can reset his password using this token
s_password_reset_valid_until_d
date
The date until the password reset token is valid
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_session, s_session,
s_user_account_activity, s_user_account_activity, 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_report_template,
s_report_template, 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_system_defaults_gui,
s_system_defaults_gui, 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_location,
p_location, p_location_type, p_location_type,
p_partner_attribute_category, p_partner_attribute_category, p_partner_attribute_type,
p_partner_attribute_type, u_unit_type, u_unit_type,
pt_marital_status, pt_marital_status, p_occupation,
p_occupation, p_denomination, p_denomination,
p_business, p_business, p_banking_type,
p_banking_type, p_banking_details_usage_type, p_banking_details_usage_type,
p_type_category, p_type_category, p_type,
p_type, p_relation_category, p_relation_category,
p_relation, p_relation, m_extract_type,
m_extract_type, m_extract_master, m_extract_master,
m_extract_master, 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_block, p_address_block, p_address_element,
p_address_element, p_address_block_element, p_address_block_element,
p_address_line, p_address_line, p_addressee_title_override,
p_addressee_title_override, 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_postcode_region_range, p_postcode_region_range,
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_contact_attribute,
p_contact_attribute, p_contact_attribute_detail, p_contact_attribute_detail,
p_method_of_contact, p_method_of_contact, p_contact_log,
p_contact_log, p_contact_log, p_partner_contact_attribute,
p_partner_contact_attribute, p_form, p_form,
p_form, 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_property_code, a_account_property_code,
a_cost_centre_types, a_cost_centre_types, a_cost_centre,
a_cost_centre, a_budget_revision, a_budget_revision,
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_corporate_exchange_rate,
a_corporate_exchange_rate, a_daily_exchange_rate, a_daily_exchange_rate,
p_email, p_email, 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_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_recurring_batch, a_recurring_batch, a_recurring_batch,
a_batch, a_batch, a_revaluation,
a_revaluation, a_special_trans_type, a_special_trans_type,
a_system_interface, a_system_interface, a_currency_language,
a_currency_language, 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, pt_applicant_status, pt_applicant_status,
pt_application_type, pt_application_type, pt_contact,
pt_contact, 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_document_category, pm_document_category,
pm_document_type, pm_document_type, pt_passport_type,
pt_passport_type, pt_language_level, pt_language_level,
pt_ability_area, pt_ability_area, pt_ability_level,
pt_ability_level, pt_qualification_area, pt_qualification_area,
pt_qualification_level, pt_qualification_level, pt_skill_category,
pt_skill_category, pt_skill_level, pt_skill_level,
p_data_label_lookup_category, p_data_label_lookup_category, p_data_label,
p_data_label, p_data_label_use, p_data_label_use,
p_data_label_lookup, p_data_label_lookup, pm_commitment_status,
pm_commitment_status, pt_position, pt_position,
pt_assignment_type, pt_assignment_type, pc_cost_type,
pc_cost_type, pc_conference_option_type, pc_conference_option_type,
pc_discount_criteria, pc_discount_criteria, pc_room_attribute_type,
pc_room_attribute_type, p_interest_category, p_interest_category,
p_interest, p_interest, p_reminder_category,
p_reminder_category, p_process, p_process,
p_state, p_state, p_action,
p_action, p_first_contact, p_first_contact,
p_partner, p_partner, p_recent_partners,
p_recent_partners, p_recent_partners, p_partner_location,
p_partner_location, p_partner_attribute, p_partner_attribute,
p_unit, p_unit, um_unit_structure,
um_unit_structure, p_family, p_family,
p_person, p_person, p_church,
p_church, p_organisation, p_organisation,
p_bank, p_bank, p_venue,
p_venue, p_banking_details, p_banking_details,
p_partner_banking_details, p_partner_banking_details, p_banking_details_usage,
p_banking_details_usage, p_partner_tax_deductible_pct, p_partner_tax_deductible_pct,
p_partner_type, p_partner_type, p_partner_relationship,
p_partner_relationship, p_partner_ledger, p_partner_ledger,
m_extract, m_extract, p_customised_greeting,
p_customised_greeting, p_customised_greeting, p_subscription,
p_subscription, p_partner_contact, p_partner_contact,
a_account, a_account, a_ep_statement,
a_ep_statement, a_account_property, a_account_property,
a_account_hierarchy, a_account_hierarchy, a_account_hierarchy_detail,
a_account_hierarchy_detail, a_valid_ledger_number, a_valid_ledger_number,
a_budget, a_budget, a_budget_period,
a_budget_period, a_analysis_attribute, a_analysis_attribute,
a_email_destination, a_email_destination, a_fees_payable,
a_fees_payable, a_fees_receivable, a_fees_receivable,
a_general_ledger_master, a_general_ledger_master, a_general_ledger_master_period,
a_general_ledger_master_period, a_motivation_detail, a_motivation_detail,
a_ep_account, a_ep_account, a_ep_match,
a_ep_match, a_ep_transaction, a_ep_transaction,
a_motivation_detail_fee, a_motivation_detail_fee, a_transaction_type,
a_transaction_type, 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_processed_fee,
a_processed_fee, a_journal, a_journal,
a_transaction, a_transaction, a_trans_anal_attrib,
a_trans_anal_attrib, a_suspense_account, a_suspense_account,
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_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, pm_general_application, pm_general_application,
pm_general_application, pm_application_status_history, pm_application_status_history,
pm_short_term_application, pm_short_term_application, pm_year_program_application,
pm_year_program_application, pm_document, pm_document,
pm_passport_details, pm_passport_details, pm_person_language,
pm_person_language, pm_past_experience, pm_past_experience,
pm_person_ability, pm_person_ability, pm_person_qualification,
pm_person_qualification, pm_person_skill, pm_person_skill,
pm_formal_education, pm_formal_education, pm_personal_data,
pm_personal_data, p_data_label_value_partner, p_data_label_value_partner,
p_data_label_value_application, p_data_label_value_application, 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_person_commitment_status, pm_person_commitment_status,
um_job, um_job, um_job_requirement,
um_job_requirement, um_job_language, um_job_language,
um_job_qualification, um_job_qualification, 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_conference_option,
pc_conference_option, 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, pc_room_attribute, pc_conference_venue,
pc_conference_venue, ph_booking, ph_booking,
ph_room_booking, ph_room_booking, p_tax,
p_tax, p_partner_interest, p_partner_interest,
p_partner_merge, p_partner_merge, p_partner_merge,
p_partner_reminder, p_partner_reminder, p_partner_reminder,
p_partner_reminder, p_partner_gift_destination, p_partner_gift_destination,
p_partner_short_code, p_partner_short_code, p_partner_state,
p_partner_state, p_partner_action, p_partner_action,
p_partner_action, p_partner_action, s_function,
s_function, s_group_function, s_group_function,
s_job_group, s_job_group, p_partner_set,
p_partner_set, s_group_partner_set, s_group_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, s_volume,
s_volume, p_file_info, p_file_info,
p_partner_graphic, p_partner_graphic, 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_partner_group, s_volume_partner_group, s_default_file_volume,
s_default_file_volume, s_volume_partner_group_partner, s_volume_partner_group_partner,
s_group_file_info, s_group_file_info