EnterpriseDW

-- Get all graduation records. SELECT grad.STDNT_ID AS StudentId ,grad.PGM_ID AS ProgramCode ,grad.EFF_TERM AS EffectiveTerm ,grad.SEQ_NUM AS SequenceNumber ,grad.ACT_GRAD_TRM AS GraduationTerm ,COUNT(*) AS NumTermsToGraduate ,ISNULL(grad.PGM_GPA,0) AS ProgramGpa FROM dbo.ST_STDNT_OBJ_AWD_A grad LEFT OUTER JOIN ( /* Get list of terms that the student has local classes in Academic History */ SELECT STUDENT_ID ,LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) AS TRM_YR FROM ST_ACDMC_HIST_A WHERE SUBSTRING(CLASS_KEY,1,1) = 'C' OR SUBSTRING(CLASS_KEY,1,1) = 'N' -- Local classes GROUP BY STUDENT_ID, LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) ) AH ON ( AH.STUDENT_ID = grad.STDNT_ID AND AH.TRM_YR <= grad.ACT_GRAD_TRM ) WHERE grad.ACT_GRAD_TRM IS NOT NULL AND grad.ACT_GRAD_TRM <> '' GROUP BY grad.STDNT_ID ,grad.PGM_ID ,grad.EFF_TERM ,grad.SEQ_NUM ,grad.ACT_GRAD_TRM ,ISNULL(grad.PGM_GPA,0)

" -- Get all graduation records. SELECT grad.STDNT_ID AS StudentId ,grad.PGM_ID AS ProgramCode ,grad.EFF_TERM AS EffectiveTerm ,grad.SEQ_NUM AS SequenceNumber ,grad.ACT_GRAD_TRM AS GraduationTerm ,COUNT(*) AS NumTermsToGraduate ,ISNULL(grad.PGM_GPA,0) AS ProgramGpa FROM dbo.ST_STDNT_OBJ_AWD_A grad LEFT OUTER JOIN ( /* Get list of terms that the student has local classes in Academic History */ SELECT STUDENT_ID ,LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) AS TRM_YR FROM ST_ACDMC_HIST_A WHERE SUBSTRING(CLASS_KEY,1,1) = 'C' OR SUBSTRING(CLASS_KEY,1,1) = 'N' -- Local classes GROUP BY STUDENT_ID, LTRIM(RTRIM(SUBSTRING(CLASS_KEY,12,6))) ) AH ON ( AH.STUDENT_ID = grad.STDNT_ID AND AH.TRM_YR <= grad.ACT_GRAD_TRM ) WHERE grad.ACT_GRAD_TRM IS NOT NULL AND grad.ACT_GRAD_TRM <> '' GROUP BY grad.STDNT_ID ,grad.PGM_ID ,grad.EFF_TERM ,grad.SEQ_NUM ,grad.ACT_GRAD_TRM ,ISNULL(grad.PGM_GPA,0) "

Jan 1 1900 12:00AM

Mar 4 2016 10:33AM