Variable - NewInsertDimEmployee

Property	Value
Name	NewInsertDimEmployee
Value	Expression: " /* SQL INSERT into DimEmployee from New Temp Table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimEmployee] (EmployeeAK ,PersonID ,EmployeeTypeCode ,EmployeeType ,FullName ,LastName ,FirstName ,MiddleInitial ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,StateCode ,State ,ZipCode ,CountyFIPSCode ,County ,CountryCode ,Country ,CitizenshipCode ,Citizenship ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HasActiveAssignment ,NumberOfActiveAssignments ,LastActiveAssignmentDateRange ,LastPayCheckDateRange ,PositionTypeCode ,PositionType ,FunctionCode ,FunctionDesc ,Locat / SQL INSERT into DimEmployee from New Temp Table */ INSERT INTO [EnterpriseDW].[dbo].[DimEmployee] (EmployeeAK ,PersonID ,EmployeeTypeCode ,EmployeeType ,FullName ,LastName ,FirstName ,MiddleInitial ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,StateCode ,State ,ZipCode ,CountyFIPSCode ,County ,CountryCode ,Country ,CitizenshipCode ,Citizenship ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HasActiveAssignment ,NumberOfActiveAssignments ,LastActiveAssignmentDateRange ,LastPayCheckDateRange ,PositionTypeCode ,PositionType ,FunctionCode ,FunctionDesc ,LocationCode ,Location ,PrimarySalaryAccountNumber ,IsAStudent ,EmployeeStudentId ,HasDirectDeposit ,HireDate ,EmployeeFulltimeParttime ,TerminationDate ,TerminationDateRange ,YearsOfServiceToInstitution ,DateOfBirth ,RowIsCurrent ,RowStartDate ,RowEndDate) SELECT EmployeeAK ,PersonID ,EmployeeTypeCode ,EmployeeType ,FullName ,LastName ,FirstName ,MiddleInitial ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,StateCode ,State ,ZipCode ,CountyFIPSCode ,County ,CountryCode ,Country ,CitizenshipCode ,Citizenship ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HasActiveAssignment ,NumberOfActiveAssignments ,LastActiveAssignmentDateRange ,LastPayCheckDateRange ,PositionTypeCode ,PositionType ,FunctionCode ,FunctionDesc ,LocationCode ,Location ,PrimarySalaryAccountNumber ,IsAStudent ,EmployeeStudentId ,HasDirectDeposit ,HireDate ,EmployeeFulltimeParttime ,TerminationDate ,TerminationDateRange ,YearsOfServiceToInstitution ,DateOfBirth ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [Staged_dbo_DimEmployee__New]
Value Type	String
Description	This variable contains the string that will be used to insert any new rows into the DimEmployee table.
System Variable	False
Namespace	User
Qualified Name	User::NewInsertDimEmployee
Evaluate As Expression	True
Expression	" /* SQL INSERT into DimEmployee from New Temp Table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimEmployee] (EmployeeAK ,PersonID ,EmployeeTypeCode ,EmployeeType ,FullName ,LastName ,FirstName ,MiddleInitial ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,StateCode ,State ,ZipCode ,CountyFIPSCode ,County ,CountryCode ,Country ,CitizenshipCode ,Citizenship ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HasActiveAssignment ,NumberOfActiveAssignments ,LastActiveAssignmentDateRange ,LastPayCheckDateRange ,PositionTypeCode ,PositionType ,FunctionCode ,FunctionDesc ,Locat
ID	926d2e73-a099-470e-b48f-c4bf129f6b69
Raise Changed Event	False