Awards in multiple SP files should not be reported in most recent file.
Something like this Research department SQL will tell you cross grad_date:
| Code Block |
|---|
|
SELECT "studentgraduates"."pidm",
"studentgraduates"."program",
"studentgraduates"."degree_code",
"studentgraduates"."status",
"studentgraduates"."grad_date"
FROM "StudentNet"."dbo"."studentgraduates" "StudentGraduates"
WHERE ( "studentgraduates"."grad_date" >= {ts '2020-07-01 00:00:00'}
AND "studentgraduates"."grad_date" < {ts '2021-06-30 00:00:01'} )
AND ( "studentgraduates"."status" = 'AW'
OR "studentgraduates"."status" = 'CM'
OR "studentgraduates"."status" = 'CT'
OR "studentgraduates"."status" = 'SC'
OR "studentgraduates"."status" = 'SK' ) |
This SQL can be ran against the MIS_Data/Student_Program_Award, database/table to find records that exist in both selected GI03_MIS_TERM codes:
| Code Block |
|---|
|
select *
from [Student_Program_Award] a
where a.GI03_MIS_TERM =210 and
exists( select pidm from [Student_Program_Award] b where b.GI03_MIS_TERM =200 and a.sp01_program_id=b.sp01_program_id and a.SP02_PROGRAM_AWARD=b.SP02_PROGRAM_AWARD
and a.SP03_PROGR_AWARD_EARN=b.SP03_PROGR_AWARD_EARN and a.SP04_PROGRAM_CO_UNIQUE_CODE = b.SP04_PROGRAM_CO_UNIQUE_CODE) |
...