sola.administrative contains 208 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
rrr	is_primary	bool	1			false	SOLA Extension. Flag it indicate if the RRR is the primary RRR for the BA Unit. One one of the current RRRs on the BA Unit can be flagged as the primary RRR.
rrr_type	is_primary	bool	1			false	SOLA Extension: Flag to indicate if the RRR type is a primary RRR.
rrr_type	party_required	bool	1				LADM Defintion: Flag to indicate at least one party must be associated with this RRR.
rrr_type	share_check	bool	1				LADM Defintion: Flag to indicate the that the sum of all shares for the RRR must be checked to ensure it equals 1.
ba_unit	change_action	bpchar	1			'i'::bpchar	SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
ba_unit_area	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).
ba_unit_contains_spatial_unit	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).
ba_unit_target	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).
condition_for_rrr	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).
mortgage_isbased_in_rrr	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).
notation	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).
notifiable_party_for_baunit	change_action	bpchar	1			'i'::bpchar
party_for_rrr	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).
required_relationship_baunit	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).
rrr	change_action	bpchar	1			'i'::bpchar	SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
rrr_share	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).
source_describes_ba_unit	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).
source_describes_rrr	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).
ba_unit_rel_type	status	bpchar	1				Status of the relationship type.
ba_unit_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the BA Unit type.
condition_type	status	bpchar	1				Status of the condition type.
mortgage_type	status	bpchar	1				SOLA Extension: Status of the mortgage type.
rrr_group_type	status	bpchar	1				SOLA Extension: Status of the RRR group type.
rrr_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the RRR type.
rrr	due_date	date	13	√		null	SOLA Extension: The date of the next payment for the RRR. E.g. the lease rental due date.
rrr	share	float8	17,17	√		null	LADM Defintion: Share of the RRR expressed as a fraction with numerator and denominator. Not used by SOLA as shares in rights are represetned in the rrr_share table. This avoids having multiple RRR of the same type on the BA Unit that only differ by share amounts.
rrr_share	denominator	int2	5				Denominator part of the share (i.e. bottom number of fraction)
rrr_share	nominator	int2	5				Nominiator part of the share (i.e. top number of fraction)
condition_for_rrr	condition_quantity	int4	10	√		null	A quantity value associted to the condition.
rrr	mortgage_ranking	int4	10	√		null	LADM Definition: The ranking order if more than one mortgage applies to the right.
ba_unit	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
ba_unit_area	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
ba_unit_contains_spatial_unit	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
ba_unit_target	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
condition_for_rrr	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
mortgage_isbased_in_rrr	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
notation	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
notifiable_party_for_baunit	rowversion	int4	10			0
party_for_rrr	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
required_relationship_baunit	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
rrr	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
rrr_share	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
source_describes_ba_unit	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
source_describes_rrr	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
rrr	mortgage_interest_rate	numeric	5,2	√		null	LADM Definition: The interest rate of the mortgage as a percentage.
ba_unit_area	size	numeric	19,2				The value of the area. Must be in metres squared and can be converted for display if requried.
rrr	amount	numeric	29,2	√		null	LADM Definition: The value of the mortgage. SOLA Extension: The amount associated with the RRR. E.g the value of the mortgage, the rental amount for a lease, etc.
sys_reg_owner_name	size	numeric	29,2	√		null
sys_reg_state_land	size	numeric	29,2	√		null
systematic_registration_listing	size	numeric	29,2	√		null
sys_reg_owner_name	agricultural	numeric	131089	√		null
sys_reg_state_land	agricultural	numeric	131089	√		null
sys_reg_owner_name	commercial	numeric	131089	√		null
sys_reg_state_land	commercial	numeric	131089	√		null
sys_reg_owner_name	industrial	numeric	131089	√		null
sys_reg_state_land	industrial	numeric	131089	√		null
sys_reg_owner_name	residential	numeric	131089	√		null
sys_reg_state_land	residential	numeric	131089	√		null
sys_reg_owner_name	last_name	text	2147483647	√		null
sys_reg_owner_name	name	text	2147483647	√		null
systematic_registration_listing	name	text	2147483647	√		null
sys_reg_owner_name	value	text	2147483647	√		null
sys_reg_state_land	value	text	2147483647	√		null
ba_unit	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
ba_unit_area	change_time	timestamp	29,6			now()	The date and time the row was last modified.
ba_unit_contains_spatial_unit	change_time	timestamp	29,6			now()	The date and time the row was last modified.
ba_unit_target	change_time	timestamp	29,6			now()	The date and time the row was last modified.
condition_for_rrr	change_time	timestamp	29,6			now()	The date and time the row was last modified.
mortgage_isbased_in_rrr	change_time	timestamp	29,6			now()	The date and time the row was last modified.
notation	change_time	timestamp	29,6			now()	The date and time the row was last modified.
notifiable_party_for_baunit	change_time	timestamp	29,6			now()
party_for_rrr	change_time	timestamp	29,6			now()	The date and time the row was last modified.
required_relationship_baunit	change_time	timestamp	29,6			now()	The date and time the row was last modified.
rrr	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
rrr_share	change_time	timestamp	29,6			now()	The date and time the row was last modified.
source_describes_ba_unit	change_time	timestamp	29,6			now()	The date and time the row was last modified.
source_describes_rrr	change_time	timestamp	29,6			now()	The date and time the row was last modified.
ba_unit	creation_date	timestamp	29,6	√		null	SOLA Extension: The datetime the BA Unit is formally recognised by the land administration agency (i.e. registered or issued).
ba_unit	expiration_date	timestamp	29,6	√		null	SOLA Extension: The datetime the BA Unit was superseded and became historic.
rrr	expiration_date	timestamp	29,6	√		null	LADM Definition: The date and time defining when the RRR remains in force to. Implementation of the LADM LA_RRR.timespec field.
notation	notation_date	timestamp	29,6	√		null	The date the notation is formalised/registered.
rrr	registration_date	timestamp	29,6	√		null	SOLA Extension: The date and time the RRR was formally registered by the Land Administration Agency.
condition_for_rrr	condition_unit	varchar	15	√		null	The unit of measure applicable for the condition quantity.
notation	reference_nr	varchar	15				The notation reference number. Value determined using the generate-notation-reference-nr business rule.
ba_unit	classification_code	varchar	20	√		null	FROM SOLA State Land Extension: The security classification for this Ba Unit. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
notation	classification_code	varchar	20	√		null	FROM SOLA State Land Extension: The security classification for this Notation. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
rrr	classification_code	varchar	20	√		null	FROM SOLA State Land Extension: The security classification for this RRR. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
ba_unit_rel_type	code	varchar	20				The code for the relationship type.
ba_unit_type	code	varchar	20				LADM Defintion: The code for the BA Unit type.
condition_type	code	varchar	20				The code for the condition type.
mortgage_type	code	varchar	20				LADM Defintion: The code for the mortgage type.
rrr_group_type	code	varchar	20				LADM Defintion: The code for the RRR group type.
rrr_type	code	varchar	20				LADM Defintion: The code for the RRR type.
condition_for_rrr	condition_code	varchar	20	√		null	The type of condition.
rrr	mortgage_type_code	varchar	20	√		null	LADM Definition: The type of mortgage.
ba_unit	name_firstpart	varchar	20				SOLA Extension: The first part of the name or reference assigned by the land administration agency to identify the property.
sys_reg_owner_name	name_firstpart	varchar	20	√		null
sys_reg_state_land	name_firstpart	varchar	20	√		null
systematic_registration_listing	name_firstpart	varchar	20	√		null
rrr	nr	varchar	20				SOLA Extension: Number to identify the RRR. Determined by the generate-rrr-nr business rule. This value is used to track the different versions of the RRR as it is edited over time.
ba_unit	redact_code	varchar	20	√		null	FROM SOLA State Land Extension: The redact classification for this Ba Unit. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.
notation	redact_code	varchar	20	√		null	FROM SOLA State Land Extension: The redact classification for this Notation. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.
rrr	redact_code	varchar	20	√		null	FROM SOLA State Land Extension: The redact classification for this RRR. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.
required_relationship_baunit	relation_code	varchar	20				Code that identifies the type of relationship between the two BA Units.
rrr_type	rrr_group_type_code	varchar	20				LADM Defintion: Identifies if the RRR type is a right, restriction or a responsibility.
rrr_type	rrr_panel_code	varchar	20	√		null	SOLA Extension. Used to identify the SOLA panel class to display to the user when they view or edit the RRR.
ba_unit	status_code	varchar	20			'pending'::character varying	LADM Definition: The status of the BA unit.
notation	status_code	varchar	20			'pending'::character varying	The status of the notation.
rrr	status_code	varchar	20			'pending'::character varying	SOLA Extension: The status of the RRR.
ba_unit	type_code	varchar	20			'basicPropertyUnit'::character varying	LADM Definition: The type of BA Unit. E.g. basicPropertyUnit, administrativeUnit, etc.
ba_unit_area	type_code	varchar	20				The type of area. E.g. officialArea, calculatedArea, etc.
rrr	type_code	varchar	20				LADM Definition: The type of RRR. E.g. freehold ownership, lease, mortage, caveat, etc.
notifiable_party_for_baunit	application_id	varchar	40
ba_unit_area	ba_unit_id	varchar	40				Identifier for the BA Unit this area value is associated to.
ba_unit_as_party	ba_unit_id	varchar	40				Identifier for the BA Unit.
ba_unit_contains_spatial_unit	ba_unit_id	varchar	40				Identifier for the BA Unit.
ba_unit_target	ba_unit_id	varchar	40				Identifier for the BA Unit.
notation	ba_unit_id	varchar	40	√		null	Identifier of the BA Unit the notation is associated with. Only populated if the notation is linked directly to the BA Unit. NULL if the notation is associated with an RRR.
rrr	ba_unit_id	varchar	40				LADM Definition: Identifier for the BA Unit the RRR applies to.
source_describes_ba_unit	ba_unit_id	varchar	40				Identifier for the BA Unit.
sys_reg_owner_name	ba_unit_id	varchar	40	√		null
sys_reg_state_land	ba_unit_id	varchar	40	√		null
systematic_registration_listing	ba_unit_id	varchar	40	√		null
notifiable_party_for_baunit	baunit_name	varchar	40
notifiable_party_for_baunit	cancel_service_id	varchar	40	√		null
required_relationship_baunit	from_ba_unit_id	varchar	40				The originating BA Unit (a.k.a. parent BA Unit). Usually a parent BA Unit will have multiple child BA Units associted to it. E.g. Island/region is the parent BA Unit for a town
ba_unit	id	varchar	40				LADM Definition: Identifier for the BA Unit.
ba_unit_area	id	varchar	40				Identifier for the BA Unit Area.
condition_for_rrr	id	varchar	40				Identifier for the condition.
notation	id	varchar	40				Identifier for the notation.
rrr	id	varchar	40				LADM Definition: Identifier for the RRR
rrr_share	id	varchar	40				Identifier for the RRR share.
sys_reg_owner_name	id	varchar	40	√		null
sys_reg_state_land	id	varchar	40	√		null
systematic_registration_listing	id	varchar	40	√		null
mortgage_isbased_in_rrr	mortgage_id	varchar	40				Identifier for the mortgage
ba_unit_as_party	party_id	varchar	40				Identifier for the Party.
notifiable_party_for_baunit	party_id	varchar	40
party_for_rrr	party_id	varchar	40				Identifier for the party associated to the RRR.
ba_unit	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table
ba_unit_area	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the ba_unit_area_historic table
ba_unit_as_party	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table
ba_unit_contains_spatial_unit	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the ba_unit_contains_spatial_unit_historic table
ba_unit_target	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the ba_unit_target_historic table
condition_for_rrr	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the condition_for_rrr_historic table
mortgage_isbased_in_rrr	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the ba_unit_contains_spatial_unit_historic table
notation	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the notation_historic table
notifiable_party_for_baunit	rowidentifier	varchar	40			uuid_generate_v1()
party_for_rrr	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the party_for_rrr_historic table
required_relationship_baunit	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the required_relationship_baunit_historic table
rrr	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the rrr_historic table
rrr_share	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the rrr_share_historic table
source_describes_ba_unit	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the source_describes_ba_unit_historic table
source_describes_rrr	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the source_describes_ba_unit_historic table
condition_for_rrr	rrr_id	varchar	40				Identifier of the RRR the condition relates to.
mortgage_isbased_in_rrr	rrr_id	varchar	40				Identifier for the RRR associated to the mortgage.
notation	rrr_id	varchar	40	√		null	Identifier of the RRR the notation is assocaited with. Must not be populated if ba_unit_id is populated.
party_for_rrr	rrr_id	varchar	40				Identifier for the RRR.
rrr_share	rrr_id	varchar	40				Identifier of the RRR the share is assocaited with.
source_describes_rrr	rrr_id	varchar	40				Identifier for the RRR.
notifiable_party_for_baunit	service_id	varchar	40
party_for_rrr	share_id	varchar	40	√		null	Identifier for the share the party has in the RRR. Not populated unless the RRR is subject to a shared allocation. E.g. Mortgage RRR does not have shares.
source_describes_ba_unit	source_id	varchar	40				Identifier for the source associated with the BA Unit.
source_describes_rrr	source_id	varchar	40				Identifier for the source associated with the RRR.
ba_unit_contains_spatial_unit	spatial_unit_id	varchar	40				Identifier for the Spatial Unit associated to the BA Unit.
notifiable_party_for_baunit	status	varchar	40			'c'::character varying
notifiable_party_for_baunit	target_party_id	varchar	40
required_relationship_baunit	to_ba_unit_id	varchar	40				The target BA Unit (a.k.a. child BA Unit). For any given relationship type, the child BA Unit will usually only have one logical parent BA Unit. E.g. A new title is the child BA Unit of the original title that is being superseded.
ba_unit	transaction_id	varchar	40	√		null	SOLA Extension: Reference to the SOLA transaction that created the BA Unit.
ba_unit_target	transaction_id	varchar	40				Identifier for the transaction to cancel the BA Unit.
notation	transaction_id	varchar	40				Identifier of the transaction that created the notation.
rrr	transaction_id	varchar	40				SOLA Extension: Identifier of the transaction that created the RRR.
ba_unit	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
ba_unit_area	change_user	varchar	50	√		null	The user id of the last person to modify the row.
ba_unit_contains_spatial_unit	change_user	varchar	50	√		null	The user id of the last person to modify the row.
ba_unit_target	change_user	varchar	50	√		null	The user id of the last person to modify the row.
condition_for_rrr	change_user	varchar	50	√		null	The user id of the last person to modify the row.
mortgage_isbased_in_rrr	change_user	varchar	50	√		null	The user id of the last person to modify the row.
notation	change_user	varchar	50	√		null	The user id of the last person to modify the row.
notifiable_party_for_baunit	change_user	varchar	50	√		null
party_for_rrr	change_user	varchar	50	√		null	The user id of the last person to modify the row.
required_relationship_baunit	change_user	varchar	50	√		null	The user id of the last person to modify the row.
rrr	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
rrr_share	change_user	varchar	50	√		null	The user id of the last person to modify the row.
source_describes_ba_unit	change_user	varchar	50	√		null	The user id of the last person to modify the row.
source_describes_rrr	change_user	varchar	50	√		null	The user id of the last person to modify the row.
ba_unit	name_lastpart	varchar	50				SOLA Extension: The remaining part of the name or reference assigned by the land administration agency to identify the property.
sys_reg_owner_name	name_lastpart	varchar	50	√		null
sys_reg_state_land	name_lastpart	varchar	50	√		null
systematic_registration_listing	name_lastpart	varchar	50	√		null
ba_unit	name	varchar	255	√		null	LADM Definition: The name of the BA Unit. Usually a concatenation of the name_firstpart and name_lastpart formatted as required.
condition_for_rrr	custom_condition_text	varchar	500	√		null	User entered text describing the condition and/or updated or revised text obtained from the template condition text.
ba_unit_rel_type	display_value	varchar	500				Displayed value of the relationship type.
ba_unit_type	display_value	varchar	500				LADM Defintion: Displayed value of the BA Unit type.
condition_type	display_value	varchar	500				Displayed value of the condition type.
mortgage_type	display_value	varchar	500				LADM Defintion: Displayed value of the mortgage type.
rrr_group_type	display_value	varchar	500				LADM Defintion: Displayed value of the RRR group type.
rrr_type	display_value	varchar	500				LADM Defintion: Displayed value of the RRR type.
ba_unit_rel_type	description	varchar	1000	√		null	Description of the relationship type.
ba_unit_type	description	varchar	1000	√		null	LADM Defintion: Description of the BA Unit type.
mortgage_type	description	varchar	1000	√		null	LADM Defintion: Description of the mortgage type.
rrr_group_type	description	varchar	1000	√		null	LADM Defintion: Description of the RRR group type.
rrr_type	description	varchar	1000	√		null	LADM Defintion: Description of the RRR type.
notation	notation_text	varchar	1000	√		null	The text of the notation. Note that template notation text can be obtained from the request type (i.e. service) the notation has been created as part of.
condition_type	description	varchar	10000				The template text describing the condition.
sys_reg_owner_name	land_use_code	varchar	2147483647	√		null
sys_reg_state_land	land_use_code	varchar	2147483647	√		null
systematic_registration_listing	land_use_code	varchar	2147483647	√		null