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
|
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 |