Tableau Connector for Workday

Build 20.0.7740

Awards

Award Element

Columns

Name Type References Description
ID_Award_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Award_Reference_Award_Reference_ID String Contains a unique identifier for an instance of an object.
Award_Reference_ID String Award Reference ID. This is the Award Unique Identifier.
Submit Bool Submit for Approval is a boolean flag indicating if the transaction is to be submitted or saved in draft mode. If this flag is set, the transaction will be submitted, otherwise the transaction is saved in draft.
Locked_in_Workday Bool Set to True to disable editing and canceling the invoice inside the Workday application. Invoice can only be updated from the web service.
Award_Number String Award Number
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.
Sponsor_Award_Reference_Number String Sponsor Award Reference Number
Award_Name String Award Name
Award_Description String Award Description
Award_Effective_Date Date Award Effective Date
Award_Signed_Date Date Award Signed Date
Award_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Type_Reference_Sponsor_Award_Type_ID String Contains a unique identifier for an instance of an object.
Purpose_Code_Reference String Purpose Code for the Award. Purpose Codes are tenanted data that can be used for categorizing Awards.
Payment_Terms_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Terms_Reference_Payment_Terms_ID String Contains a unique identifier for an instance of an object.
Institutional_ID String Award Institutional ID
Award_Salary_Cap_Default_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Salary_Cap_Default_Reference_Salary_Cap_ID String Contains a unique identifier for an instance of an object.
Spend_Restriction_Default_Reference String Spend Restriction Default on Award Header
Related_Award_Reference_WID String Contains a unique identifier for an instance of an object.
Related_Award_Reference_Award_Reference_ID String Contains a unique identifier for an instance of an object.
Award_Group_Reference String Award Groups associated with the Award Contract
Organizations_for_Award_Reference String Designate organizations for reporting access
Award_Contract_Owner_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Contract_Owner_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Award_Contract_Owner_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Award_Lifecycle_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Lifecycle_Status_Reference_Award_Lifecycle_Status_ID String Contains a unique identifier for an instance of an object.
Sub_Award Bool Indicates whether this Award is a sub-contracted award. If set to TRUE, specify a Prime Sponsor (Prime Sponsor was previously called Flow Through Sponsor).
Prime_Sponsor_Reference_WID String Contains a unique identifier for an instance of an object.
Prime_Sponsor_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Prime_Sponsor_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Sponsor_Reference_WID String Contains a unique identifier for an instance of an object.
Sponsor_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Sponsor_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Bill_To_Sponsor_Reference_WID String Contains a unique identifier for an instance of an object.
Bill_To_Sponsor_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Bill_To_Sponsor_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payment_Type_Reference_Payment_Type_ID String Contains a unique identifier for an instance of an object.
Letter_Of_Credit_Reference_WID String Contains a unique identifier for an instance of an object.
Letter_Of_Credit_Reference_Letter_of_Credit_ID String Contains a unique identifier for an instance of an object.
Letter_of_Credit_Document_ID String The Document ID used to reference this award for Letter of Credit collection. This field is required if Letter of Credit is entered.
Award_Sequence_Billing_Active_Reference Bool Checkbox toggling Billing Sequence for Award
Award_Billing_Sequence_Number_Format_Syntax_Reference String Billing Sequence format
Current_Award_Billing_Sequence_Number_Used_Reference Decimal Billing Sequence's Start Number
Award_Billing_Sequence_Generator_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Billing_Sequence_Generator_Rule_Reference_Sequence_Generator_Configuration_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_WID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_ID String Contains a unique identifier for an instance of an object.
Currency_Reference_Currency_Numeric_Code String Contains a unique identifier for an instance of an object.
Zero_Amount_Award Bool Indicates whether this award can have a zero amount value.
Sponsor_Direct_Cost_Amount Decimal The direct cost that will be billed to the sponsor for the award.
Sponsor_Facilities_and_Administration_Amount Decimal The indirect costs that will be billed to the sponsor for the award.
Cost_Share_Total_Amount Decimal The obligated cost share amount for the award.
Authorized_Amount Decimal The maximum amount authorized for billing and collection for transactions against this award.
Billing_Limit_Override Decimal The Billing Limit Override for the Award. If this value is non-zero, Cost Reimbursable billing for this award will not exceed this value. Otherwise, the Authorized Amount will be used as the Billing Limit.
Cost_Share_Required_by_Sponsor Bool A boolean flag indicating whether or not the Sponsor requires Cost Share for the award.
Anticipated_Sponsor_Direct_Cost_Amount Decimal The total anticipated Sponsor Direct Cost for the life of the award.
Anticipated_Facilities_and_Administration_Amount Decimal The total anticipated Sponsor indirect cost for the life of the award.
Award_Schedule_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Schedule_Reference_Award_Schedule_Reference_ID String Contains a unique identifier for an instance of an object.
Federal_Award_ID_Number String Federal Award ID Number
CFDA_Number String CFDA Number
CFDA_Number_Reference_WID String Contains a unique identifier for an instance of an object.
CFDA_Number_Reference_CFDA_ID String Contains a unique identifier for an instance of an object.
CFDA_Number_Reference_CFDA_Number String Contains a unique identifier for an instance of an object.
CFDA_Description String Description of CFDA program
Proposal_ID String Proposal ID
Proposal_Version String Proposal Version
Original_Proposal_Reference_WID String Contains a unique identifier for an instance of an object.
Original_Proposal_Reference_Award_Proposal_ID String Contains a unique identifier for an instance of an object.
Related_Proposals_Reference String Related Proposals for an Award

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