Anonymous, bureaucrat, administrator
7,528
edits
Changes
m
== Primary Contact ==
== Security Questions ==
== Primary Security Details ==
== Primary LDAP Details ==
== Primary VOIP Details ==
== Custom User Global Variables ==
no edit summary
= 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.
= Field reference =
== Account ==
{| class="wikitable" style="width:100%;"
! style="width:60%" | Notes
|-
| strClient_Title || ||
|-
| strClient_Firstname || ||
|-
| strClient_Surname || ||
|-
| intClient_Status || ||
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | Notes
|-
| strClient_CompanyStaffIdNumber || Company Staff Id Number || Comany Comany Staff Id
|-
| strClient_Mobile || Work Contact Mobile || Used Used to SMS Staff
|-
| strClient_Phone || Work Contact Email || Used Used to email Staff
|-
| intClient_Department || Department || The The Department or Team the Staff works in
|-
| intClient_Role || Role || The The role of that staff member
|-
| strClient_CostCentre || Cost Centre || Please Please enter a cost centre name
|-
| strClient_IsChampion || Is System Champion || Will Will include the user on all System Champion notifications.
|-
| strClient_IsApprovedContact || Is Approved Contact || Will Will allow the user submit Change Requests.
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | Notes
|-
| strClient_SecurityQuestion1 || Security Question 1 || Self Self service password, security question 1
|-
| strClient_SecurityQuestion2 || Security Answer 1 || Self Self service password, security question 1 answer
|-
| strClient_SecurityAnswer1 || Security Question 2 || Self Self service password, security question 2
|-
| strClient_SecurityAnswer2 || Security Answer 2 || Self Self service password, security question 2 answer
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | Notes
|-
| strClient_IPRange || IP Range || If If set the account will only be able to log in from this IP. Separate multiples with commas
|-
| strClient_ExternalId || External System Id || For For use with the BEAPI
|-
| strClient_ExternalKey || External System Key || For For use with the BEAPI
|-
| intClient_ForceLogout || Force Inactive Logout || After After [selected] Minutes. For Data Protection usage
|-
| strClient_IsStudent || External Student Access || When When IP restricted can user still access courses and conferences.
|-
| strClient_UrlRedirect || Alternate Login URL || Set Set an alternate destination for the user to be redirected to when they login to bxp
|-
| strClient_3rdPartyEngine || 3rd Party Engine || If If importing from or linking to a 3rd party solution, the name of that solution.
|-
| strClient_3rdPartyUserId || 3rd Party User Id || The The Id of the user to be used in that 3rd party solution.
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | Notes
|-
| strClient_LdapHostAddress || Authorised ip addresses || IP IP addresses that are allowed connect to the LDAP server. Seperate multiple by ,
|-
| strClient_LdapHostPort || LDAP Host Address || The The Host address of the LDAP server
|-
| strClient_LdapBaseDn || LDAP Host Port || Port Port the LDAP server will be listening on
|-
| strClient_LdapAuthorisedIp || LDAP Base Dn || The The LDAP Servers Base Distinguished Name
|-
| strClient_LdapAdminUserName || LDAP Admin Username i.e || User User name for the Read Only admin user created on the LDAP server
|-
| strClient_LdapAdminPassword || LDAP Admin Password || User User name for the Read Only admin user created on the LDAP server
|-
| strClient_LdapMyUserName || LDAP My Username || User User Name for the bxp users Active Directory account
|-
| strClient_LdapMyDomain || LDAP My Domain || Domain Domain for the bxp users Active Directory account
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | Notes
|-
| strClient_VOIP_ServerTechnology || Phone Server Technology || When When IP restricted can user still access courses and conferences.
|-
| strClient_VOIP_ServerIP || Server IP || The The IP Address of the phone system
|-
| strClient_VOIP_ServerPort || Server Port || The The port the requests are sent to
|-
| strClient_VOIP_Extension || User Extension || The The extension for this user
|-
| strClient_VOIP_PIN || User PIN || The The PIN code for this user
|-
| strClient_AllowiFrame || Allow iFrame ||
|-
|}
! style="width:60%" | 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 ||
|-
|}
! style="width:60%" | 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 In Reminders, add custom HTML code
|-
| strClient_LimitTimeTrackerCosting || Limit Time Tracker Costing || In In Time Tracker, Only show work types that have pricing associated?
|-
|}
== Security Information ==
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | 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 ||
|-
|}
{| class="wikitable" style="width:100%;"
! style="width:20%" | Db field name
! style="width:60%" | 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 ||
|-
|}