Columns
| Table | Type | Column | Type | Size | Nullable | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|---|
| 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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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_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
|