TF_SCD Student Term 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>4270</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4271</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><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>5844</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5845</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5846</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5847</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5848</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5851</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5852</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5853</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5854</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5855</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5856</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5857</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5858</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5859</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5862</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5863</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5864</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5865</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5866</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5867</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5868</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5869</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5870</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5871</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5872</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5873</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5874</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5875</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5876</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6269</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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>4482</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4483</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</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>5976</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5977</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5978</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5979</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5980</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5983</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5984</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5985</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5986</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5987</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5988</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5989</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5990</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5991</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5994</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5995</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5996</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5997</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5998</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5999</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6000</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6001</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6002</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6003</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6004</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6005</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6006</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6007</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6008</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6279</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns	<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Term</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>5158</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Term</Name><LineageID>3807</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TermTitle</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>5161</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TermTitle</Name><LineageID>3810</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><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 /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentTermSK</Name><LineageID>5615</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentTermAK</SourceSystemColumnName><SourceSystemLineageID>5447</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentTermAK</Name><LineageID>5618</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></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>ResidencyCode</SourceSystemColumnName><SourceSystemLineageID>5453</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCode</Name><LineageID>5624</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Residency</SourceSystemColumnName><SourceSystemLineageID>5456</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Residency</Name><LineageID>5627</LineageID><DataType>129</DataType><Length>30</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>ProgramAdmitStatus</SourceSystemColumnName><SourceSystemLineageID>5465</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProgramAdmitStatus</Name><LineageID>5636</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AcademicStatusCode</SourceSystemColumnName><SourceSystemLineageID>5468</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AcademicStatusCode</Name><LineageID>5639</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AcademicStatus</SourceSystemColumnName><SourceSystemLineageID>5471</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AcademicStatus</Name><LineageID>5642</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BasisOfAdmissionCode</SourceSystemColumnName><SourceSystemLineageID>5474</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BasisOfAdmissionCode</Name><LineageID>5645</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BasisOfAdmission</SourceSystemColumnName><SourceSystemLineageID>5477</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BasisOfAdmission</Name><LineageID>5648</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EnrollmentStatusCode</SourceSystemColumnName><SourceSystemLineageID>5480</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EnrollmentStatusCode</Name><LineageID>5651</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EnrollmentStatus</SourceSystemColumnName><SourceSystemLineageID>5483</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EnrollmentStatus</Name><LineageID>5654</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AgeAtTerm</SourceSystemColumnName><SourceSystemLineageID>5486</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AgeAtTerm</Name><LineageID>5657</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AgeRangeAtTerm</SourceSystemColumnName><SourceSystemLineageID>5489</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AgeRangeAtTerm</Name><LineageID>5660</LineageID><DataType>129</DataType><Length>10</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>Advised</SourceSystemColumnName><SourceSystemLineageID>5498</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Advised</Name><LineageID>5669</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementStatusCode</SourceSystemColumnName><SourceSystemLineageID>5501</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementStatusCode</Name><LineageID>5672</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementStatus</SourceSystemColumnName><SourceSystemLineageID>5504</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementStatus</Name><LineageID>5675</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementMandatory</SourceSystemColumnName><SourceSystemLineageID>5507</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementMandatory</Name><LineageID>5678</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateLastAdvised</SourceSystemColumnName><SourceSystemLineageID>5510</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DateLastAdvised</Name><LineageID>5681</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementProgramCode</SourceSystemColumnName><SourceSystemLineageID>5513</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementProgramCode</Name><LineageID>5684</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementProgram</SourceSystemColumnName><SourceSystemLineageID>5516</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementProgram</Name><LineageID>5687</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementAwardTypeCode</SourceSystemColumnName><SourceSystemLineageID>5519</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementAwardTypeCode</Name><LineageID>5690</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementAwardType</SourceSystemColumnName><SourceSystemLineageID>5522</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementAwardType</Name><LineageID>5693</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementAdvisorId</SourceSystemColumnName><SourceSystemLineageID>5525</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementAdvisorId</Name><LineageID>5696</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AdvisementAdvisor</SourceSystemColumnName><SourceSystemLineageID>5528</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AdvisementAdvisor</Name><LineageID>5699</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferMajorAdvisementCode</SourceSystemColumnName><SourceSystemLineageID>5531</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferMajorAdvisementCode</Name><LineageID>5702</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferMajorAdvisement</SourceSystemColumnName><SourceSystemLineageID>5534</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferMajorAdvisement</Name><LineageID>5705</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferInstitutionAdvisementId</SourceSystemColumnName><SourceSystemLineageID>5537</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferInstitutionAdvisementId</Name><LineageID>5708</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TransferInstitutionAdvisement</SourceSystemColumnName><SourceSystemLineageID>5540</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TransferInstitutionAdvisement</Name><LineageID>5711</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SdbAwardTypeCode</SourceSystemColumnName><SourceSystemLineageID>6216</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SdbAwardTypeCode</Name><LineageID>6219</LineageID><DataType>129</DataType><Length>3</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>4376</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4377</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</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>5910</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5911</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5912</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5913</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5914</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5917</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5918</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5919</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5920</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5921</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5922</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5923</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5924</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5925</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5928</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5929</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5930</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5931</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5932</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5933</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5934</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5935</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5936</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5937</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5938</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5939</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5940</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5941</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5942</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6273</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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>4215</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4216</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</Name></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>5811</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5812</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5813</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5814</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5815</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5818</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5819</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5820</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5821</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5822</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5823</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5824</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5825</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5826</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5829</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5830</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5831</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5832</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5833</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5834</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5835</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5836</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5837</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5838</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5839</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5840</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5841</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5842</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5843</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6266</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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>4429</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4430</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</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>5943</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5944</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5945</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5946</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5947</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5950</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5951</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5952</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5953</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5954</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5955</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5956</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5957</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5958</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5961</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5962</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5963</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5964</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5965</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5966</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5967</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5968</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5969</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5970</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5971</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5972</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5973</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5974</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5975</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6276</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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>#5158</string><string>#5161</string><string>#5444</string><string>#5447</string><string>#5450</string><string>#5453</string><string>#5456</string><string>#5459</string><string>#5462</string><string>#5465</string><string>#5468</string><string>#5471</string><string>#5474</string><string>#5477</string><string>#5480</string><string>#5483</string><string>#5486</string><string>#5489</string><string>#5492</string><string>#5495</string><string>#5498</string><string>#5501</string><string>#5504</string><string>#5507</string><string>#5510</string><string>#5513</string><string>#5516</string><string>#5519</string><string>#5522</string><string>#5525</string><string>#5528</string><string>#5531</string><string>#5534</string><string>#5537</string><string>#5540</string><string>#6216</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>4162</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>4163</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><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>5778</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5779</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5780</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5781</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5782</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5785</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5786</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5787</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5788</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5789</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5790</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5791</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5792</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5793</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5796</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5797</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5798</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5799</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5800</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5801</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5802</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5803</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5804</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5805</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5806</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5807</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5808</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5809</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>5810</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6265</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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>4323</LineageID><MappedToExistingDimensionLineageID>3807</MappedToExistingDimensionLineageID><Name>Term</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>4324</LineageID><MappedToExistingDimensionLineageID>3810</MappedToExistingDimensionLineageID><Name>TermTitle</Name></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>5877</LineageID><MappedToExistingDimensionLineageID>5615</MappedToExistingDimensionLineageID><Name>StudentTermSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5878</LineageID><MappedToExistingDimensionLineageID>5618</MappedToExistingDimensionLineageID><Name>StudentTermAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5879</LineageID><MappedToExistingDimensionLineageID>5621</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5880</LineageID><MappedToExistingDimensionLineageID>5624</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5881</LineageID><MappedToExistingDimensionLineageID>5627</MappedToExistingDimensionLineageID><Name>Residency</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>5884</LineageID><MappedToExistingDimensionLineageID>5636</MappedToExistingDimensionLineageID><Name>ProgramAdmitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5885</LineageID><MappedToExistingDimensionLineageID>5639</MappedToExistingDimensionLineageID><Name>AcademicStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5886</LineageID><MappedToExistingDimensionLineageID>5642</MappedToExistingDimensionLineageID><Name>AcademicStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5887</LineageID><MappedToExistingDimensionLineageID>5645</MappedToExistingDimensionLineageID><Name>BasisOfAdmissionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5888</LineageID><MappedToExistingDimensionLineageID>5648</MappedToExistingDimensionLineageID><Name>BasisOfAdmission</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5889</LineageID><MappedToExistingDimensionLineageID>5651</MappedToExistingDimensionLineageID><Name>EnrollmentStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5890</LineageID><MappedToExistingDimensionLineageID>5654</MappedToExistingDimensionLineageID><Name>EnrollmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5891</LineageID><MappedToExistingDimensionLineageID>5657</MappedToExistingDimensionLineageID><Name>AgeAtTerm</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5892</LineageID><MappedToExistingDimensionLineageID>5660</MappedToExistingDimensionLineageID><Name>AgeRangeAtTerm</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>5895</LineageID><MappedToExistingDimensionLineageID>5669</MappedToExistingDimensionLineageID><Name>Advised</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5896</LineageID><MappedToExistingDimensionLineageID>5672</MappedToExistingDimensionLineageID><Name>AdvisementStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5897</LineageID><MappedToExistingDimensionLineageID>5675</MappedToExistingDimensionLineageID><Name>AdvisementStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5898</LineageID><MappedToExistingDimensionLineageID>5678</MappedToExistingDimensionLineageID><Name>AdvisementMandatory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5899</LineageID><MappedToExistingDimensionLineageID>5681</MappedToExistingDimensionLineageID><Name>DateLastAdvised</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5900</LineageID><MappedToExistingDimensionLineageID>5684</MappedToExistingDimensionLineageID><Name>AdvisementProgramCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5901</LineageID><MappedToExistingDimensionLineageID>5687</MappedToExistingDimensionLineageID><Name>AdvisementProgram</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5902</LineageID><MappedToExistingDimensionLineageID>5690</MappedToExistingDimensionLineageID><Name>AdvisementAwardTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5903</LineageID><MappedToExistingDimensionLineageID>5693</MappedToExistingDimensionLineageID><Name>AdvisementAwardType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5904</LineageID><MappedToExistingDimensionLineageID>5696</MappedToExistingDimensionLineageID><Name>AdvisementAdvisorId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5905</LineageID><MappedToExistingDimensionLineageID>5699</MappedToExistingDimensionLineageID><Name>AdvisementAdvisor</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5906</LineageID><MappedToExistingDimensionLineageID>5702</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisementCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5907</LineageID><MappedToExistingDimensionLineageID>5705</MappedToExistingDimensionLineageID><Name>TransferMajorAdvisement</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5908</LineageID><MappedToExistingDimensionLineageID>5708</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisementId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>5909</LineageID><MappedToExistingDimensionLineageID>5711</MappedToExistingDimensionLineageID><Name>TransferInstitutionAdvisement</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6270</LineageID><MappedToExistingDimensionLineageID>6219</MappedToExistingDimensionLineageID><Name>SdbAwardTypeCode</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 Term Slowly Changing Dimension Process
Description
Up Stream Components	OLE_SRC Get DimStudentTerm TF Case Transform
Down Stream Components	OLE_DST Load New Temp Table for Student Term OLE_DST Load SCD1 Temp Table for Student Term
ID	3956
Component Class ID	{2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String	component "TF_SCD Student Term Slowly Changing Dimension Process" (3956)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	False
Validate External Metadata	True
Version	11

Name	ID	LineageID
AcademicStatus	5722	5642
AcademicStatusCode	5721	5639
Advised	5731	5669
AdvisementAdvisor	5741	5699
AdvisementAdvisorId	5740	5696
AdvisementAwardType	5739	5693
AdvisementAwardTypeCode	5738	5690
AdvisementMandatory	5734	5678
AdvisementProgram	5737	5687
AdvisementProgramCode	5736	5684
AdvisementStatus	5733	5675
AdvisementStatusCode	5732	5672
AgeAtTerm	5727	5657
AgeRangeAtTerm	5728	5660
AwardType	5730	5666
AwardTypeCode	5729	5663
BasisOfAdmission	5724	5648
BasisOfAdmissionCode	5723	5645
DateLastAdvised	5735	5681
EnrollmentStatus	5726	5654
EnrollmentStatusCode	5725	5651
Program	5719	5633
ProgramAdmitStatus	5720	5636
ProgramCode	5718	5630
Residency	5717	5627
ResidencyCode	5716	5624
RowEndDate	4156	3954
RowIsCurrent	4154	3948
RowStartDate	4155	3951
SdbAwardTypeCode	6261	6219
StudentId	5715	5621
StudentTermAK	5714	5618
StudentTermSK	5713	5615
Term	4107	3807
TermTitle	4108	3810
TransferInstitutionAdvisement	5745	5711
TransferInstitutionAdvisementId	5744	5708
TransferMajorAdvisement	5743	5705
TransferMajorAdvisementCode	5742	5702
AcademicStatus	5754	5471
AcademicStatusCode	5753	5468
Advised	5763	5498
AdvisementAdvisor	5773	5528
AdvisementAdvisorId	5772	5525
AdvisementAwardType	5771	5522
AdvisementAwardTypeCode	5770	5519
AdvisementMandatory	5766	5507
AdvisementProgram	5769	5516
AdvisementProgramCode	5768	5513
AdvisementStatus	5765	5504
AdvisementStatusCode	5764	5501
AgeAtTerm	5759	5486
AgeRangeAtTerm	5760	5489
AwardType	5762	5495
AwardTypeCode	5761	5492
BasisOfAdmission	5756	5477
BasisOfAdmissionCode	5755	5474
DateLastAdvised	5767	5510
EnrollmentStatus	5758	5483
EnrollmentStatusCode	5757	5480
Program	5751	5462
ProgramAdmitStatus	5752	5465
ProgramCode	5750	5459
Residency	5749	5456
ResidencyCode	5748	5453
SdbAwardTypeCode	6262	6216
StudentId	5747	5450
StudentTermAK	5746	5447
Term	5395	5158
TermTitle	5396	5161
TransferInstitutionAdvisement	5777	5540
TransferInstitutionAdvisementId	5776	5537
TransferMajorAdvisement	5775	5534
TransferMajorAdvisementCode	5774	5531

Name	ID	LineageID
AcademicStatus	5820	5820
AcademicStatusCode	5819	5819
Advised	5829	5829
AdvisementAdvisor	5839	5839
AdvisementAdvisorId	5838	5838
AdvisementAwardType	5837	5837
AdvisementAwardTypeCode	5836	5836
AdvisementMandatory	5832	5832
AdvisementProgram	5835	5835
AdvisementProgramCode	5834	5834
AdvisementStatus	5831	5831
AdvisementStatusCode	5830	5830
AgeAtTerm	5825	5825
AgeRangeAtTerm	5826	5826
AwardType	5828	5828
AwardTypeCode	5827	5827
BasisOfAdmission	5822	5822
BasisOfAdmissionCode	5821	5821
DateLastAdvised	5833	5833
EnrollmentStatus	5824	5824
EnrollmentStatusCode	5823	5823
Program	5817	5817
ProgramAdmitStatus	5818	5818
ProgramCode	5816	5816
Residency	5815	5815
ResidencyCode	5814	5814
RowEndDate	4264	4264
RowIsCurrent	4262	4262
RowStartDate	4263	4263
SdbAwardTypeCode	6266	6266
StudentId	5813	5813
StudentTermAK	5812	5812
StudentTermSK	5811	5811
Term	4215	4215
TermTitle	4216	4216
TransferInstitutionAdvisement	5843	5843
TransferInstitutionAdvisementId	5842	5842
TransferMajorAdvisement	5841	5841
TransferMajorAdvisementCode	5840	5840