/****** Object:  Table [dbo].[Nom10007]    Script Date: 11/05/2007 16:21:53 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10007](
	[IDMovtoPDO] [int] NOT NULL,
	[IDPeriodo] [int] NULL,
	[IDEmpleado] [int] NULL,
	[IDConcepto] [int] NULL,
	[IDMovtoPermanente] [int] NULL,
	[ImporteTotal] [float] NULL,
	[Valor] [float] NULL,
	[Importe1] [float] NULL,
	[Importe2] [float] NULL,
	[Importe3] [float] NULL,
	[Importe4] [float] NULL,
	[ImporteTotalReportado] [bit] NOT NULL,
	[Importe1Reportado] [bit] NOT NULL,
	[Importe2Reportado] [bit] NOT NULL,
	[Importe3Reportado] [bit] NOT NULL,
	[Importe4Reportado] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10007] PRIMARY KEY CLUSTERED 
(
	[IDMovtoPDO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXCONPEREMP] ON [dbo].[Nom10007] 
(
	[IDConcepto] ASC,
	[IDPeriodo] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10007] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOPERIODO] ON [dbo].[Nom10007] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10007] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPERIODOCONCEPTO] ON [dbo].[Nom10007] 
(
	[IDPeriodo] ASC,
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10006]    Script Date: 11/05/2007 16:21:45 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10006](
	[IDPuesto] [int] NOT NULL,
	[NumeroPuesto] [int] NULL,
	[Descripcion] [nvarchar](40) NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10006] PRIMARY KEY CLUSTERED 
(
	[IDPuesto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10006] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNUMEROPUESTO] ON [dbo].[Nom10006] 
(
	[NumeroPuesto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10009]    Script Date: 11/05/2007 16:22:07 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10009](
	[IDMovtoDyH] [int] NOT NULL,
	[IDPeriodo] [int] NULL,
	[IDEmpleado] [int] NULL,
	[IDTipoIncidencia] [int] NULL,
	[IDTarjetaIncapacidad] [int] NULL,
	[IDTControlVacaciones] [int] NULL,
	[Fecha] [datetime] NULL,
	[Valor] [float] NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10009] PRIMARY KEY CLUSTERED 
(
	[IDMovtoDyH] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10009] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHA] ON [dbo].[Nom10009] 
(
	[IDEmpleado] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHADESC] ON [dbo].[Nom10009] 
(
	[IDEmpleado] DESC,
	[Fecha] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOPERIODO] ON [dbo].[Nom10009] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDFECHA] ON [dbo].[Nom10009] 
(
	[IDPeriodo] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE UNIQUE NONCLUSTERED INDEX [IDXIDMOVTODYH] ON [dbo].[Nom10009] 
(
	[IDMovtoDyH] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10009] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDTARJETAINCAPACIDAD] ON [dbo].[Nom10009] 
(
	[IDTarjetaIncapacidad] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDTCONTROLVACACIONES] ON [dbo].[Nom10009] 
(
	[IDTControlVacaciones] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPEREMPINC] ON [dbo].[Nom10009] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDTipoIncidencia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPEREMPINCFEC] ON [dbo].[Nom10009] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDTipoIncidencia] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10008]    Script Date: 11/05/2007 16:22:01 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10008](
	[IDMovtoPDO] [int] NOT NULL,
	[IDPeriodo] [int] NULL,
	[IDEmpleado] [int] NULL,
	[IDConcepto] [int] NULL,
	[IDMovtoPermanente] [int] NULL,
	[ImporteTotal] [float] NULL,
	[Valor] [float] NULL,
	[Importe1] [float] NULL,
	[Importe2] [float] NULL,
	[Importe3] [float] NULL,
	[Importe4] [float] NULL,
	[ImporteTotalReportado] [bit] NOT NULL,
	[Importe1Reportado] [bit] NOT NULL,
	[Importe2Reportado] [bit] NOT NULL,
	[Importe3Reportado] [bit] NOT NULL,
	[Importe4Reportado] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10008] PRIMARY KEY CLUSTERED 
(
	[IDMovtoPDO] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXCONPEREMP] ON [dbo].[Nom10008] 
(
	[IDConcepto] ASC,
	[IDPeriodo] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10008] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOPERIODO] ON [dbo].[Nom10008] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10008] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPERIODOCONCEPTO] ON [dbo].[Nom10008] 
(
	[IDPeriodo] ASC,
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10010]    Script Date: 11/05/2007 16:22:13 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10010](
	[IDMovtoDyH] [int] NOT NULL,
	[IDPeriodo] [int] NULL,
	[IDEmpleado] [int] NULL,
	[IDTipoIncidencia] [int] NULL,
	[IDTarjetaIncapacidad] [int] NULL,
	[IDTControlVacaciones] [int] NULL,
	[Fecha] [datetime] NULL,
	[Valor] [float] NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10010] PRIMARY KEY CLUSTERED 
(
	[IDMovtoDyH] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10010] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHA] ON [dbo].[Nom10010] 
(
	[IDEmpleado] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHADESC] ON [dbo].[Nom10010] 
(
	[IDEmpleado] DESC,
	[Fecha] DESC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOPERIODO] ON [dbo].[Nom10010] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDFECHA] ON [dbo].[Nom10010] 
(
	[IDPeriodo] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10010] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDTARJETAINCAPACIDAD] ON [dbo].[Nom10010] 
(
	[IDTarjetaIncapacidad] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDTCONTROLVACACIONES] ON [dbo].[Nom10010] 
(
	[IDTControlVacaciones] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPEREMPINC] ON [dbo].[Nom10010] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDTipoIncidencia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPEREMPINCFEC] ON [dbo].[Nom10010] 
(
	[IDPeriodo] ASC,
	[IDEmpleado] ASC,
	[IDTipoIncidencia] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[NOM10014]    Script Date: 11/05/2007 16:22:28 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[NOM10014](
	[IDTControlVacaciones] [int] NOT NULL,
	[IDEmpleado] [int] NULL,
	[Ejercicio] [int] NULL,
	[DiasVacaciones] [int] NULL,
	[DiasPrimaVacacional] [float] NULL,
	[FechaInicio] [datetime] NULL,
	[FechaFin] [datetime] NULL,
	[DiasDescanso] [nvarchar](100) NULL,
	[TimeStamp] [datetime] NULL,
	[FechaPago] [datetime] NULL,
 CONSTRAINT [PK_nom10014] PRIMARY KEY CLUSTERED 
(
	[IDTControlVacaciones] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEJERCICIOEMPLEADO] ON [dbo].[NOM10014] 
(
	[Ejercicio] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[NOM10014] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHAINICIO] ON [dbo].[NOM10014] 
(
	[IDEmpleado] ASC,
	[FechaInicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXFECHAINICIO] ON [dbo].[NOM10014] 
(
	[FechaInicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10015]    Script Date: 11/05/2007 16:22:31 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10015](
	[IDPoliza] [int] NOT NULL,
	[IDPeriodo] [int] NULL,
	[EstadoContab] [nvarchar](1) NULL,
	[FechaPoliza] [datetime] NULL,
	[TipoPoliza] [int] NULL,
	[NumeroPoliza] [int] NULL,
	[Concepto] [nvarchar](100) NULL,
	[Diario] [smallint] NULL,
 CONSTRAINT [PK_nom10015] PRIMARY KEY CLUSTERED 
(
	[IDPoliza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10017]    Script Date: 11/05/2007 16:22:43 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10017](
	[IDMovtoPermanente] [int] NOT NULL,
	[IDEmpleado] [int] NULL,
	[IDConcepto] [int] NULL,
	[Descripcion] [nvarchar](40) NULL,
	[Tipo] [nvarchar](1) NULL,
	[Valor] [float] NULL,
	[VecesAplicar] [int] NULL,
	[VecesAplicado] [int] NULL,
	[MontoLimite] [float] NULL,
	[MontoAcumulado] [float] NULL,
	[MontoAcumuladoEjeAnt] [float] NULL,
	[FechaRegistro] [datetime] NULL,
	[NumeroControl] [nvarchar](40) NULL,
	[Estado] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
	[NumeroFiltro] [int] NULL,
 CONSTRAINT [PK_nom10017] PRIMARY KEY CLUSTERED 
(
	[IDMovtoPermanente] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10017] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10017] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADODESCRIPCION] ON [dbo].[Nom10017] 
(
	[IDEmpleado] ASC,
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10016]    Script Date: 11/05/2007 16:22:37 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10016](
	[IDMovtoPoliza] [int] NOT NULL,
	[IDPoliza] [int] NULL,
	[CuentaCW] [nvarchar](31) NULL,
	[NumeroMovto] [int] NULL,
	[Referencia] [nvarchar](10) NULL,
	[Concepto] [nvarchar](30) NULL,
	[TipoMovto] [nvarchar](1) NULL,
	[Cargo] [float] NULL,
	[Abono] [float] NULL,
	[CargoMonedaExt] [float] NULL,
	[AbonoMonedaExt] [float] NULL,
	[Diario] [smallint] NULL,
 CONSTRAINT [PK_nom10016] PRIMARY KEY CLUSTERED 
(
	[IDMovtoPoliza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPOLIZA] ON [dbo].[Nom10016] 
(
	[IDPoliza] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPOLIZACUENTATIPO] ON [dbo].[Nom10016] 
(
	[IDPoliza] ASC,
	[CuentaCW] ASC,
	[TipoMovto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10018]    Script Date: 11/05/2007 16:22:51 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10018](
	[IDTarjetaIncapacidad] [int] NOT NULL,
	[IDTipoIncidencia] [int] NULL,
	[IDEmpleado] [int] NULL,
	[Folio] [nvarchar](20) NULL,
	[DiasAutorizados] [int] NULL,
	[FechaInicio] [datetime] NULL,
	[Descripcion] [nvarchar](40) NULL,
	[IncapacidadInicial] [nvarchar](1) NULL,
	[RamoSeguro] [nvarchar](1) NULL,
	[TipoRiesgo] [nvarchar](1) NULL,
	[NumeroCaso] [int] NULL,
	[FinCaso] [bit] NOT NULL,
	[PorcentajeIncapacidad] [float] NULL,
	[ControlMaternidad] [bit] NOT NULL,
	[NombreMedico] [nvarchar](40) NULL,
	[MatriculaMedico] [nvarchar](40) NULL,
	[Circunstancia] [nvarchar](1) NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10018] PRIMARY KEY CLUSTERED 
(
	[IDTarjetaIncapacidad] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10018] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFOLIO] ON [dbo].[Nom10018] 
(
	[IDEmpleado] ASC,
	[Folio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADONUMEROCASO] ON [dbo].[Nom10018] 
(
	[IDEmpleado] ASC,
	[NumeroCaso] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXFOLIO] ON [dbo].[Nom10018] 
(
	[Folio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[NOM10022]    Script Date: 11/05/2007 16:23:03 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[NOM10022](
	[IDTipoIncidencia] [int] NOT NULL,
	[Descripcion] [nvarchar](40) NULL,
	[Mnemonico] [nvarchar](4) NULL,
	[DerechoSueldo] [bit] NOT NULL,
	[PorcentajeSueldo] [float] NULL,
	[TipoIMSS] [nvarchar](1) NULL,
	[TipoIncidencia] [nvarchar](1) NULL,
	[DerechoSeptimoDia] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
	[ValorUnidad] [float] NULL,
 CONSTRAINT [PK_nom10022] PRIMARY KEY CLUSTERED 
(
	[IDTipoIncidencia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[NOM10022] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXMNEMONICO] ON [dbo].[NOM10022] 
(
	[Mnemonico] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXTIPOINCIDENCIA] ON [dbo].[NOM10022] 
(
	[TipoIncidencia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10020]    Script Date: 11/05/2007 16:22:56 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10020](
	[IDBajaReingreso] [int] NOT NULL,
	[IDEmpleado] [int] NULL,
	[ClaveBajaReingreso] [nvarchar](1) NULL,
	[Fecha] [datetime] NULL,
 CONSTRAINT [PK_nom10020] PRIMARY KEY CLUSTERED 
(
	[IDBajaReingreso] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10020] 
(
	[IDEmpleado] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHA] ON [dbo].[Nom10020] 
(
	[IDEmpleado] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPRIMARYKEY] ON [dbo].[Nom10020] 
(
	[Fecha] ASC,
	[ClaveBajaReingreso] ASC,
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10023]    Script Date: 11/05/2007 16:23:09 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10023](
	[IDTipoPeriodo] [int] NOT NULL,
	[NombreTipoPeriodo] [nvarchar](40) NULL,
	[DiasDelPeriodo] [int] NULL,
	[DiasDePago] [float] NULL,
	[PeriodoTrabajo] [int] NULL,
	[ModificarHistoria] [bit] NOT NULL,
	[AjustarPeriodosCalendario] [bit] NOT NULL,
	[NumeroSeptimos] [int] NULL,
	[PosicionSeptimos] [nvarchar](30) NULL,
	[PosicionPagoNomina] [int] NULL,
	[FechaInicioEjercicio] [datetime] NULL,
	[Ejercicio] [int] NULL,
	[TimeStamp] [datetime] NULL,
	[CCalculoMesCalendario] [int] NULL,
 CONSTRAINT [PK_nom10023] PRIMARY KEY CLUSTERED 
(
	[IDTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDIASDELPERIODO] ON [dbo].[Nom10023] 
(
	[DiasDelPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDTIPOPERIODO] ON [dbo].[Nom10023] 
(
	[IDTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNOMBRETIPOPERIODO] ON [dbo].[Nom10023] 
(
	[NombreTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10027]    Script Date: 11/05/2007 16:23:17 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10027](
	[NumeroTabla] [int] NOT NULL,
	[Descripcion] [nvarchar](40) NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10027] PRIMARY KEY CLUSTERED 
(
	[NumeroTabla] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10027] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10024]    Script Date: 11/05/2007 16:23:13 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10024](
	[IDDispFiscal] [int] NOT NULL,
	[Tipo] [nvarchar](1) NULL,
	[Descripcion] [nvarchar](40) NULL,
	[Ruta] [nvarchar](255) NULL,
	[FechaInicio] [nvarchar](5) NULL,
	[Frecuencia] [nvarchar](1) NULL,
	[Activada] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10024] PRIMARY KEY CLUSTERED 
(
	[IDDispFiscal] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10024] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXFECHAINICIO] ON [dbo].[Nom10024] 
(
	[FechaInicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXFFRECUENCIA] ON [dbo].[Nom10024] 
(
	[FechaInicio] ASC,
	[Frecuencia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10030]    Script Date: 11/05/2007 16:23:24 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10030](
	[IDCategoria] [int] NOT NULL,
	[Nombre] [nvarchar](40) NULL,
	[Grupo] [nvarchar](1) NULL,
	[Tipo] [nvarchar](1) NULL,
	[Posicion] [int] NULL,
	[TimeStamp] [datetime] NULL,
	[CPropia] [bit] NULL,
 CONSTRAINT [PK_nom10030] PRIMARY KEY CLUSTERED 
(
	[IDCategoria] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPOSICION] ON [dbo].[Nom10030] 
(
	[Posicion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10031]    Script Date: 11/05/2007 16:23:29 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10031](
	[IDFormula] [int] NOT NULL,
	[IDCategoria] [int] NULL,
	[Nombre] [nvarchar](40) NULL,
	[Tipo] [nvarchar](1) NULL,
	[Posicion] [int] NULL,
	[Descripcion] [ntext] NULL,
	[Ayuda] [ntext] NULL,
	[Expresion] [ntext] NULL,
	[Modificado] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
	[Version] [int] NULL,
 CONSTRAINT [PK_nom10031] PRIMARY KEY CLUSTERED 
(
	[IDFormula] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXCATEGORIAPOSICION] ON [dbo].[Nom10031] 
(
	[IDCategoria] ASC,
	[Posicion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNOMBRE] ON [dbo].[Nom10031] 
(
	[Nombre] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXPOSICION] ON [dbo].[Nom10031] 
(
	[Posicion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[NOM10033]    Script Date: 11/05/2007 16:23:33 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[NOM10033](
	[IDModelo] [int] NOT NULL,
	[Archivo] [nvarchar](255) NULL,
	[Descripcion] [nvarchar](40) NULL,
 CONSTRAINT [PK_nom10033] PRIMARY KEY CLUSTERED 
(
	[IDModelo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[NomBlobs]    Script Date: 11/05/2007 16:23:34 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[NomBlobs](
	[Username] [nvarchar](15) NULL,
	[CodigoEmpleado] [nvarchar](40) NULL,
	[Numero] [float] NULL
) ON [PRIMARY]
  
CREATE UNIQUE NONCLUSTERED INDEX [IDXCODIGOEMPLEADO] ON [dbo].[NomBlobs] 
(
	[CodigoEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[NomDates]    Script Date: 11/05/2007 16:23:35 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[NomDates](
	[Table] [nvarchar](255) NULL,
	[Date] [datetime] NULL
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10032]    Script Date: 11/05/2007 16:23:31 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10032](
	[IDTurno] [int] NOT NULL,
	[NumeroTurno] [int] NULL,
	[Descripcion] [nvarchar](40) NULL,
	[NumeroHoras] [float] NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10032] PRIMARY KEY CLUSTERED 
(
	[IDTurno] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10032] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNUMEROTURNO] ON [dbo].[Nom10032] 
(
	[NumeroTurno] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10005]    Script Date: 11/05/2007 16:21:43 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10005](
	[IDempleado] [int] NOT NULL,
	[IDConcepto] [int] NOT NULL,
 CONSTRAINT [PK_nom10005] PRIMARY KEY CLUSTERED 
(
	[IDempleado] ASC,
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDEMPLEADO] ON [dbo].[Nom10005] 
(
	[IDempleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10011]    Script Date: 11/05/2007 16:22:20 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10011](
	[IDEmpleado] [int] NOT NULL,
	[IDTipoAcumulado] [int] NOT NULL,
	[Ejercicio] [int] NOT NULL,
	[Importe1] [float] NULL,
	[Importe2] [float] NULL,
	[Importe3] [float] NULL,
	[Importe4] [float] NULL,
	[Importe5] [float] NULL,
	[Importe6] [float] NULL,
	[Importe7] [float] NULL,
	[Importe8] [float] NULL,
	[Importe9] [float] NULL,
	[Importe10] [float] NULL,
	[Importe11] [float] NULL,
	[Importe12] [float] NULL,
	[ImporteInicioEjercicio] [float] NULL,
	[ImporteEjercicioAnterior] [float] NULL,
 CONSTRAINT [PK_nom10011] PRIMARY KEY CLUSTERED 
(
	[IDEmpleado] ASC,
	[IDTipoAcumulado] ASC,
	[Ejercicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEJERCICIO] ON [dbo].[Nom10011] 
(
	[Ejercicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADO] ON [dbo].[Nom10011] 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOEJERCICIO] ON [dbo].[Nom10011] 
(
	[IDEmpleado] ASC,
	[Ejercicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10012]    Script Date: 11/05/2007 16:22:22 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10012](
	[IDConcepto] [int] NOT NULL,
	[IDTipoAcumulado] [int] NOT NULL,
	[Tipo] [nvarchar](1) NOT NULL,
 CONSTRAINT [PK_nom10012] PRIMARY KEY CLUSTERED 
(
	[IDConcepto] ASC,
	[IDTipoAcumulado] ASC,
	[Tipo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDCONCEPTO] ON [dbo].[Nom10012] 
(
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10013]    Script Date: 11/05/2007 16:22:23 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10013](
	[IDTipoIncidencia] [int] NOT NULL,
	[IDTipoAcumulado] [int] NOT NULL,
 CONSTRAINT [PK_nom10013] PRIMARY KEY CLUSTERED 
(
	[IDTipoIncidencia] ASC,
	[IDTipoAcumulado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10019]    Script Date: 11/05/2007 16:22:54 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10019](
	[IDEmpleado] [int] NOT NULL,
	[Fecha] [datetime] NOT NULL,
	[TipoSueldo] [nvarchar](1) NOT NULL,
	[Sueldo] [float] NULL,
 CONSTRAINT [PK_nom10019] PRIMARY KEY CLUSTERED 
(
	[IDEmpleado] ASC,
	[Fecha] ASC,
	[TipoSueldo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOFECHA] ON [dbo].[Nom10019] 
(
	[IDEmpleado] ASC,
	[Fecha] ASC,
	[TipoSueldo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXEMPLEADOTIPO] ON [dbo].[Nom10019] 
(
	[IDEmpleado] ASC,
	[TipoSueldo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10021]    Script Date: 11/05/2007 16:22:59 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10021](
	[IDTipoAcumulado] [int] NOT NULL,
	[Nombre] [nvarchar](40) NOT NULL,
	[TipoMovtoAcumulado] [nvarchar](1) NOT NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10021] PRIMARY KEY CLUSTERED 
(
	[IDTipoAcumulado] ASC,
	[Nombre] ASC,
	[TipoMovtoAcumulado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNOMBRE] ON [dbo].[Nom10021] 
(
	[Nombre] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10025]    Script Date: 11/05/2007 16:23:14 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10025](
	[IDPeriodo] [int] NOT NULL,
	[Fecha] [datetime] NOT NULL,
 CONSTRAINT [PK_nom10025] PRIMARY KEY CLUSTERED 
(
	[IDPeriodo] ASC,
	[Fecha] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10025] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10026]    Script Date: 11/05/2007 16:23:15 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10026](
	[Mes] [int] NOT NULL,
	[Dia] [int] NOT NULL,
	[Descripcion] [nvarchar](40) NULL,
 CONSTRAINT [PK_nom10026] PRIMARY KEY CLUSTERED 
(
	[Mes] ASC,
	[Dia] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10028]    Script Date: 11/05/2007 16:23:19 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10028](
	[NumeroTabla] [int] NOT NULL,
	[NumeroColumna] [int] NOT NULL,
	[Descripcion] [nvarchar](40) NULL,
	[TipoColumna] [nvarchar](1) NULL,
 CONSTRAINT [PK_nom10028] PRIMARY KEY CLUSTERED 
(
	[NumeroTabla] ASC,
	[NumeroColumna] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10029]    Script Date: 11/05/2007 16:23:21 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10029](
	[NumeroTabla] [int] NOT NULL,
	[NumeroColumna] [int] NOT NULL,
	[NumeroRenglon] [int] NOT NULL,
	[Valor] [float] NULL,
	[Fecha] [datetime] NULL,
 CONSTRAINT [PK_nom10029] PRIMARY KEY CLUSTERED 
(
	[NumeroTabla] ASC,
	[NumeroColumna] ASC,
	[NumeroRenglon] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10002]    Script Date: 11/05/2007 16:21:29 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10002](
	[IDPeriodo] [int] NOT NULL,
	[IDTipoPeriodo] [int] NULL,
	[NumeroPeriodo] [int] NULL,
	[Ejercicio] [int] NULL,
	[Mes] [int] NULL,
	[DiasDePago] [float] NULL,
	[Septimos] [int] NULL,
	[InterfazCheqpaqW] [bit] NOT NULL,
	[ModificacionNeto] [bit] NOT NULL,
	[Calculado] [bit] NOT NULL,
	[Afectado] [bit] NOT NULL,
	[FechaInicio] [datetime] NULL,
	[FechaFin] [datetime] NULL,
	[InicioEjercicio] [bit] NOT NULL,
	[InicioMes] [bit] NOT NULL,
	[FinMes] [bit] NOT NULL,
	[FinEjercicio] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10002] PRIMARY KEY CLUSTERED 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDEJERCICIO] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[Ejercicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDEJERCICIOMES] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[Ejercicio] ASC,
	[Mes] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDEJERCICIONUMERO] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[Ejercicio] ASC,
	[NumeroPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDFECHAFIN] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[FechaFin] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDFECHAINICIO] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[FechaInicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDFECHAS] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[FechaInicio] ASC,
	[FechaFin] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDMESEJERCICIO] ON [dbo].[Nom10002] 
(
	[IDTipoPeriodo] ASC,
	[Mes] ASC,
	[Ejercicio] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDNUMERO] ON [dbo].[Nom10002] 
(
	[IDPeriodo] ASC,
	[NumeroPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDPERIODO] ON [dbo].[Nom10002] 
(
	[IDPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNUMEROPERIODO] ON [dbo].[Nom10002] 
(
	[NumeroPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10001]    Script Date: 11/05/2007 16:21:20 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10001](
	[IDEmpleado] [int] NOT NULL,
	[IDDepartamento] [int] NULL,
	[IDPuesto] [int] NULL,
	[IDTipoPeriodo] [int] NULL,
	[IDTurno] [int] NULL,
	[CodigoEmpleado] [nvarchar](30) NULL,
	[Nombre] [nvarchar](40) NULL,
	[ApellidoPaterno] [nvarchar](40) NULL,
	[ApellidoMaterno] [nvarchar](40) NULL,
	[NombreLargo] [nvarchar](120) NULL,
	[FechaNacimiento] [datetime] NULL,
	[LugarNacimiento] [nvarchar](40) NULL,
	[EstadoCivil] [nvarchar](1) NULL,
	[Sexo] [nvarchar](1) NULL,
	[CURPI] [nvarchar](6) NULL,
	[CURPF] [nvarchar](8) NULL,
	[NumeroSeguroSocial] [nvarchar](11) NULL,
	[UMF] [int] NULL,
	[RFC] [nvarchar](4) NULL,
	[Homoclave] [nvarchar](4) NULL,
	[CuentaPagoElectronico] [nvarchar](20) NULL,
	[SucursalPagoElectronico] [nvarchar](50) NULL,
	[BancoPagoElectronico] [int] NULL,
	[EstadoEmpleado] [nvarchar](1) NULL,
	[SueldoDiario] [float] NULL,
	[FechaSueldoDiario] [datetime] NULL,
	[SueldoVariable] [float] NULL,
	[FechaSueldoVariable] [datetime] NULL,
	[SueldoPromedio] [float] NULL,
	[FechaSueldoPromedio] [datetime] NULL,
	[SueldoIntegrado] [float] NULL,
	[FechaSueldoIntegrado] [datetime] NULL,
	[Calculado] [bit] NOT NULL,
	[Afectado] [bit] NOT NULL,
	[CalculadoExtraordinario] [bit] NOT NULL,
	[AfectadoExtraordinario] [bit] NOT NULL,
	[InterfazCheqpaqW] [bit] NOT NULL,
	[ModificacionNeto] [bit] NOT NULL,
	[FechaAlta] [datetime] NULL,
	[CuentaCW] [nvarchar](31) NULL,
	[TipoContrato] [nvarchar](1) NULL,
	[BaseCotizacionIMSS] [nvarchar](1) NULL,
	[TipoEmpleado] [nvarchar](1) NULL,
	[BasePago] [nvarchar](1) NULL,
	[FormaPago] [nvarchar](1) NULL,
	[ZonaSalario] [nvarchar](1) NULL,
	[CalculoPTU] [bit] NOT NULL,
	[CalculoAguinaldo] [bit] NOT NULL,
	[ModificacionSalarioIMSS] [bit] NOT NULL,
	[AltaIMSS] [bit] NOT NULL,
	[BajaIMSS] [bit] NOT NULL,
	[CambioCotizacionIMSS] [bit] NOT NULL,
	[Expediente] [ntext] NULL,
	[Telefono] [nvarchar](20) NULL,
	[CodigoPostal] [int] NULL,
	[Direccion] [nvarchar](60) NULL,
	[Poblacion] [nvarchar](60) NULL,
	[Estado] [nvarchar](20) NULL,
	[NombrePadre] [nvarchar](60) NULL,
	[NombreMadre] [nvarchar](60) NULL,
	[NumeroAfore] [nvarchar](50) NULL,
	[FechaBaja] [datetime] NULL,
	[CausaBaja] [nvarchar](60) NULL,
	[SueldoBaseLiquidacion] [float] NULL,
	[CampoExtra1] [nvarchar](40) NULL,
	[CampoExtra2] [nvarchar](40) NULL,
	[CampoExtra3] [nvarchar](40) NULL,
	[FechaReingreso] [datetime] NULL,
	[AjusteAlNeto] [float] NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10001] PRIMARY KEY CLUSTERED 
(
	[IDEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXCODIGOEMPLEADO] ON [dbo].[Nom10001] 
(
	[CodigoEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDEPTOTIPOPER] ON [dbo].[Nom10001] 
(
	[IDDepartamento] ASC,
	[IDTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDDEPTO] ON [dbo].[Nom10001] 
(
	[IDDepartamento] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDDEPTOCODIGO] ON [dbo].[Nom10001] 
(
	[IDDepartamento] ASC,
	[CodigoEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXIDEMPLEADOTIPOPERIODO] ON [dbo].[Nom10001] 
(
	[IDEmpleado] ASC,
	[IDTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNOMBRE] ON [dbo].[Nom10001] 
(
	[NombreLargo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXTIPOPERIODO] ON [dbo].[Nom10001] 
(
	[IDTipoPeriodo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXTIPOPERIODOCODIGO] ON [dbo].[Nom10001] 
(
	[IDTipoPeriodo] ASC,
	[CodigoEmpleado] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXTIPOPERIODODEPTO] ON [dbo].[Nom10001] 
(
	[IDTipoPeriodo] ASC,
	[IDDepartamento] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10000]    Script Date: 11/05/2007 16:20:52 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10000](
	[IDCptoPrimaVac] [int] NULL,
	[IDCptoAguinaldo] [int] NULL,
	[IDCptoPTU] [int] NULL,
	[IDCptoVacaciones] [int] NULL,
	[NombreCorto] [nvarchar](15) NULL,
	[RutaRespaldo] [nvarchar](255) NULL,
	[RutaContpaqW] [nvarchar](255) NULL,
	[RutaCheqpaqW] [nvarchar](255) NULL,
	[IDEmpresaContpaqW] [int] NULL,
	[Direccion] [nvarchar](60) NULL,
	[Telefono1] [nvarchar](20) NULL,
	[Telefono2] [nvarchar](20) NULL,
	[Telefono3] [nvarchar](20) NULL,
	[Fax] [nvarchar](20) NULL,
	[RegistroIMSS] [nvarchar](20) NULL,
	[RegistroCamara] [nvarchar](50) NULL,
	[RFC] [nvarchar](4) NULL,
	[Homoclave] [nvarchar](4) NULL,
	[RegistroInfonavit] [nvarchar](20) NULL,
	[RegistroFonacot] [nvarchar](20) NULL,
	[RegistroComisionMixta] [nvarchar](50) NULL,
	[RegistroSSA] [nvarchar](50) NULL,
	[ZonaSalarioGeneral] [nvarchar](1) NULL,
	[FechaInicioHistoria] [datetime] NULL,
	[FechaConstitucion] [datetime] NULL,
	[Ejercicio] [int] NULL,
	[PorcentajeSubsidio] [float] NULL,
	[CuentaCWGlobal] [nvarchar](31) NULL,
	[EstructuraCuentaCW] [nvarchar](9) NULL,
	[FormatoSobreRecibo] [nvarchar](255) NULL,
	[AfectarPeriodosAnteriores] [bit] NOT NULL,
	[AfectarPeriodosFuturos] [bit] NOT NULL,
	[PosicionCuentaEmpleado] [int] NULL,
	[LongitudCuentaEmpleado] [int] NULL,
	[PosicionCuentaDepto] [int] NULL,
	[LongitudCuentaDepto] [int] NULL,
	[Localidad] [nvarchar](40) NULL,
	[NombreRepresentante] [nvarchar](40) NULL,
	[ApPaternoRepresentante] [nvarchar](40) NULL,
	[ApMaternoRepresentante] [nvarchar](40) NULL,
	[CodigoPostal] [int] NULL,
	[ApartadoPostal] [nvarchar](11) NULL,
	[MascarillaCodigo] [nvarchar](30) NULL,
	[NumeroDecimales] [int] NULL,
	[TipoCodigoEmpleado] [nvarchar](1) NULL,
	[MostrarAgenda] [bit] NOT NULL,
	[TimeStamp] [datetime] NULL,
	[IDCptoAjuste] [int] NULL,
	[IDCptoIndem20] [int] NULL,
	[IDCptoIndem90] [int] NULL,
	[IDCptoPrimaAntig] [int] NULL,
	[IDCptoPrimaVacRep] [int] NULL,
	[IDCptoSueldo] [int] NULL,
	[IDCptoVacRep] [int] NULL
) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10003]    Script Date: 11/05/2007 16:21:32 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10003](
	[IDDepartamento] [int] NOT NULL,
	[NumeroDepartamento] [int] NULL,
	[Descripcion] [nvarchar](40) NULL,
	[Beneficiario] [nvarchar](60) NULL,
	[CuentaCW] [nvarchar](31) NULL,
	[TimeStamp] [datetime] NULL,
	[CSegmentoNegocio] [int] NULL,
 CONSTRAINT [PK_nom10003] PRIMARY KEY CLUSTERED 
(
	[IDDepartamento] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10003] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNUMERODEPARTAMENTO] ON [dbo].[Nom10003] 
(
	[NumeroDepartamento] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
/****** Object:  Table [dbo].[Nom10004]    Script Date: 11/05/2007 16:21:42 ******/
SET ANSI_NULLS ON
  
SET QUOTED_IDENTIFIER ON
  
CREATE TABLE [dbo].[Nom10004](
	[IDConcepto] [int] NOT NULL,
	[NumeroConcepto] [int] NULL,
	[TipoConcepto] [nvarchar](1) NULL,
	[Descripcion] [nvarchar](40) NULL,
	[Especie] [bit] NOT NULL,
	[AutomaticoGlobal] [bit] NOT NULL,
	[AutomaticoLiquidacion] [bit] NOT NULL,
	[Imprimir] [bit] NOT NULL,
	[Articulo86] [bit] NOT NULL,
	[LeyendaImporte1] [nvarchar](40) NULL,
	[LeyendaImporte2] [nvarchar](40) NULL,
	[LeyendaImporte3] [nvarchar](40) NULL,
	[LeyendaImporte4] [nvarchar](40) NULL,
	[CuentaCW] [nvarchar](31) NULL,
	[TipoMovtoCW] [nvarchar](1) NULL,
	[ContraCuentaCW] [nvarchar](31) NULL,
	[ContabCuentaCW] [nvarchar](1) NULL,
	[ContabContraCuentaCW] [nvarchar](1) NULL,
	[LeyendaValor] [nvarchar](40) NULL,
	[FormulaImporteTotal] [ntext] NULL,
	[FormulaImporte1] [ntext] NULL,
	[FormulaImporte2] [ntext] NULL,
	[FormulaImporte3] [ntext] NULL,
	[FormulaImporte4] [ntext] NULL,
	[TimeStamp] [datetime] NULL,
 CONSTRAINT [PK_nom10004] PRIMARY KEY CLUSTERED 
(
	[IDConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXDESCRIPCION] ON [dbo].[Nom10004] 
(
	[Descripcion] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXNUMEROCONCEPTO] ON [dbo].[Nom10004] 
(
	[NumeroConcepto] ASC,
	[TipoConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  
CREATE NONCLUSTERED INDEX [IDXTIPOCONCEPTO] ON [dbo].[Nom10004] 
(
	[TipoConcepto] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]