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

Table	Column	Type	Size	Nulls	Auto	Default	Comments
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).
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_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_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).
source_describes_party	change_action	bpchar	1			'i'::bpchar
communication_type	status	bpchar	1			't'::bpchar	Status of the communication type
gender_type	status	bpchar	1			't'::bpchar	Status of the gender type
group_party_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the group party type
id_type	status	bpchar	1			't'::bpchar	Status of the id type
party_role_type	status	bpchar	1			't'::bpchar	Status of the party role type
party_type	status	bpchar	1			't'::bpchar	SOLA Extension: Status of the party type
party	birth_date	date	13	√		null	SOLA Extension: Date of birth.
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.
group_party	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_member	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
party_role	rowversion	int4	10			0	SOLA Extension: Sequential value indicating the number of times this row has been modified.
source_describes_party	rowversion	int4	10			0
group_party	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party_member	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
party_role	change_time	timestamp	29,6			now()	SOLA Extension: The date and time the row was last modified.
source_describes_party	change_time	timestamp	29,6			now()
party	fax	varchar	15	√		null	SOLA Extension: The party's fax number.
party	mobile	varchar	15	√		null	SOLA Extension: The party's contact mobile phone number.
party	phone	varchar	15	√		null	SOLA Extension: The party's main contact phone number. I.e. landline.
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.
communication_type	code	varchar	20				The code for the communication type.
gender_type	code	varchar	20				The code for the gender type.
group_party_type	code	varchar	20				LADM Definition: The code for the group party type.
id_type	code	varchar	20				The code for the id type.
party_role_type	code	varchar	20				The code for the party role type.
party_type	code	varchar	20				LADM Definition: The code for the party type.
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_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	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.
group_party	type_code	varchar	20				LADM Definition: The type of the group party. E.g. family, tribe, association, etc.
party	type_code	varchar	20				LADM Definition: The type of the party. E.g. naturalPerson, nonNaturalPerson, etc.
party_role	type_code	varchar	20				SOLA Extension: The type of role the party holds
party	address_id	varchar	40	√		null	SOLA Extension: Identifier for the contact address of the party.
party_member	group_id	varchar	40				LADM Definition: Identifier of the group party
group_party	id	varchar	40				LADM Definition: Identifier for the group party.
party	id	varchar	40				LADM Definition: Identifier for the party.
party_member	party_id	varchar	40				LADM Definition: Identifier for the party.
party_role	party_id	varchar	40				LADM Definition: Identifier for the party.
source_describes_party	party_id	varchar	40
group_party	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the group_party_historic table
party	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the party_historic table
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_role	rowidentifier	varchar	40			uuid_generate_v1()	SOLA Extension: Identifies the all change records for the row in the party_role_historic table
source_describes_party	rowidentifier	varchar	40			uuid_generate_v1()
source_describes_party	source_id	varchar	40
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.
group_party	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party_member	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
party_role	change_user	varchar	50	√		null	SOLA Extension: The user id of the last person to modify the row.
source_describes_party	change_user	varchar	50	√		null
party	email	varchar	50	√		null	SOLA Extension: The party's contact email address.
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	last_name	varchar	50	√		null	SOLA Extension: The last name for the party or blank for groups and organisations.
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	name	varchar	255	√		null	LADM Definition: The first name(s) for the party or the group or organisation name.
communication_type	display_value	varchar	500				Displayed value of the communication type.
gender_type	display_value	varchar	500				Displayed value of the gender type.
group_party_type	display_value	varchar	500				LADM Definition: Displayed value of the group party type.
id_type	display_value	varchar	500				Displayed value of the id type.
party_role_type	display_value	varchar	500				Displayed value of the party role type.
party_type	display_value	varchar	500				LADM Definition: Displayed value of the party type.
communication_type	description	varchar	1000	√		null	Description of the communication type.
gender_type	description	varchar	1000	√		null	Description of the gender type.
group_party_type	description	varchar	1000	√		null	LADM Definition: Description of the group party type.
id_type	description	varchar	1000	√		null	Description of the id type.
party_role_type	description	varchar	1000	√		null	Description of the party role type.
party_type	description	varchar	1000	√		null	LADM Definition: Description of the party type.