Public Tables

 Show all Hide all

ADMINADGroup (Deprecated from Softadmin® 5.4.019)

Maps Active Directory groups against roles and functions. Used by advanced single-sign on.

The contents of this table are not deployed.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
ADGroupID int Yes No Yes Primary key.
ADGroup varchar(500) Yes Yes No The name of the AD group to map. Must match the actual group's name. Case insensitive.

The same group may occur multiple times if you need to assign both role and functions to its members.
RoleID int Yes Yes No Role to give members of this group. If a user belongs to multiple groups he gets the one with the lowest sort order.

A user must always be assigned at least one role to be able to log in, even if you also use functions.
FunctionID int Yes Yes No Function to assign members of this group.

Any previous function mappings are deleted each time a user logs in.
SortOrder int Yes Yes No Sort order.

ADMINLoginLinkInstance (Deprecated from Softadmin® 5.4.019)

Instances of login links.

Administer the table with dbo.ADMIN_LoginLinkInstance_Insert and dbo.ADMIN_LoginLinkInstance_Delete.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginLinkInstanceId int Yes No Yes Primary key.
LoginLinkId int Yes No No Link id.
LinkKey int No No No Private.
UserIdAutoLogin int No No No Private.
InsertDatetimeUtc datetime Yes No No When the link was instantiated.
ExpiresDatetimeUtc datetime Yes No No When the link expires.

ADMINLoginLog (Deprecated from Softadmin® 5.4.019)

Log of login attempts, both successful and unsuccessful.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginLogId int No No Yes Private.
LogDatetime datetime Yes No No Time of the login attempt.
LoginResultId tinyint Yes No No Result of the login attempt. See ADMINLoginResult.
UserId int Yes No No ID of user that logged in. May contain ID values of users that since have been deleted from ADMINUser.
Username varchar(300) Yes No No Name of the user. Either the name entered in the username field or the user's account in the domain.

You should only use this column for debugging and never make any assumptions about its contents.
IpAddress varchar(40) Yes No No The client's IP address. Can be on any format but will in practice either be IPv4 or IPv6.
UserAgent varchar(1000) Yes No No User agent of client's browser.
Https bit Yes No No If the client was using HTTPS.

ADMINLoginResult (Deprecated from Softadmin® 5.4.019)

Lookup table for login results.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginResultId tinyint Yes No Yes Primary key.
LoginResult varchar(300) Yes No No Description.
IsSuccessfulLogin bit Yes No No Whether the result represents a successful login or not. A failed login is anything that prevents the user from logging in, from an invalid password to an internal error.

ADMINLogMenuItem (Deprecated from Softadmin® 5.4.019)

Logs user activity in system. Only logs when a user first loads a menuitem, not if he refreshes it in the browser.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LogMenuitemID int No No Yes Primary key.
UserID int Yes No No User ID.
MenuitemID int Yes No No ID of the menu item the user viewed.
LogDatetime datetime Yes No No When the user viewed the menu item.
IsNotified bit No No No Private.

ADMINMaintenanceUserRights (Deprecated from Softadmin® 5.4.019)

Lookup table with possible user rights in the maintenance center. ADMINUser references this table.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
MaintenanceUserRightsId int Yes No Yes Primary key.
MaintenanceUserRights varchar(300) Yes No No Name of rights. In English.
MaintenanceUserRights_p int Yes No No PhraseId of language phrase with translated rights names.

ADMINSearch (Deprecated from Softadmin® 5.4.019)

Contains saved searches.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
SearchID int Yes No Yes Primary key.
SearchGroupID int Yes No No Search group.
MenuItemID int Yes No No Menu item search was saved for.
SearchName varchar(300) Yes No No Name user saved search with.
UserID int Yes No No User who last updated the search.
CreatedDatetime datetime Yes No No When the user first saved the search.
UpdatedDatetime datetime Yes No No When the user last updated the search.

ADMINSearchGroup (Deprecated from Softadmin® 5.4.019)

Contains search groups for saved searches.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
SearchGroupID int Yes No Yes Primary key.
SearchGroupName varchar(300) Yes No No Name of search group.

ADMINUser (Deprecated from Softadmin® 5.4.019)

Stores properties about users in the system.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
UserID int Yes No Yes Primary key for the user. You may create foreign keys referencing this column.
Username varchar(50) Yes No No The username the user uses to login to the system
Password varchar(50) No No No Password the user uses to login to the system. This column is only relevant when password hashing is turned off.
UsernameFirst varchar(50) Yes No No Users first name
UsernameLast varchar(50) Yes No No Users last name
UserEmail varchar(100) Yes No No Users email address
LanguageID int Yes No No Reference to the users default language in the ADMINLanguage table
RoleID int Yes No No Reference to the users role in the AMDINRole table
Administrator bit Yes No No Indicates that the user is a Softadmin® administrator.
Enabled bit Yes No No Indicates whther the account is active, i.e. can be used to login to the system.
MaintenanceUserRightsID int Yes No No Reference to the users maintenance rights in the ADMINMaintenanceUserIRights table.
HelpAdministrator bit No No No Indicates that the user is a help administrator, i.e. is allowed to edit documentation pages for the system.
PasswordHash binary No No No Hash of the users password. This column is only relevant when password hashing is enabled.
PasswordSalt binary Yes No No Salt used to compute the password hash. This column is only relevant when password hashing is enabled.
PasswordHasExpired bit Yes No No Indicates that the users password has expired and needs to be reset.
PasswordUpdateDatetime datetime Yes No No Indicates that last time the users password was changed.
CreateDatetime datetime Yes No No Indicates when the account was initially created.
LatestNewsViewingDatetime datetime No No No Private. Indicates the last time the user viewed news from the news channel.
UsernameFull varchar(101) Yes No No Concatenation of UsernameFirst and UsernameLast.

ADMINUserFunctionEditable (Deprecated from Softadmin® 5.4.019)

Contains connections between users and functions.
Add row: Allowed
Delete row: Allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description

ADMINWebServer

This table should be used whenever the system uses multiple sites (e.g. for load balancing or authentication/SSO purposes).
Clear Cache will clear the cache for all registered sites in addition to the site where the command was issued.

Neither used by Publish nor WebDAV.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
WebserverId int Yes No Yes Primary key.
Internalapplicationurl varchar(500) Yes Yes No The URL to the application.
Internalclearcacheurl varchar(500) Yes Yes No Leave blank to use the default clear cache URL. Otherwise provide an alternative URL to use when clearing cache.

SoftadminApi.AdGroup

Maps Active Directory groups against roles and functions. Used by advanced single-sign on.

The contents of this table are not deployed.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
AdGroupId int Yes No Yes Primary key.
AdGroup varchar(500) Yes Yes No The name of the AD group to map. Must match the actual group's name. Case insensitive.

Should not be prefixed with the domain name, that is, use GROUP, not DOMAIN\GROUP.

You can use this command line to list all groups in a domain:

net groups /domain


The same group may occur multiple times if you need to assign both role and functions to its members.
RoleId int Yes Yes No Role to give members of this group. If a user belongs to multiple groups he gets the one with the lowest sort order.

A user must always be assigned at least one role to be able to log in, even if you also use functions.
FunctionId int Yes Yes No Function to assign members of this group.

Any previous function mappings are deleted each time a user logs in.
SortOrder int Yes Yes No Sort order.

SoftadminApi.AzureAdGroup

The security groups used to control access and permissions.

When a user logs in the rows with a non-null RoleId are sorted by SortOrder and the first is then assigned as the user's new role.

The contents of this table are not deployed.
Add row: Allowed
Delete row: Allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
AzureAdGroupId uniqueidentifier Yes Yes Yes The group's ID. This value is defined by Azure AD and can be found in the Object ID field under the group's properties in the management console.
GroupName varchar(300) Yes Yes No The group's human-readable name.
Description varchar(4000) Yes Yes No Additional comments.
RoleId int Yes Yes No Used together with SortOrder to determine which role is assigned to users that log in.
SortOrder int Yes Yes No Used together with RoleId.

SoftadminApi.AzureAdTenant

The tenants that should have access to the application.

The contents of this table are not deployed.
Add row: Allowed
Delete row: Allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
AzureAdTenantId uniqueidentifier Yes Yes Yes The tenant's ID. This value is defined by Azure AD and can be found under the tenant's properties in the management console.
TenantName varchar(300) Yes Yes No The tenant's human-readable name.
Description varchar(4000) Yes Yes No Additional comments.

SoftadminApi.AzureAppRole

The application roles (if any) that this system exports to Azure AD.

You can use the procedure SoftadminApi.AzureAppRole_Export to export the table.

The contents of this table are not deployed.

You should never delete roles that users are assigned to so use the IsEnabled column to disable obsolete roles instead!
Add row: Allowed
Delete row: Allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
AzureAppRoleId uniqueidentifier Yes Yes Yes The role's ID, as exported to Azure AD.
RoleName int Yes Yes No The role's human-readable name.
Description varchar(4000) Yes Yes No Additional comments. This field is exported to Azure so it should not contain internal documentation.
IsEnabled bit Yes Yes No Whether the role is enabled or not.

You should never delete roles that users are assigned to so use this column to disable obsolete roles instead!

SoftadminApi.BankgiroFileIncoming (View)

Stores files from Bankgirot, automatically fetched from the incoming FTP server. Only applicable when using the "FTP via Internet" and "Third party files via FTP" delivery methods.

Use the Bankgiro component in "Process files" mode to process the files.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
BankgiroFileIncomingId int Yes No Yes Primary key.
FileName varchar(300) Yes No No Filename from Bankgirot.
Product varchar(30) Yes No No Identified by the component, based on file contents. One of
AG
BGI
BGI IMAGE
LBUT
UNKNOWN

Only attempt to process files with a product supported by the component.

Files of type "BGI IMAGE" will be deleted after a week to keep disk usage down. If they need to be kept longer than that, they have to be put in another table.

If the file was found in a subdirectory, then the product is assumed to be the name of the subdirectory.
ReceivedDateTimeUtc datetime2 Yes No No When the file was retrieved from the local FTP server; not when Bankgirot put it there.
IsProcessed bit Yes No No Use the procedure SoftadminApi.BankgiroFtp_SetAsProcessed to update the status after the file has been processed.
IsTestFile bit Yes No No If the file is a test file.
IsThirdPartyFile bit Yes No No Set to 1 if the file was found in a subdirectory on the FTP server.
File varbinary Yes No No File data.

SoftadminApi.BankgiroFileOutgoing (View)

Files generated by the Bankgiro component in the "FTP via Internet" and "Third party files via FTP" modes will be placed here. The files will then automatically be uploaded to Bankgirot.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
BankgiroFileOutgoingId int Yes No Yes Primary key.
FileName varchar(300) Yes No No Filename generated by the component.
Product varchar(30) Yes No No The type of file. Currently only 'AG' can be generated.
Action varchar(30) Yes No No One of 'AgBetUnd', 'AgBetMak', and 'AgMedgivReg', depending on the file.
CreatedDateTimeUtc datetime2 Yes No No When the file was inserted into the table.
SentDateTimeUtc datetime2 Yes No No Set when the file has been sent to Bankgirot's FTP server.
IsTestFile bit Yes No No Set to 1 if the file is a test file.
IsThirdPartyFile bit Yes No No Set to 1 if the "Third party files via FTP" mode was used to place the file in the queue.
File varbinary Yes No No File data.

SoftadminApi.BankIdSignature

Stores BankID signatures.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
BankIdSignatureId int No No Yes

SoftadminApi.Job_History

Lists when the system's scheduled jobs run.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
JobGuid uniqueidentifier Yes No No The job's ID.
JobName varchar(200) Yes No No The job's name.
RunDateTimeUtc datetime Yes No No When the job started running, universal time.
CompletedDatetimeUtc datetime Yes No No When the job completed running, universal time. If NULL then the job is either still running or the system suffered an outage severe enough to prevent it from logging job failure.
IsError bit Yes No No Whether an error was raised during job execution.

SoftadminApi.Language

The system's languages.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LanguageId int Yes No Yes
Language varchar(50) No No No The language's name.
CultureCode varchar(20) No No No The language's culture code, compatible with the FORMAT function.
IsEnabled bit No No No

SoftadminApi.LoginLinkInstance

Instances of login links.

Administer the table with SoftadminApi.LoginLinkInstance_Insert and SoftadminApi.LoginLinkInstance_Delete.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginLinkInstanceId int Yes No Yes Primary key.
LoginLinkId int Yes No No Link id.
LinkKey int No No No Private.
UserIdAutoLogin int No No No Private.
InsertDatetimeUtc datetime2 Yes No No When the link was instantiated.
ExpiresDatetimeUtc datetime2 Yes No No When the link expires.

SoftadminApi.LoginLog (View)

Log of login attempts, both successful and unsuccessful.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginLogId int No No Yes Primary key.
LogDatetime datetime Yes No No Time of the login attempt.
LoginResultId tinyint Yes No No Result of the login attempt. See ADMINLoginResult.
UserId int Yes No No ID of user that logged in. May contain Id values of users that since have been deleted from SoftadminApi.User.
Username varchar(300) Yes No No Name of the user. Either the name entered in the username field or the user's account in the domain.

You should only use this column for debugging and never make any assumptions about its contents.
IpAddress varchar(40) Yes No No The client's IP address. Can be on any format but will in practice either be IPv4 or IPv6.
UserAgent varchar(1000) Yes No No User agent of client's browser.
Https bit Yes No No If the client was using HTTPS.

SoftadminApi.LoginResult (View)

Lookup table for login results.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LoginResultId tinyint Yes No Yes Primary key.
LoginResult varchar(300) Yes No No Description.
IsSuccessfulLogin bit Yes No No Whether the result represents a successful login or not. A failed login is anything that prevents the user from logging in, from an invalid password to an internal error.

SoftadminApi.LogMenuItem (View)

Logs user activity in system. Only logs when a user first loads a menuitem, not if he refreshes it in the browser.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
LogMenuitemID int No Yes Yes Primary key.
UserID int Yes No No User ID.
MenuitemID int Yes No No ID of the menu item the user viewed.
LogDatetime datetime Yes No No When the user viewed the menu item.
IsNotified bit No No No Private.

SoftadminApi.MailQueue

Shows the state of the mail queue.

The queue contains unsent and failed mail. Sent mail is immediately deleted from the queue. Emails that had errors are deleted after a week.
Add row: Not allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
EmailId bigint Yes No Yes Primary key.
InsertDatetime datetime Yes No No When the mail was enqueued.
ErrorCode int Yes No No Error code, if the mail failed.
ErrorMessage varchar(8000) Yes No No Error message, if the mail failed.

SoftadminApi.MenuItemPermission

Presents a view of the access permissions of the system's menu items.

You should mostly use this view to present an overview of the system's mapping of functions to menu items to the system owner so that he or she can verify that it is correct.

If you need to determine if a specific user has access to a menu item then use SoftadminApi.User_HasAccessToMenuItem instead.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
MenuItemId int Yes No No Id of the menu item.
MenuGroupId int Yes No No Id of the menu group the menu item belongs to.
AllUsers bit Yes No No If 1, all users have access to the menu item.
RoleId int Yes No No Role that has access to the menu item.
FunctionId int Yes No No Function that has access to the menu item.

SoftadminApi.SavedSearch

Contains saved searches.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
SavedSearchId int Yes No Yes Primary key.
SavedSearchGroupId int Yes No No Search group.
MenuItemId int Yes No No Menu item search was saved for.
SearchName varchar(300) Yes No No Name user saved search with.
UserId int Yes No No User who last updated the search.
CreatedDatetime datetime Yes No No When the user first saved the search.
UpdatedDatetime datetime Yes No No When the user last updated the search.

SoftadminApi.SavedSearchGroup (View)

Contains search groups for saved searches.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
SavedSearchGroupId int Yes No No Primary key.
SavedSearchGroupName varchar(300) Yes No No Name of search group.

SoftadminApi.Setting_Values

All settings (application variables).
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
SettingId int Yes No Yes
SettingName varchar(100) Yes No No
Value varchar(1000) Yes No No The value of the application variable or NULL if it doesn't exist.

SoftadminApi.User

Stores properties about users in the system.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
UserId int Yes No Yes Primary key for the user. You may create foreign keys referencing this column.
Username varchar(50) Yes No No The username the user uses to login to the system
UsernameFirst varchar(50) Yes No No Users first name
UsernameLast varchar(50) Yes No No Users last name
UsernameFull varchar(101) Yes No No Concatenation of UsernameFirst and UsernameLast.
UserEmail varchar(100) Yes No No Users email address
RoleId int Yes No No Reference to the users role in the AMDINRole table
IsAdministrator bit Yes No No Indicates that the user is a Softadmin® administrator.
LanguageId int Yes No No Reference to the users default language in the ADMINLanguage table
IsEnabled bit Yes No No Indicates whther the account is active, i.e. can be used to login to the system.
CreateDatetimeUtc datetime2 Yes No No Indicates when the account was initially created.
PasswordHash binary No No No Hash of the users password. This column is only relevant when password hashing is enabled.
PasswordSalt binary Yes No No Salt used to compute the password hash. This column is only relevant when password hashing is enabled.
PasswordHasExpired bit Yes No No Indicates that the users password has expired and needs to be reset.
PasswordUpdateDatetimeUtc datetime2 Yes No No Indicates that last time the users password was changed.
MaintenanceUserRightsId int No No No Reference to the users maintenance rights in the ADMINMaintenanceUserIRights table.
CanUseVirtualMenuItems bit Yes No No Indicates that the user sees Visual menu items.
IsHelpAdministrator bit No No No Indicates that the user is a help administrator, i.e. is allowed to edit documentation pages for the system.
PersonalNumber char Yes No No The personal number of the user, set with SoftadminApi.User_UpdatePersonalNumber.
Can e.g. be used with the BankID component.
FirstNameLastName varchar(101) Yes No No Concatenation of first and last name.
LastNameFirstName varchar(101) Yes No No Concatenation of last and first name.

SoftadminApi.UserAppKey

Login keys that have been issued to the Softadmin® Go app.

You can delete rows from this table to destroy keys, for example when a user's mobile device has been stolen.
Add row: Not allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
UserId int Yes No Yes User the key belongs to.
KeyId uniqueidentifier Yes No Yes The key's id.
AppKey int No No No The key. The format is opaque.
InsertDatetimeUtc datetime Yes No No When the key was created.
LastUsedDatetimeUtc datetime Yes No No Last time the key was used.
ExpiresDatetimeUtc datetime Yes Yes No When the key will expire. This column is used to force key rotation: the user will be issued a new key if logging in with a key that will expire but that has not yet expired.

SoftadminApi.UserFavorite (View)

The user's favorites.

Requires a clear cache after DML.

Insert rows with caution, the menuitem should be reachable without passingfields.

May be used to remove menuitems/menugroups that have changed hide-status or received passingfields.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
UserId int Yes Yes No
MenuItemId int Yes Yes No
MenuGroupId int Yes Yes No
SortOrder int Yes Yes No

SoftadminApi.UserFunction (View)

Contains connections between users and functions.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
UserId int Yes Yes No User Id.
FunctionId int Yes Yes No Function Id.

SoftadminApi.UserSecurityGroup

Modify this table to configure user's access to rows indexed by Enterprise Search.
Add row: Allowed
Delete row: Allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description

SoftadminApi.WebServiceRequestLog (View)

Contains all webservice log data. Data is inserted depending on system settings "WebServiceLoggingEnabled" and "WebServiceRequestBodyLoggingEnabled".
Add row: Not allowed
Delete row: Allowed
Foreign key: Allowed

Columns:


Name Datatype Read Write Primary key Description
RequestLogId int Yes No Yes
WebServiceId int Yes No No
Url nvarchar Yes No No
HttpMethod varchar(30) Yes No No
SoapAction nvarchar Yes No No
IpAddress varchar(300) Yes No No
Username varchar(300) Yes No No Username when passowrd validation is used.
RequestMessage nvarchar Yes No No
ResponseMessage nvarchar Yes No No

SoftadminDev.Document

The table is only used as a support table for development purposes. To add a document use the Admin menugroup. Do not write procedures that rely on this table.
Add row: Not allowed
Delete row: Not allowed
Foreign key: Not allowed

Columns:


Name Datatype Read Write Primary key Description
DocumentId int Yes No Yes Primary Key
Document varbinary Yes Yes No The document
DocumentContentSize int Yes No No Size of the document.
DocumentContentType varchar(300) Yes No No Type of document
DocumentFilename varchar(300) Yes Yes No Name of the document
DocumentDescription varchar(1000) Yes Yes No Description for the document