Variable - NewInsertDimCurriculum

Property	Value
Name	NewInsertDimCurriculum
Value	Expression: " /* SQL Insert into DimCurriculum from New Temp Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCurriculum] ( ReferenceNumberAK ,ReferenceNumber ,Term ,TermTitle ,CourseId ,CurrentTerm ,CurrentCourseId ,CourseIdPrefix ,ClassTitle ,CourseTypeCode ,CourseType ,CreditNonCreditVocational ,CreditTypeCode ,CreditType ,CreditNonCredit ,ICSCode ,InstructionalClassification ,DivisionCode ,Division ,DepartmentCode ,Department ,CampusCode ,Campus ,CenterCode ,Center ,MinimumClassSize ,MaximumClassSize ,ClassStatusCode ,ClassStatus ,TimeBlockCode ,TimeBlock / SQL Insert into DimCurriculum from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimCurriculum] ( ReferenceNumberAK ,ReferenceNumber ,Term ,TermTitle ,CourseId ,CurrentTerm ,CurrentCourseId ,CourseIdPrefix ,ClassTitle ,CourseTypeCode ,CourseType ,CreditNonCreditVocational ,CreditTypeCode ,CreditType ,CreditNonCredit ,ICSCode ,InstructionalClassification ,DivisionCode ,Division ,DepartmentCode ,Department ,CampusCode ,Campus ,CenterCode ,Center ,MinimumClassSize ,MaximumClassSize ,ClassStatusCode ,ClassStatus ,TimeBlockCode ,TimeBlock ,DeliveryMethod ,PrimaryInstructorId ,PrimaryInstructorFullName ,PrimaryInstructorLastName ,PrimaryInstructorFirstName ,PrimaryInstructorMiddleInitial ,SessionCode ,Session ,Honors ,WeekendCollege ,DualEnrollment ,IndependentStudy ,Apprenticeship ,VirtualCollege ,Online100Percent ,WebEnabled ,WebBlended ,ScheduleInformation ,PrimaryInstructorType ,ICSCategoryCode ,InstructionalClassificationCategory ,TermCourseIdCount ,IsTermCourseIdCountGE10 ,IsCourseRepeatable ,CourseNumberTimesForCredit ,RowIsCurrent ,RowStartDate ,RowEndDate ,CourseLevel ,CreditNonCreditVocationalTest ,DivisionDescription, DepartmentDescription ) SELECT ReferenceNumberAK ,ReferenceNumber ,Term ,TermTitle ,CourseId ,CurrentTerm ,CurrentCourseId ,CourseIdPrefix ,ClassTitle ,CourseTypeCode ,CourseType ,CreditNonCreditVocational ,CreditTypeCode ,CreditType ,CreditNonCredit ,ICSCode ,InstructionalClassification ,DivisionCode ,Division ,DepartmentCode ,Department ,CampusCode ,Campus ,CenterCode ,Center ,MinimumClassSize ,MaximumClassSize ,ClassStatusCode ,ClassStatus ,TimeBlockCode ,TimeBlock ,DeliveryMethod ,PrimaryInstructorId ,PrimaryInstructorFullName ,PrimaryInstructorLastName ,PrimaryInstructorFirstName ,PrimaryInstructorMiddleInitial ,SessionCode ,Session ,Honors ,WeekendCollege ,DualEnrollment ,IndependentStudy ,Apprenticeship ,VirtualCollege ,Online100Percent ,WebEnabled ,WebBlended ,ScheduleInformation ,PrimaryInstructorType ,ICSCategoryCode ,InstructionalClassificationCategory ,TermCourseIdCount ,IsTermCourseIdCountGE10 ,IsCourseRepeatable ,CourseNumberTimesForCredit ,RowIsCurrent ,RowStartDate ,RowEndDate ,CourseLevel ,CreditNonCreditVocationalTest, DivisionDescription, DepartmentDescription FROM [dbo].[Staged_dbo_DimCurriculum__New]
Value Type	String
Description	This is the SQL statement to insert the new records into DimCurriculum.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimCurriculum
Evaluate As Expression	True
Expression	" /* SQL Insert into DimCurriculum from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimCurriculum] ( ReferenceNumberAK ,ReferenceNumber ,Term ,TermTitle ,CourseId ,CurrentTerm ,CurrentCourseId ,CourseIdPrefix ,ClassTitle ,CourseTypeCode ,CourseType ,CreditNonCreditVocational ,CreditTypeCode ,CreditType ,CreditNonCredit ,ICSCode ,InstructionalClassification ,DivisionCode ,Division ,DepartmentCode ,Department ,CampusCode ,Campus ,CenterCode ,Center ,MinimumClassSize ,MaximumClassSize ,ClassStatusCode ,ClassStatus ,TimeBlockCode ,TimeBlock
ID	91a7b6f7-aba1-4ce2-a58e-6db8925f47a2
Raise Changed Event	False