|
![]() |
Property | Value |
Name | Copy_Enrollment |
Value | ![]() 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::TermList] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' " |
ID | 316bbdf1-ab80-41c8-a679-84c147df39ff |
Raise Changed Event | False |
Powered by BI Documenter |
|
![]() |
Property | Value |
Name | Copy_Enrollment |
Value | ![]() 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::TermList] + "' AND [REF_NUM] IS NOT NULL AND dbo.udf_StringToDate([LOG_DATE]) <= '" + @[User::CurrentDayDate] + "' " |
ID | 316bbdf1-ab80-41c8-a679-84c147df39ff |
Raise Changed Event | False |
Powered by BI Documenter |