| Value |
 Expression: "
-- 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)
|
| Expression |
"
-- 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)
" |
Properties
