Excel Add-In for Workday

Build 25.0.9434

StudentsPayments

Stores student payment transactions and billing information.

Workday Resource Information

Retrieves a student payment for the specified student ID.

Secured by: Manage: Student Payment Processing

Scope: Student Financials

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier for this instance.

Students_Id [KEY] String False

Workday-generated unique ID linking this record to the associated student.

AcademicPeriod_Descriptor String False

A brief, human-readable summary of the academic period.

AcademicPeriod_Id String False

Unique identifier for the academic period instance.

Amount_Currency String False

The amount of the customer payment in transaction currency.

Amount_Value Decimal False

The monetary value of the customer payment in transaction currency.

Descriptor String False

A brief, human-readable summary of the instance.

InstitutionalAcademicUnit_Descriptor String False

A brief, human-readable description of the institutional academic unit.

InstitutionalAcademicUnit_Id String False

Unique identifier for the institutional academic unit.

PaymentDate Datetime False

The transaction date for the reporting transaction. If filtering for expense reports, use the Expense Report Date report field instead.

PaymentItem_Descriptor String False

A brief, human-readable summary of the payment item.

PaymentItem_Id String False

Unique identifier for the payment item instance.

PaymentType_Descriptor String False

A brief, human-readable description of the payment type.

PaymentType_Id String False

Unique identifier for the payment type instance.

Reason_Descriptor String False

A brief, human-readable summary of the reason for the payment.

Reason_Id String False

Unique identifier for the payment reason instance.

Reference String False

Reference to a customer payment processed through a settlement run. Blank if the Payment Status is 'In Progress' or the Payment Type is 'Check' or 'ETF.'

StudentFinanceTransactionDate Datetime False

The start and end date of the date range filtering payments by the student payment transaction date (format: yyyy-mm-dd).

AcademicPeriod_Prompt String False

The academic period associated with this object. If the object is tied to both a starting and ending period, it returns the starting academic period.

FromDate_Prompt Date False

Limit student payments to those made on or after this date (format: yyyy-mm-dd).

InstitutionalAcademicUnit_Prompt String False

The academic unit, an organizational classification for academic appointments.

PaymentItem_Prompt String False

The student payment item associated with the student payment.

PaymentReference_Prompt String False

The check number or EFT number associated with the student payment.

PaymentType_Prompt String False

The payment type for the reporting transaction.

ToDate_Prompt Date False

Limit student payments to those made on or before this date (format: yyyy-mm-dd).

AcademicLevel_Prompt String False

Reference prompt for selecting the academic level associated with the student.

AcademicUnit_Prompt String False

Reference prompt for selecting the academic unit associated with the student.

ActiveOnly_Prompt Bool False

If true, only returns active students.

ProgramOfStudy_Prompt String False

For non-matriculated students, the program they applied to or were admitted to; for matriculated students, their primary program of study.

Search_Prompt String False

A search string for fuzzy matching student IDs and names. Example: 'bri%20book' returns the student Brian Booker.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434