DimEmployeeLoad
 TF_SCD DimEmployee (Component)
Home  Diagrams  Documents  Images  DimEmployeeLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimEmployeeLoad   DFT Load Temp Employee Tables from Staging   TF_SCD DimEmployee
  Properties
Property Value
Name TF_SCD DimEmployee
Description
Up Stream Components
Down Stream Components
ID 7345
Component Class ID {2E42D45B-F83C-400F-8D77-61DDE6A7DF29}
Contact Info
Identification String component "TF_SCD DimEmployee" (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>8238</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8239</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8240</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8253</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8933</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8934</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8935</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8936</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8937</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8938</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8939</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8940</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8941</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8942</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8943</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8944</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8945</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8946</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8947</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8948</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8949</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8950</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8951</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8952</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8953</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8954</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8955</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8956</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8957</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8958</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8959</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8960</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8961</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8962</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8963</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8964</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8965</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8966</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8967</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8968</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8969</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9323</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9406</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9407</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>8350</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8351</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8352</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8365</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9087</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9088</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9089</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9090</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9091</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9092</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9093</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9094</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9095</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9096</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9097</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9098</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9099</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9100</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9101</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9102</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9103</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9104</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9105</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9106</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9107</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9108</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9109</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9110</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9111</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9112</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9113</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9114</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9115</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9116</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9117</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9118</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9119</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9120</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9121</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9122</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9123</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9333</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9420</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9421</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>PositionTypeCode</SourceSystemColumnName><SourceSystemLineageID>7801</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionTypeCode</Name><LineageID>7972</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PositionType</SourceSystemColumnName><SourceSystemLineageID>7804</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>PositionType</Name><LineageID>7975</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FunctionCode</SourceSystemColumnName><SourceSystemLineageID>7807</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FunctionCode</Name><LineageID>7978</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>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 /><SCDColumnType>2</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EmployeeSK</Name><LineageID>8596</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SortKeyPosition>1</SortKeyPosition><SourceSystemColumnName>EmployeeAK</SourceSystemColumnName><SourceSystemLineageID>8488</SourceSystemLineageID><SCDColumnType>1</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>EmployeeAK</Name><LineageID>8599</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>PersonID</SourceSystemColumnName><SourceSystemLineageID>8491</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><ColumnInformation><ColumnInformation><Name>PersonID</Name><LineageID>8602</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EmployeeTypeCode</SourceSystemColumnName><SourceSystemLineageID>8494</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EmployeeTypeCode</Name><LineageID>8605</LineageID><DataType>129</DataType><Length>8</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EmployeeType</SourceSystemColumnName><SourceSystemLineageID>8497</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EmployeeType</Name><LineageID>8608</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FullName</SourceSystemColumnName><SourceSystemLineageID>8500</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FullName</Name><LineageID>8611</LineageID><DataType>129</DataType><Length>80</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastName</SourceSystemColumnName><SourceSystemLineageID>8503</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LastName</Name><LineageID>8614</LineageID><DataType>129</DataType><Length>50</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>FirstName</SourceSystemColumnName><SourceSystemLineageID>8506</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>FirstName</Name><LineageID>8617</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>MiddleInitial</SourceSystemColumnName><SourceSystemLineageID>8509</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>MiddleInitial</Name><LineageID>8620</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>GenderCode</SourceSystemColumnName><SourceSystemLineageID>8512</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>GenderCode</Name><LineageID>8623</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Gender</SourceSystemColumnName><SourceSystemLineageID>8515</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Gender</Name><LineageID>8626</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EthnicityCode</SourceSystemColumnName><SourceSystemLineageID>8518</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EthnicityCode</Name><LineageID>8629</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Ethnicity</SourceSystemColumnName><SourceSystemLineageID>8521</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Ethnicity</Name><LineageID>8632</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>StateCode</SourceSystemColumnName><SourceSystemLineageID>8524</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>StateCode</Name><LineageID>8635</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>State</SourceSystemColumnName><SourceSystemLineageID>8527</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>State</Name><LineageID>8638</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>ZipCode</SourceSystemColumnName><SourceSystemLineageID>8530</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>ZipCode</Name><LineageID>8641</LineageID><DataType>129</DataType><Length>11</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountyFIPSCode</SourceSystemColumnName><SourceSystemLineageID>8533</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>CountyFIPSCode</Name><LineageID>8644</LineageID><DataType>129</DataType><Length>5</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>County</SourceSystemColumnName><SourceSystemLineageID>8536</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>County</Name><LineageID>8647</LineageID><DataType>129</DataType><Length>45</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryCode</SourceSystemColumnName><SourceSystemLineageID>8539</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>CountryCode</Name><LineageID>8650</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Country</SourceSystemColumnName><SourceSystemLineageID>8542</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Country</Name><LineageID>8653</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CitizenshipCode</SourceSystemColumnName><SourceSystemLineageID>8545</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>CitizenshipCode</Name><LineageID>8656</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Citizenship</SourceSystemColumnName><SourceSystemLineageID>8548</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>Citizenship</Name><LineageID>8659</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenshipCode</SourceSystemColumnName><SourceSystemLineageID>8551</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>CountryOfCitizenshipCode</Name><LineageID>8662</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>CountryOfCitizenship</SourceSystemColumnName><SourceSystemLineageID>8554</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>CountryOfCitizenship</Name><LineageID>8665</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HasActiveAssignment</SourceSystemColumnName><SourceSystemLineageID>8557</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>HasActiveAssignment</Name><LineageID>8668</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>NumberOfActiveAssignments</SourceSystemColumnName><SourceSystemLineageID>8560</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>NumberOfActiveAssignments</Name><LineageID>8671</LineageID></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastActiveAssignmentDateRange</SourceSystemColumnName><SourceSystemLineageID>8563</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LastActiveAssignmentDateRange</Name><LineageID>8674</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LastPayCheckDateRange</SourceSystemColumnName><SourceSystemLineageID>8566</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>LastPayCheckDateRange</Name><LineageID>8677</LineageID><DataType>129</DataType><Length>30</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>IsAStudent</SourceSystemColumnName><SourceSystemLineageID>8572</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>IsAStudent</Name><LineageID>8683</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EmployeeStudentId</SourceSystemColumnName><SourceSystemLineageID>8575</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EmployeeStudentId</Name><LineageID>8686</LineageID><DataType>129</DataType><Length>9</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HasDirectDeposit</SourceSystemColumnName><SourceSystemLineageID>8578</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>HasDirectDeposit</Name><LineageID>8689</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>HireDate</SourceSystemColumnName><SourceSystemLineageID>8581</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>HireDate</Name><LineageID>8692</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>EmployeeFulltimeParttime</SourceSystemColumnName><SourceSystemLineageID>8584</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>EmployeeFulltimeParttime</Name><LineageID>8695</LineageID><DataType>129</DataType><Length>10</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TerminationDate</SourceSystemColumnName><SourceSystemLineageID>8587</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>TerminationDate</Name><LineageID>8698</LineageID><DataType>135</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>TerminationDateRange</SourceSystemColumnName><SourceSystemLineageID>8590</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><StringComparisonIgnoresCase>False</StringComparisonIgnoresCase><ColumnInformation><ColumnInformation><Name>TerminationDateRange</Name><LineageID>8701</LineageID><DataType>129</DataType><Length>30</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>YearsOfServiceToInstitution</SourceSystemColumnName><SourceSystemLineageID>8593</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>YearsOfServiceToInstitution</Name><LineageID>8704</LineageID><DataType>2</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>DateOfBirth</SourceSystemColumnName><SourceSystemLineageID>9270</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>DateOfBirth</Name><LineageID>9313</LineageID><DataType>133</DataType></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>LocationCode</SourceSystemColumnName><SourceSystemLineageID>9339</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>LocationCode</Name><LineageID>9389</LineageID><DataType>129</DataType><Length>3</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition><InputColumnDefinition><SourceSystemColumnName>Location</SourceSystemColumnName><SourceSystemLineageID>9342</SourceSystemLineageID><SCDColumnType>3</SCDColumnType><StringComparisonCultureID>1033</StringComparisonCultureID><ColumnInformation><ColumnInformation><Name>Location</Name><LineageID>9392</LineageID><DataType>129</DataType><Length>60</Length><CodePage>1252</CodePage></ColumnInformation></ColumnInformation></InputColumnDefinition></ArrayOfInputColumnDefinition>
Existing Dimension Input Counter
Expired SCD2 Columns
<?xml version="1.0" encoding="utf-16"?><OutputColumnDefinitionList><ActionIfNotAttached>0</ActionIfNotAttached><UserIsAwareOutputIsntAttached>True</UserIsAwareOutputIsntAttached><ArrayOfOutputColumnDefinition><OutputColumnDefinition><SourceType>1</SourceType><LineageID>7429</LineageID><MappedToExistingDimensionLineageID>0</MappedToExistingDimensionLineageID><Name>Row Change Reason</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7674</LineageID><MappedToExistingDimensionLineageID>8041</MappedToExistingDimensionLineageID><Name>RowIsCurrent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7686</LineageID><MappedToExistingDimensionLineageID>8044</MappedToExistingDimensionLineageID><Name>RowStartDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>7694</LineageID><MappedToExistingDimensionLineageID>8047</MappedToExistingDimensionLineageID><Name>RowEndDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8294</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8295</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8296</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8309</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9009</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9010</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9011</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9012</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9013</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9014</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9015</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9016</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9017</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9018</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9019</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9020</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9021</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9022</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9023</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9024</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9025</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9026</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9027</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9028</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9029</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9030</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9031</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9032</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9033</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9034</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9035</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9036</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9037</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9038</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9039</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9040</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9041</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9042</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9043</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9044</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9045</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9327</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9412</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9413</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>8210</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8211</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8212</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8225</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8894</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8895</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8896</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8897</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8898</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8899</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8900</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8901</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8902</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8903</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8904</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8905</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8906</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8907</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8908</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8909</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8910</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8911</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8912</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8913</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8914</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8915</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8916</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8917</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8918</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8919</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8920</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8921</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8922</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8923</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8924</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8925</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8926</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8927</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8928</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8929</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8930</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9320</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9402</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9403</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>8322</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8323</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8324</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8337</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9048</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9049</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9050</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9051</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9052</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9053</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9054</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9055</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9056</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9057</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9058</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9059</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9060</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9061</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9062</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9063</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9064</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9065</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9066</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9067</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9068</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9069</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9070</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9071</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9072</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9073</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9074</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9075</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9076</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9077</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9078</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9079</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9080</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9081</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9082</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9083</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9084</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9330</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9416</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9417</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>#7801</string><string>#7804</string><string>#7807</string><string>#7846</string><string>#8485</string><string>#8488</string><string>#8491</string><string>#8494</string><string>#8497</string><string>#8500</string><string>#8503</string><string>#8506</string><string>#8509</string><string>#8512</string><string>#8515</string><string>#8518</string><string>#8521</string><string>#8524</string><string>#8527</string><string>#8530</string><string>#8533</string><string>#8536</string><string>#8539</string><string>#8542</string><string>#8545</string><string>#8548</string><string>#8551</string><string>#8554</string><string>#8557</string><string>#8560</string><string>#8563</string><string>#8566</string><string>#8569</string><string>#8572</string><string>#8575</string><string>#8578</string><string>#8581</string><string>#8584</string><string>#8587</string><string>#8590</string><string>#8593</string><string>#9270</string><string>#9339</string><string>#9342</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>8182</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8183</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8184</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8197</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8857</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8858</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8859</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8860</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8861</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8862</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8863</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8864</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8865</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8866</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8867</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8868</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8869</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8870</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8871</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8872</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8873</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8874</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8875</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8876</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8877</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8878</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8879</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8880</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8881</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8882</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8883</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8884</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8885</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8886</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8887</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8888</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8889</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8890</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8891</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8892</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>8893</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9319</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9400</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name><IsWantedOnOutput>False</IsWantedOnOutput></OutputColumnDefinition><OutputColumnDefinition><LineageID>9401</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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>8266</LineageID><MappedToExistingDimensionLineageID>7972</MappedToExistingDimensionLineageID><Name>PositionTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8267</LineageID><MappedToExistingDimensionLineageID>7975</MappedToExistingDimensionLineageID><Name>PositionType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8268</LineageID><MappedToExistingDimensionLineageID>7978</MappedToExistingDimensionLineageID><Name>FunctionCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8281</LineageID><MappedToExistingDimensionLineageID>8017</MappedToExistingDimensionLineageID><Name>PrimarySalaryAccountNumber</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8970</LineageID><MappedToExistingDimensionLineageID>8596</MappedToExistingDimensionLineageID><Name>EmployeeSK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8971</LineageID><MappedToExistingDimensionLineageID>8599</MappedToExistingDimensionLineageID><Name>EmployeeAK</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8972</LineageID><MappedToExistingDimensionLineageID>8602</MappedToExistingDimensionLineageID><Name>PersonID</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8973</LineageID><MappedToExistingDimensionLineageID>8605</MappedToExistingDimensionLineageID><Name>EmployeeTypeCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8974</LineageID><MappedToExistingDimensionLineageID>8608</MappedToExistingDimensionLineageID><Name>EmployeeType</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8975</LineageID><MappedToExistingDimensionLineageID>8611</MappedToExistingDimensionLineageID><Name>FullName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8976</LineageID><MappedToExistingDimensionLineageID>8614</MappedToExistingDimensionLineageID><Name>LastName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8977</LineageID><MappedToExistingDimensionLineageID>8617</MappedToExistingDimensionLineageID><Name>FirstName</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8978</LineageID><MappedToExistingDimensionLineageID>8620</MappedToExistingDimensionLineageID><Name>MiddleInitial</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8979</LineageID><MappedToExistingDimensionLineageID>8623</MappedToExistingDimensionLineageID><Name>GenderCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8980</LineageID><MappedToExistingDimensionLineageID>8626</MappedToExistingDimensionLineageID><Name>Gender</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8981</LineageID><MappedToExistingDimensionLineageID>8629</MappedToExistingDimensionLineageID><Name>EthnicityCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8982</LineageID><MappedToExistingDimensionLineageID>8632</MappedToExistingDimensionLineageID><Name>Ethnicity</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8983</LineageID><MappedToExistingDimensionLineageID>8635</MappedToExistingDimensionLineageID><Name>StateCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8984</LineageID><MappedToExistingDimensionLineageID>8638</MappedToExistingDimensionLineageID><Name>State</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8985</LineageID><MappedToExistingDimensionLineageID>8641</MappedToExistingDimensionLineageID><Name>ZipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8986</LineageID><MappedToExistingDimensionLineageID>8644</MappedToExistingDimensionLineageID><Name>CountyFIPSCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8987</LineageID><MappedToExistingDimensionLineageID>8647</MappedToExistingDimensionLineageID><Name>County</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8988</LineageID><MappedToExistingDimensionLineageID>8650</MappedToExistingDimensionLineageID><Name>CountryCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8989</LineageID><MappedToExistingDimensionLineageID>8653</MappedToExistingDimensionLineageID><Name>Country</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8990</LineageID><MappedToExistingDimensionLineageID>8656</MappedToExistingDimensionLineageID><Name>CitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8991</LineageID><MappedToExistingDimensionLineageID>8659</MappedToExistingDimensionLineageID><Name>Citizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8992</LineageID><MappedToExistingDimensionLineageID>8662</MappedToExistingDimensionLineageID><Name>CountryOfCitizenshipCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8993</LineageID><MappedToExistingDimensionLineageID>8665</MappedToExistingDimensionLineageID><Name>CountryOfCitizenship</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8994</LineageID><MappedToExistingDimensionLineageID>8668</MappedToExistingDimensionLineageID><Name>HasActiveAssignment</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8995</LineageID><MappedToExistingDimensionLineageID>8671</MappedToExistingDimensionLineageID><Name>NumberOfActiveAssignments</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8996</LineageID><MappedToExistingDimensionLineageID>8674</MappedToExistingDimensionLineageID><Name>LastActiveAssignmentDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8997</LineageID><MappedToExistingDimensionLineageID>8677</MappedToExistingDimensionLineageID><Name>LastPayCheckDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8998</LineageID><MappedToExistingDimensionLineageID>8680</MappedToExistingDimensionLineageID><Name>FunctionDesc</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>8999</LineageID><MappedToExistingDimensionLineageID>8683</MappedToExistingDimensionLineageID><Name>IsAStudent</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9000</LineageID><MappedToExistingDimensionLineageID>8686</MappedToExistingDimensionLineageID><Name>EmployeeStudentId</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9001</LineageID><MappedToExistingDimensionLineageID>8689</MappedToExistingDimensionLineageID><Name>HasDirectDeposit</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9002</LineageID><MappedToExistingDimensionLineageID>8692</MappedToExistingDimensionLineageID><Name>HireDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9003</LineageID><MappedToExistingDimensionLineageID>8695</MappedToExistingDimensionLineageID><Name>EmployeeFulltimeParttime</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9004</LineageID><MappedToExistingDimensionLineageID>8698</MappedToExistingDimensionLineageID><Name>TerminationDate</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9005</LineageID><MappedToExistingDimensionLineageID>8701</MappedToExistingDimensionLineageID><Name>TerminationDateRange</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9006</LineageID><MappedToExistingDimensionLineageID>8704</MappedToExistingDimensionLineageID><Name>YearsOfServiceToInstitution</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9324</LineageID><MappedToExistingDimensionLineageID>9313</MappedToExistingDimensionLineageID><Name>DateOfBirth</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9408</LineageID><MappedToExistingDimensionLineageID>9389</MappedToExistingDimensionLineageID><Name>LocationCode</Name></OutputColumnDefinition><OutputColumnDefinition><LineageID>9409</LineageID><MappedToExistingDimensionLineageID>9392</MappedToExistingDimensionLineageID><Name>Location</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
Citizenship
8803
8659
CitizenshipCode
8802
8656
Country
8801
8653
CountryCode
8800
8650
CountryOfCitizenship
8805
8665
CountryOfCitizenshipCode
8804
8662
County
8799
8647
CountyFIPSCode
8798
8644
DateOfBirth
9315
9313
EmployeeAK
8783
8599
EmployeeFulltimeParttime
8815
8695
EmployeeSK
8782
8596
EmployeeStudentId
8812
8686
EmployeeType
8786
8608
EmployeeTypeCode
8785
8605
Ethnicity
8794
8632
EthnicityCode
8793
8629
FirstName
8789
8617
FullName
8787
8611
FunctionCode
8126
7978
FunctionDesc
8810
8680
Gender
8792
8626
GenderCode
8791
8623
HasActiveAssignment
8806
8668
HasDirectDeposit
8813
8689
HireDate
8814
8692
IsAStudent
8811
8683
LastActiveAssignmentDateRange
8808
8674
LastName
8788
8614
LastPayCheckDateRange
8809
8677
Location
9395
9392
LocationCode
9394
9389
MiddleInitial
8790
8620
NumberOfActiveAssignments
8807
8671
PersonID
8784
8602
PositionType
8125
7975
PositionTypeCode
8124
7972
PrimarySalaryAccountNumber
8139
8017
RowEndDate
8149
8047
RowIsCurrent
8147
8041
RowStartDate
8148
8044
State
8796
8638
StateCode
8795
8635
TerminationDate
8816
8698
TerminationDateRange
8817
8701
YearsOfServiceToInstitution
8818
8704
ZipCode
8797
8641
Citizenship
8839
8548
CitizenshipCode
8838
8545
Country
8837
8542
CountryCode
8836
8539
CountryOfCitizenship
8841
8554
CountryOfCitizenshipCode
8840
8551
County
8835
8536
CountyFIPSCode
8834
8533
DateOfBirth
9316
9270
EmployeeAK
8819
8488
EmployeeFulltimeParttime
8851
8584
EmployeeStudentId
8848
8575
EmployeeType
8822
8497
EmployeeTypeCode
8821
8494
Ethnicity
8830
8521
EthnicityCode
8829
8518
FirstName
8825
8506
FullName
8823
8500
FunctionCode
8156
7807
FunctionDesc
8846
8569
Gender
8828
8515
GenderCode
8827
8512
HasActiveAssignment
8842
8557
HasDirectDeposit
8849
8578
HireDate
8850
8581
IsAStudent
8847
8572
LastActiveAssignmentDateRange
8844
8563
LastName
8824
8503
LastPayCheckDateRange
8845
8566
Location
9397
9342
LocationCode
9396
9339
MiddleInitial
8826
8509
NumberOfActiveAssignments
8843
8560
PersonID
8820
8491
PositionType
8155
7804
PositionTypeCode
8154
7801
PrimarySalaryAccountNumber
8169
7846
State
8832
8527
StateCode
8831
8524
TerminationDate
8852
8587
TerminationDateRange
8853
8590
YearsOfServiceToInstitution
8854
8593
ZipCode
8833
8530
  Output Columns
Name ID LineageID
Citizenship
8915
8915
CitizenshipCode
8914
8914
Country
8913
8913
CountryCode
8912
8912
CountryOfCitizenship
8917
8917
CountryOfCitizenshipCode
8916
8916
County
8911
8911
CountyFIPSCode
8910
8910
DateOfBirth
9320
9320
EmployeeAK
8895
8895
EmployeeFulltimeParttime
8927
8927
EmployeeSK
8894
8894
EmployeeStudentId
8924
8924
EmployeeType
8898
8898
EmployeeTypeCode
8897
8897
Ethnicity
8906
8906
EthnicityCode
8905
8905
FirstName
8901
8901
FullName
8899
8899
FunctionCode
8212
8212
FunctionDesc
8922
8922
Gender
8904
8904
GenderCode
8903
8903
HasActiveAssignment
8918
8918
HasDirectDeposit
8925
8925
HireDate
8926
8926
IsAStudent
8923
8923
LastActiveAssignmentDateRange
8920
8920
LastName
8900
8900
LastPayCheckDateRange
8921
8921
Location
9403
9403
LocationCode
9402
9402
MiddleInitial
8902
8902
NumberOfActiveAssignments
8919
8919
PersonID
8896
8896
PositionType
8211
8211
PositionTypeCode
8210
8210
PrimarySalaryAccountNumber
8225
8225
RowEndDate
7691
7691
RowIsCurrent
7667
7667
RowStartDate
7683
7683
State
8908
8908
StateCode
8907
8907
TerminationDate
8928
8928
TerminationDateRange
8929
8929
YearsOfServiceToInstitution
8930
8930
ZipCode
8909
8909
Citizenship
8991
8991
CitizenshipCode
8990
8990
Country
8989
8989
CountryCode
8988
8988
CountryOfCitizenship
8993
8993
CountryOfCitizenshipCode
8992
8992
County
8987
8987
CountyFIPSCode
8986
8986
DateOfBirth
9324
9324
EmployeeAK
8971
8971
EmployeeFulltimeParttime
9003
9003
EmployeeSK
8970
8970
EmployeeStudentId
9000
9000
EmployeeType
8974
8974
EmployeeTypeCode
8973
8973
Ethnicity
8982
8982
EthnicityCode
8981
8981
FirstName
8977
8977
FullName
8975
8975
FunctionCode
8268
8268
FunctionDesc
8998
8998
Gender
8980
8980
GenderCode
8979
8979
HasActiveAssignment
8994
8994
HasDirectDeposit
9001
9001
HireDate
9002
9002
IsAStudent
8999
8999
LastActiveAssignmentDateRange
8996
8996
LastName
8976
8976
LastPayCheckDateRange
8997
8997
Location
9409
9409
LocationCode
9408
9408
MiddleInitial
8978
8978
NumberOfActiveAssignments
8995
8995
PersonID
8972
8972
PositionType
8267
8267
PositionTypeCode
8266
8266
PrimarySalaryAccountNumber
8281
8281
Row Change Reason
8373
8373
RowEndDate
7693
7693
RowIsCurrent
7671
7671
RowStartDate
7685
7685
State
8984
8984
StateCode
8983
8983
TerminationDate
9004
9004
TerminationDateRange
9005
9005
YearsOfServiceToInstitution
9006
9006
ZipCode
8985
8985
Powered by BI Documenter