SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog WHERE EFF_TRM = '' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '2016-03-04'

"SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG_ARCH_A] st_clslog WHERE EFF_TRM = '" + @[User::TermResults] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' "

This variable contains the Select Statement to copy Prior Year Enrollment from Archived Stdnt Class Log in Staging to DWOperations

SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog WHERE EFF_TRM = '' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '2016-03-04'

"SELECT st_clslog.STDNT_ID ,st_clslog.EFF_TRM ,st_clslog.REF_NUM ,st_clslog.LOG_DATE ,ISNULL(st_clslog.LOG_TIME,0) AS LOG_TIME ,st_clslog.NOT_PAID_FLG ,st_clslog.TRNSCTN_TY FROM [dbo].[ST_STDNT_CLS_LOG] st_clslog WHERE EFF_TRM = '" + @[User::TermResults] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' "

This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations

2016-03-04

This is a configuration setting in SSIS_Configurations that is set to the date that the package is being executed on.

System.Object

This contains the Active Terms returned from a SQL select statement.

EXEC dbo.usp_FactEnrollmentSS_Select '2016-03-04' , ''

"EXEC dbo.usp_FactEnrollmentSS_Select '" + @[User::CurrentDayDate] + "' , '" + @[User::TermResults] + "'"

This is the SQL statement to execute a Stored Procedure to retrieve data from the Student Class Log file in the source system.

This variable is used in a For Each Loop container to extract data for each active term.