Columns
| Table | Type | Column | Type | Size | Nullable | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|---|
| syst_identities | View | access_account_id | uuid | 2147483647 | √ | null | The ID of the access account to be identified the identifier record. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | access_account_id | uuid | 2147483647 | √ | null | The Access Account for which the Credential is to be used. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_password_history | View | access_account_id | uuid | 2147483647 | √ | null | The Access Account to which the password history record belongs. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | access_account_id | uuid | 2147483647 | √ | null | References the Access Account to which the Permission Role is being assigned. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_access_account_instance_assocs | View | access_account_id | uuid | 2147483647 | √ | null | The access account which is being granted authentication rights to the given instance. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key along with column | |
| syst_access_accounts | View | access_account_state_id | uuid | 2147483647 | √ | null | The current life-cycle state of the Access Account. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_menu_items | View | 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 ( Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | admin_scope_options | _text | 2147483647 | √ | null | 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’. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | allow_global_logins | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | allow_leaf_nodes | bool | 1 | √ | null | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | allowed_mfa_types | _text | 2147483647 | √ | null | A array of the approved multi-factor authentication methods. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | allowed_mfa_types | _text | 2147483647 | √ | null | A array of the approved multi-factor authentication methods. Data Requirements
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | application_context_id | uuid | 2147483647 | √ | null | The Application Context which is being represented in the Instance Type. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_contexts | View | application_context_id | uuid | 2147483647 | √ | null | Identifies the Application Context which is being defined for the Instance. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | application_id | uuid | 2147483647 | √ | null | References the ms_syst_data.syst_applications record which owns the context. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_applications | View | application_id | uuid | 2147483647 | √ | null | A reference to the Application being associated with the Instance Type. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | application_id | uuid | 2147483647 | √ | null | Indicates an instance of which application is being described by the record. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | 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
Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_action_groups | View | 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
Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | command_aliases | _text | 2147483647 | √ | null | An array of strings which designate alternate, possibly non-unique values which may be used in addition to the General Usage The null/not null state of this column must match the null/not null state of the Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | command_aliases | _text | 2147483647 | √ | null | An array of strings which designate alternate, possibly non-unique values which may be used in addition to the General Usage The null/not null state of this column must match the null/not null state of the Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | 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 General Usage The null/not null state of this column must match the null/not null state of the Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | command_search | tsvector | 2147483647 | √ | null | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | command_search | tsvector | 2147483647 | √ | null | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | context_code | bytea | 2147483647 | √ | null | An Instance Context specific series of bytes which are used in algorithmic credential generation. Data Requirements
User Defined Record Supported Operations
| |
| syst_password_history | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | credential_data | text | 2147483647 | √ | null | The actual data which supports verifying the presented Identity in relation to the Access Account. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | 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. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_credentials | View | 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. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_application_contexts | View | database_owner_context | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | db_pool_size | int4 | 10 | √ | null | If the Application Context is a login datastore context, this value establishes how many database connections to open on behalf of this Instance Context. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | default_db_pool_size | int4 | 10 | √ | null | A default pool size which is assigned to new Instances of the Instance Type unless the creator of the Instance specifies a different value. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_application_contexts | View | description | text | 2147483647 | √ | null | A user visible description of the application context, its role in the application, uses, and any other helpful text. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owners | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menus | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_applications | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_password_history | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_applications | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_application_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_applications | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menus | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_functional_types | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_settings | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_application_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_password_history | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_settings | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_applications | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_password_history | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perms | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_sessions | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_accounts | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | diag_row_version | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_roles | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instances | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_applications | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_accounts | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_password_history | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchies | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_contexts | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | diag_timestamp_created | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_password_history | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_applications | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_password_rules | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_sessions | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_roles | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_applications | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menus | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_application_contexts | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perms | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owners | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_functional_types | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instances | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_network_rules | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_accounts | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_settings | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_network_rules | View | diag_timestamp_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_instance_type_applications | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_network_rules | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owners | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_settings | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_contexts | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_password_history | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_roles | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menu_items | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | diag_update_count | int8 | 19 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_sessions | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_hierarchy_items | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_contexts | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_settings | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_password_rules | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_identities | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_password_history | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_functional_types | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_application_contexts | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_applications | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_network_rules | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_accounts | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menus | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owners | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | diag_wallclock_modified | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | disallow_compromised | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | disallow_compromised | bool | 1 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | disallow_recently_used | int4 | 10 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | disallow_recently_used | int4 | 10 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_application_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | enum_default | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | enum_id | uuid | 2147483647 | √ | null | The enumeration record with which the value is associated. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | enum_id | uuid | 2147483647 | √ | null | A reference to the owning Enumeration of the functional type. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | force_reset | timestamptz | 35 | √ | null | Indicates whether or not certain Credential types, such as passwords, must be updated. General Usage When Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | functional_type | text | 2147483647 | √ | null | Indicates how the system will interpret the IP address rule. General Usage The valid functional types are:
Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | functional_type | text | 2147483647 | √ | null | Indicates how the system will interpret the IP address rule. General Usage The valid functional types are:
Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | functional_type | text | 2147483647 | √ | null | Indicates how the system will interpret the IP address rule. General Usage The valid functional types are:
Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | functional_type_default | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | hierarchy_id | uuid | 2147483647 | √ | null | Identifies the Hierarchy to which the record belongs. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | host_address | inet | 2147483647 | √ | null | The IP address of the host disallowed from attempting to authenticate Access Accounts. Data Requirements
User Defined Record Supported Operations
Supplemental Notes Attempting to | |
| syst_owner_password_rules | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_perm_role_assigns | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_disallowed_hosts | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menus | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_application_contexts | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_applications | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_password_history | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_actions | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_password_rules | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_global_network_rules | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_applications | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menu_items | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owner_network_rules | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_functional_types | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_settings | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | id | uuid | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_contexts | View | instance_id | uuid | 2147483647 | √ | null | Identifies the parent Instance for which Instance Contexts are being defined. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | instance_id | uuid | 2147483647 | √ | null | The database identifier of the Instance record for whom the Network Rule is being defined. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_access_account_instance_assocs | View | instance_id | uuid | 2147483647 | √ | null | The identity of the instance to which authentication rights is being granted. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key along with column | |
| syst_instances | View | instance_options | jsonb | 2147483647 | √ | null | A key/value store of values which define application or instance specific options. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_contexts | View | instance_type_application_id | uuid | 2147483647 | √ | null | The Instance Type/Application association to which the context definition belongs. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_type_applications | View | instance_type_id | uuid | 2147483647 | √ | null | A reference to the Instance Type being associated to an Application. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_functional_types | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_accounts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_application_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_owners | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | invitation_declined | timestamptz | 35 | √ | null | The timestamp at which the access account holder explicitly declined the invitation to access the given instance. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | invitation_expires | timestamptz | 35 | √ | null | The timestamp at which the invitation to access a given instance expires. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_account_instance_assocs | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | ip_family | int4 | 10 | √ | null | Indicates which IP family (IPv4/IPv6) for which the record defines a rule. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | ip_family | int4 | 10 | √ | null | Indicates which IP family (IPv4/IPv6) for which the record defines a rule. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | ip_family | int4 | 10 | √ | null | Indicates which IP family (IPv4/IPv6) for which the record defines a rule. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_global_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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). Data Requirements
User Defined Record Supported Operations
| |
| syst_credentials | View | last_updated | timestamptz | 35 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | login_context | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | maint_scope_options | _text | 2147483647 | √ | null | 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’. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_global_password_rules | View | max_age | interval | 49 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | max_age | interval | 49 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menu_items | View | menu_id | uuid | 2147483647 | √ | null | Identifies the Menu to which the menu item belongs. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_menus | View | menu_state_id | uuid | 2147483647 | √ | null | Indicates at which life-cycle stage the record exists. Functionally, this breaks down into “active” and “inactive” states. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | ops_scope_options | _text | 2147483647 | √ | null | 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’. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_global_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | 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. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_network_rules | View | owner_id | uuid | 2147483647 | √ | null | The database identifier of the Owner record for whom the Network Rule is being defined. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_owner_password_rules | View | owner_id | uuid | 2147483647 | √ | null | Defines the relationship with the specific Owner for whom the password rule is being defined. Data Requirements
User Defined Record Supported Operations
| |
| syst_owners | View | owner_state_id | uuid | 2147483647 | √ | null | Establishes the current life-cycle state in which Instance Owner record currently resides. Data Requirements
User Defined Record Supported Operations
| |
| syst_instances | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_access_accounts | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_menu_items | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_disallowed_passwords | View | 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. Data Requirements
User Defined Record Supported Operations
Supplemental Notes Attempting to | |
| syst_global_password_rules | View | password_length | int4range | 2147483647 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | password_length | int4range | 2147483647 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_role_grants | View | perm_id | uuid | 2147483647 | √ | null | The permission being granted by the role. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_access_account_perm_role_assigns | View | perm_role_id | uuid | 2147483647 | √ | null | A reference to the Permission Role being assigned to the Access Account. Data Requirements
User Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_perm_role_grants | View | perm_role_id | uuid | 2147483647 | √ | null | Identifies the role to which the permission grant is being made. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_owner_password_rules | View | require_lower_case | int4 | 10 | √ | null | Setting this value to 0 disables the requirement for lower case characters. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | require_lower_case | int4 | 10 | √ | null | Setting this value to 0 disables the requirement for lower case characters. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | require_mfa | bool | 1 | √ | null | When true, an approved multi-factor authentication method must be used in addition to the password credential. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | require_mfa | bool | 1 | √ | null | When true, an approved multi-factor authentication method must be used in addition to the password credential. Data Requirements
System Defined Record Supported Operations
| |
| syst_global_password_rules | View | require_numbers | int4 | 10 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | require_numbers | int4 | 10 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | require_symbols | int4 | 10 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_owner_password_rules | View | require_symbols | int4 | 10 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_owner_password_rules | View | require_upper_case | int4 | 10 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_global_password_rules | View | require_upper_case | int4 | 10 | √ | null | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_hierarchy_items | View | required | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_sessions | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_sessions | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_settings | View | setting_blob | bytea | 2147483647 | √ | null | A binary configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_date | date | 13 | √ | null | A date configuation point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_date_range | daterange | 2147483647 | √ | null | A date range configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_decimal | numeric | 0 | √ | null | An decimal configuration point (not floating point). Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_decimal_range | numrange | 2147483647 | √ | null | A decimal range configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_flag | bool | 1 | √ | null | A boolean configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_integer | int8 | 19 | √ | null | An integer configuration point Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_integer_range | int8range | 2147483647 | √ | null | An integer range configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_interval | interval | 49 | √ | null | An interval configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_json | jsonb | 2147483647 | √ | null | A JSON configuration point. Note that duplicate keys at the same level are not allowed. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_text | text | 2147483647 | √ | null | A text configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_time | time | 15 | √ | null | A time configuration point (without time zone). Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_timestamp | timestamptz | 35 | √ | null | A full datetime configuration point including time zone. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_timestamp_range | tstzrange | 2147483647 | √ | null | A range of timestamps with time zone configuration points. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | setting_uuid | uuid | 2147483647 | √ | null | A UUID configuration point. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | sort_order | int2 | 5 | √ | null | Establishes the current Menu Item’s sorting order relative to sibling Menu Item records Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is part of a composite key. The combined values of | |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_instance_contexts | View | start_context | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_application_contexts | View | start_context | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | structured | bool | 1 | √ | null | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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 Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | syst_defined | bool | 1 | √ | null | If true, this value indicates that the functional type is considered to be system defined and a part of the application. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
Supplemental Notes This column is not part of the Functional Type underlying data and is a reflection of the Functional Type’s parent enumeration since the parent determines if the functional type is considered system defined. If false, the assumption is that the Functional Type ` is user defined and supports custom user functionality. See the documentation for ms_syst.syst_enums.syst_defined for a more complete complete description. | |
| syst_menus | View | syst_defined | bool | 1 | √ | null | Values of General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | 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. Data Requirements
System Defined Record Supported Operations
| |
| syst_settings | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_applications | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_roles | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menu_items | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_settings | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perm_functional_types | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
System Defined Record Supported Operations
| |
| syst_menus | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_actions | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_functional_types | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | user_description | text | 2147483647 | √ | null | An optional user defined description of the record and its use cases. If this value is not Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enums | View | user_maintainable | bool | 1 | √ | null | If a record is system defined (see the General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_hierarchies | View | user_maintainable | bool | 1 | √ | null | If a record is system defined (see the General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | user_maintainable | bool | 1 | √ | null | If a record is system defined (see the General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_action_groups | View | user_maintainable | bool | 1 | √ | null | If a record is system defined (see the General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_menus | View | user_maintainable | bool | 1 | √ | null | If a record is system defined (see the General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_enum_items | View | user_options | jsonb | 2147483647 | √ | null | Extended user defined options, similar to syst_options, but for the purpose of driving custom functionality. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_identities | View | 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. Data Requirements
User Defined Record Supported Operations
| |
| syst_perm_role_grants | View | 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. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
| |
| syst_perms | View | view_scope_options | _text | 2147483647 | √ | null | If applicable, enumerates the available Scopes of viewable data offered by the permission. General Usage If not applicable the only option will be ‘unused’. Data Requirements
User Defined Record Supported Operations
System Defined Record Supported Operations
|