DiversityAgents

The following objects are not included:

• Logging tables
• Enumeration tables
• System objects
• Objects marked as obsolete
• Previous versions of objects

TABLES

• Agent
• AgentContactInformation
• AgentDescriptor
• AgentExternalDatabase
• AgentExternalID
• AgentHierarchyOther
• AgentIdentifier
• AgentImage
• AgentKeyword
• AgentProject
• AgentReference
• AgentRelation
• ApplicationEntityDescription
• ApplicationSearchSelectionStrings
• ProjectProxy
• ProjectUser
• UserProxy



VIEWS

• Agent_Core
• Agent_Main20
• AgentAddressList_Main20
• AgentAddressList_Main20_alt
• AgentID_AvailableReadOnly
• AgentID_FullAccess
• AgentID_Locked
• AgentID_ReadOnly
• AgentID_UserAvailable
• AgentList_Main20
• ApplicationSearchSelectionStrings_Core
• ProjectList
• PublicAgent
• PublicContactInformation4
• PublicIdentifier
• PublicImage
• PublicReference
• PublicRelation
• UserInfo
• ViewAgentAddress4
• ViewAgentNames
• ViewBaseURL
• ViewDefaultAgentNameDisplayType
• ViewDiversityWorkbenchModule



FUNCTIONS

• AddressType_Main20
• AgentAddress
• AgentChildNodes
• AgentContactInformation_Public
• AgentHierarchy
• AgentHierarchyAllSuperior
• AgentNames
• AgentSuperiorList
• AgentSynonymTopID
• AgentSynonymy
• AgentSynonymyChildNodes
• AgentTitle_Main20
• AgentTopID
• AgentType_Main20
• ApplicationSearchItemPrimaryKeyColumn
• BaseURL
• DefaultAgentNameDisplayType
• DefaultProjectID
• DiversityWorkbenchModule
• HierarchyTopID_Main20
• ReplacedWithAgentID
• SearchMenuColumns
• SearchMenuForeignKeys
• SearchMenuInferiorTables
• SearchMenuOrderColumn
• SearchMenuSuperiorTables
• SearchMenuTableTabs
• SuperiorAgentList
• UserID
• Version
• VersionClient



PROCEDURES

• procInsertAgentAddressCopy_Main20
• procInsertAgentAddressNew_Main20
• procInsertAgentCopy
• procInsertAgentCopy_Main20
• procInsertAgentNew
• procInsertAgentNew_Main20
• procSetVersionAgent
• SetUserProjects



ROLES

• DiversityWorkbenchAdministrator
• DiversityWorkbenchEditor
• DiversityWorkbenchUser




TABLES

Table Agent

The main table with the data of the agent



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (= Primary key)	NO	-
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy	YES	Refers to table Agent
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle Default value: ''	NO	-
Version	smallint	The version of a agent record (revision number, internally filled by system) Default value: (1)	NO	-
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.	YES	Refers to table AgentTitle_Enum
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution	YES	-
GivenNamePostfix	nvarchar (50)	Variable part of name, correctly placed at end of given names	YES	-
InheritedNamePrefix	nvarchar (50)	Variable part of name, correctly placed at the beginning of the inherited names	YES	-
InheritedName	nvarchar (255)	The last names of the agent (if a person)	YES	-
InheritedNamePostfix	nvarchar (50)	Additions after inherited name, like generation (Jr., III.) or names of religious orders	YES	-
Abbreviation	nvarchar (50)	Abbreviation of the agent	YES	-
AgentType	nvarchar (50)	The type of the agent, e.g. person, company Default value: N'person'	YES	Refers to table AgentType_Enum
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"	YES	-
AgentGender	nvarchar (50)	The gender resp. sex of the agent	YES	Refers to table AgentGender_Enum
Description	nvarchar (1000)	A description of the agent	YES	-
OriginalSpelling	nvarchar (200)	Name as originally written in e.g. chinese or cyrillic letters	YES	-
Notes	nvarchar (MAX)	Notes about the agent	YES	-
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year	YES	-
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent	YES	-
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent	YES	-
ValidFromYear	smallint	The year of the begin of the exsistence of the agent	YES	-
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year	YES	-
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent	YES	-
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent	YES	-
ValidUntilYear	smallint	The year of the end of the exsistence of the agent	YES	-
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.	YES	-
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded	YES	-
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died	YES	-
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources	YES	-
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"	YES	Refers to table AgentSynonymisationType_Enum
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision' Default value: N'unchecked'	YES	Refers to table RevisionLevel_Enum
ContentLanguage	nvarchar (50)	The language of the content	YES	Refers to table LanguageCode_Enum
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null	YES	-
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. Default value: (0)	YES	-

Depending on:

• AgentGender_Enum
• AgentSynonymisationType_Enum
• AgentTitle_Enum
• AgentType_Enum
• LanguageCode_Enum
• RevisionLevel_Enum

trgInsAgent





Table AgentContactInformation

The contact information resp. addresses of the agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Refers to the ID of Agent (= Foreign key and part of primary key)	NO	Refers to table Agent
DisplayOrder	tinyint	Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key)	NO	-
AddressType	nvarchar (50)	Type of the adress, e.g. private	YES	Refers to table AddressType_Enum
Country	nvarchar (255)	Country of the address	YES	-
City	nvarchar (255)	City of the address	YES	-
PostalCode	nvarchar (50)	ZIP or postcode of the address (usually output before or after the city)	YES	-
Streetaddress	nvarchar (255)	Usually street name and number, but may also contain post office box	YES	-
Address	nvarchar (255)	Free text postal address of the agent	YES	-
Telephone	nvarchar (50)	Phone number, including area code	YES	-
CellularPhone	nvarchar (50)	The number of a mobile telephone device of the agent	YES	-
Telefax	nvarchar (50)	Fax number, including area code	YES	-
Email	nvarchar (255)	E-mail address of the agent	YES	-
URI	nvarchar (255)	URI pointing to a homepage containing further information	YES	-
Notes	nvarchar (MAX)	Notes about this address	YES	-
ValidFrom	datetime	The date when this address became valid as date according to ISO 8601	YES	-
ValidUntil	datetime	The date of the expiration of the validity of this address as date according to ISO 8601	YES	-
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null Default value: N'Withhold by default'	YES	-

Depending on:

• AddressType_Enum
• Agent

trgInsAgentContactInformation





Table AgentDescriptor

The Descriptors for the agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (foreign key + part of primary key)	NO	Refers to table Agent
DescriptorID	int	-	NO	-
Descriptor	nvarchar (200)	The Descriptor Default value: ''	NO	-
URL	varchar (500)	URL of the Descriptor. In case of a module related Descriptor, the link to the module entry resp. the related webservice Default value: ''	YES	-
DescriptorType	nvarchar (50)	Type of the Descriptor as described in table AgentDescriptorType_Enum Default value: N'Descriptor'	YES	Refers to table AgentDescriptorType_Enum

Depending on:

• Agent
• AgentDescriptorType_Enum




Table AgentExternalDatabase

The external databases from which data in the database may have been imported from



Column	Data type	Description	Nullable	Relation
ExternalDatabaseID	int	An ID to identify an external data collection of plant names (primary key, the ID has no meaning outside of the DiversityWorkbench system)	NO	-
ExternalDatabaseName	nvarchar (100)	The name of the data collection that has been integrated or can be linked to for further analysis	YES	-
ExternalDatabaseVersion	nvarchar (255)	The version of this data collection (either official version number, or dates when the collection was integrated)	YES	-
Rights	nvarchar (500)	A description of copyright agreements or permission to use data from the external database	YES	-
ExternalDatabaseAuthors	nvarchar (200)	The persons or institutions responsible for the external database	YES	-
ExternalDatabaseURI	nvarchar (300)	The link to the database provider resp. the external database	YES	-
ExternalDatabaseInstitution	nvarchar (300)	The institution responsible for the external database	YES	-
InternalNotes	nvarchar (1500)	Additional notes concerning this data collection	YES	-
ExternalAttribute_AgentID	nvarchar (255)	The table and field name in the external data collection to which PlantNameAnalysis.ExternalNameID refers	YES	-
PreferredSequence	tinyint	For selection in e.g. picklists: of several equal names only the name from the source with the lowest preferred sequence will be provided.	YES	-
Disabled	bit	If this source should be disabled for selection of names e.g. in picklists	YES	-





Table AgentExternalID

The ID's of data that were imported from foreign souces



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (foreign key + part of primary key)	NO	Refers to table Agent
ExternalDatabaseID	int	The ID of an external taxonomic data collection as defined in AgentExternalDatabase (foreign key + part of primary key) Default value: ''	NO	Refers to table AgentExternalDatabase
ExternalAgentURI	varchar (255)	The URI (e.g. LSID) of the external agent	YES	-

Depending on:

• Agent
• AgentExternalDatabase




Table AgentHierarchyOther

Other hierarchies of the agent



Column	Data type	Description	Nullable	Relation
AgentID	int	Refers to the ID of Agent (= Foreign key and part of primary key)	NO	Refers to table Agent
HierarchyID	int	Identifier of the hierarchy, part of PK	NO	-
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy	NO	Refers to table Agent
ValidFrom	datetime	The start time of the hierarchy, e.g. when a person was employed in an institution	YES	-
ValidUntil	datetime	The end of a hierarchy, e.g. when an employment ended	YES	-
Notes	nvarchar (MAX)	Notes about the other hierarchy	YES	-

Depending on:

• Agent




Table AgentIdentifier

Identifier for the agent



Column	Data type	Description	Nullable	Relation
AgentID	int	Refers to the ID of Agent (= Foreign key and part of primary key)	NO	Refers to table Agent
Identifier	nvarchar (400)	Identifier for the agent, part of PK	NO	-
IdentifierURI	varchar (500)	URI of Identifier	YES	-
Type	nvarchar (50)	Type of the identifier as defined in table AgentIdentifierType_Enum	YES	Refers to table AgentIdentifierType_Enum
Notes	nvarchar (MAX)	Notes about the identifier	YES	-

Depending on:

• Agent
• AgentIdentifierType_Enum




Table AgentImage

The images of the agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (foreign key + part of primary key)	NO	Refers to table Agent
URI	varchar (255)	The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources	NO	-
Description	nvarchar (MAX)	Description of the resource	YES	-
Type	nvarchar (50)	The type of the image	YES	Refers to table AgentImageType_Enum
Sequence	int	The sequence of the image Default value: (1)	YES	-
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null Default value: N'Withhold by default'	YES	-

Depending on:

• Agent
• AgentImageType_Enum

trgInsAgentImage





Table AgentKeyword

The keywords for the agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (foreign key + part of primary key)	NO	Refers to table Agent
Keyword	nvarchar (200)	The keyword	NO	-

Depending on:

• Agent

trgInsAgentKeyword





Table AgentProject

The projects of the agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Unique ID for the Agent (= Foreign key)	NO	Refers to table Agent
ProjectID	int	The ID of the project Default value: 0	NO	Refers to table ProjectProxy

Depending on:

• Agent
• ProjectProxy




Table AgentReference

References containing informations about the agent



Column	Data type	Description	Nullable	Relation
AgentID	int	Refers to the ID of Agent (= Foreign key and part of primary key)	NO	Refers to table Agent
ReferenceTitle	nvarchar (255)	The title of the publication where information about the agent was published. Note this is only a cached value where ReferenceURI is present	NO	-
ReferenceURI	varchar (255)	URI of reference where information about the agent, e.g. referring to the module DiversityReferences	YES	-
ReferenceDetails	nvarchar (50)	Details within the reference, e.g. pages	YES	-
ContainsImage	tinyint	If the reference contains an image of the agent	YES	-
ContainsReferencelist	tinyint	If the reference contains a publication list of the agent	YES	-
Notes	nvarchar (255)	Notes about the reference	YES	-

Depending on:

• Agent

trgInsAgentReference





Table AgentRelation

Relations of the agent to other agents



Column	Data type	Description	Nullable	Relation
AgentID	int	Refers to the ID of Agent (= Foreign key and part of primary key)	NO	Refers to table Agent
RelatedAgentID	int	The AgentID of the related agent	NO	-
RelationType	nvarchar (50)	The type of the relation between the agents, e.g. "parent of", "child of", "married to"	YES	Refers to table AgentRelationType_Enum
Notes	nvarchar (255)	Notes about the relation	YES	-
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null	YES	-

Depending on:

• Agent
• AgentRelationType_Enum

trgInsAgentRelation





Table ApplicationEntityDescription





Column	Data type	Description	Nullable	Relation
TableName	varchar (50)	-	NO	-
ColumnName	varchar (50)	-	NO	-
DisplayText	nvarchar (50)	-	YES	-
Description	nvarchar (1000)	-	YES	-
LanguageCode	nvarchar (50)	-	YES	-





Table ApplicationSearchSelectionStrings





Column	Data type	Description	Nullable	Relation
UserName	varchar (50)	-	NO	-
SQLStringIdentifier	varchar (50)	-	NO	-
ItemTable	varchar (50)	-	YES	-
SQLString	varchar (2000)	-	YES	-
Description	nvarchar (MAX)	Description of the resultset and the purpose of the query	YES	-





Table ProjectProxy

The projects - refers to database DiversityProjects



Column	Data type	Description	Nullable	Relation
ProjectID	int	The ID of the project, Primary key	NO	-
Project	nvarchar (50)	The name of the project as stored in the module DiversityProjects	NO	-
ProjectURI	varchar (255)	The URI of the project, e.g. as provided by the module DiversityProjects.	YES	-
AgentNameDisplayType	nvarchar (50)	The display type of the name of the agent	YES	Refers to table AgentNameDisplayType_Enum
CreateArchive	bit	If an archive e.g. by a task schedule should be created	YES	-
ArchiveProtocol	nvarchar (MAX)	The protocol created during the last archive	YES	-
LastChanges	datetime	The recent date when data within the project had been changed	YES	-
IsLocked	bit	If the data within the project should not be changeed and the access for all users is restricted to read only	YES	-

Depending on:

• AgentNameDisplayType_Enum




Table ProjectUser

The projects to which users have access to



Column	Data type	Description	Nullable	Relation
LoginName	nvarchar (50)	The login name of the user	NO	Refers to table UserProxy
ProjectID	int	The ID of the default project of the user as stored in table ProjectProxy	NO	Refers to table ProjectProxy
ReadOnly	bit	If the user has only read access to data of this project Default value: (0)	YES	-

Depending on:

• ProjectProxy
• UserProxy




Table UserProxy

The user logins - refers to database DiversityUsers



Column	Data type	Description	Nullable	Relation
LoginName	nvarchar (50)	The login name of the user, Primary key	NO	-
CombinedNameCache	nvarchar (50)	A combined name of the user, created on the base of an entry in the module DiversityUsers	YES	-
UserURI	varchar (255)	Refers to UserInfo.UserID in database DiversityUsers	YES	-
ProjectID	int	The ID of the default project of the user as stored in table ProjectProxy	YES	Refers to table ProjectProxy
Queries	xml (MAX)	Queries created by the user	YES	-
AgentURI	varchar (255)	A link to a DiversityAgents module where further informations about the user is available.	YES	-
ID	int	ID of the user	NO	-
PrivacyConsent	bit	If the user consents the storage of his user name in the database	YES	-
PrivacyConsentDate	datetime	The time and date when the user consented or refused the storage of his user name in the database	YES	-

Depending on:

• ProjectProxy




VIEWS

View Agent_Core

Agents that are available for a user and are not ignored



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy	YES
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle	NO
DisplayText	nvarchar (204)	The name of the agent including indentation for synonyms	NO
Version	smallint	The version of a agent record (revision number, internally filled by system)	NO
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.	YES
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution	YES
GivenNamePostfix	nvarchar (50)	Variable part of name, correctly placed at end of given names	YES
InheritedNamePrefix	nvarchar (50)	Variable part of name, correctly placed at the beginning of the inherited names	YES
InheritedName	nvarchar (255)	The last names of the agent (if a person)	YES
InheritedNamePostfix	nvarchar (50)	Additions after inherited name, like generation (Jr., III.) or names of religious orders	YES
Abbreviation	nvarchar (50)	Abbreviation of the agent	YES
AgentType	nvarchar (50)	The type of the agent, e.g. person, company	YES
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"	YES
AgentGender	nvarchar (50)	The gender resp. sex of the agent	YES
Description	nvarchar (1000)	A description of the agent	YES
OriginalSpelling	nvarchar (200)	Name as originally written in e.g. chinese or cyrillic letters	YES
Notes	nvarchar (MAX)	Notes about the agent	YES
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year	YES
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent	YES
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent	YES
ValidFromYear	smallint	The year of the begin of the exsistence of the agent	YES
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year	YES
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent	YES
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent	YES
ValidUntilYear	smallint	The year of the end of the exsistence of the agent	YES
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.	YES
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded	YES
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died	YES
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources	YES
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"	YES
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'	YES
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null	YES
IgnoreButKeepForReference	bit	If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.	YES

Depending on:

• Agent
• AgentID_UserAvailable




View Agent_Main20





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy	YES
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle	NO
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.	YES
FirstNames	nvarchar (200)	-	YES
LastName	nvarchar (100)	-	YES
Abbreviation	nvarchar (50)	Abbreviation of the agent	YES
AgentType	nvarchar (50)	The type of the agent, e.g. person, company	YES
AgentRole	nvarchar (100)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"	YES
Description	nvarchar (500)	A description of the agent	YES
DateFrom	smalldatetime	-	YES
DateTo	smalldatetime	-	YES

Depending on:

• Agent




View AgentAddressList_Main20





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AddressID	int	-	NO
AddressType	nvarchar (50)	Type of the adress, e.g. private	YES
Country	nvarchar (100)	Country of the address	YES
City	nvarchar (200)	City of the address	YES
ZipCode	nvarchar (50)	-	YES
Street	nvarchar (200)	-	YES
Number	nvarchar (50)	-	YES
Address	nvarchar (200)	Free text postal address of the agent	YES
Phone	nvarchar (50)	-	YES
Mobile	nvarchar (50)	-	YES
Fax	nvarchar (50)	-	YES
Email	nvarchar (100)	E-mail address of the agent	YES
URL	nvarchar (100)	-	YES
Notes	nvarchar (100)	Notes about the agent	YES
ValidFrom	smalldatetime	The date when this address became valid as date according to ISO 8601	YES
ValidTo	smalldatetime	-	YES
IsPreferredAddress	bit	-	YES
DisplayText	nvarchar (554)	-	YES

Depending on:

• AgentAddress




View AgentAddressList_Main20_alt





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AddressID	int	-	NO
AddressType	nvarchar (50)	-	YES
Country	nvarchar (100)	-	YES
City	nvarchar (200)	-	YES
ZipCode	nvarchar (50)	-	YES
Street	nvarchar (200)	-	YES
Number	nvarchar (50)	-	YES
Address	nvarchar (200)	-	YES
Phone	nvarchar (50)	-	YES
Fax	nvarchar (50)	-	YES
Email	nvarchar (100)	-	YES
URL	nvarchar (100)	-	YES
Notes	nvarchar (100)	Notes about the agent	YES
ValidFrom	smalldatetime	-	YES
ValidTo	smalldatetime	-	YES
PreferredAddressID	int	-	NO
AddressDisplayText	nvarchar (554)	-	YES

Depending on:

• Agent
• AgentAddress




View AgentID_AvailableReadOnly

Available AgentIDs that are ReadOnly or Locked



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Foreign key)	NO

Depending on:

• AgentID_Locked
• AgentProject
• ProjectUser




View AgentID_FullAccess

ID of agents with full access (neither read only or locked)



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Foreign key)	NO

Depending on:

• AgentProject
• ProjectProxy
• ProjectUser




View AgentID_Locked

AgentIDs that are locked due to locking of the project



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Foreign key)	NO

Depending on:

• AgentProject
• ProjectProxy




View AgentID_ReadOnly

AgentIDs that are ReadOnly for a User or are locked due to locking of the project



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Foreign key)	NO

Depending on:

• AgentID_Locked
• AgentProject
• ProjectUser




View AgentID_UserAvailable

IDs of the agent available for a user



Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO

Depending on:

• Agent
• AgentProject
• ProjectUser




View AgentList_Main20





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AgentName	nvarchar (302)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle	YES

Depending on:

• Agent




View ApplicationSearchSelectionStrings_Core





Column	Data type	Description	Nullable
SQLStringIdentifier	varchar (50)	-	NO
ItemTable	varchar (50)	-	YES
SQLString	varchar (2000)	-	YES
Description	nvarchar (MAX)	Description of the resultset and the purpose of the query	YES

Depending on:

• ApplicationSearchSelectionStrings




View ProjectList

Projects available for a user



Column	Data type	Description	Nullable
ProjectID	int	The ID of the project, Primary key	NO
Project	nvarchar (50)	The name of the project as stored in the module DiversityProjects	NO
ReadOnly	int	If the user has only read access to data of this project	YES
IsLocked	bit	If the data within the project should not be changeed and the access for all users is restricted to read only	YES

Depending on:

• ProjectProxy
• ProjectUser




View PublicAgent





Column	Data type	Description	Nullable
DisplayText	nvarchar (200)	-	NO
URI	varchar (285)	-	YES
AgentID	int	Unique ID for the Agent (= Primary key)	NO
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy	YES
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle	NO
Version	smallint	The version of a agent record (revision number, internally filled by system)	NO
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.	YES
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution	YES
GivenNamePostfix	nvarchar (50)	Variable part of name, correctly placed at end of given names	YES
InheritedNamePrefix	nvarchar (50)	Variable part of name, correctly placed at the beginning of the inherited names	YES
InheritedName	nvarchar (255)	The last names of the agent (if a person)	YES
InheritedNamePostfix	nvarchar (50)	Additions after inherited name, like generation (Jr., III.) or names of religious orders	YES
Abbreviation	nvarchar (50)	Abbreviation of the agent	YES
AgentType	nvarchar (50)	The type of the agent, e.g. person, company	YES
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"	YES
AgentGender	nvarchar (50)	The gender resp. sex of the agent	YES
Description	nvarchar (1000)	A description of the agent	YES
OriginalSpelling	nvarchar (200)	Name as originally written in e.g. chinese or cyrillic letters	YES
Notes	nvarchar (MAX)	Notes about the agent	YES
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year	YES
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent	YES
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent	YES
ValidFromYear	smallint	The year of the begin of the exsistence of the agent	YES
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year	YES
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent	YES
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent	YES
ValidUntilYear	smallint	The year of the end of the exsistence of the agent	YES
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.	YES
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded	YES
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died	YES
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources	YES
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"	YES
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentNames
• BaseURL
• DefaultAgentNameDisplayType




View PublicContactInformation4





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
DisplayOrder	tinyint	Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key)	NO
ParentName	nvarchar (200)	-	NO
AddressType	nvarchar (50)	Type of the adress, e.g. private	YES
Country	nvarchar (255)	Country of the address	YES
City	nvarchar (255)	City of the address	YES
PostalCode	nvarchar (50)	ZIP or postcode of the address (usually output before or after the city)	YES
Streetaddress	nvarchar (255)	Usually street name and number, but may also contain post office box	YES
Address	nvarchar (255)	Free text postal address of the agent	YES
Telephone	nvarchar (50)	Phone number, including area code	YES
CellularPhone	nvarchar (50)	The number of a mobile telephone device of the agent	YES
Telefax	nvarchar (50)	Fax number, including area code	YES
Email	nvarchar (255)	E-mail address of the agent	YES
URI	nvarchar (255)	URI pointing to a homepage containing further information	YES
Notes	nvarchar (MAX)	Notes about the agent	YES
ValidFrom	datetime	The date when this address became valid as date according to ISO 8601	YES
ValidUntil	datetime	The date of the expiration of the validity of this address as date according to ISO 8601	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentContactInformation




View PublicIdentifier





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
Identifier	nvarchar (400)	Identifier for the agent, part of PK	NO
IdentifierURI	varchar (500)	URI of Identifier	YES
Type	nvarchar (50)	Type of the identifier as defined in table AgentIdentifierType_Enum	YES
Notes	nvarchar (MAX)	Notes about the agent	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentIdentifier




View PublicImage





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
URI	varchar (255)	The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources	NO
Description	nvarchar (MAX)	A description of the agent	YES
Type	nvarchar (50)	The type of the image	YES
Sequence	int	The sequence of the image	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentImage




View PublicReference





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
ReferenceTitle	nvarchar (255)	The title of the publication where information about the agent was published. Note this is only a cached value where ReferenceURI is present	NO
ReferenceURI	varchar (255)	URI of reference where information about the agent, e.g. referring to the module DiversityReferences	YES
ReferenceDetails	nvarchar (50)	Details within the reference, e.g. pages	YES
ContainsImage	tinyint	If the reference contains an image of the agent	YES
ContainsReferencelist	tinyint	If the reference contains a publication list of the agent	YES
Notes	nvarchar (255)	Notes about the agent	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentReference




View PublicRelation





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
RelatedAgentID	int	The AgentID of the related agent	NO
RelationType	nvarchar (50)	The type of the relation between the agents, e.g. "parent of", "child of", "married to"	YES
Notes	nvarchar (255)	Notes about the agent	YES
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.	YES

Depending on:

• Agent
• AgentRelation




View UserInfo

Information about the user as stored in table UserProxy



Column	Data type	Description	Nullable
LoginName	nvarchar (50)	The login name of the user, Primary key	NO
CombinedNameCache	nvarchar (50)	A combined name of the user, created on the base of an entry in the module DiversityUsers	YES
UserURI	varchar (255)	Refers to UserInfo.UserID in database DiversityUsers	YES
ProjectID	int	The ID of the default project of the user as stored in table ProjectProxy	YES

Depending on:

• UserProxy




View ViewAgentAddress4





Column	Data type	Description	Nullable
AgentID	int	Unique ID for the Agent (= Primary key)	NO
DisplayOrder	tinyint	Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key)	NO
ParentName	nvarchar (200)	-	NO
AddressType	nvarchar (50)	Type of the adress, e.g. private	YES
Country	nvarchar (255)	Country of the address	YES
City	nvarchar (255)	City of the address	YES
PostalCode	nvarchar (50)	ZIP or postcode of the address (usually output before or after the city)	YES
Streetaddress	nvarchar (255)	Usually street name and number, but may also contain post office box	YES
Address	nvarchar (255)	Free text postal address of the agent	YES
Telephone	nvarchar (50)	Phone number, including area code	YES
CellularPhone	nvarchar (50)	The number of a mobile telephone device of the agent	YES
Telefax	nvarchar (50)	Fax number, including area code	YES
Email	nvarchar (255)	E-mail address of the agent	YES
URI	nvarchar (255)	URI pointing to a homepage containing further information	YES
Notes	nvarchar (MAX)	Notes about the agent	YES
ValidFrom	datetime	The date when this address became valid as date according to ISO 8601	YES
ValidUntil	datetime	The date of the expiration of the validity of this address as date according to ISO 8601	YES

Depending on:

• Agent
• AgentContactInformation




View ViewAgentNames

The names of the agents as retrieved for the default display type with function AgentNames



Column	Data type	Description	Nullable
AgentID	int	The ID of the agent	NO
AgentName	nvarchar (200)	The name of the agent according to the selected display type	NO

Depending on:

• AgentNames
• DefaultAgentNameDisplayType




View ViewBaseURL

Provides the basic address for accessing the database as defined in function BaseURL



Column	Data type	Description	Nullable
BaseURL	varchar (255)	Basic address for accessing the database	YES

Depending on:

• BaseURL




View ViewDefaultAgentNameDisplayType

The default display type as set for the default project as defined in function DefaultAgentNameDisplayType



Column	Data type	Description	Nullable
DefaultAgentNameDisplayType	nvarchar (50)	The default display type	YES

Depending on:

• DefaultAgentNameDisplayType




View ViewDiversityWorkbenchModule

Provides the name of the DiversityWorkbench module as defined in function DiversityWorkbenchModule



Column	Data type	Description	Nullable
DiversityWorkbenchModule	nvarchar (50)	The name of the DiversityWorkbench module	YES

Depending on:

• DiversityWorkbenchModule




FUNCTIONS

Function AddressType_Main20





Parameter	DataType	Description
@LanguageCode	char (2)	-





Column	DataType	Description
Code	nvarchar (50)	A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.
Description	nvarchar (500)	Description of enumerated object, displayed in the user interface
Abbreviation	nvarchar (50)	-







Function AgentAddress

The address of the agent as collected from the hierarchy



Parameter	DataType	Description
@AgentID	int	The ID of the Agent





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
DisplayOrder	tinyint	Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key)
ParentName	nvarchar (4000)	The name of the superior agent within the hierarchy
AddressType	nvarchar (50)	Type of the adress, e.g. private
Country	nvarchar (255)	Country of the address
City	nvarchar (255)	City of the address
PostalCode	nvarchar (50)	ZIP or postcode of the address (usually output before or after the city)
Streetaddress	nvarchar (255)	Usually street name and number, but may also contain post office box
Address	nvarchar (255)	Free text postal address of the agent
Telephone	nvarchar (50)	Phone number, including area code
CellularPhone	nvarchar (50)	The number of a mobile telephone device of the agent
Telefax	nvarchar (50)	Fax number, including area code
Email	nvarchar (255)	E-mail address of the agent
URI	nvarchar (255)	URI pointing to a homepage containing further information
Notes	nvarchar (MAX)	Notes about the agent
ValidFrom	datetime	The date when this address became valid as date according to ISO 8601
ValidUntil	datetime	The date of the expiration of the validity of this address as date according to ISO 8601

Depending on:

• Agent
• AgentContactInformation






Function AgentChildNodes

Returns the list of agents within the hierarchy underneath the agent with the given ID (=AgentID)



Parameter	DataType	Description
@ID	int	The AgentID of the agent for which the hierarchy should be retrieved





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
ContentLanguage	nvarchar (50)	The language of the content

Depending on:

• Agent






Function AgentContactInformation_Public

Provides the first contact information that is not withheld and valid including contact information of parent agents



Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
DisplayOrder	tinyint	Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key)
ParentName	nvarchar (200)	-
AddressType	nvarchar (50)	Type of the adress, e.g. private
Country	nvarchar (255)	Country of the address
City	nvarchar (255)	City of the address
PostalCode	nvarchar (50)	ZIP or postcode of the address (usually output before or after the city)
Streetaddress	nvarchar (255)	Usually street name and number, but may also contain post office box
Address	nvarchar (255)	Free text postal address of the agent
Telephone	nvarchar (50)	Phone number, including area code
CellularPhone	nvarchar (50)	The number of a mobile telephone device of the agent
Telefax	nvarchar (50)	Fax number, including area code
Email	nvarchar (255)	E-mail address of the agent
URI	nvarchar (255)	URI pointing to a homepage containing further information
Notes	nvarchar (MAX)	Notes about the agent
ValidFrom	datetime	The date when this address became valid as date according to ISO 8601
ValidUntil	datetime	The date of the expiration of the validity of this address as date according to ISO 8601
LogUpdatedWhen	smalldatetime	Date and time when the data were last updated.

Depending on:

• Agent
• AgentContactInformation






Function AgentHierarchy

Returns the list of agents within the hierarchy starting at the topmost agent related to the agent with the given AgentID



Parameter	DataType	Description
@AgentID	int	The AgentID of the agent for which the hierarchy should be retrieved





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
ContentLanguage	nvarchar (50)	The language of the content

Depending on:

• Agent
• AgentChildNodes
• AgentTopID






Function AgentHierarchyAllSuperior

Returns the list of all superior agents within the hierarchy and other hierarchies related to the agent with the given AgentID



Parameter	DataType	Description
@AgentID	int	The ID of the Agent





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle

Depending on:

• Agent
• AgentHierarchyOther
• AgentSuperiorList






Function AgentNames

Returns a table that lists all the agents with their names according to the selected display type



Parameter	DataType	Description
@DisplayType	nvarchar (50)	The type of the display as documented in the table dbo.AgentNameDisplayType_Enum





Column	DataType	Description
AgentID	int	The ID of the agent
AgentName	nvarchar (200)	The name of the agent according to the selected display type

Depending on:

• Agent






Function AgentSuperiorList

Returns the list of superior agents as retrieved from the hierarchy



Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
ContentLanguage	nvarchar (50)	The language of the content
DisplayOrder	int	The display order according to the hierarchy where 1 corresponds to the selected agent with increasing values for higher entries within the hierarchy

Depending on:

• Agent






Function AgentSynonymTopID

Returns the top AgentID within the synyonym hierarchy for a given AgentID



DataType: int





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)

Depending on:

• Agent






Function AgentSynonymy

Returns all agents within the synonymy of the given agent



Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
ContentLanguage	nvarchar (50)	The language of the content

Depending on:

• Agent
• AgentSynonymTopID
• AgentSynonymyChildNodes






Function AgentSynonymyChildNodes

The depending synonymys of a given agent



Parameter	DataType	Description
@ID	int	The AgentID of the agent for which the depending synonymys should be retrieved





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
SynonymToAgentID	int	The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources
SynonymisationType	nvarchar (50)	The type of the synonymisation like "replaced with", "synonym to"
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
PlaceOfBirth	nvarchar (500)	The place (e.g. a city) where a person was born or an institution was founded
PlaceOfDeath	nvarchar (500)	The place (e.g.a city) where the person died
DataWithholdingReason	nvarchar (255)	If the dataset is withhold, the reason for withholding the data, otherwise null
ContentLanguage	nvarchar (50)	The language of the content

Depending on:

• Agent






Function AgentTitle_Main20





Parameter	DataType	Description
@LanguageCode	char (2)	-





Column	DataType	Description
Code	nvarchar (50)	-
Description	nvarchar (500)	-
Abbreviation	nvarchar (50)	-







Function AgentTopID

Returns the top ID within the hierarchy for a given AgentID from the table Agent.



DataType: int





Parameter	DataType	Description
@AgentID	int	The AgentID of the agent for which the top ID should be retrieved

Depending on:

• Agent






Function AgentType_Main20





Parameter	DataType	Description
@LanguageCode	char (2)	-





Column	DataType	Description
Code	nvarchar (50)	-
Description	nvarchar (500)	-
Abbreviation	nvarchar (50)	-







Function ApplicationSearchItemPrimaryKeyColumn





DataType: nvarchar (300)





Parameter	DataType	Description
@TableName	varchar (50)	-







Function BaseURL

Provides the basic address for accessing the database



DataType: varchar (255)







Function DefaultAgentNameDisplayType

The default display type as set for the default project



DataType: nvarchar (50)

Depending on:

• DefaultProjectID
• ProjectProxy






Function DefaultProjectID

Returns the default ProjectID for a user as set in table UserProxy



DataType: int

Depending on:

• ProjectUser
• UserProxy






Function DiversityWorkbenchModule

The name of the DiversityWorkbench module



DataType: nvarchar (50)







Function HierarchyTopID_Main20





DataType: varchar (11)





Parameter	DataType	Description
@Table	nvarchar (50)	-
@ID	int	-

Depending on:

• Agent






Function ReplacedWithAgentID





DataType: int





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)

Depending on:

• Agent






Function SearchMenuColumns





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
TableName	varchar (50)	-
ColumnName	varchar (50)	-
DataType	varchar (50)	-
ColumnLength	int	-
ColumnDescription	nvarchar (1000)	-
ForeignKeyTable	varchar (50)	-
ForeignKeyColumn	varchar (50)	-
MenuTab	varchar (50)	-

Depending on:

• SearchMenuInferiorTables
• SearchMenuSuperiorTables






Function SearchMenuForeignKeys





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
TableName	varchar (50)	-
ColumnName	varchar (50)	-
ForeignKeyTable	varchar (50)	-
ForeignKeyColumn	varchar (50)	-

Depending on:

• SearchMenuInferiorTables
• SearchMenuSuperiorTables






Function SearchMenuInferiorTables





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
TableName	varchar (50)	-







Function SearchMenuOrderColumn





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
ColumnName	varchar (50)	-







Function SearchMenuSuperiorTables





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
TableName	varchar (50)	-







Function SearchMenuTableTabs





Parameter	DataType	Description
@TableName	varchar (50)	-





Column	DataType	Description
TableName	varchar (50)	-
TableTab	nvarchar (50)	-

Depending on:

• SearchMenuInferiorTables
• SearchMenuSuperiorTables






Function SuperiorAgentList





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)





Column	DataType	Description
AgentID	int	Unique ID for the Agent (= Primary key)
AgentParentID	int	The AgentID of the superior agent if agents are organized within a hierarchy
AgentName	nvarchar (200)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle
Version	smallint	The version of a agent record (revision number, internally filled by system)
AgentTitle	nvarchar (50)	The title of the agent, e.g. Dr., Prof.
GivenName	nvarchar (255)	The first names of the agent (if a person) or the name of e.g. an institution
InheritedName	nvarchar (255)	The last names of the agent (if a person)
Abbreviation	nvarchar (50)	Abbreviation of the agent
AgentType	nvarchar (50)	The type of the agent, e.g. person, company
AgentRole	nvarchar (255)	The role of an agent esp. a person within an organization. e.g. "Database Administrator" or "Curator"
Description	nvarchar (1000)	A description of the agent
Notes	nvarchar (500)	Notes about the agent
ValidFromDate	datetime	The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year
ValidFromDay	tinyint	The day of the begin of the exsistence of the agent
ValidFromMonth	tinyint	The month of the begin of the exsistence of the agent
ValidFromYear	smallint	The year of the begin of the exsistence of the agent
ValidUntilDate	datetime	The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year
ValidUntilDay	tinyint	The day of the end of the exsistence of the agent
ValidUntilMonth	tinyint	The month of the end of the exsistence of the agent
ValidUntilYear	smallint	The year of the end of the exsistence of the agent
ValidDateSupplement	nvarchar (255)	Verbal or additional date information, e.g. 'end of summer 1985', 'first quarter'. The time of the valid date if necessary.
ReplacedWithAgentID	int	-
RevisionLevel	nvarchar (50)	The level of the revision of the agent, e.g. 'unchecked', 'final revision'
DisplayOrder	int	-

Depending on:

• Agent






Function UserID

ID of the User as stored in table UserProxy



DataType: int

Depending on:

• UserProxy






Function Version

The version of the database



DataType: nvarchar (8)







Function VersionClient

Version of the client software compatible with the version of the database



DataType: nvarchar (11)







PROCEDURES

Procedure procInsertAgentAddressCopy_Main20





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)
@AddressID	int	-
@CopyID	int	-
@Address	nvarchar (200)	Free text postal address of the agent

Depending on:

• AgentAddress






Procedure procInsertAgentAddressNew_Main20





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)
@AddressID	int	-
@Address	nvarchar (50)	Free text postal address of the agent

Depending on:

• AgentAddress






Procedure procInsertAgentCopy

Creates a copy of a given agent and returns the AgentID of the new agent



Parameter	DataType	Description
@AgentID	int	The AgentID of the created agent
@CopyID	int	The AgentID of the agent that should be copied
@AgentName	nvarchar (200)	A temporary display text for the created agent

Depending on:

• Agent
• AgentContactInformation
• AgentExternalID
• AgentImage
• AgentKeyword
• AgentProject
• AgentReference
• AgentRelation






Procedure procInsertAgentCopy_Main20





Parameter	DataType	Description
@AgentID	int	The AgentID of the created agent
@CopyID	int	The AgentID of the agent that should be copied
@AgentName	nvarchar (50)	A temporary display text for the created agent

Depending on:

• Agent
• AgentAddress






Procedure procInsertAgentNew





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)
@AgentName	nvarchar (500)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle

Depending on:

• Agent






Procedure procInsertAgentNew_Main20





Parameter	DataType	Description
@AgentID	int	Unique ID for the Agent (= Primary key)
@AgentName	nvarchar (50)	The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle

Depending on:

• Agent






Procedure procSetVersionAgent

Setting the version of a dataset



Parameter	DataType	Description
@ID	int	The AgentID of the agent

Depending on:

• Agent






Procedure SetUserProjects





Parameter	DataType	Description
@User	varchar (50)	-

Depending on:

• UserProxy






ROLES

DiversityWorkbenchAdministrator

Role for the adminstration of the database



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
AddressType_Enum	Diversity Workbench User					TABLE
Agent	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
Agent_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentContactInformation	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
AgentContactInformation_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentDescriptor	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentDescriptor_log	Diversity Workbench User	Diversity Workbench Editor				TABLE
AgentDescriptorType_Enum	Diversity Workbench User	•	•	•		TABLE
AgentExternalDatabase	Diversity Workbench User					TABLE
AgentExternalDatabase_log						TABLE
AgentExternalID	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	•		TABLE
AgentExternalID_log						TABLE
AgentGender_Enum	Diversity Workbench User					TABLE
AgentHierarchyOther	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentHierarchyOther_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentIdentifier	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentIdentifier_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentIdentifierType_Enum	Diversity Workbench User	•	•	•		TABLE
AgentImage	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentImage_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentImageType_Enum	Diversity Workbench User	•	•	•		TABLE
AgentKeyword	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentKeyword_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentNameDisplayType_Enum	Diversity Workbench User					TABLE
AgentProject	Diversity Workbench User	Diversity Workbench Editor		•		TABLE
AgentProject_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentReference	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentReference_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentRelation	Diversity Workbench User	Diversity Workbench Editor	Diversity Workbench Editor	Diversity Workbench Editor		TABLE
AgentRelation_log	Diversity Workbench Editor	Diversity Workbench Editor				TABLE
AgentRelationType_Enum	Diversity Workbench User					TABLE
AgentSynonymisationType_Enum	Diversity Workbench User					TABLE
AgentTitle_Enum	Diversity Workbench User					TABLE
AgentType_Enum	Diversity Workbench User					TABLE
ApplicationEntityDescription						TABLE
ApplicationSearchSelectionStrings	Diversity Workbench User	•	•	•		TABLE
LanguageCode_Enum	Diversity Workbench User	•	•	•		TABLE
ProjectProxy	Diversity Workbench User	•	•	•		TABLE
ProjectUser	Diversity Workbench User	•	•	•		TABLE
RevisionLevel_Enum	Diversity Workbench User					TABLE
UserProxy	Diversity Workbench User	•	•	•		TABLE
Agent_Core	Diversity Workbench User					VIEW
Agent_Main20						VIEW
AgentAddressList_Main20						VIEW
AgentAddressList_Main20_alt						VIEW
AgentID_AvailableReadOnly	Diversity Workbench User					VIEW
AgentID_FullAccess	Diversity Workbench User					VIEW
AgentID_Locked	Diversity Workbench User					VIEW
AgentID_ReadOnly	Diversity Workbench User					VIEW
AgentID_UserAvailable	Diversity Workbench User					VIEW
AgentList_Main20						VIEW
ApplicationSearchSelectionStrings_Core	Diversity Workbench User					VIEW
ProjectList	Diversity Workbench User					VIEW
PublicAgent	Diversity Workbench User					VIEW
PublicContactInformation4	Diversity Workbench User					VIEW
PublicIdentifier	Diversity Workbench User					VIEW
PublicImage	Diversity Workbench User					VIEW
PublicReference	Diversity Workbench User					VIEW
PublicRelation	Diversity Workbench User					VIEW
UserInfo	Diversity Workbench Editor		Diversity Workbench Editor			VIEW
ViewAgentAddress4	Diversity Workbench User					VIEW
ViewAgentNames	Diversity Workbench User					VIEW
ViewBaseURL	Diversity Workbench User					VIEW
ViewDefaultAgentNameDisplayType	Diversity Workbench User					VIEW
ViewDiversityWorkbenchModule	Diversity Workbench User					VIEW
AddressType_Main20						FUNCTION
AgentAddress	Diversity Workbench User					FUNCTION
AgentChildNodes	Diversity Workbench User					FUNCTION
AgentContactInformation_Public	Diversity Workbench User					FUNCTION
AgentHierarchy	Diversity Workbench User					FUNCTION
AgentHierarchyAllSuperior	Diversity Workbench User					FUNCTION
AgentNames	Diversity Workbench User					FUNCTION
AgentSuperiorList	Diversity Workbench User					FUNCTION
AgentSynonymTopID					Diversity Workbench User	FUNCTION
AgentSynonymy	Diversity Workbench User					FUNCTION
AgentSynonymyChildNodes	Diversity Workbench User					FUNCTION
AgentTitle_Main20						FUNCTION
AgentTopID					Diversity Workbench User	FUNCTION
AgentType_Main20						FUNCTION
ApplicationSearchItemPrimaryKeyColumn						FUNCTION
BaseURL					Diversity Workbench User	FUNCTION
DefaultAgentNameDisplayType					Diversity Workbench User	FUNCTION
DefaultProjectID					Diversity Workbench User	FUNCTION
DiversityWorkbenchModule					Diversity Workbench User	FUNCTION
HierarchyTopID_Main20						FUNCTION
ReplacedWithAgentID						FUNCTION
SearchMenuColumns						FUNCTION
SearchMenuForeignKeys						FUNCTION
SearchMenuInferiorTables						FUNCTION
SearchMenuOrderColumn						FUNCTION
SearchMenuSuperiorTables						FUNCTION
SearchMenuTableTabs						FUNCTION
SuperiorAgentList	Diversity Workbench User					FUNCTION
UserID					Diversity Workbench User	FUNCTION
Version					Diversity Workbench User	FUNCTION
VersionClient					Diversity Workbench User	FUNCTION
procInsertAgentAddressCopy_Main20						PROCEDURE
procInsertAgentAddressNew_Main20						PROCEDURE
procInsertAgentCopy					Diversity Workbench Editor	PROCEDURE
procInsertAgentCopy_Main20						PROCEDURE
procInsertAgentNew						PROCEDURE
procInsertAgentNew_Main20						PROCEDURE
procSetVersionAgent					Diversity Workbench Editor	PROCEDURE
SetUserProjects						PROCEDURE

Inheriting from roles:

• DiversityWorkbenchEditor






DiversityWorkbenchEditor

Role with write access for the database



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
AddressType_Enum	Diversity Workbench User					TABLE
Agent	Diversity Workbench User	•	•			TABLE
Agent_log	•	•				TABLE
AgentContactInformation	Diversity Workbench User	•	•			TABLE
AgentContactInformation_log	•	•				TABLE
AgentDescriptor	Diversity Workbench User	•	•	•		TABLE
AgentDescriptor_log	Diversity Workbench User	•				TABLE
AgentDescriptorType_Enum	Diversity Workbench User					TABLE
AgentExternalDatabase	Diversity Workbench User					TABLE
AgentExternalDatabase_log						TABLE
AgentExternalID	Diversity Workbench User	•	•			TABLE
AgentExternalID_log						TABLE
AgentGender_Enum	Diversity Workbench User					TABLE
AgentHierarchyOther	Diversity Workbench User	•	•	•		TABLE
AgentHierarchyOther_log	•	•				TABLE
AgentIdentifier	Diversity Workbench User	•	•	•		TABLE
AgentIdentifier_log	•	•				TABLE
AgentIdentifierType_Enum	Diversity Workbench User					TABLE
AgentImage	Diversity Workbench User	•	•	•		TABLE
AgentImage_log	•	•				TABLE
AgentImageType_Enum	Diversity Workbench User					TABLE
AgentKeyword	Diversity Workbench User	•	•	•		TABLE
AgentKeyword_log	•	•				TABLE
AgentNameDisplayType_Enum	Diversity Workbench User					TABLE
AgentProject	Diversity Workbench User	•		•		TABLE
AgentProject_log	•	•				TABLE
AgentReference	Diversity Workbench User	•	•	•		TABLE
AgentReference_log	•	•				TABLE
AgentRelation	Diversity Workbench User	•	•	•		TABLE
AgentRelation_log	•	•				TABLE
AgentRelationType_Enum	Diversity Workbench User					TABLE
AgentSynonymisationType_Enum	Diversity Workbench User					TABLE
AgentTitle_Enum	Diversity Workbench User					TABLE
AgentType_Enum	Diversity Workbench User					TABLE
ApplicationEntityDescription						TABLE
ApplicationSearchSelectionStrings	Diversity Workbench User					TABLE
LanguageCode_Enum	Diversity Workbench User					TABLE
ProjectProxy	Diversity Workbench User					TABLE
ProjectUser	Diversity Workbench User					TABLE
RevisionLevel_Enum	Diversity Workbench User					TABLE
UserProxy	Diversity Workbench User		Diversity Workbench User			TABLE
Agent_Core	Diversity Workbench User					VIEW
Agent_Main20						VIEW
AgentAddressList_Main20						VIEW
AgentAddressList_Main20_alt						VIEW
AgentID_AvailableReadOnly	Diversity Workbench User					VIEW
AgentID_FullAccess	Diversity Workbench User					VIEW
AgentID_Locked	Diversity Workbench User					VIEW
AgentID_ReadOnly	Diversity Workbench User					VIEW
AgentID_UserAvailable	Diversity Workbench User					VIEW
AgentList_Main20						VIEW
ApplicationSearchSelectionStrings_Core	Diversity Workbench User					VIEW
ProjectList	Diversity Workbench User					VIEW
PublicAgent	Diversity Workbench User					VIEW
PublicContactInformation4	Diversity Workbench User					VIEW
PublicIdentifier	Diversity Workbench User					VIEW
PublicImage	Diversity Workbench User					VIEW
PublicReference	Diversity Workbench User					VIEW
PublicRelation	Diversity Workbench User					VIEW
UserInfo	•		•			VIEW
ViewAgentAddress4	Diversity Workbench User					VIEW
ViewAgentNames	Diversity Workbench User					VIEW
ViewBaseURL	Diversity Workbench User					VIEW
ViewDefaultAgentNameDisplayType	Diversity Workbench User					VIEW
ViewDiversityWorkbenchModule	Diversity Workbench User					VIEW
AddressType_Main20						FUNCTION
AgentAddress	Diversity Workbench User					FUNCTION
AgentChildNodes	Diversity Workbench User					FUNCTION
AgentContactInformation_Public	Diversity Workbench User					FUNCTION
AgentHierarchy	Diversity Workbench User					FUNCTION
AgentHierarchyAllSuperior	Diversity Workbench User					FUNCTION
AgentNames	Diversity Workbench User					FUNCTION
AgentSuperiorList	Diversity Workbench User					FUNCTION
AgentSynonymTopID					Diversity Workbench User	FUNCTION
AgentSynonymy	Diversity Workbench User					FUNCTION
AgentSynonymyChildNodes	Diversity Workbench User					FUNCTION
AgentTitle_Main20						FUNCTION
AgentTopID					Diversity Workbench User	FUNCTION
AgentType_Main20						FUNCTION
ApplicationSearchItemPrimaryKeyColumn						FUNCTION
BaseURL					Diversity Workbench User	FUNCTION
DefaultAgentNameDisplayType					Diversity Workbench User	FUNCTION
DefaultProjectID					Diversity Workbench User	FUNCTION
DiversityWorkbenchModule					Diversity Workbench User	FUNCTION
HierarchyTopID_Main20						FUNCTION
ReplacedWithAgentID						FUNCTION
SearchMenuColumns						FUNCTION
SearchMenuForeignKeys						FUNCTION
SearchMenuInferiorTables						FUNCTION
SearchMenuOrderColumn						FUNCTION
SearchMenuSuperiorTables						FUNCTION
SearchMenuTableTabs						FUNCTION
SuperiorAgentList	Diversity Workbench User					FUNCTION
UserID					Diversity Workbench User	FUNCTION
Version					Diversity Workbench User	FUNCTION
VersionClient					Diversity Workbench User	FUNCTION
procInsertAgentAddressCopy_Main20						PROCEDURE
procInsertAgentAddressNew_Main20						PROCEDURE
procInsertAgentCopy					•	PROCEDURE
procInsertAgentCopy_Main20						PROCEDURE
procInsertAgentNew						PROCEDURE
procInsertAgentNew_Main20						PROCEDURE
procSetVersionAgent					•	PROCEDURE
SetUserProjects						PROCEDURE

Inheriting from roles:

• DiversityWorkbenchUser






DiversityWorkbenchUser

Role with read only access to the database



Permissions	SELECT	INSERT	UPDATE	DELETE	EXECUTE	Type
AddressType_Enum	•					TABLE
Agent	•					TABLE
Agent_log						TABLE
AgentContactInformation	•					TABLE
AgentContactInformation_log						TABLE
AgentDescriptor	•					TABLE
AgentDescriptor_log	•					TABLE
AgentDescriptorType_Enum	•					TABLE
AgentExternalDatabase	•					TABLE
AgentExternalDatabase_log						TABLE
AgentExternalID	•					TABLE
AgentExternalID_log						TABLE
AgentGender_Enum	•					TABLE
AgentHierarchyOther	•					TABLE
AgentHierarchyOther_log						TABLE
AgentIdentifier	•					TABLE
AgentIdentifier_log						TABLE
AgentIdentifierType_Enum	•					TABLE
AgentImage	•					TABLE
AgentImage_log						TABLE
AgentImageType_Enum	•					TABLE
AgentKeyword	•					TABLE
AgentKeyword_log						TABLE
AgentNameDisplayType_Enum	•					TABLE
AgentProject	•					TABLE
AgentProject_log						TABLE
AgentReference	•					TABLE
AgentReference_log						TABLE
AgentRelation	•					TABLE
AgentRelation_log						TABLE
AgentRelationType_Enum	•					TABLE
AgentSynonymisationType_Enum	•					TABLE
AgentTitle_Enum	•					TABLE
AgentType_Enum	•					TABLE
ApplicationEntityDescription						TABLE
ApplicationSearchSelectionStrings	•					TABLE
LanguageCode_Enum	•					TABLE
ProjectProxy	•					TABLE
ProjectUser	•					TABLE
RevisionLevel_Enum	•					TABLE
UserProxy	•		•			TABLE
Agent_Core	•					VIEW
Agent_Main20						VIEW
AgentAddressList_Main20						VIEW
AgentAddressList_Main20_alt						VIEW
AgentID_AvailableReadOnly	•					VIEW
AgentID_FullAccess	•					VIEW
AgentID_Locked	•					VIEW
AgentID_ReadOnly	•					VIEW
AgentID_UserAvailable	•					VIEW
AgentList_Main20						VIEW
ApplicationSearchSelectionStrings_Core	•					VIEW
ProjectList	•					VIEW
PublicAgent	•					VIEW
PublicContactInformation4	•					VIEW
PublicIdentifier	•					VIEW
PublicImage	•					VIEW
PublicReference	•					VIEW
PublicRelation	•					VIEW
UserInfo	•					VIEW
ViewAgentAddress4	•					VIEW
ViewAgentNames	•					VIEW
ViewBaseURL	•					VIEW
ViewDefaultAgentNameDisplayType	•					VIEW
ViewDiversityWorkbenchModule	•					VIEW
AddressType_Main20						FUNCTION
AgentAddress	•					FUNCTION
AgentChildNodes	•					FUNCTION
AgentContactInformation_Public	•					FUNCTION
AgentHierarchy	•					FUNCTION
AgentHierarchyAllSuperior	•					FUNCTION
AgentNames	•					FUNCTION
AgentSuperiorList	•					FUNCTION
AgentSynonymTopID					•	FUNCTION
AgentSynonymy	•					FUNCTION
AgentSynonymyChildNodes	•					FUNCTION
AgentTitle_Main20						FUNCTION
AgentTopID					•	FUNCTION
AgentType_Main20						FUNCTION
ApplicationSearchItemPrimaryKeyColumn						FUNCTION
BaseURL					•	FUNCTION
DefaultAgentNameDisplayType					•	FUNCTION
DefaultProjectID					•	FUNCTION
DiversityWorkbenchModule					•	FUNCTION
HierarchyTopID_Main20						FUNCTION
ReplacedWithAgentID						FUNCTION
SearchMenuColumns						FUNCTION
SearchMenuForeignKeys						FUNCTION
SearchMenuInferiorTables						FUNCTION
SearchMenuOrderColumn						FUNCTION
SearchMenuSuperiorTables						FUNCTION
SearchMenuTableTabs						FUNCTION
SuperiorAgentList	•					FUNCTION
UserID					•	FUNCTION
Version					•	FUNCTION
VersionClient					•	FUNCTION
procInsertAgentAddressCopy_Main20						PROCEDURE
procInsertAgentAddressNew_Main20						PROCEDURE
procInsertAgentCopy						PROCEDURE
procInsertAgentCopy_Main20						PROCEDURE
procInsertAgentNew						PROCEDURE
procInsertAgentNew_Main20						PROCEDURE
procSetVersionAgent						PROCEDURE
SetUserProjects						PROCEDURE