mscmp_syst_instance.ms

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default	Comments
syst_instance_contexts	View	application_context_id	uuid	2147483647	√	null	Identifies the Application Context which is being defined for the Instance. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT`
syst_instance_type_contexts	View	application_context_id	uuid	2147483647	√	null	The Application Context which is being represented in the Instance Type. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT`
syst_application_contexts	View	application_id	uuid	2147483647	√	null	References the ms_syst_data.syst_applications record which owns the context. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` System Defined Record Supported Operations `SELECT`
syst_instances	View	application_id	uuid	2147483647	√	null	Indicates an instance of which application is being described by the record. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
syst_instance_type_applications	View	application_id	uuid	2147483647	√	null	A reference to the Application being associated with the Instance Type. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` `UPDATE`
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 `syst_enum_items.syst_options` column. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: false Unique Values Required?: false Default Value: `FALSE` User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
syst_enum_items	View	enum_id	uuid	2147483647	√	null	The enumeration record with which the value is associated. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` System Defined Record Supported Operations `SELECT`
syst_enum_functional_types	View	enum_id	uuid	2147483647	√	null	A reference to the owning Enumeration of the functional type. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: false Unique Values Required?: false Default Value: `FALSE` User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: true Default Value: Automatically Generated User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
syst_instance_contexts	View	instance_id	uuid	2147483647	√	null	Identifies the parent Instance for which Instance Contexts are being defined. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT`
syst_instances	View	instance_options	jsonb	2147483647	√	null	A key/value store of values which define application or instance specific options. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
syst_instance_type_applications	View	instance_type_id	uuid	2147483647	√	null	A reference to the Instance Type being associated to an Application. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: true Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
syst_owners	View	owner_state_id	uuid	2147483647	√	null	Establishes the current life-cycle state in which Instance Owner record currently resides. Data Requirements Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Only user maintainable records.
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` `UPDATE`
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 Required?: true Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.
syst_enum_items	View	syst_defined	bool	1	√	null	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements Required?: false Unique Values Required?: false Default Value: `FALSE` User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
syst_enums	View	syst_defined	bool	1	√	null	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements Required?: false Unique Values Required?: false Default Value: `FALSE` User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT` 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_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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.
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 `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.
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 `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations. Data Requirements Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.
syst_enum_items	View	user_maintainable	bool	1	√	null	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements Required?: false Unique Values Required?: false Default Value: `TRUE` User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
syst_enums	View	user_maintainable	bool	1	√	null	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations. Data Requirements Required?: false Unique Values Required?: false Default Value: `TRUE` User Defined Record Supported Operations `SELECT` System Defined Record Supported Operations `SELECT`
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 Required?: false Unique Values Required?: false Default Value: ( No Default Value ) User Defined Record Supported Operations `INSERT` `SELECT` `UPDATE` System Defined Record Supported Operations `SELECT` `UPDATE` - Always updatable, even when not otherwise user maintainable.

Showing 1 to 143 of 143 entries