TF_SCD Student Objective 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>6671</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6672</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6673</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6674</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6675</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6676</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6677</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6678</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6679</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6680</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6681</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6682</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6683</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6684</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6685</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6686</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6687</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6688</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6689</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6690</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6905</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6906</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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>6757</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6758</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6759</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6760</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6761</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6762</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6763</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6764</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6765</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6766</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6767</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6768</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6769</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6770</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6771</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6772</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6773</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6774</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6775</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6776</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6919</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6920</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns	<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><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><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>3951</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><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><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentObjectiveSK</Name><LineageID>6485</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentObjectiveAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6425</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentObjectiveAK</Name><LineageID>6488</LineageID><DataType>129</DataType><Length>23</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EffectiveTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6428</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EffectiveTerm</Name><LineageID>6491</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EffectiveTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6431</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EffectiveTermTitle</Name><LineageID>6494</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SequenceNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6434</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SequenceNumber</Name><LineageID>6497</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdmissionStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6437</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdmissionStatus</Name><LineageID>6500</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryObjective</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6440</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrimaryObjective</Name><LineageID>6503</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProgramStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6443</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramStatusCode</Name><LineageID>6506</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GraduationStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6446</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GraduationStatusCode</Name><LineageID>6509</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ExpectedGraduationTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6449</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ExpectedGraduationTerm</Name><LineageID>6512</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ExpectedGraduationTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6452</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ExpectedGraduationTermTitle</Name><LineageID>6515</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ActualGraduationTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6455</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ActualGraduationTerm</Name><LineageID>6518</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ActualGraduationTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6458</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ActualGraduationTermTitle</Name><LineageID>6521</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GraduationHonorsCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6461</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GraduationHonorsCode</Name><LineageID>6524</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferMajorCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6464</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferMajorCode</Name><LineageID>6527</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferMajor</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6467</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferMajor</Name><LineageID>6530</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferInstitutionId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6470</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferInstitutionId</Name><LineageID>6533</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferInstitution</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6473</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferInstitution</Name><LineageID>6536</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReportedTerm</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6476</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReportedTerm</Name><LineageID>6539</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReportedTermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6479</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReportedTermTitle</Name><LineageID>6542</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GraduationAge</SourceSystemColumnName><SourceSystemLineageID>6856</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GraduationAge</Name><LineageID>6862</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GraduationAgeRange</SourceSystemColumnName><SourceSystemLineageID>6859</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GraduationAgeRange</Name><LineageID>6865</LineageID><DataType>129</DataType><Length>10</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>6713</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6714</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6715</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6716</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6717</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6718</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6719</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6720</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6721</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6722</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6723</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6724</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6725</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6726</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6727</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6728</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6729</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6730</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6731</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6732</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6911</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6912</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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>6649</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6650</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6651</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6652</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6653</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6654</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6655</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6656</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6657</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6658</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6659</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6660</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6661</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6662</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6663</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6664</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6665</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6666</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6667</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6668</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6901</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6902</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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>6735</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6736</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6737</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6738</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6739</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6740</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6741</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6742</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6743</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6744</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6745</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6746</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6747</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6748</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6749</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6750</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6751</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6752</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6753</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6754</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6915</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6916</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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>#6425</string><string>#6428</string><string>#6431</string><string>#6434</string><string>#6437</string><string>#6440</string><string>#6443</string><string>#6446</string><string>#6449</string><string>#6452</string><string>#6455</string><string>#6458</string><string>#6461</string><string>#6464</string><string>#6467</string><string>#6470</string><string>#6473</string><string>#6476</string><string>#6479</string><string>#6482</string><string>#6856</string><string>#6859</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>6629</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6630</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6631</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6632</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6633</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6634</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6635</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6636</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6637</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6638</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6639</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6640</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6641</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6642</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6643</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6644</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6645</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6646</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6647</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6648</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6899</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6900</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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>6691</LineageID><MappedToExistingDimensionLineageID>6485</MappedToExistingDimensionLineageID><Name>StudentObjectiveSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6692</LineageID><MappedToExistingDimensionLineageID>6488</MappedToExistingDimensionLineageID><Name>StudentObjectiveAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6693</LineageID><MappedToExistingDimensionLineageID>6491</MappedToExistingDimensionLineageID><Name>EffectiveTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6694</LineageID><MappedToExistingDimensionLineageID>6494</MappedToExistingDimensionLineageID><Name>EffectiveTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6695</LineageID><MappedToExistingDimensionLineageID>6497</MappedToExistingDimensionLineageID><Name>SequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6696</LineageID><MappedToExistingDimensionLineageID>6500</MappedToExistingDimensionLineageID><Name>AdmissionStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6697</LineageID><MappedToExistingDimensionLineageID>6503</MappedToExistingDimensionLineageID><Name>PrimaryObjective</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6698</LineageID><MappedToExistingDimensionLineageID>6506</MappedToExistingDimensionLineageID><Name>ProgramStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6699</LineageID><MappedToExistingDimensionLineageID>6509</MappedToExistingDimensionLineageID><Name>GraduationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6700</LineageID><MappedToExistingDimensionLineageID>6512</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6701</LineageID><MappedToExistingDimensionLineageID>6515</MappedToExistingDimensionLineageID><Name>ExpectedGraduationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6702</LineageID><MappedToExistingDimensionLineageID>6518</MappedToExistingDimensionLineageID><Name>ActualGraduationTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6703</LineageID><MappedToExistingDimensionLineageID>6521</MappedToExistingDimensionLineageID><Name>ActualGraduationTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6704</LineageID><MappedToExistingDimensionLineageID>6524</MappedToExistingDimensionLineageID><Name>GraduationHonorsCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6705</LineageID><MappedToExistingDimensionLineageID>6527</MappedToExistingDimensionLineageID><Name>TransferMajorCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6706</LineageID><MappedToExistingDimensionLineageID>6530</MappedToExistingDimensionLineageID><Name>TransferMajor</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6707</LineageID><MappedToExistingDimensionLineageID>6533</MappedToExistingDimensionLineageID><Name>TransferInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6708</LineageID><MappedToExistingDimensionLineageID>6536</MappedToExistingDimensionLineageID><Name>TransferInstitution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6709</LineageID><MappedToExistingDimensionLineageID>6539</MappedToExistingDimensionLineageID><Name>ReportedTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6710</LineageID><MappedToExistingDimensionLineageID>6542</MappedToExistingDimensionLineageID><Name>ReportedTermTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6907</LineageID><MappedToExistingDimensionLineageID>6862</MappedToExistingDimensionLineageID><Name>GraduationAge</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6908</LineageID><MappedToExistingDimensionLineageID>6865</MappedToExistingDimensionLineageID><Name>GraduationAgeRange</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 Objective Slowly Changing Dimension Process
Description
Up Stream Components	OLE_SRC Get DimStudentObjective TF Case Transform
Down Stream Components	OLE_DST Load New Temp Table for Student Objective OLE_DST Load SCD1 Temp Table for Student Objective
ID	3956
Component Class ID	{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String	component "TF_SCD Student Objective Slowly Changing Dimension Process" (3956)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	False
Validate External Metadata	True
Version	11

Name	ID	LineageID
ActualGraduationTerm	6599	6518
ActualGraduationTermTitle	6600	6521
AdmissionStatus	6593	6500
AwardType	5730	5666
AwardTypeCode	5729	5663
EffectiveTerm	6590	6491
EffectiveTermTitle	6591	6494
ExpectedGraduationTerm	6597	6512
ExpectedGraduationTermTitle	6598	6515
GraduationAge	6893	6862
GraduationAgeRange	6894	6865
GraduationHonorsCode	6601	6524
GraduationStatusCode	6596	6509
PrimaryObjective	6594	6503
Program	5719	5633
ProgramCode	5718	5630
ProgramStatusCode	6595	6506
ReportedTerm	6606	6539
ReportedTermTitle	6607	6542
RowEndDate	4156	3954
RowIsCurrent	4154	3948
RowStartDate	4155	3951
SequenceNumber	6592	6497
StudentId	5715	5621
StudentObjectiveAK	6589	6488
StudentObjectiveSK	6588	6485
TransferInstitution	6605	6536
TransferInstitutionId	6604	6533
TransferMajor	6603	6530
TransferMajorCode	6602	6527
ActualGraduationTerm	6618	6455
ActualGraduationTermTitle	6619	6458
AdmissionStatus	6612	6437
AwardType	5762	5495
AwardTypeCode	5761	5492
EffectiveTerm	6609	6428
EffectiveTermTitle	6610	6431
ExpectedGraduationTerm	6616	6449
ExpectedGraduationTermTitle	6617	6452
GraduationAge	6895	6856
GraduationAgeRange	6896	6859
GraduationHonorsCode	6620	6461
GraduationStatusCode	6615	6446
PrimaryObjective	6613	6440
Program	5751	5462
ProgramCode	5750	5459
ProgramStatusCode	6614	6443
ReportedTerm	6625	6476
ReportedTermTitle	6626	6479
SequenceNumber	6611	6434
StudentId	5747	5450
StudentObjectiveAK	6608	6425
TransferInstitution	6624	6473
TransferInstitutionId	6623	6470
TransferMajor	6622	6467
TransferMajorCode	6621	6464

Name	ID	LineageID
ActualGraduationTerm	6660	6660
ActualGraduationTermTitle	6661	6661
AdmissionStatus	6654	6654
AwardType	5828	5828
AwardTypeCode	5827	5827
EffectiveTerm	6651	6651
EffectiveTermTitle	6652	6652
ExpectedGraduationTerm	6658	6658
ExpectedGraduationTermTitle	6659	6659
GraduationAge	6901	6901
GraduationAgeRange	6902	6902
GraduationHonorsCode	6662	6662
GraduationStatusCode	6657	6657
PrimaryObjective	6655	6655
Program	5817	5817
ProgramCode	5816	5816
ProgramStatusCode	6656	6656
ReportedTerm	6667	6667
ReportedTermTitle	6668	6668
RowEndDate	4264	4264
RowIsCurrent	4262	4262
RowStartDate	4263	4263
SequenceNumber	6653	6653
StudentId	5813	5813
StudentObjectiveAK	6650	6650
StudentObjectiveSK	6649	6649
TransferInstitution	6666	6666
TransferInstitutionId	6665	6665
TransferMajor	6664	6664
TransferMajorCode	6663	6663
ActualGraduationTerm	6702	6702
ActualGraduationTermTitle	6703	6703
AdmissionStatus	6696	6696
AwardType	5894	5894
AwardTypeCode	5893	5893
EffectiveTerm	6693	6693
EffectiveTermTitle	6694	6694
ExpectedGraduationTerm	6700	6700
ExpectedGraduationTermTitle	6701	6701