Data Flow Task

Data Flow Task

Data Flow Task

Data Flow Task

Task

Execute SQL Task

Task

Execute SQL Task

EnterpriseDW

N/A

If the Enterprise Data Warehouse resides on a different server from the DWStaging and DWoperations databases, a linked server must be defined and the name populated into the Var_EDWLinkedServername. If it resides on the same server, this setting must be set to ?N/A?. This is a configuration setting from SSIS_Configurations.

exec usp_FactProgramRetentionSnapshot_Select

"/* This table will contain all students from the End Of Term table and their real cohort terms. */ CREATE TABLE #student_cohort_temp ( [StudentId] VARCHAR(9) NOT NULL ,[CohortTerm] VARCHAR(6) NOT NULL ) INSERT INTO #student_cohort_temp ( [StudentId] ,[CohortTerm] ) /* Determine the students and their cohort term from the Student End Of Term table */ SELECT EOT.STDNT_ID AS StudentId ,MIN(AH.CohortTerm) AS CohortTerm FROM ST_STDNT_ENDOFTERM_A EOT /* Join on set of students that completed a local credit class after the HS Grad Date */ /* The earliest such term is their cohort term. */ INNER JOIN ( /* Get first term that the student took a credit class after HS Graduation. This is Cohort Term. */ SELECT AH2.STUDENT_ID ,MIN(AH2.AH_TERM) AS CohortTerm FROM ( /* Join AH with Student to get AH local credit classes taken after HS Grad Date */ SELECT AH1.STUDENT_ID, RTRIM(SUBSTRING(CLASS_KEY,12,6)) AS AH_TERM FROM ST_ACDMC_HIST