mssub_bms.ms_syst

Columns

Search:

Table	Type	Column	Type	Size	Nullable	Default	Comments
syst_complex_format_values	Table	complex_format_id	uuid	2147483647		null	The format record with which the value is associated.
syst_interaction_logs	Table	data	jsonb	2147483647	√	null	Optional document style data which may more completely elaborate on the activity being recorded.
syst_enums	Table	default_syst_options	jsonb	2147483647	√	null	Establishes the expected extended system options along with default values if applicable. General Usage Note that this setting is used to both validate and set defaults in the `syst_enum_items.syst_options` column.
syst_enums	Table	default_user_options	jsonb	2147483647	√	null	Allows a user to set the definition of syst_enum_items.user_options values and provide defaults for those values if appropriate.
syst_complex_formats	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_role_created	text	2147483647		null	The database role which created the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_role_modified	text	2147483647		null	The database role which modified the record. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_interaction_logs	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_enums	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_complex_format_values	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_settings	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_complex_formats	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_enum_items	Table	diag_row_version	int8	19		1	The current version of the row. The value here indicates how many actual data changes have been made to the row. If an update of the row leaves all data fields the same, disregarding the updates to the diag_* columns, the row version is not updated, nor are any updates made to the other diag_* columns other than diag_update_count. General Usage This column is system maintained and should be considered read only in normal operations. Direct Usage This column is frequently used by by application logic to resolve the “dirty write” issues which can arise from concurrent data changes. As such any administrative override of automatic system maintenance of this value should consider the ramifications on application function.
syst_complex_formats	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_timestamp_created	timestamptz	35		now()	The database server date/time when the transaction which created the record started. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_timestamp_modified	timestamptz	35		now()	The database server date/time when the transaction which modified the record started. This field will be the same as diag_timestamp_created for inserted records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_update_count	int8	19		0	Records the number of times the record has been updated regardless as to if the update actually changed any data. In this way needless or redundant record updates can be found. This row starts at 0 and therefore may be the same as the diag_row_version - 1. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	diag_wallclock_modified	timestamptz	35		clock_timestamp()	The database server date/time at the moment the record was actually modified. For long running transactions this time may be significantly later than the value of diag_timestamp_modified. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	display_name	text	2147483647		null	A friendly name and candidate key for the record, suitable for use in user interactions General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	enum_default	bool	1		false	If true, indicates that this value is the default selection from all values defined for the enumerations. General Usage Note that if a record is inserted or updated in this table with enum_default set true, and another record already exists for the enumeration with its enum_default set true, the newly inserted/updated record will take precedence and the value record previously set to be default will have its enum_default setting set to false. If false then the value record has no special significance relative to defaulting.
syst_enum_functional_types	Table	enum_id	uuid	2147483647		null	A reference to the owning Enumeration of the functional type.
syst_enum_items	Table	enum_id	uuid	2147483647		null	The enumeration record with which the value is associated.
syst_complex_format_values	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_enum_items	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_enum_functional_types	Table	external_name	text	2147483647		null	A non-unique/non-key value used to display to users and external parties where uniqueness is less of a concern than specific end user presentation.
syst_complex_format_values	Table	format_default	bool	1		false	If true, indicates that this value is the default selection from all values defined for the enumerations. If false then the value record has no special significance relative to defaulting. 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.
syst_enum_items	Table	functional_type_default	bool	1		false	If true, the value record is the default selection for any of a specific fucntional type. This is helpful in situations where a progression of state is automatically processed by the system and the state is represented by an enumeration. General Usage Note that if a record is inserted or updated in this table with its functional_type_default set true, and another record already exists for the enumeration/functional type combination with its functional_type_default set true, the newly inserted/updated record will take precedence and the value record previously set to be default will have its functional_type_default setting set to false. In cases where there are no functional types, this value should simply remain false.
syst_enum_items	Table	functional_type_id	uuid	2147483647	√	null	If the enumeration requires a functional type, this column references the functional type associated with the enumeration value record. General Usage Note that not all enumerations require functional types. If syst_enum_functional_types records exist for an enumeration, then this column will be required for any values of that enumeration; if there are no functional types defined for an enumeration, the this column must remain NULL.
syst_interaction_logs	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	id	uuid	2147483647		uuid_generate_v7()	The record’s primary key. The definitive identifier of the record in the system. General Usage This column is system maintained and should be considered read only in normal operations.
syst_interaction_logs	Table	interaction_timestamp	timestamptz	35		now()	The nominal time at which the event being recorded is considered to have happened. This is the database transaction start time specifically.
syst_interaction_logs	Table	interaction_type_id	uuid	2147483647		null	The kind of interaction being recorded.
syst_interaction_logs	Table	interface_type_id	uuid	2147483647		null	The origin entry point into the application and from which the activity was initiated.
syst_enum_items	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	internal_name	text	2147483647		null	A candidate key useful for programmatic references to individual records. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	setting_blob	bytea	2147483647	√	null	A binary configuration point.
syst_settings	Table	setting_date	date	13	√	null	A date configuation point.
syst_settings	Table	setting_date_range	daterange	2147483647	√	null	A date range configuration point.
syst_settings	Table	setting_decimal	numeric	0	√	null	An decimal configuration point (not floating point).
syst_settings	Table	setting_decimal_range	numrange	2147483647	√	null	A decimal range configuration point.
syst_settings	Table	setting_flag	bool	1	√	null	A boolean configuration point.
syst_settings	Table	setting_integer	int8	19	√	null	An integer configuration point
syst_settings	Table	setting_integer_range	int8range	2147483647	√	null	An integer range configuration point.
syst_settings	Table	setting_interval	interval	49	√	null	An interval configuration point.
syst_settings	Table	setting_json	jsonb	2147483647	√	null	A JSON configuration point. Note that duplicate keys at the same level are not allowed.
syst_settings	Table	setting_text	text	2147483647	√	null	A text configuration point.
syst_settings	Table	setting_time	time	15	√	null	A time configuration point (without time zone).
syst_settings	Table	setting_timestamp	timestamptz	35	√	null	A full datetime configuration point including time zone.
syst_settings	Table	setting_timestamp_range	tstzrange	2147483647	√	null	A range of timestamps with time zone configuration points.
syst_settings	Table	setting_uuid	uuid	2147483647	√	null	A UUID configuration point.
syst_complex_format_values	Table	sort_order	int4	10		null	Indicates the sort ordering of the particular value record with the lowest value sorting first. When a value record for an enumeration is inserted or updated and this column is being set to a value which equals another enumeration value record for the same enumeration, the system assumes that the new record is being set to precede the existing record and it will be set to sort after the newly inserted/updated enumeration value.
syst_enum_items	Table	sort_order	int2	5		null	Indicates the sort ordering of the particular value record with the lowest value sorting first. General Usage When a value record for an enumeration is inserted or updated and this column is being set to a value which equals another enumeration value record for the same enumeration, the system assumes that the new record is being set to precede the existing record and it will be set to sort after the newly inserted/updated enumeration value.
syst_complex_format_values	Table	syst_data	jsonb	2147483647		null	For the system expected data definition this column identifies the individual fields that make up the complex format type along with the expected type and other expected metadata for each field.
syst_enum_items	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	syst_defined	bool	1		false	Values of `TRUE` in this column indicate that the record is considered a “System Defined” record, a record which is created and primarily maintained by the system using automated processes. A value of `FALSE` indicates that the record is considered a “User Defined” record which is maintained by user actions in the application. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_functional_types	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_formats	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_settings	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	syst_description	text	2147483647		null	A system defined description indicating the purpose and use cases of a given record. Text defined in this column is system maintained and should not be changed under normal circumstances. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	syst_form	jsonb	2147483647		null	Describes how the individual data fields of the complex format are presented in user interfaces and printed documents.
syst_enum_items	Table	syst_options	jsonb	2147483647	√	null	Extended options and metadata which describe the behavior and meaning of the specific value within the enumeration. General Usage The owning syst_enums record’s default_syst_options column will indicate what syst_options are required or available and establishes default values for them.
syst_complex_format_values	Table	user_data	jsonb	2147483647	√	null	Allows for custom user data fields to be defined in place of the system provided data in syst_data. Note that when this column is not null, it replaces the system definition: it does not augment it. This means that any system expected data fields should also appear in the user data.
syst_enum_functional_types	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_enum_items	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_enums	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_settings	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_complex_format_values	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_complex_formats	Table	user_description	text	2147483647	√	null	An optional user defined description of the record and its use cases. If this value is not `NULL`, the value will override any `syst_description` defined text in application user interfaces and other presentations.
syst_complex_format_values	Table	user_form	jsonb	2147483647	√	null	Allows for custom user layout of the format data fields in user interfaces and other user presentations. Note that when this column is not null, it replaces the system definition and so any system expected layout elements should also be accounted for in this user layout.
syst_complex_formats	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_complex_format_values	Table	user_maintainable	bool	1		false	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enums	Table	user_maintainable	bool	1		true	If a record is system defined (see the `syst_defined` column), there may be some user data maintenance operations permitted in some cases. If the value of this column for a record is `TRUE` and the record is also “System Defined”, then permitted user maintenance operations are available for the record. If the record is system defined and the value of this column is `FALSE`, no user maintenance is allowed. If the record is not system defined, the value in this column will have no meaning or effect; user defined records may set this value `TRUE` as a simple information point indicating that the record is user maintainable. General Usage This column is system maintained and should be considered read only in normal operations.
syst_enum_items	Table	user_options	jsonb	2147483647	√	null	Extended user defined options, similar to syst_options, but for the purpose of driving custom functionality.

Showing 1 to 128 of 128 entries