C11/System/ARI/SQL/schema/GC_ETL_ARI/views/xtract.Employee.sql

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Employee] AS
SELECT [timestamp]
     , [No_]
     , [First Name]
--      , [Middle Name]
     , [Last Name]
--      , [Initials]
--      , [Job Title]
--      , [Search Name]
--      , [Address]
--      , [Address 2]
--      , [City]
--      , [Post Code]
--      , [County]
--      , [Phone No_]
--      , [Home Mobile Phone No_]
--      , [E-Mail]
--      , [Alt_ Address Code]
--      , [Alt_ Address Start Date]
--      , [Alt_ Address End Date]
--      , [Picture]
--      , [Birth Date]
--      , [Social Security No_]
--      , [Union Code]
     , [Union Membership No_]
--      , [Sex]
--      , [Country Code]
--      , [Manager No_]
--      , [Employmt_ Contract Code]
--      , [Statistics Group Code]
     , [Employment Date]
--      , [Status]
--      , [Inactive Date]
--      , [Cause of Inactivity Code]
--      , [Termination Date]
--      , [Grounds for Term_ Code]
--      , [Global Dimension 1 Code]
--      , [Global Dimension 2 Code]
--      , [Resource No_]
--      , [Last Date Modified]
--      , [Direct Phone No_]
--      , [Pager]
--      , [Fax No_]
--      , [Company E-Mail]
--      , [Title]
--      , [Salespers__Purch_ Code]
--      , [No_ Series]
--      , [Employee Posting Group]
--      , [Bank Branch No_]
--      , [Bank Account No_]
--      , [IBAN]
--      , [SWIFT Code]
--      , [Application Method]
--      , [Address No_]
--      , [Date of Update]
--      , [Time of Update]
--      , [Updated by User ID]
--      , [Update Company]
     , [Name]
--      , [Name 2]
     , [Home Page 2]
--      , [Address Salutation Code]
--      , [Letter Salutation Code]
--      , [Title Code]
--      , [Action triggered by Card Page]
--      , [Service Advisor]
     , [Function Code]
--      , [Cash Reg_ Access Permitted]
--      , [Time Clock Password]
--      , [Place of Birth]
--      , [Work Completed Allowed]
--      , [Time Approval Password]
--      , [TCE Correction Allowed for]
--      , [Approval Allowed for]
--      , [Allow Time Split Afterwards]
     , [Default Task Type]
--      , [Allow End Clocking Afterwards]
--      , [Rounding Template Code]
--      , [Rounding Begin Day]
--      , [Rounding End Day]
--      , [Rounding Begin Break]
--      , [Rounding End Break]
--      , [Rounding Duration Break]
--      , [Codeunit No_ Rounding Calc_]
--      , [Mobile Phone No_]
--      , [Allow Manual Registration]
--      , [Cost]
     , [Task Type Group]
--      , [Tolerance Begin Day (Minutes)]
--      , [Tolerance End Day (Minutes)]
--      , [Tolerance Begin Break (Min_)]
--      , [Tolerance End Break (Minutes)]
--      , [Tolerance During Break (Min_)]
--      , [Home Page]
--      , [Home Phone No_]
--      , [Home Fax No_]
--      , [Home E-Mail]
--      , [Deactivate Clocking Diagnostic]
--      , [Time Clock Password GUID]
--      , [Time Approval Password GUID]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Employee]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO