Variable - SQLRelativeDaySource

Property	Value
Name	SQLRelativeDaySource
Value	Expression: "/* Primary SELECT for the Relative Day Dimension / SELECT CAST( CASE WHEN RelDay.SeqNumber < 0 THEN ((LEFT(Term.TRM_YR,4) 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * -1 * 1000000)) * -1 ELSE (LEFT(Term.TRM_YR,4) * 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * 1000000) END AS INT ) AS SRCRelativeDaySK ,LTRIM(RTRIM(CAST(Term.TRM_YR AS varchar(6)))) AS SRCTerm ,CAST(LEFT(Term.TRM_YR,4) AS varchar(4)) AS SRCTermYear ,CAST(SUBSTRING(Term.TRM_YR,5,1) AS varchar(3)) AS SRCTermTypeCode ,LTRIM(RTRIM(CAST(Term.TRM_TTL AS varchar(30)))) AS SRCTermTitle ,CAST(RelDay.SeqNumber AS INT) AS SRCRelativeDayNumber ,'Day ' + CAST(RelDay.SeqNumber AS varchar(11)) AS SRCRelativeDay ,CAST(dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber AS DATE) AS SRCRelativeDayDate ,CONVERT (varchar(8),dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber,112) AS SRCRelativeDayDateSK /* T /* Primary SELECT for the Relative Day Dimension / SELECT CAST( CASE WHEN RelDay.SeqNumber < 0 THEN ((LEFT(Term.TRM_YR,4) 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * -1 * 1000000)) * -1 ELSE (LEFT(Term.TRM_YR,4) * 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * 1000000) END AS INT ) AS SRCRelativeDaySK ,LTRIM(RTRIM(CAST(Term.TRM_YR AS varchar(6)))) AS SRCTerm ,CAST(LEFT(Term.TRM_YR,4) AS varchar(4)) AS SRCTermYear ,CAST(SUBSTRING(Term.TRM_YR,5,1) AS varchar(3)) AS SRCTermTypeCode ,LTRIM(RTRIM(CAST(Term.TRM_TTL AS varchar(30)))) AS SRCTermTitle ,CAST(RelDay.SeqNumber AS INT) AS SRCRelativeDayNumber ,'Day ' + CAST(RelDay.SeqNumber AS varchar(11)) AS SRCRelativeDay ,CAST(dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber AS DATE) AS SRCRelativeDayDate ,CONVERT (varchar(8),dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber,112) AS SRCRelativeDayDateSK /* Term and Session information exists in the Staged TermSession Table / FROM dbo.Staged_TermSessionTempTable Term / Cross Join with the Sequential Numbers Table / CROSS JOIN Lookup_SequentialNbrs RelDay / Select the two years of Relative Days / WHERE (RelDay.SeqNumber >= -365 and RelDay.SeqNumber <= 365) / Order by Term and Relative Day number for processing */ ORDER BY Term.TRM_YR ,RelDay.SeqNumber
Value Type	String
Description	This variable contain the SQL statement to extract the data for the Term dimension from the source system.
System Variable	False
Namespace	User
Qualified Name	User::SQLRelativeDaySource
Evaluate As Expression	True
Expression	"/* Primary SELECT for the Relative Day Dimension / SELECT CAST( CASE WHEN RelDay.SeqNumber < 0 THEN ((LEFT(Term.TRM_YR,4) 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * -1 * 1000000)) * -1 ELSE (LEFT(Term.TRM_YR,4) * 100 ) + SUBSTRING(Term.TRM_YR,5,1) + (RelDay.SeqNumber * 1000000) END AS INT ) AS SRCRelativeDaySK ,LTRIM(RTRIM(CAST(Term.TRM_YR AS varchar(6)))) AS SRCTerm ,CAST(LEFT(Term.TRM_YR,4) AS varchar(4)) AS SRCTermYear ,CAST(SUBSTRING(Term.TRM_YR,5,1) AS varchar(3)) AS SRCTermTypeCode ,LTRIM(RTRIM(CAST(Term.TRM_TTL AS varchar(30)))) AS SRCTermTitle ,CAST(RelDay.SeqNumber AS INT) AS SRCRelativeDayNumber ,'Day ' + CAST(RelDay.SeqNumber AS varchar(11)) AS SRCRelativeDay ,CAST(dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber AS DATE) AS SRCRelativeDayDate ,CONVERT (varchar(8),dbo.udf_StringToDate(Sess_BEG_DT) + RelDay.SeqNumber,112) AS SRCRelativeDayDateSK /* T
ID	c95b758c-5904-4384-904f-6deb186279a6
Raise Changed Event	False