sola.system contains 190 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
appuser	activation_code	varchar	40	√		null
appuser	activation_expiration	timestamp	29,6	√		null	Account activation timeout. It can be used to delete account if it was not activated in time.
appuser	active	bool	1			true
appuser_setting	active	bool	1			true	Flag to indicate if the setting is active or not.
config_map_layer	active	bool	1			true	Flag to indicate if the layer is active. Inactive layers are not displayed in the map layer control.
language	active	bool	1			true	Indicates if the language is current active or not.
map_search_option	active	bool	1			true	Indicates the Map Search Option is active or not.
setting	active	bool	1			true	Indicates if the setting is active or not. If not active, the default value for the setting will apply.
br_definition	active_from	date	13				The date this version of the rule is active from.
br_definition	active_until	date	13			'infinity'::date	The date until this version of the rule is active.
config_map_layer	added_from_bulk_operation	bool	1			false	Flag to indicate the layer was added when using the SOLA Bulk Operation feature.
approle_appgroup	appgroup_id	varchar	40				Identifier for the group the role is associated to.
appuser_appgroup	appgroup_id	varchar	40				Identifier for the group the user is associated to.
approle_appgroup	approle_code	varchar	20				Code for the security role.
appuser_appgroup	appuser_id	varchar	40				Identifier for the SOLA user.
email	attachment	bytea	2147483647	√		null	Attachment file to send
email	attachment_mime_type	varchar	250	√		null	attachment_mime_type
email	attachment_name	varchar	250	√		null	Attachment file name
email	attempt	int4	10			1	Number of attempt of sending message.
email	bcc	varchar	5000	√		null	List of names and email address to send a blind copy of the message
br_current	body	varchar	4000	√		null
br_definition	body	varchar	4000				The definition of the rule. Either SQL commands or Drools XML.
br_report	body	varchar	4000	√		null
email	body	varchar	8000				Message body
br_definition	br_id	varchar	100				Identifier for the business rule
br_validation	br_id	varchar	100				The business rule referenced by this br validation record.
config_panel_launcher	card_name	varchar	50	√		null	The MainContentPanel card name for the panel to launch
email	cc	varchar	5000	√		null	List of names and email address to send a copy of the message
approle_appgroup	change_action	bpchar	1			'i'::bpchar	Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
appuser	change_action	bpchar	1			'i'::bpchar
appuser_appgroup	change_action	bpchar	1			'i'::bpchar	Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
approle_appgroup	change_time	timestamp	29,6			now()	The date and time the row was last modified.
appuser	change_time	timestamp	29,6			now()
appuser_appgroup	change_time	timestamp	29,6			now()	The date and time the row was last modified.
approle_appgroup	change_user	varchar	50	√		null	The user id of the last person to modify the row.
appuser	change_user	varchar	50	√		null
appuser_appgroup	change_user	varchar	50	√		null	The user id of the last person to modify the row.
approle	code	varchar	20				Code for the security role. Must match exactly the code value used within the SOLA source code to reference the role.
br_severity_type	code	varchar	20				Code for the severity type.
br_technical_type	code	varchar	20				Code for the technical type.
br_validation_target_type	code	varchar	20				Code for the validation target type.
config_map_layer_type	code	varchar	20				Code for the map layer type.
config_panel_launcher	code	varchar	20				The code for the panel to launch
language	code	varchar	7				Code for the langauge.
map_search_option	code	varchar	20				The code for the map search option.
panel_launcher_group	code	varchar	20				The code for the panel launcher group
consolidation_config	condition_description	varchar	1000				Description of the condition has to be applied to rows of the source table for extraction.
consolidation_config	condition_sql	varchar	1000	√		null	The SQL implementation of the condition.
appgroup	description	varchar	1000	√		null	Describes the purpose of the appgroup and should also indicate when it applies.
approle	description	varchar	5000	√		null	Describes the purpose of the role and should also indicate when it applies.
appuser	description	varchar	255	√		null
br	description	varchar	1000	√		null	A description of the business rule. Intended for system administrators and end users.
br_report	description	varchar	1000	√		null
br_severity_type	description	varchar	1000	√		null	A description of the severity type.
br_technical_type	description	varchar	1000	√		null	A description of the technical type.
br_validation_target_type	description	varchar	5000	√		null	A description of the validation target type.
config_map_layer_type	description	varchar	555	√		null	A description of the map layer type.
config_panel_launcher	description	varchar	1000	√		null	Description for the panel to launch
map_search_option	description	varchar	500	√		null	A description for the search option.
panel_launcher_group	description	varchar	1000	√		null	Description for the panel launcher group
query	description	varchar	1000	√		null	Technical description for the query.
setting	description	varchar	555				Description of the setting.
br	display_name	varchar	250			uuid_generate_v1()	The display name for the business rule.
approle	display_value	varchar	500				The text value that will be displayed to the user.
br_severity_type	display_value	varchar	500				The text value that will be displayed to the user.
br_technical_type	display_value	varchar	500				The text value that will be displayed to the user.
br_validation_target_type	display_value	varchar	500				The text value that will be displayed to the user.
config_map_layer_type	display_value	varchar	250				The text value that will be displayed to the user.
config_panel_launcher	display_value	varchar	500				The user friendly name for the panel to launch
language	display_value	varchar	250				The text value that will be displayed to the user.
panel_launcher_group	display_value	varchar	500				The user friendly name for the panel launcher group
query_field	display_value	varchar	200	√		null	The title to display for the query field when presenting results to the user. This value supports localization.
appuser	email	varchar	40	√		null
email	error	varchar	5000	√		null	Error message received when sending the message.
br	feedback	varchar	2000	√		null	The message that should be displayed to the user if the rule is not complied with.
br_current	feedback	varchar	2000	√		null
br_report	feedback	varchar	2000	√		null
appuser	first_name	varchar	30				The first name of the SOLA user.
config_map_layer_metadata	for_client	bool	1	√		false	Indicates whether an option is for use by the client or server. If true, it's supposed to be used by the client map control, otherwise option is sent to the server.
crs	from_long	float8	17,17	√		null	The longitude in WGS84 identifying the where the CRS is valid from.
appgroup	id	varchar	40				Identifier for the appgroup.
appuser	id	varchar	40				The SOLA user identifier.
br	id	varchar	100				The name of the business rule
br_current	id	varchar	100	√		null
br_report	id	varchar	100	√		null
br_validation	id	varchar	40			uuid_generate_v1()	Identifier for the br validation
consolidation_config	id	varchar	100
email	id	varchar	40				Unique identifier of the record.
query_field	index_in_query	int4	10				Indicates the position of the result field in the query result set. The index is zero based. The number must not exceed the number of fields in the select part of the query.
language	is_default	bool	1			false	Indicates the default language used by SOLA. Only one record in the table should have is_default = true.
config_map_layer	item_order	int4	10			0	The order to use for display of layers in the layer control. The layer with the lowest number will be displayed at the bottom of the layer control.
crs	item_order	int4	10				Identifies the order the CRS is displayed in the drop down menu on the Map Viewer. The CRS with the lowest item order will be used as the default CRS for the initial display of the map.
language	item_order	int4	10			1	The order the langages should be displayed. The lowest order number will display the langage at the top of the language list. Also identifies the order that all localized string values must store their language translations.
appuser	last_name	varchar	30				The last name of the SOLA user.
user_pword_expiry	last_pword_change	timestamp	29,6	√		null
config_panel_launcher	launch_group	varchar	20				The launch group for the panel.
consolidation_config	log_in_extracted_rows	bool	1			true	True - If the records has to be logged in the extracted rows table.
language	ltr	bool	1			true	Indicates text direction. If true, then left to right should applied, otherwise right to left.
config_panel_launcher	message_code	varchar	50	√		null	The code of the message to display when opening the panel. See the ClientMessage class for a list of codes.
map_search_option	min_search_str_len	int2	5			3	The minimum number of characters required for the search string.
appuser	mobile_number	varchar	20	√		null
br_report	moment_code	varchar	20	√		null
appgroup	name	varchar	600				The name assigned to the appgroup.
appuser_setting	name	varchar	50				The name of the setting.
config_map_layer	name	varchar	50				Name assigned to the map layer.
config_map_layer_metadata	name	varchar	50
query	name	varchar	100				Identifier/name for the query
query_field	name	varchar	100				Identifier/name for the query field
setting	name	varchar	50				Identifier/name for the setting
config_map_layer_metadata	name_layer	varchar	50
user_pword_expiry	no_pword_expiry	bool	1	√		null
br_report	order_of_execution	int4	10	√		null
br_validation	order_of_execution	int4	10			0	Number used to order the execution of business rules in the rule set.
consolidation_config	order_of_execution	int4	10				Order of execution of the extract.
config_panel_launcher	panel_class	varchar	100	√		null	The full package and class name for the panel to launch. e.g. org.sola.clients.swing.desktop.administrative.PropertyPanel
active_users	passwd	varchar	100	√		null
appuser	passwd	varchar	100			uuid_generate_v1()
config_map_layer	pojo_query_name	varchar	100	√		null	The name of the query (i.e. system.query) used to retrieve features for this layer.
config_map_layer	pojo_query_name_for_select	varchar	100	√		null	The name of the query to use to select objects corresponding to the layer. Can be used for any layer type
config_map_layer	pojo_structure	varchar	500	√		null	Plain old java object structure. Must be specified in the same format as requried by the Geotools featuretype definition. E.g. theGeom:Polygon,label:""
user_pword_expiry	pword_change_user	varchar	50	√		null
user_pword_expiry	pword_expiry_days	int4	10	√		null
map_search_option	query_name	varchar	100				The query (i.e. system.query) that will be used for retrieving the search results. The query requires only one parameter : search_string. Map search queries must be defined to use this parameter and return 3 fields; id - unique id for the matched item, label - the value to display to the user, the_geom: the WKB of the matched geometry.
query_field	query_name	varchar	100				Identifier/name for the query
email	recipient	varchar	255				Email address of recipient.
email	recipient_name	varchar	255	√		null	Name of recipient.
consolidation_config	remove_before_insert	bool	1			false	True - The records in the destination will be removed if they are found in the new extract. The check is done in rowidentifier.
user_roles	rolename	varchar	20	√		null
approle_appgroup	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the system.approle_appgroup_historic table
appuser	rowidentifier	varchar	40			uuid_generate_v1()
appuser_appgroup	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the system.appuser_appgroup_historic table
extracted_rows	rowidentifier	varchar	40				The rowidentifier of the record. Carefull: It is the rowidentifier and not the id.
approle_appgroup	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
appuser	rowversion	int4	10			0
appuser_appgroup	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
consolidation_config	schema_name	varchar	100				Name of the source schema.
config_map_layer	security_password	varchar	30	√		null	The password to access a secure wms layer. Not currently used.
config_map_layer	security_user	varchar	30	√		null	The username to access a secure wms layer. Not currently used.
br_report	severity_code	varchar	20	√		null
br_validation	severity_code	varchar	20				The severity of the business rule failure.
config_map_layer	shape_location	varchar	500	√		null	The location of the shapefile. Used for layers of type shape. THe client application must have access to the shape file location.
query	sql	varchar	4000				The SQL query definition. These SQL queries are executed using MyBatis, so it is possible to identify query parameters using the #{param} syntax.
crs	srid	int4	10				The Spatial Reference Identifier (SRID) for the CRS.
approle	status	bpchar	1				The status of the role.
br_severity_type	status	bpchar	1				The status of the severity type.
br_technical_type	status	bpchar	1				The status of the technical type.
br_validation_target_type	status	bpchar	1				The status of the validation target type.
config_map_layer_type	status	bpchar	1				The status of the map layer type.
config_panel_launcher	status	bpchar	1			't'::bpchar	Status of this configuration record.
panel_launcher_group	status	bpchar	1			't'::bpchar	Status of this panel launcher group
config_map_layer	style	varchar	4000	√		null	An SLD document representing the styles to use for display of the layer features in the map.
email	subject	varchar	250				Subject of the message
consolidation_config	table_name	varchar	100				Name of the source table.
extracted_rows	table_name	varchar	200				The table where the record has been found. It has to be absolute table name including the schema name.
br_validation	target_application_moment	varchar	20	√		null	Identifies the application action the rule applies to. E.g. approve, validate, etc. Only valid if target_code is application.
br_report	target_code	varchar	20	√		null
br_validation	target_code	varchar	20				The entity that is the target of the validation E.g. application, service, rrr, etc.
br_validation	target_reg_moment	varchar	20	√		null	Identifies the entity status the rule applies to. E.g. current, pending, etc. Only valid if target_code is one of ba_unit, cadastre_object, source, rrr or bulkOperationSpatial.
br_report	target_request_type_code	varchar	20	√		null
br_validation	target_request_type_code	varchar	20	√		null	Used as an additional filter for the set of business rules to run by ensuring the rule is only executed if the service type (a.k.a. request_type) matches the specified value.
br_report	target_rrr_type_code	varchar	20	√		null
br_validation	target_rrr_type_code	varchar	20	√		null	Used as an additional filter for the set of business rules to run by ensuring the rule is only executed if the rrr type matches the specified value.
br_validation	target_service_moment	varchar	20	√		null	Identifies the service action the rule applies to. E.g. complete, start, cancel, etc. Only valid if the target_code is service.
br	technical_description	varchar	1000	√		null	A technical description of the business rule including any parameters the rule expects. Intended for developers.
br	technical_type_code	varchar	20				Indicates which engine must be used to run the business rule (sql or drools). Note that SOLA does not currently implement any Drools rules.
br_current	technical_type_code	varchar	20	√		null
br_report	technical_type_code	varchar	20	√		null
email	time_to_send	timestamp	29,6			now()	Date and time when to send the message.
config_map_layer	title	varchar	100				The title used for the layer when it is displayed in the map control.
map_search_option	title	varchar	50				The title displayed to the user for the map search option.
crs	to_long	float8	17,17	√		null	The longitude in WGS84 identifying the where the CRS is valid to.
config_map_layer	type_code	varchar	20				Indicates the source of data for the map layer. One of pojo (Plain Old Java Object - SOLA specific), wms (Web Map Service), shape (Shapefile)
user_pword_expiry	uname	varchar	40	√		null
config_map_layer	url	varchar	500	√		null	The URL identifying the data source for a WMS layer.
config_map_layer	use_for_ot	bool	1			true	Flag to indicate if the layer must be visible on open tenure map.
config_map_layer	use_in_public_display	bool	1			false	Flag to indicate if the layer must be visible when printing the public display map. Not relevant for other kinds of map operations.
appuser_setting	user_id	varchar	40				Identifier of the user the setting applies to.
active_users	username	varchar	40	√		null
appuser	username	varchar	40				The user name assigned to the SOLA user.
user_roles	username	varchar	40	√		null
config_map_layer_metadata	value	varchar	100
version	version_num	varchar	50				The version number for the changeset.
config_map_layer	visible_in_start	bool	1			true	Flag to indicate if the layer should be turned on and display when the map initially displays
appuser_setting	vl	varchar	2000				The value of the setting
setting	vl	varchar	2000				The value for the setting.
config_map_layer	wms_data_source	varchar	200	√		null	Description to display in the Map when the WMS layer is turned on.
config_map_layer	wms_format	varchar	15	√		null	Format of the output for the WMS layer. Allowed values are as defined by the WMS server capabilities. E.g. image/png or image/jpeg.
config_map_layer	wms_layers	varchar	500	√		null	The names of the layers to request when obtaining data from a Web Map Service. Layer names must be separated with a comma.
config_map_layer	wms_version	varchar	10	√		null	The version of the WMS server. Values can be one of 1.0.0, 1.1.0, 1.1.1, 1.3.0.
map_search_option	zoom_in_buffer	numeric	20,2			50	The buffer distance to use when zooming the map to display the selected object. The units of this value are dependent on the coordinate system of the map (usually meters).