mssub_mcp.ms_syst

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default	Comments
syst_password_history	Table	access_account_id	uuid	2147483647		null	The Access Account to which the password history record belongs.
syst_identities	Table	access_account_id	uuid	2147483647		null	The ID of the access account to be identified the identifier record.
syst_access_account_perm_role_assigns	Table	access_account_id	uuid	2147483647		null	References the Access Account to which the Permission Role is being assigned.
syst_credentials	Table	access_account_id	uuid	2147483647		null	The Access Account for which the Credential is to be used.
syst_access_account_instance_assocs	Table	access_account_id	uuid	2147483647		null	The access account which is being granted authentication rights to the given instance.
syst_access_accounts	Table	access_account_state_id	uuid	2147483647		null	The current life-cycle state of the Access Account.
syst_access_account_instance_assocs	Table	access_granted	timestamptz	35	√	null	The timestamp at which access to the instance was granted and active. General Usage If the access did not require the access invitation process, this value will typically reflect the creation timestamp of the record. If the invitation was required, it will reflect the time when the access account holder actually accepted the invitation to access the instance.
syst_identities	Table	account_identifier	text	2147483647		null	The actual Identifier which identifies a user or system to the system. General Usage Identifiers of the same Identifier Type are unique to the Owner/Access Account combination. All Unowned Access Accounts are considered as being in the same Owner group for this purpose.
syst_actions	Table	action_group_id	uuid	2147483647		null	If the Action belongs to an Action Group, this column defines the owning Action Group. General Usage If the Action is to be accessible via Command entry, it must define a parent Action Group. If the Action is not accessible via Commands, this value should be left `NULL`.
syst_menu_items	Table	action_id	uuid	2147483647	√	null	Associates a specific action to be invoked when the Menu Item that the record represents is “selected”. General Usage Note that the referenced Action’s texts will supersede the Menu Item texts in any user facing situations, though if the Menu Item is also associated with a Menu (`submenu_menu_id`), the Menu’s text will prevail.
syst_perm_role_grants	Table	admin_scope	text	2147483647		null	Assigns the Scope of the Permission’s Data Administration Right being granted by the Role. General Usage The valid Scope options are defined by the Permission record.
syst_perms	Table	admin_scope_options	_text	2147483647		ARRAY['unused'::text]	If applicable, enumerates the available Scopes of data administration offered by the permission. Administration in this context refers to creating or deleting records. General Usage If not applicable the only option will be ‘unused’.
syst_access_accounts	Table	allow_global_logins	bool	1		false	Indicates whether or not an Access Account may be used to login outside of the context of a specific Owner or Instance. This use case supports Access Accounts which are independently managed, such as might be the case for external bookkeepers. The need for this distinction arises when considering logins for Access Account holders such as customers or vendors. In these cases access to the Owner’s environment should appear to be unique, but they may use the same identifier as used for a different, but unrelated, Owner. In this case you have multiple Access Accounts with possibly the same identifier; to resolve the conflict, it is required therefore to know which Owner or Instance the Access Accounts holder is trying to access. In the allow global case we can just ask the account holder but in the disallow global case we need to know it in advance. Another way to think about global logins is in relation to user interface. A global login interface may present the user with a choice of Instance Owners and then their Instances whereas the non-global login user must go directly to the login interface for a specific Owner (be that URL or other client-side specific identification.) General Usage When true, allows an Access Account to log into the system without having an Owner or Instance specified in the login process. When false, the Access Account is more tightly bound to a specific Owner and so only a specific Owner and Instances should be evaluated at login time.
syst_hierarchy_items	Table	allow_leaf_nodes	bool	1		false	Indicates to implementing Components that this Hierarchy Item level can be associated with “Leaf Nodes”. Leaf Nodes are not defined in the mscmp_syst_hierarchy Component, but are rather defined by Hierarchy implementing Components. Leaf Nodes are the records which the Branch Nodes/Hierarchy definition are organizing. An example of a Leaf Node would be an application menu implementing Component defining references/links to specific application functionality which are then displayed associated to branches of a tree structure (menu/sub-menu/ etc.) The links are Leaf Nodes and the branches of the menu are Branch Nodes: representations of the Hierarchy Items. General Usage If this value is true, it means this Hierarchy Item record may be associated directly with Leaf Nodes. If false, Leaf Nodes must be associated with other levels of the Hierarchy. The bottom/lowest level required Hierarchy Item must always be marked as `allow_leaf_nodes` true. Higher than the lowest required Hierarchy Item level may arbitrarily allow or disallow Leaf Node associations as the implementing Component sees fit.
syst_global_password_rules	Table	allowed_mfa_types	_text	2147483647		ARRAY[]::text[]	A array of the approved multi-factor authentication methods.
syst_owner_password_rules	Table	allowed_mfa_types	_text	2147483647		ARRAY[]::text[]	A array of the approved multi-factor authentication methods.
syst_instance_contexts	Table	application_context_id	uuid	2147483647		null	Identifies the Application Context which is being defined for the Instance.
syst_instance_type_contexts	Table	application_context_id	uuid	2147483647		null	The Application Context which is being represented in the Instance Type.
syst_instance_type_applications	Table	application_id	uuid	2147483647		null	A reference to the Application being associated with the Instance Type.
syst_application_contexts	Table	application_id	uuid	2147483647		null	References the ms_syst_data.syst_applications record which owns the context.
syst_instances	Table	application_id	uuid	2147483647		null	Indicates an instance of which application is being described by the record.
syst_action_groups	Table	command	text	2147483647	√	null	Provides the primary text “Command” used for identifying the Action Group. Commands associated with Action Groups are used for commandline-like input by application users to specify a class of action. For example, the Command “new” may designate a class of Actions which all deal with record or transaction creation; secondary Commands at the Action level would delineate which specific creation action to take. General Usage When the value of this column is `NULL`, the Action Group is not searchable or available to the user using command line interfaces. Such Action Groups exist to organize Actions which are only accessible via menu interfaces (or similar). Note that if this value is `NULL` other `command_*` columns must also be `NULL`. `command` designated Commands have priority over similar “Command Aliases” defined in the `command_aliases` column.
syst_actions	Table	command	text	2147483647	√	null	Provides the primary text “Command” used for identifying the Action. Commands associated with Actions are used for commandline-like input by application users to select the specific action to take assuming the Action Group has been resolved.. For example, the Command “po”, when taken from the Action Group identified with Command “new”, could indicate that the user wishes to create a new purchase order. General Usage When the value of this column is `NULL`, the Action is not searchable or available to the user using command line interfaces. Such Actions exist if they are only invokable from menus or similar, non-commandline user interfaces. Note that if this value is `NULL` other `command_*` columns must also be `NULL`. `command` designated Commands have priority over similar “Command Aliases” defined in the `command_aliases` column.
syst_action_groups	Table	command_aliases	_text	2147483647	√	null	An array of strings which designate alternate, possibly non-unique values which may be used in addition to the `command` value in identifying the record. In searched results, `command_aliases` received a reduced priority vs. `command` values. General Usage The null/not null state of this column must match the null/not null state of the `command` column.
syst_actions	Table	command_aliases	_text	2147483647	√	null	An array of strings which designate alternate, possibly non-unique values which may be used in addition to the `command` value in identifying the record. In searched results, `command_aliases` received a reduced priority vs. `command` values. General Usage The null/not null state of this column must match the null/not null state of the `command` column.
syst_action_groups	Table	command_config	regconfig	2147483647	√	null	Establishes the PostgresSQL text search configuration to use when parsing the Command strings. The primary use of this column is to set the value of the generated column `command_search`, though establishing the appropriate configuration for use with the record may be useful elsewhere. General Usage The null/not null state of this column must match the null/not null state of the `command` column.
syst_actions	Table	command_config	regconfig	2147483647	√	null	Establishes the PostgresSQL text search configuration to use when parsing the Command strings. The primary use of this column is to set the value of the generated column `command_search`, though establishing the appropriate configuration for use with the record may be useful elsewhere.
syst_actions	Table	command_search	tsvector	2147483647	√	ms_syst_priv.generate_command_tsvector(p_config => command_config, p_command => command, p_command_aliases => command_aliases)	A generated column containing the PostgreSQL tsvector value used when resolving an Action Command. General Usage The null/not null state of this column must match the null/not null state of the `command` column.
syst_action_groups	Table	command_search	tsvector	2147483647	√	ms_syst_priv.generate_command_tsvector(p_config => command_config, p_command => command, p_command_aliases => command_aliases)	A generated column containing the PostgreSQL tsvector value used when resolving an Action Group Command. Being a generated column, the system will automatically update this column when its source columns are updated. General Usage Being a generated column, the system will automatically update this column when its source columns are updated. The null/not null state of this column will match the null/not null state of the `command` column.
syst_instance_contexts	Table	context_code	bytea	2147483647		null	An Instance Context specific series of bytes which are used in algorithmic credential generation.
syst_credentials	Table	credential_data	text	2147483647		null	The actual data which supports verifying the presented Identity in relation to the Access Account.
syst_password_history	Table	credential_data	text	2147483647		null	The previously hashed password recorded for reuse comparisons. General Usage This is the same format as the existing active password credential.
syst_credentials	Table	credential_for_identity_id	uuid	2147483647	√	null	When an Access Account Identity is created for either Identity Validation or Access Account recovery, a single use Identity is created as well as a single use Credential. In this specific case, the one time use Credential and the one time use Identity are linked. This is especially important in recovery scenarios to ensure that only the correct recovery communication can recover the account. This field identifies the which Identity is associated with the Credential. For regular use Identities, there are no special Credential requirements that would be needed to for a link and the value in this column should be null.
syst_credentials	Table	credential_type_id	uuid	2147483647		null	The kind of Credential that the record represents. General Usage Note that the behavior and use cases of the Credential may have specific processing and handling requirements based on the Functional Type of the Credential ype.
syst_application_contexts	Table	database_owner_context	bool	1		false	Indicates if the Application Context represents the database role used for object ownership. General Usage If true, the Application Context does represent the ownership role and should also be defined as a login_context = FALSE context. If false, the role is not used for database object ownership. Note that there should only ever be one Application Context defined as database_owner_context = TRUE for any one Application.
syst_instance_contexts	Table	db_pool_size	int4	10		0	If the Application Context is a login datastore context, this value establishes how many database connections to open on behalf of this Instance Context.
syst_instances	Table	dbserver_name	text	2147483647	√	null	Identifies on which database server the instance is hosted. If empty, no server has been assigned and the instance is unstartable.
syst_instance_type_contexts	Table	default_db_pool_size	int4	10		0	A default pool size which is assigned to new Instances of the Instance Type unless the creator of the Instance specifies a different value.
syst_enums	Table	default_syst_options	jsonb	2147483647	√	null	Establishes the expected extended system options along with default values if applicable. General Usage Note that this setting is used to both validate and set defaults in the `syst_enum_items.syst_options` column.
syst_enums	Table	default_user_options	jsonb	2147483647	√	null	Allows a user to set the definition of syst_enum_items.user_options values and provide defaults for those values if appropriate.
syst_application_contexts	Table	description	text	2147483647		null	A user visible description of the application context, its role in the application, uses, and any other helpful text.
syst_instance_network_rules	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_role_created	text	2147483647	√	null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_role_modified	text	2147483647	√	null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_access_account_instance_assocs	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_menus	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_owner_network_rules	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_disallowed_hosts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_sessions	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_hierarchy_items	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instances	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_global_password_rules	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_owner_password_rules	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_identities	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_perm_roles	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_perms	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_applications	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_perm_functional_types	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_enum_items	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_credentials	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_enum_functional_types	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_password_history	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_perm_role_grants	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instance_network_rules	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_menu_items	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_actions	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instance_type_applications	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instance_type_contexts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_settings	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_action_groups	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_access_accounts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instance_contexts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_owners	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_hierarchies	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_application_contexts	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_global_network_rules	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_access_account_perm_role_assigns	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_instance_contexts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_application_contexts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	disallow_compromised	bool	1		true	When true new passwords submitted through the change password process will be checked against a list of common passwords and passwords known to have been compromised and disallow their use as password credentials in the system. General Usage When false submitted passwords are not checked as being common or against known compromised passwords; such passwords would therefore be usable in the system.
syst_global_password_rules	Table	disallow_compromised	bool	1		true	When true new passwords submitted through the change password process will be checked against a list of common passwords and passwords known to have been compromised and disallow their use as password credentials in the system. General Usage When false submitted passwords are not checked as being common or against known compromised passwords; such passwords would therefore be usable in the system.
syst_global_password_rules	Table	disallow_recently_used	int4	10		0	When passwords are changed, this value determines how many prior passwords should be checked in order to prevent password re-use. General Usage Setting this value to zero or a negative number will disable the recently used password check.
syst_owner_password_rules	Table	disallow_recently_used	int4	10		0	When passwords are changed, this value determines how many prior passwords should be checked in order to prevent password re-use. General Usage Setting this value to zero or a negative number will disable the recently used password check.
syst_application_contexts	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	enum_default	bool	1		false	If true, indicates that this value is the default selection from all values defined for the enumerations. General Usage Note that if a record is inserted or updated in this table with enum_default set true, and another record already exists for the enumeration with its enum_default set true, the newly inserted/updated record will take precedence and the value record previously set to be default will have its enum_default setting set to false. If false then the value record has no special significance relative to defaulting.
syst_enum_items	Table	enum_id	uuid	2147483647		null	The enumeration record with which the value is associated.
syst_enum_functional_types	Table	enum_id	uuid	2147483647		null	A reference to the owning Enumeration of the functional type.
syst_action_groups	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_access_accounts	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_enum_functional_types	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_hierarchy_items	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_menu_items	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_identities	Table	external_name	text	2147483647	√	null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_enum_items	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_actions	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_credentials	Table	force_reset	timestamptz	35	√	null	Indicates whether or not certain Credential types, such as passwords, must be updated. General Usage When `NOT NULL`, the user must update their Credential on the next login; when `NULL` updating the Credential is not being administratively forced.
syst_instance_network_rules	Table	functional_type	text	2147483647		null	Indicates how the system will interpret the IP address rule. General Usage The valid functional types are: `allow` - the rule is explicitly allowing an IP address, network, or range of IP addresses to continue in the authentication process. `deny` - the rule is explicitly rejecting an IP address, network, or range of IP addresses from the authentication process.
syst_global_network_rules	Table	functional_type	text	2147483647		null	Indicates how the system will interpret the IP address rule. General Usage The valid functional types are: `allow` - the rule is explicitly allowing an IP address, network, or range of IP addresses to continue in the authentication process. `deny` - the rule is explicitly rejecting an IP address, network, or range of IP addresses from the authentication process.
syst_owner_network_rules	Table	functional_type	text	2147483647		null	Indicates how the system will interpret the IP address rule. General Usage The valid functional types are: `allow` - the rule is explicitly allowing an IP address, network, or range of IP addresses to continue in the authentication process. `deny` - the rule is explicitly rejecting an IP address, network, or range of IP addresses from the authentication process.
syst_enum_items	Table	functional_type_default	bool	1		false	If true, the value record is the default selection for any of a specific fucntional type. This is helpful in situations where a progression of state is automatically processed by the system and the state is represented by an enumeration. General Usage Note that if a record is inserted or updated in this table with its functional_type_default set true, and another record already exists for the enumeration/functional type combination with its functional_type_default set true, the newly inserted/updated record will take precedence and the value record previously set to be default will have its functional_type_default setting set to false. In cases where there are no functional types, this value should simply remain false.
syst_enum_items	Table	functional_type_id	uuid	2147483647	√	null	If the enumeration requires a functional type, this column references the functional type associated with the enumeration value record. General Usage Note that not all enumerations require functional types. If syst_enum_functional_types records exist for an enumeration, then this column will be required for any values of that enumeration; if there are no functional types defined for an enumeration, the this column must remain NULL.
syst_hierarchy_items	Table	hierarchy_depth	int2	5		null	Indicates the at what level in the hierarchy this Group Type Item sits relative to the other items in the Group Type. Records with relatively higher values are deeper or lower in the hierarchy. General Usage When a value for this column is not provided at insert time, the record is assigned the next hierarchy depth value relative to the existing records. When a record is inserted with a set hierarchy_depth value and that value pre-exists for the same Group Type as the new record, the insert is treated as a “insert above” operation, with the existing conflicting record being updated to have the next hierarchy value; existing Group Type Item records are continued to be updated until the last record is assigned a non-conflicting hierarchy_depth value.
syst_hierarchy_items	Table	hierarchy_id	uuid	2147483647		null	Identifies the Hierarchy to which the record belongs.
syst_hierarchies	Table	hierarchy_state_id	uuid	2147483647		null	A reference indicating at which point in the Hierarchy life-cycle the record sits. General Usage The record may only be set in an `active` state if the record and any associated Hierarchy Item records are in a consistent, valid state. Similarly, the record may only be set to an `inactive` state if the Hierarchy record is not in use, which is defined as the record being referenced by an Hierarchy implementing Component’s records.
syst_hierarchies	Table	hierarchy_type_id	uuid	2147483647		null	A reference indicating in which specific functional area or with which feature of the application the Hierarchy is associated with.
syst_disallowed_hosts	Table	host_address	inet	2147483647		null	The IP address of the host disallowed from attempting to authenticate Access Accounts.
syst_application_contexts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_network_rules	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_contexts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_disallowed_hosts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_type_applications	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_role_grants	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_network_rules	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_password_history	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_network_rules	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_perm_role_assigns	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owner_password_rules	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_credentials	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_global_password_rules	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_identities	Table	identity_expires	timestamptz	35	√	null	The timestamp at which the identity record expires. General Usage For validation and recovery identities this would be the time of validation/recovery request expiration. For perpetual identity types, this value will be NULL.
syst_identities	Table	identity_type_id	uuid	2147483647		null	The kind of identifier being described by the record. General Usage Note that this value influences the kind of credentials that can be used to complete the authentication process.
syst_instances	Table	instance_code	bytea	2147483647		null	This is a random sequence of bytes intended for use in certain algorithmic credential generation routines. General Usage Note that losing this value may prevent the Instance from being started due to bad credentials; there may be other consequences as well.
syst_instance_contexts	Table	instance_id	uuid	2147483647		null	Identifies the parent Instance for which Instance Contexts are being defined.
syst_access_account_instance_assocs	Table	instance_id	uuid	2147483647		null	The identity of the instance to which authentication rights is being granted.
syst_instance_network_rules	Table	instance_id	uuid	2147483647		null	The database identifier of the Instance record for whom the Network Rule is being defined.
syst_instances	Table	instance_options	jsonb	2147483647	√	null	A key/value store of values which define application or instance specific options.
syst_instances	Table	instance_state_id	uuid	2147483647		null	Establishes the current life-cycle state of the instance record. This can determine functionality such as if the instance is usable, visible, or if it may be purged from the database completely.
syst_instance_type_contexts	Table	instance_type_application_id	uuid	2147483647		null	The Instance Type/Application association to which the context definition belongs.
syst_instances	Table	instance_type_id	uuid	2147483647		null	Indicates the type of the instance. This can designate instances as being production or non-production, or make other functional differences between instances created for different reasons based on the assigned instance type.
syst_instance_type_applications	Table	instance_type_id	uuid	2147483647		null	A reference to the Instance Type being associated to an Application.
syst_application_contexts	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_accounts	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instance_contexts	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_sessions	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_instances	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchy_items	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_owners	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_access_account_instance_assocs	Table	invitation_declined	timestamptz	35	√	null	The timestamp at which the access account holder explicitly declined the invitation to access the given instance.
syst_access_account_instance_assocs	Table	invitation_expires	timestamptz	35	√	null	The timestamp at which the invitation to access a given instance expires.
syst_access_account_instance_assocs	Table	invitation_issued	timestamptz	35	√	null	When inviting unowned, independent access accounts such as might be used by an external bookkeeper, the grant of access by the instance owner is not immediately effective but must also be approved by the access account holder being granted access. General Usage The timestamp in this column indicates when the invitation to connect to the instance was issued. If the value in this column is null, the assumption is that no invitation was required to grant the access to the access account.
syst_instance_network_rules	Table	ip_host_or_network	inet	2147483647	√	null	An IPv4 or IPv6 IP address or network block expressed using standard CIDR notation. General Usage If this value is given you should not provide an IP host address range in the ip_host_range_lower/ip_host_range_upper columns. Providing range column values when this column is not null will result in a consistency check failure.
syst_global_network_rules	Table	ip_host_or_network	inet	2147483647	√	null	An IPv4 or IPv6 IP address or network block expressed using standard CIDR notation. General Usage If this value is given you should not provide an IP host address range in the ip_host_range_lower/ip_host_range_upper columns. Providing range column values when this column is not null will result in a consistency check failure.
syst_owner_network_rules	Table	ip_host_or_network	inet	2147483647	√	null	An IPv4 or IPv6 IP address or network block expressed using standard CIDR notation. General Usage If this value is given you should not provide an IP host address range in the ip_host_range_lower/ip_host_range_upper columns. Providing range column values when this column is not null will result in a consistency check failure.
syst_instance_network_rules	Table	ip_host_range_lower	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the lower bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_upper column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_global_network_rules	Table	ip_host_range_lower	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the lower bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_upper column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_owner_network_rules	Table	ip_host_range_lower	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the lower bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_upper column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_owner_network_rules	Table	ip_host_range_upper	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the upper bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_lower column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_global_network_rules	Table	ip_host_range_upper	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the upper bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_lower column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_instance_network_rules	Table	ip_host_range_upper	inet	2147483647	√	null	An IPv4 or IPv6 IP host address which is the upper bound (inclusive) of a range of IP addresses. General Usage If the value in this column is not null a value must also be provided for the ip_host_range_lower column. Both ip_host_range_lower and ip_host_range_upper must be of the same IP family (IPv4 or IPv6).
syst_credentials	Table	last_updated	timestamptz	35		now()	For Credential types where rules regarding updating may apply, such as common passwords, this column indicates when the Credential was last updated (timestamp of last password change, for example). General Usage This field is explicitly not for dating trivial or administrative changes which don’t actually materially change the Credential data; please consult the appropriate diagnostic fields for those use cases.
syst_application_contexts	Table	login_context	bool	1		false	Indicates whether or not the Application Context is used for making connections to the database. General Usage If true, each associated Instance Context is created as a role in the database with the LOGIN privilege; if false, the role is created in the database as a NOLOGIN role. Most often non-login Application Contexts are created to serve as the database role owning database objects.
syst_perm_role_grants	Table	maint_scope	text	2147483647		null	Assigns the Scope of the Permission’s Maintenance Right being granted by the Role. General Usage The valid Scope options are defined by the Permission record.
syst_perms	Table	maint_scope_options	_text	2147483647		ARRAY['unused'::text]	If applicable, enumerates the available Scopes of maintainable data offered by the permission. Maintenance in this context refers to changing existing data. General Usage If not applicable the only option will be ‘unused’.
syst_owner_password_rules	Table	max_age	interval	49		'00:00:00'::interval	An interval indicating the maximum allowed age of a password. Any password older than this interval will typically result in the user being forced to update their password prior to being allowed access to other functionality. The specific user workflow will depend on the implementation details of application. General Usage An interval of 0 time disables the check and passwords may be of any age.
syst_global_password_rules	Table	max_age	interval	49		'00:00:00'::interval	An interval indicating the maximum allowed age of a password. Any password older than this interval will typically result in the user being forced to update their password prior to being allowed access to other functionality. The specific user workflow will depend on the implementation details of application. General Usage An interval of 0 time disables the check and passwords may be of any age.
syst_menu_items	Table	menu_id	uuid	2147483647		null	Identifies the Menu to which the menu item belongs.
syst_menus	Table	menu_state_id	uuid	2147483647		null	Indicates at which life-cycle stage the record exists. Functionally, this breaks down into “active” and “inactive” states.
syst_perm_role_grants	Table	ops_scope	text	2147483647		null	Assigns the Scope of the Permission’s Operations Right being granted by the Role. General Usage The valid Scope options are defined by the Permission record.
syst_perms	Table	ops_scope_options	_text	2147483647		ARRAY['unused'::text]	If applicable, enumerates the available Scopes of a given operation or processing capability offered by the permission. General Usage If not applicable the only option will be ‘unused’.
syst_global_network_rules	Table	ordering	int4	10		null	Defines the order in which IP rules are applied. Lower values are applied prior to higher values. General Usage All records are ordered using unique ordering values within each owner value. When a new Owner Network Rule is inserted with the ordering value of an existing Owner Network Rule record for the same Owner, the system will assume the new record should be “inserted before” the existing record. Therefore the existing record will be reordered behind the new record by incrementing the existing record’s ordering value by one. This reordering process happens recursively until there are no ordering value conflicts for any of an Owner’s Network Rule records.
syst_instance_network_rules	Table	ordering	int4	10		null	Defines the order in which IP rules are applied. Lower values are applied prior to higher values. General Usage All records are ordered using unique ordering values within each Instance value. When a new Instance Network Rule is inserted with the ordering value of an existing Instance Network Rule record for the same Owner, the system will assume the new record should be “inserted before” the existing record. Therefore the existing record will be reordered behind the new record by incrementing the existing record’s ordering value by one. This reordering process happens recursively until there are no ordering value conflicts for any of an Instance’s Network Rule records.
syst_owner_network_rules	Table	ordering	int4	10		null	Defines the order in which IP rules are applied. Lower values are applied prior to higher values. General Usage All records are ordered using unique ordering values within each owner value. When a new Owner Network Rule is inserted with the ordering value of an existing Owner Network Rule record for the same Owner, the system will assume the new record should be “inserted before” the existing record. Therefore the existing record will be reordered behind the new record by incrementing the existing record’s ordering value by one. This reordering process happens recursively until there are no ordering value conflicts for any of an Owner’s Network Rule records.
syst_owner_network_rules	Table	owner_id	uuid	2147483647		null	The database identifier of the Owner record for whom the Network Rule is being defined.
syst_owner_password_rules	Table	owner_id	uuid	2147483647		null	Defines the relationship with the specific Owner for whom the password rule is being defined.
syst_instances	Table	owner_id	uuid	2147483647		null	Identifies the owner of the instance. The owner is the entity which commissioned the instance and is the “user” of the instance. Owners have nominal management rights over their instances, such as which access accounts and which credential types are allowed to be used to authenticate to the owner’s instances.
syst_owners	Table	owner_state_id	uuid	2147483647		null	Establishes the current life-cycle state in which Instance Owner record currently resides.
syst_instances	Table	owning_instance_id	uuid	2147483647	√	null	In some cases, an instance is considered subordinate to another instance. For example, consider a production environment and a related sandbox environment. The existence of the sandbox doesn’t have real meaning without being associated with some sort of production instance where the real work is performed. This kind of association becomes clearer in SaaS environments where a primary instance is contracted for, but other supporting instances, such as a sandbox, should follow certain account related actions of the primary.
syst_access_accounts	Table	owning_owner_id	uuid	2147483647	√	null	Associates the Access Account with a specific Owner. This allows for access accounts which are identified and managed exclusively by a given Owner. General Usage When this field is NULL, the assumption is that it’s an independent access account. An independent Access Account may be used, for example, by third party accountants that need to access the Instances of different Owners.
syst_menu_items	Table	parent_menu_item_id	uuid	2147483647	√	null	References the current Menu Item’s parent Menu Item record. If the current Menu Item record is at the root of the Menu, this value will be `NULL`.
syst_disallowed_passwords	Table	password_hash	bytea	2147483647		null	The SHA1 hash of the disallowed password. The reason for using SHA1 here is that it is compatible with the “Have I Been Pwned” data and API products. We also get some reasonable obscuring of possibly private data.
syst_owner_password_rules	Table	password_length	int4range	2147483647		int4range(8, 64, '[]'::text)	An integer range of acceptable password lengths with the lower bound representing the minimum length and the upper bound representing the maximum password length. General Usage A zero or negative value on either bound indicates that the bound check is disabled. Note that disabling a bound may still result in a bounds check using the application defined default for the bound. Length is determined on a per character basis, not a per byte basis.
syst_global_password_rules	Table	password_length	int4range	2147483647		int4range(8, 64, '[]'::text)	An integer range of acceptable password lengths with the lower bound representing the minimum length and the upper bound representing the maximum password length. General Usage A zero or negative value on either bound indicates that the bound check is disabled. Note that disabling a bound may still result in a bounds check using the application defined default for the bound. Length is determined on a per character basis, not a per byte basis.
syst_perm_roles	Table	perm_functional_type_id	uuid	2147483647		null	Assigns the Permission Role to a specific Permission Functional Type. General Usage Only Permissions with the same Permission Functional Type may be granted by the Permission Role.
syst_perms	Table	perm_functional_type_id	uuid	2147483647		null	Assigns the Permission to a specific Permission Functional Type. General Usage Permissions may only be granted in Permission Roles of the same Permission Functional Type.
syst_perm_role_grants	Table	perm_id	uuid	2147483647		null	The permission being granted by the role.
syst_access_account_perm_role_assigns	Table	perm_role_id	uuid	2147483647		null	A reference to the Permission Role being assigned to the Access Account.
syst_perm_role_grants	Table	perm_role_id	uuid	2147483647		null	Identifies the role to which the permission grant is being made.
syst_global_password_rules	Table	require_lower_case	int4	10		0	Setting this value to 0 disables the requirement for lower case characters.
syst_owner_password_rules	Table	require_lower_case	int4	10		0	Setting this value to 0 disables the requirement for lower case characters.
syst_owner_password_rules	Table	require_mfa	bool	1		true	When true, an approved multi-factor authentication method must be used in addition to the password credential.
syst_global_password_rules	Table	require_mfa	bool	1		true	When true, an approved multi-factor authentication method must be used in addition to the password credential.
syst_global_password_rules	Table	require_numbers	int4	10		0	Establishes the minimum number of numeric characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for numeric characters.
syst_owner_password_rules	Table	require_numbers	int4	10		0	Establishes the minimum number of numeric characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for numeric characters.
syst_owner_password_rules	Table	require_symbols	int4	10		0	Establishes the minimum number of non-alphanumeric characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for non-alphanumeric characters.
syst_global_password_rules	Table	require_symbols	int4	10		0	Establishes the minimum number of non-alphanumeric characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for non-alphanumeric characters.
syst_global_password_rules	Table	require_upper_case	int4	10		0	Establishes the minimum number of upper case characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for upper case characters.
syst_owner_password_rules	Table	require_upper_case	int4	10		0	Establishes the minimum number of upper case characters that are required to be present in the password. General Usage Setting this value to 0 disables the requirement for upper case characters.
syst_hierarchy_items	Table	required	bool	1		true	Indicates if the Hierarchy Item level must be represented by a record in the implementing data, or if the Hierarchy Item level represents an optional level. If true, the Hierarchy Item level must be represented by a record in the data of the implementing Component for that data to be considered valid. If false, the Hierarchy Item level is considered optional and the data of the implementing Component may omit the Hierarchy Item level in its data without the data being considered invalid. General Usage The highest/root Hierarchy Item level must always be required. If lower levels of the Hierarchy are required, all parents to the lowest required Hierarchy Item level must also be marked as required true.
syst_sessions	Table	session_data	jsonb	2147483647	√	null	A binary representation of user session data. The data itself will vary depending on the specific needs of user interface interactions.
syst_sessions	Table	session_expires	timestamptz	35		null	A Timestamp indicating the Date/Time at which the session will no longer be considered valid and will eligible for purging from the system. General Usage Prior to the expiration time, the session may be renewed and the session_expires time may be updated to a later time. After the session_expires timestamp is past, however, the session may not be updated and a new session will need to be established, typically via a new user authentication process.
syst_settings	Table	setting_blob	bytea	2147483647	√	null	A binary configuration point.
syst_settings	Table	setting_date	date	13	√	null	A date configuation point.
syst_settings	Table	setting_date_range	daterange	2147483647	√	null	A date range configuration point.
syst_settings	Table	setting_decimal	numeric	0	√	null	An decimal configuration point (not floating point).
syst_settings	Table	setting_decimal_range	numrange	2147483647	√	null	A decimal range configuration point.
syst_settings	Table	setting_flag	bool	1	√	null	A boolean configuration point.
syst_settings	Table	setting_integer	int8	19	√	null	An integer configuration point
syst_settings	Table	setting_integer_range	int8range	2147483647	√	null	An integer range configuration point.
syst_settings	Table	setting_interval	interval	49	√	null	An interval configuration point.
syst_settings	Table	setting_json	jsonb	2147483647	√	null	A JSON configuration point. Note that duplicate keys at the same level are not allowed.
syst_settings	Table	setting_text	text	2147483647	√	null	A text configuration point.
syst_settings	Table	setting_time	time	15	√	null	A time configuration point (without time zone).
syst_settings	Table	setting_timestamp	timestamptz	35	√	null	A full datetime configuration point including time zone.
syst_settings	Table	setting_timestamp_range	tstzrange	2147483647	√	null	A range of timestamps with time zone configuration points.
syst_settings	Table	setting_uuid	uuid	2147483647	√	null	A UUID configuration point.
syst_enum_items	Table	sort_order	int2	5		null	Indicates the sort ordering of the particular value record with the lowest value sorting first. General Usage When a value record for an enumeration is inserted or updated and this column is being set to a value which equals another enumeration value record for the same enumeration, the system assumes that the new record is being set to precede the existing record and it will be set to sort after the newly inserted/updated enumeration value.
syst_menu_items	Table	sort_order	int2	5		null	Establishes the current Menu Item’s sorting order relative to sibling Menu Item records
syst_application_contexts	Table	start_context	bool	1		false	Indicates whether or not the system should start the context for any Instances of the application. General Usage If true, any Instance of the Application will start its associated context so long as it is enabled at the Instance level. If false, the context is disabled for all Instances in the Application regardless of their individual settings.
syst_instance_contexts	Table	start_context	bool	1		false	Indicates whether the Instance Context should be started on Instance start. General Usage If true, indicates that the Instance Context should be started, so long as the Application Context record is also set to allow context starting. If false, the Instance Context not be started, even if the related Application Context is set to allow context starts.
syst_hierarchies	Table	structured	bool	1		true	A flag indicating whether or not the Hierarchy actually defines a structure, or if the any implementations allow fully ad hoc structuring within the implementing Component. General Usage This configuration exists for cases where a Component implements Hierarchy functionality, but can also operate while bypassing any hierarchy checks at all; this way we can still require a Hierarchy record reference in the implementation while allowing the Hierarchy definition itself be the configuration point for determining whether or not hierarchical structure is required.
syst_menu_items	Table	submenu_menu_id	uuid	2147483647	√	null	When not null, indicates that the Menu Item record imports an independently defined Menu. General Usage An attempt to associate a Menu which recursively references the current Menu Item’s parent Menu will result in an exception being raised and the transaction attempting to make the association will be rolled back. Note that the referenced Menu’s descriptive texts and naming will supersede the naming specified directly by this record or the text of any associated Menu Action referenced in the `action_id` column.
syst_enums	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_roles	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perms	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menu_items	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_perm_functional_types	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_action_groups	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_actions	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_applications	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	syst_options	jsonb	2147483647	√	null	Extended options and metadata which describe the behavior and meaning of the specific value within the enumeration. General Usage The owning syst_enums record’s default_syst_options column will indicate what syst_options are required or available and establishes default values for them.
syst_settings	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_menu_items	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_perm_roles	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_actions	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_perm_functional_types	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_enum_functional_types	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_menus	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_enum_items	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_hierarchies	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_action_groups	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_enums	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_perms	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_action_groups	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_menus	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_hierarchies	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	user_options	jsonb	2147483647	√	null	Extended user defined options, similar to syst_options, but for the purpose of driving custom functionality.
syst_identities	Table	validated	timestamptz	35	√	null	The timestamp at which the identity was validated for use. General Usage Depending on the requirements of the identity functional type, the timestamp here may be set as the time of the identity creation or it may set when the access account holder actually makes a formal verification. A null value here indicates that the identity is not validated by the access account holder and is not able to be used for authentication to the system.
syst_identities	Table	validates_identity_id	uuid	2147483647	√	null	Each identity requiring validation will require its own validation. General Usage Since validation requests are also single use identities, we need to know which permanent identifier is being validate. This column points to the identifier that is being validated. When the current identifier is not being used for validation, this field is null.
syst_identities	Table	validation_requested	timestamptz	35	√	null	The timestamp on which the validation request was issued to the access account holder. General Usage This value will be null if the identity did not require validation.
syst_perm_role_grants	Table	view_scope	text	2147483647		null	Assigns the Scope of the Permission’s View Right being granted by the Role. General Usage The valid Scope options are defined by the Permission record.
syst_perms	Table	view_scope_options	_text	2147483647		ARRAY['unused'::text]	If applicable, enumerates the available Scopes of viewable data offered by the permission. General Usage If not applicable the only option will be ‘unused’.

Showing 1 to 506 of 506 entries