Description
AA_ADVANCEMENT_RATING
| Source composite view of all internal and external advancement ratings associated with a prospect person or organization. Contains one row per rating per entity. | | |
AA_ANNUAL_GIVING
| Source composite view contains summary detail for all giving per fiscal year for persons and organizations. | | |
AA_CAMPAIGN
|
AA_CAMPAIGN_COMMENT
|
AA_CAMPAIGN_DESIGNATION
|
AA_CAMPAIGN_EXPENSE
|
AA_CAMPAIGN_FUNDRAISER
| Contains detail information for each solicitor assigned to the campaign by solicitation type and or by solicitor organization or by neither.One row per campaign per solicitor type per solicitor organization per solicitor uid. | | |
AA_CAMPAIGN_GIVING_HISTORY
| Source composite view contains summary giving detail for persons and organizations on a per campaign, per fiscal year basis. | | |
AA_CAMPAIGN_MAIL
|
AA_CAMPAIGN_SOLICITATION
|
AA_CONSTITUENT
| Source composite view contains biographic and demographic information for all persons, including summary detail on total to-date giving and institutional involvment. | | |
AA_CONSTITUENT_CONTACT
| Source view contains all contacts with a person or organization related to a project or interest area. Contact information may correspond to a prospect plan or result from an unplanned contact. | | |
AA_CONSTITUENT_PLAN
| Source composite view contains all scheduled or unplanned moves associated with a prospect plan for a person or organization. | | |
AA_CONSTITUENT_STAFF_ASSIGN
| Source composite view of all staff assignements associated with a prospect person or organization. Contains one row per assignment per entity. | | |
AA_CON_CONF_COMMENT_SUBJ
| Contains subject tag indexing for prospect confidential comments. This is to be used with PROSPECT_CONFIDENTIAL_COMMENT to aid in filtering comments by keyword.One occurrence per entity uid per comment group sequence number per staff iden per comment subject. | | |
AA_CON_ENTITY_CONF_COMMENT
| Contains confidential comments for constituent entities.One occurrence per entity uid per comment group sequence number per staff iden. | | |
AA_DEGREE
| Source composite view contains information on all degrees received by a person from any institution as applicable. | | |
AA_DESIGNATION
| Source composite view provides reporting from a designation perspective as a whole. This contains designation information, total pledges, pledge payments and gifts with matching information and various counts for the designation.One occurrence per designation. | | |
AA_DESIGNATION_ADJUSTMENT
| Source composite view provides reporting on designation adjustments.One occurrence per designation per adjustment sequence. | | |
AA_DESIGNATION_ATTRIBUTE
| Source composite view provides reporting on designation attributes.One occurrence per designation per attribute. | | |
AA_DESIGNATION_CLASS_YEAR
| Source composite view provides reporting on class years associated with a designation.One occurrence per designation per class year. | | |
AA_DESIGNATION_COMMENT
| Source composite view provides reporting on comments associated with a designation.One occurrence per designation per comment group sequence number per staff iden. | | |
AA_DESIGNATION_COMMENT_SUBJ
| Source composite view provides reporting on comment tags associated with a designation comment.One occurrence per designation per comment group sequence number per staff iden per comment tag. | | |
AA_DESIGNATION_FINAID_FUND
| Source composite view provides reporting on financial aid funds associated with a designation.One occurrence per designation per financial aid fund. | | |
AA_DESIGNATION_GIVING_HISTORY
| Source composite view contains summary giving information by person or organization for each fund or designation on a per fiscal year basis. | | |
AA_DESIGNATION_ID
| Source composite view contains information about contacts, report recipients, and other individuals or organizations associated to a designation.One row per designation per designation id. | | |
AA_DONOR_CATEGORY
| Source composite view of all donor categories associated with a person or organization. Donor categories correspond to the standardized voluntary support of education reporting categories. | | |
AA_EXCLUSION
| Source composite view of all actions or activities from which a person or organization should be excluded including mailings, phone contact or solicitations. | | |
AA_FUNDING_INTEREST
| Source composite view of each funding project or area of interest to which a prospect person or organization has been associated for potential solicitation. Data includes current prospect status, target ask amount and date, method of donation and free form text. | | |
AA_GIFT
| Source composite view contains information on all gifts or payments made by a person or organization including campaign, designation, associated pledge details, matching gift information, preferred class, solicitation and recognition details. | | |
AA_GIFT_ASSOCIATED_ENTITY
| The source composite view contains all entities and related information associated with a gift or payment. | | |
AA_GIFT_AUXILIARY
| Source composite view contains details related to any quid pro quo benefits or permiums associated with an individual gift made by a person or organization. | | |
AA_GIFT_MATCHING
| Source composite view contains employer matching gift details for each eligible gift made by a person. | | |
AA_GIFT_MEMO
| Source composite view contains information for each memo or soft credit assignment made in association with an individual gift or pledge payment. | | |
AA_GIFT_MULTIPLE
| Source composite view contains information for each multiple or hard credit assignment made in association with an individual gift or pledge payment. | | |
AA_GIFT_SOCIETY
| Source composite view contains information on each gift society to which a person or organization is affiliated on a per year basis. | | |
AA_MEMBERSHIP
| Source composite view contains information on each membership program to which a person or organization is affiliated on a per interest basis. | | |
AA_MEMBERSHIP_DUES
| Composite view contains information on each dues payment for a membership program to which a person or organization is affiliated. | | |
AA_MEMBERSHIP_INTEREST
| Composite view contains information on each membership program to which a person or organization is affiliated on a per interest basis per transaction adjustment. | | |
AA_ORGANIZATIONAL_CONSTITUENT
| Source composite view contains biographic and demographic information for all organizations, including donor categories, matching gift rules, institutional affiliations and summary detail on giving history. | | |
AA_ORGANIZATION_CONTACT
| One row per entity per contact sequence number. | | |
AA_ORGANIZATION_FUNDING_AREA
| Contains areas of interests fundable by an organization.One row per organization per funding area. | | |
AA_PLEDGE
| Source composite view contains information on all pledges made by a person or organization including campaign, designations, payment methods, amounts paid and solicitation details. | | |
AA_PLEDGE_ASSOCIATED_ENTITY
| List of all entities and related information associated with a pledge or payment.One row per entity per pledge per associated entity. | | |
AA_PLEDGE_AUXILIARY
| Contains auxiliary information for individual pledges, including alternative recognition donor categories or class years, details related to any associated quid pro quo benefits/premiums or the face/market values of the gift.One row per entity, i.e., person or organization, per auxiliary pledge record. | | |
AA_PLEDGE_CONDITIONAL
| Contains information pertaining to conditional pledges.One row per pidm per pledge number per sequence number. | | |
AA_PLEDGE_INSTALLMENT
| Source composite view contains details on each scheduled payment for any pledge set up on an installment plan basis for a person or organization. | | |
AA_PLEDGE_MATCHING
| Source composite view contains details and tracking information on employer matching contributions for each eligible pledge made by a person. | | |
AA_PROJECT_INTEREST
| Contains an unlimited number of project or interest areas that a prospect may be interested in supporting.One row per entity per project. | | |
AA_PROSPECT_CONF_COMMENT
| Source composite view provides reporting on confidential comments associated with a prospect.One occurrence per prospect per comment group sequence number per staff iden. | | |
AA_PROSPECT_CONF_COMMENT_SUBJ
| Source composite view provides reporting on confidential comment tags associated with a prospect comment.One occurrence per prospect per comment group sequence number per staff iden per comment tag. | | |
AA_PROSPECT_CONTACT_EXPENSE
| Contains a list of all expenses related to the contact for this prospect for the responsible staff member assigned.Multiple rows per entity per contact reference item number, per expense type. | | |
AA_PROSPECT_INFO
| Source composite view contains general information on each prospect person or organization including source, status, target ask amount and ask date and primary staff assignments. | | |
AA_PROSPECT_MOVES_MANAGEMENT
| Contains details related to each scheduled move and each contact or follow up action associated with a prospect plan for a prospect.Multiple rows per entity per project. | | |
AA_PROSPECT_PROPOSAL
| Source composite view contains information on all proposals associated with a prospect person or organization. | | |
AA_PROSPECT_PROPOSAL_MASTER
| Contains detail information for each proposal associated with a prospect on a per proposal project basis.One row per entity per proposal per proposal project. | | |
AA_PROSPECT_PROPOSAL_PROJECT
| Contains detail information for each proposal associated with a prospect on a per proposal project basis.One row per entity per proposal per proposal project. | | |
AA_PROSPECT_PROPOSAL_RESULT
|
AA_PROSPECT_STAFF_ASSIGNMENT
| Contains a listing of all staff assigned to a prospect. This may be through direct staff assignment, a proposal assignment, or a prospect management contact.One row per entity per staff type per staff identifier or staff UID. | | |
AA_SOLICITOR
| Source composite view contains details related to any solicitation efforts associated to a gift or pledge. | | |
AA_SOLICITOR_ASSIGNMENT
| Source composite view provides reporting on assigned contacts to solicitor organizations and or solicitors. This includes information about constituents assigned to either a campaign, type of solicitation, solicitor organization and or solicitor with ask amounts and ask dates.One occurrence per campaign per solicitation_type per solicitor_organization per solicitor_uid per assignment_sequence_number per solicitation_year. | | |
AA_SOLICITOR_ASSIGNMENT_RESULT
| Source composite view provides reporting on results of an assigned contact to solicitor organizations and or solicitors. This contains information about results of an assigned contacts to either a campaign, type of solicitation, solicitor organization and or solicitor with the type of contact, results, date of solicitation, gift and pledge number.One occurrence per campaign per solicitation_type per solicitor_organization per solicitation_year per solicitor_uid per contact_sequence_number per sequence_number. | | |
AA_SOLICITOR_ORGANIZATION
| Contains detail information for each solicitor organization, who the contact is, participation goal, dollar goal, and anticipated donor count.One row per solicitor organization. | | |
AA_SOLICITOR_ORG_COMMENT
| Contains comments for a solicitor organization.One occurrence per solicitor per sequence number. | | |
AA_SOLICITOR_ORG_FUNDRAISER
| Contains detail information for each solicitor assigned to the solictor organization.One row per solicitor organization per solicitor. | | |
AA_SOL_ORG_FUNDRAISER_GOAL
| Contains detail information for each solicitor within an organization, who the contact is, participation goal, dollar goal, and anticipated donor count.One row per solicitor organization per solicitor uid per year. | | |
AA_SOL_ORG_GOAL
| Contains detail information for each solicitor organization, who the contact is, participation goal, dollar goal, and anticipated donor count.One row per solicitor organization per year. | | |
AA_SPECIAL_ACTIVITY
| Source composite view contains information on any special activities in which a person or organization has participated. | | |
AA_SPECIAL_ACTIVITY_YEAR
| Special advancement activity year composite view will be repeating data and store all of the years recorded for a person's participation in an activity. | | |
AA_SPECIAL_PURPOSE_GROUP
| Source composite view contains information related to any special purpose groups to which a person or organization is affiliated. | | |
AA_VALIDATION
| Source composite view contains a number of the source systems' validation table records. This view was meant to be used with reporting tools to create list of values as well as for cleansing purposes in the Enterprise Data Warehouse. | | |
AA_YEAR_TYPE_DEFINITION
| Contains the year types and codes. | | |