|
![]() |
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 |
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>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 |
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 |
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 |