Variable - Copy_Enrollment

Property	Value
Name	Copy_Enrollment
Value	Expression: "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] + "' " 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'
Value Type	String
Description	This variable contains the Select Statement to copy Prior Year Enrollment from Staging to DWOperations
System Variable	False
Namespace	User
Qualified Name	User::Copy_Enrollment
Evaluate As Expression	True
Expression	"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] + "' "
ID	c8cdd87a-23cb-49ce-b09e-fce9b122cb8d
Raise Changed Event	False