|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF Case Transform |
| Description | The case transformation corrects, cases and standardizes names, addresses or any text to proper case for any input columns data. |
| Up Stream Components | |
| Down Stream Components | |
| ID | 3715 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | TF Name Parse Transform; Pragmatic Works, Inc; Task Factory (c) 2011 Pragmatic Works, Inc; http://www.pragmaticworks.com;support@pragmaticworks.com |
| Identification String | component "TF Case Transform" (3715) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 1 |
Connections
| Name | Connection Manager | Description |
Custom Properties
| Name | Value |
UserComponentTypeName |
PW.TaskFactory.CaseAndStandardizationTransform.CaseAndStandardizationTransform, PW.TaskFactory100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=47acf905d0337c39 |
Input Columns
| Name | ID | LineageID |
Citizenship |
8727 |
8548 |
CitizenshipCode |
8726 |
8545 |
Country |
8725 |
8542 |
CountryCode |
8724 |
8539 |
CountryOfCitizenship |
8729 |
8554 |
CountryOfCitizenshipCode |
8728 |
8551 |
County |
8723 |
8536 |
CountyFIPSCode |
8722 |
8533 |
DateOfBirth |
9272 |
9270 |
EmployeeAK |
8707 |
8488 |
EmployeeFulltimeParttime |
8739 |
8584 |
EmployeeStudentId |
8736 |
8575 |
EmployeeType |
8710 |
8497 |
EmployeeTypeCode |
8709 |
8494 |
Ethnicity |
8718 |
8521 |
EthnicityCode |
8717 |
8518 |
FirstName |
8713 |
8506 |
FullName |
8711 |
8500 |
FunctionCode |
8056 |
7807 |
FunctionDesc |
8734 |
8569 |
Gender |
8716 |
8515 |
GenderCode |
8715 |
8512 |
HasActiveAssignment |
8730 |
8557 |
HasDirectDeposit |
8737 |
8578 |
HireDate |
8738 |
8581 |
IsAStudent |
8735 |
8572 |
LastActiveAssignmentDateRange |
8732 |
8563 |
LastName |
8712 |
8503 |
LastPayCheckDateRange |
8733 |
8566 |
Location |
9345 |
9342 |
LocationCode |
9344 |
9339 |
MiddleInitial |
8714 |
8509 |
NumberOfActiveAssignments |
8731 |
8560 |
PersonID |
8708 |
8491 |
PositionType |
8055 |
7804 |
PositionTypeCode |
8054 |
7801 |
PrimarySalaryAccountNumber |
8069 |
7846 |
RowIsDuplicate |
6645 |
6511 |
RowIsSelected |
6646 |
6514 |
State |
8720 |
8527 |
StateCode |
8719 |
8524 |
TerminationDate |
8740 |
8587 |
TerminationDateRange |
8741 |
8590 |
VerifyEmployeeSK |
8706 |
8485 |
YearsOfServiceToInstitution |
8742 |
8593 |
ZipCode |
8721 |
8530 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3720 |
3720 |
ErrorColumn |
3721 |
3721 |
| Powered by BI Documenter |
