Variable - SCD1UpdateDimProgramRetentionCohort

Property	Value
Name	SCD1UpdateDimProgramRetentionCohort
Value	Expression: " /* Sample Update Type1 to Dim / UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimProgramRetentionCohort] SET ProgramRetentionCohortAK = SCD1.ProgramRetentionCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, CIPCode = SCD1.CIPCode, CIP = SCD1.CIP, AgeAtProgramRetentionCohort = SCD1.AgeAtProgramRetentionCohort, AgeRangeAtProgramRetentionCohort = SCD1.AgeRangeAtProgramRetentionCohort, SwitchedProgramCode = SCD1.SwitchedProgramCode, SwitchedProgram = SCD1.SwitchedProgram, SwitchedTerm = SCD1.SwitchedTerm, SwitchedTermTitle = SCD1.SwitchedTermTitle, SwitchedAwardTypeCode = SCD1.SwitchedAwardTypeCode, SwitchedAwardType = SCD1.SwitchedAwardType, SwitchedCIPCode = SCD1.SwitchedCIPCod / Sample Update Type1 to Dim */ UPDATE [EnterpriseDW].[dbo].[DimProgramRetentionCohort] SET ProgramRetentionCohortAK = SCD1.ProgramRetentionCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, CIPCode = SCD1.CIPCode, CIP = SCD1.CIP, AgeAtProgramRetentionCohort = SCD1.AgeAtProgramRetentionCohort, AgeRangeAtProgramRetentionCohort = SCD1.AgeRangeAtProgramRetentionCohort, SwitchedProgramCode = SCD1.SwitchedProgramCode, SwitchedProgram = SCD1.SwitchedProgram, SwitchedTerm = SCD1.SwitchedTerm, SwitchedTermTitle = SCD1.SwitchedTermTitle, SwitchedAwardTypeCode = SCD1.SwitchedAwardTypeCode, SwitchedAwardType = SCD1.SwitchedAwardType, SwitchedCIPCode = SCD1.SwitchedCIPCode, SwitchedCIP = SCD1.SwitchedCIP FROM [EnterpriseDW].[dbo].[DimProgramRetentionCohort] AS [DIM] INNER JOIN [dbo].[Staged_dbo_DimProgramRetentionCohort__Type1Update] AS SCD1 ON Dim.ProgramRetentionCohortAK = SCD1.ProgramRetentionCohortAK
Value Type	String
Description	The SQL string that will update any changed rows in the DimStudentTerm dimension.
System Variable	False
Namespace	User
Qualified Name	User::SCD1UpdateDimProgramRetentionCohort
Evaluate As Expression	True
Expression	" /* Sample Update Type1 to Dim */ UPDATE " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimProgramRetentionCohort] SET ProgramRetentionCohortAK = SCD1.ProgramRetentionCohortAK, StudentId = SCD1.StudentId, CohortTerm = SCD1.CohortTerm, CohortTermTitle = SCD1.CohortTermTitle, ProgramCode = SCD1.ProgramCode, Program = SCD1.Program, ProgramAdmitStatus = SCD1.ProgramAdmitStatus, AwardTypeCode = SCD1.AwardTypeCode, AwardType = SCD1.AwardType, CIPCode = SCD1.CIPCode, CIP = SCD1.CIP, AgeAtProgramRetentionCohort = SCD1.AgeAtProgramRetentionCohort, AgeRangeAtProgramRetentionCohort = SCD1.AgeRangeAtProgramRetentionCohort, SwitchedProgramCode = SCD1.SwitchedProgramCode, SwitchedProgram = SCD1.SwitchedProgram, SwitchedTerm = SCD1.SwitchedTerm, SwitchedTermTitle = SCD1.SwitchedTermTitle, SwitchedAwardTypeCode = SCD1.SwitchedAwardTypeCode, SwitchedAwardType = SCD1.SwitchedAwardType, SwitchedCIPCode = SCD1.SwitchedCIPCod
ID	d46fb6fd-e48a-41c9-b823-d24774e927d3
Raise Changed Event	False