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
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 |