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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Resource] AS
SELECT [timestamp]
     , [No_]
--      , [Type]
--      , [Name]
--      , [Search Name]
--      , [Name 2]
--      , [Address]
--      , [Address 2]
--      , [City]
--      , [Social Security No_]
--      , [Title]
--      , [Education]
--      , [Contract Class]
--      , [Employment Date]
--      , [Resource Group No_]
--      , [Global Dimension 1 Code]
--      , [Global Dimension 2 Code]
--      , [Unit of Measure Code]
--      , [Direct Unit Cost]
--      , [Indirect Cost _]
--      , [Unit Cost]
--      , [Profit _]
--      , [Price_Profit Calculation]
--      , [Unit Price]
--      , [Vendor No_]
--      , [Last Date Modified]
--      , [Blocked]
--      , [Gen_ Prod_ Posting Group]
--      , [Picture]
--      , [Post Code]
--      , [County]
--      , [Automatic Ext_ Texts]
--      , [No_ Series]
--      , [Tax Group Code]
--      , [VAT Prod_ Posting Group]
--      , [Country_Region Code]
--      , [IC Partner Purch_ G_L Acc_ No_]
--      , [Address No_]
--      , [Date of Update]
--      , [Time of Update]
--      , [Updated by User ID]
--      , [Update Company]
--      , [Last Name]
--      , [First Name]
--      , [Title Code]
--      , [Resource Cost Group Code]
     , convert(float, [Efficiency _]) AS [Efficiency]
--      , [Service Advisor No_]
--      , [Employee No_]
--      , [Location Code]
--      , [Price per Day]
--      , [Distance Incl_]
--      , [Price per Distance]
--      , [Amt_ Insurance]
--      , [Amt_ Retention]
--      , [Amt_ Comprehensive Insurance]
--      , [Company Calendar Code]
--      , [Absences In]
--      , [Avg_ Hours per Day]
--      , [Administrative]
--      , [Main Company]
--      , [Available from]
--      , [Available to]
--      , [VIN]
--      , [Pers_ Calendar Templ_ Code]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Resource]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO