Table of contents

All tables [ show/hide ]

Tables in Master data [ show/hide ]

Tables in Profile data [ show/hide ]

Tables in Request data [ show/hide ]

Tables in Role data [ show/hide ]

Tables in System data [ show/hide ]

Tables in WAR Metadata [ show/hide ]

tblAdminGroupMemberships

List of users who are administrators of various parts of the system.

Columns

ColumnTypeDescription
UserIDinteger
(read-only)
ID of the user who is in a managerial role.
DepartmentIDinteger
(optional, read-only)
ID of the department the user has management rights over.
ResourceIDinteger
(optional, read-only)
ID of the resource the user has management rights over.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DepartmenttblDepartment
(read-only)
The department the user has management rights over.
ResourcetblResource
(read-only)
The resource the user has management rights over.
UsertblUsers
(read-only)
The user who is in a managerial role.

tblAttachments

Storage for attachments relating to a request, or part thereof.

Columns

ColumnTypeDescription
RequestIDinteger
(read-only)
The ID of the request the attachment relates to.
RequestLineIDinteger
(optional)
The ID of the specific request line the attachment relates to.
Filenamestring(128)
(read-only)
The original name of the file.
Filetypestring(128)The MIME type of the file.
Datastring(128)The attachment data.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RequestLinetblRequestLine
(read-only)
The request line the attachment relates to.
RequesttblRequestHeader
(read-only)
The request the attachment relates to.

tblAudit

The audit trail.

Columns

ColumnTypeDescription
IDuniqueid
(read-only)
ID of the line, used only to provide uniqueness.
EventTimedatetimeTimestamp of the event.
Sourcestring(64)Source -- either a subsystem or a user name.
EventTypestring(32)Type of audit event.
SeverityintegerSeverity of audit event: 0 = catastrophic failure, 1 = error, 2 = warning, 3 = notice, 4 = debug 1 etc..
Descriptionstring(255)Description of audit event.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

tblAuthGroup

Holds details of each authorization group – name etc.

Columns

ColumnTypeDescription
IDautoid
(read-only)
ID of the auth group
Namestring(128)name of the auth group
Commentstring(128)a comment
LeadMemberIDintegerUser ID of the lead member
DepartmentIDinteger
(optional)
The ID of the department owning the authorization group; governs authority to edit this auth group..
ResourceIDinteger
(optional)
The ID of the resource the authorization group relates to; governs authority to edit this auth group.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DepartmenttblDepartmentThe department owning the authorization group.
ResourcetblResourceThe resource the authorization group relates to.
LeadMembertblUsersThe lead user of the authorization group, having ability to delegate approval.

tblAuthGroupMember

List of users in each authorization group

Columns

ColumnTypeDescription
AuthGroupIDinteger
(read-only)
ID of the auth group
UserIDinteger
(read-only)
ID of the user

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
AuthGrouptblAuthGroup
(read-only)
The auth group the user is a mamber of.
UsertblUsers
(read-only)
The user that is a member of the group.

tblAuthGroupRole

List of authorization groups required for each role

Columns

ColumnTypeDescription
RoleIDinteger
(read-only)
ID of the role
RoleVersioninteger
(read-only)
Version of the role
AuthGroupIDinteger
(read-only)
ID of the authgroup

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
AuthGrouptblAuthGroup
(read-only)
The authorization group whose approval is required.
RoletblRole
(read-only)
The role this authorization group is required to approve.

tblAuthLines

List of signatories for each request line – one per authorizing user in each authorization group.

Columns

ColumnTypeDescription
RequestIDinteger
(read-only)
The ID of the request holding the request line to be approved.
LineIDinteger
(read-only)
The ID of the request line being approved.
AuthGroupIDinteger
(read-only)
The ID of the authorization group whose approval is required.
UserIDinteger
(read-only)
The ID of the user within the authorization group.
Statusstring(32)The current approval state of this line.
Signaturestring(128)The name of the user who signed this authline.
SignatureVerifiedBystring(128)How the signature was verified -- RBAC, Active Directory etc.
SignatureTypestring(128)Whether the signature was of the required user or a delegated user.
DelegateUserIDinteger
(optional)
The ID of the user who signed with delegated authority.
LastUpdateddatetimeThe time this line was created or updated.
Commentstring(128)A comment.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DelegateUsertblUsersThe user who signed using delegated authority.
RequestLinetblRequestLine
(read-only)
The request line this signature line relates to.
AuthGroupMembertblAuthGroupMember
(read-only)
The user / authorization group that can sign off on this line.

tblCommandInfo

List of commands available in each WAR instance.

Columns

ColumnTypeDescription
InstanceIDinteger
(read-only)
ID of the WAR instance this command applies to.
Namestring(128)
(read-only)
Name of the command.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
InstancetblWARInstances
(read-only)
The WAR instance this command is available on.

tblCommandParameters

List of parameters required for each WAR command.

Columns

ColumnTypeDescription
InstanceIDinteger
(read-only)
ID of the WAR instance owning the command.
CommandNamestring(128)
(read-only)
Name of the command this parameter is for.
ParameterNamestring(128)
(read-only)
Name of the parameter.
ParameterTypestring(128)Type of the parameter.
Commentstring(128)Comment.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
CommandtblCommandInfo
(read-only)
The command this parameter is required for.

tblCompoundRole

Compound-role specific details

Columns

ColumnTypeDescription
RoleIDinteger
(read-only)
ID of the role
RoleVersioninteger
(read-only)
Version of the compound role

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RoletblRole
(read-only)
The common role data for the role.

tblCompoundRoleRole

List of roles making up each compound role

Columns

ColumnTypeDescription
CompoundRoleIDinteger
(read-only)
ID of the compound role
CompoundRoleVersioninteger
(read-only)
Version of the compound role
RoleIDinteger
(read-only)
ID of the contained role
RoleVersionintegerVersion of the contained role (if compound)

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RoletblRole
(read-only)
The role contained within the CompoundRole.
CompoundRoletblCompoundRole
(read-only)
The containing compound role.

tblDelegations

List of delegations made by resource managers.

Columns

ColumnTypeDescription
UserIDinteger
(read-only)
ID of the user whose authority he has elected to delegate.
DelegatedDepartmentIDinteger
(read-only)
ID of the department over which authority has been delegated.
DelegatedResourceIDinteger
(read-only)
ID of the resource over which authority has been delegated.
DelegateUserIDinteger
(read-only)
ID of the user the authority has been delegated to.
RequestIDinteger
(optional, read-only)
ID of the request this delegation is (optionally) specific to.
LineIDinteger
(optional, read-only)
ID of the request line this delegation is (optionally) specific to.
AuthGroupIDinteger
(optional, read-only)
ID of the authgroup this delegation is (optionally) specific to.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DelegatedResourcetblResource
(read-only)
...
DelegatedAuthLinetblAuthLines
(read-only)
...
DelegateUsertblUsers
(read-only)
...
DelegatedDepartmenttblDepartment
(read-only)
...
UsertblUsers
(read-only)
The user whose authority is being delegated.

tblDepartment

List of departments

Columns

ColumnTypeDescription
IDautoid
(read-only)
ID of the department
Namestring(128)Name of the department
Commentstring(128)Descriptive comment

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

tblDepartmentCompoundRole

List of compound roles available to each department

Columns

ColumnTypeDescription
DepartmentIDinteger
(read-only)
ID of the owning department
CompoundRoleIDinteger
(read-only)
ID of the owned role
CompoundRoleVersionintegerVersion of the owned role

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DepartmenttblDepartment
(read-only)
The department with access to the compound role.
CompoundRoletblCompoundRole
(read-only)
The compound role the department has access to.

tblFavoriteRoles

Favourite roles

Columns

ColumnTypeDescription
UserIDinteger
(read-only)
ID of the user whose favourite this is
RoleIDinteger
(read-only)
ID of the favourite role
RoleVersionintegerVersion of the favourite role
UsedTimestampdatetimeTime this was last selected
UpdatedTimestampdatetimeTime this was last updated

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
FavoriteRoleObjtblRole
(read-only)
The role the user has marked as a favourite.
UsertblUsers
(read-only)
The user whose favourite this is.

tblFavoriteUsers

Favourite users

Columns

ColumnTypeDescription
UserIDinteger
(read-only)
ID of the user whose favourite this is
FavoriteUserIDinteger
(read-only)
ID of the favourite user
UsedTimestampdatetimeTime this was last selected
UpdatedTimestampdatetimeTime this was last updated

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
UsertblUsers
(read-only)
The user whose favourite this is.
FavoriteUserObjtblUsers
(read-only)
The user the user has marked as a favourite.

tblParameters

Parameter template for each role action

Columns

ColumnTypeDescription
ResourceRoleIDinteger
(read-only)
ID of the resource role this defines
ResourceRoleVersioninteger
(read-only)
Version of the resource role this defines
ExecutionOrderinteger
(read-only)
Index of the command within the role
ParameterNamestring(128)Name of the parameter being defined
ParameterSourceTypestring(128)The overall source of the parameter -- fixed, AD, Subscriber, request line etc.
ParameterSourcestring(128)The source of the parameter -- a fixed string, field name etc.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RoleActiontblRoleActions
(read-only)
The role action this parameter is associated with.

tblRequestHeader

Holds overall details of each request – date, requestor, note etc.

Columns

ColumnTypeDescription
IDautoid
(read-only)
The unique request ID.
RequestorIDintegerThe User ID of the requesting user.
Statusstring(16)Overall status of the request -- Editing, Submitted, etc.
Descriptionstring(255)
(optional)
A description of the request, used by users to identify requests within the system.
Commentstring(255)
(optional)
A comment regarding the request.
CreateddatetimeThe date and time the request was created.
LastUpdateddatetimeThe date and time the request was last updated.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RequestortblUsersThe user making the request.

tblRequestLine

Holds individual request lines.

Columns

ColumnTypeDescription
RequestIDinteger
(read-only)
The ID of the request holding this request line.
LineIDuniqueid
(read-only)
The ID of this line within the request.
Actionstring(64)The action being requested.
Statusstring(32)The current status of this request line.
LastUpdateddatetimeThe date and time the request was submitted.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RequesttblRequestHeader
(read-only)
The containing request.

tblRequestLineData

Data fields for each request line – these correspond initially to input into the user interface, and are created for new lines as the request progresses.

Columns

ColumnTypeDescription
RequestIDinteger
(read-only)
The ID of the request holding this request line.
LineIDinteger
(read-only)
The ID of the request line to which this data pertains.
FieldNamestring(64)
(read-only)
The field name of the data.
FieldDatastring(255)
(read-only)
The data.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RequestLinetblRequestLine
(read-only)
The request line this data relates to.

tblRequirements

List of pre-requisites and conflicting roles for each resource role

Columns

ColumnTypeDescription
ResourceRoleIDinteger
(read-only)
ID of the resource role
ResourceRoleVersioninteger
(read-only)
Version of the resource role
RequirementTypestring(128)Type of requirement: prerequisite, conflict, override
RequirementRoleIDinteger
(read-only)
ID of the resource role required
RequirementRoleVersioninteger
(read-only)
Version of the resource role required

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
ResourceRoletblResourceRole
(read-only)
The resource role this is a requirement for.

tblResource

List of resources

Columns

ColumnTypeDescription
IDautoid
(read-only)
ID of the resource
DepartmentIDinteger
(optional)
ID of the department owning this resource; if NULL, available to all departments
RootOUstring(128)The top-most OU to which this resource is available.
Namestring(128)Name of the resource
Commentstring(128)Descriptive comment

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DepartmenttblDepartmentThe department owning the resource.

tblResourceRole

Resource-role specific details

Columns

ColumnTypeDescription
RoleIDinteger
(read-only)
ID of the role
RoleVersionintegerAll resource roles have a version of 0
ResourceIDintegerID of the associated resource
ManualExecutorIDinteger
(optional)
ID of the user responsible for manual execution.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
ResourcetblResourceThe resource the role relates to.
RoletblRole
(read-only)
The common role data for the role.
ManualExecutortblUsersThe user responsible for manual execution.

tblRole

Details common to both resource roles and compound roles

Columns

ColumnTypeDescription
IDautoid
(read-only)
ID of the role
Versioninteger
(read-only)
Version of the role
VersionStatestring(1)Whether a version is current or not -- A for Active, I for Inactive
Namestring(128)Role name
Commentstring(255)A comment
RoleTypestring(10)Compound, resource or RBAC
ApprovalDeadlineintegerNumber of days to wait for approval
ExecutionDeadlineintegerNumber of days to wait for execution

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

tblRoleActions

List of WAR commands to be issued for each resource role

Columns

ColumnTypeDescription
ResourceRoleIDinteger
(read-only)
ID of the resource role this defines
ResourceRoleVersioninteger
(read-only)
Version of the resource role this defines
WARInstanceintegerID of the WAR instance this command should be run on
CommandNamestring(128)Name of the command to be executed
ExecutionOrderinteger
(read-only)
Order within the command list

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
CommandtblCommandInfoThe command to be executed.
ResourceRoletblResourceRole
(read-only)
The resource role this action implements.

tblRolePriorityGroups

List of role priority groups, defining the role hierarchy.

Columns

ColumnTypeDescription
IDautoid
(read-only)
ID of the priority group
Namestring(128)Name of the priority group

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

tblRolePriorityLists

List of roles within a priority group.

Columns

ColumnTypeDescription
GroupIDinteger
(read-only)
ID of the priority group
RoleIDintegerID of the role
RoleVersionintegerVersion of the role -- FIXME!
Priorityinteger
(read-only)
Priority of the role within the group

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RoletblRole
GrouptblRolePriorityGroups
(read-only)

tblUserRole

List of roles currently granted to users

Columns

ColumnTypeDescription
UserIDinteger
(read-only)
ID of the user
RoleIDinteger
(read-only)
ID of the role
RoleVersionintegerVersion of the role

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
RoletblRole
(read-only)
The role the user has.
UsertblUsers
(read-only)
The user having the role.

tblUsers

List of users – sourced from Active Directory / Subscriber DB

Columns

ColumnTypeDescription
IDautoid
(read-only)
RBAC User ID
Usernamestring(128)Username
AuthenticationTypestring(128)Authentication type -- RBAC, Active Directory etc.
Authenticationstring(128)If using RBAC authentication, a hash of the user's password. If using Active Directory etc. authentication, the relevant data; e.g. account DN.
DepartmentIDintegerID of the user's department
BadgeNumberstring(128)User's badge number from subscriber DB
LogonScreenstring(128)Screen to present after logging on

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
DepartmenttblDepartmentThe department the user is a member of.

tblWARAgents

List of agents available to each WAR instance.

Columns

ColumnTypeDescription
InstanceIDinteger
(read-only)
ID of the WAR instance owning this agent.
Namestring(64)
(read-only)
Name of the agent within SEM.
FriendlyNamestring(128)Display name for the agent.
Commentstring(255)
(optional)
Optional comment.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods:

Associated Objects

ObjectTypeDescription
InstancetblWARInstances
(read-only)
The WAR instance this agent is reachable through.

tblWARInstances

List of WAR instances RBAC can interface to.

Columns

ColumnTypeDescription
IDautoid
(read-only)
Unique identifier for the instance.
Namestring(64)Display name of the WAR instance.
DSNstring(128)Name of the DSN used to access this instance.

Constraints

Class methods

New objects of this class are constructed with:

The following methods return a single object, or a null reference if the requested object was not found:

The following methods return a list of objects:

Other methods: