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-223HEERF 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'
0 Comments