Jira Legacy |
---|
server | System JIRA |
---|
columns | key,summary,type,created,updated,due,assignee,reporter,priority,status |
---|
|
...
,resolution | maximumIssues | 20 |
---|
jqlQuery | labels = "SF/FA" |
---|
serverId | 8b861ae3-ff87-316b-a17e-97c61a7e2fb4 |
---|
|
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 Steve Stephen @ ThreeForks, Inc had created.
...
Status |
---|
colour | Yellow |
---|
title | HEERF II |
---|
|
...
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' |