Tableau Connector for Workday

Build 20.0.7740

StudentSponsorContracts

Element Container for Student Sponsor Contract Data

Columns

Name Type References Description
ID String ID for Student Sponsor Contract Data Element
Academic_Level_Reference_WID String Contains a unique identifier for an instance of an object.
Academic_Level_Reference_Academic_Level_ID String Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_WID String Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_Hierarchy_ID String Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID String Contains a unique identifier for an instance of an object.
Contract_Name String Contract Name for Student Sponsor Contract Data Element
Financial_Aid_Award_Year_Reference_WID String Contains a unique identifier for an instance of an object.
Financial_Aid_Award_Year_Reference_Financial_Aid_Award_Year_ID String Contains a unique identifier for an instance of an object.
Contract_Description String Contract Description for Student Sponsor Contract Data Element
Document_Date Date Document Date for Student Sponsor Contract Data Element
Contract_Signed_Date Date Customer Contract Signed Date for Student Sponsor Contract Data Element
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.
Sponsor_Reflected_Reference_WID String Contains a unique identifier for an instance of an object.
Sponsor_Reflected_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Sponsor_Reflected_Reference_Sponsor_Reference_ID String Contains a unique identifier for an instance of an object.
Award_Contract_Bill_To_Sponsor_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Contract_Bill_To_Sponsor_Reference_Sponsor_ID String Contains a unique identifier for an instance of an object.
Award_Contract_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.
No_FA_Need_Impact Bool Designates that student sponsor payments tied to this student sponsor contract do not impact FA Need.
Impact_1098_T Bool Designates that student sponsor payments tied to this student sponsor contract impacts 1098-T calculations.
Refund_Sponsor_Overpayment_to_Student Bool Designates that a student sponsor overpayment tied to this student sponsor contract will be refunded to the student.
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.
Student_Precedence_Group_for_Academic_Unit_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Precedence_Group_for_Academic_Unit_Reference_Student_Precedence_Group_ID String Contains a unique identifier for an instance of an object.
Student_Minimum Decimal Student Minimum for Student Sponsor Contract Data Element
Student_Maximum Decimal Student Maximum for Student Sponsor Contract Data Element
Disbursement_Schedule_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Schedule_Reference_Student_Calendar_Disbursement_Schedule_ID String Contains a unique identifier for an instance of an object.
Disbursement_Schedule_Reference_Student_Disbursement_Schedule_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_WID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Accrual_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Aggregate_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Arithmetic_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Build_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Calculation_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Compensation_Plan_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Conditional_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Constant_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Constant_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Date_Difference_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Date_Extract_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Date_Increment_Decrement_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Deduction_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Earning_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Instance_Set_Comparison_Calculation String Contains a unique identifier for an instance of an object.
Calculation_Reference_Instance_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Logic_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Lookup_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Time_Off_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Value_Comparison_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Deduction_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Earning_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Calculation_Reference_Workday_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_WID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Accrual_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Aggregate_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Arithmetic_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Build_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Calculation_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Compensation_Plan_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Conditional_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Constant_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Constant_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Date_Difference_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Date_Extract_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Date_Increment_Decrement_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Deduction_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Earning_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Instance_Set_Comparison_Calculation String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Instance_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Logic_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Lookup_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Time_Off_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Value_Comparison_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Deduction_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Earning_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Amount_Calculation_Reference_Workday_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Refundable Bool Refundable Boolean for Student Sponsor Contract Data Element
Respect_Disbursement_Hold Bool Respect Disbursement Hold Boolean for Student Sponsor Contract
Total_Contract_Amount Decimal Total Contract Amount for Student Sponsor Contract Data Element
Revenue_Category_Reference_WID 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.
Worktags_Reference String Worktags for Student Sponsor Contract
Header_Numeric_Field_1 Decimal Header Numeric Field 1 for Student Sponsor Contract Data
Student_Sponsor_Contract_Amount_Rule_Line_Data String Student Sponsor Contract Amount Rule Line Data
Student_Sponsor_Contract_Line_Data String Element Container for Student Sponsor Contract Line Data

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