SAP status determination

FHDA has customized way to calculate stats to be used for SAP status determination using FHDA_FA_SAP_CALC_STATS.

The function FHDA_FA_SAP_CALC_STATS is used for many SAP rules on RORRULE.

Function Parameters:

needs three values to be passed to it:

Student PIDM, Term for which the calculations are done, Stat Type to be calculated.

Meaning of stat type:

TA - Term institutional attempted hours
TE - Term institutional earned hours
TG - Term institutional GPA
CA - Cumulative institutional attempted hours
CE - Cumulative institutional earned hours
CG - Cumulative institutional GPA
CP - Cumulative institutional GPA as of prior term

Usage:

Example: find the student's attempted hours

baninst1.fhda_fa_sap_calc_stats(sfbetrm_pidm, sfbetrm_term_code, 'TA')

You can use this function in a select query, e.g.

select
shrlgpa_pidm,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','TA') TA,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','TE') TE,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','TG') TG,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','CA') CA,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','CE') CE,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','CG') CG,
fhda_fa_sap_calc_stats(shrlgpa_pidm,'202511','CP') CP
from shrlgpa

Â