DimAssignmentLoad
 TF_SCD DimAssignment (Component)
Home  Diagrams  Documents  Images  DimAssignmentLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimAssignmentLoad   DFT Load Temp Assignment Tables from Staging   TF_SCD DimAssignment
  Properties
Property Value
Name TF_SCD DimAssignment
Description
Up Stream Components
Down Stream Components
ID 7345
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF_SCD DimAssignment" (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>8240</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8253</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8961</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9640</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9641</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9642</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9643</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9644</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9645</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9646</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9647</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9648</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9649</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9650</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9651</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9652</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9653</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9654</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9655</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9656</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9657</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9658</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9659</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9660</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9661</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9662</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9663</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9664</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9665</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9666</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9667</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9668</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9669</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9670</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>8352</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8365</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9115</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9770</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9771</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9772</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9773</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9774</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9775</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9776</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9777</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9778</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9779</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9780</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9781</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9782</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9783</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9784</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9785</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9786</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9787</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9788</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9789</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9790</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9791</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9792</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9793</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9794</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9795</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9796</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9797</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9798</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9799</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9800</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>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>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>FunctionDesc</SourceSystemColumnName><SourceSystemLineageID>8569</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FunctionDesc</Name><LineageID>8680</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName /><SCDColumnType>2</SCDColumnType><ColumnInformation><ColumnInformation><Name>AssignmentSK</Name><LineageID>9363</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>AssignmentAK</SourceSystemColumnName><SourceSystemLineageID>9273</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>AssignmentAK</Name><LineageID>9366</LineageID><DataType>129</DataType><Length>20</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PersonId</SourceSystemColumnName><SourceSystemLineageID>9276</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PersonId</Name><LineageID>9369</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionCode</SourceSystemColumnName><SourceSystemLineageID>9279</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionCode</Name><LineageID>9372</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentSequenceNumber</SourceSystemColumnName><SourceSystemLineageID>9282</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>AssignmentSequenceNumber</Name><LineageID>9375</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobTitle</SourceSystemColumnName><SourceSystemLineageID>9285</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobTitle</Name><LineageID>9378</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentStatus</SourceSystemColumnName><SourceSystemLineageID>9288</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>AssignmentStatus</Name><LineageID>9381</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentTypeCode</SourceSystemColumnName><SourceSystemLineageID>9291</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>AssignmentTypeCode</Name><LineageID>9384</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentType</SourceSystemColumnName><SourceSystemLineageID>9294</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>AssignmentType</Name><LineageID>9387</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StartDate</SourceSystemColumnName><SourceSystemLineageID>9297</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>StartDate</Name><LineageID>9390</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EndDate</SourceSystemColumnName><SourceSystemLineageID>9300</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>EndDate</Name><LineageID>9393</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobGroupCode</SourceSystemColumnName><SourceSystemLineageID>9303</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobGroupCode</Name><LineageID>9396</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobGroup</SourceSystemColumnName><SourceSystemLineageID>9306</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobGroup</Name><LineageID>9399</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>JobClassCode</SourceSystemColumnName><SourceSystemLineageID>9309</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>JobClassCode</Name><LineageID>9402</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PayBasis</SourceSystemColumnName><SourceSystemLineageID>9312</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PayBasis</Name><LineageID>9405</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InstitutionalAssignmentTypeCode</SourceSystemColumnName><SourceSystemLineageID>9315</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>InstitutionalAssignmentTypeCode</Name><LineageID>9408</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>InstitutionalAssignmentType</SourceSystemColumnName><SourceSystemLineageID>9318</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>InstitutionalAssignmentType</Name><LineageID>9411</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PrimaryAssignment</SourceSystemColumnName><SourceSystemLineageID>9321</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PrimaryAssignment</Name><LineageID>9414</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>RegularTemporary</SourceSystemColumnName><SourceSystemLineageID>9324</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>RegularTemporary</Name><LineageID>9417</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ExemptStatus</SourceSystemColumnName><SourceSystemLineageID>9327</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ExemptStatus</Name><LineageID>9420</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentFulltimeParttime</SourceSystemColumnName><SourceSystemLineageID>9330</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>AssignmentFulltimeParttime</Name><LineageID>9423</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>AssignmentEndDateRange</SourceSystemColumnName><SourceSystemLineageID>9333</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>AssignmentEndDateRange</Name><LineageID>9426</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastPaymentDateRange</SourceSystemColumnName><SourceSystemLineageID>9336</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LastPaymentDateRange</Name><LineageID>9429</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EndBasisCode</SourceSystemColumnName><SourceSystemLineageID>9339</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EndBasisCode</Name><LineageID>9432</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EndBasis</SourceSystemColumnName><SourceSystemLineageID>9342</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EndBasis</Name><LineageID>9435</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>BaseSalary</SourceSystemColumnName><SourceSystemLineageID>9345</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>BaseSalary</Name><LineageID>9438</LineageID><DataType>131</DataType><Precision>11</Precision><Scale>2</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ActualSalary</SourceSystemColumnName><SourceSystemLineageID>9348</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>ActualSalary</Name><LineageID>9441</LineageID><DataType>131</DataType><Precision>11</Precision><Scale>2</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DailyRate</SourceSystemColumnName><SourceSystemLineageID>9351</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>DailyRate</Name><LineageID>9444</LineageID><DataType>131</DataType><Precision>9</Precision><Scale>2</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HourlyRate</SourceSystemColumnName><SourceSystemLineageID>9354</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>HourlyRate</Name><LineageID>9447</LineageID><DataType>131</DataType><Precision>9</Precision><Scale>4</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>OvertimeRate</SourceSystemColumnName><SourceSystemLineageID>9357</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>OvertimeRate</Name><LineageID>9450</LineageID><DataType>131</DataType><Precision>9</Precision><Scale>4</Scale></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TotalSalary</SourceSystemColumnName><SourceSystemLineageID>9360</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>TotalSalary</Name><LineageID>9453</LineageID><DataType>131</DataType><Precision>11</Precision><Scale>2</Scale></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>8296</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8309</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9037</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9704</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9705</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9706</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9707</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9708</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9709</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9710</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9711</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9712</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9713</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9714</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9715</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9716</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9717</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9718</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9719</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9720</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9721</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9722</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9723</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9724</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9725</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9726</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9727</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9728</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9729</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9730</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9731</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9732</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9733</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9734</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>8212</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8225</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8922</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9607</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9608</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9609</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9610</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9611</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9612</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9613</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9614</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9615</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9616</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9617</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9618</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9619</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9620</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9621</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9622</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9623</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9624</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9625</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9626</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9627</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9628</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9629</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9630</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9631</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9632</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9633</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9634</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9635</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9636</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9637</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>8324</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8337</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9076</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9737</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9738</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9739</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9740</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9741</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9742</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9743</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9744</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9745</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9746</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9747</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9748</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9749</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9750</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9751</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9752</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9753</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9754</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9755</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9756</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9757</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9758</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9759</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9760</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9761</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9762</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9763</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9764</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9765</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9766</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9767</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>#7807</string><string>#7846</string><string>#8569</string><string>#9270</string><string>#9273</string><string>#9276</string><string>#9279</string><string>#9282</string><string>#9285</string><string>#9288</string><string>#9291</string><string>#9294</string><string>#9297</string><string>#9300</string><string>#9303</string><string>#9306</string><string>#9309</string><string>#9312</string><string>#9315</string><string>#9318</string><string>#9321</string><string>#9324</string><string>#9327</string><string>#9330</string><string>#9333</string><string>#9336</string><string>#9339</string><string>#9342</string><string>#9345</string><string>#9348</string><string>#9351</string><string>#9354</string><string>#9357</string><string>#9360</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>8184</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8197</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8885</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9576</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9577</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9578</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9579</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9580</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9581</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9582</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9583</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9584</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9585</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9586</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9587</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9588</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9589</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9590</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9591</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9592</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9593</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9594</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9595</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9596</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9597</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9598</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9599</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9600</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9601</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9602</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9603</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9604</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9605</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9606</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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>8268</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8281</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8998</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9671</LineageID><MappedToExistingDimensionLineageID>9363</MappedToExistingDimensionLineageID><Name>AssignmentSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9672</LineageID><MappedToExistingDimensionLineageID>9366</MappedToExistingDimensionLineageID><Name>AssignmentAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9673</LineageID><MappedToExistingDimensionLineageID>9369</MappedToExistingDimensionLineageID><Name>PersonId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9674</LineageID><MappedToExistingDimensionLineageID>9372</MappedToExistingDimensionLineageID><Name>PositionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9675</LineageID><MappedToExistingDimensionLineageID>9375</MappedToExistingDimensionLineageID><Name>AssignmentSequenceNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9676</LineageID><MappedToExistingDimensionLineageID>9378</MappedToExistingDimensionLineageID><Name>JobTitle</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9677</LineageID><MappedToExistingDimensionLineageID>9381</MappedToExistingDimensionLineageID><Name>AssignmentStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9678</LineageID><MappedToExistingDimensionLineageID>9384</MappedToExistingDimensionLineageID><Name>AssignmentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9679</LineageID><MappedToExistingDimensionLineageID>9387</MappedToExistingDimensionLineageID><Name>AssignmentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9680</LineageID><MappedToExistingDimensionLineageID>9390</MappedToExistingDimensionLineageID><Name>StartDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9681</LineageID><MappedToExistingDimensionLineageID>9393</MappedToExistingDimensionLineageID><Name>EndDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9682</LineageID><MappedToExistingDimensionLineageID>9396</MappedToExistingDimensionLineageID><Name>JobGroupCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9683</LineageID><MappedToExistingDimensionLineageID>9399</MappedToExistingDimensionLineageID><Name>JobGroup</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9684</LineageID><MappedToExistingDimensionLineageID>9402</MappedToExistingDimensionLineageID><Name>JobClassCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9685</LineageID><MappedToExistingDimensionLineageID>9405</MappedToExistingDimensionLineageID><Name>PayBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9686</LineageID><MappedToExistingDimensionLineageID>9408</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9687</LineageID><MappedToExistingDimensionLineageID>9411</MappedToExistingDimensionLineageID><Name>InstitutionalAssignmentType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9688</LineageID><MappedToExistingDimensionLineageID>9414</MappedToExistingDimensionLineageID><Name>PrimaryAssignment</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9689</LineageID><MappedToExistingDimensionLineageID>9417</MappedToExistingDimensionLineageID><Name>RegularTemporary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9690</LineageID><MappedToExistingDimensionLineageID>9420</MappedToExistingDimensionLineageID><Name>ExemptStatus</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9691</LineageID><MappedToExistingDimensionLineageID>9423</MappedToExistingDimensionLineageID><Name>AssignmentFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9692</LineageID><MappedToExistingDimensionLineageID>9426</MappedToExistingDimensionLineageID><Name>AssignmentEndDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9693</LineageID><MappedToExistingDimensionLineageID>9429</MappedToExistingDimensionLineageID><Name>LastPaymentDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9694</LineageID><MappedToExistingDimensionLineageID>9432</MappedToExistingDimensionLineageID><Name>EndBasisCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9695</LineageID><MappedToExistingDimensionLineageID>9435</MappedToExistingDimensionLineageID><Name>EndBasis</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9696</LineageID><MappedToExistingDimensionLineageID>9438</MappedToExistingDimensionLineageID><Name>BaseSalary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9697</LineageID><MappedToExistingDimensionLineageID>9441</MappedToExistingDimensionLineageID><Name>ActualSalary</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9698</LineageID><MappedToExistingDimensionLineageID>9444</MappedToExistingDimensionLineageID><Name>DailyRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9699</LineageID><MappedToExistingDimensionLineageID>9447</MappedToExistingDimensionLineageID><Name>HourlyRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9700</LineageID><MappedToExistingDimensionLineageID>9450</MappedToExistingDimensionLineageID><Name>OvertimeRate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9701</LineageID><MappedToExistingDimensionLineageID>9453</MappedToExistingDimensionLineageID><Name>TotalSalary</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
ActualSalary
9539
9441
AssignmentAK
9514
9366
AssignmentEndDateRange
9534
9426
AssignmentFulltimeParttime
9533
9423
AssignmentSequenceNumber
9517
9375
AssignmentSK
9513
9363
AssignmentStatus
9519
9381
AssignmentType
9521
9387
AssignmentTypeCode
9520
9384
BaseSalary
9538
9438
DailyRate
9540
9444
EndBasis
9537
9435
EndBasisCode
9536
9432
EndDate
9523
9393
ExemptStatus
9532
9420
FunctionCode
8126
7978
FunctionDesc
8810
8680
HourlyRate
9541
9447
InstitutionalAssignmentType
9529
9411
InstitutionalAssignmentTypeCode
9528
9408
JobClassCode
9526
9402
JobGroup
9525
9399
JobGroupCode
9524
9396
JobTitle
9518
9378
LastPaymentDateRange
9535
9429
OvertimeRate
9542
9450
PayBasis
9527
9405
PersonId
9515
9369
PositionCode
9516
9372
PrimaryAssignment
9530
9414
PrimarySalaryAccountNumber
8139
8017
RegularTemporary
9531
9417
RowEndDate
8149
8047
RowIsCurrent
8147
8041
RowStartDate
8148
8044
StartDate
9522
9390
TotalSalary
9543
9453
ActualSalary
9569
9348
AssignmentAK
9544
9273
AssignmentEndDateRange
9564
9333
AssignmentFulltimeParttime
9563
9330
AssignmentSequenceNumber
9547
9282
AssignmentStatus
9549
9288
AssignmentType
9551
9294
AssignmentTypeCode
9550
9291
BaseSalary
9568
9345
DailyRate
9570
9351
EndBasis
9567
9342
EndBasisCode
9566
9339
EndDate
9553
9300
ExemptStatus
9562
9327
FunctionCode
8156
7807
FunctionDesc
8846
8569
HourlyRate
9571
9354
InstitutionalAssignmentType
9559
9318
InstitutionalAssignmentTypeCode
9558
9315
JobClassCode
9556
9309
JobGroup
9555
9306
JobGroupCode
9554
9303
JobTitle
9548
9285
LastPaymentDateRange
9565
9336
OvertimeRate
9572
9357
PayBasis
9557
9312
PersonId
9545
9276
PositionCode
9546
9279
PrimaryAssignment
9560
9321
PrimarySalaryAccountNumber
8169
7846
RegularTemporary
9561
9324
StartDate
9552
9297
TotalSalary
9573
9360
  Output Columns
Name ID LineageID
ActualSalary
9633
9633
AssignmentAK
9608
9608
AssignmentEndDateRange
9628
9628
AssignmentFulltimeParttime
9627
9627
AssignmentSequenceNumber
9611
9611
AssignmentSK
9607
9607
AssignmentStatus
9613
9613
AssignmentType
9615
9615
AssignmentTypeCode
9614
9614
BaseSalary
9632
9632
DailyRate
9634
9634
EndBasis
9631
9631
EndBasisCode
9630
9630
EndDate
9617
9617
ExemptStatus
9626
9626
FunctionCode
8212
8212
FunctionDesc
8922
8922
HourlyRate
9635
9635
InstitutionalAssignmentType
9623
9623
InstitutionalAssignmentTypeCode
9622
9622
JobClassCode
9620
9620
JobGroup
9619
9619
JobGroupCode
9618
9618
JobTitle
9612
9612
LastPaymentDateRange
9629
9629
OvertimeRate
9636
9636
PayBasis
9621
9621
PersonId
9609
9609
PositionCode
9610
9610
PrimaryAssignment
9624
9624
PrimarySalaryAccountNumber
8225
8225
RegularTemporary
9625
9625
RowEndDate
7691
7691
RowIsCurrent
7667
7667
RowStartDate
7683
7683
StartDate
9616
9616
TotalSalary
9637
9637
ActualSalary
9697
9697
AssignmentAK
9672
9672
AssignmentEndDateRange
9692
9692
AssignmentFulltimeParttime
9691
9691
AssignmentSequenceNumber
9675
9675
AssignmentSK
9671
9671
AssignmentStatus
9677
9677
AssignmentType
9679
9679
AssignmentTypeCode
9678
9678
BaseSalary
9696
9696
DailyRate
9698
9698
EndBasis
9695
9695
EndBasisCode
9694
9694
EndDate
9681
9681
ExemptStatus
9690
9690
FunctionCode
8268
8268
FunctionDesc
8998
8998
HourlyRate
9699
9699
InstitutionalAssignmentType
9687
9687
InstitutionalAssignmentTypeCode
9686
9686
JobClassCode
9684
9684
JobGroup
9683
9683
JobGroupCode
9682
9682
JobTitle
9676
9676
LastPaymentDateRange
9693
9693
OvertimeRate
9700
9700
PayBasis
9685
9685
PersonId
9673
9673
PositionCode
9674
9674
PrimaryAssignment
9688
9688
PrimarySalaryAccountNumber
8281
8281
RegularTemporary
9689
9689
Row Change Reason
8373
8373
RowEndDate
7693
7693
RowIsCurrent
7671
7671
RowStartDate
7685
7685
StartDate
9680
9680
TotalSalary
9701
9701
Powered by BI Documenter