TF_SCD Student Slowly Changing Dimension Process

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>1407</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1420</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>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><OutputColumnDefinition><LineageID>3390</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3391</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3392</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3393</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3394</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3395</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3396</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3397</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3398</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3399</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3400</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3401</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3402</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3403</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3404</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3405</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3406</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3407</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3408</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3409</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3410</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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>1571</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1584</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>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><OutputColumnDefinition><LineageID>3480</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3481</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3482</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3483</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3484</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3485</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3486</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3487</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3488</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3489</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3490</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3491</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3492</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3493</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3494</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3495</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3496</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3497</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3498</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3499</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3500</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns	<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><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>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><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>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><InputColumnDefinition><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationSK</Name><LineageID>3241</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>ApplicationAK</SourceSystemColumnName><SourceSystemLineageID>3136</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationAK</Name><LineageID>3244</LineageID><DataType>129</DataType><Length>23</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationTerm</SourceSystemColumnName><SourceSystemLineageID>3139</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationTerm</Name><LineageID>3247</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationTermTitle</SourceSystemColumnName><SourceSystemLineageID>3142</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationTermTitle</Name><LineageID>3250</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationEntry</SourceSystemColumnName><SourceSystemLineageID>3145</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationEntry</Name><LineageID>3253</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationTypeCode</SourceSystemColumnName><SourceSystemLineageID>3148</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationTypeCode</Name><LineageID>3256</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationType</SourceSystemColumnName><SourceSystemLineageID>3151</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationType</Name><LineageID>3259</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CreditVocationalBachelorApplication</SourceSystemColumnName><SourceSystemLineageID>3154</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CreditVocationalBachelorApplication</Name><LineageID>3262</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InitialOrReadmitApplication</SourceSystemColumnName><SourceSystemLineageID>3157</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InitialOrReadmitApplication</Name><LineageID>3265</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BasisOfAdmissionCode</SourceSystemColumnName><SourceSystemLineageID>3160</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BasisOfAdmissionCode</Name><LineageID>3268</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BasisOfAdmission</SourceSystemColumnName><SourceSystemLineageID>3163</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BasisOfAdmission</Name><LineageID>3271</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EnrollmentStatusCode</SourceSystemColumnName><SourceSystemLineageID>3166</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EnrollmentStatusCode</Name><LineageID>3274</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EnrollmentStatus</SourceSystemColumnName><SourceSystemLineageID>3169</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EnrollmentStatus</Name><LineageID>3277</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BachelorApplicant</SourceSystemColumnName><SourceSystemLineageID>3172</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BachelorApplicant</Name><LineageID>3280</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramCode</SourceSystemColumnName><SourceSystemLineageID>3175</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramCode</Name><LineageID>3283</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Program</SourceSystemColumnName><SourceSystemLineageID>3178</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Program</Name><LineageID>3286</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardTypeCode</SourceSystemColumnName><SourceSystemLineageID>3181</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardTypeCode</Name><LineageID>3289</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardType</SourceSystemColumnName><SourceSystemLineageID>3184</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardType</Name><LineageID>3292</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ApplicationDate</SourceSystemColumnName><SourceSystemLineageID>3187</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ApplicationDate</Name><LineageID>3295</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstTermEnrolled</SourceSystemColumnName><SourceSystemLineageID>3190</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstTermEnrolled</Name><LineageID>3298</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstTermEnrolledTitle</SourceSystemColumnName><SourceSystemLineageID>3193</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstTermEnrolledTitle</Name><LineageID>3301</LineageID><DataType>129</DataType><Length>30</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>1489</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1502</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>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><OutputColumnDefinition><LineageID>3434</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3435</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3436</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3437</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3438</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3439</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3440</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3441</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3442</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3443</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3444</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3445</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3446</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3447</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3448</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3449</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3450</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3451</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3452</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3453</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3454</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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	968,713
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>1364</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1377</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>3115</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3116</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3367</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3368</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3369</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3370</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3371</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3372</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3373</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3374</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3375</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3376</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3377</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3378</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3379</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3380</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3381</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3382</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3383</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3384</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3385</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3386</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3387</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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>1530</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1543</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>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><OutputColumnDefinition><LineageID>3457</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3458</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3459</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3460</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3461</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3462</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3463</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3464</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3465</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3466</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3467</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3468</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3469</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3470</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3471</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3472</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3473</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3474</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3475</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3476</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3477</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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>#908</string><string>#934</string><string>#3046</string><string>#3049</string><string>#3133</string><string>#3136</string><string>#3139</string><string>#3142</string><string>#3145</string><string>#3148</string><string>#3151</string><string>#3154</string><string>#3157</string><string>#3160</string><string>#3163</string><string>#3166</string><string>#3169</string><string>#3172</string><string>#3175</string><string>#3178</string><string>#3181</string><string>#3184</string><string>#3187</string><string>#3190</string><string>#3193</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>1323</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1336</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</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>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><OutputColumnDefinition><LineageID>3346</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3347</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3348</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3349</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3350</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3351</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3352</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3353</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3354</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3355</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3356</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3357</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3358</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3359</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3360</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3361</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3362</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3363</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3364</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3365</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3366</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1448</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1461</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2082</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2083</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2084</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3121</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3122</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3411</LineageID><MappedToExistingDimensionLineageID>3241</MappedToExistingDimensionLineageID><Name>ApplicationSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3412</LineageID><MappedToExistingDimensionLineageID>3244</MappedToExistingDimensionLineageID><Name>ApplicationAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3413</LineageID><MappedToExistingDimensionLineageID>3247</MappedToExistingDimensionLineageID><Name>ApplicationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3414</LineageID><MappedToExistingDimensionLineageID>3250</MappedToExistingDimensionLineageID><Name>ApplicationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3415</LineageID><MappedToExistingDimensionLineageID>3253</MappedToExistingDimensionLineageID><Name>ApplicationEntry</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3416</LineageID><MappedToExistingDimensionLineageID>3256</MappedToExistingDimensionLineageID><Name>ApplicationTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3417</LineageID><MappedToExistingDimensionLineageID>3259</MappedToExistingDimensionLineageID><Name>ApplicationType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3418</LineageID><MappedToExistingDimensionLineageID>3262</MappedToExistingDimensionLineageID><Name>CreditVocationalBachelorApplication</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3419</LineageID><MappedToExistingDimensionLineageID>3265</MappedToExistingDimensionLineageID><Name>InitialOrReadmitApplication</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3420</LineageID><MappedToExistingDimensionLineageID>3268</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3421</LineageID><MappedToExistingDimensionLineageID>3271</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3422</LineageID><MappedToExistingDimensionLineageID>3274</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3423</LineageID><MappedToExistingDimensionLineageID>3277</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3424</LineageID><MappedToExistingDimensionLineageID>3280</MappedToExistingDimensionLineageID><Name>BachelorApplicant</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3425</LineageID><MappedToExistingDimensionLineageID>3283</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3426</LineageID><MappedToExistingDimensionLineageID>3286</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3427</LineageID><MappedToExistingDimensionLineageID>3289</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3428</LineageID><MappedToExistingDimensionLineageID>3292</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3429</LineageID><MappedToExistingDimensionLineageID>3295</MappedToExistingDimensionLineageID><Name>ApplicationDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3430</LineageID><MappedToExistingDimensionLineageID>3298</MappedToExistingDimensionLineageID><Name>FirstTermEnrolled</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3431</LineageID><MappedToExistingDimensionLineageID>3301</MappedToExistingDimensionLineageID><Name>FirstTermEnrolledTitle</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

Property	Value
Name	TF_SCD Student Slowly Changing Dimension Process
Description
Up Stream Components	OLE_SRC Get DimApplication TF Transform Case
Down Stream Components	OLE_DST Load New Temp Table for Application OLE_DST Load SCD1 Temp Table for Application
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

Name	ID	LineageID
ApplicationAK	3304	3244
ApplicationDate	3321	3295
ApplicationEntry	3307	3253
ApplicationSK	3303	3241
ApplicationTerm	3305	3247
ApplicationTermTitle	3306	3250
ApplicationType	3309	3259
ApplicationTypeCode	3308	3256
AwardType	3320	3292
AwardTypeCode	3319	3289
BachelorApplicant	3316	3280
BasisOfAdmission	3313	3271
BasisOfAdmissionCode	3312	3268
CreditVocationalBachelorApplication	3310	3262
EnrollmentStatus	3315	3277
EnrollmentStatusCode	3314	3274
FirstTermEnrolled	3322	3298
FirstTermEnrolledTitle	3323	3301
FirstTimeInCollege	2036	793
HomeCampus	3108	3055
HomeCampusCode	3107	3052
InitialOrReadmitApplication	3311	3265
Program	3318	3286
ProgramCode	3317	3283
RowEndDate	2068	889
RowIsCurrent	2066	883
RowStartDate	2067	886
StudentId	2027	766
ApplicationAK	3324	3136
ApplicationDate	3341	3187
ApplicationEntry	3327	3145
ApplicationTerm	3325	3139
ApplicationTermTitle	3326	3142
ApplicationType	3329	3151
ApplicationTypeCode	3328	3148
AwardType	3340	3184
AwardTypeCode	3339	3181
BachelorApplicant	3336	3172
BasisOfAdmission	3333	3163
BasisOfAdmissionCode	3332	3160
CreditVocationalBachelorApplication	3330	3154
EnrollmentStatus	3335	3169
EnrollmentStatusCode	3334	3166
FirstTermEnrolled	3342	3190
FirstTermEnrolledTitle	3343	3193
FirstTimeInCollege	2419	908
HomeCampus	3110	3049
HomeCampusCode	3109	3046
InitialOrReadmitApplication	3331	3157
Program	3338	3178
ProgramCode	3337	3175
StudentId	2431	934

Name	ID	LineageID
ApplicationAK	3368	3368
ApplicationDate	3385	3385
ApplicationEntry	3371	3371
ApplicationTerm	3369	3369
ApplicationTermTitle	3370	3370
ApplicationType	3373	3373
ApplicationTypeCode	3372	3372
AwardType	3384	3384
AwardTypeCode	3383	3383
BachelorApplicant	3380	3380
BasisOfAdmission	3377	3377
BasisOfAdmissionCode	3376	3376
CreditVocationalBachelorApplication	3374	3374
EnrollmentStatus	3379	3379
EnrollmentStatusCode	3378	3378
FirstTermEnrolled	3386	3386
FirstTermEnrolledTitle	3387	3387
FirstTimeInCollege	1364	1364
HomeCampus	3116	3116
HomeCampusCode	3115	3115
InitialOrReadmitApplication	3375	3375
Program	3382	3382
ProgramCode	3381	3381
RowEndDate	2076	2076
RowIsCurrent	2074	2074
RowStartDate	2075	2075
StudentId	1377	1377
ApplicationAK	3412	3412
ApplicationDate	3429	3429
ApplicationEntry	3415	3415
ApplicationSK	3411	3411
ApplicationTerm	3413	3413
ApplicationTermTitle	3414	3414
ApplicationType	3417	3417
ApplicationTypeCode	3416	3416
AwardType	3428	3428
AwardTypeCode	3427	3427
BachelorApplicant	3424	3424
BasisOfAdmission	3421	3421