DimPositionLoad
 TF_SCD DimPosition (Component)
  Properties
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
  Connections
Name Connection Manager Description
  Custom Properties
Name Value
(Obsolete) Route Deleted Rows to SCD2 Expired Output
False
(Obsolete) Route SCD2New Rows to New Output
False
Audit Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><CanIncludeSCDColumnTypes>Auditing</CanIncludeSCDColumnTypes><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>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
  Input Columns
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
  Output Columns
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