ETL_DWH_ARI/schema/GC_ETL_ARI/views/xtract.Time_Account_T.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Time_Account_T] AS
SELECT [timestamp]
     , [No_]
     , [Description]
--      , [Description 2]
--      , [Symbol]
--      , [Character]
--      , [Pay Type 1]
--      , [Pay Type 2]
--      , [Pay Type_Absent Day]
--      , [Pay Integration Zero Values]
--      , [Formatting]
--      , [Class (General)]
--      , [Class (Statistics)]
--      , [Class (Absent Days)]
--      , [Class (Account Default)]
--      , [Class (Time Processing)]
--      , [Class (Individual)]
--      , [Class (Employee Info)]
--      , [Class (Vacation Reduction)]
--      , [Class (Matrix Layout)]
--      , [TA No_ Value Car_ Fwd_]
--      , [TA No_ Added Value]
--      , [Time Acc_ No_ - Absent Day_H]
--      , [Accounts Heading]
--      , [Time Account No_ - Copy 1]
--      , [TA No_ Reference Sum-Values]
--      , [Time Account No_ - Copy 2]
--      , [Sum-Values]
--      , [TA Gr_ No_ Pub_ Holiday Filter]
--      , [Pay Type_Absent Day half Day]
--      , [Target Time_Pub_ Holiday ina_]
--      , [Overwrite Planning (Prio_1)]
--      , [Do not Overwrite Planning]
--      , [Check 42-Day Period]
--      , [Sorting (Matrix Layout)]
--      , [TP_Half miss_Day not processed]
--      , [Pay Type_Check miss_Day in Pay]
--      , [Terminal-Access Inactive]
--      , [Add Agreed Vacation Entitle_]
--      , [Access Time per Terminal No_]
--      , [Absent Day - Monday]
--      , [Absent Day - Tuesday]
--      , [Absent Day - Wednesday]
--      , [Absent Day - Thursday]
--      , [Absent Day - Friday]
--      , [Absent Day - Saturday]
--      , [Absent Day - Sunday]
--      , [Absent Day at Target Time]
--      , [Pay Type Individual]
--      , [Break Time per Terminal No_]
--      , [Processing - Monday]
--      , [Processing - Tuesday]
--      , [Processing - Wednesday]
--      , [Processing - Thursday]
--      , [Processing - Friday]
--      , [Processing - Saturday]
--      , [Processing - Sunday]
--      , [Processing on Target Time]
--      , [Special Day - Monday]
--      , [Special Day - Tuesday]
--      , [Special Day - Wednesday]
--      , [Special Day - Thursday]
--      , [Special Day - Friday]
--      , [Special Day - Saturday]
--      , [Special Day - Sunday]
--      , [Presence max_ Interrupt (Min)]
--      , [Extended Account Defaults]
--      , [TA No_ Absenc__Empl__Target]
--      , [Sorting Statistics 1-9999]
--      , [Ref_ E-Field Day Targ_AbsDay_H]
--      , [TA No_ Dest_AT Appl_ Cancel]
--      , [TA No_ Ref_from Special Day]
--      , [DS_Day Object at Absent Day]
--      , [TA No_ Ref_until Special Day]
--      , [TA No_ Dest_Absent Time Appl_]
--      , [Time Card Column Type 2]
--      , [Time Card Column Landsc_Format]
--      , [Time Card Column Type 1]
--      , [Shift Scheduling Category]
--      , [Shift Scheduling Miss_Day Post]
--      , [Sorting Footer 1-9999 right]
--      , [Time Manager: insert allowed]
--      , [Color Employee Planning]
--      , [Color Value Employee Planning]
--      , [Shift Scheduling Absent D_ Hrs]
--      , [Sorting Total 1-9999 left]
--      , [Import-Code Absent Day]
--      , [Deviation Monday 1]
--      , [Deviation Tuesday 1]
--      , [Deviation Wednesday 1]
--      , [Deviation Thursday 1]
--      , [Deviation Friday 1]
--      , [Deviation Saturday 1]
--      , [Deviation Sunday 1]
--      , [Deviation Threshold Minutes 1]
--      , [Color Duty Scheduling]
--      , [Color Value Duty Scheduling]
--      , [Deviation Monday 2]
--      , [Deviation Tuesday 2]
--      , [Deviation Wednesday 2]
--      , [Deviation Thursday 2]
--      , [Deviation Friday 2]
--      , [Deviation Saturday 2]
--      , [Deviation Sunday 2]
--      , [Deviation Threshold Minutes 2]
--      , [FDC-Int_ _ Cancel inactive]
--      , [Pay Int_ _ Posting Type]
--      , [ineffective for TA No_ 1]
--      , [Pre-Pub_ Holiday no Output EP]
--      , [ineffective for TA No_ 2]
--      , [TA No_ Present Range]
--      , [ineffective for TA No_ 3]
--      , [Pay Int_ _ Cancel Absent Day]
--      , [ineffective for TA No_ 4]
--      , [TA No_ Ref_perc_ Order-Split_]
--      , [ineffective for TA No_ 5]
--      , [Pay Int_ _ without Until-Date]
--      , [ineffective for TA No_ 6]
--      , [TA No_ Dest_perc_ Splitting]
--      , [ineffective for TA No_ 7]
--      , [TA No_ Ref_perc_ Splitting]
--      , [ineffective for TA No_ 8]
--      , [FDC-Int_ _ Dest_ Department]
--      , [ineffective for TA No_ 9]
--      , [ineffective for Class (Stat_)3]
--      , [ineffective for TA No_ 10]
--      , [ineffective for Class (Stat_)2]
--      , [ineffective for Class (Stat_)1]
--      , [ineff_TAGrp_Absenc__Empl__Hrs_]
--      , [Pay Int_ _ Sum Dept_ Splitting]
--      , [ineff_ TAGrp_F_DOUBLE]
--      , [FDC Posting Sum_Day]
--      , [ineff_ TAGrp_Abs__Empl__D_Hrs_]
--      , [Pay Sum Inactive]
--      , [FDC Sum Inactive]
--      , [Pay Int_ _ Dept_ Splitting]
--      , [FDC Int_ _ Target Task]
--      , [FDC Integration Active]
--      , [FDC-Overh_ CC Inactive if Mov_]
--      , [TA No_ Ref_ Hrs_->Record]
--      , [Part-time Business College]
--      , [For Pub_Holidays Break+Round_]
--      , [TP_Absent Time in Core Time]
--      , [TA No_ Ref_ Record>Hrs_]
--      , [Department Splitting]
--      , [FDC Splitting]
--      , [Exclusive Processing Serial]
--      , [FDC_Dept_ Progwork protected]
--      , [Datev_AK]
--      , [Datev_AK without Pay Type]
--      , [Absent Day creates Presence]
--      , [Integration Resources]
--      , [MaxValue AbsDay_Year Warning]
--      , [MaxValue AbsDay_Year Rejection]
--      , [Import-Code IE Time Planning]
--      , [Import-Code IE Time Entry]
--      , [Value]
--      , [Protected]
--      , [External Access permitted]
--      , [Import-Code IE Activity]
--      , [Import-Code IE TP half Day]
--      , [Loss of Pay Principle Miss_Day]
--      , [Protect_ Loss of Pay Principle]
--      , [Message rem_ Vac_ Check]
--      , [Absent Day Evaluation 0_5]
--      , [Pay Int_ _ FDC Splitting]
--      , [Provision Payroll Int_Journal]
--      , [Paying out Payroll Int_Journal]
--      , [No Vac_ Entitlem_ Aliquot_]
--      , [Ref_ Empl-Field Abs_Empl_Targ_]
--      , [Aliquotation Source]
--      , [Enter Period Date Payroll + 1]
--      , [For Plannig Stuff only]
--      , [Info Clocking Entry]
--      , [Type Info Clocking]
--      , [Gen_TA No_ Value Info Clocking]
--      , [TP_Remark Info-Clocking]
--      , [FDC-Reference Scrap Code]
--      , [FDC_Dept_ Time Acc_ inactive]
--      , [Pay Type_FDC]
--      , [Pay-Int_ _ Cancel inactive]
--      , [FDC-Cancel TA-No_ 1_Day Next P]
--      , [Empl-Data Send Limit Total]
--      , [Calculation Factor_FDC]
--      , [Time Grid No_ AbsTime Transfer]
--      , [Vacation Add_ Night Work]
--      , [TA-No_ Dest_ smaller Split-Val]
--      , [TA-No_ Dest_ greater Split-Val]
--      , [Info-Clocking Split-Value Min_]
--      , [Split-Value based on Target T_]
--      , [Dyn_ Over-Grid ineffect_ Info]
--      , [Coming to 1_Dept_->Time Acc_]
--      , [Department->Time Account]
--      , [Order->Time Account]
--      , [Task->Time Account]
--      , [Dimension1->Time Account]
--      , [Dimension2->Time Account]
--      , [Dimension3->Time Account]
--      , [Dimension4->Time Account]
--      , [Job No_->Time Account]
--      , [Work Package->Time Account]
--      , [Dest_ Dept_ PayInt__DeptSplit_]
--      , [Org-Group Order No_ Unprod]
--      , [Org-Group Task No_ Unprod]
--      , [Org-Group Dimension 1 Unprod]
--      , [Org-Group Dimension 2 Unprod]
--      , [Org-Group Dimension 3 Unprod]
--      , [Org-Group Dimension 4 Unprod]
--      , [Org-Group Job No_->TA]
--      , [Org-Group Work Package->TA]
--      , [Round Constant DeptSplit_]
--      , [Difference-Values FDC-Parallel]
--      , [TP_Status Info Clocking]
--      , [Exclusive Processing Parallel]
--      , [Exclusive Processing Collect]
--      , [TP_Evaluation active]
--      , [Absent Day - Insert Comment]
--      , [Algo-Nr_ Report Percent Source]
--      , [TA No_ Report Percent Dest_]
--      , [Time Account No_ - Copy 3]
--      , [Time Account No_ - Copy 4]
--      , [Time Account No_ - Copy 5]
--      , [Time Account No_ - Copy 6]
--      , [Ref_ TA-No_ Abs_Day Plan Cont_]
--      , [Ref_ TA-No_ Business Trip End]
--      , [Pay Int_ _ Sum Other-Dept_]
--      , [Pay Int_ _ Only Other-Dept_]
--      , [Sort IE Absent Times]
--      , [Sort IE Timeacc__ML]
--      , [Transfer Capacities Inactive]
--      , [DS_Balance_Plan_Target Month]
--      , [Absent Day anonymous Active]
--      , [TP_ProgSave Inactive]
--      , [EP_Alternative Balance Output]
--      , [TP_Balances +_- Back Calc_]
--      , [Time Manager: delete allowed]
--      , [Pub_ Holiday w_o Processing]
--      , [Absent Day-Int_ ext_ inactive]
--      , [Journal - Copy 1_Day]
--      , [Absent Day <as worked>]
--      , [AT-Workflow Cancel]
--      , [Lookup-Release for Journal]
--      , [TP_Complete Inactive]
--      , [Algo-No_ Report Sum]
--      , [Ref_ Employee Table]
--      , [Info EMail Approved Appl_ 1]
--      , [Info EMail Approved Appl_ 2]
--      , [AT-Wf Create Remark mandatory]
--      , [AT-Wf Approve Remark mandatory]
--      , [AT-Wf Reject Remark mandatory]
--      , [Time Account Workflow active]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Time_Account_T]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO