|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Verification Temp table from EMPLOYEE_A Staging and NON_EMPLOYEE_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 EMPLOYEE_A Staging and NON_EMPLOYEE_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_DimEmployee_Select |
SqlCommandVariable |
User::GetPositionMods |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
Citizenship |
2248 |
2248 |
CitizenshipCode |
2245 |
2245 |
Country |
2242 |
2242 |
CountryCode |
2239 |
2239 |
CountryOfCitizenship |
2254 |
2254 |
CountryOfCitizenshipCode |
2251 |
2251 |
DateOfBirth |
2618 |
2618 |
EmployeeAK |
2194 |
2194 |
EmployeeFulltimeParttime |
2281 |
2281 |
EmployeeStudentId |
2272 |
2272 |
EmployeeType |
2203 |
2203 |
EmployeeTypeCode |
2200 |
2200 |
ErrorCode |
13 |
13 |
ErrorColumn |
14 |
14 |
Ethnicity |
2227 |
2227 |
EthnicityCode |
2224 |
2224 |
FirstName |
2212 |
2212 |
FullName |
2206 |
2206 |
FunctionCode |
2044 |
2044 |
FunctionDescription |
2047 |
2047 |
Gender |
2221 |
2221 |
GenderCode |
2218 |
2218 |
HasActiveAssignment |
2257 |
2257 |
HasDirectDeposit |
2275 |
2275 |
HireDate |
2278 |
2278 |
IsStudent |
2269 |
2269 |
LastActiveAssignmentDateRange |
2263 |
2263 |
LastName |
2209 |
2209 |
LastPayCheckDateRange |
2266 |
2266 |
Location |
2664 |
2664 |
LocationCode |
2661 |
2661 |
MiddleInitial |
2215 |
2215 |
NumberOfActiveAssignments |
2260 |
2260 |
PersonID |
2197 |
2197 |
PositionType |
2041 |
2041 |
PositionTypeCode |
2038 |
2038 |
PrimarySalaryAccountNumber |
2083 |
2083 |
State |
2233 |
2233 |
StateCode |
2230 |
2230 |
TerminationDate |
2284 |
2284 |
TerminationDateRange |
2287 |
2287 |
YearsOfServiceToInstitution |
2293 |
2293 |
ZipCode |
2236 |
2236 |
Citizenship |
2247 |
2247 |
CitizenshipCode |
2244 |
2244 |
Country |
2241 |
2241 |
CountryCode |
2238 |
2238 |
CountryOfCitizenship |
2253 |
2253 |
CountryOfCitizenshipCode |
2250 |
2250 |
DateOfBirth |
2617 |
2617 |
EmployeeAK |
2193 |
2193 |
EmployeeFulltimeParttime |
2280 |
2280 |
EmployeeStudentId |
2271 |
2271 |
EmployeeType |
2202 |
2202 |
EmployeeTypeCode |
2199 |
2199 |
Ethnicity |
2226 |
2226 |
EthnicityCode |
2223 |
2223 |
FirstName |
2211 |
2211 |
FullName |
2205 |
2205 |
FunctionCode |
2043 |
2043 |
FunctionDescription |
2046 |
2046 |
Gender |
2220 |
2220 |
GenderCode |
2217 |
2217 |
HasActiveAssignment |
2256 |
2256 |
HasDirectDeposit |
2274 |
2274 |
HireDate |
2277 |
2277 |
IsStudent |
2268 |
2268 |
LastActiveAssignmentDateRange |
2262 |
2262 |
LastName |
2208 |
2208 |
LastPayCheckDateRange |
2265 |
2265 |
Location |
2663 |
2663 |
LocationCode |
2660 |
2660 |
MiddleInitial |
2214 |
2214 |
NumberOfActiveAssignments |
2259 |
2259 |
PersonID |
2196 |
2196 |
PositionType |
2040 |
2040 |
PositionTypeCode |
2037 |
2037 |
PrimarySalaryAccountNumber |
2082 |
2082 |
State |
2232 |
2232 |
StateCode |
2229 |
2229 |
TerminationDate |
2283 |
2283 |
TerminationDateRange |
2286 |
2286 |
YearsOfServiceToInstitution |
2292 |
2292 |
ZipCode |
2235 |
2235 |
| Powered by BI Documenter |
