Loading...
 

FinAid “Is” Boolean Functions

Most Frequently Used FinAid “Is” Functions in Argos

mv_FinAid_IsTAP ( PIDM, AID_YEAR)
  • returns: Y if a Student is a TAP (Tuition Assistance Program) aid-eligible.
  • returns: NULL otherwise.
mv_FinAid_IsTAP_byTerm ( PIDM, TERM)
  • returns: Y if a Student is a TAP (Tuition Assistance Program) aid-recipient and RPRATRM_PAID_AMT > 0.
  • returns: NULL otherwise.
mv_FinAid_IsPELL ( PIDM, AID_YEAR)
  • returns: Y if a Student is a Pell Grant aid-eligible.
  • returns: NULL otherwise.
mv_FinAid_IsPELL_byTerm ( PIDM, TERM)
  • returns: Y if a Student is a PELL Grant aid-recipient and RPRATRM_PAID_AMT > 0.
  • returns: NULL otherwise.
mv_FinAid_IsExcelsior ( PIDM)
  • returns: Y if a Student is a Excelsior Scholarship (SGRCHRT_CHRT_CODE = 'EXCS') aid-eligible.
  • returns: NULL otherwise.
mv_FinAid_IsFundRecipient ( PIDM, AID_YEAR)
  • returns: Y if an Aid-Recipient of one of the following funds: Tuition Assistance Program (TAP), Pell Grant, or Aid for Part-Time Study (APTS).
  • returns: NULL otherwise.
mv_FinAid_IsAidRecipient ( PIDM, AID_YEAR)
  • returns: Y if a Student is an Aid-Recipient of one of the following funds: Social Security Insurance (SSI), Food Stamps, Temporary Assistance for Needy Families (TANF), or Women, Infants and Children (WIC).
  • returns: NULL otherwise.
mv_FinAid_IsLowIncome ( PIDM, AID_YEAR)
  • returns: Y if a Student is a Student/Parent is an Aid-Recipient meets one of the following: total family income below $21,257 for single persons, or $28,694 per couple, or $36,131 for a family of three, with an additional $7,437 for each additional family member.
  • returns: NULL otherwise.
mv_FinAid_IsAcceptedFund ( PIDM, AID_YEAR, FUND_CODE)
  • returns: Y if a Student has accepted (RPRAWRD_AWST_CODE = 'ACCP') or 'N' if (RPRAWRD_AWST_CODE = 'OFFD') not accepted a fund (RPRAWRD_FUND_CODE).
  • returns: NULL otherwise.

mv_FinAid_IsDonePromissoryNote ( PIDM)
  • returns: Y if a Student has completed Promissory Note Electronically (RLRDMPN_EMPN_IND = 'Y') or 'N' if completed on Paper (RLRDMPN_EMPN_IND = 'N').
  • returns: NULL otherwise.
mv_FinAid_IsFirstTimeEnrolled ( PIDM, TERM)
  • returns: Y if a Student was first time enrolled (RORSAPR_SAPR_CODE = 'F') in a given term.
  • returns: NULL otherwise.