FactPriorEnrollmentSnapshotLoad
 OLE_SRC Copy Archived Active Enrollment from Staging to Operations 1 (Component)
Home  Diagrams  Documents  Images  FactPriorEnrollmentSnapshotLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  FactPriorEnrollmentSnapshotLoad   FELC Loop Thru Prior Terms   DFT Copy Term Enrollment data to Operations   OLE_SRC Copy Archived Active Enrollment from Staging to Operations 1
  Properties
Property Value
Name OLE_SRC Copy Archived Active Enrollment from Staging to Operations 1
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 118
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 Copy Archived Active Enrollment from Staging to Operations 1" (118)
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::Copy_ArchivedPriorEnrollment
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
EFF_TRM
146
146
ErrorCode
152
152
ErrorColumn
153
153
LOG_DATE
148
148
LOG_TIME
149
149
NOT_PAID_FLG
150
150
REF_NUM
147
147
STDNT_ID
145
145
TRNSCTN_TY
151
151
EFF_TRM
131
131
LOG_DATE
133
133
LOG_TIME
134
134
NOT_PAID_FLG
135
135
REF_NUM
132
132
STDNT_ID
130
130
TRNSCTN_TY
136
136
Powered by BI Documenter