/****** Object:  Table [dbo].[C_B_LU_PHONE_VLDTN_STS]    Script Date: 4/5/2023 3:58:38 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[C_B_LU_PHONE_VLDTN_STS](
	[ROWID_OBJECT] [nchar](14) NOT NULL,
	[CREATOR] [nvarchar](50) NULL,
	[CREATE_DATE] [datetime2](7) NULL,
	[UPDATED_BY] [nvarchar](50) NULL,
	[LAST_UPDATE_DATE] [datetime2](7) NULL,
	[CONSOLIDATION_IND] [bigint] NOT NULL,
	[DELETED_IND] [bigint] NULL,
	[DELETED_BY] [nvarchar](50) NULL,
	[DELETED_DATE] [datetime2](7) NULL,
	[LAST_ROWID_SYSTEM] [nchar](14) NOT NULL,
	[DIRTY_IND] [bigint] NULL,
	[INTERACTION_ID] [bigint] NULL,
	[HUB_STATE_IND] [bigint] NOT NULL,
	[CM_DIRTY_IND] [bigint] NULL,
	[REF_PHONE_VLDTN_STATUS] [nvarchar](50) NOT NULL,
	[REF_PHONE_VLDTN_DESC] [nvarchar](100) NULL,
	[SNOW_VLDTN_MESSAGE] [nvarchar](100) NULL,
	[REFRESH_FREQUENCY] [bigint] NULL,
 CONSTRAINT [SVR1_PYMW6B] PRIMARY KEY CLUSTERED 
(
	[ROWID_OBJECT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_DATA],
 CONSTRAINT [SVR1_Q7RXF1] UNIQUE NONCLUSTERED 
(
	[REF_PHONE_VLDTN_STATUS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_DATA]
) ON [CMX_DATA]
GO
/****** Object:  Table [dbo].[C_B_PARTY_COMM]    Script Date: 4/5/2023 3:58:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[C_B_PARTY_COMM](
	[ROWID_OBJECT] [nchar](14) NOT NULL,
	[CREATOR] [nvarchar](50) NULL,
	[CREATE_DATE] [datetime2](7) NULL,
	[UPDATED_BY] [nvarchar](50) NULL,
	[LAST_UPDATE_DATE] [datetime2](7) NULL,
	[CONSOLIDATION_IND] [bigint] NOT NULL,
	[DELETED_IND] [bigint] NULL,
	[DELETED_BY] [nvarchar](50) NULL,
	[DELETED_DATE] [datetime2](7) NULL,
	[LAST_ROWID_SYSTEM] [nchar](14) NOT NULL,
	[DIRTY_IND] [bigint] NULL,
	[INTERACTION_ID] [bigint] NULL,
	[HUB_STATE_IND] [bigint] NOT NULL,
	[CM_DIRTY_IND] [bigint] NULL,
	[PARTY_ID] [nchar](14) NULL,
	[COMM_TYP_CD] [nvarchar](25) NULL,
	[COMM_VAL] [nvarchar](256) NULL,
	[STATUS_CD] [nvarchar](50) NULL,
	[PRIMARY_FLG] [nchar](1) NULL,
	[DO_NOT_CNTCT_IND] [nchar](1) NULL,
	[PREF_IND] [nchar](1) NULL,
	[OPT_IN] [nchar](1) NULL,
	[AREA_CD] [nvarchar](50) NULL,
	[OVERRIDE_TRUST_IND] [nchar](1) NULL,
	[EVENT_TYP] [nvarchar](50) NULL,
	[COMM_USG] [nvarchar](25) NULL,
	[OVERRIDE_TRUST_RSN] [nvarchar](200) NULL,
	[BOUNCEBACK_IND] [nchar](1) NULL,
	[BOUNCEBACK_DATE] [datetime2](0) NULL,
	[UNSUBSCRIBE_IND] [nchar](1) NULL,
	[UNSUBSCRIBE_DATE] [datetime2](0) NULL,
	[ORIG_COMM_VALUE] [nvarchar](256) NULL,
	[EXPLICIT_CONSENT_DATE] [datetime2](0) NULL,
	[EXPLICIT_CONSENT_SOURCE] [nvarchar](100) NULL,
	[REF_EMAIL_VERBOSE_STS] [nvarchar](50) NULL,
	[REF_PHONE_VERBOSE_STS] [nvarchar](50) NULL,
	[REF_PHONE_TYPE] [nvarchar](50) NULL,
	[REF_PHONE_TIMEZONE] [nvarchar](50) NULL,
	[REF_PHONE_CNTRY] [nvarchar](50) NULL,
	[REF_PHONE_CITY] [nvarchar](200) NULL,
	[REF_PHONE_INTL_FORMAT] [nvarchar](50) NULL,
	[REF_PHONE_E164_FORMAT] [nvarchar](50) NULL,
 CONSTRAINT [SVR1_1XO7] PRIMARY KEY CLUSTERED 
(
	[ROWID_OBJECT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_DATA]
) ON [CMX_DATA]
GO
/****** Object:  Table [dbo].[C_B_PARTY_COMM_XREF]    Script Date: 4/5/2023 3:58:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[C_B_PARTY_COMM_XREF](
	[ROWID_XREF] [bigint] NOT NULL,
	[PKEY_SRC_OBJECT] [nvarchar](255) NULL,
	[ROWID_OBJECT] [nchar](14) NOT NULL,
	[ROWID_SYSTEM] [nchar](14) NOT NULL,
	[SRC_LUD] [datetime2](7) NULL,
	[PUT_UPDATE_MERGE_IND] [bigint] NULL,
	[INTERACTION_ID] [bigint] NULL,
	[HUB_STATE_IND] [bigint] NOT NULL,
	[PROMOTE_IND] [bigint] NULL,
	[NULL_INDICATOR_BITMAP] [nvarchar](1000) NULL,
	[PERIOD_START_DATE] [datetime2](7) NULL,
	[PERIOD_END_DATE] [datetime2](7) NULL,
	[CREATOR] [nvarchar](50) NULL,
	[CREATE_DATE] [datetime2](7) NULL,
	[UPDATED_BY] [nvarchar](50) NULL,
	[LAST_UPDATE_DATE] [datetime2](7) NULL,
	[DELETED_IND] [bigint] NULL,
	[DELETED_BY] [nvarchar](50) NULL,
	[DELETED_DATE] [datetime2](7) NULL,
	[ORIG_ROWID_OBJECT] [nchar](14) NOT NULL,
	[STG_ROWID_TABLE] [nchar](14) NULL,
	[PARTY_ID] [bigint] NULL,
	[COMM_TYP_CD] [nvarchar](25) NULL,
	[COMM_VAL] [nvarchar](256) NULL,
	[STATUS_CD] [nvarchar](50) NULL,
	[PRIMARY_FLG] [nchar](1) NULL,
	[DO_NOT_CNTCT_IND] [nchar](1) NULL,
	[PREF_IND] [nchar](1) NULL,
	[OPT_IN] [nchar](1) NULL,
	[AREA_CD] [nvarchar](50) NULL,
	[S_COMM_TYP_CD] [nvarchar](255) NULL,
	[S_PARTY_ID] [nvarchar](255) NULL,
	[OVERRIDE_TRUST_IND] [nchar](1) NULL,
	[EVENT_TYP] [nvarchar](50) NULL,
	[COMM_USG] [nvarchar](25) NULL,
	[S_COMM_USG] [nvarchar](255) NULL,
	[OVERRIDE_TRUST_RSN] [nvarchar](200) NULL,
	[BOUNCEBACK_IND] [nchar](1) NULL,
	[BOUNCEBACK_DATE] [datetime2](0) NULL,
	[UNSUBSCRIBE_IND] [nchar](1) NULL,
	[UNSUBSCRIBE_DATE] [datetime2](0) NULL,
	[ORIG_COMM_VALUE] [nvarchar](256) NULL,
	[EXPLICIT_CONSENT_DATE] [datetime2](0) NULL,
	[EXPLICIT_CONSENT_SOURCE] [nvarchar](100) NULL,
	[REF_EMAIL_VERBOSE_STS] [nvarchar](50) NULL,
	[REF_PHONE_VERBOSE_STS] [nvarchar](50) NULL,
	[REF_PHONE_TYPE] [nvarchar](50) NULL,
	[REF_PHONE_TIMEZONE] [nvarchar](50) NULL,
	[REF_PHONE_CNTRY] [nvarchar](50) NULL,
	[REF_PHONE_CITY] [nvarchar](200) NULL,
	[REF_PHONE_INTL_FORMAT] [nvarchar](50) NULL,
	[REF_PHONE_E164_FORMAT] [nvarchar](50) NULL,
	[S_REF_EMAIL_VERBOSE_STS] [nvarchar](255) NULL,
	[S_REF_PHONE_VERBOSE_STS] [nvarchar](255) NULL,
 CONSTRAINT [SVR1_1XSC] PRIMARY KEY CLUSTERED 
(
	[ROWID_XREF] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_DATA]
) ON [CMX_DATA]
GO
/****** Object:  Table [dbo].[MDM_TRUST_SCORE]    Script Date: 4/5/2023 3:58:39 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MDM_TRUST_SCORE](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CREATE_DATE] [datetime2](7) NULL,
	[TYPE] [nvarchar](50) NULL,
	[SOURCE_SYSTEM] [nvarchar](50) NULL,
	[SCORE] [int] NULL
) ON [CMX_DATA]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_PYMW6C]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_PYMW6C] ON [dbo].[C_B_LU_PHONE_VLDTN_STS]
(
	[CONSOLIDATION_IND] ASC,
	[ROWID_OBJECT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_Q7RXF0]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_Q7RXF0] ON [dbo].[C_B_LU_PHONE_VLDTN_STS]
(
	[REF_PHONE_VLDTN_STATUS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NI_C_B_PARTY_COMM_3]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [NI_C_B_PARTY_COMM_3] ON [dbo].[C_B_PARTY_COMM]
(
	[HUB_STATE_IND] ASC,
	[COMM_TYP_CD] ASC,
	[COMM_VAL] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NI_C_B_PARTY_COMM_5]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [NI_C_B_PARTY_COMM_5] ON [dbo].[C_B_PARTY_COMM]
(
	[HUB_STATE_IND] ASC,
	[LAST_UPDATE_DATE] ASC,
	[COMM_TYP_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [NI_C_B_PARTY_COMM_6]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [NI_C_B_PARTY_COMM_6] ON [dbo].[C_B_PARTY_COMM]
(
	[HUB_STATE_IND] ASC,
	[PARTY_ID] ASC,
	[COMM_TYP_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_1XO8]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_1XO8] ON [dbo].[C_B_PARTY_COMM]
(
	[CONSOLIDATION_IND] ASC,
	[ROWID_OBJECT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_20VY]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_20VY] ON [dbo].[C_B_PARTY_COMM]
(
	[COMM_TYP_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_ENPK9I]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_ENPK9I] ON [dbo].[C_B_PARTY_COMM]
(
	[LAST_ROWID_SYSTEM] ASC,
	[COMM_TYP_CD] ASC,
	[COMM_VAL] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_I1OUZY]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_I1OUZY] ON [dbo].[C_B_PARTY_COMM]
(
	[COMM_USG] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_KXTZUR]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_KXTZUR] ON [dbo].[C_B_PARTY_COMM]
(
	[PARTY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_Q7RY24]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_Q7RY24] ON [dbo].[C_B_PARTY_COMM]
(
	[REF_EMAIL_VERBOSE_STS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_Q7RY3E]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_Q7RY3E] ON [dbo].[C_B_PARTY_COMM]
(
	[REF_PHONE_VERBOSE_STS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_WTFR4W]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_WTFR4W] ON [dbo].[C_B_PARTY_COMM]
(
	[HUB_STATE_IND] ASC,
	[CONSOLIDATION_IND] ASC
)
INCLUDE ( 	[ROWID_OBJECT],
	[PARTY_ID],
	[COMM_TYP_CD],
	[COMM_VAL],
	[COMM_USG]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_DATA]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_ZVNPF8]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_ZVNPF8] ON [dbo].[C_B_PARTY_COMM]
(
	[COMM_VAL] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
/****** Object:  Index [SVR1_118W35P]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_118W35P] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[INTERACTION_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
/****** Object:  Index [SVR1_11HQXXK]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_11HQXXK] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[PARTY_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_15B5FAU]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_15B5FAU] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[COMM_TYP_CD] ASC,
	[HUB_STATE_IND] ASC,
	[LAST_UPDATE_DATE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_1XSD]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_1XSD] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[ORIG_ROWID_OBJECT] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_1XSE]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_1XSE] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[ROWID_OBJECT] ASC,
	[ROWID_SYSTEM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_1XSF]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE UNIQUE NONCLUSTERED INDEX [SVR1_1XSF] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[PKEY_SRC_OBJECT] ASC,
	[ROWID_SYSTEM] ASC,
	[HUB_STATE_IND] ASC,
	[PERIOD_START_DATE] ASC,
	[PERIOD_END_DATE] 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 [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_20W0]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_20W0] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[COMM_TYP_CD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_I1OV00]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_I1OV00] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[COMM_USG] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_Q7RY26]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_Q7RY26] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[REF_EMAIL_VERBOSE_STS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
SET ANSI_PADDING ON
GO
/****** Object:  Index [SVR1_Q7RY3G]    Script Date: 4/5/2023 3:58:39 AM ******/
CREATE NONCLUSTERED INDEX [SVR1_Q7RY3G] ON [dbo].[C_B_PARTY_COMM_XREF]
(
	[REF_PHONE_VERBOSE_STS] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [CMX_INDX]
GO
ALTER TABLE [dbo].[C_B_LU_PHONE_VLDTN_STS] ADD  CONSTRAINT [DF_C_B_LU_PHONE_VLDTN_STS_CREATOR]  DEFAULT ('CMX') FOR [CREATOR]
GO
ALTER TABLE [dbo].[C_B_LU_PHONE_VLDTN_STS] ADD  CONSTRAINT [DF_C_B_LU_PHONE_VLDTN_STS_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
GO
ALTER TABLE [dbo].[C_B_LU_PHONE_VLDTN_STS] ADD  CONSTRAINT [DF_C_B_LU_PHONE_VLDTN_STS_CONSOLIDATION_IND]  DEFAULT ((4)) FOR [CONSOLIDATION_IND]
GO
ALTER TABLE [dbo].[C_B_LU_PHONE_VLDTN_STS] ADD  CONSTRAINT [DF_C_B_LU_PHONE_VLDTN_STS_HUB_STATE_IND]  DEFAULT ((1)) FOR [HUB_STATE_IND]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_CREATOR]  DEFAULT ('CMX') FOR [CREATOR]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_CONSOLIDATION_IND]  DEFAULT ((4)) FOR [CONSOLIDATION_IND]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_HUB_STATE_IND]  DEFAULT ((1)) FOR [HUB_STATE_IND]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM_XREF] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_XREF_HUB_STATE_IND]  DEFAULT ((1)) FOR [HUB_STATE_IND]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM_XREF] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_XREF_CREATOR]  DEFAULT ('CMX') FOR [CREATOR]
GO
ALTER TABLE [dbo].[C_B_PARTY_COMM_XREF] ADD  CONSTRAINT [DF_C_B_PARTY_COMM_XREF_CREATE_DATE]  DEFAULT (getdate()) FOR [CREATE_DATE]
GO