SchemaSpy Analysis of sola_cs.applicationExtension to the LADM used by SOLA to implement Case Management functionality. Generated by
SchemaSpy
Generated by SchemaSpy on ?? ??? 16 22:00 ALMT 2015
Database Type: PostgreSQL - 9.1.4 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
application 4 5 25 Applications capture details and manage requests received by the land administration agency to change, update or report on land registry and/or cadastre information. Applications have a lifecycle and transition into different states as the land administration agency processes the request that instigated the application. The primary role of an application is to implement case management functionality in SOLA.
Tags: FLOSS SOLA Extension, Change History
application_action_type 2 1 5 Code list of action types.
Tags: FLOSS SOLA Extension, Reference Table
application_property 3 15 Captures details of property associated to an application.
Tags: FLOSS SOLA Extension, Change History
application_spatial_unit 2 7 Captures details of parcels (a.k.a. Cadastre Objects or Spatial Units) associated to an application.
Tags: FLOSS SOLA Extension, Change History
application_status_type 2 4 Code list of application status types.
Tags: FLOSS SOLA Extension, Reference Table
application_uses_source 2 7 Links the application to the sources (a.k.a. documents) submitted with the application.
Tags: FLOSS SOLA Extension, Change History
cancel_notification 12
Function: get_concatenated_name 0 Returns a concatenated list of all cadastre objects associated to the BA Unit referenced by the application.
Function: get_work_summary 0 Returns a summary of the services processed for a specified reporting period. Used by the Lodgement Statistics Report.
Function: getlodgement 0 Not used. Replaced by get_work_summary.
Function: getlodgetiming 0 Not used. Replaced by get_work_summary.
request_category_type 1 4 Code list of request category types. Request category types group the request types into logical groupings such as request types for registration or cadastral changes.
Tags: FLOSS SOLA Extension, Reference Table
request_type 3 4 15 Code list of request types. Request types identify the different types of services provided by the land administration agency. SOLA includes a default set of request types that can be reconfigured to match those required by the land administration agency.
Tags: FLOSS SOLA Extension, Reference Table
request_type_requires_source_type 2 2 Identifies the types of sources (a.k.a. documents) that must be provided before a service can be processed by the land administration agency.
Tags: FLOSS SOLA Extension
Sequence: application_nr_seq 0 Sequence number used as the basis for the Application nr field. This sequence is used by the generate-application-nr business rule.
service 1 4 17 Used to control the type of change an application can make to the land registry and/or cadastre information recorded in SOLA. Services broadly identify the actions the land administration agency will undertake for the application. Every application lodged in SOLA must include at least one service. SOLA includes a default set of request types that can be reconfigured to match those services required by the land administration agency.
Tags: FLOSS SOLA Extension, Change History
service_action_type 2 1 5 Code list of service action types. Service actions identify the actions user can perform against services. E.g. lodge, start, revert, cancel, complete.
Tags: FLOSS SOLA Extension, Reference Table
service_status_type 2 4 Code list of service status types.
Tags: FLOSS SOLA Extension, Reference Table
systematic_registration_certificates 4 Used by systematic registration to identify parcels that require a certificate to be generated.
type_action 1 4 Code list of request type actions. Identifies what actions the Property Details screen should support for RRRs when processing a service. One of new, vary or cancel.
Tags: FLOSS SOLA Extension, Reference Table
         
18 Tables     114  
2 Views     16