|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | TF Transform Case |
| 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 | 975 |
| Component Class ID | {2E42D45B-F83C-400F-8D77-61DDE6A7DF29} |
| Contact Info | TF Name Parse Transform;Pragmatic Works, Inc; Task Factory (c) 2009 - 2012 Pragmatic Works, Inc; http://www.pragmaticworks.com;support@pragmaticworks.com |
| Identification String | component "TF Transform Case" (975) |
| 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 |
CellPhoneNumber |
1011 |
946 |
CountryOfBirth |
1022 |
968 |
CountryOfBirthCode |
1021 |
966 |
CountryOfCitizenship |
1024 |
972 |
CountryOfCitizenshipCode |
1023 |
970 |
DateOfBirth |
997 |
918 |
Ethnicity |
991 |
906 |
EthnicityCode |
990 |
904 |
FERPARequested |
1020 |
964 |
FirstName |
986 |
896 |
FirstTimeInCollege |
992 |
908 |
FullName |
1006 |
936 |
Gender |
989 |
902 |
GenderCode |
988 |
900 |
HighSchool |
1009 |
942 |
HighSchoolInstitutionId |
1008 |
940 |
HomeCampus |
3058 |
3049 |
HomeCampusCode |
3057 |
3046 |
HomePhoneNumber |
1010 |
944 |
ImmigrationStatus |
1015 |
954 |
ImmigrationStatusCode |
1014 |
952 |
InitialPrepStatus |
2934 |
2911 |
InstitutionalEmailAddress |
1012 |
948 |
InternationalStudent |
2937 |
2920 |
LastName |
985 |
894 |
MiddleName |
987 |
898 |
PersonalEmailAddress |
1013 |
950 |
PrimaryLanguage |
993 |
910 |
PrimaryLanguageCode |
1007 |
938 |
RaceAfricanAmerican |
999 |
922 |
RaceAmericanIndian |
1002 |
928 |
RaceAsian |
1001 |
926 |
RacePacificIslander |
1000 |
924 |
RaceUnreported |
1003 |
930 |
RaceWhite |
998 |
920 |
Residency |
995 |
914 |
ResidencyCode |
994 |
912 |
ResidencyCounty |
1017 |
958 |
ResidencyCountyCode |
1016 |
956 |
ResidencyState |
1019 |
962 |
ResidencyStateCode |
1018 |
960 |
StudentAthlete |
2936 |
2917 |
StudentId |
1005 |
934 |
StudentIdAK |
984 |
892 |
VerifyStudentIdSK |
1004 |
932 |
VeteranStudent |
2935 |
2914 |
ZipCode |
996 |
916 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
980 |
980 |
ErrorColumn |
981 |
981 |
| Powered by BI Documenter |
