sola.application contains 130 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
application	action_code	varchar	20			'lodge'::character varying	The last action that happended to the application. E.g. lodged, assigned, validated, approved, etc.
service	action_code	varchar	20			'lodge'::character varying	Service action code. Indicates the last action to occur on the service. E.g. lodge, start, complete, cancel, etc.
application	action_notes	varchar	255	√		null	Optional description of the action.
service	action_notes	varchar	255	√		null	Provides extra detail related to the last action to occur on the service. Not Used.
application	agent_id	varchar	40	√		null	Identifier of the party (individual or organization) that is requesting information or changes to the land registry and/or cadastre information recorded in SOLA. This could be a lawyer or surveyor under instruction from the property owner, the property owner themselves or a third party with a vested interest in a particular property.
application_property	application_id	varchar	40				Identifier for the application the record is associated to.
application_spatial_unit	application_id	varchar	40				Identifier for the application the record is associated to.
application_uses_source	application_id	varchar	40				Identifier for the application the record is associated to.
service	application_id	varchar	40	√		null	Identifier for the application the service is associated with.
application_property	area	numeric	20,2			0	The area of the property. This value should be square meters and converted if required for display to the user. e.g. Converted on display into and imperial acres, roods and perches value.
request_type	area_base_fee	numeric	20,2			0	The fee component charged for each square metre of the property or 0 if no area fee applies.
service	area_fee	numeric	20,2			0	The area fee charged for the service. Calculated from the sum of all areas listed for properties on the application multiplied by the request_type.area_base_fee.
application	assigned_datetime	timestamp	29,6	√		null	The date and time the application was last assigned to a user.
application	assignee_id	varchar	40	√		null	The identifier of the user assigned to the application. If this value is null, then the application is unassigned.
application_property	ba_unit_id	varchar	40	√		null	Reference to a record in the BA Unit table that matches the property details provided for the application.
systematic_registration_certificates	ba_unit_id	varchar	40	√		null
request_type	base_fee	numeric	20,2			0	The fixed fee component charged for the service or 0 if there is no fixed fee.
service	base_fee	numeric	20,2			0	The fixed fee charged for the service. Obtained from the base_fee value in request_type.
cancel_notification	baunit_name	varchar	40	√		null
cancel_notification	cancel_service_id	varchar	40	√		null
application	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).
application_property	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).
application_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).
application_uses_source	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).
service	change_action	bpchar	1			'i'::bpchar
application	change_time	timestamp	29,6			now()	The date and time the row was last modified.
application_property	change_time	timestamp	29,6			now()	The date and time the row was last modified.
application_spatial_unit	change_time	timestamp	29,6			now()	The date and time the row was last modified.
application_uses_source	change_time	timestamp	29,6			now()	The date and time the row was last modified.
service	change_time	timestamp	29,6			now()
application	change_user	varchar	50	√		null	The user id of the last person to modify the row.
application_property	change_user	varchar	50	√		null	The user id of the last person to modify the row.
application_spatial_unit	change_user	varchar	50	√		null	The user id of the last person to modify the row.
application_uses_source	change_user	varchar	50	√		null	The user id of the last person to modify the row.
service	change_user	varchar	50	√		null
application	classification_code	varchar	20	√		null	FROM SOLA State Land Extension: The security classification for this Application/Job. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
application_action_type	code	varchar	20				The code for the application action type.
application_status_type	code	varchar	20				The code for the application status type.
request_category_type	code	varchar	20				The code for the request category type.
request_type	code	varchar	20				The code for the request type.
service_action_type	code	varchar	20				The code for the service action type.
service_status_type	code	varchar	20				The code for the service status type.
type_action	code	varchar	20				The code for the request type action.
application	contact_person_id	varchar	40				The person to contact in regard to the application. This person is considered the applicant.
application_action_type	description	varchar	1000	√		null	Description of the application action type.
application_status_type	description	varchar	1000	√		null	Description of the application status type.
request_category_type	description	varchar	1000	√		null	Description of the request category type.
request_type	description	varchar	1000	√		null	Description of the request type.
service_action_type	description	varchar	1000	√		null	Description of the service action type.
service_status_type	description	varchar	1000	√		null	Description of the service status type.
type_action	description	varchar	1000	√		null	Description of the request type action.
request_type	display_group_name	varchar	500	√		null	SOLA Extension. Used to group request types that have a similar purpose (e.g. Mortgage types or Systematic Registration types). Used by the Add Service dialog to group the request types for display.
application_action_type	display_value	varchar	500				Displayed value of the application action type.
application_status_type	display_value	varchar	500				Displayed value of the application status type.
request_category_type	display_value	varchar	500				Displayed value of the request category type.
request_type	display_value	varchar	500				Displayed value of the request type.
service_action_type	display_value	varchar	500				Displayed value of the service action type.
service_status_type	display_value	varchar	500				Displayed value of the service status type.
type_action	display_value	varchar	500				Displayed value of the request type action.
application	expected_completion_date	date	13			now()	The date the application should be completed by. This value is determined from the maximum service expected completion date associated with the application.
service	expected_completion_date	date	13				Date when the service is expected to be completed by. Calculated using the service lodging_datetime and the nr_days_to_complete for the service request type.
application	fee_paid	bool	1			false	Flag to indicate a sufficient amount (or all) of the fee has been paid. Once set, the application can be assigned and worked on.
cancel_notification	grouppartyid	varchar	40	√		null
cancel_notification	grouppartylastname	varchar	50	√		null
cancel_notification	grouppartyname	varchar	255	√		null
application	id	varchar	40				Identifier for the application.
application_property	id	varchar	40				Identifier for the application property.
service	id	varchar	40				Identifier for the service.
application_property	land_use_code	varchar	20	√		null	Code to indicate the general purpose of the property. E.g. Commerical, Residential, Industrial, etc.
application	location	geometry	2147483647	√		null	The approximate geographic location of the application. The user may indicate more than one point if the application affects a large number of parcels.
application	lodging_datetime	timestamp	29,6			now()	The lodging date and time of the application. This date identifies when the application is officially accepted by the land administration agency.
service	lodging_datetime	timestamp	29,6			now()	The date the service was lodged on the application. Typically will match the application lodgement_datetime, but may vary if a service is added after the application is lodged.
application_property	name_firstpart	varchar	20				The first part of the name or reference assigned by the land administration agency to identify the property.
systematic_registration_certificates	name_firstpart	varchar	20	√		null
application_property	name_lastpart	varchar	20				The remaining part of the name or reference assigned by the land administration agency to identify the property.
systematic_registration_certificates	name_lastpart	varchar	50	√		null
request_type	notation_template	varchar	1000	√		null	Template text to use when completing the details of RRR records created by the service.
application	nr	varchar	15				The application number displayed to end users. Generated by the generate-application-nr business rule when the application record is initially saved.
systematic_registration_certificates	nr	varchar	15	√		null
request_type	nr_days_to_complete	int4	10			0	The number of days it should take for the service to be completed. Can be used to manage and monitor transaction throughput targets for the land administration agency.
request_type	nr_properties_required	int4	10			0	The minimum number of properties that must be referenced by the application before services of this type can be processed.
cancel_notification	party_id	varchar	40	√		null
cancel_notification	partylastname	varchar	50	√		null
cancel_notification	partyname	varchar	255	√		null
application	receipt_reference	varchar	100	√		null	The number of the receipt issued as proof of payment. If more than one receipt is issued in the case of part payments, the receipts numbers can be listed in this feild separated by commas.
application	redact_code	varchar	20	√		null	FROM SOLA State Land Extension: The redact classification for this Application/Job. 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.
request_type	request_category_code	varchar	20				The code for the request category type.
request_type_requires_source_type	request_type_code	varchar	20				The request type that requries the source to be present on the application.
service	request_type_code	varchar	20				The request type identifying the purpose of the service.
application	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the application_historic table
application_property	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the application_property_historic table
application_spatial_unit	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the application_spatial_unit_historic table
application_uses_source	rowidentifier	varchar	40			uuid_generate_v1()	Identifies the all change records for the row in the application_spatial_unit_historic table
service	rowidentifier	varchar	40			uuid_generate_v1()
application	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
application_property	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
application_spatial_unit	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
application_uses_source	rowversion	int4	10			0	Sequential value indicating the number of times this row has been modified.
service	rowversion	int4	10			0
request_type	rrr_type_code	varchar	20	√		null	Used by the Property Details screen to identify the type of RRR affected by the service. If null, the Property Details screen will allow the user to process all RRR types.
cancel_notification	service_id	varchar	40	√		null
service	service_order	int4	10			0	The relative order of the service within the application. Can be used to imply a workflow sequence for application related tasks.
request_type	service_panel_code	varchar	20	√		null	SOLA Extension. Used to identify the SOLA panel class to display to the user when they start the service
application	services_fee	numeric	20,2			0	The sum of all service fees.
application_uses_source	source_id	varchar	40				Identifier of the source associated to the application.
request_type_requires_source_type	source_type_code	varchar	20				The source type required by the request type.
application_spatial_unit	spatial_unit_id	varchar	40				Identifier of the parcel (a.k.a Cadastre Objects or Spatial Units) associated to the application.
application_action_type	status	bpchar	1			't'::bpchar	Status of the application action type
application_status_type	status	bpchar	1			't'::bpchar	Status of the application status type
request_category_type	status	bpchar	1			't'::bpchar	Status of the request category type
request_type	status	bpchar	1			't'::bpchar	Status of the request type
service_action_type	status	bpchar	1			't'::bpchar	Status of the service action type
service_status_type	status	bpchar	1			't'::bpchar	Status of the service status type
type_action	status	bpchar	1			't'::bpchar	Status of the request type action.
application	status_code	varchar	20			'lodged'::character varying	The status of the application.
service	status_code	varchar	20			'lodged'::character varying	Service status code.
application_action_type	status_to_set	varchar	20	√		null
service_action_type	status_to_set	varchar	20	√		null	The status to set on the service when the service action is applied.
cancel_notification	target_party_id	varchar	40	√		null
cancel_notification	targetpartylastname	varchar	50	√		null
cancel_notification	targetpartyname	varchar	255	√		null
application	tax	numeric	20,2			0	The tax applicable based on the services fee.
application	total_amount_paid	numeric	20,2			0	The amount paid by the applicant. Usually will be the full amount (total_fee), but can be a partial payment if the land administration agency accepts partial payments.
application	total_fee	numeric	20,2			0	The sum of the services_fee and tax.
application_property	total_value	numeric	20,2			0	The land or property value (may vary from jurisdiction to jurisdiction) on which a proportionate service fee can be calculated.
request_type	type_action_code	varchar	20	√		null	Used by teh Property Details screen to identify what action applies to the RRR affected by the service. One of new, vary or cancel. If null, the Property Details screen will allow the user to create or vary RRRs matching the rrr_type_code.
request_type	value_base_fee	numeric	20,2			0	The fee component charged against the value of the property or 0 if no value fee applies.
service	value_fee	numeric	20,2			0	The value fee charged for the service. Calculated from the sum of all values listed for properties on the application multiplied by the request_type.value_base_fee.
application_property	verified_exists	bool	1			false	Flag to indicate if the property details provided for the application match an existing property record in the BA Unit table.
application_property	verified_location	bool	1			false	Flag to indicate if the property details provided for the application reference an existing parcel record in the Cadastre Object table.