Data Request

Your request will be sent to Advancement Services. It is our commitment to Lewis & Clark College that your request is completed on time and you are completely satisfied with the results. As all requests are important, they will be processed in the order received. It is necessary for you to anticipate a five business-day turnaround time.

* - Required Field

Submitted By*

E-mail Address*

Extension*

Requested By

Department*

Department (Other)

Request Details*

Request (Other)

Due Date*

Run Date
(What's the earliest date you'd like to receive your request?)

List/Report Format

Request Name

Purpose of Request*
(How will this list/report be used?)

Selection Criteria*

Exclusions:

Deceased
No Contact
No Mail Solicit
No Phone Solicit
Chronicle Only
Advocate Only
Law Only
Foreign Address
Lost Address
Prospects Current Gifts
Current Pledges
Current WCs
Phone Refusals
No E-mail Solicitation
E-mail Contact ONLY
No E-mail Contact
No E-mail Events
E-mail Reunion ONLY

Additional Exclusions

Output Fields:

Output Format*

Standard Ouputs:

Mailing
Solicitation
Phonathon Current Year Giving Analysis
Three Year Giving Analysis

Demographics

ID Spouse ID

Link Spouse
Full Name
Last Name
First Name
Middle Name
Nickname (First)
Maiden Name
Class Year Spouse Full Name
Spouse Last Name
Spouse First Name
Spouse Middle Name
Spouse Nick Name
Spouse Maiden Name
Spouse Class Year

Pref. Address
Home Address
Bus. Address
City
ST
ZIP
Country
Chapter Code Home Phone
Business Phone
Preferred Phone
Preferred Phone Type
Employer Name
Business Title
Mail Rules

Source(s)
Moves Manager
Prospect Status
Affiliations
LC Degrees
LC Majors
ALL Majors
Athletics
Overseas Codes
Spouse Source(s)
Spouse Moves Manager
Spouse Prospect Status
Spouse Affiliations
Spouse LC Degrees
Spouse LC Majors

Giving

CrYr Amount(s)
YR1 Amount
YR2 Amount
YR3 Amount
YR4 Amount
YR5 Amount CrYr TOTAL Amount
Last Gift
Lifetime Giving
Hard Credit ONLY
Soft Credit ONLY
Pledge Balance

Last Solicitation Response Code/Date/Campaign

Area(s) of Giving
(select more than one by holding down the Ctrl Key in Windows or the apple key in MacOS)

Donor Purposes
(select more than one by holding down the Ctrl Key in Windows or the apple key in MacOS)

Additional Output

Sort Order:

Order 1

Other 1

Order 2

Other 2

Order 3

Other 3

Order 4

Other 4

Comments

BEFORE YOU SUBMIT...
Be sure to check your request. A copy of the request will be sent to the e-mail address entered at the beginning of the request.

Want to try?

Go to the Query Builder help page and see if you can find what you're looking for!

Query Builder Help

REQUEST TIPS

Request Details

E-mail addresses are only provided to the Alumni and Parent Programs, and Annual Giving liaisons. For more information please contact Stephen LeBoutillier.

Requested By

Who originally requested the report (if other than yourself)?

Request Name

The name you provide will be what shows up in the tracking system for identification purposes.

Selection Criteria

Please be as specific as possible to avoid any unwanted data.

Exclusions

Check all boxes for groups you do not want included in your request. Deceased and No Contact are always checked to reduce errors. If you do want these groups included in your request, please uncheck the boxes.

Sort Order

Remember: If you are requesting a list in Excel format, you will be able to sort by any of the output fields that you selected.

Gray204

Output Field Help

What you select will appear on your request.

Full Name

Prefix First MI. Last Suffix

Preferred Address

Will only return one address, can not be used in conjunction with home or business address.

Current Year Amount(s)

Returns individual gifts given to the College in the current fiscal year.

Current Year TOTAL Amount

Returns the total of all gifts given to selected areas of giving (listed below).

Last Gift

Will list Amount, Date and Fund of last gift to the College in three seperate columns.