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 defn
contact
grant
help msg
main switchboard
outreach
party
payment
person
price set
product type
publication
stored selection
Server database:
help
load
load sequence
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
top of page
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.
top of page
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.
top of page
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.
top of page
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
top of page
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.
top of page
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:
- Which
parties
made donations in March 2004?
- Which
parties
receieved the April 2005 newsletter?
- Which
parties
were involved in the June 10
evening meeting?
-
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.
top of page
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.
top of page
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.
top of page
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.
top of page
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.
top of page
Publication
-
Publication edit
- Provides functions to edit publications and brief summaries of
individual issues of each publication.
top of page
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.
top of page
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.
top of page
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
top of page
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.
top of page
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.
top of page
Screen Images - Earlier Versions
Version 1
Version 2
Version 3
top of page