DimTimeTypeLoad
 OLE_SRC Verification Temp table from TIME_TYPE_A Staging (Component)
Home  Diagrams  Documents  Images  DimTimeTypeLoad  Executables  Connection Managers  Log Providers  Variables 
Current Path:  DimTimeTypeLoad   DFT Load Temp TimeType Table for Verification   OLE_SRC Verification Temp table from TIME_TYPE_A Staging
  Properties
Property Value
Name OLE_SRC Verification Temp table from TIME_TYPE_A Staging
Description OLE DB Source
Up Stream Components none
Down Stream Components
ID 1
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 Verification Temp table from TIME_TYPE_A Staging" (1)
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 
       TIME_TYPE_CODE AS TimeTypeAK
      ,TIME_TYPE_CODE AS TimeTypeCode
      ,CAST(ISNULL(TimeT.DESCRIPTION , 'N/A') AS VARCHAR(50)) AS TimeType
      ,CAST(
         CASE
           WHEN TIME_TYPE_CODE = 'NORM' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS RegularTime
      ,CAST(
         CASE
           WHEN PAID_TIME_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS PaidTime
      ,CAST(
         CASE
           WHEN OVERTIME_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS OverTime
      ,CAST(
         CASE
           WHEN LEAVE_TYPE_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS LeaveTime   
      ,CAST(
         CASE
           WHEN LONG_TERM_LEAVE_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS LongTermTime  
      ,CAST(
         CASE
           WHEN ACCRUAL_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS AccruedTime                      
      ,CAST(
         CASE
           WHEN ACCUMULATED_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS EarnedTime    
      ,CAST(
         CASE
           WHEN SICK_POOL_IND = '1' THEN 'Yes'
           ELSE 'No'
         END AS VARCHAR(3))
         AS SickPoolTime   
      ,CAST(ISNULL(TAA_ENTRY_OPTION_CODE,'N/A') AS VARCHAR(8)) AS  TimeAttendReportingOptionCode 
      ,CAST(ISNULL(ReportOption.LONG_DESCRIPTION, 'N/A') AS VARCHAR(60)) AS TimeAttendReportingOption        
  FROM TIME_TYPE_A TimeT
  
  LEFT OUTER JOIN UTL_CODE_TABLE ReportOption
  ON
  (
     ReportOption.TABLE_NAME = 'TAA-OPTION'
     AND
     ReportOption.CODE = TimeT.TAA_ENTRY_OPTION_CODE
     AND
     ReportOption.STATUS = 'A'
  )
SqlCommandVariable
User::GetPositionMods
  Input Columns
Name ID LineageID
  Output Columns
Name ID LineageID
AccruedTime
2897
2897
EarnedTime
2900
2900
ErrorCode
13
13
ErrorColumn
14
14
LeaveTime
2891
2891
LongTermTime
2894
2894
OverTime
2888
2888
PaidTime
2885
2885
RegularTime
2882
2882
SickPoolTime
2903
2903
TimeAttendReportingOption
2909
2909
TimeAttendReportingOptionCode
2906
2906
TimeType
2879
2879
TimeTypeAK
2873
2873
TimeTypeCode
2876
2876
AccruedTime
2896
2896
EarnedTime
2899
2899
LeaveTime
2890
2890
LongTermTime
2893
2893
OverTime
2887
2887
PaidTime
2884
2884
RegularTime
2881
2881
SickPoolTime
2902
2902
TimeAttendReportingOption
2908
2908
TimeAttendReportingOptionCode
2905
2905
TimeType
2878
2878
TimeTypeAK
2872
2872
TimeTypeCode
2875
2875
Powered by BI Documenter