|
![]() |
Property | Value |
Name | TF_SCD Gl Code |
Description | |
Up Stream Components | |
Down Stream Components | |
ID | 7391 |
Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
Contact Info | |
Identification String | component "TF_SCD Gl Code" (7391) |
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>7479</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7480</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7481</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7482</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7483</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7484</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7485</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7486</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7487</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7488</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7489</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7490</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7491</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7492</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7493</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7494</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7495</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7496</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7497</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7498</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7499</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7500</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>7501</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7502</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7503</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7504</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7505</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7506</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7507</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7508</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>7611</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7612</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7613</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7614</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7615</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7616</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7617</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7618</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7619</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7620</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7621</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7622</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7623</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7624</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7625</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7626</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7627</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7628</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7884</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8011</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8012</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Deleted Output Counter |
|
Error Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>1</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7477</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7478</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7683</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7684</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7685</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7686</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7687</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7688</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7689</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7690</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7691</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7692</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7693</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7694</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7695</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7696</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7697</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7698</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7699</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7700</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7888</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8019</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8020</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><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><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>6610</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>6613</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SpecialMembersColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCodeSK</Name><LineageID>7315</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>GlCodeAK</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7273</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCodeAK</Name><LineageID>7318</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Glc</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7276</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Glc</Name><LineageID>7321</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Qual2</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7279</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Qual2</Name><LineageID>7324</LineageID><DataType>129</DataType><Length>4</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlClassCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7282</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlClassCode</Name><LineageID>7327</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlClass</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7285</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlClass</Name><LineageID>7330</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCategoryCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7288</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCategoryCode</Name><LineageID>7333</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCategory</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7291</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCategory</Name><LineageID>7336</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlSubCategoryCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7294</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlSubCategoryCode</Name><LineageID>7339</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlSubCategory</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7297</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlSubCategory</Name><LineageID>7342</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlcDescription</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7300</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlcDescription</Name><LineageID>7345</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCodeName</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7303</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCodeName</Name><LineageID>7348</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCodeSubTotalCode</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7306</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCodeSubTotalCode</Name><LineageID>7351</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlCodeSubTotal</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7309</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlCodeSubTotal</Name><LineageID>7354</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AccountSign</SourceSystemColumnName><SpecialMembersColumnName /><SourceSystemLineageID>7312</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AccountSign</Name><LineageID>7357</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GlGroup</SourceSystemColumnName><SourceSystemLineageID>7820</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>GlGroup</Name><LineageID>7823</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HrClassification</SourceSystemColumnName><SourceSystemLineageID>7936</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HrClassification</Name><LineageID>7998</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HrTimeStatus</SourceSystemColumnName><SourceSystemLineageID>7939</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HrTimeStatus</Name><LineageID>8001</LineageID><DataType>129</DataType><Length>30</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>7475</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7647</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7648</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7649</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7650</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7651</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7652</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7653</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7654</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7655</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7656</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7657</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7658</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7659</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7660</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7661</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7662</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7663</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7664</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7886</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8015</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8016</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Expired SCD2 Output Counter |
|
Hashing Algorithm |
0 |
Inferred Member False Value for Integer |
1 |
Inferred Member False Value for Strings |
N |
Inferred Member True Value for Integer |
0 |
Inferred Member True Value for Strings |
Y |
Invalid Input Output Counter |
|
Last Window Size |
0,0 |
Manage Surrogate Keys |
False |
New Output Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7473</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7591</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7592</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7593</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7594</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7595</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7596</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7597</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7598</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7599</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7600</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7601</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7602</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7603</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7604</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7605</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7606</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7607</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7608</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7883</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8009</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8010</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</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>7476</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7665</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7666</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7667</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7668</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7669</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7670</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7671</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7672</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7673</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7674</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7675</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7676</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7677</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7678</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7679</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7680</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7681</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7682</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7887</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8017</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8018</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></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>#6511</string><string>#6514</string><string>#7270</string><string>#7273</string><string>#7276</string><string>#7279</string><string>#7282</string><string>#7285</string><string>#7288</string><string>#7291</string><string>#7294</string><string>#7297</string><string>#7300</string><string>#7303</string><string>#7306</string><string>#7309</string><string>#7312</string><string>#7820</string><string>#7936</string><string>#7939</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>7509</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7510</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7511</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7512</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7513</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7514</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7515</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7516</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7517</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7518</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7519</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7520</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7521</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7522</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7523</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7524</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7525</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7526</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7527</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7528</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7529</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7530</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7531</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7532</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7533</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7534</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7535</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>7573</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7574</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7575</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7576</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7577</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7578</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7579</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7580</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7581</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7582</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7583</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7584</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7585</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7586</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7587</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7588</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7589</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7590</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7882</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8007</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8008</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></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>7474</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7629</LineageID><MappedToExistingDimensionLineageID>6607</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7630</LineageID><MappedToExistingDimensionLineageID>6610</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7631</LineageID><MappedToExistingDimensionLineageID>6613</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7632</LineageID><MappedToExistingDimensionLineageID>7315</MappedToExistingDimensionLineageID><Name>GlCodeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7633</LineageID><MappedToExistingDimensionLineageID>7318</MappedToExistingDimensionLineageID><Name>GlCodeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7634</LineageID><MappedToExistingDimensionLineageID>7321</MappedToExistingDimensionLineageID><Name>Glc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7635</LineageID><MappedToExistingDimensionLineageID>7324</MappedToExistingDimensionLineageID><Name>Qual2</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7636</LineageID><MappedToExistingDimensionLineageID>7327</MappedToExistingDimensionLineageID><Name>GlClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7637</LineageID><MappedToExistingDimensionLineageID>7330</MappedToExistingDimensionLineageID><Name>GlClass</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7638</LineageID><MappedToExistingDimensionLineageID>7333</MappedToExistingDimensionLineageID><Name>GlCategoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7639</LineageID><MappedToExistingDimensionLineageID>7336</MappedToExistingDimensionLineageID><Name>GlCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7640</LineageID><MappedToExistingDimensionLineageID>7339</MappedToExistingDimensionLineageID><Name>GlSubCategoryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7641</LineageID><MappedToExistingDimensionLineageID>7342</MappedToExistingDimensionLineageID><Name>GlSubCategory</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7642</LineageID><MappedToExistingDimensionLineageID>7345</MappedToExistingDimensionLineageID><Name>GlcDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7643</LineageID><MappedToExistingDimensionLineageID>7348</MappedToExistingDimensionLineageID><Name>GlCodeName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7644</LineageID><MappedToExistingDimensionLineageID>7351</MappedToExistingDimensionLineageID><Name>GlCodeSubTotalCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7645</LineageID><MappedToExistingDimensionLineageID>7354</MappedToExistingDimensionLineageID><Name>GlCodeSubTotal</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7646</LineageID><MappedToExistingDimensionLineageID>7357</MappedToExistingDimensionLineageID><Name>AccountSign</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7885</LineageID><MappedToExistingDimensionLineageID>7823</MappedToExistingDimensionLineageID><Name>GlGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8013</LineageID><MappedToExistingDimensionLineageID>7998</MappedToExistingDimensionLineageID><Name>HrClassification</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8014</LineageID><MappedToExistingDimensionLineageID>8001</MappedToExistingDimensionLineageID><Name>HrTimeStatus</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 |
AccountSign |
7556 |
7357 |
Glc |
7544 |
7321 |
GlCategory |
7549 |
7336 |
GlCategoryCode |
7548 |
7333 |
GlcDescription |
7552 |
7345 |
GlClass |
7547 |
7330 |
GlClassCode |
7546 |
7327 |
GlCodeAK |
7543 |
7318 |
GlCodeName |
7553 |
7348 |
GlCodeSK |
7542 |
7315 |
GlCodeSubTotal |
7555 |
7354 |
GlCodeSubTotalCode |
7554 |
7351 |
GlGroup |
7880 |
7823 |
GlSubCategory |
7551 |
7342 |
GlSubCategoryCode |
7550 |
7339 |
HrClassification |
8003 |
7998 |
HrTimeStatus |
8004 |
8001 |
Qual2 |
7545 |
7324 |
RowEndDate |
7541 |
6613 |
RowIsCurrent |
7539 |
6607 |
RowStartDate |
7540 |
6610 |
AccountSign |
7570 |
7312 |
Glc |
7558 |
7276 |
GlCategory |
7563 |
7291 |
GlCategoryCode |
7562 |
7288 |
GlcDescription |
7566 |
7300 |
GlClass |
7561 |
7285 |
GlClassCode |
7560 |
7282 |
GlCodeAK |
7557 |
7273 |
GlCodeName |
7567 |
7303 |
GlCodeSubTotal |
7569 |
7309 |
GlCodeSubTotalCode |
7568 |
7306 |
GlGroup |
7881 |
7820 |
GlSubCategory |
7565 |
7297 |
GlSubCategoryCode |
7564 |
7294 |
HrClassification |
8005 |
7936 |
HrTimeStatus |
8006 |
7939 |
Qual2 |
7559 |
7279 |
Name | ID | LineageID |
AccountSign |
7608 |
7608 |
Glc |
7596 |
7596 |
GlCategory |
7601 |
7601 |
GlCategoryCode |
7600 |
7600 |
GlcDescription |
7604 |
7604 |
GlClass |
7599 |
7599 |
GlClassCode |
7598 |
7598 |
GlCodeAK |
7595 |
7595 |
GlCodeName |
7605 |
7605 |
GlCodeSK |
7594 |
7594 |
GlCodeSubTotal |
7607 |
7607 |
GlCodeSubTotalCode |
7606 |
7606 |
GlGroup |
7883 |
7883 |
GlSubCategory |
7603 |
7603 |
GlSubCategoryCode |
7602 |
7602 |
HrClassification |
8009 |
8009 |
HrTimeStatus |
8010 |
8010 |
Qual2 |
7597 |
7597 |
RowEndDate |
7593 |
7593 |
RowIsCurrent |
7591 |
7591 |
RowStartDate |
7592 |
7592 |
AccountSign |
7646 |
7646 |
Glc |
7634 |
7634 |
GlCategory |
7639 |
7639 |
GlCategoryCode |
7638 |
7638 |
GlcDescription |
7642 |
7642 |
GlClass |
7637 |
7637 |
GlClassCode |
7636 |
7636 |
GlCodeAK |
7633 |
7633 |
GlCodeName |
7643 |
7643 |
GlCodeSK |
7632 |
7632 |
GlCodeSubTotal |
7645 |
7645 |
GlCodeSubTotalCode |
7644 |
7644 |
GlGroup |
7885 |
7885 |
GlSubCategory |
7641 |
7641 |
GlSubCategoryCode |
7640 |
7640 |
HrClassification |
8013 |
8013 |
HrTimeStatus |
8014 |
8014 |
Qual2 |
7635 |
7635 |
Powered by BI Documenter |