sola.party contains 78 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
communication_type	code	varchar	20				The code for the communication type.
communication_type	description	varchar	1000	√		null	Description of the communication type.
communication_type	display_value	varchar	500				Displayed value of the communication type.
communication_type	status	bpchar	1			't'::bpchar	Status of the communication type
gender_type	code	varchar	20				The code for the gender type.
gender_type	description	varchar	1000	√		null	Description of the gender type.
gender_type	display_value	varchar	500				Displayed value of the gender type.
gender_type	status	bpchar	1			't'::bpchar	Status of the gender type
group_party	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).
group_party	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
group_party	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
group_party	id	varchar	40				LADM Definition: Identifier for the group party.
group_party	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the group_party_historic table
group_party	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
group_party	type_code	varchar	20				LADM Definition: The type of the group party. E.g. family, tribe, association, etc.
group_party_type	code	varchar	20				LADM Definition: The code for the group party type.
group_party_type	description	varchar	1000	√		null	LADM Definition: Description of the group party type.
group_party_type	display_value	varchar	500				LADM Definition: Displayed value of the group party type.
group_party_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the group party type
id_type	code	varchar	20				The code for the id type.
id_type	description	varchar	1000	√		null	Description of the id type.
id_type	display_value	varchar	500				Displayed value of the id type.
id_type	status	bpchar	1			't'::bpchar	Status of the id type
party	address_id	varchar	40	√		null	SOLA Extension: Identifier for the contact address of the party.
party	alias	varchar	50	√		null	SOLA Extension: Any alias for the party. A party can have more than one alias. If so, the aliases should be separated by a comma.
party	birth_date	date	13	√		null	SOLA Extension: Date of birth.
party	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).
party	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party	classification_code	varchar	20	√		null	FROM SOLA State Land Extension: The security classification for this Party. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
party	email	varchar	50	√		null	SOLA Extension: The party's contact email address.
party	ext_id	varchar	255	√		null	SOLA Extension: An identifier for the party from some external system such as a customer relationship management (CRM) system.
party	fathers_last_name	varchar	50	√		null	SOLA Extension: The last name of the father for the party. Relevant where the fathers last name forms part of the name for the party.
party	fathers_name	varchar	50	√		null	SOLA Extension: The first name of the father for the party. Relevant where the fathers first name forms part of the name for the party.
party	fax	varchar	15	√		null	SOLA Extension: The party's fax number.
party	gender_code	varchar	20	√		null	SOLA Extension: Identifies the gender for the party. If the party is of type naturalPerson then a gender code must be specified.
party	id	varchar	40				LADM Definition: Identifier for the party.
party	id_number	varchar	20	√		null	SOLA Extension: The number from the id used to verify the identity of the party.
party	id_type_code	varchar	20	√		null	SOLA Extension: Used to indicate the type of id used to verify the identity of the party.
party	last_name	varchar	50	√		null	SOLA Extension: The last name for the party or blank for groups and organisations.
party	mobile	varchar	15	√		null	SOLA Extension: The party's contact mobile phone number.
party	name	varchar	255	√		null	LADM Definition: The first name(s) for the party or the group or organisation name.
party	phone	varchar	15	√		null	SOLA Extension: The party's main contact phone number. I.e. landline.
party	preferred_communication_code	varchar	20	√		null	SOLA Extension: Used to indicate the party's preferred means of communication with the land administration agency.
party	redact_code	varchar	20	√		null	FROM SOLA State Land Extension: The redact classification for this Party. 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.
party	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the party_historic table
party	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party	type_code	varchar	20				LADM Definition: The type of the party. E.g. naturalPerson, nonNaturalPerson, etc.
party_member	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).
party_member	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party_member	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party_member	group_id	varchar	40				LADM Definition: Identifier of the group party
party_member	party_id	varchar	40				LADM Definition: Identifier for the party.
party_member	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the party_member_historic table
party_member	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_member	share	float8	17,17	√		null	LADM Definition: The share of a RRR held by a party member expressed as a fraction with a numerator and a denominator.
party_role	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).
party_role	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party_role	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party_role	party_id	varchar	40				LADM Definition: Identifier for the party.
party_role	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the party_role_historic table
party_role	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_role	type_code	varchar	20				SOLA Extension: The type of role the party holds
party_role_type	code	varchar	20				The code for the party role type.
party_role_type	description	varchar	1000	√		null	Description of the party role type.
party_role_type	display_value	varchar	500				Displayed value of the party role type.
party_role_type	status	bpchar	1			't'::bpchar	Status of the party role type
party_type	code	varchar	20				LADM Definition: The code for the party type.
party_type	description	varchar	1000	√		null	LADM Definition: Description of the party type.
party_type	display_value	varchar	500				LADM Definition: Displayed value of the party type.
party_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the party type
source_describes_party	change_action	bpchar	1			'i'::bpchar
source_describes_party	change_time	timestamp	29,6			now()
source_describes_party	change_user	varchar	50	√		null
source_describes_party	party_id	varchar	40
source_describes_party	rowidentifier	varchar	40			uuid_generate_v1()
source_describes_party	rowversion	int4	10			0
source_describes_party	source_id	varchar	40