|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Temp Tables from Staging for Curriculum |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 3553 |
| 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 Temp Tables from Staging for Curriculum" (3553) |
| 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 |
2 |
AlwaysUseDefaultCodePage |
False |
CommandTimeout |
0 |
DefaultCodePage |
1252 |
OpenRowset |
|
OpenRowsetVariable |
|
ParameterMapping |
|
SqlCommand |
SELECT VerifyCurriculumSK , ReferenceNumberAK , ReferenceNumber , Term , TermTitle , CourseId , CurrentTerm , CurrentCourseId , CourseIdPrefix , ClassTitle , CourseTypeCode , CourseType , CreditNonCreditVocational , CreditTypeCode , CreditType , CreditNonCredit , ICSCode , InstructionalClassification , DivisionCode , Division , DepartmentCode , Department , CampusCode , Campus , CenterCode , Center , MinimumClassSize , MaximumClassSize , ClassStatusCode , ClassStatus , TimeBlockCode , TimeBlock , DeliveryMethod , PrimaryInstructorId , PrimaryInstructorFullName , PrimaryInstructorLastName , PrimaryInstructorFirstName , PrimaryInstructorMiddleInitial , SessionCode , [Session] , Honors , WeekendCollege , DualEnrollment , IndependentStudy , Apprenticeship , VirtualCollege , Online100Percent , WebEnabled , WebBlended , ScheduleInformation , PrimaryInstructorType , ICSCategoryCode , InstructionalClassificationCategory , TermCourseIdCount , IsTermCourseIdCountGE10 , IsCourseRepeatable , CourseNumberTimesForCredit ,CourseLevel ,CreditNonCreditVocationalTest ,DivisionDescription ,DepartmentDescription FROM dbo.Verify_dbo_DimCurriculum WHERE RowIsSelected = 'Y' ORDER BY ReferenceNumberAK |
SqlCommandVariable |
User::GetCurriculumMods |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
Apprenticeship |
5282 |
5282 |
Campus |
5219 |
5219 |
CampusCode |
5216 |
5216 |
Center |
5225 |
5225 |
CenterCode |
5222 |
5222 |
ClassStatus |
5237 |
5237 |
ClassStatusCode |
5234 |
5234 |
ClassTitle |
5177 |
5177 |
CourseId |
5165 |
5165 |
CourseIdPrefix |
5174 |
5174 |
CourseLevel |
6147 |
6147 |
CourseNumberTimesForCredit |
5825 |
5825 |
CourseType |
5183 |
5183 |
CourseTypeCode |
5180 |
5180 |
CreditNonCredit |
5195 |
5195 |
CreditNonCreditVocational |
5186 |
5186 |
CreditNonCreditVocationalTest |
6292 |
6292 |
CreditType |
5192 |
5192 |
CreditTypeCode |
5189 |
5189 |
CurrentCourseId |
5171 |
5171 |
CurrentTerm |
5168 |
5168 |
DeliveryMethod |
5246 |
5246 |
Department |
5213 |
5213 |
DepartmentCode |
5210 |
5210 |
DepartmentDescription |
6363 |
6363 |
Division |
5207 |
5207 |
DivisionCode |
5204 |
5204 |
DivisionDescription |
6360 |
6360 |
DualEnrollment |
5276 |
5276 |
ErrorCode |
3565 |
3565 |
ErrorColumn |
3566 |
3566 |
Honors |
5270 |
5270 |
ICSCategoryCode |
5810 |
5810 |
ICSCode |
5198 |
5198 |
IndependentStudy |
5279 |
5279 |
InstructionalClassification |
5201 |
5201 |
InstructionalClassificationCategory |
5813 |
5813 |
IsCourseRepeatable |
6006 |
6006 |
IsTermCourseIdCountGE10 |
6003 |
6003 |
MaximumClassSize |
5231 |
5231 |
MinimumClassSize |
5228 |
5228 |
Online100Percent |
5288 |
5288 |
PrimaryInstructorFirstName |
5258 |
5258 |
PrimaryInstructorFullName |
5252 |
5252 |
PrimaryInstructorId |
5249 |
5249 |
PrimaryInstructorLastName |
5445 |
5445 |
PrimaryInstructorMiddleInitial |
5261 |
5261 |
PrimaryInstructorType |
5807 |
5807 |
ReferenceNumber |
5156 |
5156 |
ReferenceNumberAK |
5153 |
5153 |
ScheduleInformation |
5297 |
5297 |
Session |
5267 |
5267 |
SessionCode |
5264 |
5264 |
Term |
5159 |
5159 |
TermCourseIdCount |
5816 |
5816 |
TermTitle |
5162 |
5162 |
TimeBlock |
5243 |
5243 |
TimeBlockCode |
5240 |
5240 |
VerifyCurriculumSK |
5150 |
5150 |
VirtualCollege |
5285 |
5285 |
WebBlended |
5294 |
5294 |
WebEnabled |
5291 |
5291 |
WeekendCollege |
5273 |
5273 |
Apprenticeship |
5281 |
5281 |
Campus |
5218 |
5218 |
CampusCode |
5215 |
5215 |
Center |
5224 |
5224 |
CenterCode |
5221 |
5221 |
ClassStatus |
5236 |
5236 |
ClassStatusCode |
5233 |
5233 |
ClassTitle |
5176 |
5176 |
CourseId |
5164 |
5164 |
CourseIdPrefix |
5173 |
5173 |
CourseLevel |
6146 |
6146 |
CourseNumberTimesForCredit |
5824 |
5824 |
CourseType |
5182 |
5182 |
CourseTypeCode |
5179 |
5179 |
CreditNonCredit |
5194 |
5194 |
CreditNonCreditVocational |
5185 |
5185 |
CreditNonCreditVocationalTest |
6291 |
6291 |
CreditType |
5191 |
5191 |
CreditTypeCode |
5188 |
5188 |
CurrentCourseId |
5170 |
5170 |
CurrentTerm |
5167 |
5167 |
DeliveryMethod |
5245 |
5245 |
Department |
5212 |
5212 |
DepartmentCode |
5209 |
5209 |
DepartmentDescription |
6362 |
6362 |
Division |
5206 |
5206 |
DivisionCode |
5203 |
5203 |
DivisionDescription |
6359 |
6359 |
DualEnrollment |
5275 |
5275 |
Honors |
5269 |
5269 |
ICSCategoryCode |
5809 |
5809 |
ICSCode |
5197 |
5197 |
IndependentStudy |
5278 |
5278 |
InstructionalClassification |
5200 |
5200 |
InstructionalClassificationCategory |
5812 |
5812 |
IsCourseRepeatable |
6005 |
6005 |
IsTermCourseIdCountGE10 |
6002 |
6002 |
MaximumClassSize |
5230 |
5230 |
MinimumClassSize |
5227 |
5227 |
Online100Percent |
5287 |
5287 |
PrimaryInstructorFirstName |
5257 |
5257 |
PrimaryInstructorFullName |
5251 |
5251 |
PrimaryInstructorId |
5248 |
5248 |
PrimaryInstructorLastName |
5444 |
5444 |
PrimaryInstructorMiddleInitial |
5260 |
5260 |
PrimaryInstructorType |
5806 |
5806 |
ReferenceNumber |
5155 |
5155 |
ReferenceNumberAK |
5152 |
5152 |
ScheduleInformation |
5296 |
5296 |
Session |
5266 |
5266 |
SessionCode |
5263 |
5263 |
Term |
5158 |
5158 |
TermCourseIdCount |
5815 |
5815 |
TermTitle |
5161 |
5161 |
TimeBlock |
5242 |
5242 |
TimeBlockCode |
5239 |
5239 |
VerifyCurriculumSK |
5149 |
5149 |
VirtualCollege |
5284 |
5284 |
WebBlended |
5293 |
5293 |
WebEnabled |
5290 |
5290 |
WeekendCollege |
5272 |
5272 |
| Powered by BI Documenter |
