Difference between revisions of "Client table fields"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "= Overview = Client Functional Security Content Security HR The primary security table for individual users in bxp is called the "Client" table. This stores the details o...") |
Philip Lacey (talk | contribs) m (→Primary VOIP Details) |
||
| Line 145: | Line 145: | ||
|- | |- | ||
|} | |} | ||
| − | + | ||
| + | |||
== Interface options == | == Interface options == | ||
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| Line 193: | Line 194: | ||
|- | |- | ||
|} | |} | ||
| − | + | ||
== Security Information == | == Security Information == | ||
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
Revision as of 19:04, 13 March 2018
Contents
1 Overview
Client Functional Security Content Security HR
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 |
== 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 |
== 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.7 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.8 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 |
