-
Notifications
You must be signed in to change notification settings - Fork 0
/
MULTI.t_op_SiteProfile.Table.sql
37 lines (37 loc) · 2.43 KB
/
MULTI.t_op_SiteProfile.Table.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
USE [Reporting]
GO
/****** Object: Table [MULTI].[t_op_SiteProfile] Script Date: 4/2/2024 11:07:52 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [MULTI].[t_op_SiteProfile](
[Registry] [varchar](7) NOT NULL,
[SiteID] [int] NULL,
[SiteStatus] [nvarchar](1024) NULL,
[SalesforceStatus] [varchar](20) NULL,
[TopEnrollingSite] [nvarchar](80) NULL,
[MonthsActive] [float] NULL,
[NonExited] [int] NULL,
[Exited] [int] NULL,
[TotalVisits] [int] NULL,
[AvgVisitsPerMonth] [decimal](5, 1) NULL,
[NineMonthActiveCount] [int] NULL,
[ConfirmedEvents] [int] NULL,
[ExpectedEvents] [int] NULL,
[RetrievedDocs] [int] NULL,
[DocRetrievalPercent] [float] NULL,
[AllTimeConfirmedEvents] [int] NULL,
[AllTimeRetrievedDocs] [int] NULL,
[AllTimeDocRetrievalPercent] [float] NULL,
[ActivePercent] [float] NULL,
[ConsistencyRating] [varchar](13) NULL,
[DataContributionAllTime] [numeric](10, 8) NULL,
[RunningDataContributionAllTime] [numeric](10, 8) NULL,
[Top80AllTime] [nvarchar](10) NULL,
[DataContribution12Mos] [numeric](10, 8) NULL,
[RunningDataContribution12Mos] [numeric](10, 8) NULL,
[Top8012Mos] [nvarchar](10) NULL,
[ConductedICCVs] [int] NULL
) ON [PRIMARY]
GO