FactStudentGradesLoad
 OLE_SRC Archived Grades from Staging (Component)
  Properties
Property Value
Name OLE_SRC Archived Grades from Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 823
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 Archived Grades from Staging" (823)
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
3
AlwaysUseDefaultCodePage
False
CommandTimeout
0
DefaultCodePage
1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand
SELECT
    Stdnt.STUDENT_ID as StudentIdAK
  , Stdnt.LST_NM as LastName
  , Stdnt.FRST_NM as FirstName
  , Stdnt.MDL_NM as MiddleName
  , ISNULL(Stdnt.SEX, 'N/A') as GenderCode
  , ISNULL(LookupGender.Gender, 'N/A') as Gender
  , ISNULL(Stdnt.ETHNICITY, 'N/A') as EthnicityCode
  , ISNULL(Ethnic.ETHNICITY_DESCRIPTION, 'N/A') as Ethnicity
  , CASE
        WHEN Stdnt.FMLY_HIST_FLG = 'Y' THEN 'Yes'
        ELSE 'No'
    End as FirstTimeInCollege  
  , ISNULL(Lang.LANGUAGE_DESCRIPTION, 'N/A') as PrimaryLanguage    
  , ISNULL(Stdnt.RES_CD, 'N/A') as ResidencyCode
  , ISNULL(Res.RESIDENCY_DESCRIPTION, 'N/A') as Residency
  , ISNULL(StdntAddr.ZIP_CD, 'N/A') as ZipCode
  , ISNULL(CAST(Stdnt.RES_CNTY_CD as varchar(3)), 'N/A') as CountyCode
  , ISNULL(County.COUNTY_DESCRIPTION, 'N/A') as County  
  , dbo.udf_StringToDate(ISNULL(Stdnt.DOB, '18000101')) as DateOfBirth  
  , ISNULL(dbo.udf_StudentAgeRange(Stdnt.DOB), 'N/A') as AgeRange
  , Race.White as RaceWhite
  , Race.BlackAfricanAmerican as RaceAfricanAmerican
  , Race.HawaiianPacIslander as RacePacificIslander
  , Race.Asian as RaceAsian
  , Race.AmIndianAKNative as RaceAmericanIndian
  , Race.NotReported as RaceUnreported
from ST_STDNT_A Stdnt
LEFT OUTER JOIN ST_ADDRESSES_A StdntAddr
  ON (
     Stdnt.STUDENT_ID = StdntAddr.STUDENT_ID
     AND
     StdntAddr.ADDR_TY = '01'
     )
JOIN LookupGender  
  ON (
     LookupGender.GenderCode = Stdnt.SEX
     )
LEFT OUTER JOIN uvw_CODE_Ethnicity Ethnic
  ON (
     Stdnt.ETHNICITY = Ethnic.CODE
     )
 
 LEFT OUTER JOIN uvw_CODE_Language Lang
   on (
       Stdnt.PRIM_LANG = Lang.CODE
      )
      
 LEFT OUTER JOIN uvw_CODE_Residency Res
    on (
        Stdnt.RES_CD =  Res.CODE
       ) 
 LEFT OUTER JOIN uvw_CODE_County County
    on (
        Stdnt.RES_CNTY_CD =  County.CODE
       ) 
            
JOIN uvw_StudentRace Race
   on (
      Stdnt.ISN_ST_STDNT_A = Race.ISN_ST_STDNT_A
      )
      
WHERE Stdnt.PRSPCT_FLG = 0
SqlCommandVariable
User::Get_ArchivedGrades
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
Attempt1
1267
1267
Attempt2
1270
1270
Attempt2OrMore
1273
1273
Attempt3OrMore
1276
1276
ErrorCode
854
854
ErrorColumn
855
855
GradeA
1228
1228
GradeB
1231
1231
GradeByLetterOther
1264
1264
GradeC
1234
1234
GradeD
1237
1237
GradeF
1240
1240
GradeFail
1219
1219
GradeI
1261
1261
GradeMarginal
1216
1216
GradeN
1255
1255
GradeOther
1225
1225
GradeP
1249
1249
GradeS
1246
1246
GradeSuccess
1213
1213
GradeU
1252
1252
GradeW
1243
1243
GradeWithdrawal
1222
1222
GradeX
1258
1258
RefNum
1210
1210
StudentId
1204
1204
Term
1392
1392
Attempt1
1266
1266
Attempt2
1269
1269
Attempt2OrMore
1272
1272
Attempt3OrMore
1275
1275
GradeA
1227
1227
GradeB
1230
1230
GradeByLetterOther
1263
1263
GradeC
1233
1233
GradeD
1236
1236
GradeF
1239
1239
GradeFail
1218
1218
GradeI
1260
1260
GradeMarginal
1215
1215
GradeN
1254
1254
GradeOther
1224
1224
GradeP
1248
1248
GradeS
1245
1245
GradeSuccess
1212
1212
GradeU
1251
1251
GradeW
1242
1242
GradeWithdrawal
1221
1221
GradeX
1257
1257
RefNum
1209
1209
StudentId
1203
1203
Term
1391
1391
Powered by BI Documenter