Difference between revisions of "Client table fields"
Philip Lacey (talk | contribs) m (→Primary VOIP Details) |
Philip Lacey (talk | contribs) m |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | = | + | {| class="wikitable" style="width:100%;" |
| − | + | ! style="width:25%;text-align:center;" | Client | |
| − | Client | + | ! style="width:25%;text-align:center;" | Functional Security |
| − | Functional Security | + | ! style="width:25%;text-align:center;" | Content Security |
| − | Content Security | + | ! style="width:25%;text-align:center;" | HR |
| − | HR | + | |- |
| + | | style="text-align:center;" | [[Client_table_fields|Link]] | ||
| + | | style="text-align:center;" | [[Security_-_Functional_Access_Matrix|Link]] | ||
| + | | style="text-align:center;" | [[Bxp_Security_-_Content_Management|Link]] | ||
| + | | style="text-align:center;" | [[Employee_Self-Service_-_Fields|Link]] | ||
| + | |- | ||
| + | |} | ||
| + | = Overview = | ||
| − | The primary security table for individual users in bxp is called the "Client" table. | + | 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. | + | 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. |
| Line 21: | Line 28: | ||
= Field reference = | = Field reference = | ||
| − | == Account == | + | == Account == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_Title || | + | | strClient_Title || || |
|- | |- | ||
| − | | strClient_Firstname || | + | | strClient_Firstname || || |
|- | |- | ||
| − | | strClient_Surname || | + | | strClient_Surname || || |
|- | |- | ||
| − | | intClient_Status || | + | | intClient_Status || || |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Primary Contact == | + | == Primary Contact == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_CompanyStaffIdNumber || | + | | strClient_CompanyStaffIdNumber || Company Staff Id Number || Comany Staff Id |
|- | |- | ||
| − | | strClient_Mobile || | + | | strClient_Mobile || Work Contact Mobile || Used to SMS Staff |
|- | |- | ||
| − | | strClient_Phone || | + | | strClient_Phone || Work Contact Email || Used to email Staff |
|- | |- | ||
| − | | intClient_Department || | + | | intClient_Department || Department || The Department or Team the Staff works in |
|- | |- | ||
| − | | intClient_Role || | + | | intClient_Role || Role || The role of that staff member |
|- | |- | ||
| − | | strClient_CostCentre || | + | | strClient_CostCentre || Cost Centre || Please enter a cost centre name |
|- | |- | ||
| − | | strClient_IsChampion || | + | | strClient_IsChampion || Is System Champion || Will include the user on all System Champion notifications. |
|- | |- | ||
| − | | strClient_IsApprovedContact || | + | | strClient_IsApprovedContact || Is Approved Contact || Will allow the user submit Change Requests. |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Security Questions == | + | == Security Questions == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_SecurityQuestion1 || | + | | strClient_SecurityQuestion1 || Security Question 1 || Self service password, security question 1 |
|- | |- | ||
| − | | strClient_SecurityQuestion2 || | + | | strClient_SecurityQuestion2 || Security Answer 1 || Self service password, security question 1 answer |
|- | |- | ||
| − | | strClient_SecurityAnswer1 || | + | | strClient_SecurityAnswer1 || Security Question 2 || Self service password, security question 2 |
|- | |- | ||
| − | | strClient_SecurityAnswer2 || | + | | strClient_SecurityAnswer2 || Security Answer 2 || Self service password, security question 2 answer |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Primary Security Details == | + | == Primary Security Details == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_IPRange || | + | | strClient_IPRange || IP Range || If set the account will only be able to log in from this IP. Separate multiples with commas |
|- | |- | ||
| − | | strClient_ExternalId || | + | | strClient_ExternalId || External System Id || For use with the BEAPI |
|- | |- | ||
| − | | strClient_ExternalKey || | + | | strClient_ExternalKey || External System Key || For use with the BEAPI |
|- | |- | ||
| − | | intClient_ForceLogout || | + | | intClient_ForceLogout || Force Inactive Logout || After [selected] Minutes. For Data Protection usage |
|- | |- | ||
| − | | strClient_IsStudent || | + | | strClient_IsStudent || External Student Access || When IP restricted can user still access courses and conferences. |
|- | |- | ||
| − | | strClient_UrlRedirect || | + | | strClient_UrlRedirect || Alternate Login URL || Set an alternate destination for the user to be redirected to when they login to bxp |
|- | |- | ||
| − | | strClient_3rdPartyEngine || | + | | strClient_3rdPartyEngine || 3rd Party Engine || If importing from or linking to a 3rd party solution, the name of that solution. |
|- | |- | ||
| − | | strClient_3rdPartyUserId || | + | | strClient_3rdPartyUserId || 3rd Party User Id || The Id of the user to be used in that 3rd party solution. |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Primary LDAP Details == | + | == Primary LDAP Details == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_LdapHostAddress || | + | | strClient_LdapHostAddress || Authorised ip addresses || IP addresses that are allowed connect to the LDAP server. Seperate multiple by , |
|- | |- | ||
| − | | strClient_LdapHostPort || | + | | strClient_LdapHostPort || LDAP Host Address || The Host address of the LDAP server |
|- | |- | ||
| − | | strClient_LdapBaseDn || | + | | strClient_LdapBaseDn || LDAP Host Port || Port the LDAP server will be listening on |
|- | |- | ||
| − | | strClient_LdapAuthorisedIp || | + | | strClient_LdapAuthorisedIp || LDAP Base Dn || The LDAP Servers Base Distinguished Name |
|- | |- | ||
| − | | strClient_LdapAdminUserName || | + | | strClient_LdapAdminUserName || LDAP Admin Username i.e || User name for the Read Only admin user created on the LDAP server |
|- | |- | ||
| − | | strClient_LdapAdminPassword || | + | | strClient_LdapAdminPassword || LDAP Admin Password || User name for the Read Only admin user created on the LDAP server |
|- | |- | ||
| − | | strClient_LdapMyUserName || | + | | strClient_LdapMyUserName || LDAP My Username || User Name for the bxp users Active Directory account |
|- | |- | ||
| − | | strClient_LdapMyDomain || | + | | strClient_LdapMyDomain || LDAP My Domain || Domain for the bxp users Active Directory account |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Primary VOIP Details == | + | == Primary VOIP Details == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_VOIP_ServerTechnology || | + | | strClient_VOIP_ServerTechnology || Phone Server Technology || When IP restricted can user still access courses and conferences. |
|- | |- | ||
| − | | strClient_VOIP_ServerIP || | + | | strClient_VOIP_ServerIP || Server IP || The IP Address of the phone system |
|- | |- | ||
| − | | strClient_VOIP_ServerPort || | + | | strClient_VOIP_ServerPort || Server Port || The port the requests are sent to |
|- | |- | ||
| − | | strClient_VOIP_Extension || | + | | strClient_VOIP_Extension || User Extension || The extension for this user |
|- | |- | ||
| − | | strClient_VOIP_PIN || | + | | strClient_VOIP_PIN || User PIN || The PIN code for this user |
|- | |- | ||
| − | | strClient_AllowiFrame || | + | | strClient_AllowiFrame || Allow iFrame || |
|- | |- | ||
|} | |} | ||
| Line 150: | Line 157: | ||
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_HTMLVersion || | + | | strClient_HTMLVersion || HTML Version || |
|- | |- | ||
| − | | strClient_SpeedInterface || | + | | strClient_SpeedInterface || Speed Interface || |
|- | |- | ||
| − | | strClient_UsePresence || | + | | strClient_UsePresence || Use Presence || |
|- | |- | ||
| − | | strClient_SystemLayout_MainMenu || | + | | strClient_SystemLayout_MainMenu || Main Menu || |
|- | |- | ||
| − | | strClient_SystemLayout_SectionMenu || | + | | strClient_SystemLayout_SectionMenu || Section Menu || |
|- | |- | ||
| − | | strClient_SystemLayout_Page || | + | | strClient_SystemLayout_Page || Page || |
|- | |- | ||
| − | | strClient_SystemLayout_BackgroundImage || | + | | strClient_SystemLayout_BackgroundImage || Background Image || |
|- | |- | ||
| − | | strClient_SystemLayout_CSS || | + | | strClient_SystemLayout_CSS || CSS || |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Module Specific == | + | == Module Specific == |
| − | + | ||
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_ListerOptions || | + | | strClient_ListerOptions || Lister Options || |
|- | |- | ||
| − | | strClient_ListerCategories || | + | | strClient_ListerCategories || Lister Categories || |
|- | |- | ||
| − | | strClient_ListerType1 || | + | | strClient_ListerType1 || Lister Type 1 || |
|- | |- | ||
| − | | strClient_ListerType2 || | + | | strClient_ListerType2 || Lister Type 2 || |
|- | |- | ||
| − | | strClient_ListerType3 || | + | | strClient_ListerType3 || Lister Type 3 || |
|- | |- | ||
| − | | strClient_ListerType4 || | + | | strClient_ListerType4 || Lister Type 4 || |
|- | |- | ||
| − | | strClient_RemindersPage || | + | | strClient_RemindersPage || Reminders Page Options || In Reminders, add custom HTML code |
|- | |- | ||
| − | | strClient_LimitTimeTrackerCosting || | + | | strClient_LimitTimeTrackerCosting || Limit Time Tracker Costing || In Time Tracker, Only show work types that have pricing associated? |
|- | |- | ||
|} | |} | ||
| − | == Security Information == | + | == Security Information == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | intClient_CreatedBy || | + | | intClient_CreatedBy || Created By || |
|- | |- | ||
| − | | dteClient_DateCreated || | + | | dteClient_DateCreated || Created Date || |
|- | |- | ||
| − | | intClient_LastEdited_ByWhom || | + | | intClient_LastEdited_ByWhom || Last Edited By || |
|- | |- | ||
| − | | dteClient_LastEdited_LastDateTime || | + | | dteClient_LastEdited_LastDateTime || Last Edited Date || |
|- | |- | ||
| − | | intClient_Retired_LastByWhom || | + | | intClient_Retired_LastByWhom || Retired By || |
|- | |- | ||
| − | | dteClient_Retired_LastDateTime || | + | | dteClient_Retired_LastDateTime || Retired Date || |
|- | |- | ||
| − | | dteClient_LastLoginDateTime || | + | | dteClient_LastLoginDateTime || Last Login Date Time || |
|- | |- | ||
| − | | dteClient_CompanyStartDate || | + | | dteClient_CompanyStartDate || Company Start Date || |
|- | |- | ||
| − | | dteClient_CompanyEndDate || | + | | dteClient_CompanyEndDate || Company End Date || |
|- | |- | ||
| − | | dteClient_LastPasswordChangeDateTime || | + | | dteClient_LastPasswordChangeDateTime || Last Password Change Date Time || |
|- | |- | ||
| − | | dteClient_LastPresence || | + | | dteClient_LastPresence || Last Presence Date Time || |
|- | |- | ||
| − | | dteClient_Password_FirstFailDateTime || | + | | dteClient_Password_FirstFailDateTime || Password Fail - First Date Time || |
|- | |- | ||
| − | | dteClient_Password_LastFailDateTime || | + | | dteClient_Password_LastFailDateTime || Password Fail - Last Date Time || |
|- | |- | ||
|} | |} | ||
| − | + | ||
| − | == Custom User Global Variables == | + | == Custom User Global Variables == |
{| class="wikitable" style="width:100%;" | {| class="wikitable" style="width:100%;" | ||
| − | ! style="width: | + | ! style="width:30%" | Db field name |
| − | ! style="width: | + | ! style="width:30%" | On Screen name |
| − | ! style="width: | + | ! style="width:40%" | Notes |
|- | |- | ||
| − | | strClient_CustomGlobalField_1 || | + | | strClient_CustomGlobalField_1 || Custom Global Variable 1 || |
|- | |- | ||
| − | | strClient_CustomGlobalField_2 || | + | | strClient_CustomGlobalField_2 || Custom Global Variable 2 || |
|- | |- | ||
| − | | strClient_CustomGlobalField_3 || | + | | strClient_CustomGlobalField_3 || Custom Global Variable 3 || |
|- | |- | ||
| − | | strClient_CustomGlobalField_4 || | + | | strClient_CustomGlobalField_4 || Custom Global Variable 4 || |
|- | |- | ||
| − | | strClient_CustomGlobalField_5 || | + | | strClient_CustomGlobalField_5 || Custom Global Variable 5 || |
|- | |- | ||
| − | | strClient_CustomGlobalField_6 || | + | | strClient_CustomGlobalField_6 || Custom Global Variable 6 || |
|- | |- | ||
|} | |} | ||
Latest revision as of 19:14, 13 March 2018
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 |