Return to Navigation

Reviewing Delivered Equations

This section lists the PeopleSoft-delivered equations.

Oracle delivers a set of feature-specific equations as part of Equation Engine. These represent either system-specific or demonstration-based equations.

Warning! Do not modify any system-specific equations, because compromising those equations has negative processing ramifications for the specific feature.

You can view any equation that you are authorized to read on the Review Equations component select (Set Up SACR, then select Common Definitions, then select Equation Engine, then select Review Equations).

EQ* — Delivered System and Demo Equations

Equation Name

Description

EQCOMPILEALL

Compile All Active Equations

EQFACTORIAL

Factorial Sub Equation

EQROUND

Round to spec decimal places

EQROUNDBANK

Banker's Rounding

EQTNRUNCTL

Default Equation Run Control

EQTSTADD1

Test Add 1

EQTSTASGN1

Test Assignment Statement

EQTSTASSIGN2

Test Assign 2

EQTSTCALL1

Test Call 1

EQTSTCALL2

Test Call 2

EQTSTCALL3

Test Call 3

EQTSTCALL4

Test Call 4

EQTSTCALL5

Test Call 5

EQTSTCALL6

Test Call 6 - sql multi select

EQTSTCALL7

Test Call 7 - sql sel count

EQTSTCALL8

Call Test 8

EQTSTDDF

Test Date Difference

EQTSTDIV1

TEST DIVIDE 1

EQTSTEXIST1

Test Exist 1

EQTSTEXIST2

Test Exit 2

EQTSTEXIST3

Test Exit 3

EQTSTEXT1

Test External 1

EQTSTEXT2

Test External 2

EQTSTFIND1

Test Find 1

EQTSTFIND2

Test Find 2

EQTSTFIND3

Test Find 3

EQTSTFIND4

Test Find 4

EQTSTFIND5

Test Find 5

EQTSTFIND6

Find 6

EQTSTHALT1

Halt Test 1

EQTSTIF1

Test If 1

EQTSTIF2

Test If 2

EQTSTIF3

Test If 3

EQTSTIF4

If Test 4

EQTSTLOOP1

Test Loop 1

EQTSTMSG1

Test Msg 1

EQTSTMSG2

Test Msg 2

EQTSTMSG3

Test Msg 3

EQTSTMSG4

Test Msg 4

EQTSTMSG5

Test Msg 5

EQTSTMSG6

Test Msg 6

EQTSTMSG7

Test Msg 7

EQTSTMULT1

Test Multiply 1

EQTSTPAREN1

Test Paren 1

EQTSTPRECED1

Test Operator Precedence 1

EQTSTRETN1

Test Return 1

EQTSTRETN2

Test Return 2

EQTSTROUND1

Test Rounding 1

EQTSTSTEM1

Test Stem 1

EQTSTSTEM2

Test Stem 2

EQTSTSTEM3

Test Stem 3

EQTSTSTEM4

Test Stem 4

EQTSTSUB1

Test Subtract 1

FACE* — CommonLine Delivered Edits

Equation Name

Description

FACEDDELERRS

Delete Old Loan Edit Errors

FACEDGET1ST

Get First Run Control Info

FACEDGETCATG

Get Dest Category

FACEDGETCLPN

Get CL Pnote

FACEDGETDEST

Get Loan Dest Edit Data

FACEDGETORIG

Get Loan Origination Data

FACEDGETTYPE

Get Loan Type Data

FACEDLOGERR

Log Loan Edit Errors

FACEDUPDSTAT

Update Loan Action Status

FACL* — CommonLine Delivered Edits

Equation Name

Description

FACLOANEDITS

Fin Aid Loan Edits

FACLOANONEUP

One Up CRC Loan Validation

FACR* — Common Record CommonLine Delivered Edits

Equation Name

Description

FACRADDR01

Permanent address missing

FACRADDR02

Mailing address missing

FACRADDR03

Borrower perm address missing

FACRADDR04

Borrower mailing addr missing

FACRBORROW01

Borrower missing

FACRCHNG01

Loan incr w/undisbursed check

FACRCOSIGN01

Cosigners Required

FACRCOSIGN02

Cosigner Signatures Required

FACRDEBT01

Total Loan Debt Missing

FACRDEPSTAT1

Dependency stat missing

FACRDEST01

Loan Dest Nbr is Zero

FACRDISBDT01

Disb 91 days after Ln Per End

FACRDISBDT02

Ln Per Strt - Disb Dt > 13

FACRDISBDT03

Disb dts require chron order

FACRDRVLIC01

Borrower DL or state missing

FACRGRADDT01

Grad dt before Loan End dt

FACRHOLDFED1

Disbursement Hold on Fed Aid

FACRNAME01

Student name missing

FACRNAME02

Borrower name missing

FACRPER01

Loan Per gt 1 Yr

FACRPLUS01 PLUS borr/stdnt SSN

same

FACRPLUS02

No PLUS for grad student

FACRPLUSMPN

Serial PLUS MPN Check

FACRREFS01

References Required

FACRSRVCIN01

Service Indicators Exist

FACRSSN01

Borrower SSN is blank

FACRSSN02

Student SSN is blank

FAED* — CommonLine 4 Delivered Edits

Equation Name

Description

FAEDADDR01

Permanent address missing

FAEDADDR02

Mailing address missing

FAEDADDR03

Borrower perm address missing

FAEDADDR04

Borrower mailing addr missing

FAEDBORROW01

Borrower missing

FAEDCHNG01

Loan incr w/undisbursed check

FAEDCOSIGN01

Cosigners Required

FAEDCOSIGN02

Cosigner Signatures Required

FAEDDEBT01

Total Loan Debt Missing

FAEDDEPSTAT1

Dependency stat missing

FAEDDEST01

Loan Dest Nbr is Zero

FAEDDISBDT01 Disb

91 days after Ln Per End

FAEDDISBDT02

Ln Per Strt - Disb Dt > 13

FAEDDISBDT03

Disb dts require chron order

FAEDDRVLIC01

Borrower DL or state missing

FAEDGRADDT01

Grad dt before Loan End dt

FAEDNAME01

Student name missing

FAEDNAME02

Borrower name missing

FAEDPER01

Loan Per gt 1 Yr

FAEDPLUS01

PLUS borr/stdnt SSN same

FAEDPLUS02

No PLUS for grad student

FAEDPLUSMPN

Serial PLUS MPN Check

FAEDREFS01

References Required

FAEDSRVCIN01

Service Indicators Exist

FAEDSSN01

Borrower SSN is blank

FAEDSSN02

Student SSN is blank

FAHD* — Hold and Release Delivered Edits

Equation Name

Description

FAHDLOADLVL

Load Level Status Check

FAHDSAPSTAT

Satisfactory Academic Progress

FALTR*— Forms Engine FAN Delivered Equations

Equation Name

Description

FANLTRDTRANG

Award Ltrs within a date range

FANLTRNONEED

No Need

FANLTRSCHONL

Scholarship Only

FANLTRSEL

Award Ltr Selection Criteria

FA_CRC* — CRC Loan Edits Delivered Edits

Equation Name

Description

FA_CRCEDITS

FA CRC Loan Edits

FA_* — CommonLine Delivered Edits

Equation Name

Description

FACEDDELERRS

Delete Old Loan Edit Errors

FACEDGET1ST

Get First Run Control Info

FACEDGETCATG

Get Dest Category

FACEDGETCLPN

Get CL Pnote

FACEDGETDEST

Get Loan Dest Edit Data

FACEDGETORIG

Get Loan Origination Data

FACEDGETTYPE

Get Loan Type Data

FACEDLOGERR

Log Loan Edit Errors

FACEDUPDSTAT

Update Loan Action Status

FA_LOANEDITS

Fin Aid Loan Edits

FAPK* — Packaging System Equations

Equation Name

Description

FAPKAFDCPAR

Set global AFDC_PAR

FAPKAFDCSTU

Set global AFDC_STU

FAPKAGIPAR

Set global AGI_PAR

FAPKAGISTU

Set global AGI_STU

FAPKCHLSPPAR

Set global CHILD_SUPPORT_PAR

FAPKDEPENDST

Set global DEPNDNCY_STAT

FAPKDEPNDNTS

Set global DEPENDENTS

FAPKDTAPPREC

Set global DT_APP_RECEIVED

FAPKERNINPAR

Set global ERND_INC_CRED_PAR

FAPKEXEMPT

Set global NUM_EXEMPTIONS

FAPKEXEMPTPR

Set global NUM_EXEMPTIONS_PAR

FAPKGDATASRC

Get Packaging Data Source

FAPKLEGALRES

Set global LEGAL_RESIDENCE

FAPKMARSTPAR

Set global MARITAL_STAT_PAR

FAPKMAR_STAT

Set global MARITAL_STAT

FAPKMONVETBN

Set global MONTHLY_VET_BEN

FAPKNMFAMMEM

Set global NUM_FAMILY_MEMBERS

FAPKNMINCOLL

Set global NUMBER_IN_COLLEGE

FAPKNMMNVTBN

Set global NUM_MONTH_VET_BEN

FAPKNUMINCOL

Set global NUM_IN_COLLEGE

FAPKNUMINFAM

Set global NUMBER_IN_FAMILY

FAPKORPHAN

Set global ORPHAN

FAPKRDINSTCT

Read INST_CONTROL

FAPKRDINSTIN

Read INST_INTERPRET

FAPKRDINSTPR

Read Inst Parent

FAPKRDINSTST

Read Inst Student

FAPKRDISIRCT

Read ISIR_CONTROL

FAPKRDISIRPR

Read Isir Parent

FAPKRDISIRST

Read Isir Student

FAPKSPERNINC

Set global SPS_EARNED_INCOME

FAPKSSBENPAR

Set global SS_BENEFIT_PAR

FAPKSSBENSTU

Set global SS_BENEFIT_STU

FAPKSTATERES

Get State Residence

FAPKSTERNINC

Set global STD_EARNED_INCOME

FAPKTOTWKAP

Set global TOTAL_FROM_WKA_P

FAPKUNTAXIN

Set global UNTAXED_INC

FAPKUNTAXINP

Set global UNTAXED_INC_PAR

FAPKVETERAN

Set global VETERAN

FAPD* — Packaging Demo Equations

Oracle strongly recommends that you not modify these equations. You can clone them to use a basis for your own similar equations.

Equation Name

Description

FAPDADJPCONT

Stored Value ADJ_PAR_CONTRIB

FAPDANNLOAD

Annual Load 1

FAPDANNLOAD2

Annual_Load 2

FAPDANNLOAD3

Annual Load 3

FAPDAPP_DATE

If Then Example DT_APP_RECEIVED

FAPDCLCIFAGI

Calc Variables based on AGI

FAPDCLCTLEFC

Calculate Award based on EFC

FAPDDEPENDNT

Dependent Students

FAPDDEPNDNTS

Dependents

FAPDDL_STATE

Award based on License State

FAPDDOBPRIOR

If Then Example of DOB_PRIOR

FAPDEARLYADM

If Then Else Example EARLY_ADM

FAPDEFC3000

Award based on FED_EFC <= 3000

FAPDEFC4000

Award based on FED_EFC <= 4000

FAPDEFC6000

Award based on FED_EFC > 6000

FAPDEFCBOTH

Handles Both Award Periods

FAPDEFC_STAT

If Then Example of EFC STAT

FAPDFROSH

Award based on Freshman level

FAPDGAPBDGT1

Gap_Bdgt#1

FAPDGAPBDGT2

Gap_Bdgt#2

FAPDGRADELVL

Award based on NSLDS_LOAN_YEAR

FAPDGRADS

GRADUATES

FAPDHIGHEFC

Award where FED_EFC >= 10,000

FAPDINDPNDNT

Independent

FAPDJMET5000

Select if Unmet Need >= 5,000

FAPDLASTAWRD

Last Award

FAPDMDLABRAT

Award based on VARIABLE_FLAG7

FAPDMDSPCLTY

Award based on VARIABLE_CHAR3

FAPDMDTSTSCR

Award using VARIABLE_NUM5

FAPDPELLELIG

Select Pell Eligible Candidate

FAPDPELL_ELG

Pell Eligibility Flag Example

FAPDPLUS_INT

Example: Interest in PLUS Loan

FAPDPRIM_EFC

Stored Val Example Primary EFC

FAPDPRJYRINC

If Then Example on PROJ_YR_INC

FAPDP_AFDC

Stored Value of Parents' AFDC

FAPDP_AGI

Stored Value of PAR_AGI

FAPDP_IM#COL

Inst Parent Number in College

FAPDP_IM_AGI

Inst Parent Number in College

FAPDP_MARSTT

If Then using MARITAL_STAT_PAR

FAPDP_NMCOLL

If Then: PAR NUM_IN_COLLEGE

FAPDP_WORK1

Parent 2005 ISIR WORKSHEET_A

FAPDP_WORK2

Parent 2005 ISIR WORKSHEET_B

FAPDP_WORK3

Parent 2005 ISIR WORKSHEET_C

FAPDREMNEED1

Remaining Need 1

FAPDREMNEED2

Remaining Need 2

FAPDREMNEED3

Remaining Need 3

FAPDROUNDAWD

Round A_AMOUNT

FAPDRUNGAWDS

Running TOTAL AWD AMT

FAPDSEC_EFC

Stored Value of SECONDARY_EFC

FAPDSPS_ERND

Stored Value of SPS_EARNED_INC

FAPDSSA_CITZ

If Then: SSA_CITIZENSHP_IND

FAPDS_AFDC

Stored Value: AFDC_STU

FAPDS_AGI

Stored Value: AGI_STU

FAPDS_CHLSUP

Store Value CHILD_SUPPORT_RCVD

FAPDS_DEP_ST

If Then Example DEPNDNCY_STAT

FAPDS_EARNED

Stored Val: STD_EARNED_INCOME

FAPDS_IM_AGI

Award using IM Student AGI

FAPDS_IM_INC

Inst Student Income

FAPDS_MARRD

If Then Example of STU MARRIED

FAPDS_MAR_ST

If Then Example MARITAL_STAT

FAPDS_NUMCOL

If Then STU NUMBER_IN_COLLEGE

FAPDS_NUMFAM

If Then STU NUM_FAMILY_MEMBERS

FAPDS_ORPHAN

If Then And Example of ORPHAN

FAPDS_ST_SEL

If Then Example STATE_AGNCY_RLS

FAPDS_VA_BEN

Stored Value MONTHLY_VET_BEN

FAPDS_VETERN

If Then Example VETERAN status

FAPDS_WORK1

STUDENT_WORKSHEET_A

FAPDS_WORK2

STUDENT_WORKSHEET_B

FAPDS_WORK3

STUDENT_WORKSHEET_C

FAPDTGTRMNED

Award using I_TRGT_FED_RMNEED

FAPDTIV_ELIG

If Then Example: TITLEIV_ELIG

FAPDTOTALINC

Stored Value of TOTAL_INCOME

FAPDTOTPRCNT

Stored Value TOTAL_PAR_CONTRIB

FAPDTOTSCONT

Stored Value TOTAL_STU_CONTRIB

FAPDTRANS_DT

Award using TRANS_PROCESS_DT

FAPDUGRADS

UNDERGRADS

FAPDUMET1000

Select FED_RMNEED >= 10,000

FAPDUNGRADS

Undergraduates

FAPDVALIDEFC

Award using VALID_EFC_CALC

FAPDVGAPAWRD

VGAP Award Amount

FAPDVIRGNRES

If Then: STATE_RESIDENCE = VA

FAPD_APPDATE

IF THEN DATE > 2003/01/01

FAPD_IM_#COL

Award using Stu Nbr in College

SFTD* — SF Tuition Calculation Delivered Equations

Equation Name

Description

SFTDBILLUNIT

Billing Units

SFTDCSSTDYFE

Case Study Fees

SFTDMDLABRAT

Medical School Laboratory Fees

SFTDMDSCTUIT

Medical School Tuition

SFTDMDSPECLT

Medical Speciality

SFTDMDTESTSC

Medical School Test Scores

SFTDRSRCHFEE

Research Project Fees

SFTDUGRAD

Undergraduate

SFTDUGRDAMT

SF UGRD Pay Amount

SFTDUGRDSEL

SF UGRD Select

SFTDTFTRMTRM

Term Fee Charge by Term Adjust by Term

SFTDTFTRMSES

Term Fee Charge by Term Adjust by Session

SFTDTFTRMCLS

Term Fee Charge by Term Adjust by Class

SFTDTFSESTRM

Term Fee Charge by Session Adjust by Term

SFTDTFSESCLS

Term Fee Charge by Session Adjust by Class

SFTDCLSTRM

Term Fee Charge by Class Adjust by Term

SFTDCLASSNBR

Class Fee A_Amount

SFTDCLSSEL

Class Fee A_Select

SFTDCOURSEID

Course ID A_Amount

SFTDCLSWVR

Course Fee A_Amount Negative