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_report_result, s_report_result, 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