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

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO
CREATE   VIEW [xtract].[Employee_T] AS
SELECT [timestamp]
     , [No_]
--      , [ID No_]
--      , [Search Item]
--      , [Name]
     , [Last Name]
     , [First Name]
--      , [Street]
--      , [Post Code]
--      , [City]
--      , [Company Phone No_]
--      , [Private Phone No_]
--      , [Fax]
--      , [E-Mail]
--      , [Homepage]
--      , [Sex]
--      , [No_ Series]
--      , [Employee No_ - Payroll]
--      , [Target Company - Payroll]
--      , [Destination Journal - Payroll]
--      , [IE_Def_ Task Type TP]
--      , [Destination Company - Sync_]
--      , [Employee No_ - Resource]
--      , [Rented Empl_ (Duty Scheduling)]
--      , [Vaca_Car_Fwd_Prev_Y_ Inactive]
--      , [Soft-Term_ Coming Inactive]
--      , [Soft-Term_ Leaving Inactive]
--      , [Soft-Term_ Errand Inactive]
--      , [Soft-Term_ Break Inactive]
--      , [Soft-Term_ Dept_ Inactive]
--      , [Date of Birth]
--      , [Employment Date]
     , [Leaving Date]
--      , [Begin of Plan Continuation]
--      , [Begin Special Day Continuation]
--      , [Fixed-term Contract until]
--      , [Medical Checkup]
--      , [Begin Time of Probation]
--      , [End Time of Probation]
--      , [Begin Work Permit]
--      , [End Work Permit]
--      , [Begin Integration]
--      , [End Integration]
--      , [Begin altern_ Vac_ Year]
--      , [End altern_ Vac_ Year]
--      , [Working Days _ Week]
--      , [Contract No_ - Payroll]
--      , [Employee No_ - Resource EUID]
--      , [MS-Project Import Inactive]
--      , [Vacation in Hours]
     , [Department No_]
--      , [Division No_]
--      , [Activity No_]
--      , [Company No_]
--      , [Pay Group No_]
--      , [State No_]
--      , [Group No_ 1]
--      , [Group No_ 2]
--      , [Group No_ 3]
--      , [Time Object No_]
--      , [Key Reference No_]
--      , [Sorting Planning Programs]
--      , [Day Object on Pub_ Holidays]
--      , [Employee User ID]
--      , [Bar Code Coming Clocking]
--      , [Bar Code Leaving Clocking]
--      , [Destination Journal - FDC]
--      , [Company Reference]
--      , [FDC Permissions]
--      , [Dynamic Agreed Vacation]
--      , [Std_ Vac_ Entitlem_ Days]
--      , [Handic_ Vac_ Entitlem_ Days]
--      , [Vacation Payed Days]
--      , [Spec_ Vac_3 Entitlem_ Days]
--      , [Std_Vac_Days Car_Fwd_Prev_Y_]
--      , [Handic_ Vac_1 Days Car_ Fwd_]
--      , [Vacation Expired Days]
--      , [Vacation Add_ Limited Days]
--      , [Rem_ Vac_ Days taken]
--      , [Rem_ Vac_ Days planned]
--      , [Standard Vac_ Entitlement Hrs_]
--      , [Handic_ Vac_1 Entitlement Hrs_]
--      , [Special Vac_2 Entitlement (H)]
--      , [Std_ Vac_Car_Fwd_Prev_Y_(H)]
--      , [Handic_ Vac_1 Hours Car_ Fwd_]
--      , [Spec_ Vac_2 Hours Car_ Fwd_]
--      , [Rem_ Vac_ Hours taken]
--      , [Rem_ Vac_ Hrs_ Planned]
--      , [Plan Cont_ manual Active]
--      , [Rem_ Handic_ Vac_ Days taken]
--      , [Rem_ Handic_ Vac_ Days planned]
--      , [Options Auto_ Day Finished]
--      , [Coming Clocking Day Finished]
--      , [Leaving Clocking Day Finished]
--      , [Order Continuation Inactive]
--      , [Soft-Term_ Make Vac_ Inactive]
--      , [Soft-Term_ Passw_ Inactive]
--      , [Soft-Term_ Order Inactive]
--      , [Payroll Integration Inactive]
--      , [Absent Integration Inactive]
--      , [End of Last Plan Continuation]
--      , [End of last Special Day Cont_]
--      , [Date of Last Change]
--      , [Time of Last Change]
--      , [User No_ of Last Change]
--      , [Date of Last Processing]
--      , [Duty Scheduling Inactive]
--      , [Synchronization Inactive]
--      , [Access Data Active]
--      , [All Modules Inactive]
--      , [Employee Planning Inactive]
--      , [Terminal Acquisition Inactive]
--      , [Time Processing Inactive]
--      , [Values Car_ Fwd_ Inactive]
--      , [Payroll_Absent Int_ Inactive]
--      , [Reports Inactive]
--      , [Autom_ Plan Cont_ Inactive]
--      , [Integration FDC Inactive]
--      , [Integr_ FDC unprod_ Inactive]
--      , [Soft Terminal Password]
--      , [Monday Absent Days Hours]
--      , [Tuesday Absent Days Hours]
--      , [Wednesday Absent Days Hours]
--      , [Thursday Absent Days Hours]
--      , [Friday Absent Days Hours]
--      , [Saturday Absent Days Hours]
--      , [Sunday Absent Days Hours]
--      , [Monday Absent Days Minutes]
--      , [Tuesday Absent Days Minutes]
--      , [Wednesday Absent Days Minutes]
--      , [Thursday Absent Days Minutes]
--      , [Friday Absent Days Minutes]
--      , [Saturday Absent Days Minutes]
--      , [Sunday Absent Days Minutes]
--      , [VIP (Management-Info_Cockpit)]
--      , [Month of Birth]
--      , [Day of Birth]
--      , [Counter]
--      , [Hide]
--      , [DS_Sort Shift Classification]
--      , [From Date Plan Cont_ rolling]
--      , [PrivateMobilePhoneNo]
--      , [c_o]
--      , [Profession]
--      , [Machine]
--      , [Coming Reference Day Finished]
--      , [Leaving Reference Day Finished]
--      , [Order Duty Scheduling]
--      , [ID No_ Numeric]
--      , [Vacation_Weeks]
--      , [ID No_ before modifying]
--      , [Handic_Car_Fwd_Prev_Y_ Active]
--      , [Coming - Order Begin]
--      , [Com-Order_Num_Days before]
--      , [Soft-Term_ Empl-File Inactive]
--      , [Filesend Limit Total Inactive]
--      , [Soft-Term_ Empl-Info Inactive]
--      , [ST Make Corr_ Inactive]
--      , [ST Appr_ TC Inactive]
--      , [ST Absence Inactive]
--      , [ST FDC-Order Inactive]
--      , [ST FDC-Order Begin Inactive]
--      , [ST FDC-Order End Inactive]
--      , [ST FDC-Task List Inactive]
--      , [ST FDC-Quantity Inactive]
--      , [ST FDC-Finished Inactive]
--      , [Soft-Term_ Appr_ Vac_ Inactive]
--      , [ST FDC-Collect Beg_ Inactive]
--      , [ST FDC-Collect End Inactive]
--      , [Dept_ Integration Own Dept_]
--      , [Unique-ID Badge]
--      , [Summary of payroll data Active]
--      , [Contract Percent]
--      , [Max_ Vacation Add_ Night Work]
--      , [ST Dept_ Filter Org-Group]
--      , [FDC Split_Division Parallel]
--      , [Superior]
--      , [From Line Plan Cont_ rolling]
--      , [Alternative ID No_]
--      , [From Week Plan Cont_ rolling]
--      , [Stand-In]
--      , [Licence-Check]
--      , [Present]
--      , [Absent]
--      , [Balances Total Terminal]
--      , [Check Maternity Protection Law]
--      , [Org-Form_Duty Sched_]
--      , [Org-Value_Duty Sched_]
--      , [Access Group No_]
--      , [Picture]
--      , [ShortSign]
--      , [Initials]
--      , [County]
--      , [CountryRegionCode]
--      , [LanguageCode]
--      , [NationalityCode]
--      , [CompanyPhoneNoExtension]
--      , [CompanyMobilePhoneNo]
--      , [OfficeRoom]
--      , [CountryOfBirthCode]
--      , [PlaceOfBirth]
--      , [NameOfBirth]
--      , [StreetAlternative]
--      , [PostCodeAlternative]
--      , [CityAlternative]
--      , [SocialSecurityNumber]
--      , [BeginRetirementExpected]
--      , [Age]
--      , [Seniority]
--      , [SeniorityDate]
--      , [CommitteeElectionAccepted]
--      , [ProcessResponsibleEmplNo]
--      , [ResidencePermit]
--      , [BeginResidencePermit]
--      , [EndResidencePermit]
--      , [ResidencePermitExposed]
--      , [WorkPermit]
--      , [WorkPermitExposed]
--      , [ResourceActivateStatusBlocked]
--      , [ContactPersEmergeEmplNo1]
--      , [ContactPersEmergeEmplNo2]
--      , [RelationshipType]
--      , [DenominationNo]
--      , [DenominationLineNo]
--      , [PrivateEMail]
--      , [PrivateHomepage]
--      , [FamilyStatus]
--      , [NumberOfChildren]
--      , [PayScaleAgreement]
--      , [SalaryGroup]
--      , [CareerGroup]
--      , [NumberOfContracts]
--      , [EmploymentStatus]
--      , [Executive]
--      , [FunctionalSupervisor]
--      , [EmployeeResponsible]
--      , [PersonalSignatureInactive]
--      , [CurrentReasonLeaveNo]
--      , [CurrentReasonLeaveLineNo]
--      , [DimensionCodeAccess1]
--      , [DimensionValueAccess1]
--      , [DimensionCodeAccess2]
--      , [DimensionValueAccess2]
--      , [DimensionCodeAccess3]
--      , [DimensionValueAccess3]
--      , [DimensionCodeAccess4]
--      , [DimensionValueAccess4]
--      , [ReadyForRelocation]
--      , [FavoredLocation]
--      , [RiscOfLoss]
--      , [ConsequencesOfLoss]
--      , [HoursPerWeek]
--      , [TeamSize]
--      , [NumberOfSubordinatesDisci]
--      , [NumberOfSubordinatesFunc]
--      , [ProcessingStatus]
--      , [Signature]
--      , [VendorReferenceNo]
--      , [ContactReferenceNo]
--      , [Salespers__Purch_ Code]
--      , [Base Unit of Measure]
--      , [Gen_ Prod_ Posting Group]
--      , [SyncResourceModule]
--      , [PerformanceAssessmentsActive]
--      , [RecordDateInsert]
--      , [RecordTimeInsert]
--      , [RecordUserNoInsert]
     , [Client_DB]
FROM [GC_TRANSIT_ARI].[import].[Employee_T]
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

GO