TF_SCD Student Receipt 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>4044</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4045</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4046</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4047</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4048</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4049</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4050</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4051</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4052</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4053</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4054</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4055</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4056</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4057</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4058</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4059</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4060</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4061</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4062</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4063</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4064</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4065</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>4066</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4067</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4068</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4069</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4070</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4071</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4072</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4073</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>4317</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4318</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4319</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5846</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7164</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7165</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7166</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7167</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7168</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7169</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7170</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7171</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7172</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7173</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7174</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7175</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7176</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7177</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</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>4042</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4043</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4529</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4530</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4531</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5978</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7226</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7227</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7228</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7229</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7230</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7231</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7232</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7233</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7234</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7235</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7236</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7237</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7238</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7239</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns	<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>7068</LineageID><DataType>130</DataType><Length>1</Length></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>7071</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>7074</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>5450</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>StudentId</Name><LineageID>7029</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentReceiptSK</Name><LineageID>7023</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentReceiptAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6933</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentReceiptAK</Name><LineageID>7026</LineageID><DataType>129</DataType><Length>24</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrintedReceiptNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6936</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PrintedReceiptNumber</Name><LineageID>7032</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptCategory</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6939</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptCategory</Name><LineageID>7035</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptProcesserCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6942</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptProcesserCode</Name><LineageID>7038</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptProcesser</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6945</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptProcesser</Name><LineageID>7041</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SessionDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6948</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>SessionDate</Name><LineageID>7044</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SessionSequenceNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6951</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>SessionSequenceNumber</Name><LineageID>7047</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptSequenceNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6954</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>ReceiptSequenceNumber</Name><LineageID>7050</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptTypeCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6957</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptTypeCode</Name><LineageID>7053</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptType</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6960</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptType</Name><LineageID>7056</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MiscellaneousReceiptCatecoryCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6963</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>MiscellaneousReceiptCatecoryCode</Name><LineageID>7059</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MiscellaneousReceiptCategory</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6966</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>MiscellaneousReceiptCategory</Name><LineageID>7062</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReceiptReference</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6969</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ReceiptReference</Name><LineageID>7065</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><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4040</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4423</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4424</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4425</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5912</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7194</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7195</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7196</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7197</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7198</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7199</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7200</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7201</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7202</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7203</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7204</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7205</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7206</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7207</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</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><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4038</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4262</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4263</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4264</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5813</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7148</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7149</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7150</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7151</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7152</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7153</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7154</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7155</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7156</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7157</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7158</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7159</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7160</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7161</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New Output Counter
New SCD2 Columns	<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4041</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4476</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4477</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4478</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5945</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7210</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7211</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7212</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7213</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7214</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7215</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7216</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7217</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7218</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7219</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7220</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7221</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7222</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7223</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</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>#5450</string><string>#6930</string><string>#6933</string><string>#6936</string><string>#6939</string><string>#6942</string><string>#6945</string><string>#6948</string><string>#6951</string><string>#6954</string><string>#6957</string><string>#6960</string><string>#6963</string><string>#6966</string><string>#6969</string><string>#6972</string><string>#6975</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>4074</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4075</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4076</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4077</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4078</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4079</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4080</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4081</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4082</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4083</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4084</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4085</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4086</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4087</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4088</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4089</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4090</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4091</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4092</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4093</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4094</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4095</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4096</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4097</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4098</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4099</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>4100</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>4209</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4210</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4211</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5780</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7134</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7135</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7136</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7137</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7138</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7139</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7140</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7141</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7142</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7143</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7144</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7145</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7146</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7147</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</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>4039</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4370</LineageID><MappedToExistingDimensionLineageID>7068</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4371</LineageID><MappedToExistingDimensionLineageID>7071</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4372</LineageID><MappedToExistingDimensionLineageID>7074</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5879</LineageID><MappedToExistingDimensionLineageID>7029</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7178</LineageID><MappedToExistingDimensionLineageID>7023</MappedToExistingDimensionLineageID><Name>StudentReceiptSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7179</LineageID><MappedToExistingDimensionLineageID>7026</MappedToExistingDimensionLineageID><Name>StudentReceiptAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7180</LineageID><MappedToExistingDimensionLineageID>7032</MappedToExistingDimensionLineageID><Name>PrintedReceiptNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7181</LineageID><MappedToExistingDimensionLineageID>7035</MappedToExistingDimensionLineageID><Name>ReceiptCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7182</LineageID><MappedToExistingDimensionLineageID>7038</MappedToExistingDimensionLineageID><Name>ReceiptProcesserCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7183</LineageID><MappedToExistingDimensionLineageID>7041</MappedToExistingDimensionLineageID><Name>ReceiptProcesser</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7184</LineageID><MappedToExistingDimensionLineageID>7044</MappedToExistingDimensionLineageID><Name>SessionDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7185</LineageID><MappedToExistingDimensionLineageID>7047</MappedToExistingDimensionLineageID><Name>SessionSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7186</LineageID><MappedToExistingDimensionLineageID>7050</MappedToExistingDimensionLineageID><Name>ReceiptSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7187</LineageID><MappedToExistingDimensionLineageID>7053</MappedToExistingDimensionLineageID><Name>ReceiptTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7188</LineageID><MappedToExistingDimensionLineageID>7056</MappedToExistingDimensionLineageID><Name>ReceiptType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7189</LineageID><MappedToExistingDimensionLineageID>7059</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCatecoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7190</LineageID><MappedToExistingDimensionLineageID>7062</MappedToExistingDimensionLineageID><Name>MiscellaneousReceiptCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7191</LineageID><MappedToExistingDimensionLineageID>7065</MappedToExistingDimensionLineageID><Name>ReceiptReference</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 Receipt Slowly Changing Dimension Process
Description
Up Stream Components	OLE_SRC Get DimStudentReceipt TF Case Transform
Down Stream Components	OLE_DST Load New Temp Table for Student Receipt OLE_DST Load SCD1 Temp Table for Student Receipt
ID	3956
Component Class ID	{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String	component "TF_SCD Student Receipt Slowly Changing Dimension Process" (3956)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	False
Validate External Metadata	True
Version	11

Name	ID	LineageID
MiscellaneousReceiptCatecoryCode	7113	7059
MiscellaneousReceiptCategory	7114	7062
PrintedReceiptNumber	7104	7032
ReceiptCategory	7105	7035
ReceiptProcesser	7107	7041
ReceiptProcesserCode	7106	7038
ReceiptReference	7115	7065
ReceiptSequenceNumber	7110	7050
ReceiptType	7112	7056
ReceiptTypeCode	7111	7053
RowEndDate	7118	7074
RowIsCurrent	7116	7068
RowStartDate	7117	7071
SessionDate	7108	7044
SessionSequenceNumber	7109	7047
StudentId	7103	7029
StudentReceiptAK	7102	7026
StudentReceiptSK	7101	7023
MiscellaneousReceiptCatecoryCode	7129	6963
MiscellaneousReceiptCategory	7130	6966
PrintedReceiptNumber	7120	6936
ReceiptCategory	7121	6939
ReceiptProcesser	7123	6945
ReceiptProcesserCode	7122	6942
ReceiptReference	7131	6969
ReceiptSequenceNumber	7126	6954
ReceiptType	7128	6960
ReceiptTypeCode	7127	6957
SessionDate	7124	6948
SessionSequenceNumber	7125	6951
StudentId	5747	5450
StudentReceiptAK	7119	6933

Name	ID	LineageID
MiscellaneousReceiptCatecoryCode	7159	7159
MiscellaneousReceiptCategory	7160	7160
PrintedReceiptNumber	7150	7150
ReceiptCategory	7151	7151
ReceiptProcesser	7153	7153
ReceiptProcesserCode	7152	7152
ReceiptReference	7161	7161
ReceiptSequenceNumber	7156	7156
ReceiptType	7158	7158
ReceiptTypeCode	7157	7157
RowEndDate	4264	4264
RowIsCurrent	4262	4262
RowStartDate	4263	4263
SessionDate	7154	7154
SessionSequenceNumber	7155	7155
StudentId	5813	5813
StudentReceiptAK	7149	7149
StudentReceiptSK	7148	7148
MiscellaneousReceiptCatecoryCode	7189	7189
MiscellaneousReceiptCategory	7190	7190
PrintedReceiptNumber	7180	7180
ReceiptCategory	7181	7181
ReceiptProcesser	7183	7183
ReceiptProcesserCode	7182	7182
ReceiptReference	7191	7191
ReceiptSequenceNumber	7186	7186
ReceiptType	7188	7188
ReceiptTypeCode	7187	7187
RowEndDate	4372	4372
RowIsCurrent	4370	4370
RowStartDate	4371	4371
SessionDate	7184	7184
SessionSequenceNumber	7185	7185
StudentId	5879	5879
StudentReceiptAK	7179	7179
StudentReceiptSK	7178	7178