DimProgramRetentionCohortLoad
 NewInsertDimProgramRetentionCohort (Variable)
  Properties
Property Value
Name NewInsertDimProgramRetentionCohort
Value Expression: " /* SQL INSERT into DimProgramRetentionCohort from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimProgramRetentionCohort] ( ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,SwitchedCIPCode ,SwitchedCIP ,RowIsCurrent ,RowStartDate ,RowEndDate ) SELECT ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,Switched

/* SQL INSERT into DimProgramRetentionCohort from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimProgramRetentionCohort] ( ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,SwitchedCIPCode ,SwitchedCIP ,RowIsCurrent ,RowStartDate ,RowEndDate ) SELECT ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,SwitchedCIPCode ,SwitchedCIP ,RowIsCurrent ,RowStartDate ,RowEndDate FROM Staged_dbo_DimProgramRetentionCohort__New
Value Type String
Description This variable contains the string that will be used to insert any new rows into the DimStudentTerm table.
System Variable False
Namespace User
Qualified Name User::NewInsertDimProgramRetentionCohort
Evaluate As Expression True
Expression " /* SQL INSERT into DimProgramRetentionCohort from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimProgramRetentionCohort] ( ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,SwitchedCIPCode ,SwitchedCIP ,RowIsCurrent ,RowStartDate ,RowEndDate ) SELECT ProgramRetentionCohortAK ,StudentId ,CohortTerm ,CohortTermTitle ,ProgramCode ,Program ,ProgramAdmitStatus ,AwardTypeCode ,AwardType ,CIPCode ,CIP ,AgeAtProgramRetentionCohort ,AgeRangeAtProgramRetentionCohort ,SwitchedProgramCode ,SwitchedProgram ,SwitchedTerm ,SwitchedTermTitle ,SwitchedAwardTypeCode ,SwitchedAwardType ,Switched
ID 926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event False
Powered by BI Documenter