Tableau Connector for Workday

Build 20.0.7740

StudentAlternativeLoanApplications

Wrapper element for the Student Alternative Loan Application Get Response

Columns

Name Type References Description
Student_Alternative_Loan_Application_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Alternative_Loan_Application_Reference_Student_Loan_Application_ID String Contains a unique identifier for an instance of an object.
Student_Alternative_Loan_Application_ID String Unique ID for the Alternative Loan Application. Auto Generated if not set
Student_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID String Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID String Contains a unique identifier for an instance of an object.
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.
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.
Alternative_Loan_Certified_Amount Decimal Certified Amount for the Alternative Loan Application
Alternative_Loan_Approved_Amount Decimal Approved Amount for the Alternative Loan Application
Requested_Loan_Amount Decimal Requested Amount for the Alternative Loan Application
Record_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Record_Status_Reference_Student_Alternative_Loan_Application_Record_Status_ID String Contains a unique identifier for an instance of an object.
CommonLine_Unique_Identifier String CommonLine Unique Identifier
CommonLine_Loan_Sequence_Number Decimal CommonLine Loan Sequence Number
Alternative_Student_or_Borrower_Indicator_Reference_WID String Contains a unique identifier for an instance of an object.
Alternative_Student_or_Borrower_Indicator_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Alternative_Borrower_Default_or_Refund_Reference_WID String Contains a unique identifier for an instance of an object.
Alternative_Borrower_Default_or_Refund_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Loan_Period_Begin_Date Date Loan Period Begin Date
Loan_Period_End_Date Date Loan Period End Date
Lender_ID String Lender ID
Program_Type_Code String Program Type Code
Date_Record_Status_Last_Updated Date Date Record Status Last Updated
Servicer_Code String Servicer Code
Student_Information_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Student_Information_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Student_Information_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Student_Information_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Title_Descriptor String The description of the reference to the Title of a person.
Student_Information_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_First_Name String The First Name (Given Name) for a person.
Student_Information_Middle_Name String The Middle Name for a person.
Student_Information_Last_Name String The Last Name (Family Name) for a person.
Student_Information_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Student_Information_Tertiary_Last_Name String The Tertiary Last Name for a person.
Local_Name_Detail_First_Name String Contains First Name in local script, which is generally configured to as Given Name, for supporting Countries.
Local_Name_Detail_Middle_Name String Contains Middle Name in local script for supporting Countries.
Local_Name_Detail_Last_Name String Contains Last Name in local script, which is generally configured as Family Name, for supporting Countries.
Local_Name_Detail_Secondary_Last_Name String Contains Secondary Last Name in local script, which is generally configured as Maternal Family Name, for supporting Countries.
Student_Information_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Information_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Student_Information_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Information_Secondary_Last_Name_2 String Contains Secondary Last Name in second local script, which is generally configured as Maternal Family Name, for supporting Countries.
Student_Information_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Student_Information_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Information_Full_Name_for_Singapore_and_Malaysia String Full Person Name is used by Malaysia and Singapore. It is designed for (eliminate space between these two words) Workers in these countries to enter their Full Legal Name. It is an attribute of Global Person Name Class and is not a concatenation of First and Last Names.
Student_Information_Social_Security_Number String Social Security Number
Student_Information_Date_of_Birth Date Date of Birth
Student_Information_Financial_Aid_Citizenship_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Financial_Aid_Citizenship_Status_Reference_Financial_Aid_Citizenship_Status_ID String Contains a unique identifier for an instance of an object.
Default_or_Refund_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Default_or_Refund_Code_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Student_Information_Signature_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Information_Signature_Code_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Financial_Aid_Grade_Level_in_College_Reference_WID String Contains a unique identifier for an instance of an object.
Financial_Aid_Grade_Level_in_College_Reference_Financial_Aid_Grade_Level_in_College_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Borrower_Information_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Borrower_Information_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Borrower_Information_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Title_Descriptor String The description of the reference to the Title of a person.
Borrower_Information_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_First_Name String The First Name (Given Name) for a person.
Borrower_Information_Middle_Name String The Middle Name for a person.
Borrower_Information_Last_Name String The Last Name (Family Name) for a person.
Borrower_Information_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Borrower_Information_Tertiary_Last_Name String The Tertiary Last Name for a person.
Name_Detail_First_Name String Contains First Name in local script, which is generally configured to as Given Name, for supporting Countries.
Name_Detail_Middle_Name String Contains Middle Name in local script for supporting Countries.
Name_Detail_Last_Name String Contains Last Name in local script, which is generally configured as Family Name, for supporting Countries.
Name_Detail_Secondary_Last_Name String Contains Secondary Last Name in local script, which is generally configured as Maternal Family Name, for supporting Countries.
Borrower_Information_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Borrower_Information_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Borrower_Information_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Borrower_Information_Secondary_Last_Name_2 String Contains Secondary Last Name in second local script, which is generally configured as Maternal Family Name, for supporting Countries.
Borrower_Information_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Borrower_Information_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Borrower_Information_Full_Name_for_Singapore_and_Malaysia String Full Person Name is used by Malaysia and Singapore. It is designed for (eliminate space between these two words) Workers in these countries to enter their Full Legal Name. It is an attribute of Global Person Name Class and is not a concatenation of First and Last Names.
Area_Code String The area code for this phone number.
Phone_Number String The phone number (no area code).
Address_Information_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Address_Information_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Address_Information_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Address_Information_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Last_Modified Datetime The moment when the address was last modified.
Municipality String City part of the address.
Country_City_Reference_WID String Contains a unique identifier for an instance of an object.
Country_City_Reference_Country_Subregion_Code_In_Country String Contains a unique identifier for an instance of an object.
Country_City_Reference_Country_Subregion_Internal_ID String Contains a unique identifier for an instance of an object.
Address_Information_Country_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Address_Information_Country_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Address_Information_Country_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Address_Information_Country_Region_Descriptor String The region part of the address. Typically this contains the state/province information.
Postal_Code String The postal code part of the address.
Number_of_Days Decimal Tracks the number of days an employee works from home per week.
Municipality_Local String City in local script part of the address.
Address_Reference_WID String Contains a unique identifier for an instance of an object.
Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Address_ID String New ID value used in address updates. The ID cannot already be in use by another address.
Borrower_Information_Social_Security_Number String Social Security Number
Borrower_Information_Date_of_Birth Date Date of Birth.
Borrower_Information_Financial_Aid_Citizenship_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Financial_Aid_Citizenship_Status_Reference_Financial_Aid_Citizenship_Status_ID String Contains a unique identifier for an instance of an object.
License_ID_Reference_WID String Contains a unique identifier for an instance of an object.
License_ID_Reference_License_Identifier_ID String Contains a unique identifier for an instance of an object.
License_ID_ID String License Identifier.
ID_Type_Reference_WID String Contains a unique identifier for an instance of an object.
ID_Type_Reference_I9_License_Identifier_Type_Code String Contains a unique identifier for an instance of an object.
ID_Type_Reference_License_ID_Type_ID String Contains a unique identifier for an instance of an object.
License_ID_Country_Reference_WID String Contains a unique identifier for an instance of an object.
License_ID_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
License_ID_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
License_ID_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
License_ID_Country_Region_Reference_WID String Contains a unique identifier for an instance of an object.
License_ID_Country_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
License_ID_Country_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
License_ID_Country_Region_Descriptor String Country Region issuing the License Identifier. No more than one Country Reference, Country Region Reference, or Authority Reference can be specified.
Authority_Reference_WID String Contains a unique identifier for an instance of an object.
Authority_Reference_Authority_ID String Contains a unique identifier for an instance of an object.
License_Class String License Class.
Issued_Date Date Date the License Identifier was issued.
Expiration_Date Date Expiration Date of the License Identifier.
Verification_Date Date Verification Date of the License Identifier.
Verified_By_Reference_WID String Contains a unique identifier for an instance of an object.
Verified_By_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Verified_By_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
License_ID_Shared_Reference_WID String Contains a unique identifier for an instance of an object.
License_ID_Shared_Reference_License_Identifier_Reference_ID String Contains a unique identifier for an instance of an object.
Alien_Registration_Number String Alternative Borrower Alien Registration Number
Borrower_Information_Signature_Code_Reference_WID String Contains a unique identifier for an instance of an object.
Borrower_Information_Signature_Code_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Disbursement_1_Hold_or_Release_Indicator_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_1_Hold_or_Release_Indicator_Reference_Student_Alternative_Loan_Application_Hold_Release_Indicator_ID String Contains a unique identifier for an instance of an object.
Disbursement_2_Hold_or_Release_Indicator_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_2_Hold_or_Release_Indicator_Reference_Student_Alternative_Loan_Application_Hold_Release_Indicator_ID String Contains a unique identifier for an instance of an object.
Disbursement_3_Hold_or_Release_Indicator_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_3_Hold_or_Release_Indicator_Reference_Student_Alternative_Loan_Application_Hold_Release_Indicator_ID String Contains a unique identifier for an instance of an object.
Disbursement_4_Hold_or_Release_Indicator_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_4_Hold_or_Release_Indicator_Reference_Student_Alternative_Loan_Application_Hold_Release_Indicator_ID String Contains a unique identifier for an instance of an object.
Disbursement_Date_1 Date Disbursement Date 1
Disbursement_Date_2 Date Disbursement Date 2
Disbursement_Date_3 Date Disbursement Date 3
Disbursement_Date_4 Date Disbursement Date 4
Disbursement_Amount_1 Decimal Disbursement Amount 1
Disbursement_Amount_2 Decimal Disbursement Amount 2
Disbursement_Amount_3 Decimal Disbursement Amount 3
Disbursement_Amount_4 Decimal Disbursement Amount 4
Origination_Fee_1 Decimal Origination Fee 1
Origination_Fee_2 Decimal Origination Fee 2
Origination_Fee_3 Decimal Origination Fee 3
Origination_Fee_4 Decimal Origination Fee 4
Guarantee_or_Federal_Default_Fee_1 Decimal Guarantee/Federal Default Fee 1
Guarantee_or_Federal_Default_Fee_2 Decimal Guarantee/Federal Default Fee 2
Guarantee_or_Federal_Default_Fee_3 Decimal Guarantee/Federal Default Fee 3
Guarantee_or_Federal_Default_Fee_4 Decimal Guarantee/Federal Default Fee 4
Guarantee_or_Federal_Default_Fees_Paid_1 Decimal Guarantee/Federal Default Fees Paid 1
Guarantee_or_Federal_Default_Fees_Paid_2 Decimal Guarantee/Federal Default Fees Paid 2
Guarantee_or_Federal_Default_Fees_Paid_3 Decimal Guarantee/Federal Default Fees Paid 3
Guarantee_or_Federal_Default_Fees_Paid_4 Decimal Guarantee/Federal Default Fees Paid 4
Net_Disbursement_Amount_1 Decimal Net Disbursement Amount 1
Net_Disbursement_Amount_2 Decimal Net Disbursement Amount 2
Net_Disbursement_Amount_3 Decimal Net Disbursement Amount 3
Net_Disbursement_Amount_4 Decimal Net Disbursement Amount 3
Disbursement_Status_1_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Status_1_Reference_Student_Alternative_Loan_Application_Disbursement_Status_ID String Contains a unique identifier for an instance of an object.
Disbursement_Status_2_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Status_2_Reference_Student_Alternative_Loan_Application_Disbursement_Status_ID String Contains a unique identifier for an instance of an object.
Disbursement_Status_3_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Status_3_Reference_Student_Alternative_Loan_Application_Disbursement_Status_ID String Contains a unique identifier for an instance of an object.
Disbursement_Status_4_Reference_WID String Contains a unique identifier for an instance of an object.
Disbursement_Status_4_Reference_Student_Alternative_Loan_Application_Disbursement_Status_ID String Contains a unique identifier for an instance of an object.
School_ID String School ID
School_Designated_Branch_or_Division_Code String School Designated Branch/Division Code
Guarantor_ID String Guarantor ID
Lender_Non_ED_Branch_ID String Lender Non-ED Branch ID
Processing_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Processing_Type_Reference_Student_Alternative_Loan_Application_Processing_Type_ID String Contains a unique identifier for an instance of an object.
Promissory_Note_Delivery_Reference_WID String Contains a unique identifier for an instance of an object.
Promissory_Note_Delivery_Reference_Student_Alternative_Loan_Application_Promissory_Note_Delivery_Type_ID String Contains a unique identifier for an instance of an object.
Alternative_Borrower_Total_Student_Loan_Debt Decimal Alternative Borrower Total Student Loan Debt
Response_to_Originator_Reference_WID String Contains a unique identifier for an instance of an object.
Response_to_Originator_Reference_Boolean_ID String Contains a unique identifier for an instance of an object.
Loan_Credit_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Credit_Status_Reference_Student_Loan_Application_Credit_Status_ID String Contains a unique identifier for an instance of an object.
Lender_Approved_or_Denied_Date Date Lender Approved/Denied Date
Guarantee_Date Date Guarantee Date
Guarantee_Amount Decimal Guarantee Amount
Guarantee_Amount_Reduction_Reference_WID String Contains a unique identifier for an instance of an object.
Guarantee_Amount_Reduction_Reference_Student_Alternative_Loan_Guarantee_Amount_Reduction_ID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_1_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_1_Reference_Student_Alternative_Loan_Application_Send_Error_Message_ID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_2_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_2_Reference_Student_Alternative_Loan_Application_Send_Error_Message_ID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_3_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_3_Reference_Student_Alternative_Loan_Application_Send_Error_Message_ID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_4_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_4_Reference_Student_Alternative_Loan_Application_Send_Error_Message_ID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_5_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Send_Error_Message_5_Reference_Student_Alternative_Loan_Application_Send_Error_Message_ID String Contains a unique identifier for an instance of an object.
Application_Phase_Reference_WID String Contains a unique identifier for an instance of an object.
Application_Phase_Reference_Student_Alternative_Loan_Application_Phase_ID String Contains a unique identifier for an instance of an object.
School_Refund_Amount Decimal School Refund Amount
Date_of_Refund_to_Lender Date Date of Refund to Lender

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