FactApplicationStatusLoad
 OLE_SRC Application Status from Staged Table (Component)
  Properties
Property Value
Name OLE_SRC Application Status from Staged Table
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 528
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 Application Status from Staged Table" (528)
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
[dbo].[FactApplicationStatus_Staging]
OpenRowsetVariable
ParameterMapping
SqlCommand
SELECT *
FROM dbo.FactApplicationStatus_Staging
WHERE RowIsSelected = 'Y'
SqlCommandVariable
User::Get_DailySnapshot
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
ApplicationAK
1294
1294
ApplicationDate
1312
1312
ApplicationSource
1303
1303
ApplicationTerm
1300
1300
EnrolledAfterApplicationTerm
1342
1342
EnrolledInApplicationTerm
1345
1345
ErrorCode
559
559
ErrorColumn
560
560
NeedAdvising
1318
1318
NeedEducationalPlan
1330
1330
NeedOrientation
1321
1321
NeedTesting
1315
1315
NeedTranscripts
1324
1324
NoAdmissionBarriers
1336
1336
NotEnrolled
1339
1339
OtherRegistrationHold
1333
1333
ResidencyHold
1327
1327
StudentId
1297
1297
StudentObjectiveAK
1309
1309
ApplicationAK
1293
1293
ApplicationDate
1311
1311
ApplicationSource
1302
1302
ApplicationTerm
1299
1299
EnrolledAfterApplicationTerm
1341
1341
EnrolledInApplicationTerm
1344
1344
NeedAdvising
1317
1317
NeedEducationalPlan
1329
1329
NeedOrientation
1320
1320
NeedTesting
1314
1314
NeedTranscripts
1323
1323
NoAdmissionBarriers
1335
1335
NotEnrolled
1338
1338
OtherRegistrationHold
1332
1332
ResidencyHold
1326
1326
StudentId
1296
1296
StudentObjectiveAK
1308
1308
Powered by BI Documenter