SelCtlDB

NW Data Centric home   home   [about]   downloads  

Current loctn: about > screen

Screen Images - Version 4

The links provided here display graphics images of the main user interface forms included in the database.

All screen images are provided as PNG files with file sizes less than 40Kb.

This implementation provides an abridged version of the full data model, as applied during implementation for the first client - a nonprofit land trust.

Client Database

Code Set Definitions

Code Set Definitions are sets of codes used to populate drop-down lists on forms, etc. A large number of these codes sets are avaialble for editing by the data administrator through these forms.

Some code definition forms in the database are not represented here. However, forms not represented here are very similar

Constant definition
Defines constants like organization name, etc.
Contact subject definition
Defines codes used to indicate the general subject of a communication contact.
Contact method definitionn
Defines codes used to indicate the communication method used during a contact
Deliverable type definition
Defines codes used to categorize grant deliverables
Ethnicity definition
Defines codes used to indicate the identified ethnicity of a person within the database
Focus area definition
Defines codes used to indicate overarching program areas of the organization that might be used to report or categorize volunteer actions, action team outreach efforts, personal areas of insterest for constituents
Fund definition
Defines codes used to indicate the destination of funds obtained from payments. Typical value might include c3, 2008 construction, c4 pac, etc
Group definition
Defines codes used to indicate a group in which a party may be a member. Groups can be very general and may include mailing lists, subscription recipients, commmitees, persons on waiting lists, formal memberships, etc
Group type definition
Defines codes used to indicate the overarching type of a group. Typically assumes values like subscription, membership, committee
Help message type definition
Defines codes used to indicate a category assigned to a help message stored in the database
Income category definition
Defines codes used to indicate the assigned income category of a product purchase. Might correspond closely to codes used in the organizational accounting system.
Language defn
Defines codes used to indicate languages a person is proficient with
Milestone definition
Defines codes used to indicate the codes used to indicate the type of milestone acheieved by a grant
Outreach method definition
Defines codes used to indicate the method of communication used for an outreach effort
Party category definition
Defines codes used to indicate categories assigned to a party
Party member role definition
Defines codes used to indicate the type of role played by a person within a party they are a member of.
Payment method definition
Defines codes used to indicate the method used to provide a payment. Several of these records are linked to database automation and should be changed only by a knowledgable person
Personal event type definition
Defines codes used to categorize a personal event stored into the database. Typical values might include marriage, birth in family, major illness, etc
Phone type definition
Defines codes used to categorize a phone number entered into the database. Typical values might include voice mobile, pager, fax, etc
Postal code definition
Defines codes used to inidicate postal code of location addresses entered into the database. Entry of a postal code defined in this list will typically cause an automatic entry of the related city and state
Product category definition
Defines codes used to categorize parties. In constrast to group membership, these classifications are not provided with a start/end date
Race definition
Defines codes used to indicate the racial heritage of a person entered in the database. Each person may have multiple codes established in cases where then identify themselves as multiracial
Region definition
Defines codes used to indicate the geographic region a location falls into. These codes would typically not duplicate a city, state or county code, which is provided in specialized fields in the database
Related person role definition
Defines codes used to categorize the relationship between two persons within the database. Typical values might include spouse, father, friend, etc.
Staff member definition
Defines codes used to indicate organization staff members who might be assigned roles such as primary party contact, organizational roles on an outreach, organizational roles in a contact, etc
Volunteer action definition
Defines codes used to indicate volunteer actions a person is willing to perform, or actions they have performed for the organization

Contacts

Contacts are communications between staff and others (phone call, email, letter, meeting, etc.) These communications are indidivudally targeted, whereas outreaches are typcially intended as bulk communications

Contact Edit (Party tab)
Contact Edit (Subjects tab)
Contact selection
Used to specify selection criteria for contact records to be edited or summarized using reports.
Contact selection display
Used to display records matching the selection criteria specified on the contact selection form. Also used to select reports used to summarize those records.

Grants

Grant edit (deliverable tab columnar view, subtab for milestones))
Grant edit (deliverable tab columnar view, subtab for related outreaches))
Grant edit (deliverable tab list view)
Grant edit (party tab)
Grant selection
Used to specify selection criteria for grant records to be edited or summarized using reports.
Grant selection display
Used to display records matching the selection criteria specified on the grant selection form. Also used to select reports used to summarize those records.

Help Message

Help messages may be stored and accessed within the database just like any other data. Typically, a help message would provide instructions for a task frequently performed using the datbase

Help message edit
Help message selection
Used to specify selection criteria for help message records to be edited or summarized using reports.
Help message selection display
Used to display records matching the selection criteria specified on the help message selection form. Also used to select reports used to summarize those records.

Main Switchboard

The Main Switchboard provides the user with entry to major database functions

Main switchboard (alternate data access tab)
Provides access to data editing forms without use of record selection forms. Typically, it is not wise to use this approach for general database use. But there are times when a skilled used can complete complex tasks more efficiently by this approach.
Main switchboard (admin tab)
Provides access to user-customizable code sets and other administrator-type functions
Main switchboard (general tab)
Used to access selection forms for typical editing and reporting uses of the database

Outreaches

An Outreach can represent any type of effort to inform or engage the public. These are typically more general or public communications than are contacts, which tend to be more private.

Outreach edit (deliverable tab)
Outreach edit (expense tab)
Outreach edit (focus tab)
Outreach edit (payment tab)
The payment tab displays a summary of payments that are linked specifically to the outreach
Outreach edit (payment schedule tab)
The payment tab displays a summary of payment schedules that are linked specifically to the outreach
Outreach edit (party tab)
Outreach edit (response tab)
Outreach edit (staff tab)
Outreach selection (grant tab)
Used to specify selection criteria for outreach records to be edited or summarized using reports.
Outreach selection (outreach tab)
Used to specify selection criteria for outreach records to be edited or summarized using reports.
Outreach selection (party tab)
Used to specify selection criteria for outreach records to be edited or summarized using reports.
Outreach selection display
Used to display records matching the selection criteria specified on the outreach selection form. Also used to select reports used to summarize those records.

Parties

A Party can be an individual, a family, an organization, a business, a foundation, or an agency, etc. Here are some questions that help present an understanding of the way the term party is used:

Party edit (category tab)
Party edit (contact tab)
Party edit (contact preference tab)
Party edit (email tab)
Party edit (focus tab)
Party edit (group member tab, columnar view)
Party edit (group member tab, list view)
Party edit (location tab, columnar view)
Party edit (location tab, list view)
Party edit (party member tab)
Displays persons associated with the current party record
Party edit (payment tab, columnar view))
Party edit (payment tab, list view)
Party edit (payment tab, columnar view))
Party edit (payment tab, list view)
Party edit (phone tab)
Best use if for entry of mobile phones that clearly do not represent a single location. Hard-wired phones might be be preferably entered under locations
Party selection (contact tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for contact criteria.
Party selection (email tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for email criteria.
Party selection (group member tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for group member criteria.
Party selection (location tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for location criteria.
Party selection (outreach tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for outreach criteria.
Party selection (party tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for party criteria.
Party selection (party members tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for party members criteria.
Party selection (payment tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for payment criteria.
Party selection (payment schedule tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for payment schedule criteria.
Party selection (team tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for team criteria.
Party selection (volunteer actions tab)
Used to specify selection criteria for party records to be edited or summarized using reports, tab for volunteer action criteria.
Party selection display
Used to display records matching the selection criteria specified on the party selection form. Also used to select reports used to summarize those records.

Payments

Payment edit
Payment selection (outreach tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for outreach criteria.
Payment selection (payment tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for payment criteria.
Payment selection (party tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for party criteria.
Payment selection (party aggregate payments tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for party aggregate payments criteria.
Payment selection (party group member tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for party group member criteria.
Payment selection (party location tab)
Used to specify selection criteria for payment records to be edited or summarized using reports, tab for party location criteria.
Payment selection display
Used to display records matching the selection criteria specified on the payment selection form. Also used to select reports used to summarize those records.

Persons

Person edit (ethnicity/language tab)
Person edit (party member tab)
Person edit (personal event tab)
Tracks important personal events, such as new births, deaths, retirement, major illness, divorces, marriages.
Person edit (race tab)
Person edit (related person tab)
Important personal relationships between persons
Person selection
Used to specify selection criteria for person records to be edited or summarized using reports.
Person selection display
Used to display records matching the selection criteria specified on the person selection form. Also used to select reports used to summarize those records.

Price Set

Price set edit
A price set is a set of product prices enacted as a set, and for a finite date range. Multiple price sets may be stored for historic purposes, effective dates for price sets should be set to avoid overlap. For any specified date, only one price set should be active.

Product Type

Product types define something the organzation provides in return for payments. The concept is applied rather broadly. For instance, a contribution is treated as a product, as are subscritpions to newsletters, types of memberships, clothing and other merchandise.

Product type edit
Product type selection
Used to specify selection criteria for product type records to be edited or summarized using reports
Product type selection display
Used to display records matching the selection criteria specified on the product type selection form. Also used to select reports used to summarize those records.

Publication

Publication edit
Provides functions to edit publications and brief summaries of individual issues of each publication.

Stored Selection Criteria

Stored record selection criteria represent a group of settings developed on a record selection form and stored for later recall

Stored record selection edit
Used to edit stored record selection criteria
Stored record selection search
Used to specify selection criteria for stored record selection records to be edited or recalled to the appropriate record selection form.

Team

Teams are assembled to carry out activities such as monitoring, etc. Unlike groups, a team can be linked to outreach actions. Roles played by each individual member within a team can also be specified.

Team edit (Members tab)
Team edit (outreach tab)
Team selection
Used to specify selection criteria for team records to be edited or summarized using reports
Team selection display
Used to display records matching the selection criteria specified on the team selection form. Also used to select reports used to summarize those records.

Server Database

Help Message

Load records define an attempt to process a set of tables in a set sequence, either to delete table contents, delete contents and reload from a 2d database, or to transfer data from a 2d database into the tables without deleting table contents first. Related records store important messages generated during the loading attempt.

Help message edit

Load

Load records define an attempt to process a set of tables in a set sequence, either to delete table contents, delete contents and reload from a 2d database, or to transfer data from a 2d database into the tables without deleting table contents first. Related records store important messages generated during the loading attempt.

Load edit (load event tab, columnar view)
Load edit (load event tab, list view)
Load edit (load sequence tab)
Load selection
Used to specify selection criteria for load records to be edited or summarized using reports
Load selection display
Used to display records matching the selection criteria specified on the load selection form. Also used to select reports used to summarize those records.

Load Sequence

Load records define an attempt to process a set of tables in a set sequence, either to delete table contents, delete contents and reload from a 2d database, or to transfer data from a 2d database into the tables without deleting table contents first. Related records store important messages generated during the loading attempt.

Load sequence edit
Load sequence selection
Used to specify selection criteria for load sequence records to be edited or summarized using reports
Load sequence selection display
Used to display records matching the selection criteria specified on the load sequence selection form. Also used to select reports used to summarize those records.

Screen Images - Earlier Versions