/****** Object:  Table [dbo].[tbl_DW_OperatorAgreements]    Script Date: 7/6/2020 3:51:53 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorAgreements_MFR0](
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[cho_id] [int] NOT NULL,
	[cho_name] [varchar](150) NULL,
	[assignedContractNbr] [varchar](25) NOT NULL,
	[contractName] [varchar](200) NOT NULL,
	[startDate] [datetime] NULL,
	[endDate] [datetime] NULL,
	[contractId] [int] NOT NULL,
 CONSTRAINT [PK_DW_OperatorAgreements_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[cho_id] ASC,
	[assignedContractNbr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[tbl_DW_OperatorAnalyzer]    Script Date: 7/6/2020 3:52:11 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorAnalyzer_MFR0](
	[ownerType] [char](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[dataId] [int] IDENTITY(1,1) NOT NULL,
	[operatorName] [varchar](150) NULL,
	[cho_id] [int] NOT NULL,
	[cho_type] [char](1) NOT NULL,
	[segmentId] [int] NULL,
	[operatorSegment] [varchar](200) NULL,
	[purchasingMonth] [datetime] NULL,
	[forecast_qty] [decimal](18, 2) NOT NULL,
	[skuId] [int] NOT NULL,
	[sku] [varchar](30) NULL,
	[skuDesc] [varchar](250) NULL,
	[requestId] [int] NULL,
	[agreementOwnerChoId] [int] NULL,
	[agreementOwnerName] [varchar](150) NULL,
	[prodId] [int] NULL,
	[product] [varchar](25) NULL,
	[shortDesc] [varchar](100) NULL,
	[categoryId] [int] NULL,
	[catnum] [varchar](25) NULL,
	[category] [varchar](75) NULL,
	[prodline_id] [int] NULL,
	[productLineCode] [varchar](50) NULL,
	[productLine] [varchar](200) NULL,
	[territoryId] [int] NULL,
	[territoryName] [varchar](50) NULL,
	[rollup_cho_id] [int] NULL,
	[rollup_operatorName] [varchar](150) NULL,
 CONSTRAINT [PK_tbl_DW_OperatorAnalyzer_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[dataId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


/****** Object:  Table [dbo].[tbl_DW_OperatorAnalyzerClaimDetails]    Script Date: 7/6/2020 3:52:32 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorAnalyzerClaimDetails_MFR0](
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[cho_id] [int] NOT NULL,
	[cho_name] [varchar](150) NULL,
	[assignedContractNbr] [varchar](25) NOT NULL,
	[contractName] [varchar](200) NOT NULL,
	[claimInvoice] [varchar](25) NULL,
	[claimDate] [datetime] NOT NULL,
	[periodStart] [datetime] NULL,
	[periodEnd] [datetime] NULL,
	[claimant] [varchar](125) NULL,
	[skuId] [int] NOT NULL,
	[sku] [varchar](30) NULL,
	[skuDesc] [varchar](250) NULL,
	[itemQty] [decimal](38, 4) NULL,
	[dataId] [int] IDENTITY(1,1) NOT NULL,
	[locationName] [varchar](125) NULL,
	[contractId] [int] NULL,
 CONSTRAINT [PK_DW_OperatorAnalyzerClaimDetails_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[dataId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[tbl_DW_OperatorSegments]    Script Date: 7/6/2020 3:52:43 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorSegments_MFR0](
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[operatorSegmentId] [int] NOT NULL,
	[operatorSegment] [varchar](200) NULL,
 CONSTRAINT [PK_DW_OperatorSegments_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[operatorSegmentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


/****** Object:  Table [dbo].[tbl_DW_OperatorTerritories]    Script Date: 7/6/2020 3:52:51 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorTerritories_MFR0](
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[territoryId] [int] NOT NULL,
	[territoryName] [varchar](50) NULL,
 CONSTRAINT [PK_DW_OperatorTerritories_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[territoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


/****** Object:  Table [dbo].[tbl_DW_ProductHierarchy_MFR0]    Script Date: 7/6/2020 3:52:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_ProductHierarchy_MFR0](
	[ownerType] [varchar](3) NOT NULL,
	[ownerId] [int] NOT NULL,
	[skuId] [int] NOT NULL,
	[sku] [varchar](30) NULL,
	[skuDesc] [varchar](250) NULL,
	[prodId] [int] NULL,
	[product] [varchar](25) NULL,
	[shortDesc] [varchar](100) NULL,
	[categoryId] [int] NULL,
	[catnum] [varchar](25) NULL,
	[category] [varchar](75) NULL,
	[prodline_id] [int] NULL,
	[productLineCode] [varchar](50) NULL,
	[productLine] [varchar](200) NULL,
 CONSTRAINT [PK_DW_ProductHierarchy_MFR0] PRIMARY KEY CLUSTERED 
(
	[ownerType] ASC,
	[ownerId] ASC,
	[skuId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO



/****** Object: Table [dbo].[tbl_DW_OperatorExclusions] Script Date: 7/6/2020 4:02:19 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_OperatorExclusions_MFR0](
[ownerType] [varchar](3) NOT NULL,
[ownerId] [int] NOT NULL,
[claimId] [int] NOT NULL,
[claimDate] [datetime] NOT NULL,
[claimRef] [varchar](25) NULL,
[claimInvoice] [varchar](25) NULL,
[claimantPartnerType] [varchar](3) NOT NULL,
[claimantPartnerId] [int] NULL,
[claimantPartnerName] [varchar](125) NULL,
[beneficiaryOperatorId1] [int] NOT NULL,
[beneficiaryOperatorName1] [varchar](125) NOT NULL,
[choId1] [int] NULL,
[contractId1] [int] NOT NULL,
[assignedContractNbr1] [varchar](25) NOT NULL,
[contractName1] [varchar](200) NOT NULL,
[beneficiaryOperatorId2] [int] NOT NULL,
[beneficiaryOperatorName2] [varchar](125) NOT NULL,
[choId2] [int] NULL,
[contractId2] [int] NOT NULL,
[assignedContractNbr2] [varchar](25) NOT NULL,
[contractName2] [varchar](200) NOT NULL,
[claimDollars] [decimal](38, 4) NULL,
[claimCases] [decimal](38, 4) NULL,
[dataId] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_DW_OperatorExclusions_MFR0] PRIMARY KEY CLUSTERED
(
[ownerType] ASC,
[ownerId] ASC,
[dataId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO


/****** Object: Table [dbo].[tbl_DW_1FSOperators] Script Date: 7/6/2020 4:10:28 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tbl_DW_1FSOperators_MFR0](
[ownerType] [varchar](3) NOT NULL,
[ownerId] [int] NOT NULL,
[choId] [int] NOT NULL,
[operatorName] [varchar](150) NOT NULL,
[operatorAddress] [varchar](150) NULL,
[operatorCity] [varchar](50) NULL,
[operatorState] [varchar](2) NULL,
[operatorZipCode] [varchar](10) NULL,
[operatorSegmentId] [int] NULL,
[operatorSegment] [varchar](200) NULL,
[lastActivityDate] [datetime] NULL,
[operatorType] [varchar](25) NOT NULL,
[parentChoId] [int] NULL,
[parentName] [varchar](150) NULL,
[hostChoId] [int] NULL,
[hostName] [varchar](150) NULL,
[affiliationChoId_1] [int] NULL,
[affiliationSince_1] [datetime] NULL,
[affiliationMemberNbr_1] [varchar](25) NULL,
[affiliationName_1] [varchar](150) NULL,
[affiliationChoId_2] [int] NULL,
[affiliationSince_2] [datetime] NULL,
[affiliationMemberNbr_2] [varchar](25) NULL,
[affiliationName_2] [varchar](150) NULL,
[affiliationChoId_3] [int] NULL,
[affiliationSince_3] [datetime] NULL,
[affiliationMemberNbr_3] [varchar](25) NULL,
[affiliationName_3] [varchar](150) NULL,
[affiliationChoId_4] [int] NULL,
[affiliationSince_4] [datetime] NULL,
[affiliationMemberNbr_4] [varchar](25) NULL,
[affiliationName_4] [varchar](150) NULL,
[primaryGPO] [varchar](5) NULL,
CONSTRAINT [pk_DW_1FSOperators_MFR0] PRIMARY KEY CLUSTERED
(
[ownerType] ASC,
[ownerId] ASC,
[choId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO