SchemaSpy Analysis of sola.application - ColumnsExtension to the LADM used by SOLA to implement Case Management functionality. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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.