|
|
||||||
|
|
||||||
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 |
Apprenticeship |
5342 |
5281 |
Campus |
5321 |
5218 |
CampusCode |
5320 |
5215 |
Center |
5323 |
5224 |
CenterCode |
5322 |
5221 |
ClassStatus |
5327 |
5236 |
ClassStatusCode |
5326 |
5233 |
ClassTitle |
5307 |
5176 |
CourseId |
5303 |
5164 |
CourseIdPrefix |
5306 |
5173 |
CourseLevel |
6148 |
6146 |
CourseNumberTimesForCredit |
5832 |
5824 |
CourseType |
5309 |
5182 |
CourseTypeCode |
5308 |
5179 |
CreditNonCredit |
5313 |
5194 |
CreditNonCreditVocational |
5310 |
5185 |
CreditNonCreditVocationalTest |
6293 |
6291 |
CreditType |
5312 |
5191 |
CreditTypeCode |
5311 |
5188 |
CurrentCourseId |
5305 |
5170 |
CurrentTerm |
5304 |
5167 |
DeliveryMethod |
5330 |
5245 |
Department |
5319 |
5212 |
DepartmentCode |
5318 |
5209 |
DepartmentDescription |
6365 |
6362 |
Division |
5317 |
5206 |
DivisionCode |
5316 |
5203 |
DivisionDescription |
6364 |
6359 |
DualEnrollment |
5340 |
5275 |
Honors |
5338 |
5269 |
ICSCategoryCode |
5827 |
5809 |
ICSCode |
5314 |
5197 |
IndependentStudy |
5341 |
5278 |
InstructionalClassification |
5315 |
5200 |
InstructionalClassificationCategory |
5828 |
5812 |
IsCourseRepeatable |
6008 |
6005 |
IsTermCourseIdCountGE10 |
6007 |
6002 |
MaximumClassSize |
5325 |
5230 |
MinimumClassSize |
5324 |
5227 |
Online100Percent |
5344 |
5287 |
PrimaryInstructorFirstName |
5334 |
5257 |
PrimaryInstructorFullName |
5332 |
5251 |
PrimaryInstructorId |
5331 |
5248 |
PrimaryInstructorLastName |
5446 |
5444 |
PrimaryInstructorMiddleInitial |
5335 |
5260 |
PrimaryInstructorType |
5826 |
5806 |
ReferenceNumber |
5300 |
5155 |
ReferenceNumberAK |
5299 |
5152 |
ScheduleInformation |
5347 |
5296 |
Session |
5337 |
5266 |
SessionCode |
5336 |
5263 |
Term |
5301 |
5158 |
TermCourseIdCount |
5829 |
5815 |
TermTitle |
5302 |
5161 |
TimeBlock |
5329 |
5242 |
TimeBlockCode |
5328 |
5239 |
VerifyCurriculumSK |
5298 |
5149 |
VirtualCollege |
5343 |
5284 |
WebBlended |
5346 |
5293 |
WebEnabled |
5345 |
5290 |
WeekendCollege |
5339 |
5272 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
3720 |
3720 |
ErrorColumn |
3721 |
3721 |
| Powered by BI Documenter |
