Tableau Connector for Workday

Build 20.0.7740

StudentLoanApplications

Contains information about the referenced Student Loan Application.

Columns

Name Type References Description
ID String Reference ID for the Student Loan Application
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.
Student_Social_Security_Number String Social Security Number for the Borrower on the Loan Application
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.
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.
Maximum_Loan_Amount_Requested Bool Marks if the Maximum Loan Amount has been requested
Student_Loan_Amount_Requested Decimal Amount requested for the Student Loan Application
Unknown_Loan_Amount Bool The PLUS loan applicant's indication that they did not know the amount of PLUS to borrow
Endorser_Amount Decimal The endorser amount for the PLUS loan application
Loan_Application_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Application_Reason_Reference_Student_Loan_Application_Reason_ID String Contains a unique identifier for an instance of an object.
Application_ID Decimal Application ID for the Student Loan Application
Loan_Application_Submission_Date Date The date the Loan Application was submitted.
Application_Completed_Date Date The date the PLUS loan application was completed
Previous_Application_ID Decimal The Previous Student Loan Application ID that the current one is updating.
Previous_Student_Loan_Application_Reference_WID String Contains a unique identifier for an instance of an object.
Previous_Student_Loan_Application_Reference_Student_Loan_Application_ID String Contains a unique identifier for an instance of an object.
Loan_Balance_Option_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Balance_Option_Reference_Student_Loan_Application_Balance_Option_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.
Loan_Action_Choice_Reference_WID String Contains a unique identifier for an instance of an object.
Loan_Action_Choice_Reference_Student_Loan_Application_Action_Choice_ID String Contains a unique identifier for an instance of an object.
Loan_Application_Start_Date Date Start Date for the Student Loan Application
Loan_Application_End_Date Date End Date for the Student Loan Application
Credit_Requirements_Met Bool The COD indicator the the PLUS loan applicant has met all credit requirements
Reconsideration_Eligible Bool The PLUS loan applicant's credit eligibility based on reconsideration
Original_Credit_Decision_Credit_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Original_Credit_Decision_Credit_Status_Reference_Student_Loan_Application_Credit_Status_ID String Contains a unique identifier for an instance of an object.
Credit_Appeal_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Credit_Appeal_Status_Reference_Student_Loan_Application_Credit_Appeal_Status_ID String Contains a unique identifier for an instance of an object.
Credit_Decision_Date Date The date the credit decision status for the PLUS loan was determined
Credit_Decision_Expiration_Date Date The expiration date of the PLUS loan loan credit decision status
Credit_Action_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Credit_Action_Status_Reference_Student_Loan_Application_Credit_Action_Status_ID String Contains a unique identifier for an instance of an object.
PLUS_Counseling_Completed Bool Indicator that returns whether or not the PLUS loan applicant completed PLUS Counseling
PLUS_Counseling_Completed_Date Date The date that the PLUS loan borrower completed PLUS Counseling
Endorser_Approved Bool Indicator that the PLUS loan endorser is credit-approved
School_Credit_Balance_Option Bool The PLUS loan applicant's indication on how they want the loan balance to be processed
Country_Reference_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Country_Reference_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Country_Reference_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Country_Reference_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Title_Descriptor String The description of the reference to the Title of a person.
Student_Loan_Application_Student_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_First_Name String The First Name (Given Name) for a person.
Student_Loan_Application_Student_Middle_Name String The Middle Name for a person.
Student_Loan_Application_Student_Last_Name String The Last Name (Family Name) for a person.
Student_Loan_Application_Student_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Student_Loan_Application_Student_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_Loan_Application_Student_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Loan_Application_Student_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Student_Loan_Application_Student_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Loan_Application_Student_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_Loan_Application_Student_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Student_Loan_Application_Student_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_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_Loan_Application_Student_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Last_Modified Datetime The moment when the address was last modified.
Student_Loan_Application_Student_Address_Line_Data String The address line for the address. This typically contains Street name, street number, apartment, suite number.
Student_Loan_Application_Student_Municipality String City part of the address.
Student_Loan_Application_Student_Country_City_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_City_Reference_Country_Subregion_Code_In_Country String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_City_Reference_Country_Subregion_Internal_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Submunicipality_Data String The submunicipality of the address.
Student_Loan_Application_Student_Country_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Country_Region_Descriptor String The region part of the address. Typically this contains the state/province information.
Student_Loan_Application_Student_Subregion_Data String The subregion part of the address.
Student_Loan_Application_Student_Postal_Code String The postal code part of the address.
Student_Loan_Application_Student_Usage_Data String Encapsulating element for all Communication Method Usage data.
Student_Loan_Application_Student_Number_of_Days Decimal Tracks the number of days an employee works from home per week.
Student_Loan_Application_Student_Municipality_Local String City in local script part of the address.
Student_Loan_Application_Student_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Student_Address_ID String New ID value used in address updates. The ID cannot already be in use by another address.
Student_Loan_Application_Student_Email_Address String The Student's Email Address for this Loan Application.
Name_Detail_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Name_Detail_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Name_Detail_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Name_Detail_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Title_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Title_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Title_Descriptor String The description of the reference to the Title of a person.
Student_Loan_Application_Borrower_Salutation_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Salutation_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_First_Name String The First Name (Given Name) for a person.
Student_Loan_Application_Borrower_Middle_Name String The Middle Name for a person.
Student_Loan_Application_Borrower_Last_Name String The Last Name (Family Name) for a person.
Student_Loan_Application_Borrower_Secondary_Last_Name String The Secondary Last Name (Secondary Family Name) for a person.
Student_Loan_Application_Borrower_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.
Student_Loan_Application_Borrower_First_Name_2 String Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Loan_Application_Borrower_Middle_Name_2 String Contains Middle Name in second local script for supporting Countries.
Student_Loan_Application_Borrower_Last_Name_2 String Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Student_Loan_Application_Borrower_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_Loan_Application_Borrower_Social_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Social_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Social_Suffix_Descriptor String A reference to the description of Social Suffix for a person.
Student_Loan_Application_Borrower_Academic_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Academic_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Hereditary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Hereditary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Honorary_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Honorary_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Professional_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Professional_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Religious_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Religious_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Royal_Suffix_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Royal_Suffix_Reference_Predefined_Name_Component_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_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_Loan_Application_Borrower_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Last_Modified Datetime The moment when the address was last modified.
Student_Loan_Application_Borrower_Address_Line_Data String The address line for the address. This typically contains Street name, street number, apartment, suite number.
Student_Loan_Application_Borrower_Municipality String City part of the address.
Student_Loan_Application_Borrower_Country_City_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_City_Reference_Country_Subregion_Code_In_Country String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_City_Reference_Country_Subregion_Internal_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Submunicipality_Data String The submunicipality of the address.
Student_Loan_Application_Borrower_Country_Region_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Region_Reference_Country_Region_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Region_Reference_ISO_3166_2_Code String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Country_Region_Descriptor String The region part of the address. Typically this contains the state/province information.
Student_Loan_Application_Borrower_Subregion_Data String The subregion part of the address.
Student_Loan_Application_Borrower_Postal_Code String The postal code part of the address.
Student_Loan_Application_Borrower_Usage_Data String Encapsulating element for all Communication Method Usage data.
Student_Loan_Application_Borrower_Number_of_Days Decimal Tracks the number of days an employee works from home per week.
Student_Loan_Application_Borrower_Municipality_Local String City in local script part of the address.
Student_Loan_Application_Borrower_Address_Reference_WID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Address_Reference_Address_ID String Contains a unique identifier for an instance of an object.
Student_Loan_Application_Borrower_Address_ID String New ID value used in address updates. The ID cannot already be in use by another address.
Area_Code String The area code for this phone number.
Phone_Number String The phone number (no area code).
Student_Loan_Application_Borrower_Email_Address String The Borrower's Email Address for this Loan Application.
Social_Security_Number String The Borrower's Social Security Number for this Loan Application.
Date_of_Birth Date The Borrower's Date of Birth for this Loan Application.
Citizenship_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Citizenship_Status_Reference_Financial_Aid_Citizenship_Status_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