|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Get DimEmployee |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 3782 |
| 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 Get DimEmployee" (3782) |
| 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 |
SELECT EmployeeSK ,EmployeeAK ,PersonID ,EmployeeTypeCode ,EmployeeType ,FullName ,LastName ,FirstName ,MiddleInitial ,GenderCode ,Gender ,EthnicityCode ,Ethnicity ,StateCode ,State ,ZipCode ,CountyFIPSCode ,County ,CountryCode ,Country ,CitizenshipCode ,Citizenship ,CountryOfCitizenshipCode ,CountryOfCitizenship ,HasActiveAssignment ,NumberOfActiveAssignments ,LastActiveAssignmentDateRange ,LastPayCheckDateRange ,PositionTypeCode ,PositionType ,FunctionCode ,FunctionDesc ,LocationCode ,Location ,PrimarySalaryAccountNumber ,IsAStudent ,EmployeeStudentId ,HasDirectDeposit ,HireDate ,EmployeeFulltimeParttime ,TerminationDate ,TerminationDateRange ,YearsOfServiceToInstitution ,DateOfBirth ,RowIsCurrent ,RowStartDate ,RowEndDate FROM DimEmployee WHERE RowIsCurrent = 'Y' ORDER BY EmployeeAK |
SqlCommandVariable |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
Citizenship |
8660 |
8660 |
CitizenshipCode |
8657 |
8657 |
Country |
8654 |
8654 |
CountryCode |
8651 |
8651 |
CountryOfCitizenship |
8666 |
8666 |
CountryOfCitizenshipCode |
8663 |
8663 |
County |
8648 |
8648 |
CountyFIPSCode |
8645 |
8645 |
DateOfBirth |
9314 |
9314 |
EmployeeAK |
8600 |
8600 |
EmployeeFulltimeParttime |
8696 |
8696 |
EmployeeSK |
8597 |
8597 |
EmployeeStudentId |
8687 |
8687 |
EmployeeType |
8609 |
8609 |
EmployeeTypeCode |
8606 |
8606 |
ErrorCode |
3794 |
3794 |
ErrorColumn |
3795 |
3795 |
Ethnicity |
8633 |
8633 |
EthnicityCode |
8630 |
8630 |
FirstName |
8618 |
8618 |
FullName |
8612 |
8612 |
FunctionCode |
7979 |
7979 |
FunctionDesc |
8681 |
8681 |
Gender |
8627 |
8627 |
GenderCode |
8624 |
8624 |
HasActiveAssignment |
8669 |
8669 |
HasDirectDeposit |
8690 |
8690 |
HireDate |
8693 |
8693 |
IsAStudent |
8684 |
8684 |
LastActiveAssignmentDateRange |
8675 |
8675 |
LastName |
8615 |
8615 |
LastPayCheckDateRange |
8678 |
8678 |
Location |
9393 |
9393 |
LocationCode |
9390 |
9390 |
MiddleInitial |
8621 |
8621 |
NumberOfActiveAssignments |
8672 |
8672 |
PersonID |
8603 |
8603 |
PositionType |
7976 |
7976 |
PositionTypeCode |
7973 |
7973 |
PrimarySalaryAccountNumber |
8018 |
8018 |
RowEndDate |
8048 |
8048 |
RowIsCurrent |
8042 |
8042 |
RowStartDate |
8045 |
8045 |
State |
8639 |
8639 |
StateCode |
8636 |
8636 |
TerminationDate |
8699 |
8699 |
TerminationDateRange |
8702 |
8702 |
YearsOfServiceToInstitution |
8705 |
8705 |
ZipCode |
8642 |
8642 |
Citizenship |
8659 |
8659 |
CitizenshipCode |
8656 |
8656 |
Country |
8653 |
8653 |
CountryCode |
8650 |
8650 |
CountryOfCitizenship |
8665 |
8665 |
CountryOfCitizenshipCode |
8662 |
8662 |
County |
8647 |
8647 |
CountyFIPSCode |
8644 |
8644 |
DateOfBirth |
9313 |
9313 |
EmployeeAK |
8599 |
8599 |
EmployeeFulltimeParttime |
8695 |
8695 |
EmployeeSK |
8596 |
8596 |
EmployeeStudentId |
8686 |
8686 |
EmployeeType |
8608 |
8608 |
EmployeeTypeCode |
8605 |
8605 |
Ethnicity |
8632 |
8632 |
EthnicityCode |
8629 |
8629 |
FirstName |
8617 |
8617 |
FullName |
8611 |
8611 |
FunctionCode |
7978 |
7978 |
FunctionDesc |
8680 |
8680 |
Gender |
8626 |
8626 |
GenderCode |
8623 |
8623 |
HasActiveAssignment |
8668 |
8668 |
HasDirectDeposit |
8689 |
8689 |
HireDate |
8692 |
8692 |
IsAStudent |
8683 |
8683 |
LastActiveAssignmentDateRange |
8674 |
8674 |
LastName |
8614 |
8614 |
LastPayCheckDateRange |
8677 |
8677 |
Location |
9392 |
9392 |
LocationCode |
9389 |
9389 |
MiddleInitial |
8620 |
8620 |
NumberOfActiveAssignments |
8671 |
8671 |
PersonID |
8602 |
8602 |
PositionType |
7975 |
7975 |
PositionTypeCode |
7972 |
7972 |
PrimarySalaryAccountNumber |
8017 |
8017 |
RowEndDate |
8047 |
8047 |
RowIsCurrent |
8041 |
8041 |
RowStartDate |
8044 |
8044 |
State |
8638 |
8638 |
StateCode |
8635 |
8635 |
TerminationDate |
8698 |
8698 |
TerminationDateRange |
8701 |
8701 |
YearsOfServiceToInstitution |
8704 |
8704 |
ZipCode |
8641 |
8641 |
| Powered by BI Documenter |
