DimProgramRetentionCohortLoad
 OLE_SRC Verification Temp table from Program Retention Staging (Component)
  Properties
Property Value
Name OLE_SRC Verification Temp table from Program Retention Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 1
Component Class ID {BCEFE59B-6819-47F7-A125-63753B33ABB7}
Contact Info OLE DB Source;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;7
Identification String component "OLE_SRC Verification Temp table from Program Retention Staging" (1)
Is Default Locale True
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
select 1 as A
SqlCommandVariable
User::GetRecords
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
AgeAtProgramRetentionCohort
1902
1902
AgeRangeAtProgramRetentionCohort
1905
1905
AwardType
864
864
AwardTypeCode
861
861
CIP
1899
1899
CIPCode
1896
1896
CohortTerm
1710
1710
CohortTermTitle
1713
1713
ErrorCode
13
13
ErrorColumn
14
14
Program
834
834
ProgramAdmitStatus
1716
1716
ProgramCode
831
831
ProgramRetentionCohortAK
1893
1893
StudentId
822
822
SwitchedAwardType
1923
1923
SwitchedAwardTypeCode
1920
1920
SwitchedCIP
1929
1929
SwitchedCIPCode
1926
1926
SwitchedProgram
1911
1911
SwitchedProgramCode
1908
1908
SwitchedTerm
1914
1914
SwitchedTermTitle
1917
1917
AgeAtProgramRetentionCohort
1901
1901
AgeRangeAtProgramRetentionCohort
1904
1904
AwardType
863
863
AwardTypeCode
860
860
CIP
1898
1898
CIPCode
1895
1895
CohortTerm
1709
1709
CohortTermTitle
1712
1712
Program
833
833
ProgramAdmitStatus
1715
1715
ProgramCode
830
830
ProgramRetentionCohortAK
1892
1892
StudentId
821
821
SwitchedAwardType
1922
1922
SwitchedAwardTypeCode
1919
1919
SwitchedCIP
1928
1928
SwitchedCIPCode
1925
1925
SwitchedProgram
1910
1910
SwitchedProgramCode
1907
1907
SwitchedTerm
1913
1913
SwitchedTermTitle
1916
1916
Powered by BI Documenter