key	summary	type	created	updated	due	assignee	reporter	priority	status	resolution

Loading...

Refresh

Past Report Notes

MIS Term 240 didn’t have RVAPROP populated and the CCPG (Promise Grant) records were reported in the wrong Financial Aid Year.

Change Request: CR-000182753 (force.com)

SF03 and SF04 generate unknown values. For 210 we used data from a custom SF report that Stephen @ ThreeForks, Inc had created.

https://sequoias.atlassian.net/browse/AP-223

HEERF II

HEERF II dispersal was done manually outside of Financial Aid. If SF/FA 220 requires reporting it Ryan White wrote this to grab those records.

SELECT   'FA561210'
       || stvterm.STVTERM_MIS_TERM_ID
       || gv_mis_global_bp.f_get_identifier (
              tbraccd_PIDM,
              gb_common.f_get_id (tbraccd_PIDM),
              goksels.f_name_bio_value (tbraccd_PIDM, 'SSN'))
       || 'GW01000                       '    AS FA_LINE
  FROM tbraccd INNER JOIN stvterm ON stvterm_code = tbraccd_Term_code
WHERE tbraccd_detail_code = 'CRFD' AND tbraccd_term_code = '202210'