3Student Financial Planning Groovy Scripts and Prompts

Here's a list of all available Oracle Student Financial Planning Groovy scripts, organized by functional category. Each script includes its name, purpose, return type, and a ready-to-use prompt that you can copy into your generative AI tool to generate well-documented code.

The scripts are grouped into categories to help you quickly find what you need.

ISIR Processing Scripts

Script Name Purpose Return Type
isirUsedInPackaging Select the ISIR that should be used in packaging for an Award Year. IIsirRecordAPI
isirCCodeAutoCodeClearingLogic Determine if an ISIR c-code is auto cleared. Boolean
isirAssumptionAutoCodeClearingLogic Determine if an ISIRassumption is auto cleared. Boolean
isirHighlightAutoCodeClearingLogic Determine if an ISIRhighlight is auto cleared. Boolean
isirRejectCodeAutoCodeClearingLogic Determine if an ISIR reject code is auto cleared. Boolean
isirVerificationClearanceRules Determine if an ISIRverification is auto cleared. Boolean
isirUseSubsequentIsir Define which fields on ISIR will trigger an ISIR review when subsequent ISIRs enter SFP for a Student. Boolean
isirDiscrepancyEvaluation Determinewhether an ISIR correction for a given ISIR field is required. Void
isirHighlightsDocumentsRequired Determine the documents required to resolve an ISIR highlight. Void
isirCCodeDocumentsRequired Determine the documents required to resolve an ISIR c-code. Void
isirRejectCodeDocumentsRequired Determine the documents required to resolve an ISIR reject code. Void
isirVerificationDocumentsRequired Determine the documents required to resolve an ISIR verification. Void
isirAssumptionDocumentsRequired Determine the documents required to resolve an ISIR assumption. Void
isirDiscrepancyRequiredDocuments Determine whether the isirDiscrepancyEvaluation script should be executed. Void
isirDiscrepancyAdditionalDocumentsRequired Determine whether additional documentation should be collected. Void

Financial Aid Calculation Scripts

Script Name Purpose Return Type
gradeLevelProgression Calculate the grade level. Integer
awardOverridingCriteria Override award amounts. IAwardOverrideAPI
awardYearSelectionCriteria Determine the award year to use in crossover payment periods. IScriptedCrossoverArbitratorResult
plusCreditDecisionMatchingCriteria Determine the (G)PLUSloans applicable to the term or payment period. List<IPlusLoanAPI>
medicalAmount Determine the medical amount. BigDecimal
pellEnrollmentIntensity Determine the Enrollment Intensity percentage for the Pell award. BigDecimal

Enrollment and Academic Scripts

Script Name Purpose Return Type
enrollmentStatusOverride Determine whether the calculated enrollment status should be overridden. String
globalEnrollmentStatusCriteria Specifies how the application should find the student's enrollment status. String
summerTermType Defines if the Summer Term should be treated as Header or Trailer. String
nonTermAcyMonths Determine the number of months in a nonterm academic year. Integer
termPaymentPeriodMonths Determine the number of months in a term payment period. BigDecimal

Document Management Scripts

Script Name Purpose Return Type
documentOwnerLogic Determine the document owners. Void
documentFaAcceptance Determine the Financial Aid acceptance of a document. Boolean
documentCancellation Determines when a document request can be canceled. Void
documentMetadataAdditionalResolutionAction Evaluate document metadata fields for document acceptance. Void

Satisfactory Academic Progress (SAP) Scripts

Script Name Purpose Return Type
sapDisablePaceOfCompletion Determines if Pace of Completion calculations are needed for SAP. Boolean
sapEvaluationPeriodDetermination Determines if SAP Period needs evaluation at the end of the academic year. Boolean

Disbursement Scripts

Script Name Purpose Return Type
disbursementDates Evaluates anticipated disbursement dates. List<LocalDate>
configurableDisbursementCriteria Evaluates configurable disbursement criteria. Boolean
configurableLateDisbursementCriteria Evaluates configurable late/pwd disbursement criteria. Boolean
originationCriteria Evaluates origination criteria for a disbursement. Boolean

Miscellaneous Scripts

Script Name Purpose Return Type
letterCodeCriteria Determines the letter code for given parameters. String
notificationRequiredCriteria Determines if a student notification must be triggered. Boolean
coaCostValue Calculates the value of a COA item. BigDecimal
additionalCoaComponents Evaluates if a COA configuration is applicable. Boolean
exitCounselingGraduatingCriteria Evaluates exit counseling criteria for graduating students. Boolean
exitCounselingWithdrawnCriteria Evaluates exit counseling criteria for withdrawn students. Boolean
professionalJudgementInitiatingConditions Determines if a student meets the criteria for professional judgement. Boolean
professionalJudgementRequiredDocuments Determines the documents required for professional judgement. Void