Tableau Connector for Workday

Build 20.0.7740

StudentAwardItems

Wrapper element for the Student Charge Item Data

Columns

Name Type References Description
Student_Award_Item_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Award_Item_Reference_Student_Award_Item_ID String Contains a unique identifier for an instance of an object.
ID String Reference ID for Student Award Item
Effective_Date Date Search for a Student Award Item using the Effective as of Date.
Name String Search for a Student Award Item using the Name. The match must be an exact match with a Student Award Item Name that contains the Name specified.
Description String Student Award Item Description
Code String Student Award Item Code
Inactive Bool Student Award Item Inactive
Override_Spend_Company_Reference_WID String Contains a unique identifier for an instance of an object.
Override_Spend_Company_Reference_Company_Reference_ID String Contains a unique identifier for an instance of an object.
Override_Spend_Company_Reference_Organization_Reference_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.
Type_Reference_WID String Contains a unique identifier for an instance of an object.
Type_Reference_Student_Award_Type_ID String Contains a unique identifier for an instance of an object.
Loan_Fee_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Fee_Reference_Loan_Fee_ID String Contains a unique identifier for an instance of an object.
Loan_Fee_Deduction_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Fee_Deduction_Method_Reference_Loan_Fee_Deduction_Method_ID String Contains a unique identifier for an instance of an object.
Source_Reference_WID String Contains a unique identifier for an instance of an object.
Source_Reference_Student_Award_Source_ID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Spend_Category_Reference_Spend_Category_ID String Contains a unique identifier for an instance of an object.
Need_Method_Reference_WID String Contains a unique identifier for an instance of an object.
Need_Method_Reference_Student_Award_Need_Method_ID String Contains a unique identifier for an instance of an object.
Federal_Program_ID_Reference_WID String Contains a unique identifier for an instance of an object.
Federal_Program_ID_Reference_Student_Award_Federal_Program_ID_ID String Contains a unique identifier for an instance of an object.
IPEDS_Mapping_Reference_WID String Contains a unique identifier for an instance of an object.
IPEDS_Mapping_Reference_Student_Award_IPEDS_Mapping_ID String Contains a unique identifier for an instance of an object.
State_Program_ID String Student Award Item State Program ID
Student_Award_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Award_Status_Reference_Student_Award_Status_ID String Contains a unique identifier for an instance of an object.
Student_Allowable_Action_Reference String Student Award Item Allowable Action
No_Rounding Bool Student Award Item No Rounding
Package_Once Bool Student Award Item Lock
Award_Sort String Student Award Item Sort Order
Manual_Override Bool Student Award Item Manual Override
Engagement_Action_Item_Reference String Student Award Item Requirements
Award_Eligibility_Calculation_Reference_WID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Accrual_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Aggregate_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Arithmetic_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Build_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Calculation_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Compensation_Plan_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Conditional_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Constant_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Constant_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Date_Difference_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Date_Extract_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Date_Increment_Decrement_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Deduction_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Earning_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Instance_Set_Comparison_Calculation String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Instance_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Logic_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Lookup_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Time_Off_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Value_Comparison_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Deduction_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Earning_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_Calculation_Reference_Workday_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Award_Eligibility_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.
Student_Interim_Calculation_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Interim_Calculation_Reference_Interim_Calculation_ID String Contains a unique identifier for an instance of an object.
Frequency_of_Award_Amount_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_of_Award_Amount_Reference_Frequency_of_Award_Amount_ID String Contains a unique identifier for an instance of an object.
Student_Award_Item_Limit_Data_Reference String Data element containing Aggregate Limit information for a Student Award Item
Fiscal_Limit_Reference_WID String Contains a unique identifier for an instance of an object.
Fiscal_Limit_Reference_Fiscal_Limit_ID String Contains a unique identifier for an instance of an object.
Disbursable Bool Student Award Item Disbursable
Disbursement_Eligibility_Condition_Reference String The Disbursement Eligibility Conditions that must be met by the student before funds are disbursed
Disbursement_Eligibility_Calculation_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Accrual_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Aggregate_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Arithmetic_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Build_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Calculation_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Compensation_Basis_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Compensation_Plan_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Conditional_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Constant_Date_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Constant_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Date_Difference_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Date_Extract_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Date_Increment_Decrement_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Deduction_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Earning_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Instance_Set_Comparison_Calculation String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Instance_Value_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Logic_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Lookup_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Time_Off_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Value_Comparison_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Absence_Balance_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Absence_Component_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Absence_Plan_ID String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Deduction_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Earning_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Pay_Accumulation_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Pay_Balance_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Pay_Component_Group_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Pay_Component_Related_Calculation_Code String Contains a unique identifier for an instance of an object.
Disbursement_Eligibility_Calculation_Reference_Workday_Related_Calculation_ID String Contains a unique identifier for an instance of an object.
Disbursement_Schedule_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Schedule_Rule_Reference_Student_Disbursement_Schedule_Rule_ID String Contains a unique identifier for an instance of an object.
Disbursement_Proration_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Proration_Rule_Reference_Disbursement_Proration_Rule_ID String Contains a unique identifier for an instance of an object.
Work_Study_Payment_Condition_Reference String Student must meet the Work-Study eligibility condition(s) that are set by the school before making the student eligible for Work-Study.
Academic_Period_POS_Load_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Academic_Period_POS_Load_Status_Reference_Student_Load_Status_ID String Contains a unique identifier for an instance of an object.
Course_Start_POS_Load_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Course_Start_POS_Load_Status_Reference_Student_Load_Status_ID String Contains a unique identifier for an instance of an object.
Refundable Bool Student Award Item Refundable
Anticipated_Aid Bool Student Award Item Anticipated AId
Anticipated_Payment_Display_Rule_Reference_WID String Contains a unique identifier for an instance of an object.
Anticipated_Payment_Display_Rule_Reference_Anticipated_Payment_Display_Rule_ID String Contains a unique identifier for an instance of an object.
Student_Precedence_Group_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Precedence_Group_Reference_Student_Precedence_Group_ID String Contains a unique identifier for an instance of an object.
Student_Work_Study_Allocation_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Work_Study_Allocation_Reference_Costing_Override_ID String Contains a unique identifier for an instance of an object.
Student_Work_Study_Allocation_Reference_Student_Work_Study_Allocation_ID String Contains a unique identifier for an instance of an object.
Work_Study_Payment_Limit_Reference_WID String Contains a unique identifier for an instance of an object.
Work_Study_Payment_Limit_Reference_Work_Study_Payment_Limit_ID String Contains a unique identifier for an instance of an object.

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