TF_SCD Student Success Cohort 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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4318</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4319</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5846</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5849</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5850</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5860</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5861</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7018</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7019</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7020</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7021</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7022</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7023</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7024</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7109</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7162</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7163</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4530</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4531</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5978</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5981</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5982</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5992</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5993</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7052</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7053</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7054</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7055</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7056</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7057</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7058</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7119</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7176</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7177</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns	<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>3948</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>3951</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>3954</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentId</SourceSystemColumnName><SourceSystemLineageID>5450</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentId</Name><LineageID>5621</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramCode</SourceSystemColumnName><SourceSystemLineageID>5459</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramCode</Name><LineageID>5630</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Program</SourceSystemColumnName><SourceSystemLineageID>5462</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Program</Name><LineageID>5633</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardTypeCode</SourceSystemColumnName><SourceSystemLineageID>5492</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardTypeCode</Name><LineageID>5663</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AwardType</SourceSystemColumnName><SourceSystemLineageID>5495</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AwardType</Name><LineageID>5666</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentSuccessCohortSK</Name><LineageID>6930</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentSuccessCohortAK</SourceSystemColumnName><SourceSystemLineageID>6954</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentSuccessCohortAK</Name><LineageID>6933</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CohortTerm</SourceSystemColumnName><SourceSystemLineageID>6957</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CohortTerm</Name><LineageID>6936</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CohortTermTitle</SourceSystemColumnName><SourceSystemLineageID>6960</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CohortTermTitle</Name><LineageID>6939</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramAdmitStatus</SourceSystemColumnName><SourceSystemLineageID>6963</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramAdmitStatus</Name><LineageID>6942</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InitialPrepStatus</SourceSystemColumnName><SourceSystemLineageID>6966</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InitialPrepStatus</Name><LineageID>6945</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstTerm_FT_PT</SourceSystemColumnName><SourceSystemLineageID>6969</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstTerm_FT_PT</Name><LineageID>6948</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstYearTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7089</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstYearTerm</Name><LineageID>7086</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastTermCaptured</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7125</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LastTermCaptured</Name><LineageID>7131</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastTermCapturedTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7128</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LastTermCapturedTitle</Name><LineageID>7134</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4424</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4425</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5912</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5915</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5916</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5926</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5927</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7034</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7035</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7036</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7037</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7038</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7039</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7040</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7113</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7168</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7169</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4263</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4264</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5813</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5816</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5817</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5827</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5828</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7009</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7010</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7011</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7012</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7013</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7014</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7015</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7106</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7158</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7159</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4477</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4478</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5945</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5948</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5949</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5959</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5960</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7043</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7044</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7045</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7046</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7047</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7048</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7049</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7116</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7172</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7173</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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>#5459</string><string>#5462</string><string>#5492</string><string>#5495</string><string>#6951</string><string>#6954</string><string>#6957</string><string>#6960</string><string>#6963</string><string>#6966</string><string>#6969</string><string>#7089</string><string>#7125</string><string>#7128</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4210</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4211</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5780</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5783</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5784</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5794</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5795</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7002</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7003</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7004</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7005</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7006</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7007</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7008</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7105</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7156</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7157</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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>3948</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4371</LineageID><MappedToExistingDimensionLineageID>3951</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4372</LineageID><MappedToExistingDimensionLineageID>3954</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5879</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5882</LineageID><MappedToExistingDimensionLineageID>5630</MappedToExistingDimensionLineageID><Name>ProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5883</LineageID><MappedToExistingDimensionLineageID>5633</MappedToExistingDimensionLineageID><Name>Program</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5893</LineageID><MappedToExistingDimensionLineageID>5663</MappedToExistingDimensionLineageID><Name>AwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5894</LineageID><MappedToExistingDimensionLineageID>5666</MappedToExistingDimensionLineageID><Name>AwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7025</LineageID><MappedToExistingDimensionLineageID>6930</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7026</LineageID><MappedToExistingDimensionLineageID>6933</MappedToExistingDimensionLineageID><Name>StudentSuccessCohortAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7027</LineageID><MappedToExistingDimensionLineageID>6936</MappedToExistingDimensionLineageID><Name>CohortTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7028</LineageID><MappedToExistingDimensionLineageID>6939</MappedToExistingDimensionLineageID><Name>CohortTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7029</LineageID><MappedToExistingDimensionLineageID>6942</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7030</LineageID><MappedToExistingDimensionLineageID>6945</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7031</LineageID><MappedToExistingDimensionLineageID>6948</MappedToExistingDimensionLineageID><Name>FirstTerm_FT_PT</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7110</LineageID><MappedToExistingDimensionLineageID>7086</MappedToExistingDimensionLineageID><Name>FirstYearTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7164</LineageID><MappedToExistingDimensionLineageID>7131</MappedToExistingDimensionLineageID><Name>LastTermCaptured</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7165</LineageID><MappedToExistingDimensionLineageID>7134</MappedToExistingDimensionLineageID><Name>LastTermCapturedTitle</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 Success Cohort Slowly Changing Dimension Process
Description
Up Stream Components	OLE_SRC Get DimStudentSuccessCohort TF Case Transform
Down Stream Components	OLE_DST Load New Temp Table for Student Success Cohort OLE_DST Load SCD1 Temp Table for Student Success Cohort
ID	3956
Component Class ID	{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String	component "TF_SCD Student Success Cohort Slowly Changing Dimension Process" (3956)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	False
Validate External Metadata	True
Version	11

Name	ID	LineageID
AwardType	5730	5666
AwardTypeCode	5729	5663
CohortTerm	6989	6936
CohortTermTitle	6990	6939
FirstTerm_FT_PT	6993	6948
FirstYearTerm	7101	7086
InitialPrepStatus	6992	6945
LastTermCaptured	7150	7131
LastTermCapturedTitle	7151	7134
Program	5719	5633
ProgramAdmitStatus	6991	6942
ProgramCode	5718	5630
RowEndDate	4156	3954
RowIsCurrent	4154	3948
RowStartDate	4155	3951
StudentId	5715	5621
StudentSuccessCohortAK	6988	6933
StudentSuccessCohortSK	6987	6930
AwardType	5762	5495
AwardTypeCode	5761	5492
CohortTerm	6995	6957
CohortTermTitle	6996	6960
FirstTerm_FT_PT	6999	6969
FirstYearTerm	7102	7089
InitialPrepStatus	6998	6966
LastTermCaptured	7152	7125
LastTermCapturedTitle	7153	7128
Program	5751	5462
ProgramAdmitStatus	6997	6963
ProgramCode	5750	5459
StudentId	5747	5450
StudentSuccessCohortAK	6994	6954

Name	ID	LineageID
AwardType	5828	5828
AwardTypeCode	5827	5827
CohortTerm	7011	7011
CohortTermTitle	7012	7012
FirstTerm_FT_PT	7015	7015
FirstYearTerm	7106	7106
InitialPrepStatus	7014	7014
LastTermCaptured	7158	7158
LastTermCapturedTitle	7159	7159
Program	5817	5817
ProgramAdmitStatus	7013	7013
ProgramCode	5816	5816
RowEndDate	4264	4264
RowIsCurrent	4262	4262
RowStartDate	4263	4263
StudentId	5813	5813
StudentSuccessCohortAK	7010	7010
StudentSuccessCohortSK	7009	7009
AwardType	5894	5894
AwardTypeCode	5893	5893
CohortTerm	7027	7027
CohortTermTitle	7028	7028
FirstTerm_FT_PT	7031	7031
FirstYearTerm	7110	7110
InitialPrepStatus	7030	7030
LastTermCaptured	7164	7164
LastTermCapturedTitle	7165	7165
Program	5883	5883
ProgramAdmitStatus	7029	7029
ProgramCode	5882	5882
RowEndDate	4372	4372
RowIsCurrent	4370	4370
RowStartDate	4371	4371
StudentId	5879	5879
StudentSuccessCohortAK	7026	7026
StudentSuccessCohortSK	7025	7025