...
SF03 and SF04 generate unknown values. For 210 we used data from a custom SF report that Steve @ ThreeForks, Inc had created.
Status |
---|
colour | Yellow |
---|
title | 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.
Code Block |
---|
|
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' |