OLE_SRC Get DimTimeType

Property	Value
Name	OLE_SRC Get DimTimeType
Description	OLE DB Source
Up Stream Components	none
Down Stream Components	TF_SCD DimTimeType
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 DimTimeType" (3782)
Is Default Locale	True
Pipeline Version	0
Uses Dispositions	True
Validate External Metadata	True
Version	7

Name	Connection Manager	Description
OleDbConnection	EnterpriseDW

Name	Value
AccessMode	2
AlwaysUseDefaultCodePage	False
CommandTimeout	0
DefaultCodePage	1252
OpenRowset
OpenRowsetVariable
ParameterMapping
SqlCommand	SELECT TimeTypeSK ,TimeTypeAK ,TimeTypeCode ,TimeType ,RegularTime ,PaidTime ,OvertimeTime ,LeaveTime ,LongTermTime ,AccruedTime ,EarnedTime ,SickPoolTime ,TimeAttendReportingOptionCode ,TimeAttendReportingOption ,RowIsCurrent ,RowStartDate ,RowEndDate FROM DimTimeType WHERE RowIsCurrent = 'Y' ORDER BY TimeTypeAK
SqlCommandVariable

Name

ID

LineageID

Name	ID	LineageID
AccruedTime	9993	9993
EarnedTime	9996	9996
ErrorCode	3794	3794
ErrorColumn	3795	3795
LeaveTime	9987	9987
LongTermTime	9990	9990
OvertimeTime	9984	9984
PaidTime	9981	9981
RegularTime	9978	9978
RowEndDate	8048	8048
RowIsCurrent	8042	8042
RowStartDate	8045	8045
SickPoolTime	9999	9999
TimeAttendReportingOption	10005	10005
TimeAttendReportingOptionCode	10002	10002
TimeType	9975	9975
TimeTypeAK	9969	9969
TimeTypeCode	9972	9972
TimeTypeSK	9966	9966
AccruedTime	9992	9992
EarnedTime	9995	9995
LeaveTime	9986	9986
LongTermTime	9989	9989
OvertimeTime	9983	9983
PaidTime	9980	9980
RegularTime	9977	9977
RowEndDate	8047	8047
RowIsCurrent	8041	8041
RowStartDate	8044	8044
SickPoolTime	9998	9998
TimeAttendReportingOption	10004	10004
TimeAttendReportingOptionCode	10001	10001
TimeType	9974	9974
TimeTypeAK	9968	9968
TimeTypeCode	9971	9971
TimeTypeSK	9965	9965