Client table fields

Client	Functional Security	Content Security	HR
Link	Link	Link	Link

Contents

1 Overview

The primary security table for individual users in bxp is called the "Client" table. This stores the details of users in the bxp system.

Paired with this table is the Security and the HR table. Security manages the functional access to the system linking it with the Id column of the client table. The HR table also links to the Id column of the client table.

Fields from this table are used throughout bxp.

They are listed here for reference purposes for replacement procedures.

2 Field reference

2.1 Account

Db field name	On Screen name	Notes
strClient_Title
strClient_Firstname
strClient_Surname
intClient_Status

2.2 Primary Contact

Db field name	On Screen name	Notes
strClient_CompanyStaffIdNumber	Company Staff Id Number	Comany Staff Id
strClient_Mobile	Work Contact Mobile	Used to SMS Staff
strClient_Phone	Work Contact Email	Used to email Staff
intClient_Department	Department	The Department or Team the Staff works in
intClient_Role	Role	The role of that staff member
strClient_CostCentre	Cost Centre	Please enter a cost centre name
strClient_IsChampion	Is System Champion	Will include the user on all System Champion notifications.
strClient_IsApprovedContact	Is Approved Contact	Will allow the user submit Change Requests.

2.3 Security Questions

Db field name	On Screen name	Notes
strClient_SecurityQuestion1	Security Question 1	Self service password, security question 1
strClient_SecurityQuestion2	Security Answer 1	Self service password, security question 1 answer
strClient_SecurityAnswer1	Security Question 2	Self service password, security question 2
strClient_SecurityAnswer2	Security Answer 2	Self service password, security question 2 answer

2.4 Primary Security Details

Db field name	On Screen name	Notes
strClient_IPRange	IP Range	If set the account will only be able to log in from this IP. Separate multiples with commas
strClient_ExternalId	External System Id	For use with the BEAPI
strClient_ExternalKey	External System Key	For use with the BEAPI
intClient_ForceLogout	Force Inactive Logout	After [selected] Minutes. For Data Protection usage
strClient_IsStudent	External Student Access	When IP restricted can user still access courses and conferences.
strClient_UrlRedirect	Alternate Login URL	Set an alternate destination for the user to be redirected to when they login to bxp
strClient_3rdPartyEngine	3rd Party Engine	If importing from or linking to a 3rd party solution, the name of that solution.
strClient_3rdPartyUserId	3rd Party User Id	The Id of the user to be used in that 3rd party solution.

2.5 Primary LDAP Details

Db field name	On Screen name	Notes
strClient_LdapHostAddress	Authorised ip addresses	IP addresses that are allowed connect to the LDAP server. Seperate multiple by ,
strClient_LdapHostPort	LDAP Host Address	The Host address of the LDAP server
strClient_LdapBaseDn	LDAP Host Port	Port the LDAP server will be listening on
strClient_LdapAuthorisedIp	LDAP Base Dn	The LDAP Servers Base Distinguished Name
strClient_LdapAdminUserName	LDAP Admin Username i.e	User name for the Read Only admin user created on the LDAP server
strClient_LdapAdminPassword	LDAP Admin Password	User name for the Read Only admin user created on the LDAP server
strClient_LdapMyUserName	LDAP My Username	User Name for the bxp users Active Directory account
strClient_LdapMyDomain	LDAP My Domain	Domain for the bxp users Active Directory account

2.6 Primary VOIP Details

Db field name	On Screen name	Notes
strClient_VOIP_ServerTechnology	Phone Server Technology	When IP restricted can user still access courses and conferences.
strClient_VOIP_ServerIP	Server IP	The IP Address of the phone system
strClient_VOIP_ServerPort	Server Port	The port the requests are sent to
strClient_VOIP_Extension	User Extension	The extension for this user
strClient_VOIP_PIN	User PIN	The PIN code for this user
strClient_AllowiFrame	Allow iFrame

2.7 Interface options

Db field name	On Screen name	Notes
strClient_HTMLVersion	HTML Version
strClient_SpeedInterface	Speed Interface
strClient_UsePresence	Use Presence
strClient_SystemLayout_MainMenu	Main Menu
strClient_SystemLayout_SectionMenu	Section Menu
strClient_SystemLayout_Page	Page
strClient_SystemLayout_BackgroundImage	Background Image
strClient_SystemLayout_CSS	CSS

2.8 Module Specific

Db field name	On Screen name	Notes
strClient_ListerOptions	Lister Options
strClient_ListerCategories	Lister Categories
strClient_ListerType1	Lister Type 1
strClient_ListerType2	Lister Type 2
strClient_ListerType3	Lister Type 3
strClient_ListerType4	Lister Type 4
strClient_RemindersPage	Reminders Page Options	In Reminders, add custom HTML code
strClient_LimitTimeTrackerCosting	Limit Time Tracker Costing	In Time Tracker, Only show work types that have pricing associated?

2.9 Security Information

Db field name	On Screen name	Notes
intClient_CreatedBy	Created By
dteClient_DateCreated	Created Date
intClient_LastEdited_ByWhom	Last Edited By
dteClient_LastEdited_LastDateTime	Last Edited Date
intClient_Retired_LastByWhom	Retired By
dteClient_Retired_LastDateTime	Retired Date
dteClient_LastLoginDateTime	Last Login Date Time
dteClient_CompanyStartDate	Company Start Date
dteClient_CompanyEndDate	Company End Date
dteClient_LastPasswordChangeDateTime	Last Password Change Date Time
dteClient_LastPresence	Last Presence Date Time
dteClient_Password_FirstFailDateTime	Password Fail - First Date Time
dteClient_Password_LastFailDateTime	Password Fail - Last Date Time

2.10 Custom User Global Variables

Db field name	On Screen name	Notes
strClient_CustomGlobalField_1	Custom Global Variable 1
strClient_CustomGlobalField_2	Custom Global Variable 2
strClient_CustomGlobalField_3	Custom Global Variable 3
strClient_CustomGlobalField_4	Custom Global Variable 4
strClient_CustomGlobalField_5	Custom Global Variable 5
strClient_CustomGlobalField_6	Custom Global Variable 6