|
![]() |
Property | Value |
Name | TF_SCD Student Slowly Changing Dimension Process |
Description | |
Up Stream Components | |
Down Stream Components | |
ID | 1067 |
Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
Contact Info | |
Identification String | component "TF_SCD Student Slowly Changing Dimension Process" (1067) |
Is Default Locale | True |
Pipeline Version | 0 |
Uses Dispositions | False |
Validate External Metadata | True |
Version | 11 |
Name | Connection Manager | Description |
Name | Value |
(Obsolete) Route Deleted Rows to SCD2 Expired Output |
False |
(Obsolete) Route SCD2New Rows to New Output |
False |
Audit Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>Auditing</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1154</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1155</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1156</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1157</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1158</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1159</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1160</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1161</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1162</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1163</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1164</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1165</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1166</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1167</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1168</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1169</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1170</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1171</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1172</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1173</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1174</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1175</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Number of rows held in cache on first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1176</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1177</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1178</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1179</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1180</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1181</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1182</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1183</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum Output Rows per Second</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Debugging Messages |
|
Deleted Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>1399</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1400</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1401</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1402</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1403</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1404</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1405</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1406</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1407</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1408</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1409</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1410</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1411</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1412</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1413</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1414</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1415</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1416</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1417</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1418</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1420</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1421</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1422</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1423</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1424</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1425</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1426</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1427</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1428</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1429</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1430</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1431</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1432</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1433</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1434</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1435</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1436</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1437</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1438</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1439</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2077</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2078</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2079</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2080</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3003</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3004</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3005</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3006</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3119</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3120</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Deleted Output Counter |
|
Error Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1152</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1153</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1563</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1564</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1565</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1566</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1567</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1568</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1569</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1570</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1571</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1572</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1573</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1574</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1575</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1576</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1577</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1578</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1579</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1580</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1581</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1582</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1584</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1585</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1586</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1587</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1588</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1589</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1590</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1591</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1592</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1593</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1594</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1595</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1596</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1597</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1598</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1599</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1600</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1601</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1602</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1603</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2093</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2094</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2095</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2096</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3025</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3026</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3027</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3028</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3133</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3134</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>StudentIdAK</SourceSystemColumnName><SourceSystemLineageID>892</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentIdAK</Name><LineageID>763</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastName</SourceSystemColumnName><SourceSystemLineageID>894</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LastName</Name><LineageID>772</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstName</SourceSystemColumnName><SourceSystemLineageID>896</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstName</Name><LineageID>775</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MiddleName</SourceSystemColumnName><SourceSystemLineageID>898</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>MiddleName</Name><LineageID>778</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GenderCode</SourceSystemColumnName><SourceSystemLineageID>900</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GenderCode</Name><LineageID>781</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Gender</SourceSystemColumnName><SourceSystemLineageID>902</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Gender</Name><LineageID>784</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EthnicityCode</SourceSystemColumnName><SourceSystemLineageID>904</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EthnicityCode</Name><LineageID>787</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Ethnicity</SourceSystemColumnName><SourceSystemLineageID>906</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Ethnicity</Name><LineageID>790</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstTimeInCollege</SourceSystemColumnName><SourceSystemLineageID>908</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FirstTimeInCollege</Name><LineageID>793</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryLanguage</SourceSystemColumnName><SourceSystemLineageID>910</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrimaryLanguage</Name><LineageID>799</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCode</SourceSystemColumnName><SourceSystemLineageID>912</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCode</Name><LineageID>826</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Residency</SourceSystemColumnName><SourceSystemLineageID>914</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Residency</Name><LineageID>829</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ZipCode</SourceSystemColumnName><SourceSystemLineageID>916</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ZipCode</Name><LineageID>844</LineageID><DataType>129</DataType><Length>11</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateOfBirth</SourceSystemColumnName><SourceSystemLineageID>918</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DateOfBirth</Name><LineageID>847</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceWhite</SourceSystemColumnName><SourceSystemLineageID>920</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceWhite</Name><LineageID>853</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAfricanAmerican</SourceSystemColumnName><SourceSystemLineageID>922</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAfricanAmerican</Name><LineageID>856</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RacePacificIslander</SourceSystemColumnName><SourceSystemLineageID>924</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RacePacificIslander</Name><LineageID>859</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAsian</SourceSystemColumnName><SourceSystemLineageID>926</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAsian</Name><LineageID>862</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceAmericanIndian</SourceSystemColumnName><SourceSystemLineageID>928</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceAmericanIndian</Name><LineageID>865</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RaceUnreported</SourceSystemColumnName><SourceSystemLineageID>930</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RaceUnreported</Name><LineageID>868</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentId</SourceSystemColumnName><SourceSystemLineageID>934</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentId</Name><LineageID>766</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FullName</SourceSystemColumnName><SourceSystemLineageID>936</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FullName</Name><LineageID>769</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryLanguageCode</SourceSystemColumnName><SourceSystemLineageID>938</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrimaryLanguageCode</Name><LineageID>796</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HighSchoolInstitutionId</SourceSystemColumnName><SourceSystemLineageID>940</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HighSchoolInstitutionId</Name><LineageID>802</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HighSchool</SourceSystemColumnName><SourceSystemLineageID>942</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HighSchool</Name><LineageID>805</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomePhoneNumber</SourceSystemColumnName><SourceSystemLineageID>944</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomePhoneNumber</Name><LineageID>808</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CellPhoneNumber</SourceSystemColumnName><SourceSystemLineageID>946</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CellPhoneNumber</Name><LineageID>811</LineageID><DataType>129</DataType><Length>25</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InstitutionalEmailAddress</SourceSystemColumnName><SourceSystemLineageID>948</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InstitutionalEmailAddress</Name><LineageID>814</LineageID><DataType>129</DataType><Length>75</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PersonalEmailAddress</SourceSystemColumnName><SourceSystemLineageID>950</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PersonalEmailAddress</Name><LineageID>817</LineageID><DataType>129</DataType><Length>75</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ImmigrationStatusCode</SourceSystemColumnName><SourceSystemLineageID>952</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ImmigrationStatusCode</Name><LineageID>820</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ImmigrationStatus</SourceSystemColumnName><SourceSystemLineageID>954</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ImmigrationStatus</Name><LineageID>823</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCountyCode</SourceSystemColumnName><SourceSystemLineageID>956</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCountyCode</Name><LineageID>832</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyCounty</SourceSystemColumnName><SourceSystemLineageID>958</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyCounty</Name><LineageID>835</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyStateCode</SourceSystemColumnName><SourceSystemLineageID>960</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyStateCode</Name><LineageID>838</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ResidencyState</SourceSystemColumnName><SourceSystemLineageID>962</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ResidencyState</Name><LineageID>841</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FERPARequested</SourceSystemColumnName><SourceSystemLineageID>964</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FERPARequested</Name><LineageID>850</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfBirthCode</SourceSystemColumnName><SourceSystemLineageID>966</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfBirthCode</Name><LineageID>871</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfBirth</SourceSystemColumnName><SourceSystemLineageID>968</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfBirth</Name><LineageID>874</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenshipCode</SourceSystemColumnName><SourceSystemLineageID>970</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfCitizenshipCode</Name><LineageID>877</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenship</SourceSystemColumnName><SourceSystemLineageID>972</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>CountryOfCitizenship</Name><LineageID>880</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentSK</Name><LineageID>760</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>883</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>886</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>889</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InitialPrepStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2911</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InitialPrepStatus</Name><LineageID>2923</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>VeteranStudent</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2914</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>VeteranStudent</Name><LineageID>2926</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StudentAthlete</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2917</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StudentAthlete</Name><LineageID>2929</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InternationalStudent</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>2920</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InternationalStudent</Name><LineageID>2932</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomeCampusCode</SourceSystemColumnName><SourceSystemLineageID>3046</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomeCampusCode</Name><LineageID>3052</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HomeCampus</SourceSystemColumnName><SourceSystemLineageID>3049</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HomeCampus</Name><LineageID>3055</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition> |
Existing Dimension Input Counter |
|
Expired SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1150</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1481</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1482</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1483</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1484</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1485</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1486</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1487</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1488</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1489</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1490</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1491</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1492</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1493</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1494</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1495</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1496</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1497</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1498</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1499</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1500</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1502</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1503</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1504</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1505</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1506</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1507</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1508</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1509</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1510</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1511</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1512</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1513</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1514</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1515</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1516</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1517</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1518</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1519</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1520</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1521</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2085</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2086</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2087</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2088</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3013</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3014</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3015</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3016</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3125</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3126</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></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><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1148</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1356</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1357</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1358</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1359</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1360</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1361</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1362</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1363</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1364</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1365</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1366</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1367</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1368</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1369</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1370</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1371</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1372</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1373</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1374</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1375</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1377</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1378</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1379</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1380</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1381</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1382</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1383</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1384</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1385</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1386</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1387</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1388</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1389</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1390</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1391</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1392</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1393</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1394</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1395</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1396</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2073</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2074</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2075</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2076</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2997</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2998</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2999</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3000</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3115</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3116</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New Output Counter |
|
New SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1151</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1522</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1523</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1524</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1525</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1526</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1527</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1528</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1529</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1530</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1531</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1532</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1533</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1534</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1535</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1536</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1537</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1538</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1539</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1540</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1541</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1543</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1544</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1545</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1546</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1547</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1548</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1549</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1550</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1551</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1552</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1553</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1554</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1555</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1556</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1557</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1558</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1559</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1560</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1561</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1562</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2089</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2090</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2091</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2092</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3019</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3020</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3021</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3022</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3129</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3130</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></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>#892</string><string>#894</string><string>#896</string><string>#898</string><string>#900</string><string>#902</string><string>#904</string><string>#906</string><string>#908</string><string>#910</string><string>#912</string><string>#914</string><string>#916</string><string>#918</string><string>#920</string><string>#922</string><string>#924</string><string>#926</string><string>#928</string><string>#930</string><string>#932</string><string>#934</string><string>#936</string><string>#938</string><string>#940</string><string>#942</string><string>#944</string><string>#946</string><string>#948</string><string>#950</string><string>#952</string><string>#954</string><string>#956</string><string>#958</string><string>#960</string><string>#962</string><string>#964</string><string>#966</string><string>#968</string><string>#970</string><string>#972</string><string>#2911</string><string>#2914</string><string>#2917</string><string>#2920</string><string>#3046</string><string>#3049</string></ArrayOfString> |
Special Members Input Counter |
|
Special Members Lineages |
<?xml version="1.0" encoding="utf-16"?><ArrayOfString /> |
Statistics Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>None</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1184</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1185</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1186</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1187</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1188</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1189</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1190</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1191</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1192</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1193</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1194</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1195</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1196</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1197</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1198</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1199</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1200</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1201</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1202</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1203</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1204</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1205</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1206</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1207</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1208</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1209</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1210</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Input Waiting On Row Processing</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Suppress Warnings About Optimizing Performance Through Sorted Inputs |
False |
Suppress Warnings About Optimizing Performance Through Surrogate Key Configuration |
False |
Suppress Warnings About Surrogate Key Configuration |
False |
Surrogate Key Increment |
1 |
Surrogate Key Increment By Variable? |
False |
Surrogate Key Increment Variable |
|
Surrogate Key Seed |
0 |
Surrogate Key Seed By Variable? |
False |
Surrogate Key Seed Variable |
|
Surrogate Key Seed Variable Guaranteed |
False |
Unchanged Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ArrayOfOutputColumnDefinition><OutputColumnDefinition><LineageID>1315</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1316</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1317</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1318</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1319</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1320</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1321</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1322</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1323</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1324</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1325</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1326</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1327</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1328</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1329</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1330</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1331</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1332</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1333</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1334</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1336</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1337</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1338</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1339</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1340</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1341</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1342</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1343</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1344</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1345</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1346</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1347</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1348</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1349</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1350</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1351</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1352</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1353</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1354</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>1355</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2069</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2070</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2071</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2072</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2993</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2994</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2995</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>2996</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3113</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>3114</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Unchanged Output Counter |
|
Update SCD1 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>1149</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1440</LineageID><MappedToExistingDimensionLineageID>763</MappedToExistingDimensionLineageID><Name>StudentIdAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1441</LineageID><MappedToExistingDimensionLineageID>772</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1442</LineageID><MappedToExistingDimensionLineageID>775</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1443</LineageID><MappedToExistingDimensionLineageID>778</MappedToExistingDimensionLineageID><Name>MiddleName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1444</LineageID><MappedToExistingDimensionLineageID>781</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1445</LineageID><MappedToExistingDimensionLineageID>784</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1446</LineageID><MappedToExistingDimensionLineageID>787</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1447</LineageID><MappedToExistingDimensionLineageID>790</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1448</LineageID><MappedToExistingDimensionLineageID>793</MappedToExistingDimensionLineageID><Name>FirstTimeInCollege</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1449</LineageID><MappedToExistingDimensionLineageID>799</MappedToExistingDimensionLineageID><Name>PrimaryLanguage</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1450</LineageID><MappedToExistingDimensionLineageID>826</MappedToExistingDimensionLineageID><Name>ResidencyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1451</LineageID><MappedToExistingDimensionLineageID>829</MappedToExistingDimensionLineageID><Name>Residency</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1452</LineageID><MappedToExistingDimensionLineageID>844</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1453</LineageID><MappedToExistingDimensionLineageID>847</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1454</LineageID><MappedToExistingDimensionLineageID>853</MappedToExistingDimensionLineageID><Name>RaceWhite</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1455</LineageID><MappedToExistingDimensionLineageID>856</MappedToExistingDimensionLineageID><Name>RaceAfricanAmerican</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1456</LineageID><MappedToExistingDimensionLineageID>859</MappedToExistingDimensionLineageID><Name>RacePacificIslander</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1457</LineageID><MappedToExistingDimensionLineageID>862</MappedToExistingDimensionLineageID><Name>RaceAsian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1458</LineageID><MappedToExistingDimensionLineageID>865</MappedToExistingDimensionLineageID><Name>RaceAmericanIndian</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1459</LineageID><MappedToExistingDimensionLineageID>868</MappedToExistingDimensionLineageID><Name>RaceUnreported</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1461</LineageID><MappedToExistingDimensionLineageID>766</MappedToExistingDimensionLineageID><Name>StudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1462</LineageID><MappedToExistingDimensionLineageID>769</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1463</LineageID><MappedToExistingDimensionLineageID>796</MappedToExistingDimensionLineageID><Name>PrimaryLanguageCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1464</LineageID><MappedToExistingDimensionLineageID>802</MappedToExistingDimensionLineageID><Name>HighSchoolInstitutionId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1465</LineageID><MappedToExistingDimensionLineageID>805</MappedToExistingDimensionLineageID><Name>HighSchool</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1466</LineageID><MappedToExistingDimensionLineageID>808</MappedToExistingDimensionLineageID><Name>HomePhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1467</LineageID><MappedToExistingDimensionLineageID>811</MappedToExistingDimensionLineageID><Name>CellPhoneNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1468</LineageID><MappedToExistingDimensionLineageID>814</MappedToExistingDimensionLineageID><Name>InstitutionalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1469</LineageID><MappedToExistingDimensionLineageID>817</MappedToExistingDimensionLineageID><Name>PersonalEmailAddress</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1470</LineageID><MappedToExistingDimensionLineageID>820</MappedToExistingDimensionLineageID><Name>ImmigrationStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1471</LineageID><MappedToExistingDimensionLineageID>823</MappedToExistingDimensionLineageID><Name>ImmigrationStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1472</LineageID><MappedToExistingDimensionLineageID>832</MappedToExistingDimensionLineageID><Name>ResidencyCountyCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1473</LineageID><MappedToExistingDimensionLineageID>835</MappedToExistingDimensionLineageID><Name>ResidencyCounty</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1474</LineageID><MappedToExistingDimensionLineageID>838</MappedToExistingDimensionLineageID><Name>ResidencyStateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1475</LineageID><MappedToExistingDimensionLineageID>841</MappedToExistingDimensionLineageID><Name>ResidencyState</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1476</LineageID><MappedToExistingDimensionLineageID>850</MappedToExistingDimensionLineageID><Name>FERPARequested</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1477</LineageID><MappedToExistingDimensionLineageID>871</MappedToExistingDimensionLineageID><Name>CountryOfBirthCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1478</LineageID><MappedToExistingDimensionLineageID>874</MappedToExistingDimensionLineageID><Name>CountryOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1479</LineageID><MappedToExistingDimensionLineageID>877</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>1480</LineageID><MappedToExistingDimensionLineageID>880</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2081</LineageID><MappedToExistingDimensionLineageID>760</MappedToExistingDimensionLineageID><Name>StudentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2082</LineageID><MappedToExistingDimensionLineageID>883</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2083</LineageID><MappedToExistingDimensionLineageID>886</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>2084</LineageID><MappedToExistingDimensionLineageID>889</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3007</LineageID><MappedToExistingDimensionLineageID>2923</MappedToExistingDimensionLineageID><Name>InitialPrepStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3008</LineageID><MappedToExistingDimensionLineageID>2926</MappedToExistingDimensionLineageID><Name>VeteranStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3009</LineageID><MappedToExistingDimensionLineageID>2929</MappedToExistingDimensionLineageID><Name>StudentAthlete</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3010</LineageID><MappedToExistingDimensionLineageID>2932</MappedToExistingDimensionLineageID><Name>InternationalStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3121</LineageID><MappedToExistingDimensionLineageID>3052</MappedToExistingDimensionLineageID><Name>HomeCampusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>3122</LineageID><MappedToExistingDimensionLineageID>3055</MappedToExistingDimensionLineageID><Name>HomeCampus</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 |
Name | ID | LineageID |
CellPhoneNumber |
2042 |
811 |
CountryOfBirth |
2063 |
874 |
CountryOfBirthCode |
2062 |
871 |
CountryOfCitizenship |
2065 |
880 |
CountryOfCitizenshipCode |
2064 |
877 |
DateOfBirth |
2054 |
847 |
Ethnicity |
2035 |
790 |
EthnicityCode |
2034 |
787 |
FERPARequested |
2055 |
850 |
FirstName |
2030 |
775 |
FirstTimeInCollege |
2036 |
793 |
FullName |
2028 |
769 |
Gender |
2033 |
784 |
GenderCode |
2032 |
781 |
HighSchool |
2040 |
805 |
HighSchoolInstitutionId |
2039 |
802 |
HomeCampus |
3108 |
3055 |
HomeCampusCode |
3107 |
3052 |
HomePhoneNumber |
2041 |
808 |
ImmigrationStatus |
2046 |
823 |
ImmigrationStatusCode |
2045 |
820 |
InitialPrepStatus |
2983 |
2923 |
InstitutionalEmailAddress |
2043 |
814 |
InternationalStudent |
2986 |
2932 |
LastName |
2029 |
772 |
MiddleName |
2031 |
778 |
PersonalEmailAddress |
2044 |
817 |
PrimaryLanguage |
2038 |
799 |
PrimaryLanguageCode |
2037 |
796 |
RaceAfricanAmerican |
2057 |
856 |
RaceAmericanIndian |
2060 |
865 |
RaceAsian |
2059 |
862 |
RacePacificIslander |
2058 |
859 |
RaceUnreported |
2061 |
868 |
RaceWhite |
2056 |
853 |
Residency |
2048 |
829 |
ResidencyCode |
2047 |
826 |
ResidencyCounty |
2050 |
835 |
ResidencyCountyCode |
2049 |
832 |
ResidencyState |
2052 |
841 |
ResidencyStateCode |
2051 |
838 |
RowEndDate |
2068 |
889 |
RowIsCurrent |
2066 |
883 |
RowStartDate |
2067 |
886 |
StudentAthlete |
2985 |
2929 |
StudentId |
2027 |
766 |
StudentIdAK |
2026 |
763 |
StudentSK |
2025 |
760 |
VeteranStudent |
2984 |
2926 |
ZipCode |
2053 |
844 |
CellPhoneNumber |
2437 |
946 |
CountryOfBirth |
2448 |
968 |
CountryOfBirthCode |
2447 |
966 |
CountryOfCitizenship |
2450 |
972 |
CountryOfCitizenshipCode |
2449 |
970 |
DateOfBirth |
2424 |
918 |
Ethnicity |
2418 |
906 |
EthnicityCode |
2417 |
904 |
FERPARequested |
2446 |
964 |
FirstName |
2413 |
896 |
FirstTimeInCollege |
2419 |
908 |
FullName |
2432 |
936 |
Gender |
2416 |
902 |
GenderCode |
2415 |
900 |
HighSchool |
2435 |
942 |
HighSchoolInstitutionId |
2434 |
940 |
HomeCampus |
3110 |
3049 |
HomeCampusCode |
3109 |
3046 |
HomePhoneNumber |
2436 |
944 |
ImmigrationStatus |
2441 |
954 |
ImmigrationStatusCode |
2440 |
952 |
InitialPrepStatus |
2987 |
2911 |
InstitutionalEmailAddress |
2438 |
948 |
InternationalStudent |
2990 |
2920 |
LastName |
2412 |
894 |
MiddleName |
2414 |
898 |
PersonalEmailAddress |
2439 |
950 |
PrimaryLanguage |
2420 |
910 |
PrimaryLanguageCode |
2433 |
938 |
RaceAfricanAmerican |
2426 |
922 |
RaceAmericanIndian |
2429 |
928 |
RaceAsian |
2428 |
926 |
RacePacificIslander |
2427 |
924 |
RaceUnreported |
2430 |
930 |
RaceWhite |
2425 |
920 |
Residency |
2422 |
914 |
ResidencyCode |
2421 |
912 |
ResidencyCounty |
2443 |
958 |
ResidencyCountyCode |
2442 |
956 |
ResidencyState |
2445 |
962 |
ResidencyStateCode |
2444 |
960 |
StudentAthlete |
2989 |
2917 |
StudentId |
2431 |
934 |
StudentIdAK |
2411 |
892 |
VeteranStudent |
2988 |
2914 |
ZipCode |
2423 |
916 |
Name | ID | LineageID |
CellPhoneNumber |
1383 |
1383 |
CountryOfBirth |
1394 |
1394 |
CountryOfBirthCode |
1393 |
1393 |
CountryOfCitizenship |
1396 |
1396 |
CountryOfCitizenshipCode |
1395 |
1395 |
DateOfBirth |
1369 |
1369 |
Ethnicity |
1363 |
1363 |
EthnicityCode |
1362 |
1362 |
FERPARequested |
1392 |
1392 |
FirstName |
1358 |
1358 |
FirstTimeInCollege |
1364 |
1364 |
FullName |
1378 |
1378 |
Gender |
1361 |
1361 |
GenderCode |
1360 |
1360 |
HighSchool |
1381 |
1381 |
HighSchoolInstitutionId |
1380 |
1380 |
HomeCampus |
3116 |
3116 |
HomeCampusCode |
3115 |
3115 |
HomePhoneNumber |
1382 |
1382 |
ImmigrationStatus |
1387 |
1387 |
ImmigrationStatusCode |
1386 |
1386 |
InitialPrepStatus |
2997 |
2997 |
InstitutionalEmailAddress |
1384 |
1384 |
InternationalStudent |
3000 |
3000 |
LastName |
1357 |
1357 |
MiddleName |
1359 |
1359 |
PersonalEmailAddress |
1385 |
1385 |
PrimaryLanguage |
1365 |
1365 |
PrimaryLanguageCode |
1379 |
1379 |
RaceAfricanAmerican |
1371 |
1371 |
RaceAmericanIndian |
1374 |
1374 |
RaceAsian |
1373 |
1373 |
RacePacificIslander |
1372 |
1372 |
RaceUnreported |
1375 |
1375 |
RaceWhite |
1370 |
1370 |
Residency |
1367 |
1367 |
ResidencyCode |
1366 |
1366 |
ResidencyCounty |
1389 |
1389 |
ResidencyCountyCode |
1388 |
1388 |
ResidencyState |
1391 |
1391 |
ResidencyStateCode |
1390 |
1390 |
RowEndDate |
2076 |
2076 |
RowIsCurrent |
2074 |
2074 |
RowStartDate |
2075 |
2075 |
StudentAthlete |
2999 |
2999 |
StudentId |
1377 |
1377 |
StudentIdAK |
1356 |
1356 |
StudentSK |
2073 |
2073 |
VeteranStudent |
2998 |
2998 |
ZipCode |
1368 |
1368 |
CellPhoneNumber |
1467 |
1467 |
CountryOfBirth |
1478 |
1478 |
CountryOfBirthCode |
1477 |
1477 |
CountryOfCitizenship |
1480 |
1480 |
CountryOfCitizenshipCode |
1479 |
1479 |
DateOfBirth |
1453 |
1453 |
Ethnicity |
1447 |
1447 |
EthnicityCode |
1446 |
1446 |
FERPARequested |
1476 |
1476 |
FirstName |
1442 |
1442 |
FirstTimeInCollege |
1448 |
1448 |
FullName |
1462 |
1462 |
Gender |
1445 |
1445 |
GenderCode |
1444 |
1444 |
HighSchool |
1465 |
1465 |
HighSchoolInstitutionId |
1464 |
1464 |
HomeCampus |
3122 |
3122 |
HomeCampusCode |
3121 |
3121 |
HomePhoneNumber |
1466 |
1466 |
ImmigrationStatus |
1471 |
1471 |
ImmigrationStatusCode |
1470 |
1470 |
InitialPrepStatus |
3007 |
3007 |
InstitutionalEmailAddress |
1468 |
1468 |
InternationalStudent |
3010 |
3010 |
LastName |
1441 |
1441 |
MiddleName |
1443 |
1443 |
PersonalEmailAddress |
1469 |
1469 |
PrimaryLanguage |
1449 |
1449 |
PrimaryLanguageCode |
1463 |
1463 |
RaceAfricanAmerican |
1455 |
1455 |
RaceAmericanIndian |
1458 |
1458 |
RaceAsian |
1457 |
1457 |
RacePacificIslander |
1456 |
1456 |
RaceUnreported |
1459 |
1459 |
RaceWhite |
1454 |
1454 |
Residency |
1451 |
1451 |
ResidencyCode |
1450 |
1450 |
ResidencyCounty |
1473 |
1473 |
ResidencyCountyCode |
1472 |
1472 |
ResidencyState |
1475 |
1475 |
ResidencyStateCode |
1474 |
1474 |
Row Change Reason |
1149 |
1149 |
RowEndDate |
2084 |
2084 |
RowIsCurrent |
2082 |
2082 |
RowStartDate |
2083 |
2083 |
StudentAthlete |
3009 |
3009 |
StudentId |
1461 |
1461 |
StudentIdAK |
1440 |
1440 |
StudentSK |
2081 |
2081 |
VeteranStudent |
3008 |
3008 |
ZipCode |
1452 |
1452 |
Powered by BI Documenter |