Tableau Connector for Workday

Build 20.0.7740

Awards_Award_Line_Data

Award Line Data Element

Columns

Name Type References Description
Award_Award_Reference_WID String

Awards.Award_Reference_WID

The unique identifier type. Each
ID_Receivable_Contract_Line_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Receivable_Contract_Line_Reference_Receivable_Contract_Line_Reference_ID String Contains a unique identifier for an instance of an object.
ID_Receivable_Contract_Line_Reference_Student_Sponsor_Contract_Line_ID String Contains a unique identifier for an instance of an object.
Receivable_Contract_Line_Reference_ID String The Receivable Contract Line Reference ID. This is the Receivable Contract Line unique identifier.
Line_Number Decimal Contract Line Number
Intercompany_Affiliate_Reference_WID String Contains a unique identifier for an instance of an object.
Intercompany_Affiliate_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Intercompany_Affiliate_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Bank_Account_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Customer_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Petty_Cash_Account_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Receivable_Writeoff_Reason_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Revenue_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Supplier_Category_ID String Contains a unique identifier for an instance of an object.
Revenue_Category_Reference_Tax_Category_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.
Line_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Line_Type_Reference_Contract_Line_Type_ID String Contains a unique identifier for an instance of an object.
Spend_Restriction_Reference String Spend Restrictions on Award Line
Line_Item_Description_Override String A description of the Award Line.
Deferred_Revenue Bool A boolean Flag indicating whether or not the revenue for the award line is deferred. Cannot be used for cost-reimbursable billing.
Line_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Line_Status_Reference_Document_Status_ID String Contains a unique identifier for an instance of an object.
Primary_Grant Bool A boolean flag indicating whether or not the award contract line is the primary line for the award
Line_CFDA_Number_Reference_WID String Contains a unique identifier for an instance of an object.
Line_CFDA_Number_Reference_CFDA_ID String Contains a unique identifier for an instance of an object.
Line_CFDA_Number_Reference_CFDA_Number String Contains a unique identifier for an instance of an object.
Grant_Reference_WID String Contains a unique identifier for an instance of an object.
Grant_Reference_Grant_ID String Contains a unique identifier for an instance of an object.
Line_Amount Decimal Line Amount
Rate_Agreement_Reference_WID String Contains a unique identifier for an instance of an object.
Rate_Agreement_Reference_Facilities_and_Administration_Rate_Agreement_ID String Contains a unique identifier for an instance of an object.
Cost_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Cost_Rate_Type_Reference_Facilities_and_Adminstration_Cost_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Exception_Reference_WID String Contains a unique identifier for an instance of an object.
Exception_Reference_Facilities_and_Administration_Exception_ID String Contains a unique identifier for an instance of an object.
Revenue_Allocation_Profile_Reference_WID String Contains a unique identifier for an instance of an object.
Revenue_Allocation_Profile_Reference_Facilities_and_Adminstration_Revenue_Allocation_Profile_ID String Contains a unique identifier for an instance of an object.
Basis_Limit_Reference_WID String Contains a unique identifier for an instance of an object.
Basis_Limit_Reference_Basis_Limit_ID String Contains a unique identifier for an instance of an object.
Basis_Limit_ID String The basis limit reference ID.
Basis_Limit_Name String The name of the Basis Limit for the award line.
Basis_Limit_Amount Decimal The maximum cost basis that is eligible for Facilities and Administration calculations for the Award Line or group of Award Lines.
Award_Line_Start_Date Date The date on which the Award Line becomes effective.
Award_Line_End_Date Date The date after which the award line is no longer effective. Transactions occurring after this date, that are tagged with the Grant for this award line will not be considered as 'counting' toward this award line.
Award_Line_Description String Award Line Description
Line_Invoice_Memo_Override String Award Line Invoice Memo Override
Default_Worktags_Reference String Default Worktags that will be placed on Invoice lines generated for Installment Based billing.
Award_Line_Salary_Cap_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Line_Salary_Cap_Reference_Salary_Cap_ID String Contains a unique identifier for an instance of an object.
Award_Line_Salary_Cap_Override_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Line_Salary_Cap_Override_Reference_Salary_Cap_Interval_ID String Contains a unique identifier for an instance of an object.
Subrecipient_Reference_WID String Contains a unique identifier for an instance of an object.
Subrecipient_Reference_Scout_ID String Contains a unique identifier for an instance of an object.
Subrecipient_Reference_Supplier_ID String Contains a unique identifier for an instance of an object.
Subrecipient_Reference_Supplier_Reference_ID String Contains a unique identifier for an instance of an object.
Line_Federal_Award_ID_Number String Federal Award ID Number
Line_Billing_Notes String Line Billing Notes
Revenue_Recognition_Line_Notes String Revenue Recognition Line Notes
Award_Credit_Data String Contains the award credit Information for an award line.

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