dbo.danone_empleados

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	5526
Created	10/28/2019 6:32:13 PM
Last Modified	10/28/2019 6:32:13 PM

Columns

Name	Data Type	Length	Not Null	Computed	Persisted
HirisID	varchar	150	False	False	False
DanoneID	varchar	150	False	False	False
HirisID2	varchar	150	False	False	False
Name	varchar	150	False	False	False
OperationalEntity	varchar	150	False	False	False
ContractCompany	varchar	150	False	False	False
CBU	varchar	150	False	False	False
EmployeeStatus	varchar	150	False	False	False
EventReason	varchar	150	False	False	False
Effectivedate	varchar	150	False	False	False
Event	varchar	150	False	False	False
EmailAddress	varchar	150	False	False	False
ITAccess	varchar	150	False	False	False
Gender	varchar	150	False	False	False
PositionTitle	varchar	150	False	False	False
OperationalEntity1	varchar	150	False	False	False
CBUCBS	varchar	150	False	False	False
RBURBS	varchar	150	False	False	False
WBUWBS	varchar	150	False	False	False
ContractCompany1	varchar	150	False	False	False
JobFamily	varchar	150	False	False	False
OpBUGeographicalRegion	varchar	150	False	False	False
OpBUGeographicalSubRegion	varchar	150	False	False	False
Location	varchar	150	False	False	False
LocationCode	varchar	150	False	False	False
HRCBSincharge	varchar	150	False	False	False
HRRegion	varchar	150	False	False	False
LocationGeographicalRegion	varchar	150	False	False	False
LocationGeographicalSubRegion	varchar	150	False	False	False
SharedServicesHub	varchar	150	False	False	False
EmplCategory	varchar	150	False	False	False
CODIMember	varchar	150	False	False	False
InternationalStatus	varchar	150	False	False	False
Internationalfiletype	varchar	150	False	False	False
JobCode	varchar	150	False	False	False
JobCodeDescription	varchar	150	False	False	False
Jobentrydate	varchar	150	False	False	False
LocalJobCodeDescription	varchar	150	False	False	False
Positionentrydate	varchar	150	False	False	False
PositionSeniority	varchar	150	False	False	False
OpBUEntryDate	varchar	150	False	False	False
OpBUSeniority	varchar	150	False	False	False
HierarchicalSupervisorID	varchar	150	False	False	False
HierarchicalSupervisorName	varchar	150	False	False	False
ProximityHR1Name	varchar	150	False	False	False
ProximityHR2Name	varchar	150	False	False	False
CostCenter	varchar	150	False	False	False
ContractType	varchar	150	False	False	False
WeeklyHours	varchar	150	False	False	False
FTE	varchar	150	False	False	False
IsFullTimeEmployee	varchar	150	False	False	False
PermTemp	varchar	150	False	False	False
IsShiftEmployee	varchar	150	False	False	False
LaborAgreement	varchar	150	False	False	False
Laboragreementcategory	varchar	150	False	False	False
SalaryAdminPlan	varchar	150	False	False	False
DentroFueradeConvenio	varchar	150	False	False	False
PayGroup	varchar	150	False	False	False
AccountCode	varchar	150	False	False	False
AccountCodeDescription	varchar	150	False	False	False
PayCompany	varchar	150	False	False	False
VariableSchedule	varchar	150	False	False	False
Groupentrydate	varchar	150	False	False	False
GroupSeniority	varchar	150	False	False	False
NegotiatedSeniorityDate	varchar	150	False	False	False
Nacionality	varchar	150	False	False	False
DNI	varchar	50	False	False	False
CUIL	varchar	50	False	False	False

SQL Script

Copy

CREATE TABLE dbo.danone_empleados (
  HirisID varchar(150) NULL,
  DanoneID varchar(150) NULL,
  HirisID2 varchar(150) NULL,
  Name varchar(150) NULL,
  OperationalEntity varchar(150) NULL,
  ContractCompany varchar(150) NULL,
  CBU varchar(150) NULL,
  EmployeeStatus varchar(150) NULL,
  EventReason varchar(150) NULL,
  Effectivedate varchar(150) NULL,
  Event varchar(150) NULL,
  EmailAddress varchar(150) NULL,
  ITAccess varchar(150) NULL,
  Gender varchar(150) NULL,
  PositionTitle varchar(150) NULL,
  OperationalEntity1 varchar(150) NULL,
  CBUCBS varchar(150) NULL,
  RBURBS varchar(150) NULL,
  WBUWBS varchar(150) NULL,
  ContractCompany1 varchar(150) NULL,
  JobFamily varchar(150) NULL,
  OpBUGeographicalRegion varchar(150) NULL,
  OpBUGeographicalSubRegion varchar(150) NULL,
  Location varchar(150) NULL,
  LocationCode varchar(150) NULL,
  HRCBSincharge varchar(150) NULL,
  HRRegion varchar(150) NULL,
  LocationGeographicalRegion varchar(150) NULL,
  LocationGeographicalSubRegion varchar(150) NULL,
  SharedServicesHub varchar(150) NULL,
  EmplCategory varchar(150) NULL,
  CODIMember varchar(150) NULL,
  InternationalStatus varchar(150) NULL,
  Internationalfiletype varchar(150) NULL,
  JobCode varchar(150) NULL,
  JobCodeDescription varchar(150) NULL,
  Jobentrydate varchar(150) NULL,
  LocalJobCodeDescription varchar(150) NULL,
  Positionentrydate varchar(150) NULL,
  PositionSeniority varchar(150) NULL,
  OpBUEntryDate varchar(150) NULL,
  OpBUSeniority varchar(150) NULL,
  HierarchicalSupervisorID varchar(150) NULL,
  HierarchicalSupervisorName varchar(150) NULL,
  ProximityHR1Name varchar(150) NULL,
  ProximityHR2Name varchar(150) NULL,
  CostCenter varchar(150) NULL,
  ContractType varchar(150) NULL,
  WeeklyHours varchar(150) NULL,
  FTE varchar(150) NULL,
  IsFullTimeEmployee varchar(150) NULL,
  PermTemp varchar(150) NULL,
  IsShiftEmployee varchar(150) NULL,
  LaborAgreement varchar(150) NULL,
  Laboragreementcategory varchar(150) NULL,
  SalaryAdminPlan varchar(150) NULL,
  DentroFueradeConvenio varchar(150) NULL,
  PayGroup varchar(150) NULL,
  AccountCode varchar(150) NULL,
  AccountCodeDescription varchar(150) NULL,
  PayCompany varchar(150) NULL,
  VariableSchedule varchar(150) NULL,
  Groupentrydate varchar(150) NULL,
  GroupSeniority varchar(150) NULL,
  NegotiatedSeniorityDate varchar(150) NULL,
  Nacionality varchar(150) NULL,
  DNI varchar(50) NULL,
  CUIL varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found