|
|
||||||
|
|
||||||
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 |
ActualSalary |
9481 |
9348 |
AssignmentAK |
9456 |
9273 |
AssignmentEndDateRange |
9476 |
9333 |
AssignmentFulltimeParttime |
9475 |
9330 |
AssignmentSequenceNumber |
9459 |
9282 |
AssignmentStatus |
9461 |
9288 |
AssignmentType |
9463 |
9294 |
AssignmentTypeCode |
9462 |
9291 |
BaseSalary |
9480 |
9345 |
DailyRate |
9482 |
9351 |
EndBasis |
9479 |
9342 |
EndBasisCode |
9478 |
9339 |
EndDate |
9465 |
9300 |
ExemptStatus |
9474 |
9327 |
FunctionCode |
8056 |
7807 |
FunctionDesc |
8734 |
8569 |
HourlyRate |
9483 |
9354 |
InstitutionalAssignmentType |
9471 |
9318 |
InstitutionalAssignmentTypeCode |
9470 |
9315 |
JobClassCode |
9468 |
9309 |
JobGroup |
9467 |
9306 |
JobGroupCode |
9466 |
9303 |
JobTitle |
9460 |
9285 |
LastPaymentDateRange |
9477 |
9336 |
OvertimeRate |
9484 |
9357 |
PayBasis |
9469 |
9312 |
PersonId |
9457 |
9276 |
PositionCode |
9458 |
9279 |
PrimaryAssignment |
9472 |
9321 |
PrimarySalaryAccountNumber |
8069 |
7846 |
RegularTemporary |
9473 |
9324 |
RowIsDuplicate |
6645 |
6511 |
RowIsSelected |
6646 |
6514 |
StartDate |
9464 |
9297 |
TotalSalary |
9485 |
9360 |
VerifyAssignmentSK |
9455 |
9270 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3720 |
3720 |
ErrorColumn |
3721 |
3721 |
| Powered by BI Documenter |
