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:

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:

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)

Resources

Awards in multiple SP files should not be reported in most recent file.

0 Comments