Salesforce

What is the Grant Request Insights Explore Standard Data Dictionary?

« Go Back
Information
What is the Grant Request Insights Explore Standard Data Dictionary?
What-is-the-Grant-Request-Insights-Explore-Standard-Data-Dictionary
Details

The following Data Dictionary provides an overview of the most commonly used standard data fields within the Insights Grant Request 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 Grant Request Explore.

Grant Request Explore Standard Data Dictionary

Field Label

Field Description

Explore Sub-Folder

Request IDThe unique CyberGrants identification number for a particular grant request. Each request in CyberGrants will have a distinct Request IDGrant Request
Final Approval DateThe date of final approval for the requestGrant Request
Create DateThe date a request was createdGrant Request
NP Submit DateThe date the Non-Profit submitted the requestGrant Request
NP Resubmit DateThe date the Non-Profit resubmitted the request.Grant Request
Funding PrincipleA single-select classification item used to identify the primary focus that the request is meant to addressGrant Request
DispositionThe current status of the particular request. When a grant is either canceled or rejected, the funds for any payments made against it are returned to the budget line for use in other requestsGrant Request
Has the Organization Reviewed?A flag that indicates if a request was reviewed by the organizationGrant Request
Is Request Source External?A flag that indicates whether or not the source of a request is externalGrant Request
Request Submitted ByThe name of the person who submitted the requestGrant Request
Request OwnerThe owner of the request recordGrant Request
Aggregated Approval CommentsAn aggregated list of comments left across all steps of the approval workflowApproval
Aggregated Approval OrderAn aggregated order of the approval type (or step) within the approval workflowApproval
Approval ResultThe resulting decision of the approval type (or step)Approval
Aggregated Approver NamesAn aggregation of all approver names across all applicable steps withins the approval workflowApproval
Approval DateThe date of the approvalApproval
Approval Resubmit DateThe date of the approval resubmissionApproval
Aggregated Approval TypeThe aggregated titles of all applicable steps within the approval workflowApproval
Impact Report IDThe unique CyberGrants identification number for a particular impact report. Each impact report in CyberGrants will have a distinct impact report IDImpact Report
Available DateThe date the impact report is available for the organization to begin completingImpact Report
Due DateThe date that the impact report is due to be completed by from the organizationImpact Report
Final Approval DateThe final approval date of the impact reportImpact Report
Resubmit DateThe resubmit date from the organizationImpact Report
Submit DateThe date the organization submitted the impact reportImpact Report
DispositionThe current status of the impact reportImpact Report
CommentsThe comments left on the impact reportImpact Report
Submit User Full NameThe full name of the user who submitted the impact reportImpact Report
ProgramThe application type for a particular request. Grant requests may have different questions depending upon their proposal typeProposal Type
Average Grant AmountThe aggregated average grant amountMeasures
Average Grant/Request AmountThe aggregated average of grant or request amount (if grant amount is null)Measures
Average Paid AmountThe aggregated average paid grant amountMeasures
Average Request AmountThe aggregated average requested amountMeasures
Days Request OpenThe final approval date or today's date (if not approved/rejected) - submit date in daysMeasures
Days to ApproveThe date difference from submit date and final approval date with disposition of approvedMeasures
Days to Start Approval TimelineThe approval submit date - submit date in daysMeasures
Request CountThe unique count of requestsMeasures
Request Count (Approved)The unique count of requests with a disposition of ApprovedMeasures
Request Count (External)The unique count of requests with a disposition of ExternalMeasures
Request Count (Paid)The unique count of paid requestsMeasures
Request Count (Pending)The unique count of requests with a disposition of PendingMeasures
Request Count (Pending/Org Reviewed)The unique count of requests with a disposition of Pending or have been returned to the grantmakerMeasures
Request Count (Pending/Org Reviewing)The unique count of requests with a disposition of Pending or pending applicant reviewMeasures
Request Count (Resubmitted)The unique count of requests that have been resubmitted at least onceMeasures
Tag CountThe unique count of Tag IDsMeasures
Grant AmountThe summed amount the grantmaker has elected to approve/reject. This does not have to equal the nonprofit's requested amount.Measures
Grant Amount (Approved)The sum of the total grant amount with a disposition of ApprovedMeasures
Grant/Request AmountThe sum of grant or request amount (if grant amount is null)Measures
Paid AmountThe portion of the grant amount that has been paid. Equals the sum of a grant's payments with a Paid payment statusMeasures
Request AmountThe sum of the request amountMeasures

 

What else do you need help with?

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


Powered by