Variable - NewInsertDimStudent

Property	Value
Name	NewInsertDimStudent
Value	Expression: " /* SQL Insert into Staged DimStudent table / INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudent] ([StudentIdAK] ,[StudentId] ,[FullName] ,[LastName] ,[FirstName] ,[MiddleName] ,[GenderCode] ,[Gender] ,[EthnicityCode] ,[Ethnicity] ,[FirstTimeInCollege] ,[PrimaryLanguageCode] ,[PrimaryLanguage] ,[HighSchoolInstitutionId] ,[HighSchool] ,[HomePhoneNumber] ,[CellPhoneNumber] ,[InstitutionalEmailAddress] ,[PersonalEmailAddress] ,[ImmigrationStatusCode] ,[ImmigrationStatus] ,[ResidencyCode] ,[Residency] ,[ResidencyCountyCode] ,[ResidencyCounty] ,[ResidencyStateCode] ,[ResidencyState] ,[ZipCode] ,[Da / SQL Insert into Staged DimStudent table */ INSERT INTO [EnterpriseDW].[dbo].[DimStudent] ([StudentIdAK] ,[StudentId] ,[FullName] ,[LastName] ,[FirstName] ,[MiddleName] ,[GenderCode] ,[Gender] ,[EthnicityCode] ,[Ethnicity] ,[FirstTimeInCollege] ,[PrimaryLanguageCode] ,[PrimaryLanguage] ,[HighSchoolInstitutionId] ,[HighSchool] ,[HomePhoneNumber] ,[CellPhoneNumber] ,[InstitutionalEmailAddress] ,[PersonalEmailAddress] ,[ImmigrationStatusCode] ,[ImmigrationStatus] ,[ResidencyCode] ,[Residency] ,[ResidencyCountyCode] ,[ResidencyCounty] ,[ResidencyStateCode] ,[ResidencyState] ,[ZipCode] ,[DateOfBirth] ,[FERPARequested] ,[RaceWhite] ,[RaceAfricanAmerican] ,[RacePacificIslander] ,[RaceAsian] ,[RaceAmericanIndian] ,[RaceUnreported] ,[CountryOfBirthCode] ,[CountryOfBirth] ,[CountryOfCitizenshipCode] ,[CountryOfCitizenship] ,[HomeCampusCode] ,[HomeCampus] ,[InitialPrepStatus] ,[VeteranStudent] ,[StudentAthlete] ,[InternationalStudent] ,[RowIsCurrent] ,[RowStartDate] ,[RowEndDate]) SELECT StudentIdAK ,StudentId ,FullName ,LastName ,FirstName ,MiddleName ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,FirstTimeInCollege ,PrimaryLanguageCode ,PrimaryLanguage ,HighSchoolInstitutionId ,HighSchool ,HomePhoneNumber ,CellPhoneNumber ,InstitutionalEmailAddress ,PersonalEmailAddress ,ImmigrationStatusCode ,ImmigrationStatus ,ResidencyCode ,Residency ,ResidencyCountyCode ,ResidencyCounty ,ResidencyStateCode ,ResidencyState ,ZipCode ,DateOfBirth ,FERPARequested ,RaceWhite ,RaceAfricanAmerican ,RacePacificIslander ,RaceAsian ,RaceAmericanIndian ,RaceUnreported ,CountryOfBirthCode ,CountryOfBirth ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HomeCampusCode ,HomeCampus ,InitialPrepStatus ,VeteranStudent ,StudentAthlete ,InternationalStudent ,RowIsCurrent ,RowStartDate ,RowEndDate FROM [dbo].[Staged_dbo_DimStudent__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::NewInsertDimStudent
Evaluate As Expression	True
Expression	" /* SQL Insert into Staged DimStudent table */ INSERT INTO " + (@[User::EDWLinkedServerName] == "N/A" ? "" : "[" + @[User::EDWLinkedServerName]+"]." ) + "["+ @[User::EDWDBName] + "].[dbo].[DimStudent] ([StudentIdAK] ,[StudentId] ,[FullName] ,[LastName] ,[FirstName] ,[MiddleName] ,[GenderCode] ,[Gender] ,[EthnicityCode] ,[Ethnicity] ,[FirstTimeInCollege] ,[PrimaryLanguageCode] ,[PrimaryLanguage] ,[HighSchoolInstitutionId] ,[HighSchool] ,[HomePhoneNumber] ,[CellPhoneNumber] ,[InstitutionalEmailAddress] ,[PersonalEmailAddress] ,[ImmigrationStatusCode] ,[ImmigrationStatus] ,[ResidencyCode] ,[Residency] ,[ResidencyCountyCode] ,[ResidencyCounty] ,[ResidencyStateCode] ,[ResidencyState] ,[ZipCode] ,[Da
ID	1a9e45e9-006e-47b6-97cc-cc3daf5e3b1b
Raise Changed Event	False