Previous Topic

Next Topic

Book Contents

Book Index

People report pipeline

This is by far the biggest pipeline, containing everything you'd ever want to know about a person.

Field

Description or sample

Match similarity

(not used here)

Name

Cornett, William S. III

Name (natural)

William S. Cornett III

Name (natural) without middle initial

William Cornett

Name prefix/title

Mr.

Name with prefix/title

Mr. William S. Cornett III

Name first

William

Name middle

S

Name middle initial

S

Name last/family

Cornett

Name last/family initial

C

Name first and last/family

Mr. William Cornett

Name suffix

III

Mailing title

Mr. Cornett

Mailing all names

The Mailing title field if present, otherwise the Name with prefix/title value.

Mailing dear

Bill

Mailing count

(not used here)

Company

Bespoke Software, Inc.

Alternate name

Boss, Big

Alternate name (natural)

Big Boss

Alternate first name

Big

Alternate middle name

 

Alternate family/last name

Boss

Alternate name suffix

 

He/She/They

He

he/she/they (lower case)

he

Sounds like (phonetic) name

KOR-net, WILL-yum

Sounds like (phonetic) name (reversed)

WILL-yum KOR-net

Team

Y

Team name

Bespoke's Big Volunteering Team

Team member count

8

Team description

 

Gender

Male

Gender (short)

M

Person type

Volunteer

Active date

04/12/2008

Active status

Leave of absence

All person types

Volunteer,Staff

Additional types

Staff

All supervisors

VSys goes and finds all supervisors associated with this person from assignments, job associations and hours.

Volunteer type

General

Group

Daily volunteers

Additional groups

Troublesome volunteers,Donors

All groups

Daily volunteers,Troublesome volunteers,Donors

Volunteer source

Billboard

Job preferences

Outdoor work,Computer work

Language

English

Communication language

English

Additional languages

Bad English

Availability

Jan-June 2009 12pm-6pm, Monday,Tuesday,Thursday

Skills

Computer,Cats,Wrangling children

Special requests/needs

Cattle prod

Contact flags

Do not e-mail,Do not spindle

DOB

03/01/1970 (not my real DOB!)

DOB year

1970

DOB month

03

DOB month name

March

Birthday

03/01

Age

40

Age at nearest birthday

Used primarily for birthday greetings, which are often sent or seen before the recipient's actual birthday. This is their age at the birthday the shortest distance from today's date.

Deceased

N

Deceased date

 

Inactive

N

Inactive date

 

Inactive reason

 

Inactive followup date

 

Years since first active

12

Re-active date

08/01/2008

Placeholder

N

Archived

N

Archived date

 

Archived reason

 

Archived comment

 

Banned

N

Banned comments

 

Banned reason

 

Banned expiration

 

Wheelchair/requires handicap access

N

Medical alert

Allergic to hard work.

Diet alert

No vegetables.

Emergency contact

Only here for backwards compatibility, use the person's "Emergency contact" address instead for this purpose.

Nationality

USA

Place of birth

Bronx, NY

Passport number

123456789

Passport expiration date

02/15/2010

Photo ID verified

The last date their ID was verified.

Code

16-digit internal ID code for this person.

Code short

The "Basic" or 5-digit ID code.

Security user ID

wcornett

Security disabled

N

Security expiration

 

Person number

 

Import reference

ID from previous database, e.g. a VolunteerWorks number.

Last changed

08/13/2009

Date created

02/01/2001

Date started

02/18/2001

Status

Active

Transitions

Details all transitions between active, inactive, banned, archived, deceased, and any imported from VolunteerWorks.

Upcoming recurring assignments

Describes the rules for all active recurring assignments.

Image

 

Web user ID

wcornett@bespoke.com

Web disabled

N

Web needs activation

N

Web description

Active

Link to current web application

(not used here)

Kiosk user ID

1234

Kiosk disabled

N

Years since first active

Number of years between the current date and the person's Date started.

See Also

Pipelines

Account records report pipelines

Account summaries report pipelines

Addresses report pipelines (various)

Assignments report pipelines

Audit trace records report pipeline

Availability report pipeline

Award report pipelines

Certifications report pipelines

Combined assignments and job associations report pipelines

Comments report pipeline

Credentials report pipeline

Custom application forms report pipeline

Custom fields report pipelines

Hours details report pipelines

Hours summary report pipeline

Incoming messages report pipeline

Interviews report pipelines

Job associations report pipelines

Job definitions report pipeline

Letters report pipeline

Mandates report pipelines

Memberships report pipelines

Phone numbers report pipelines

Project data report pipeline

Recurring assignments report pipeline

Relationship report pipeline

Relationships report pipeline

Report images report pipeline

Security rights report pipeline

Survey results report pipeline

System report pipeline

Trainings report pipelines

Transitions report pipeline