|
![]() |
Property | Value |
Name | TF_SCD DimPosition |
Description | |
Up Stream Components | |
Down Stream Components | |
ID | 7345 |
Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
Contact Info | |
Identification String | component "TF_SCD DimPosition" (7345) |
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>7433</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Package Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7434</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Execution Instance</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7435</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Machine Name</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7436</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Start Time</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7437</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Existing Dimension Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7438</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Special Members Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7439</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Source System Input Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7440</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Unchanged Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7441</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7442</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Deleted Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7443</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 Expired Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7444</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD2 New Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7445</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>SCD1 Updated Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7446</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Output Row Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7447</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7448</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Existing Dimension Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7449</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7450</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Special Members Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7451</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7452</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Source System Row Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7453</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds until first key match</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7454</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>7455</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Maximum number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7456</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Average number of rows held in cache</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7457</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Upstream Backpressure Generated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7458</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Sort Optimization Cache Hit Percentage</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7459</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time First Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7460</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Time Last Output Row Produced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7461</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Milliseconds of Downstream Backpressure Experienced</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7462</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>7670</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7684</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7692</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8233</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8234</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8235</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8236</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8237</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8238</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8239</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8240</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8241</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8242</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8243</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8244</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8245</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8246</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8247</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8248</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8249</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8250</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8251</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8252</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8253</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8254</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8255</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8256</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8257</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8259</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8260</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8534</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8535</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8597</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8649</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</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>7431</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7432</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Invalid Input Error Description</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7680</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7688</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7696</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8345</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8346</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8347</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8348</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8349</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8350</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8351</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8352</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8353</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8354</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8355</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8356</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8357</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8358</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8359</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8360</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8361</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8362</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8363</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8364</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8365</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8366</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8367</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8368</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8369</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8371</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8372</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8548</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8549</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8605</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8659</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
Existing Dimension Columns |
<?xml version="1.0" encoding="utf-16"?><ArrayOfInputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>7</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowIsCurrent</Name><LineageID>8041</LineageID><DataType>130</DataType><Length>1</Length></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>5</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowStartDate</Name><LineageID>8044</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SpecialMembersColumnName /><SCDColumnType>6</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>RowEndDate</Name><LineageID>8047</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>PositionSK</Name><LineageID>7957</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>PositionAK</SourceSystemColumnName><SourceSystemLineageID>7789</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionAK</Name><LineageID>7960</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionCode</SourceSystemColumnName><SourceSystemLineageID>7792</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionCode</Name><LineageID>7963</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionTitle</SourceSystemColumnName><SourceSystemLineageID>7795</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionTitle</Name><LineageID>7966</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionStatus</SourceSystemColumnName><SourceSystemLineageID>7798</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionStatus</Name><LineageID>7969</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionTypeCode</SourceSystemColumnName><SourceSystemLineageID>7801</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionTypeCode</Name><LineageID>7972</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionType</SourceSystemColumnName><SourceSystemLineageID>7804</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionType</Name><LineageID>7975</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FunctionCode</SourceSystemColumnName><SourceSystemLineageID>7807</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FunctionCode</Name><LineageID>7978</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FunctionDescription</SourceSystemColumnName><SourceSystemLineageID>7810</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FunctionDescription</Name><LineageID>7981</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateEstablished</SourceSystemColumnName><SourceSystemLineageID>7813</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>DateEstablished</Name><LineageID>7984</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateInactivated</SourceSystemColumnName><SourceSystemLineageID>7816</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>DateInactivated</Name><LineageID>7987</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobGroupCode</SourceSystemColumnName><SourceSystemLineageID>7819</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobGroupCode</Name><LineageID>7990</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobGroup</SourceSystemColumnName><SourceSystemLineageID>7822</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobGroup</Name><LineageID>7993</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobClassCode</SourceSystemColumnName><SourceSystemLineageID>7825</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobClassCode</Name><LineageID>7996</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayBasis</SourceSystemColumnName><SourceSystemLineageID>7828</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayBasis</Name><LineageID>7999</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Budgeted</SourceSystemColumnName><SourceSystemLineageID>7831</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Budgeted</Name><LineageID>8002</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RegularTemporary</SourceSystemColumnName><SourceSystemLineageID>7834</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>RegularTemporary</Name><LineageID>8005</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PooledIndicator</SourceSystemColumnName><SourceSystemLineageID>7837</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PooledIndicator</Name><LineageID>8008</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ExemptStatus</SourceSystemColumnName><SourceSystemLineageID>7840</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ExemptStatus</Name><LineageID>8011</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionFulltimeParttime</SourceSystemColumnName><SourceSystemLineageID>7843</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionFulltimeParttime</Name><LineageID>8014</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimarySalaryAccountNumber</SourceSystemColumnName><SourceSystemLineageID>7846</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PrimarySalaryAccountNumber</Name><LineageID>8017</LineageID><DataType>129</DataType><Length>28</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountOfActiveAssignments</SourceSystemColumnName><SourceSystemLineageID>7849</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>CountOfActiveAssignments</Name><LineageID>8020</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountOfInactiveAssignments</SourceSystemColumnName><SourceSystemLineageID>7852</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>CountOfInactiveAssignments</Name><LineageID>8023</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InactiveReasonCode</SourceSystemColumnName><SourceSystemLineageID>7855</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>InactiveReasonCode</Name><LineageID>8026</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InactiveReason</SourceSystemColumnName><SourceSystemLineageID>7858</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>InactiveReason</Name><LineageID>8029</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FulltimeEquivalent</SourceSystemColumnName><SourceSystemLineageID>7864</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>FulltimeEquivalent</Name><LineageID>8035</LineageID><DataType>131</DataType><Precision>5</Precision><Scale>2</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>WeeklyAuthorizedHours</SourceSystemColumnName><SourceSystemLineageID>7867</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>WeeklyAuthorizedHours</Name><LineageID>8038</LineageID><DataType>131</DataType><Precision>5</Precision><Scale>2</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LocationCode</SourceSystemColumnName><SourceSystemLineageID>8485</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LocationCode</Name><LineageID>8517</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Location</SourceSystemColumnName><SourceSystemLineageID>8488</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Location</Name><LineageID>8520</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InactiveVacantDateRange</SourceSystemColumnName><SourceSystemLineageID>8559</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>InactiveVacantDateRange</Name><LineageID>8562</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MultipleFunds</SourceSystemColumnName><SourceSystemLineageID>8611</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>MultipleFunds</Name><LineageID>8614</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition> |
Existing Dimension Input Counter |
|
Expired SCD2 Columns |
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7429</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7674</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7686</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7694</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8289</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8290</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8291</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8292</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8293</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8294</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8295</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8296</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8297</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8298</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8299</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8300</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8301</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8302</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8303</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8304</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8305</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8306</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8307</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8308</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8309</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8310</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8311</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8312</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8313</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8315</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8316</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8540</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8541</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8601</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8653</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</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>7427</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7667</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7683</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7691</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8205</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8206</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8207</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8208</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8209</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8210</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8211</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8212</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8213</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8214</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8215</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8216</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8217</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8218</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8219</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8220</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8221</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8222</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8223</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8224</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8225</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8226</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8227</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8228</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8229</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8231</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8232</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8530</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8531</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8594</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8646</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</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>7430</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7677</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7687</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7695</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8317</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8318</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8319</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8320</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8321</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8322</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8323</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8324</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8325</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8326</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8327</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8328</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8329</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8330</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8331</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8332</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8333</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8334</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8335</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8336</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8337</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8338</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8339</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8340</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8341</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8343</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8344</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8544</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8545</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8604</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8656</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition></ArrayOfOutputColumnDefinition></OutputColumnDefinitionList> |
New SCD2 Output Counter |
|
Number of Processing Threads |
2 |
Processing Timeout |
3600 |
SCD2 Current Member False Value for Integer |
1 |
SCD2 Current Member False Value for Strings |
N |
SCD2 Current Member True Value for Integer |
0 |
SCD2 Current Member True Value for Strings |
Y |
SCD2 Date Millisecond Precision |
3 |
SCD2 Desired Expiry For Current Records |
0 |
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>#7786</string><string>#7789</string><string>#7792</string><string>#7795</string><string>#7798</string><string>#7801</string><string>#7804</string><string>#7807</string><string>#7810</string><string>#7813</string><string>#7816</string><string>#7819</string><string>#7822</string><string>#7825</string><string>#7828</string><string>#7831</string><string>#7834</string><string>#7837</string><string>#7840</string><string>#7843</string><string>#7846</string><string>#7849</string><string>#7852</string><string>#7855</string><string>#7858</string><string>#7864</string><string>#7867</string><string>#8485</string><string>#8488</string><string>#8559</string><string>#8611</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>7463</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval Start</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7464</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Interval End</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7465</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - ED Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7466</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SM Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7467</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Input - SS Rows Received</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7468</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - ED Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7469</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SM Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7470</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Cache - SS Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7471</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Unchanged Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7472</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7473</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Deleted Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7474</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Updated SCD1 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7475</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - Expired SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7476</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Output - New SCD2 Rows Sent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7477</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Units Built</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7478</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Rows Built Into Work Units</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7479</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Bulk Matched Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7480</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Match Prep - Work Unit Count</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7481</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Matched Key Queue Length</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7482</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Skipped Rows</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7483</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Regular Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7484</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Sort Optimization Determination</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7485</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Matching - Undetermined</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7486</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Waiting For Input</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7487</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Matching Waiting On Caching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7488</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Thread Delay - Processing Waiting On Matching</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7489</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>7666</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7682</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7690</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8177</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8178</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8179</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8180</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8181</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8182</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8183</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8184</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8185</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8186</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8187</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8188</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8189</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8190</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8191</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8192</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8193</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8194</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8195</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8196</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8197</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8198</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8199</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8200</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8201</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8203</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8204</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8528</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8529</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8593</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8645</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</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>8373</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7671</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7685</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>7693</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8261</LineageID><MappedToExistingDimensionLineageID>7957</MappedToExistingDimensionLineageID><Name>PositionSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8262</LineageID><MappedToExistingDimensionLineageID>7960</MappedToExistingDimensionLineageID><Name>PositionAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8263</LineageID><MappedToExistingDimensionLineageID>7963</MappedToExistingDimensionLineageID><Name>PositionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8264</LineageID><MappedToExistingDimensionLineageID>7966</MappedToExistingDimensionLineageID><Name>PositionTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8265</LineageID><MappedToExistingDimensionLineageID>7969</MappedToExistingDimensionLineageID><Name>PositionStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8266</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8267</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8268</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8269</LineageID><MappedToExistingDimensionLineageID>7981</MappedToExistingDimensionLineageID><Name>FunctionDescription</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8270</LineageID><MappedToExistingDimensionLineageID>7984</MappedToExistingDimensionLineageID><Name>DateEstablished</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8271</LineageID><MappedToExistingDimensionLineageID>7987</MappedToExistingDimensionLineageID><Name>DateInactivated</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8272</LineageID><MappedToExistingDimensionLineageID>7990</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8273</LineageID><MappedToExistingDimensionLineageID>7993</MappedToExistingDimensionLineageID><Name>JobGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8274</LineageID><MappedToExistingDimensionLineageID>7996</MappedToExistingDimensionLineageID><Name>JobClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8275</LineageID><MappedToExistingDimensionLineageID>7999</MappedToExistingDimensionLineageID><Name>PayBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8276</LineageID><MappedToExistingDimensionLineageID>8002</MappedToExistingDimensionLineageID><Name>Budgeted</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8277</LineageID><MappedToExistingDimensionLineageID>8005</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8278</LineageID><MappedToExistingDimensionLineageID>8008</MappedToExistingDimensionLineageID><Name>PooledIndicator</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8279</LineageID><MappedToExistingDimensionLineageID>8011</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8280</LineageID><MappedToExistingDimensionLineageID>8014</MappedToExistingDimensionLineageID><Name>PositionFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8281</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8282</LineageID><MappedToExistingDimensionLineageID>8020</MappedToExistingDimensionLineageID><Name>CountOfActiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8283</LineageID><MappedToExistingDimensionLineageID>8023</MappedToExistingDimensionLineageID><Name>CountOfInactiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8284</LineageID><MappedToExistingDimensionLineageID>8026</MappedToExistingDimensionLineageID><Name>InactiveReasonCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8285</LineageID><MappedToExistingDimensionLineageID>8029</MappedToExistingDimensionLineageID><Name>InactiveReason</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8287</LineageID><MappedToExistingDimensionLineageID>8035</MappedToExistingDimensionLineageID><Name>FulltimeEquivalent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8288</LineageID><MappedToExistingDimensionLineageID>8038</MappedToExistingDimensionLineageID><Name>WeeklyAuthorizedHours</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8536</LineageID><MappedToExistingDimensionLineageID>8517</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8537</LineageID><MappedToExistingDimensionLineageID>8520</MappedToExistingDimensionLineageID><Name>Location</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8598</LineageID><MappedToExistingDimensionLineageID>8562</MappedToExistingDimensionLineageID><Name>InactiveVacantDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8650</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>MultipleFunds</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 |
Budgeted |
8134 |
8002 |
CountOfActiveAssignments |
8140 |
8020 |
CountOfInactiveAssignments |
8141 |
8023 |
DateEstablished |
8128 |
7984 |
DateInactivated |
8129 |
7987 |
ExemptStatus |
8137 |
8011 |
FulltimeEquivalent |
8145 |
8035 |
FunctionCode |
8126 |
7978 |
FunctionDescription |
8127 |
7981 |
InactiveReason |
8143 |
8029 |
InactiveReasonCode |
8142 |
8026 |
InactiveVacantDateRange |
8589 |
8562 |
JobClassCode |
8132 |
7996 |
JobGroup |
8131 |
7993 |
JobGroupCode |
8130 |
7990 |
Location |
8523 |
8520 |
LocationCode |
8522 |
8517 |
MultipleFunds |
8641 |
8614 |
PayBasis |
8133 |
7999 |
PooledIndicator |
8136 |
8008 |
PositionAK |
8120 |
7960 |
PositionCode |
8121 |
7963 |
PositionFulltimeParttime |
8138 |
8014 |
PositionSK |
8119 |
7957 |
PositionStatus |
8123 |
7969 |
PositionTitle |
8122 |
7966 |
PositionType |
8125 |
7975 |
PositionTypeCode |
8124 |
7972 |
PrimarySalaryAccountNumber |
8139 |
8017 |
RegularTemporary |
8135 |
8005 |
RowEndDate |
8149 |
8047 |
RowIsCurrent |
8147 |
8041 |
RowStartDate |
8148 |
8044 |
WeeklyAuthorizedHours |
8146 |
8038 |
Budgeted |
8164 |
7831 |
CountOfActiveAssignments |
8170 |
7849 |
CountOfInactiveAssignments |
8171 |
7852 |
DateEstablished |
8158 |
7813 |
DateInactivated |
8159 |
7816 |
ExemptStatus |
8167 |
7840 |
FulltimeEquivalent |
8175 |
7864 |
FunctionCode |
8156 |
7807 |
FunctionDescription |
8157 |
7810 |
InactiveReason |
8173 |
7858 |
InactiveReasonCode |
8172 |
7855 |
InactiveVacantDateRange |
8590 |
8559 |
JobClassCode |
8162 |
7825 |
JobGroup |
8161 |
7822 |
JobGroupCode |
8160 |
7819 |
Location |
8525 |
8488 |
LocationCode |
8524 |
8485 |
MultipleFunds |
8642 |
8611 |
PayBasis |
8163 |
7828 |
PooledIndicator |
8166 |
7837 |
PositionAK |
8150 |
7789 |
PositionCode |
8151 |
7792 |
PositionFulltimeParttime |
8168 |
7843 |
PositionStatus |
8153 |
7798 |
PositionTitle |
8152 |
7795 |
PositionType |
8155 |
7804 |
PositionTypeCode |
8154 |
7801 |
PrimarySalaryAccountNumber |
8169 |
7846 |
RegularTemporary |
8165 |
7834 |
WeeklyAuthorizedHours |
8176 |
7867 |
Name | ID | LineageID |
Budgeted |
8220 |
8220 |
CountOfActiveAssignments |
8226 |
8226 |
CountOfInactiveAssignments |
8227 |
8227 |
DateEstablished |
8214 |
8214 |
DateInactivated |
8215 |
8215 |
ExemptStatus |
8223 |
8223 |
FulltimeEquivalent |
8231 |
8231 |
FunctionCode |
8212 |
8212 |
FunctionDescription |
8213 |
8213 |
InactiveReason |
8229 |
8229 |
InactiveReasonCode |
8228 |
8228 |
InactiveVacantDateRange |
8594 |
8594 |
JobClassCode |
8218 |
8218 |
JobGroup |
8217 |
8217 |
JobGroupCode |
8216 |
8216 |
Location |
8531 |
8531 |
LocationCode |
8530 |
8530 |
MultipleFunds |
8646 |
8646 |
PayBasis |
8219 |
8219 |
PooledIndicator |
8222 |
8222 |
PositionAK |
8206 |
8206 |
PositionCode |
8207 |
8207 |
PositionFulltimeParttime |
8224 |
8224 |
PositionSK |
8205 |
8205 |
PositionStatus |
8209 |
8209 |
PositionTitle |
8208 |
8208 |
PositionType |
8211 |
8211 |
PositionTypeCode |
8210 |
8210 |
PrimarySalaryAccountNumber |
8225 |
8225 |
RegularTemporary |
8221 |
8221 |
RowEndDate |
7691 |
7691 |
RowIsCurrent |
7667 |
7667 |
RowStartDate |
7683 |
7683 |
WeeklyAuthorizedHours |
8232 |
8232 |
Budgeted |
8276 |
8276 |
CountOfActiveAssignments |
8282 |
8282 |
CountOfInactiveAssignments |
8283 |
8283 |
DateEstablished |
8270 |
8270 |
DateInactivated |
8271 |
8271 |
ExemptStatus |
8279 |
8279 |
FulltimeEquivalent |
8287 |
8287 |
FunctionCode |
8268 |
8268 |
FunctionDescription |
8269 |
8269 |
InactiveReason |
8285 |
8285 |
InactiveReasonCode |
8284 |
8284 |
InactiveVacantDateRange |
8598 |
8598 |
JobClassCode |
8274 |
8274 |
JobGroup |
8273 |
8273 |
JobGroupCode |
8272 |
8272 |
Location |
8537 |
8537 |
LocationCode |
8536 |
8536 |
MultipleFunds |
8650 |
8650 |
PayBasis |
8275 |
8275 |
PooledIndicator |
8278 |
8278 |
PositionAK |
8262 |
8262 |
PositionCode |
8263 |
8263 |
PositionFulltimeParttime |
8280 |
8280 |
PositionSK |
8261 |
8261 |
PositionStatus |
8265 |
8265 |
PositionTitle |
8264 |
8264 |
PositionType |
8267 |
8267 |
PositionTypeCode |
8266 |
8266 |
PrimarySalaryAccountNumber |
8281 |
8281 |
RegularTemporary |
8277 |
8277 |
Row Change Reason |
8373 |
8373 |
RowEndDate |
7693 |
7693 |
RowIsCurrent |
7671 |
7671 |
RowStartDate |
7685 |
7685 |
WeeklyAuthorizedHours |
8288 |
8288 |
Powered by BI Documenter |