banr-web-snapshot-panes/Tracking Requirements.sql at master · jpangborn/banr-web-snapshot-panes · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
-- TREQ - Financial Aid Requirements
-- Displays the student's financial aid requirements

-- Sequence: 1
-- Columsn: 0

select rrrareq_treq_code || ' - ' || rtvtreq_long_desc as "Requirement",
  rrrareq_trst_code || ' - ' || rtvtrst_desc as "Status",
  rrrareq_sat_ind as "Satisfied",
  to_char(rrrareq_est_date, 'FMMONTH DD, YYYY') as "Created",
  to_char(rrrareq_stat_date, 'FMMONTH DD, YYYY') as "Status Date",
  rrrareq_fund_code as "Fund"
from rrrareq
left join rtvtreq
  on rrrareq_treq_code = rtvtreq_code
left join rtvtrst
  on rrrareq_trst_code = rtvtrst_code
where rrrareq_aidy_code = :AIDY
  and rrrareq_pidm = :PIDM
  and rrrareq_sat_ind = 'N'
union
select rrrareq_treq_code || ' - ' || rtvtreq_long_desc as "Requirement",
  rrrareq_trst_code || ' - ' || rtvtrst_desc as "Status",
  rrrareq_sat_ind as "Satisfied",
  to_char(rrrareq_est_date, 'FMMONTH DD, YYYY') as "Created",
  to_char(rrrareq_stat_date, 'FMMONTH DD, YYYY') as "Status Date",
  rrrareq_fund_code as "Fund"
from rrrareq
left join rtvtreq
  on rrrareq_treq_code = rtvtreq_code
left join rtvtrst
  on rrrareq_trst_code = rtvtrst_code
where rrrareq_aidy_code = :AIDY
  and rrrareq_pidm = :PIDM
  and rrrareq_sat_ind = 'Y'