Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

key summary type created updated due assignee reporter priority status resolution
Refresh

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'
  • No labels