DimStudentLoad
 TF_SCD Student Slowly Changing Dimension Process (Component)
  Properties
Property Value
Name TF_SCD Student Slowly Changing Dimension Process
Description
Up Stream Components
Down Stream Components
ID 1067
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF_SCD Student Slowly Changing Dimension Process" (1067)
Is Default Locale True
Pipeline Version 0
Uses Dispositions False
Validate External Metadata True
Version 11
  Connections
Name Connection Manager Description
  Custom Properties
Name Value
(Obsolete) Route Deleted Rows to SCD2 Expired Output
False
(Obsolete) Route SCD2New Rows to New Output
False
Audit Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>Auditing</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1154</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1155</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1156</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1157</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1158</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1159</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1160</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1161</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1162</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1163</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1164</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1165</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1166</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1167</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1168</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1169</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1170</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1171</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1172</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1173</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1174</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1175</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Number of rows held in cache on first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1176</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1177</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1178</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1179</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1180</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1181</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1182</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1183</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum Output Rows per Second</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Debugging Messages
Deleted Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>1399</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1400</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1401</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1402</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1403</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1404</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1405</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1406</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1407</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1408</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1409</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1410</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1411</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1412</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1413</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1414</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1415</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1416</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1417</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1418</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1420</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1421</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1422</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1423</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1424</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1425</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1426</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1427</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1428</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1429</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1430</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1431</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1432</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1433</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1434</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1435</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1436</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1437</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1438</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1439</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2077</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2078</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2079</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2080</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3003</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3004</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3005</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3006</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3119</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3120</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Deleted Output Counter
Error Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1152</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1153</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1563</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1564</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1565</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1566</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1567</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1568</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1569</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1570</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1571</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1572</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1573</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1574</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1575</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1576</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1577</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1578</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1579</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1580</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1581</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1582</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1584</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1585</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1586</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1587</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1588</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1589</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1590</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1591</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1592</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1593</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1594</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1595</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1596</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1597</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1598</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1599</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1600</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1601</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1602</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1603</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2093</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2094</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2095</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2096</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3025</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3026</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3027</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3028</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3133</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3134</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentIdAK</SourceSystemColumnName><SourceSystemLineageID>892</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentIdAK</Name><LineageID>763</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastName</SourceSystemColumnName><SourceSystemLineageID>894</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LastName</Name><LineageID>772</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstName</SourceSystemColumnName><SourceSystemLineageID>896</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstName</Name><LineageID>775</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MiddleName</SourceSystemColumnName><SourceSystemLineageID>898</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>MiddleName</Name><LineageID>778</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GenderCode</SourceSystemColumnName><SourceSystemLineageID>900</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GenderCode</Name><LineageID>781</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Gender</SourceSystemColumnName><SourceSystemLineageID>902</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Gender</Name><LineageID>784</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EthnicityCode</SourceSystemColumnName><SourceSystemLineageID>904</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EthnicityCode</Name><LineageID>787</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Ethnicity</SourceSystemColumnName><SourceSystemLineageID>906</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Ethnicity</Name><LineageID>790</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstTimeInCollege</SourceSystemColumnName><SourceSystemLineageID>908</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstTimeInCollege</Name><LineageID>793</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryLanguage</SourceSystemColumnName><SourceSystemLineageID>910</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrimaryLanguage</Name><LineageID>799</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCode</SourceSystemColumnName><SourceSystemLineageID>912</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCode</Name><LineageID>826</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Residency</SourceSystemColumnName><SourceSystemLineageID>914</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Residency</Name><LineageID>829</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ZipCode</SourceSystemColumnName><SourceSystemLineageID>916</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ZipCode</Name><LineageID>844</LineageID><DataType>129</DataType><Length>11</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateOfBirth</SourceSystemColumnName><SourceSystemLineageID>918</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DateOfBirth</Name><LineageID>847</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceWhite</SourceSystemColumnName><SourceSystemLineageID>920</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceWhite</Name><LineageID>853</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAfricanAmerican</SourceSystemColumnName><SourceSystemLineageID>922</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAfricanAmerican</Name><LineageID>856</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RacePacificIslander</SourceSystemColumnName><SourceSystemLineageID>924</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RacePacificIslander</Name><LineageID>859</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAsian</SourceSystemColumnName><SourceSystemLineageID>926</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAsian</Name><LineageID>862</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAmericanIndian</SourceSystemColumnName><SourceSystemLineageID>928</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAmericanIndian</Name><LineageID>865</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceUnreported</SourceSystemColumnName><SourceSystemLineageID>930</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceUnreported</Name><LineageID>868</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentId</SourceSystemColumnName><SourceSystemLineageID>934</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentId</Name><LineageID>766</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FullName</SourceSystemColumnName><SourceSystemLineageID>936</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FullName</Name><LineageID>769</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryLanguageCode</SourceSystemColumnName><SourceSystemLineageID>938</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrimaryLanguageCode</Name><LineageID>796</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HighSchoolInstitutionId</SourceSystemColumnName><SourceSystemLineageID>940</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HighSchoolInstitutionId</Name><LineageID>802</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HighSchool</SourceSystemColumnName><SourceSystemLineageID>942</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HighSchool</Name><LineageID>805</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomePhoneNumber</SourceSystemColumnName><SourceSystemLineageID>944</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomePhoneNumber</Name><LineageID>808</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CellPhoneNumber</SourceSystemColumnName><SourceSystemLineageID>946</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CellPhoneNumber</Name><LineageID>811</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InstitutionalEmailAddress</SourceSystemColumnName><SourceSystemLineageID>948</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InstitutionalEmailAddress</Name><LineageID>814</LineageID><DataType>129</DataType><Length>75</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PersonalEmailAddress</SourceSystemColumnName><SourceSystemLineageID>950</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PersonalEmailAddress</Name><LineageID>817</LineageID><DataType>129</DataType><Length>75</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ImmigrationStatusCode</SourceSystemColumnName><SourceSystemLineageID>952</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ImmigrationStatusCode</Name><LineageID>820</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ImmigrationStatus</SourceSystemColumnName><SourceSystemLineageID>954</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ImmigrationStatus</Name><LineageID>823</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCountyCode</SourceSystemColumnName><SourceSystemLineageID>956</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCountyCode</Name><LineageID>832</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCounty</SourceSystemColumnName><SourceSystemLineageID>958</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCounty</Name><LineageID>835</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyStateCode</SourceSystemColumnName><SourceSystemLineageID>960</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyStateCode</Name><LineageID>838</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyState</SourceSystemColumnName><SourceSystemLineageID>962</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyState</Name><LineageID>841</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FERPARequested</SourceSystemColumnName><SourceSystemLineageID>964</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FERPARequested</Name><LineageID>850</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfBirthCode</SourceSystemColumnName><SourceSystemLineageID>966</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfBirthCode</Name><LineageID>871</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfBirth</SourceSystemColumnName><SourceSystemLineageID>968</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfBirth</Name><LineageID>874</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenshipCode</SourceSystemColumnName><SourceSystemLineageID>970</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfCitizenshipCode</Name><LineageID>877</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenship</SourceSystemColumnName><SourceSystemLineageID>972</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfCitizenship</Name><LineageID>880</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentSK</Name><LineageID>760</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>883</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>886</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>889</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InitialPrepStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2911</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InitialPrepStatus</Name><LineageID>2923</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>VeteranStudent</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2914</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>VeteranStudent</Name><LineageID>2926</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentAthlete</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2917</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentAthlete</Name><LineageID>2929</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InternationalStudent</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2920</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InternationalStudent</Name><LineageID>2932</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomeCampusCode</SourceSystemColumnName><SourceSystemLineageID>3046</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomeCampusCode</Name><LineageID>3052</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomeCampus</SourceSystemColumnName><SourceSystemLineageID>3049</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomeCampus</Name><LineageID>3055</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition>
Existing Dimension Input Counter
Expired SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1150</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1481</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1482</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1483</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1484</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1485</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1486</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1487</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1488</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1489</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1490</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1491</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1492</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1493</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1494</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1495</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1496</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1497</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1498</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1499</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1500</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1502</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1503</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1504</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1505</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1506</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1507</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1508</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1509</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1510</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1511</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1512</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1513</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1514</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1515</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1516</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1517</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1518</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1519</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1520</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1521</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2085</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2086</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2087</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2088</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3013</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3014</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3015</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3016</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3125</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3126</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Expired SCD2 Output Counter
Hashing Algorithm
0
Inferred Member False Value for Integer
1
Inferred Member False Value for Strings
N
Inferred Member True Value for Integer
0
Inferred Member True Value for Strings
Y
Invalid Input Output Counter
Last Window Size
0,0
Manage Surrogate Keys
False
New Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1148</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1356</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1357</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1358</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1359</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1360</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1361</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1362</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1363</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1364</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1365</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1366</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1367</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1368</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1369</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1370</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1371</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1372</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1373</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1374</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1375</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1377</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1378</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1379</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1380</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1381</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1382</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1383</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1384</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1385</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1386</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1387</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1388</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1389</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1390</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1391</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1392</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1393</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1394</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1395</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1396</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2073</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2074</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2075</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2076</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2997</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2998</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2999</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3000</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3115</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3116</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New Output Counter
New SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1151</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1522</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1523</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1524</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1525</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1526</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1527</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1528</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1529</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1530</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1531</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1532</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1533</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1534</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1535</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1536</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1537</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1538</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1539</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1540</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1541</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1543</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1544</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1545</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1546</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1547</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1548</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1549</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1550</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1551</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1552</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1553</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1554</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1555</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1556</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1557</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1558</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1559</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1560</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1561</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1562</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2089</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2090</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2091</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2092</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3019</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3020</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3021</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3022</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3129</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3130</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New SCD2 Output Counter
Number of Processing Threads
2
Processing Timeout
3600
SCD2 Current Member False Value for Integer
1
SCD2 Current Member False Value for Strings
N
SCD2 Current Member True Value for Integer
0
SCD2 Current Member True Value for Strings
Y
SCD2 Date Millisecond Precision
3
SCD2 Desired Expiry For Current Records
2
SCD2 Expiry Date Variable
SCD2 Gap Granularity
2
SCD2 Gap Offset
1
SCD2 Now Variable
System::ContainerStartTime
SCD2 Specific Expiry Date
<?xml version="1.0" encoding="utf-16"?><ArrayOfLong />
Source System Input Counter
Source System Lineages
<?xml version="1.0" encoding="utf-16"?><ArrayOfString><string>#892</string><string>#894</string><string>#896</string><string>#898</string><string>#900</string><string>#902</string><string>#904</string><string>#906</string><string>#908</string><string>#910</string><string>#912</string><string>#914</string><string>#916</string><string>#918</string><string>#920</string><string>#922</string><string>#924</string><string>#926</string><string>#928</string><string>#930</string><string>#932</string><string>#934</string><string>#936</string><string>#938</string><string>#940</string><string>#942</string><string>#944</string><string>#946</string><string>#948</string><string>#950</string><string>#952</string><string>#954</string><string>#956</string><string>#958</string><string>#960</string><string>#962</string><string>#964</string><string>#966</string><string>#968</string><string>#970</string><string>#972</string><string>#2911</string><string>#2914</string><string>#2917</string><string>#2920</string><string>#3046</string><string>#3049</string></ArrayOfString>
Special Members Input Counter
Special Members Lineages
<?xml version="1.0" encoding="utf-16"?><ArrayOfString />
Statistics Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>None</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1184</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1185</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1186</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1187</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1188</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1189</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1190</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1191</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1192</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1193</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1194</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1195</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1196</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1197</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1198</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1199</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1200</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1201</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1202</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1203</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1204</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1205</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1206</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1207</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1208</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1209</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1210</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Input Waiting On Row Processing</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Suppress Warnings About Optimizing Performance Through Sorted Inputs
False
Suppress Warnings About Optimizing Performance Through Surrogate Key Configuration
False
Suppress Warnings About Surrogate Key Configuration
False
Surrogate Key Increment
1
Surrogate Key Increment By Variable?
False
Surrogate Key Increment Variable
Surrogate Key Seed
0
Surrogate Key Seed By Variable?
False
Surrogate Key Seed Variable
Surrogate Key Seed Variable Guaranteed
False
Unchanged Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>1315</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1316</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1317</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1318</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1319</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1320</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1321</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1322</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1323</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1324</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1325</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1326</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1327</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1328</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1329</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1330</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1331</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1332</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1333</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1334</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1336</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1337</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1338</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1339</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1340</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1341</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1342</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1343</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1344</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1345</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1346</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1347</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1348</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1349</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1350</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1351</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1352</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1353</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1354</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1355</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2069</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2070</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2071</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2072</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2993</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2994</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2995</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2996</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3113</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3114</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Unchanged Output Counter
Update SCD1 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1149</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1440</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1441</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1442</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1443</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1444</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1445</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1446</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1447</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1448</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1449</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1450</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1451</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1452</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1453</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1454</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1455</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1456</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1457</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1458</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1459</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1461</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1462</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1463</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1464</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1465</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1466</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1467</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1468</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1469</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1470</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1471</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1472</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1473</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1474</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1475</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1476</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1477</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1478</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1479</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1480</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2081</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2082</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2083</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2084</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3007</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3008</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3009</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3010</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3121</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3122</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Updated SCD1 Output Counter
UserComponentTypeName
PW.TaskFactory.DimensionMerge.DimensionMergeSCD, PW.TaskFactory.DimensionMergeSCD100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=47acf905d0337c39
  Input Columns
Name ID LineageID
CellPhoneNumber
2042
811
CountryOfBirth
2063
874
CountryOfBirthCode
2062
871
CountryOfCitizenship
2065
880
CountryOfCitizenshipCode
2064
877
DateOfBirth
2054
847
Ethnicity
2035
790
EthnicityCode
2034
787
FERPARequested
2055
850
FirstName
2030
775
FirstTimeInCollege
2036
793
FullName
2028
769
Gender
2033
784
GenderCode
2032
781
HighSchool
2040
805
HighSchoolInstitutionId
2039
802
HomeCampus
3108
3055
HomeCampusCode
3107
3052
HomePhoneNumber
2041
808
ImmigrationStatus
2046
823
ImmigrationStatusCode
2045
820
InitialPrepStatus
2983
2923
InstitutionalEmailAddress
2043
814
InternationalStudent
2986
2932
LastName
2029
772
MiddleName
2031
778
PersonalEmailAddress
2044
817
PrimaryLanguage
2038
799
PrimaryLanguageCode
2037
796
RaceAfricanAmerican
2057
856
RaceAmericanIndian
2060
865
RaceAsian
2059
862
RacePacificIslander
2058
859
RaceUnreported
2061
868
RaceWhite
2056
853
Residency
2048
829
ResidencyCode
2047
826
ResidencyCounty
2050
835
ResidencyCountyCode
2049
832
ResidencyState
2052
841
ResidencyStateCode
2051
838
RowEndDate
2068
889
RowIsCurrent
2066
883
RowStartDate
2067
886
StudentAthlete
2985
2929
StudentId
2027
766
StudentIdAK
2026
763
StudentSK
2025
760
VeteranStudent
2984
2926
ZipCode
2053
844
CellPhoneNumber
2437
946
CountryOfBirth
2448
968
CountryOfBirthCode
2447
966
CountryOfCitizenship
2450
972
CountryOfCitizenshipCode
2449
970
DateOfBirth
2424
918
Ethnicity
2418
906
EthnicityCode
2417
904
FERPARequested
2446
964
FirstName
2413
896
FirstTimeInCollege
2419
908
FullName
2432
936
Gender
2416
902
GenderCode
2415
900
HighSchool
2435
942
HighSchoolInstitutionId
2434
940
HomeCampus
3110
3049
HomeCampusCode
3109
3046
HomePhoneNumber
2436
944
ImmigrationStatus
2441
954
ImmigrationStatusCode
2440
952
InitialPrepStatus
2987
2911
InstitutionalEmailAddress
2438
948
InternationalStudent
2990
2920
LastName
2412
894
MiddleName
2414
898
PersonalEmailAddress
2439
950
PrimaryLanguage
2420
910
PrimaryLanguageCode
2433
938
RaceAfricanAmerican
2426
922
RaceAmericanIndian
2429
928
RaceAsian
2428
926
RacePacificIslander
2427
924
RaceUnreported
2430
930
RaceWhite
2425
920
Residency
2422
914
ResidencyCode
2421
912
ResidencyCounty
2443
958
ResidencyCountyCode
2442
956
ResidencyState
2445
962
ResidencyStateCode
2444
960
StudentAthlete
2989
2917
StudentId
2431
934
StudentIdAK
2411
892
VeteranStudent
2988
2914
ZipCode
2423
916
  Output Columns
Name ID LineageID
CellPhoneNumber
1383
1383
CountryOfBirth
1394
1394
CountryOfBirthCode
1393
1393
CountryOfCitizenship
1396
1396
CountryOfCitizenshipCode
1395
1395
DateOfBirth
1369
1369
Ethnicity
1363
1363
EthnicityCode
1362
1362
FERPARequested
1392
1392
FirstName
1358
1358
FirstTimeInCollege
1364
1364
FullName
1378
1378
Gender
1361
1361
GenderCode
1360
1360
HighSchool
1381
1381
HighSchoolInstitutionId
1380
1380
HomeCampus
3116
3116
HomeCampusCode
3115
3115
HomePhoneNumber
1382
1382
ImmigrationStatus
1387
1387
ImmigrationStatusCode
1386
1386
InitialPrepStatus
2997
2997
InstitutionalEmailAddress
1384
1384
InternationalStudent
3000
3000
LastName
1357
1357
MiddleName
1359
1359
PersonalEmailAddress
1385
1385
PrimaryLanguage
1365
1365
PrimaryLanguageCode
1379
1379
RaceAfricanAmerican
1371
1371
RaceAmericanIndian
1374
1374
RaceAsian
1373
1373
RacePacificIslander
1372
1372
RaceUnreported
1375
1375
RaceWhite
1370
1370
Residency
1367
1367
ResidencyCode
1366
1366
ResidencyCounty
1389
1389
ResidencyCountyCode
1388
1388
ResidencyState
1391
1391
ResidencyStateCode
1390
1390
RowEndDate
2076
2076
RowIsCurrent
2074
2074
RowStartDate
2075
2075
StudentAthlete
2999
2999
StudentId
1377
1377
StudentIdAK
1356
1356
StudentSK
2073
2073
VeteranStudent
2998
2998
ZipCode
1368
1368
CellPhoneNumber
1467
1467
CountryOfBirth
1478
1478
CountryOfBirthCode
1477
1477
CountryOfCitizenship
1480
1480
CountryOfCitizenshipCode
1479
1479
DateOfBirth
1453
1453
Ethnicity
1447
1447
EthnicityCode
1446
1446
FERPARequested
1476
1476
FirstName
1442
1442
FirstTimeInCollege
1448
1448
FullName
1462
1462
Gender
1445
1445
GenderCode
1444
1444
HighSchool
1465
1465
HighSchoolInstitutionId
1464
1464
HomeCampus
3122
3122
HomeCampusCode
3121
3121
HomePhoneNumber
1466
1466
ImmigrationStatus
1471
1471
ImmigrationStatusCode
1470
1470
InitialPrepStatus
3007
3007
InstitutionalEmailAddress
1468
1468
InternationalStudent
3010
3010
LastName
1441
1441
MiddleName
1443
1443
PersonalEmailAddress
1469
1469
PrimaryLanguage
1449
1449
PrimaryLanguageCode
1463
1463
RaceAfricanAmerican
1455
1455
RaceAmericanIndian
1458
1458
RaceAsian
1457
1457
RacePacificIslander
1456
1456
RaceUnreported
1459
1459
RaceWhite
1454
1454
Residency
1451
1451
ResidencyCode
1450
1450
ResidencyCounty
1473
1473
ResidencyCountyCode
1472
1472
ResidencyState
1475
1475
ResidencyStateCode
1474
1474
Row Change Reason
1149
1149
RowEndDate
2084
2084
RowIsCurrent
2082
2082
RowStartDate
2083
2083
StudentAthlete
3009
3009
StudentId
1461
1461
StudentIdAK
1440
1440
StudentSK
2081
2081
VeteranStudent
3008
3008
ZipCode
1452
1452
Powered by BI Documenter