Skip to content

MasterHRCM Table Design Schema

DataBase Name:MasterHRCM

Table Name:CMS_DrugDxCode

Description:

Describes Standard Drug codes based on Drugs and DrugType.

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[CMS_DrugDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CMS_DrugDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [MainTerm] [varchar](100) NULL,
    [Level1] [varchar](1000) NULL,
    [Level2] [varchar](1000) NULL,
    [Level3] [varchar](1000) NULL,
    [Level4] [varchar](1000) NULL,
    [FinalLevel] [varchar](1000) NULL,
    [Level] [int] NOT NULL,
    [Nemod] [varchar](600) NULL,
    [Key] [varchar](500) NULL,
    [Value] [varchar](500) NULL,
    [Substance] [varchar](100) NULL,
    [DrugType] [varchar](100) NULL,
    [Code] [varchar](50) NULL,
    [Status] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:CMS_DxCodeDesc

Description:

Describes Standard ICD10 Diagnosis codes and its description and related information.

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[CMS_DxCodeDesc]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CMS_DxCodeDesc](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ICDCode] [varchar](10) NULL,
    [ICD10Code] [varchar](10) NULL,
    [Status] [int] NULL,
    [ShortDesc] [varchar](250) NULL,
    [LongDesc] [varchar](250) NULL,
    [Chronic] [tinyint] NULL,
    [ObStatus] [tinyint] NULL,
    [FStatus] [int] NULL,
    [EffectiveYearFrom] [varchar](30) NULL,
    [EffectiveYearTo] [varchar](30) NULL,
    [GroupId] [varchar](10) NULL,
    [IcdLevel] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CMS_DxCodeDesc] ADD  CONSTRAINT [DF_CMS_DxCodeDesc_FStatus]  DEFAULT ((0)) FOR [FStatus]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:CMS_PcsCodeDesc

Description:

Describes Standard ICD10 Procedure codes and its description and related information.

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[CMS_PcsCodeDesc]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CMS_PcsCodeDesc](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [CPTCode] [varchar](20) NULL,
    [Status] [int] NULL,
    [ShortDesc] [varchar](250) NULL,
    [LongDesc] [varchar](250) NULL,
    [EffectiveYearFrom] [varchar](30) NULL,
    [EffectiveYearTo] [varchar](30) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_AllergiesDxCode

Description:

Knowledge based table which consits of ICD10 codes related to allergy Disorders and it can be mapped using NumericId.

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_AllergiesDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_AllergiesDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [Disorder] [varchar](255) NULL,
    [IcdCode1] [varchar](10) NULL,
    [Status] [int] NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Cause

Description:

Knowledge based table which consits of causes related to Disorders and it can be mapped using NumericId.

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Cause]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Cause](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [CauseId] [int] NULL,
    [Cause] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Cause] ADD  CONSTRAINT [DF_KB_Cause_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Cause] ADD  CONSTRAINT [DF_KB_Cause_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ChfDxCode

Description:

Knowledge based table which consits of Codes related to CHF and getting final code by using combination of these codes.

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ChfDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ChfDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [CHF1] [varchar](20) NULL,
    [CHF2] [varchar](20) NULL,
    [FinalCode] [varchar](20) NULL,
    [Tconcept1] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_ChfDxCode] ADD  CONSTRAINT [DF_KB_ChfDxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Disorder

Description:

Knowledge based table which consits of All Disorders and it can be mapped using NumericId.

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Disorder]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Disorder](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [Disorder] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Disorder] ADD  CONSTRAINT [DF_KB_Disorder_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Disorder] ADD  CONSTRAINT [DF_KB_Disorder_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxCode

Description:

Knowledge based table which consits of all combinations of NumericIds like Disorder,Cause,Site,Site1,...and using those NumericIds we can get Final ICD10 Diagnosis Code by our Analysis Application.

Schema:

 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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [CauseId] [int] NOT NULL,
    [SiteId] [int] NOT NULL,
    [Site1Id] [int] NOT NULL,
    [Site2Id] [int] NOT NULL,
    [ManifestationId] [int] NOT NULL,
    [ExtensionId] [varchar](10) NULL,
    [Stage] [int] NOT NULL,
    [Type] [int] NOT NULL,
    [History] [varchar](10) NULL,
    [TemporalConcept1] [int] NOT NULL,
    [TemporalConcept2] [int] NOT NULL,
    [IcdCode1] [varchar](10) NULL,
    [IcdCode2] [varchar](10) NULL,
    [IcdCode3] [varchar](10) NULL,
    [Status] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL,
    [TemplateId] [int] NULL,
    [ckstatus] [int] NOT NULL,
    [Neonatal] [int] NULL,
    [Gender] [int] NOT NULL,
    [Icdcode4] [varchar](10) NULL,
    [Icdcode5] [varchar](10) NULL,
    [Icdcode6] [varchar](10) NULL,
    [obStatus] [tinyint] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_ckstatus]  DEFAULT ((0)) FOR [ckstatus]
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_Neonatal]  DEFAULT ((0)) FOR [Neonatal]
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_Gender]  DEFAULT ((0)) FOR [Gender]
GO
ALTER TABLE [dbo].[KB_DxCode] ADD  CONSTRAINT [DF_KB_DxCode_obStatus]  DEFAULT ((0)) FOR [obStatus]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxCodeCombination

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxCodeCombination]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxCodeCombination](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [dx] [varchar](20) NULL,
    [dxcomb] [varchar](20) NULL,
    [GroupId] [int] NULL,
    [count] [int] NULL,
    [Content] [varchar](500) NULL,
    [DisorderId] [int] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxCodeFirst

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxCodeFirst]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxCodeFirst](
    [internalid] [int] IDENTITY(1,1) NOT NULL,
    [CODE] [varchar](50) NULL,
    [CodeFirst] [varchar](500) NULL,
    [rstatus] [int] NULL,
    [LASTMODIFY] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
    [internalid] 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
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxExclusionCode

Description:

Knowledge based table which consits of Excluded ICD10 codes based on Priority and Disease Group.Lowest priority means Most Specific code and Highest Priority means Less Specific Diagnosis code.

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxExclusionCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxExclusionCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [IcdCode] [varchar](50) NULL,
    [Priority] [int] NULL,
    [GroupId] [int] NULL,
    [GroupName] [nvarchar](255) NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_DxExclusionCode] ADD  CONSTRAINT [DF_KB_DxExclusionCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxFactorCombination

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxFactorCombination]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxFactorCombination](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ICDCode] [varchar](20) NULL,
    [FactorName] [varchar](200) NULL,
    [TargetCode] [varchar](20) NULL,
    [CombCount] [tinyint] NULL,
    [GroupId] [int] NULL,
    [RStatus] [tinyint] NULL,
    [LastModify] [datetime] NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_DxFactorCombination] ADD  CONSTRAINT [DF_KB_DxFactorCombination_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_DxTabExclusion1Code

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_DxTabExclusion1Code]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_DxTabExclusion1Code](
    [Internalid] [int] IDENTITY(1,1) NOT NULL,
    [Code1] [varchar](50) NULL,
    [Code2] [varchar](50) NULL,
    [Rstatus] [int] NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_DxTabExclusion1Code] ADD  CONSTRAINT [DF_KB_DxTabExclusion1Code_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_HabitsDxCode

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_HabitsDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_HabitsDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NOT NULL,
    [Disorder] [varchar](255) NULL,
    [Type] [varchar](255) NULL,
    [IcdCode1] [varchar](50) NULL,
    [History] [varchar](10) NULL,
    [Status] [int] NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_HabitsDxCode] ADD  CONSTRAINT [DF_KB_HabitsDxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_HivDxCode

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_HivDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[KB_HivDxCode](
    [A1Code] [nvarchar](10) NULL,
    [A2Code] [nvarchar](10) NULL,
    [FinalCode] [nvarchar](10) NULL,
    [Status] [int] NULL
) ON [PRIMARY]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_HtnDxCode

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_HtnDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_HtnDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [CHF] [varchar](50) NULL,
    [CKD] [varchar](50) NULL,
    [FinalCode] [varchar](50) NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_HtnDxCode] ADD  CONSTRAINT [DF_KB_HtnDxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_LongTermDrugDxCode

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_LongTermDrugDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_LongTermDrugDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ICDCode] [varchar](10) NULL,
    [Description] [varchar](100) NULL,
    [DrugName] [varchar](500) NULL,
    [DrugCTZ] [varchar](50) NULL,
    [RStatus] [int] NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_LongTermDrugDxCode] ADD  CONSTRAINT [DF_KB_LongTermDrugDxCode_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[KB_LongTermDrugDxCode] ADD  CONSTRAINT [DF_KB_LongTermDrugDxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Manifestation

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Manifestation]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Manifestation](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ManifestationId] [int] NOT NULL,
    [Manifestation] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Manifestation] ADD  CONSTRAINT [DF_KB_Manifestation_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Manifestation] ADD  CONSTRAINT [DF_KB_Manifestation_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ObgComplication

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ObgComplication]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ObgComplication](
    [internalid] [int] IDENTITY(1,1) NOT NULL,
    [code] [varchar](50) NULL,
    [Icd10code] [varchar](50) NULL,
    [trimester] [varchar](1000) NULL,
    [trimstatus] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ObgDeliveryStatus

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ObgDeliveryStatus]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ObgDeliveryStatus](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [FetusCount] [varchar](50) NULL,
    [StillBirthStatus] [varchar](500) NULL,
    [TargetCode] [varchar](50) NULL,
    [CodeDescription] [varchar](700) NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_ObgDeliveryStatus] ADD  CONSTRAINT [DF_KB_ObgDeliveryStatus_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ObgDisorder

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ObgDisorder]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ObgDisorder](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [Disorder] [varchar](500) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_ObgDisorder] ADD  CONSTRAINT [DF_KB_ObgDisorder_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ObgDxCode

Description:

Schema:

 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
38
39
40
41
42
43
44
45
46
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ObgDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ObgDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [CauseId] [int] NOT NULL,
    [SiteId] [int] NOT NULL,
    [Site1Id] [int] NOT NULL,
    [Site2Id] [int] NOT NULL,
    [ManifestationId] [int] NOT NULL,
    [ExtensionId] [int] NULL,
    [Stage] [int] NOT NULL,
    [Type] [int] NOT NULL,
    [History] [varchar](50) NOT NULL,
    [TemporalConcept1] [int] NOT NULL,
    [TemporalConcept2] [int] NOT NULL,
    [IcdCode1] [varchar](10) NULL,
    [IcdCode2] [varchar](10) NULL,
    [IcdCode3] [varchar](10) NULL,
    [Status] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL,
    [TemplateId] [int] NULL,
    [ckstatus] [int] NOT NULL,
    [Neonatal] [int] NULL,
    [Gender] [int] NOT NULL,
    [Pstatus] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_ObgDxCode] ADD  CONSTRAINT [DF_KB_ObgDxCode_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_ObgDxCode] ADD  CONSTRAINT [DF_KB_ObgDxCode_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO
ALTER TABLE [dbo].[KB_ObgDxCode] ADD  CONSTRAINT [DF_KB_ObgDxCode_ckstatus]  DEFAULT ((0)) FOR [ckstatus]
GO
ALTER TABLE [dbo].[KB_ObgDxCode] ADD  CONSTRAINT [DF_KB_ObgDxCode_Gender]  DEFAULT ((0)) FOR [Gender]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_ObgInfectiousCrosswalk

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_ObgInfectiousCrosswalk]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_ObgInfectiousCrosswalk](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ObgCode] [varchar](50) NULL,
    [Icdcode] [varchar](50) NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_PcsDxExclusion

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_PcsDxExclusion]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_PcsDxExclusion](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DxCode] [varchar](10) NOT NULL,
    [PCSCode] [varchar](10) NOT NULL,
    [Status] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_PcsDxExclusion] ADD  CONSTRAINT [DF_KB_PcsDxExclusion_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_PcsDxExclusion] ADD  CONSTRAINT [DF_KB_PcsDxExclusion_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Site

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Site]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Site](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [SiteId] [int] NOT NULL,
    [Site] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Site] ADD  CONSTRAINT [DF_KB_Site_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Site] ADD  CONSTRAINT [DF_KB_Site_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Site1

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Site1]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Site1](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Site1Id] [int] NULL,
    [Site] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Site1] ADD  CONSTRAINT [DF_KB_Site1_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Site1] ADD  CONSTRAINT [DF_KB_Site1_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Site2

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Site2]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Site2](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Site2Id] [int] NULL,
    [Site] [varchar](250) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_Site2] ADD  CONSTRAINT [DF_KB_Site2_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_Site2] ADD  CONSTRAINT [DF_KB_Site2_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_SurgicalDxCode

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_SurgicalDxCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_SurgicalDxCode](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [DisorderId] [int] NULL,
    [Disorder] [varchar](100) NULL,
    [Icdcode1] [varchar](50) NULL,
    [Icdcode2] [varchar](50) NULL,
    [Status] [int] NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_SurgicalDxCode] ADD  CONSTRAINT [DF_KB_SurgicalDxCode_Status]  DEFAULT ((0)) FOR [Status]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_TemporalConcept1

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_TemporalConcept1]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_TemporalConcept1](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [TConcept1Id] [int] NULL,
    [TConcept1] [varchar](50) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_TemporalConcept1] ADD  CONSTRAINT [DF_KB_TemporalConcept1_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_TemporalConcept1] ADD  CONSTRAINT [DF_KB_TemporalConcept1_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_TemporalConcept2

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_TemporalConcept2]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_TemporalConcept2](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [TConcept2Id] [int] NULL,
    [TConcept2] [varchar](50) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_TemporalConcept2] ADD  CONSTRAINT [DF_KB_TemporalConcept2_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[KB_TemporalConcept2] ADD  CONSTRAINT [DF_KB_TemporalConcept2_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_Type

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_Type]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_Type](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [TypeId] [int] NULL,
    [Type] [varchar](50) NULL,
    [Status] [int] NOT NULL,
    [UniqueId] [int] NULL,
    [LastModify] [datetime] NOT NULL,
    [UserName] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_VSeriesCore

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_VSeriesCore]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_VSeriesCore](
    [InternalID] [int] IDENTITY(1,1) NOT NULL,
    [Event] [varchar](50) NULL,
    [Victim] [varchar](50) NULL,
    [VTVehicle] [varchar](50) NULL,
    [OPVehicle] [varchar](50) NULL,
    [Traffic] [varchar](50) NULL,
    [Encounter] [varchar](50) NULL,
    [Code] [varchar](10) NULL,
    [Rstatus] [tinyint] NULL,
    [UserName] [varchar](50) NULL,
    [Lastmodify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_VSeriesCore] ADD  CONSTRAINT [DF_KB_VSeriesCore_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[KB_VSeriesCore] ADD  CONSTRAINT [DF_KB_VSeriesCore_Lastmodify]  DEFAULT (getdate()) FOR [Lastmodify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_WSeriesCoreData

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_WSeriesCoreData]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_WSeriesCoreData](
    [internalid] [int] IDENTITY(1,1) NOT NULL,
    [codeseries] [varchar](10) NULL,
    [StandardDisorder] [varchar](150) NULL,
    [keyterm] [varchar](100) NULL,
    [keytype] [varchar](50) NULL,
    [code] [varchar](10) NULL,
    [lastmodify] [datetime] NULL,
    [rstatus] [int] NULL,
    [action] [varchar](100) NULL,
    [username] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_WSeriesCoreData] ADD  CONSTRAINT [DF_KB_WSeriesCoreData_lastmodify]  DEFAULT (getdate()) FOR [lastmodify]
GO
ALTER TABLE [dbo].[KB_WSeriesCoreData] ADD  CONSTRAINT [DF_KB_WSeriesCoreData_rstatus]  DEFAULT ((0)) FOR [rstatus]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:KB_YSeriesActivity

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[KB_YSeriesActivity]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[KB_YSeriesActivity](
    [InternalId] [tinyint] IDENTITY(1,1) NOT NULL,
    [Activity] [varchar](150) NULL,
    [Place] [varchar](100) NULL,
    [Code] [varchar](50) NULL,
    [rstatus] [tinyint] NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[KB_YSeriesActivity] ADD  CONSTRAINT [DF_KB_YSeriesActivity_rstatus]  DEFAULT ((0)) FOR [rstatus]
GO
ALTER TABLE [dbo].[KB_YSeriesActivity] ADD  CONSTRAINT [DF_KB_YSeriesActivity_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_Address

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_Address]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_Address](
    [AddressID] [int] IDENTITY(1,1) NOT NULL,
    [Address1] [varchar](80) NOT NULL,
    [Address2] [varchar](80) NULL,
    [Address3] [varchar](80) NULL,
    [City] [varchar](80) NOT NULL,
    [RegionName] [varchar](80) NOT NULL,
    [StateProvince] [varchar](80) NOT NULL,
    [Country] [varchar](80) NOT NULL,
    [PostalCode] [varchar](8) NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_Address] PRIMARY KEY CLUSTERED 
(
    [AddressID] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_Address] ADD  CONSTRAINT [DF_MST_Address_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_Address] ADD  CONSTRAINT [DF_MST_Address_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_ArthroplastyDevice

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_ArthroplastyDevice]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ArthroplastyDevice](
    [Internalid] [int] IDENTITY(1,1) NOT NULL,
    [Operation] [varchar](50) NULL,
    [Bodypart] [varchar](50) NULL,
    [DeviceSynonym] [varchar](50) NULL,
    [Device] [varchar](50) NULL,
    [Lastmodify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ArthroplastyDevice] ADD  CONSTRAINT [DF_MST_ArthroplastyDevice_Lastmodify]  DEFAULT (getdate()) FOR [Lastmodify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_DeviceExclusion

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_DeviceExclusion]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DeviceExclusion](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Device] [varchar](100) NULL,
    [Priority] [int] NULL,
    [GroupId] [int] NULL,
    [GroupName] [nvarchar](255) NULL,
    [Status] [int] NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DeviceExclusion] ADD  CONSTRAINT [DF_MST_DeviceExclusion_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[MST_DeviceExclusion] ADD  CONSTRAINT [DF_MST_DeviceExclusion_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_DxExclusionType

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_DxExclusionType]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DxExclusionType](
    [DxExclusionTypeId] [int] NOT NULL,
    [ExclusionDesc] [varchar](50) NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_DxExclusionType] PRIMARY KEY CLUSTERED 
(
    [DxExclusionTypeId] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DxExclusionType] ADD  CONSTRAINT [DF_MST_DxExclusionType_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[MST_DxExclusionType] ADD  CONSTRAINT [DF_MST_DxExclusionType_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DxExclusionType] ADD  CONSTRAINT [DF_MST_DxExclusionType_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_Hospital

Description:

Schema:

 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
38
39
40
41
42
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_Hospital]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_Hospital](
    [HospitalID] [int] IDENTITY(1,1) NOT NULL,
    [HospitalName] [varchar](80) NOT NULL,
    [HospitalAliasName] [varchar](80) NULL,
    [HospitalGroupID] [int] NOT NULL,
    [AddressID] [int] NOT NULL,
    [Active] [bit] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_Hospital] PRIMARY KEY CLUSTERED 
(
    [HospitalID] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_Hospital]  WITH CHECK ADD  CONSTRAINT [FK_MST_Hospital_MST_Address] FOREIGN KEY([AddressID])
REFERENCES [dbo].[MST_Address] ([AddressID])
GO
ALTER TABLE [dbo].[MST_Hospital] CHECK CONSTRAINT [FK_MST_Hospital_MST_Address]
GO
ALTER TABLE [dbo].[MST_Hospital]  WITH CHECK ADD  CONSTRAINT [FK_MST_Hospital_MST_HospitalGroup] FOREIGN KEY([HospitalGroupID])
REFERENCES [dbo].[MST_HospitalGroup] ([HospitalGroupId])
GO
ALTER TABLE [dbo].[MST_Hospital] CHECK CONSTRAINT [FK_MST_Hospital_MST_HospitalGroup]
GO
ALTER TABLE [dbo].[MST_Hospital] ADD  CONSTRAINT [DF_MST_Hospital_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_Hospital] ADD  CONSTRAINT [DF_MST_Hospital_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_Hospital] ADD  CONSTRAINT [DF_MST_Hospital_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_HospitalGroup

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_HospitalGroup]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_HospitalGroup](
    [HospitalGroupId] [int] IDENTITY(1,1) NOT NULL,
    [HospitalGroupName] [varchar](80) NULL,
    [Active] [bit] NOT NULL,
    [AddressID] [int] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_HospitalGroup] PRIMARY KEY CLUSTERED 
(
    [HospitalGroupId] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_HospitalGroup]  WITH CHECK ADD  CONSTRAINT [FK_MST_HospitalGroup_MST_Address] FOREIGN KEY([AddressID])
REFERENCES [dbo].[MST_Address] ([AddressID])
GO
ALTER TABLE [dbo].[MST_HospitalGroup] CHECK CONSTRAINT [FK_MST_HospitalGroup_MST_Address]
GO
ALTER TABLE [dbo].[MST_HospitalGroup] ADD  CONSTRAINT [DF_MST_HospitalGroup_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_HospitalGroup] ADD  CONSTRAINT [DF_MST_HospitalGroup_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_HospitalGroup] ADD  CONSTRAINT [DF_MST_HospitalGroup_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_ListFile

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_ListFile]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ListFile](
    [ListFileId] [int] IDENTITY(1,1) NOT NULL,
    [DefName] [varchar](50) NULL,
    [DefPath] [varchar](150) NULL,
    [ListName] [varchar](50) NULL,
    [MajorType] [varchar](50) NULL,
    [MinorType] [varchar](50) NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_DefFile] PRIMARY KEY CLUSTERED 
(
    [ListFileId] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ListFile] ADD  CONSTRAINT [DF_MST_DefFile_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_ListFile] ADD  CONSTRAINT [DF_MST_DefFile_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_ListFile] ADD  CONSTRAINT [DF_Table_1_Modifieddate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_ListTerm

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_ListTerm]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ListTerm](
    [ListTermId] [int] IDENTITY(1,1) NOT NULL,
    [ListFileId] [int] NOT NULL,
    [Term] [varchar](max) NULL,
    [STY] [varchar](150) NULL,
    [TUI] [varchar](80) NULL,
    [CUI] [varchar](80) NULL,
    [SnomedCtId] [varchar](80) NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_ListTerm] PRIMARY KEY CLUSTERED 
(
    [ListTermId] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ListTerm] ADD  CONSTRAINT [DF_MST_ListTerm_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_ListTerm] ADD  CONSTRAINT [DF_MST_ListTerm_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_ListTerm] ADD  CONSTRAINT [DF_MST_ListTerm_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSBodyPart

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSBodyPart]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSBodyPart](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [BodyPart] [varchar](100) NULL,
    [Site] [varchar](100) NULL,
    [Site0] [varchar](100) NULL,
    [Site1] [varchar](50) NULL,
    [Status] [int] NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSBodyPart] ADD  CONSTRAINT [DF_MST_PCSBodyPart_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[MST_PCSBodyPart] ADD  CONSTRAINT [DF_MST_PCSBodyPart_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSBodyPartSynonym

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSBodyPartSynonym]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSBodyPartSynonym](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [BodyPart] [varchar](250) NOT NULL,
    [BodyPartSynonym] [varchar](250) NOT NULL,
    [BodyPartLoc] [varchar](50) NULL,
    [CommonName] [varchar](50) NULL,
    [Operation] [varchar](150) NULL,
    [RStatus] [int] NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSBodyPartSynonym] ADD  CONSTRAINT [DF_MST_PCSBodyPartSynonym_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[MST_PCSBodyPartSynonym] ADD  CONSTRAINT [DF_MST_PCSBodyPartSynonym_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSDevice

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSDevice]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSDevice](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [GroupId] [int] NULL,
    [Device] [varchar](500) NULL,
    [Device1] [varchar](100) NULL,
    [Rstatus] [tinyint] NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSDevice] ADD  CONSTRAINT [DF_MST_PCSDevice_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[MST_PCSDevice] ADD  CONSTRAINT [DF_MST_PCSDevice_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSExclusionByCode

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSExclusionByCode]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSExclusionByCode](
    [PCSExclusionID] [int] IDENTITY(1,1) NOT NULL,
    [ProcCode] [varchar](10) NULL,
    [Priority] [tinyint] NOT NULL,
    [GroupId] [int] NOT NULL,
    [GroupName] [varchar](50) NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_PCSExclusionByCode] PRIMARY KEY CLUSTERED 
(
    [PCSExclusionID] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSExclusionByCode] ADD  CONSTRAINT [DF_MST_PCSExclusionByCode_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_PCSExclusionByCode] ADD  CONSTRAINT [DF_MST_PCSExclusionByCode_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSExclusionByContent

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSExclusionByContent]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSExclusionByContent](
    [PCSExclusionID] [int] IDENTITY(1,1) NOT NULL,
    [PCSId] [varchar](10) NULL,
    [Content] [varchar](200) NULL,
    [Priority] [tinyint] NOT NULL,
    [GroupId] [int] NOT NULL,
    [GroupName] [varchar](50) NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_PCSExclusionByContent] PRIMARY KEY CLUSTERED 
(
    [PCSExclusionID] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSExclusionByContent] ADD  CONSTRAINT [DF_MST_PCSExclusionByContent_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_PCSExclusionByContent] ADD  CONSTRAINT [DF_MST_PCSExclusionByContent_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSOpBodyPart

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSOpBodyPart]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSOpBodyPart](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Operation] [varchar](250) NOT NULL,
    [BodyPart] [varchar](250) NOT NULL,
    [BodyPartLoc] [varchar](50) NULL,
    [Count] [int] NULL,
    [BodyPartSynonym] [varchar](50) NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSOpBodyPart] ADD  CONSTRAINT [DF_MST_PCSOpBodyPart_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSOperation

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSOperation]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSOperation](
    [Internalid] [int] IDENTITY(1,1) NOT NULL,
    [Operation] [varchar](200) NULL,
    [Approach] [varchar](50) NULL,
    [Code] [varchar](50) NULL,
    [RStatus] [int] NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NULL,
    [Gender] [varchar](5) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSOperation] ADD  CONSTRAINT [DF_MST_PCSOperation_Status]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[MST_PCSOperation] ADD  CONSTRAINT [DF_MST_PCSOperation_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO
ALTER TABLE [dbo].[MST_PCSOperation] ADD  CONSTRAINT [DF_MST_PCSOperation_Gender]  DEFAULT ('U') FOR [Gender]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSOpSynonym

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSOpSynonym]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSOpSynonym](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Operation] [varchar](100) NULL,
    [OpSynonym] [varchar](100) NULL,
    [UserName] [varchar](50) NULL,
    [Rstatus] [tinyint] NULL,
    [LastModify] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSOpSynonym] ADD  CONSTRAINT [DF_MST_PCSOpSynonym_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[MST_PCSOpSynonym] ADD  CONSTRAINT [DF_MST_PCSOpSynonym_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSQualifier

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSQualifier]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSQualifier](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [GroupId] [int] NULL,
    [Qualifier] [varchar](100) NULL,
    [Qualifier1] [varchar](100) NULL,
    [Rstatus] [tinyint] NOT NULL,
    [UserName] [varchar](50) NULL,
    [Lastmodify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSQualifier] ADD  CONSTRAINT [DF_MST_PCSQualifier_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[MST_PCSQualifier] ADD  CONSTRAINT [DF_MST_PCSQualifier_Lastmodify]  DEFAULT (getdate()) FOR [Lastmodify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_PCSTabular

Description:

Schema:

 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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_PCSTabular]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSTabular](
    [internalid] [int] IDENTITY(1,1) NOT NULL,
    [GroupId] [int] NULL,
    [SectionTitle] [varchar](50) NULL,
    [Section] [varchar](100) NULL,
    [SectionCode] [varchar](20) NULL,
    [BodySystemTitle] [varchar](100) NULL,
    [BodySystem] [varchar](100) NULL,
    [bodySystemCode] [varchar](20) NULL,
    [rootTitle] [varchar](100) NULL,
    [Operation] [varchar](100) NULL,
    [OperationCode] [varchar](20) NULL,
    [Definition] [varchar](1000) NULL,
    [digit4Title] [varchar](100) NULL,
    [BodyPart] [varchar](100) NULL,
    [BodyPartCode] [varchar](20) NULL,
    [digit5Title] [varchar](100) NULL,
    [Approach] [varchar](100) NULL,
    [ApproachCode] [varchar](20) NULL,
    [digit6Title] [varchar](100) NULL,
    [Device] [varchar](100) NULL,
    [DeviceCode] [varchar](20) NULL,
    [digit7Title] [varchar](100) NULL,
    [Qualifier] [varchar](100) NULL,
    [QualifierCode] [varchar](20) NULL,
    [Status] [int] NULL,
    [CODE] [varchar](50) NULL,
    [Gender] [tinyint] NOT NULL,
    [Neonatal] [tinyint] NOT NULL,
    [UserName] [varchar](50) NULL,
    [LastModify] [datetime] NOT NULL,
 CONSTRAINT [PK__MST_PCSTabular] PRIMARY KEY CLUSTERED 
(
    [internalid] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSTabular] ADD  CONSTRAINT [DF_MST_PCSTabular_Gender]  DEFAULT ((0)) FOR [Gender]
GO
ALTER TABLE [dbo].[MST_PCSTabular] ADD  CONSTRAINT [DF_MST_PCSTabular_Neonatal]  DEFAULT ((0)) FOR [Neonatal]
GO
ALTER TABLE [dbo].[MST_PCSTabular] ADD  CONSTRAINT [DF_MST_PCSTabular_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_ProcedureStatus

Description:

Schema:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_ProcedureStatus]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ProcedureStatus](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [ProcedureName] [varchar](100) NULL,
    [PCSCode] [varchar](10) NULL,
    [PastCode] [varchar](20) NULL,
    [ActualDesc] [varchar](200) NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ProcedureStatus] ADD  CONSTRAINT [DF_MST_ProcedureStatus_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_QualifierExclusion

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_QualifierExclusion]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QualifierExclusion](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [Qualifier] [varchar](100) NULL,
    [Priority] [int] NULL,
    [GroupId] [int] NULL,
    [GroupName] [nvarchar](255) NULL,
    [Status] [int] NULL,
    [LastModify] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QualifierExclusion] ADD  CONSTRAINT [DF_MST_QualifierExclusion_Status]  DEFAULT ((0)) FOR [Status]
GO
ALTER TABLE [dbo].[MST_QualifierExclusion] ADD  CONSTRAINT [DF_MST_QualifierExclusion_LastModify]  DEFAULT (getdate()) FOR [LastModify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_StandardBodyParts2

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_StandardBodyParts2]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_StandardBodyParts2](
    [InternalId] [int] IDENTITY(1,1) NOT NULL,
    [OperationName] [varchar](50) NOT NULL,
    [StandardBodyPart] [varchar](100) NULL,
    [BodySystem] [varchar](50) NULL,
    [BodyPart] [varchar](50) NULL,
    [BodyPartLoc] [varchar](50) NULL,
    [Code] [varchar](10) NULL,
    [Excision] [varchar](20) NULL,
    [Rstatus] [tinyint] NULL,
    [UserName] [varchar](50) NULL,
    [Lastmodify] [datetime] NOT NULL,
    [Operation2] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_StandardBodyParts2] ADD  CONSTRAINT [DF_MST_StandardBodyParts2_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[MST_StandardBodyParts2] ADD  CONSTRAINT [DF_MST_StandardBodyParts2_Lastmodify]  DEFAULT (getdate()) FOR [Lastmodify]
GO

ChangeLog:

======================================================

DataBase Name:MasterHRCM

Table Name:MST_UniqueListTerm

Description:

Schema:

 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
USE [MasterHRCM]
GO
/****** Object:  Table [dbo].[MST_UniqueListTerm]    Script Date: 06/21/2018 16:48:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_UniqueListTerm](
    [UniqueListTermId] [int] IDENTITY(1,1) NOT NULL,
    [Term] [varchar](max) NULL,
    [STY] [varchar](150) NULL,
    [TUI] [varchar](80) NULL,
    [CUI] [varchar](80) NULL,
    [SnomedCtId] [varchar](80) NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [smalldatetime] NOT NULL,
    [ModifiedDate] [smalldatetime] NOT NULL,
 CONSTRAINT [PK_MST_UniqueListTerm] PRIMARY KEY CLUSTERED 
(
    [UniqueListTermId] 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
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_UniqueListTerm] ADD  CONSTRAINT [DF_MST_UniqueListTerm_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_UniqueListTerm] ADD  CONSTRAINT [DF_MST_UniqueListTerm_InsertedDate]  DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_UniqueListTerm] ADD  CONSTRAINT [DF_MST_UniqueListTerm_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
GO

ChangeLog: