|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | OLE_SRC Get DimCurriculum |
| Description | OLE DB Source |
| Up Stream Components | none |
| Down Stream Components | |
| ID | 3782 |
| 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 Get DimCurriculum" (3782) |
| 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 [CurriculumSK] AS CurriculumSK ,[ReferenceNumberAK] AS ReferenceNumberAK ,[ReferenceNumber] AS ReferenceNumber ,[Term] AS Term ,[TermTitle] AS TermTitle ,[CourseId] AS CourseId ,[CurrentTerm] AS CurrentTerm ,[CurrentCourseId] AS CurrentCourseId ,[CourseIdPrefix] AS CourseIdPrefix ,[ClassTitle] AS ClassTitle ,[CourseTypeCode] AS CourseTypeCode ,[CourseType] AS CourseType ,[CreditNonCreditVocational] AS CreditNonCreditVocational ,[CreditTypeCode] AS CreditTypeCode ,[CreditType] AS CreditType ,[CreditNonCredit] AS CreditNonCredit ,[ICSCode] AS ICSCode ,[InstructionalClassification] AS InstructionalClassification ,[DivisionCode] AS DivisionCode ,[Division] AS Division ,[DepartmentCode] AS DepartmentCode ,[Department] AS Department ,[CampusCode] AS CampusCode ,[Campus] AS Campus ,[CenterCode] AS CenterCode ,[Center] AS Center ,[MinimumClassSize] AS MinimumClassSize ,[MaximumClassSize] AS MaximumClassSize ,[ClassStatusCode] AS ClassStatusCode ,[ClassStatus] AS ClassStatus ,[TimeBlockCode] AS TimeBlockCode ,[TimeBlock] AS TimeBlock ,[DeliveryMethod] AS DeliveryMethod ,[PrimaryInstructorId] AS PrimaryInstructor ,[PrimaryInstructorFullName] AS PrimaryInstructorFullName ,[PrimaryInstructorLastName] AS PrimaryInstructorLastName ,[PrimaryInstructorFirstName] AS PrimaryInstructorFirstName ,[PrimaryInstructorMiddleInitial] AS PrimaryInstructorInitial ,[SessionCode] AS SessionCode ,[Session] AS Session ,[Honors] AS Honors ,[WeekendCollege] AS WeekendCollege ,[DualEnrollment] AS DualEnrollment ,[IndependentStudy] AS IndependentStudy ,[Apprenticeship] AS Apprenticeship ,[VirtualCollege] AS VirtualCollege ,[Online100Percent] AS Online100Percent ,[WebEnabled] AS WebEnabled ,[WebBlended] AS WebBlended ,[ScheduleInformation] AS ScheduleInformation , [PrimaryInstructorType] AS PrimaryInstructorType , [ICSCategoryCode] AS ICSCategoryCode , [InstructionalClassificationCategory] AS InstructionalClassificationCategory , [TermCourseIdCount] AS TermCourseIdCount , [IsTermCourseIdCountGE10] AS IsTermCourseIdCountGE10 , [IsCourseRepeatable] AS IsCourseRepeatable , [CourseNumberTimesForCredit] AS CourseNumberTimesForCredit ,[RowIsCurrent] AS RowIsCurrent ,[RowStartDate] AS RowStartDate ,[RowEndDate] AS RowEndDate ,CourseLevel ,CreditNonCreditVocationalTest ,DivisionDescription ,DepartmentDescription FROM [dbo].[DimCurriculum] WHERE RowIsCurrent = 'Y' ORDER BY ReferenceNumberAK |
SqlCommandVariable |
Input Columns
| Name | ID | LineageID |
Output Columns
| Name | ID | LineageID |
Apprenticeship |
3931 |
3931 |
Campus |
3868 |
3868 |
CampusCode |
3865 |
3865 |
Center |
3874 |
3874 |
CenterCode |
3871 |
3871 |
ClassStatus |
3886 |
3886 |
ClassStatusCode |
3883 |
3883 |
ClassTitle |
3826 |
3826 |
CourseId |
3814 |
3814 |
CourseIdPrefix |
3823 |
3823 |
CourseLevel |
6199 |
6199 |
CourseNumberTimesForCredit |
5901 |
5901 |
CourseType |
3832 |
3832 |
CourseTypeCode |
3829 |
3829 |
CreditNonCredit |
3844 |
3844 |
CreditNonCreditVocational |
3835 |
3835 |
CreditNonCreditVocationalTest |
6344 |
6344 |
CreditType |
3841 |
3841 |
CreditTypeCode |
3838 |
3838 |
CurrentCourseId |
3820 |
3820 |
CurrentTerm |
3817 |
3817 |
CurriculumSK |
3799 |
3799 |
DeliveryMethod |
3895 |
3895 |
Department |
3862 |
3862 |
DepartmentCode |
3859 |
3859 |
DepartmentDescription |
6425 |
6425 |
Division |
3856 |
3856 |
DivisionCode |
3853 |
3853 |
DivisionDescription |
6422 |
6422 |
DualEnrollment |
3925 |
3925 |
ErrorCode |
3794 |
3794 |
ErrorColumn |
3795 |
3795 |
Honors |
3919 |
3919 |
ICSCategoryCode |
5886 |
5886 |
ICSCode |
3847 |
3847 |
IndependentStudy |
3928 |
3928 |
InstructionalClassification |
3850 |
3850 |
InstructionalClassificationCategory |
5889 |
5889 |
IsCourseRepeatable |
6062 |
6062 |
IsTermCourseIdCountGE10 |
6059 |
6059 |
MaximumClassSize |
3880 |
3880 |
MinimumClassSize |
3877 |
3877 |
Online100Percent |
3937 |
3937 |
PrimaryInstructor |
3898 |
3898 |
PrimaryInstructorFirstName |
3907 |
3907 |
PrimaryInstructorFullName |
3901 |
3901 |
PrimaryInstructorInitial |
3910 |
3910 |
PrimaryInstructorLastName |
3904 |
3904 |
PrimaryInstructorType |
5883 |
5883 |
ReferenceNumber |
3805 |
3805 |
ReferenceNumberAK |
3802 |
3802 |
RowEndDate |
3955 |
3955 |
RowIsCurrent |
3949 |
3949 |
RowStartDate |
3952 |
3952 |
ScheduleInformation |
3946 |
3946 |
Session |
3916 |
3916 |
SessionCode |
3913 |
3913 |
Term |
3808 |
3808 |
TermCourseIdCount |
5892 |
5892 |
TermTitle |
3811 |
3811 |
TimeBlock |
3892 |
3892 |
TimeBlockCode |
3889 |
3889 |
VirtualCollege |
3934 |
3934 |
WebBlended |
3943 |
3943 |
WebEnabled |
3940 |
3940 |
WeekendCollege |
3922 |
3922 |
Apprenticeship |
3930 |
3930 |
Campus |
3867 |
3867 |
CampusCode |
3864 |
3864 |
Center |
3873 |
3873 |
CenterCode |
3870 |
3870 |
ClassStatus |
3885 |
3885 |
ClassStatusCode |
3882 |
3882 |
ClassTitle |
3825 |
3825 |
CourseId |
3813 |
3813 |
CourseIdPrefix |
3822 |
3822 |
CourseLevel |
6198 |
6198 |
CourseNumberTimesForCredit |
5900 |
5900 |
CourseType |
3831 |
3831 |
CourseTypeCode |
3828 |
3828 |
CreditNonCredit |
3843 |
3843 |
CreditNonCreditVocational |
3834 |
3834 |
CreditNonCreditVocationalTest |
6343 |
6343 |
CreditType |
3840 |
3840 |
CreditTypeCode |
3837 |
3837 |
CurrentCourseId |
3819 |
3819 |
CurrentTerm |
3816 |
3816 |
CurriculumSK |
3798 |
3798 |
DeliveryMethod |
3894 |
3894 |
Department |
3861 |
3861 |
DepartmentCode |
3858 |
3858 |
DepartmentDescription |
6424 |
6424 |
Division |
3855 |
3855 |
DivisionCode |
3852 |
3852 |
DivisionDescription |
6421 |
6421 |
DualEnrollment |
3924 |
3924 |
Honors |
3918 |
3918 |
ICSCategoryCode |
5885 |
5885 |
ICSCode |
3846 |
3846 |
IndependentStudy |
3927 |
3927 |
InstructionalClassification |
3849 |
3849 |
InstructionalClassificationCategory |
5888 |
5888 |
IsCourseRepeatable |
6061 |
6061 |
IsTermCourseIdCountGE10 |
6058 |
6058 |
MaximumClassSize |
3879 |
3879 |
MinimumClassSize |
3876 |
3876 |
Online100Percent |
3936 |
3936 |
PrimaryInstructor |
3897 |
3897 |
PrimaryInstructorFirstName |
3906 |
3906 |
PrimaryInstructorFullName |
3900 |
3900 |
PrimaryInstructorInitial |
3909 |
3909 |
PrimaryInstructorLastName |
3903 |
3903 |
PrimaryInstructorType |
5882 |
5882 |
ReferenceNumber |
3804 |
3804 |
ReferenceNumberAK |
3801 |
3801 |
RowEndDate |
3954 |
3954 |
RowIsCurrent |
3948 |
3948 |
RowStartDate |
3951 |
3951 |
ScheduleInformation |
3945 |
3945 |
Session |
3915 |
3915 |
SessionCode |
3912 |
3912 |
Term |
3807 |
3807 |
TermCourseIdCount |
5891 |
5891 |
TermTitle |
3810 |
3810 |
TimeBlock |
3891 |
3891 |
TimeBlockCode |
3888 |
3888 |
VirtualCollege |
3933 |
3933 |
WebBlended |
3942 |
3942 |
WebEnabled |
3939 |
3939 |
WeekendCollege |
3921 |
3921 |
| Powered by BI Documenter |
