Salesforce

What is the Employee Giving Insights Explore Standard Data Dictionary?

« Go Back
Information
What is the Employee Giving Insights Explore Standard Data Dictionary?
What-is-the-Employee-Giving-Insights-Explore-Standard-Data-Dictionary
Details

The following Data Dictionary provides an overview of the most commonly used standard data fields within the Insights Employee Giving Explore. By understanding this information, users can effectively navigate and analyze their program's data within Insights.

See below to learn about the popular standard data fields that can be leveraged through the Insights Employee Giving Explore.

Employee Giving Explore Standard Data Dictionary

Field Label

Field Description

Explore Sub-Folder

EG Request IDThe unique CyberGrants identification number for a particular eg request. Each gift or hour record in CyberGrants will have a distinct EG request IDEmployee Giving
Request IDThe unique CyberGrants identification number for a particular payment request. Each request in CyberGrants will have a distinct request IDEmployee Giving
EG Fiscal YearThe fiscal Year in which the employee gift is applicableEmployee Giving
Create DateThe date the gift or hours were entered into the CyberGrants system by the donorEmployee Giving
Start DateThe date the gift was given or the hours were logged by the donor to the organizationEmployee Giving
End DateThe date the gift was given or the hours were logged by the donor to the organizationEmployee Giving
Submit DateThe date the gift or hours were submitted into the CyberGrants system by the donorEmployee Giving
Confirmation DateThe date the organization confirmed the gift or hoursEmployee Giving
Final Approval DateThe date in which the record has completed the final step in the approval workflowEmployee Giving
DescriptionThe description of the gift transactionEmployee Giving
DesignationThe designation of the gift transaction (i.e. in honor of, etc.)Employee Giving
DispositionThe current status of the gift recordEmployee Giving
Is Recurring?A flag that indicates if the gift is recurringEmployee Giving
Approval CommentsThe comments included by the approver during the approval stepEmployee Giving
Total Cash Gift AmountThe summed amount of all giftsEmployee Giving
Total Match AmountThe summed amount of all matching giftsEmployee Giving
Privacy PreferenceThe indicator for the donor’s privacy preference related to a specific gift transactionEmployee Giving
ProgramThe proposal type or program nameEmployee Giving
Average Gift AmountThe aggregated average amount for employee giftsMeasures
Average Match AmountThe aggregated average amount for company matchesMeasures
EG Request CountThe unique count of EG Request IDsMeasures
Median Gift AmountThe aggregated median amount for employee giftsMeasures
Median Match AmountThe aggregated median amount for company matchesMeasures
Gift & Match AmountThe sum of total employee gift amounts and total company match amountsMeasures
Gift AmountThe sum of all employee gift amountsMeasures
Match AmountThe sum of all company match amountsMeasures

 

What else do you need help with?

Not what you're looking for? Navigate to the Insights Standard Data Dictionary Overview


Powered by