Variable - NewInsertDimApplication

Property	Value
Name	NewInsertDimApplication
Value	Expression: " /* SQL Insert into Staged DimApplication table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimApplication] ([ApplicationAK] ,[StudentId] ,[ApplicationTerm] ,[ApplicationTermTitle] ,[ApplicationEntry] ,[ApplicationTypeCode] ,[ApplicationType] ,[CreditVocationalBachelorApplication] ,[InitialOrReadmitApplication] ,[BasisOfAdmissionCode] ,[BasisOfAdmission] ,[EnrollmentStatusCode] ,[EnrollmentStatus] ,[FirstTimeInCollege] ,[BachelorApplicant] ,[ProgramCode] ,[Program] ,[AwardTypeCode] ,[AwardType] ,[ApplicationDate] ,[FirstTermEnrolled] ,[FirstTermEnrolledTitle] ,[HomeCampusCode] ,[HomeCampus] ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT ApplicationAK ,StudentId ,ApplicationTerm ,ApplicationTermTitle ,Applic / SQL Insert into Staged DimApplication table */ INSERT INTO [EnterpriseDW].[dbo].[DimApplication] ([ApplicationAK] ,[StudentId] ,[ApplicationTerm] ,[ApplicationTermTitle] ,[ApplicationEntry] ,[ApplicationTypeCode] ,[ApplicationType] ,[CreditVocationalBachelorApplication] ,[InitialOrReadmitApplication] ,[BasisOfAdmissionCode] ,[BasisOfAdmission] ,[EnrollmentStatusCode] ,[EnrollmentStatus] ,[FirstTimeInCollege] ,[BachelorApplicant] ,[ProgramCode] ,[Program] ,[AwardTypeCode] ,[AwardType] ,[ApplicationDate] ,[FirstTermEnrolled] ,[FirstTermEnrolledTitle] ,[HomeCampusCode] ,[HomeCampus] ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT ApplicationAK ,StudentId ,ApplicationTerm ,ApplicationTermTitle ,ApplicationEntry ,ApplicationTypeCode ,ApplicationType ,CreditVocationalBachelorApplication ,InitialOrReadmitApplication ,BasisOfAdmissionCode ,BasisOfAdmission ,EnrollmentStatusCode ,EnrollmentStatus ,FirstTimeInCollege ,BachelorApplicant ,ProgramCode ,Program ,AwardTypeCode ,AwardType ,ApplicationDate ,FirstTermEnrolled ,FirstTermEnrolledTitle ,HomeCampusCode ,HomeCampus ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [dbo].[Staged_dbo_DimApplication__New]
Value Type	String
Description	The SQL statement that will insert the data into the DimStudent table.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimApplication
Evaluate As Expression	True
Expression	" /* SQL Insert into Staged DimApplication table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimApplication] ([ApplicationAK] ,[StudentId] ,[ApplicationTerm] ,[ApplicationTermTitle] ,[ApplicationEntry] ,[ApplicationTypeCode] ,[ApplicationType] ,[CreditVocationalBachelorApplication] ,[InitialOrReadmitApplication] ,[BasisOfAdmissionCode] ,[BasisOfAdmission] ,[EnrollmentStatusCode] ,[EnrollmentStatus] ,[FirstTimeInCollege] ,[BachelorApplicant] ,[ProgramCode] ,[Program] ,[AwardTypeCode] ,[AwardType] ,[ApplicationDate] ,[FirstTermEnrolled] ,[FirstTermEnrolledTitle] ,[HomeCampusCode] ,[HomeCampus] ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT ApplicationAK ,StudentId ,ApplicationTerm ,ApplicationTermTitle ,Applic
ID	3a70ca6a-0e32-4ca3-abaf-21c0c20db4d9
Raise Changed Event	False