|
|
||||||
|
|
||||||
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 |
Budgeted |
8064 |
7831 |
CountOfActiveAssignments |
8070 |
7849 |
CountOfInactiveAssignments |
8071 |
7852 |
DateEstablished |
8058 |
7813 |
DateInactivated |
8059 |
7816 |
ExemptStatus |
8067 |
7840 |
FulltimeEquivalent |
8075 |
7864 |
FunctionCode |
8056 |
7807 |
FunctionDescription |
8057 |
7810 |
InactiveReason |
8073 |
7858 |
InactiveReasonCode |
8072 |
7855 |
InactiveVacantDateRange |
8564 |
8559 |
JobClassCode |
8062 |
7825 |
JobGroup |
8061 |
7822 |
JobGroupCode |
8060 |
7819 |
Location |
8491 |
8488 |
LocationCode |
8490 |
8485 |
MultipleFunds |
8616 |
8611 |
PayBasis |
8063 |
7828 |
PooledIndicator |
8066 |
7837 |
PositionAK |
8050 |
7789 |
PositionCode |
8051 |
7792 |
PositionFulltimeParttime |
8068 |
7843 |
PositionStatus |
8053 |
7798 |
PositionTitle |
8052 |
7795 |
PositionType |
8055 |
7804 |
PositionTypeCode |
8054 |
7801 |
PrimarySalaryAccountNumber |
8069 |
7846 |
RegularTemporary |
8065 |
7834 |
RowIsDuplicate |
6645 |
6511 |
RowIsSelected |
6646 |
6514 |
VerifyPositionSK |
8049 |
7786 |
WeeklyAuthorizedHours |
8076 |
7867 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3720 |
3720 |
ErrorColumn |
3721 |
3721 |
| Powered by BI Documenter |
