DimOrgUnitLoad
 TF SCD Org Unit (Component)
  Properties
Property Value
Name TF SCD Org Unit
Description
Up Stream Components
Down Stream Components
ID 6677
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF SCD Org Unit" (6677)
Is Default Locale True
Pipeline Version 0
Uses Dispositions False
Validate External Metadata True
Version 11
  Connections
Name Connection Manager Description
  Custom Properties
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>6765</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6766</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6767</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6768</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6769</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6770</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6771</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6772</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6773</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6774</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6775</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6776</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6777</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6778</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6779</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6780</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6781</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6782</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6783</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6784</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6785</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6786</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>6787</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6788</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6789</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6790</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6791</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6792</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6793</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6794</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>6953</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6954</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6955</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6956</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6957</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6958</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6959</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6960</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6961</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6962</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6963</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6964</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6965</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6966</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6967</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6968</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6969</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6970</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6971</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6972</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6973</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6974</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6975</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6976</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6977</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6978</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6979</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6980</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6981</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6982</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6983</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6984</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7312</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></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>6763</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6764</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7081</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7082</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7083</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7084</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7085</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7086</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7087</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7088</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7089</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7090</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7091</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7092</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7093</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7094</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7095</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7096</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7097</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7098</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7099</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7100</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7101</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7102</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7103</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7104</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7105</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7106</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7107</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7108</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7109</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7110</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7111</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7112</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7322</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Existing Dimension Columns
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitSK</Name><LineageID>6520</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>OrgUnitAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6427</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitAK</Name><LineageID>6523</LineageID><DataType>129</DataType><Length>16</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OrgUnit</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6430</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnit</Name><LineageID>6526</LineageID><DataType>129</DataType><Length>18</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OrgUnitName</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6433</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitName</Name><LineageID>6529</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OrgUnitStatusCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6436</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitStatusCode</Name><LineageID>6532</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OrgUnitStatus</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6439</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitStatus</Name><LineageID>6535</LineageID><DataType>129</DataType><Length>15</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FundCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6442</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FundCode</Name><LineageID>6538</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Fund</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6445</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Fund</Name><LineageID>6541</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FunctionCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6448</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FunctionCode</Name><LineageID>6544</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FunctionDescription</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6451</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>FunctionDescription</Name><LineageID>6547</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SubFunctionCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6454</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SubFunctionCode</Name><LineageID>6550</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>SubFunction</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6457</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>SubFunction</Name><LineageID>6553</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LocationCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6460</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LocationCode</Name><LineageID>6556</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Location</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6463</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Location</Name><LineageID>6559</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Qual1</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6466</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Qual1</Name><LineageID>6562</LineageID><DataType>129</DataType><Length>6</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ControlOrgUnit</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6469</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ControlOrgUnit</Name><LineageID>6565</LineageID><DataType>129</DataType><Length>18</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ControlOrgUnitName</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6472</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ControlOrgUnitName</Name><LineageID>6568</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BudgetManagerId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6475</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BudgetManagerId</Name><LineageID>6571</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BudgetManager</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6478</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>BudgetManager</Name><LineageID>6574</LineageID><DataType>129</DataType><Length>40</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>UserGroupId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6481</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>UserGroupId</Name><LineageID>6577</LineageID><DataType>129</DataType><Length>16</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>UserGroup</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6484</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>UserGroup</Name><LineageID>6580</LineageID><DataType>129</DataType><Length>40</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrincipalAdminId</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6487</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrincipalAdminId</Name><LineageID>6583</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrincipalAdmin</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6490</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PrincipalAdmin</Name><LineageID>6586</LineageID><DataType>129</DataType><Length>40</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ProjectNumber</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6493</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ProjectNumber</Name><LineageID>6589</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReportDistributionCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6496</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReportDistributionCode</Name><LineageID>6592</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ReportDistribution</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6499</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>ReportDistribution</Name><LineageID>6595</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OrgUnitGrouping</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6502</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>OrgUnitGrouping</Name><LineageID>6598</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StartDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6505</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StartDate</Name><LineageID>6601</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EndDate</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>6508</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EndDate</Name><LineageID>6604</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>6607</LineageID><DataType>129</DataType><Length>1</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>6613</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StateOrgUnit</SourceSystemColumnName><SourceSystemLineageID>7270</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>StateOrgUnit</Name><LineageID>7273</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition>
Existing Dimension Input Counter
Expired SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6761</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7017</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7018</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7019</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7020</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7021</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7022</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7023</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7024</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7025</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7026</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7027</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7028</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7029</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7030</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7031</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7032</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7033</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7034</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7035</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7036</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7037</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7038</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7039</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7040</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7041</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7042</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7043</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7044</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7045</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7046</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7047</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7048</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7316</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Expired SCD2 Output Counter
Hashing Algorithm
0
Inferred Member False Value for Integer
1
Inferred Member False Value for Strings
N
Inferred Member True Value for Integer
0
Inferred Member True Value for Strings
Y
Invalid Input Output Counter
Last Window Size
0,0
Manage Surrogate Keys
False
New Output Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6759</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>6919</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6920</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6921</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6922</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6923</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6924</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6925</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6926</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6927</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6928</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6929</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6930</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6931</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6932</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6933</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6934</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6935</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6936</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6937</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6938</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6939</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6940</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6941</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6942</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6943</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6944</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6945</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6946</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6947</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6948</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6949</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6950</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7309</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New Output Counter
New SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6762</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7049</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7050</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7051</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7052</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7053</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7054</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7055</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7056</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7057</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7058</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7059</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7060</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7061</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7062</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7063</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7064</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7065</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7066</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7067</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7068</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7069</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7070</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7071</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7072</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7073</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7074</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7075</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7076</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7077</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7078</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7079</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7080</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7319</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
New SCD2 Output Counter
Number of Processing Threads
0
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>#6424</string><string>#6427</string><string>#6430</string><string>#6433</string><string>#6436</string><string>#6439</string><string>#6442</string><string>#6445</string><string>#6448</string><string>#6451</string><string>#6454</string><string>#6457</string><string>#6460</string><string>#6463</string><string>#6466</string><string>#6469</string><string>#6472</string><string>#6475</string><string>#6478</string><string>#6481</string><string>#6484</string><string>#6487</string><string>#6490</string><string>#6493</string><string>#6496</string><string>#6499</string><string>#6502</string><string>#6505</string><string>#6508</string><string>#6511</string><string>#6514</string><string>#7270</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>6795</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6796</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6797</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6798</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6799</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6800</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6801</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6802</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6803</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6804</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6805</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6806</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6807</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6808</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6809</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6810</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6811</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6812</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6813</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6814</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6815</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6816</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6817</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6818</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6819</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6820</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6821</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>6887</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6888</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6889</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6890</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6891</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6892</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6893</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6894</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6895</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6896</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6897</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6898</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6899</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6900</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6901</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6902</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6903</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6904</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6905</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6906</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6907</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6908</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6909</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6910</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6911</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6912</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6913</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6914</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6915</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6916</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6917</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6918</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7308</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</Name></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList>
Unchanged Output Counter
Update SCD1 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>6760</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6985</LineageID><MappedToExistingDimensionLineageID>6520</MappedToExistingDimensionLineageID><Name>OrgUnitSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6986</LineageID><MappedToExistingDimensionLineageID>6523</MappedToExistingDimensionLineageID><Name>OrgUnitAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6987</LineageID><MappedToExistingDimensionLineageID>6526</MappedToExistingDimensionLineageID><Name>OrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6988</LineageID><MappedToExistingDimensionLineageID>6529</MappedToExistingDimensionLineageID><Name>OrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6989</LineageID><MappedToExistingDimensionLineageID>6532</MappedToExistingDimensionLineageID><Name>OrgUnitStatusCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6990</LineageID><MappedToExistingDimensionLineageID>6535</MappedToExistingDimensionLineageID><Name>OrgUnitStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6991</LineageID><MappedToExistingDimensionLineageID>6538</MappedToExistingDimensionLineageID><Name>FundCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6992</LineageID><MappedToExistingDimensionLineageID>6541</MappedToExistingDimensionLineageID><Name>Fund</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6993</LineageID><MappedToExistingDimensionLineageID>6544</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6994</LineageID><MappedToExistingDimensionLineageID>6547</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6995</LineageID><MappedToExistingDimensionLineageID>6550</MappedToExistingDimensionLineageID><Name>SubFunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6996</LineageID><MappedToExistingDimensionLineageID>6553</MappedToExistingDimensionLineageID><Name>SubFunction</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6997</LineageID><MappedToExistingDimensionLineageID>6556</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6998</LineageID><MappedToExistingDimensionLineageID>6559</MappedToExistingDimensionLineageID><Name>Location</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>6999</LineageID><MappedToExistingDimensionLineageID>6562</MappedToExistingDimensionLineageID><Name>Qual1</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7000</LineageID><MappedToExistingDimensionLineageID>6565</MappedToExistingDimensionLineageID><Name>ControlOrgUnit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7001</LineageID><MappedToExistingDimensionLineageID>6568</MappedToExistingDimensionLineageID><Name>ControlOrgUnitName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7002</LineageID><MappedToExistingDimensionLineageID>6571</MappedToExistingDimensionLineageID><Name>BudgetManagerId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7003</LineageID><MappedToExistingDimensionLineageID>6574</MappedToExistingDimensionLineageID><Name>BudgetManager</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7004</LineageID><MappedToExistingDimensionLineageID>6577</MappedToExistingDimensionLineageID><Name>UserGroupId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7005</LineageID><MappedToExistingDimensionLineageID>6580</MappedToExistingDimensionLineageID><Name>UserGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7006</LineageID><MappedToExistingDimensionLineageID>6583</MappedToExistingDimensionLineageID><Name>PrincipalAdminId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7007</LineageID><MappedToExistingDimensionLineageID>6586</MappedToExistingDimensionLineageID><Name>PrincipalAdmin</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7008</LineageID><MappedToExistingDimensionLineageID>6589</MappedToExistingDimensionLineageID><Name>ProjectNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7009</LineageID><MappedToExistingDimensionLineageID>6592</MappedToExistingDimensionLineageID><Name>ReportDistributionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7010</LineageID><MappedToExistingDimensionLineageID>6595</MappedToExistingDimensionLineageID><Name>ReportDistribution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7011</LineageID><MappedToExistingDimensionLineageID>6598</MappedToExistingDimensionLineageID><Name>OrgUnitGrouping</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7012</LineageID><MappedToExistingDimensionLineageID>6601</MappedToExistingDimensionLineageID><Name>StartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7013</LineageID><MappedToExistingDimensionLineageID>6604</MappedToExistingDimensionLineageID><Name>EndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7014</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7015</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7016</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7313</LineageID><MappedToExistingDimensionLineageID>7273</MappedToExistingDimensionLineageID><Name>StateOrgUnit</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
  Input Columns
Name ID LineageID
BudgetManager
6843
6574
BudgetManagerId
6842
6571
ControlOrgUnit
6840
6565
ControlOrgUnitName
6841
6568
EndDate
6853
6604
FunctionCode
6833
6544
FunctionDescription
6834
6547
Fund
6832
6541
FundCode
6831
6538
Location
6838
6559
LocationCode
6837
6556
OrgUnit
6827
6526
OrgUnitAK
6826
6523
OrgUnitGrouping
6851
6598
OrgUnitName
6828
6529
OrgUnitSK
6825
6520
OrgUnitStatus
6830
6535
OrgUnitStatusCode
6829
6532
PrincipalAdmin
6847
6586
PrincipalAdminId
6846
6583
ProjectNumber
6848
6589
Qual1
6839
6562
ReportDistribution
6850
6595
ReportDistributionCode
6849
6592
RowEndDate
6856
6613
RowIsCurrent
6854
6607
RowStartDate
6855
6610
StartDate
6852
6601
StateOrgUnit
7306
7273
SubFunction
6836
6553
SubFunctionCode
6835
6550
UserGroup
6845
6580
UserGroupId
6844
6577
BudgetManager
6874
6478
BudgetManagerId
6873
6475
ControlOrgUnit
6871
6469
ControlOrgUnitName
6872
6472
EndDate
6884
6508
FunctionCode
6864
6448
FunctionDescription
6865
6451
Fund
6863
6445
FundCode
6862
6442
Location
6869
6463
LocationCode
6868
6460
OrgUnit
6858
6430
OrgUnitAK
6857
6427
OrgUnitGrouping
6882
6502
OrgUnitName
6859
6433
OrgUnitStatus
6861
6439
OrgUnitStatusCode
6860
6436
PrincipalAdmin
6878
6490
PrincipalAdminId
6877
6487
ProjectNumber
6879
6493
Qual1
6870
6466
ReportDistribution
6881
6499
ReportDistributionCode
6880
6496
StartDate
6883
6505
StateOrgUnit
7307
7270
SubFunction
6867
6457
SubFunctionCode
6866
6454
UserGroup
6876
6484
UserGroupId
6875
6481
  Output Columns
Name ID LineageID
StateOrgUnit
7312
7312
StateOrgUnit
7316
7316
StateOrgUnit
7322
7322
BudgetManager
6937
6937
BudgetManagerId
6936
6936
ControlOrgUnit
6934
6934
ControlOrgUnitName
6935
6935
EndDate
6947
6947
FunctionCode
6927
6927
FunctionDescription
6928
6928
Fund
6926
6926
FundCode
6925
6925
Location
6932
6932
LocationCode
6931
6931
OrgUnit
6921
6921
OrgUnitAK
6920
6920
OrgUnitGrouping
6945
6945
OrgUnitName
6922
6922
OrgUnitSK
6919
6919
OrgUnitStatus
6924
6924
OrgUnitStatusCode
6923
6923
PrincipalAdmin
6941
6941
PrincipalAdminId
6940
6940
ProjectNumber
6942
6942
Qual1
6933
6933
ReportDistribution
6944
6944
ReportDistributionCode
6943
6943
RowEndDate
6950
6950
RowIsCurrent
6948
6948
RowStartDate
6949
6949
StartDate
6946
6946
StateOrgUnit
7309
7309
SubFunction
6930
6930
SubFunctionCode
6929
6929
UserGroup
6939
6939
UserGroupId
6938
6938
StateOrgUnit
7319
7319
BudgetManager
6905
6905
BudgetManagerId
6904
6904
ControlOrgUnit
6902
6902
ControlOrgUnitName
6903
6903
EndDate
6915
6915
FunctionCode
6895
6895
FunctionDescription
6896
6896
Fund
6894
6894
FundCode
6893
6893
Location
6900
6900
LocationCode
6899
6899
OrgUnit
6889
6889
OrgUnitAK
6888
6888
OrgUnitGrouping
6913
6913
OrgUnitName
6890
6890
OrgUnitSK
6887
6887
OrgUnitStatus
6892
6892
OrgUnitStatusCode
6891
6891
PrincipalAdmin
6909
6909
PrincipalAdminId
6908
6908
ProjectNumber
6910
6910
Qual1
6901
6901
ReportDistribution
6912
6912
ReportDistributionCode
6911
6911
RowEndDate
6918
6918
RowIsCurrent
6916
6916
RowStartDate
6917
6917
StartDate
6914
6914
StateOrgUnit
7308
7308
SubFunction
6898
6898
SubFunctionCode
6897
6897
UserGroup
6907
6907
UserGroupId
6906
6906
BudgetManager
7003
7003
BudgetManagerId
7002
7002
ControlOrgUnit
7000
7000
ControlOrgUnitName
7001
7001
EndDate
7013
7013
FunctionCode
6993
6993
FunctionDescription
6994
6994
Fund
6992
6992
FundCode
6991
6991
Location
6998
6998
LocationCode
6997
6997
OrgUnit
6987
6987
OrgUnitAK
6986
6986
OrgUnitGrouping
7011
7011
OrgUnitName
6988
6988
OrgUnitSK
6985
6985
OrgUnitStatus
6990
6990
OrgUnitStatusCode
6989
6989
PrincipalAdmin
7007
7007
PrincipalAdminId
7006
7006
ProjectNumber
7008
7008
Qual1
6999
6999
ReportDistribution
7010
7010
ReportDistributionCode
7009
7009
Row Change Reason
6760
6760
StartDate
7012
7012
StateOrgUnit
7313
7313
SubFunction
6996
6996
SubFunctionCode
6995
6995
UserGroup
7005
7005
UserGroupId
7004
7004
Powered by BI Documenter