OLE_SRC Get DimStudent

Property	Value
Name	OLE_SRC Get DimStudent
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	TF_SCD Student Slowly Changing Dimension Process
ID	681
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 Get DimStudent" (681)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Name	Connection Manager	Description
OleDbConnection	EnterpriseDW

Name	Value
AccessMode	2
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	SELECT [StudentSK] AS StudentSK ,[StudentIdAK] AS StudentIdAK ,[StudentId] AS StudentId ,[FullName] AS FullName ,[LastName] AS LastName ,[FirstName] AS FirstName ,[MiddleName] AS MiddleName ,[GenderCode] AS GenderCode ,[Gender] AS Gender ,[EthnicityCode] AS EthnicityCode ,[Ethnicity] AS Ethnicity ,[FirstTimeInCollege] AS FirstTimeInCollege ,[PrimaryLanguageCode] AS PrimaryLanguageCode ,[PrimaryLanguage] AS PrimaryLanguage ,[HighSchoolInstitutionId] AS HighSchoolInstitutionId ,[HighSchool] AS HighSchool ,[HomePhoneNumber] AS HomePhoneNumber ,[CellPhoneNumber] AS CellPhoneNumber ,[InstitutionalEmailAddress] AS InstitutionalEmailAddress ,[PersonalEmailAddress] AS PersonalEmailAddress ,[ImmigrationStatusCode] AS ImmigrationStatusCode ,[ImmigrationStatus] AS ImmigrationStatus ,[ResidencyCode] AS ResidencyCode ,[Residency] AS Residency ,[ResidencyCountyCode] AS ResidencyCountyCode ,[ResidencyCounty] AS ResidencyCounty ,[ResidencyStateCode] AS ResidencyStateCode ,[ResidencyState] AS ResidencyState ,[ZipCode] AS ZipCode ,[DateOfBirth] AS DateOfBirth ,[FERPARequested] AS FERPARequested ,[RaceWhite] AS RaceWhite ,[RaceAfricanAmerican] AS RaceAfricanAmerican ,[RacePacificIslander] AS RacePacificIslander ,[RaceAsian] AS RaceAsian ,[RaceAmericanIndian] AS RaceAmericanIndian ,[RaceUnreported] AS RaceUnreported ,[CountryOfBirthCode] AS CountryOfBirthCode ,[CountryOfBirth] AS CountryOfBirth ,[CountryOfCitizenshipCode] AS CountryOfCitizenshipCode ,[CountryOfCitizenship] AS CountryOfCitizenship ,[HomeCampusCode] AS HomeCampusCode ,[HomeCampus] AS HomeCampus ,[InitialPrepStatus] AS InitialPrepStatus ,[VeteranStudent] AS VeteranStudent ,[StudentAthlete] AS StudentAthlete ,[InternationalStudent] AS InternationalStudent ,[RowIsCurrent] AS RowIsCurrent ,[RowStartDate] AS RowStartDate ,[RowEndDate] AS RowEndDate FROM [dbo].[DimStudent] WHERE RowIsCurrent = 'Y' ORDER BY StudentIdAK
SqlCommandVariable

Name

ID

LineageID

Name	ID	LineageID
CellPhoneNumber	812	812
CountryOfBirth	875	875
CountryOfBirthCode	872	872
CountryOfCitizenship	881	881
CountryOfCitizenshipCode	878	878
DateOfBirth	848	848
ErrorCode	693	693
ErrorColumn	694	694
Ethnicity	791	791
EthnicityCode	788	788
FERPARequested	851	851
FirstName	776	776
FirstTimeInCollege	794	794
FullName	770	770
Gender	785	785
GenderCode	782	782
HighSchool	806	806
HighSchoolInstitutionId	803	803
HomeCampus	3056	3056
HomeCampusCode	3053	3053
HomePhoneNumber	809	809
ImmigrationStatus	824	824
ImmigrationStatusCode	821	821
InitialPrepStatus	2924	2924
InstitutionalEmailAddress	815	815
InternationalStudent	2933	2933
LastName	773	773
MiddleName	779	779
PersonalEmailAddress	818	818
PrimaryLanguage	800	800
PrimaryLanguageCode	797	797
RaceAfricanAmerican	857	857
RaceAmericanIndian	866	866
RaceAsian	863	863
RacePacificIslander	860	860
RaceUnreported	869	869
RaceWhite	854	854
Residency	830	830
ResidencyCode	827	827
ResidencyCounty	836	836
ResidencyCountyCode	833	833
ResidencyState	842	842
ResidencyStateCode	839	839
RowEndDate	890	890
RowIsCurrent	884	884
RowStartDate	887	887
StudentAthlete	2930	2930
StudentId	767	767
StudentIdAK	764	764
StudentSK	761	761
VeteranStudent	2927	2927
ZipCode	845	845
CellPhoneNumber	811	811
CountryOfBirth	874	874
CountryOfBirthCode	871	871
CountryOfCitizenship	880	880
CountryOfCitizenshipCode	877	877
DateOfBirth	847	847
Ethnicity	790	790
EthnicityCode	787	787
FERPARequested	850	850
FirstName	775	775
FirstTimeInCollege	793	793
FullName	769	769
Gender	784	784
GenderCode	781	781
HighSchool	805	805
HighSchoolInstitutionId	802	802
HomeCampus	3055	3055
HomeCampusCode	3052	3052
HomePhoneNumber	808	808
ImmigrationStatus	823	823
ImmigrationStatusCode	820	820
InitialPrepStatus	2923	2923
InstitutionalEmailAddress	814	814
InternationalStudent	2932	2932
LastName	772	772
MiddleName	778	778
PersonalEmailAddress	817	817
PrimaryLanguage	799	799
PrimaryLanguageCode	796	796
RaceAfricanAmerican	856	856
RaceAmericanIndian	865	865
RaceAsian	862	862
RacePacificIslander	859	859
RaceUnreported	868	868
RaceWhite	853	853
Residency	829	829
ResidencyCode	826	826
ResidencyCounty	835	835
ResidencyCountyCode	832	832
ResidencyState	841	841
ResidencyStateCode	838	838
RowEndDate	889	889
RowIsCurrent	883	883
RowStartDate	886	886
StudentAthlete	2929	2929
StudentId	766	766
StudentIdAK	763	763
StudentSK	760	760
VeteranStudent	2926	2926
ZipCode	844	844