FactStudentGradesLoad
 OLE_SRC Grades from Staging (Component)
  Properties
Property Value
Name OLE_SRC Grades from Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 783
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 Grades from Staging" (783)
Is Default Locale False
Pipeline Version 0
Uses Dispositions True
Validate External Metadata True
Version 7
  Connections
Name Connection Manager Description
OleDbConnection
  Custom Properties
Name Value
AccessMode
2
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
exec usp_FactActiveStudentGrades
SqlCommandVariable
User::Get_Grades
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
Attempt1
1192
1192
Attempt2
1195
1195
Attempt2OrMore
1198
1198
Attempt3OrMore
1201
1201
ErrorCode
814
814
ErrorColumn
815
815
GradeA
1153
1153
GradeB
1156
1156
GradeByLetterOther
1189
1189
GradeC
1159
1159
GradeD
1162
1162
GradeF
1165
1165
GradeFail
1144
1144
GradeI
1186
1186
GradeMarginal
1141
1141
GradeN
1180
1180
GradeOther
1150
1150
GradeP
1174
1174
GradeS
1171
1171
GradeSuccess
1138
1138
GradeU
1177
1177
GradeW
1168
1168
GradeWithdrawal
1147
1147
GradeX
1183
1183
RefNum
1135
1135
StudentId
1129
1129
Term
1389
1389
Attempt1
1191
1191
Attempt2
1194
1194
Attempt2OrMore
1197
1197
Attempt3OrMore
1200
1200
GradeA
1152
1152
GradeB
1155
1155
GradeByLetterOther
1188
1188
GradeC
1158
1158
GradeD
1161
1161
GradeF
1164
1164
GradeFail
1143
1143
GradeI
1185
1185
GradeMarginal
1140
1140
GradeN
1179
1179
GradeOther
1149
1149
GradeP
1173
1173
GradeS
1170
1170
GradeSuccess
1137
1137
GradeU
1176
1176
GradeW
1167
1167
GradeWithdrawal
1146
1146
GradeX
1182
1182
RefNum
1134
1134
StudentId
1128
1128
Term
1388
1388
Powered by BI Documenter