Tableau Connector for Workday

Build 20.0.7740

Gifts

Gift Data

Columns

Name Type References Description
ID String ID. This is a unique identifier for Gift.
Inactive Bool Boolean to indicate that Gift is Inactive.
Submit Bool Boolean flag which when set to true will Submit Gift.
Gift_Name String Name for a Gift. Must be unique.
Date_Gift_Established Date Date Gift Established, Optional
Include_Gift_ID_in_Name Bool Boolean flag which when set to true will include the Gift ID in the Gift Name.
Alternate_Name String Alternative Name, Optional
Gift_Classification_Reference_WID String Contains a unique identifier for an instance of an object.
Gift_Classification_Reference_Gift_Classification_ID String Contains a unique identifier for an instance of an object.
Investment_Pool_Reference_WID String Contains a unique identifier for an instance of an object.
Investment_Pool_Reference_Investment_Pool_ID String Contains a unique identifier for an instance of an object.
Company_Reference_WID String Contains a unique identifier for an instance of an object.
Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Company_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Gift_Responsible_Organization_Reference String Reference to an existing Gift Responsible Organization.
Gift_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Gift_Type_Reference_Gift_Type_ID String Contains a unique identifier for an instance of an object.
Gift_Purpose_Reference String Reference to an existing Gift Purpose.
Approval_Level_Reference_WID String Contains a unique identifier for an instance of an object.
Approval_Level_Reference_Approval_Level_ID String Contains a unique identifier for an instance of an object.
Origination_Reference_WID String Contains a unique identifier for an instance of an object.
Origination_Reference_Origination_ID String Contains a unique identifier for an instance of an object.
Administrative_Fee_Applies Bool Boolean Flag which when set to true means the Administrative Free Applies to a Gift.
Related_Worktags_by_Type_Data String Allowed and Default Related Worktags Data by Worktag Type.
Purchase_Worktag_Reference String Reference to Purchase Worktags.
Reinvestment_Worktag_Reference String Reference to Reinvestment Worktags.
Mandatory_Reinvestment Bool Boolean Flag which when set to true indicates Mandatory Reinvestment.
Pay_Flat_Amount_Reinvest_Balance Bool Reinvest Balance
Reinvestment_Amount Decimal Reinvestment Amount for a Gift.
Reinvestment_Percent Decimal Reinvestment Percent for a Gift.
Until_Principal_Amount Decimal Reinvest Until Principal Amount for a Gift.
Until_Reinvestment_Date Date Reinvest Until Reinvestment Date for a Gift.
Flat_Amount_Rule_Data String Income Distribution Amount Rule Data
Percent_Rule_Data String Income Distribution Percent Rule Data
Gift_Restriction_Data String Gift Restriction Data including: Primary Purpose Reference, Gift Purpose Reference, Honorarium Type Reference, Release Level Reference, Matching Requirement, Allow Underwater Spending, Yield Only, Donor Restriction Excerpt, Restriction Description, Nature of Restriction, Restricted By Value Reference. Required Fields: None
Attachment_Data String Encapsulating element containing all Business Document Attachment data.
Secured_Attachment String The details of a resume (resume, name, comments).

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740