DimStudentTermLoad
 TF Case Transform (Component)
  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
AcademicStatus
5551
5471
AcademicStatusCode
5550
5468
Advised
5560
5498
AdvisementAdvisor
5570
5528
AdvisementAdvisorId
5569
5525
AdvisementAwardType
5568
5522
AdvisementAwardTypeCode
5567
5519
AdvisementMandatory
5563
5507
AdvisementProgram
5566
5516
AdvisementProgramCode
5565
5513
AdvisementStatus
5562
5504
AdvisementStatusCode
5561
5501
AgeAtTerm
5556
5486
AgeRangeAtTerm
5557
5489
AwardType
5559
5495
AwardTypeCode
5558
5492
BasisOfAdmission
5553
5477
BasisOfAdmissionCode
5552
5474
DateLastAdvised
5564
5510
EnrollmentStatus
5555
5483
EnrollmentStatusCode
5554
5480
Program
5548
5462
ProgramAdmitStatus
5549
5465
ProgramCode
5547
5459
Residency
5546
5456
ResidencyCode
5545
5453
SdbAwardTypeCode
6221
6216
StudentId
5544
5450
StudentTermAK
5543
5447
Term
5301
5158
TermTitle
5302
5161
TransferInstitutionAdvisement
5574
5540
TransferInstitutionAdvisementId
5573
5537
TransferMajorAdvisement
5572
5534
TransferMajorAdvisementCode
5571
5531
VerifyStudentTermSK
5542
5444
  Output Columns
Name ID LineageID
ErrorCode
3720
3720
ErrorColumn
3721
3721
Powered by BI Documenter