|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Verification Temp table from ASSIGNMENT_A Staging |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 1 |
| Component Class ID | {BCEFE59B-6819-47F7-A125-63753B33ABB7} |
| Contact Info | OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7 |
| Identification String | component "OLE_SRC Verification Temp table from ASSIGNMENT_A Staging" (1) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 7 |
Connections
| Name | Connection Manager | Description |
OleDbConnection |
Custom Properties
| Name | Value |
AccessMode |
2 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
OpenRowset |
|
OpenRowsetVariable |
|
ParameterMapping |
|
SqlCommand |
exec usp_DimAssignment_Select |
SqlCommandVariable |
User::GetPositionMods |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
ActualSalary |
2690 |
2690 |
AssignmentAK |
2618 |
2618 |
AssignmentEndDateRange |
2675 |
2675 |
AssignmentFulltimeParttime |
2672 |
2672 |
AssignmentSequenceNumber |
2624 |
2624 |
AssignmentStatus |
2630 |
2630 |
AssignmentType |
2636 |
2636 |
AssignmentTypeCode |
2633 |
2633 |
BaseSalary |
2687 |
2687 |
DailyRate |
2693 |
2693 |
EndBasis |
2684 |
2684 |
EndBasisCode |
2681 |
2681 |
EndDate |
2642 |
2642 |
ErrorCode |
13 |
13 |
ErrorColumn |
14 |
14 |
ExemptStatus |
2669 |
2669 |
FunctionCode |
2044 |
2044 |
FunctionDescription |
2047 |
2047 |
HourlyRate |
2696 |
2696 |
InstitutionalAssignmentType |
2660 |
2660 |
InstitutionalAssignmentTypeCode |
2657 |
2657 |
JobClassCode |
2651 |
2651 |
JobGroup |
2648 |
2648 |
JobGroupCode |
2645 |
2645 |
JobTitle |
2627 |
2627 |
LastPaymentDateRange |
2836 |
2836 |
OvertimeRate |
2699 |
2699 |
PayBasis |
2654 |
2654 |
PersonID |
2197 |
2197 |
PositionCode |
2621 |
2621 |
PrimaryAssignment |
2663 |
2663 |
PrimarySalaryAccountNumber |
2083 |
2083 |
RegularTemporary |
2666 |
2666 |
StartDate |
2639 |
2639 |
TotalSalary |
2702 |
2702 |
ActualSalary |
2689 |
2689 |
AssignmentAK |
2617 |
2617 |
AssignmentEndDateRange |
2674 |
2674 |
AssignmentFulltimeParttime |
2671 |
2671 |
AssignmentSequenceNumber |
2623 |
2623 |
AssignmentStatus |
2629 |
2629 |
AssignmentType |
2635 |
2635 |
AssignmentTypeCode |
2632 |
2632 |
BaseSalary |
2686 |
2686 |
DailyRate |
2692 |
2692 |
EndBasis |
2683 |
2683 |
EndBasisCode |
2680 |
2680 |
EndDate |
2641 |
2641 |
ExemptStatus |
2668 |
2668 |
FunctionCode |
2043 |
2043 |
FunctionDescription |
2046 |
2046 |
HourlyRate |
2695 |
2695 |
InstitutionalAssignmentType |
2659 |
2659 |
InstitutionalAssignmentTypeCode |
2656 |
2656 |
JobClassCode |
2650 |
2650 |
JobGroup |
2647 |
2647 |
JobGroupCode |
2644 |
2644 |
JobTitle |
2626 |
2626 |
LastPaymentDateRange |
2835 |
2835 |
OvertimeRate |
2698 |
2698 |
PayBasis |
2653 |
2653 |
PersonID |
2196 |
2196 |
PositionCode |
2620 |
2620 |
PrimaryAssignment |
2662 |
2662 |
PrimarySalaryAccountNumber |
2082 |
2082 |
RegularTemporary |
2665 |
2665 |
StartDate |
2638 |
2638 |
TotalSalary |
2701 |
2701 |
| Powered by BI Documenter |
