DimStudentTermLoad
 OLE_SRC Verification Temp table from Student Term Staging (Component)
  Properties
Property Value
Name OLE_SRC Verification Temp table from Student Term 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 Student Term 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::GetStudentTermMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
AcademicStatus
843
843
AcademicStatusCode
840
840
Advised
867
867
AdvisementAdvisor
897
897
AdvisementAdvisorId
894
894
AdvisementAwardType
891
891
AdvisementAwardTypeCode
888
888
AdvisementMandatory
876
876
AdvisementProgram
885
885
AdvisementProgramCode
882
882
AdvisementStatus
873
873
AdvisementStatusCode
870
870
AgeAtTerm
858
858
AgeRangeAtTerm
1316
1316
AwardType
864
864
AwardTypeCode
861
861
BasisOfAdmission
849
849
BasisOfAdmissionCode
846
846
DateLastAdvised
879
879
EnrollmentStatus
855
855
EnrollmentStatusCode
852
852
ErrorCode
13
13
ErrorColumn
14
14
Program
834
834
ProgramAdmitStatus
837
837
ProgramCode
831
831
Residency
828
828
ResidencyCode
825
825
SdbAwardTypeCode
1347
1347
StudentId
822
822
StudentTermAK
819
819
Term
291
291
TermTitle
294
294
TransferInstitutionAdvisement
909
909
TransferInstitutionAdvisementId
906
906
TransferMajorAdvisement
903
903
TransferMajorAdvisementCode
900
900
AcademicStatus
842
842
AcademicStatusCode
839
839
Advised
866
866
AdvisementAdvisor
896
896
AdvisementAdvisorId
893
893
AdvisementAwardType
890
890
AdvisementAwardTypeCode
887
887
AdvisementMandatory
875
875
AdvisementProgram
884
884
AdvisementProgramCode
881
881
AdvisementStatus
872
872
AdvisementStatusCode
869
869
AgeAtTerm
857
857
AgeRangeAtTerm
1315
1315
AwardType
863
863
AwardTypeCode
860
860
BasisOfAdmission
848
848
BasisOfAdmissionCode
845
845
DateLastAdvised
878
878
EnrollmentStatus
854
854
EnrollmentStatusCode
851
851
Program
833
833
ProgramAdmitStatus
836
836
ProgramCode
830
830
Residency
827
827
ResidencyCode
824
824
SdbAwardTypeCode
1346
1346
StudentId
821
821
StudentTermAK
818
818
Term
290
290
TermTitle
293
293
TransferInstitutionAdvisement
908
908
TransferInstitutionAdvisementId
905
905
TransferMajorAdvisement
902
902
TransferMajorAdvisementCode
899
899
Powered by BI Documenter