Hrcm Schema

Table Name:AQAS_PendingAccount¶

Description:¶

It contains list of AccountNumber's and given those as an input to Auto Query Alert System Analysis.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[AQAS_PendingAccount]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AQAS_PendingAccount](
    [PendingAccountId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ChangeSource] [varchar](50) NOT NULL,
    [PendingStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AQAS_PendingAccount] PRIMARY KEY CLUSTERED 
(
    [PendingAccountId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_PendingStatus] ON [dbo].[AQAS_PendingAccount] 
(
    [PendingStatus] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AQAS_PendingAccount] ADD  CONSTRAINT [DF_AQAS_PendingAccount_PendingStatus]  DEFAULT ((0)) FOR [PendingStatus]
GO
ALTER TABLE [dbo].[AQAS_PendingAccount] ADD  CONSTRAINT [DF_AQAS_PendingAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[AQAS_PendingAccount] ADD  CONSTRAINT [DF_AQAS_PendingAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

PendingStatus:

It describes some vales which are 0 means need to start AQAS Analysis, 1 means AQAS Analysis was completed and 2 means AQAS Analysis in Process.

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

Table Name:AQAS_QueryAlertElementResult¶

Description:¶

It describes final result for AQAS Analysis.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[AQAS_QueryAlertElementResult]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AQAS_QueryAlertElementResult](
    [QAElementResultId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [QueryAlertId] [int] NOT NULL,
    [CriteriaElementId] [int] NOT NULL,
    [CriteriaElementMappingId] [int] NOT NULL,
    [ClinicalElementTypeId] [int] NOT NULL,
    [UniqueCriteriaId] [int] NOT NULL,
    [GroupId] [int] NULL,
    [Result] [varchar](150) NULL,
    [Result_Source_UniqueId] [int] NOT NULL,
    [QueryCriteriaType] [varchar](150) NULL,
    [PhysicianReference] [varchar](250) NULL,
    [HospitalDay] [int] NULL,
    [SetId] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AQAS_QueryAlertElementResult] PRIMARY KEY CLUSTERED 
(
    [QAElementResultId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNo] ON [dbo].[AQAS_QueryAlertElementResult] 
(
    [AccountNumber] ASC,
    [ClinicalElementTypeId] ASC,
    [Active] ASC
)
INCLUDE ( [Result_Source_UniqueId]) 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]
GO
CREATE NONCLUSTERED INDEX [Ncix_Active] ON [dbo].[AQAS_QueryAlertElementResult] 
(
    [Active] ASC
)
INCLUDE ( [QAElementResultId],
[AccountNumber],
[CriteriaElementId]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Ncix_CEId] ON [dbo].[AQAS_QueryAlertElementResult] 
(
    [CriteriaElementId] ASC
)
INCLUDE ( [QAElementResultId],
[AccountNumber],
[Active]) 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]
GO
CREATE NONCLUSTERED INDEX [Ncix_CETID] ON [dbo].[AQAS_QueryAlertElementResult] 
(
    [ClinicalElementTypeId] ASC,
    [Active] ASC
)
INCLUDE ( [QAElementResultId],
[AccountNumber],
[Result_Source_UniqueId]) 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]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult]  WITH CHECK ADD  CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlert] FOREIGN KEY([QueryAlertId])
REFERENCES [dbo].[MST_QueryAlert] ([QueryAlertId])
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] CHECK CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlert]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult]  WITH CHECK ADD  CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlertCriteriaElement] FOREIGN KEY([CriteriaElementId])
REFERENCES [dbo].[MST_QueryAlertCriteriaElement] ([CriteriaElementId])
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] CHECK CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlertCriteriaElement]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult]  WITH CHECK ADD  CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlertCriteriaElementMapping] FOREIGN KEY([CriteriaElementMappingId])
REFERENCES [dbo].[MST_QueryAlertCriteriaElementMapping] ([CriteriaElementMappingId])
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] CHECK CONSTRAINT [FK_AQAS_QueryAlertElementResult_MST_QueryAlertCriteriaElementMapping]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertElementResult_SetId]  DEFAULT ((0)) FOR [SetId]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertElementResult_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertElementResult_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertElementResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertElementResult_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

Active:

It describes some values which are 0 means History ResulSet and 1 means Current ResultSet.

SetId:

Min value reprasent's HistorySet and Max value reprasent's CurrentSet.

Result_Source_UniqueId:

At finally we get results from some source tables in that have an internalid or some other uniqueid is nothing but Result_Source_UniqueId.

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

Table Name:AQAS_QueryAlertFinalResult¶

Description:¶

It describes AccountNumbers which are Finally Trigered Only for AQAS Analysis.

Table Schema¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[AQAS_QueryAlertFinalResult]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AQAS_QueryAlertFinalResult](
    [QAFinalResultId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [QueryAlertId] [int] NOT NULL,
    [QueryTypeId] [int] NOT NULL,
    [QueryDiagnosisId] [int] NOT NULL,
    [QueryName] [varchar](150) NOT NULL,
    [SetId] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_AQAS_QueryAlertFinalResult] PRIMARY KEY CLUSTERED 
(
    [QAFinalResultId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[AQAS_QueryAlertFinalResult] 
(
    [AccountNumber] ASC
)
INCLUDE ( [SetId]) 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]
GO
CREATE NONCLUSTERED INDEX [Ncix_Active] ON [dbo].[AQAS_QueryAlertFinalResult] 
(
    [Active] ASC
)
INCLUDE ( [QAFinalResultId],
[AccountNumber]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult]  WITH CHECK ADD  CONSTRAINT [FK_AQAS_QueryAlertFinalResult_MST_QueryAlert] FOREIGN KEY([QueryAlertId])
REFERENCES [dbo].[MST_QueryAlert] ([QueryAlertId])
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult] CHECK CONSTRAINT [FK_AQAS_QueryAlertFinalResult_MST_QueryAlert]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertFinalResult_SetId]  DEFAULT ((0)) FOR [SetId]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertFinalResult_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertFinalResult_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[AQAS_QueryAlertFinalResult] ADD  CONSTRAINT [DF_AQAS_QueryAlertFinalResult_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

Active:

It describes some values which are 0 means History ResulSet and 1 means Current ResultSet.

SetId:

Min value reprasent's HistorySet and Max value reprasent's CurrentSet.

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

Table Name:CDA_Allergy¶

Description:¶

Our developer inherited an old application and asked for help to identify cross-database dependencies. There were many integration points, but they were not documented anywhere.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[CDA_Allergy]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CDA_Allergy](
    [AllergyId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [Allergy] [varchar](250) NULL,
    [Severity] [varchar](50) NULL,
    [Reaction] [varchar](50) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [HospitalDay] [int] NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_CDA_Allergy] PRIMARY KEY CLUSTERED 
(
    [AllergyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CDA_Allergy] ADD  CONSTRAINT [DF_CDA_Allergy_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[CDA_Allergy] ADD  CONSTRAINT [DF_CDA_Allergy_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Allergy] ADD  CONSTRAINT [DF_CDA_Allergy_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:CDA_Habit¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[CDA_Habit]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CDA_Habit](
    [HabitId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [Substance] [varchar](250) NULL,
    [Usage] [varchar](50) NULL,
    [Frequency] [varchar](50) NULL,
    [Duration] [varchar](50) NULL,
    [PackYears] [varchar](50) NULL,
    [QuitDate] [varchar](50) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [HospitalDay] [int] NULL,
    [RStatus] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_CDA_Habit] PRIMARY KEY CLUSTERED 
(
    [HabitId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CDA_Habit] ADD  CONSTRAINT [DF_CDA_Habit_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[CDA_Habit] ADD  CONSTRAINT [DF_CDA_Habit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Habit] ADD  CONSTRAINT [DF_CDA_Habit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:CDA_HomeMedication¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[CDA_HomeMedication]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CDA_HomeMedication](
    [HomeMedicationID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [HomeMedication] [varchar](250) NULL,
    [Dose] [varchar](100) NULL,
    [Route] [varchar](100) NULL,
    [Frequency] [varchar](100) NULL,
    [Duration] [varchar](50) NULL,
    [PRN] [varchar](50) NULL,
    [PRNReason] [varchar](150) NULL,
    [DischargeDoseDue] [varchar](25) NULL,
    [StartDate] [varchar](15) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [SectionHeader] [varchar](200) NULL,
    [HospitalDay] [int] NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_CDA_HomeMedication] PRIMARY KEY CLUSTERED 
(
    [HomeMedicationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CDA_HomeMedication] ADD  CONSTRAINT [DF_CDA_HomeMedication_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[CDA_HomeMedication] ADD  CONSTRAINT [DF_CDA_HomeMedication_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_HomeMedication] ADD  CONSTRAINT [DF_CDA_HomeMedication_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:CDA_IPMedication¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[CDA_IPMedication]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CDA_IPMedication](
    [IPMedicationID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [OrderStatus] [varchar](50) NULL,
    [ProcStatus] [varchar](50) NULL,
    [Medication] [varchar](250) NULL,
    [Frequency] [varchar](100) NULL,
    [OrderBy] [varchar](70) NULL,
    [RStatus] [tinyint] NOT NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [SectionHeader] [varchar](200) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_CDA_IPMedication] PRIMARY KEY CLUSTERED 
(
    [IPMedicationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CDA_IPMedication] ADD  CONSTRAINT [DF_CDA_IPMedication_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[CDA_IPMedication] ADD  CONSTRAINT [DF_CDA_IPMedication_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_IPMedication] ADD  CONSTRAINT [DF_CDA_IPMedication_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:CDA_Lab¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[CDA_Lab]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CDA_Lab](
    [LabID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [LabOrder] [varchar](100) NULL,
    [TestName] [varchar](250) NULL,
    [Result] [varchar](50) NULL,
    [ActualValue] [varchar](50) NULL,
    [RefRange] [varchar](50) NULL,
    [Comments] [varchar](250) NULL,
    [ResultStatus] [varchar](30) NULL,
    [Collection] [datetime] NULL,
    [Rstatus] [tinyint] NOT NULL,
    [StartId] [int] NOT NULL,
    [EndId] [int] NOT NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [Deviation] [float] NULL,
    [DeviationType] [varchar](15) NULL,
    [MinRange] [float] NULL,
    [MaxRange] [float] NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_CDA_Lab] PRIMARY KEY CLUSTERED 
(
    [LabID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[CDA_Lab] ADD  CONSTRAINT [DF_CDA_Lab_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[CDA_Lab] ADD  CONSTRAINT [DF_CDA_Lab_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Lab] ADD  CONSTRAINT [DF_CDA_Lab_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:DBError¶

Description:¶

It describes complete Error Log Information when gets an Error while browsing an KPAI Application and Running CIRS Application.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[DBError]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DBError](
    [DBErrorID] [int] IDENTITY(1,1) NOT NULL,
    [ErrorState] [int] NOT NULL,
    [ErrorNumber] [int] NOT NULL,
    [ErrorMessage] [varchar](4000) NULL,
    [ErrorSchema] [varchar](1000) NULL,
    [ErrorProcedureName] [varchar](128) NULL,
    [ErrorApplication] [varchar](20) NULL,
    [Active] [bit] NOT NULL,
    [ErrorDate] [datetime] NOT NULL,
 CONSTRAINT [PK_DBError] PRIMARY KEY CLUSTERED 
(
    [DBErrorID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[DBError] ADD  CONSTRAINT [DF_DBError_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[DBError] ADD  CONSTRAINT [DF_DBError_ErrorDate]  DEFAULT (getutcdate()) FOR [ErrorDate]
GO

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

Table Name:FTP_DRG¶

Description:¶

It describes complete information about MSDRG, APRDRG and Account charges information.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_DRG]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_DRG](
    [DRGID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MSDRG] [varchar](10) NOT NULL,
    [MSDRGDesc] [varchar](250) NULL,
    [MSDRGWeight] [float] NULL,
    [MSDRGMDC] [varchar](10) NULL,
    [MSDRGGLOS] [float] NULL,
    [MSDRGALOS] [float] NULL,
    [APRDRG] [varchar](10) NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NULL,
    [APRDRGMDC] [varchar](10) NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NULL,
    [ROM] [int] NULL,
    [TotalCharge] [varchar](20) NULL,
    [TotalCost] [varchar](20) NULL,
    [VarianceCharge] [varchar](20) NULL,
    [VarianceCost] [varchar](20) NULL,
    [ExpectedReimbursement] [varchar](20) NULL,
    [TotalExpected] [varchar](20) NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
 CONSTRAINT [PK_FTP_DRG] PRIMARY KEY CLUSTERED 
(
    [DRGID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNo] ON [dbo].[FTP_DRG] 
(
    [AccountNumber] ASC
)
INCLUDE ( [DRGID]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_DRG] ADD  CONSTRAINT [DF_FTP_DRG_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_DRG] ADD  CONSTRAINT [DF_FTP_DRG_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:FTP_DXCode¶

Description:¶

It describes complete information about Diagnosis codes and appropriate DRG.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_DXCode]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_DXCode](
    [DXCodeID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DXCode] [varchar](10) NULL,
    [DXDesc] [varchar](250) NULL,
    [POA] [varchar](10) NULL,
    [DXType] [varchar](10) NULL,
    [DXPriority] [int] NOT NULL,
    [CCMCC] [varchar](10) NULL,
    [PhysicianID] [varchar](30) NULL,
    [DXDate] [datetime] NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DRGID] [int] NOT NULL,
 CONSTRAINT [PK_FTP_DXCode] PRIMARY KEY CLUSTERED 
(
    [DXCodeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_DXCode] 
(
    [AccountNumber] ASC,
    [DXCode] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_DXCode] ADD  CONSTRAINT [DF_FTP_DXCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_DXCode] ADD  CONSTRAINT [DF_FTP_DXCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[FTP_DXCode] ADD  DEFAULT ((0)) FOR [DRGID]
GO

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

Table Name:FTP_IPMedication¶

Description:¶

It describes information about In-patient medication's.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_IPMedication]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_IPMedication](
    [IPMedicationID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MedicationName] [varchar](150) NULL,
    [MedicationType] [varchar](150) NULL,
    [Dose] [varchar](100) NULL,
    [Route] [varchar](100) NULL,
    [Frequency] [varchar](100) NULL,
    [StartDate] [datetime] NULL,
    [EndDate] [datetime] NULL,
    [PRN] [varchar](10) NULL,
    [Administration] [varchar](10) NULL,
    [GenericName] [varchar](150) NULL,
    [BrandName] [varchar](150) NULL,
    [DrugID] [varchar](50) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
    [UniqueId] [int] NOT NULL,
    [BrandUniqueID] [int] NOT NULL,
 CONSTRAINT [PK_FTP_IPMedication] PRIMARY KEY CLUSTERED 
(
    [IPMedicationID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_IPMedication] 
(
    [AccountNumber] ASC,
    [MedicationName] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD  CONSTRAINT [DF_FTP_IPMedication_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD  CONSTRAINT [DF_FTP_IPMedication_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD  CONSTRAINT [DF__FTP_IPMed__Medic__0FD74C44]  DEFAULT ((0)) FOR [UniqueId]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD  CONSTRAINT [DF_FTP_IPMedication_BrandUniqueID]  DEFAULT ((0)) FOR [BrandUniqueID]
GO

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

Table Name:FTP_Lab¶

Description:¶

It describes complete information about Laboratory data and reference range data.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_Lab]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_Lab](
    [LabID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [TestName] [varchar](150) NULL,
    [Result] [varchar](150) NULL,
    [NumericResult] [float] NULL,
    [Unit] [varchar](50) NULL,
    [ReferenceRange] [varchar](30) NULL,
    [LabTestDate] [datetime] NOT NULL,
    [LOINCCode] [varchar](50) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
    [Deviation] [float] NULL,
    [DeviationType] [varchar](15) NULL,
    [MinRange] [float] NULL,
    [MaxRange] [float] NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_FTP_Lab] PRIMARY KEY CLUSTERED 
(
    [LabID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_Lab] 
(
    [AccountNumber] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Ncix_Result] ON [dbo].[FTP_Lab] 
(
    [Result] ASC
)
INCLUDE ( [LabID]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_Lab] ADD  CONSTRAINT [DF_FTP_Lab_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_Lab] ADD  CONSTRAINT [DF_FTP_Lab_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[FTP_Lab] ADD  CONSTRAINT [DF__FTP_Lab__TestId__5575A085]  DEFAULT ((0)) FOR [UniqueId]
GO

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

Table Name:FTP_NurseNote¶

Description:¶

It describes NurseNote Information.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_NurseNote]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_NurseNote](
    [NurseNoteID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [NurseNoteDate] [datetime] NOT NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
    [UniqueId] [int] NOT NULL,
 CONSTRAINT [PK_FTP_NurseNote] PRIMARY KEY CLUSTERED 
(
    [NurseNoteID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_NurseNote] 
(
    [AccountNumber] ASC
)
INCLUDE ( [NurseNoteID],
[NurseNoteDate]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_NurseNote] ADD  CONSTRAINT [DF_FTP_NurseNote_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_NurseNote] ADD  CONSTRAINT [DF_FTP_NurseNote_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[FTP_NurseNote] ADD  DEFAULT ((0)) FOR [UniqueId]
GO

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

Table Name:FTP_PCSCode¶

Description:¶

It describes complete information about Procedure codes.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_PCSCode]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_PCSCode](
    [PCSCodeID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [PCSDesc] [varchar](250) NULL,
    [PCSType] [varchar](10) NULL,
    [PCSPriority] [int] NULL,
    [PhysicianID] [varchar](30) NULL,
    [PCSDate] [datetime] NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DRGID] [int] NOT NULL,
 CONSTRAINT [PK_FTP_PCSCode] PRIMARY KEY CLUSTERED 
(
    [PCSCodeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_PCSCode] 
(
    [AccountNumber] ASC,
    [PCSCode] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FTP_PCSCode] ADD  CONSTRAINT [DF_FTP_PCSCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_PCSCode] ADD  CONSTRAINT [DF_FTP_PCSCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[FTP_PCSCode] ADD  DEFAULT ((0)) FOR [DRGID]
GO

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

Table Name:FTP_VitalSign¶

Description:¶

It describes information about VitalSigns.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[FTP_VitalSign]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTP_VitalSign](
    [VitalSignID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [VitalSign] [varchar](150) NOT NULL,
    [Result] [varchar](150) NOT NULL,
    [NumericResult] [float] NOT NULL,
    [NumericResult2] [float] NULL,
    [VitalSignDate] [datetime] NOT NULL,
    [LOINCCode] [varchar](50) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_FTP_VitalSign] PRIMARY KEY CLUSTERED 
(
    [VitalSignID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[FTP_VitalSign] 
(
    [AccountNumber] ASC
)
INCLUDE ( [VitalSignDate]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Ncix_ReportDate] ON [dbo].[FTP_VitalSign] 
(
    [ReportDate] 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]
GO
CREATE NONCLUSTERED INDEX [Ncix_VSign] ON [dbo].[FTP_VitalSign] 
(
    [VitalSign] ASC,
    [InsertedDate] ASC
)
INCLUDE ( [VitalSignID],
[NumericResult]) 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]
GO
ALTER TABLE [dbo].[FTP_VitalSign] ADD  CONSTRAINT [DF_FTP_VitalSign_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_VitalSign] ADD  CONSTRAINT [DF_FTP_VitalSign_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:HIM_Document¶

Description:¶

It describes information about Patient Account, patient Document Transcription details, Document Formated details and Type of Documents.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[HIM_Document]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Document](
    [DocumentID] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MRN] [varchar](30) NOT NULL,
    [DocumentTypeID] [int] NULL,
    [PhysicianID] [varchar](30) NULL,
    [PhysicianName] [varchar](80) NULL,
    [ActivityDateTime] [datetime] NULL,
    [OriginationDateTime] [datetime] NULL,
    [TranscriptionDateTime] [datetime] NULL,
    [EditDateTime] [datetime] NULL,
    [UniqueDocumentNumber] [varchar](100) NOT NULL,
    [ParentDocumentNumber] [varchar](100) NULL,
    [UniqueDocumentFileName] [varchar](200) NULL,
    [DocumentCompletionStatusID] [int] NOT NULL,
    [DocumentRunningStatusID] [int] NOT NULL,
    [InitialRunDate] [datetime] NULL,
    [LastRunDate] [datetime] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [HospitalDay] [int] NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [Formatted] [int] NOT NULL,
 CONSTRAINT [PK_HIM_Document_1] PRIMARY KEY CLUSTERED 
(
    [DocumentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [NCIX_Formatted] ON [dbo].[HIM_Document] 
(
    [Formatted] ASC
)
INCLUDE ( [DocumentID],
[DocumentTypeID]) 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HIM_Document]  WITH CHECK ADD  CONSTRAINT [FK_HIM_DocumentInfo_HIM_Physician] FOREIGN KEY([PhysicianID])
REFERENCES [dbo].[HIM_Physician] ([PhysicianID])
GO
ALTER TABLE [dbo].[HIM_Document] CHECK CONSTRAINT [FK_HIM_DocumentInfo_HIM_Physician]
GO
ALTER TABLE [dbo].[HIM_Document]  WITH CHECK ADD  CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentCompletionStatus] FOREIGN KEY([DocumentCompletionStatusID])
REFERENCES [dbo].[MST_DocumentCompletionStatus] ([DocumentCompletionStatusID])
GO
ALTER TABLE [dbo].[HIM_Document] CHECK CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentCompletionStatus]
GO
ALTER TABLE [dbo].[HIM_Document]  WITH CHECK ADD  CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentRunningStatus] FOREIGN KEY([DocumentRunningStatusID])
REFERENCES [dbo].[MST_DocumentRunningStatus] ([DocumentRunningStatusID])
GO
ALTER TABLE [dbo].[HIM_Document] CHECK CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentRunningStatus]
GO
ALTER TABLE [dbo].[HIM_Document]  WITH NOCHECK ADD  CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentType] FOREIGN KEY([DocumentTypeID])
REFERENCES [dbo].[MST_DocumentType] ([DocumentTypeID])
NOT FOR REPLICATION
GO
ALTER TABLE [dbo].[HIM_Document] NOCHECK CONSTRAINT [FK_HIM_DocumentInfo_MST_DocumentType]
GO
ALTER TABLE [dbo].[HIM_Document] ADD  CONSTRAINT [DF_HIM_Document_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD  CONSTRAINT [DF_HIM_Document_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD  CONSTRAINT [DF__HIM_Docum__Forma__10AB74EC]  DEFAULT ((0)) FOR [Formatted]
GO

Columns:¶

Formatted:

0 means Document need to Format to Analysis and 1 means document format was completed.

DocumentRunningStatusId:

USE [HRCM]
GO
/****** Object:  Table [dbo].[HIM_VitalSign]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_VitalSign](
    [VitalSignID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [VitalSign] [varchar](150) NOT NULL,
    [Result] [varchar](150) NOT NULL,
    [NumericResult] [float] NOT NULL,
    [NumericResult2] [float] NULL,
    [VitalSignDate] [datetime] NULL,
    [LOINCCode] [varchar](50) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_HIM_VitalSign] PRIMARY KEY CLUSTERED 
(
    [VitalSignID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_VitalSign] ADD  CONSTRAINT [DF_HIM_VitalSign_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_VitalSign] ADD  CONSTRAINT [DF_HIM_VitalSign_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_ApplicationsLog¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_ApplicationsLog]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_ApplicationsLog](
    [ApplicationLogID] [int] IDENTITY(1,1) NOT NULL,
    [ApplicationName] [varchar](80) NULL,
    [ServerIP] [varchar](30) NULL,
    [ClientIP] [varchar](30) NULL,
    [UserId] [varchar](50) NULL,
    [LogLevel] [varchar](150) NULL,
    [LogPoint] [varchar](150) NULL,
    [LogMessage] [varchar](250) NULL,
    [ResolvedBy] [varchar](50) NULL,
    [ResolvedDate] [datetime] NULL,
    [ResolvedDesc] [varchar](150) NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_LOG_ApplicationsLog] PRIMARY KEY CLUSTERED 
(
    [ApplicationLogID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_ApplicationsLog] ADD  CONSTRAINT [DF_LOG_ApplicationsLog_RStatus]  DEFAULT ((1)) FOR [RStatus]
GO
ALTER TABLE [dbo].[LOG_ApplicationsLog] ADD  CONSTRAINT [DF_LOG_ApplicationsLog_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_ApplicationsLog] ADD  CONSTRAINT [DF_LOG_ApplicationsLog_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_FTP_DRG¶

Description:¶

It describes the History information about the table FTP_DRG.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_FTP_DRG]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_FTP_DRG](
    [DRGLogId] [int] IDENTITY(1,1) NOT NULL,
    [DRGID] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MSDRG] [varchar](10) NOT NULL,
    [MSDRGDesc] [varchar](250) NULL,
    [MSDRGWeight] [float] NULL,
    [MSDRGMDC] [varchar](10) NULL,
    [MSDRGGLOS] [float] NULL,
    [MSDRGALOS] [float] NULL,
    [APRDRG] [varchar](10) NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NULL,
    [APRDRGMDC] [varchar](10) NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NULL,
    [ROM] [int] NULL,
    [TotalCharge] [varchar](20) NULL,
    [TotalCost] [varchar](20) NULL,
    [VarianceCharge] [varchar](20) NULL,
    [VarianceCost] [varchar](20) NULL,
    [ExpectedReimbursement] [varchar](20) NULL,
    [TotalExpected] [varchar](20) NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [ReportDate] [datetime] NULL,
 CONSTRAINT [PK_Ftp_Drg_Log] PRIMARY KEY CLUSTERED 
(
    [DRGLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_FTP_DRG] ADD  CONSTRAINT [DF_Ftp_Drg_Log_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_DRG] ADD  CONSTRAINT [DF_Ftp_Drg_Log_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_FTP_DXCode¶

Description:¶

It describes the History information about the table FTP_DXCode.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_FTP_DXCode]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_FTP_DXCode](
    [DxCodeLogID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DXCode] [varchar](10) NULL,
    [DXDesc] [varchar](250) NULL,
    [POA] [varchar](10) NULL,
    [DXType] [varchar](10) NULL,
    [DXPriority] [int] NOT NULL,
    [CCMCC] [varchar](10) NULL,
    [PhysicianID] [varchar](30) NULL,
    [DXDate] [datetime] NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DRGID] [int] NOT NULL,
 CONSTRAINT [PK_Ftp_DxCode_Log] PRIMARY KEY CLUSTERED 
(
    [DxCodeLogID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_FTP_DXCode] ADD  CONSTRAINT [DF_Ftp_DxCode_Log_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_DXCode] ADD  CONSTRAINT [DF_Ftp_DxCode_Log_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_DXCode] ADD  DEFAULT ((0)) FOR [DRGID]
GO

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

Table Name:LOG_FTP_PatientDocuments¶

Description:¶

It describes the information about PDOCS like Account,Type of Documents,Physician, Transcription Details and DocumentCompletion status.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_FTP_PatientDocuments]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_FTP_PatientDocuments](
    [PatientDocumentID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MRN] [varchar](30) NOT NULL,
    [PatientDocumentType] [varchar](100) NULL,
    [DocumentTypeId] [int] NULL,
    [PhysicianName] [varchar](80) NULL,
    [DateDictCreated] [varchar](35) NULL,
    [DocumentCompletionStatus] [varchar](80) NULL,
    [FileName] [varchar](100) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_LOG_FTP_PatientDocuments] PRIMARY KEY CLUSTERED 
(
    [PatientDocumentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_FTP_PatientDocuments] ADD  CONSTRAINT [DF_LOG_FTP_PatientDocuments_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_PatientDocuments] ADD  CONSTRAINT [DF_LOG_FTP_PatientDocuments_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_FTP_PCSCode¶

Description:¶

It describes the History information about the table FTP_PCSCode.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_FTP_PCSCode]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_FTP_PCSCode](
    [PcsCodeLogId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [PCSDesc] [varchar](250) NULL,
    [PCSType] [varchar](10) NULL,
    [PCSPriority] [int] NULL,
    [PhysicianID] [varchar](30) NULL,
    [PCSDate] [datetime] NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DRGID] [int] NOT NULL,
 CONSTRAINT [PK_Ftp_PcsCode_Log] PRIMARY KEY CLUSTERED 
(
    [PcsCodeLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_FTP_PCSCode] ADD  CONSTRAINT [DF_Ftp_PcsCode_Log_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_PCSCode] ADD  CONSTRAINT [DF_Ftp_PcsCode_Log_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[LOG_FTP_PCSCode] ADD  DEFAULT ((0)) FOR [DRGID]
GO

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

Table Name:LOG_HIM_Document¶

Description:¶

It describes the History information about the table HIM_Document.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_HIM_Document]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_HIM_Document](
    [LHDocumentID] [int] IDENTITY(1,1) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MRN] [varchar](30) NOT NULL,
    [DocumentTypeID] [int] NULL,
    [PhysicianID] [varchar](30) NULL,
    [PhysicianName] [varchar](80) NULL,
    [ActivityDateTime] [datetime] NULL,
    [OriginationDateTime] [datetime] NULL,
    [TranscriptionDateTime] [datetime] NULL,
    [EditDateTime] [datetime] NULL,
    [UniqueDocumentNumber] [varchar](100) NULL,
    [ParentDocumentNumber] [varchar](100) NULL,
    [UniqueDocumentFileName] [varchar](200) NULL,
    [DocumentCompletionStatusID] [int] NOT NULL,
    [LogStatus] [varchar](10) NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_LOG_HIM_Document_Log] PRIMARY KEY CLUSTERED 
(
    [LHDocumentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_HIM_Document] ADD  CONSTRAINT [DF_LOG_HIM_Document_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO

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

Table Name:LOG_NLP_DRG¶

Description:¶

It describes the History information about the table NLP_DRG.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_NLP_DRG]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_NLP_DRG](
    [LogDrgId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MsDrg] [varchar](10) NOT NULL,
    [MsDrgDesc] [varchar](250) NULL,
    [MsDrgWeight] [float] NOT NULL,
    [MsDrgMDC] [varchar](10) NOT NULL,
    [MsDrgGLOS] [float] NOT NULL,
    [MsDrgALOS] [float] NOT NULL,
    [AprDrg] [varchar](10) NULL,
    [AprDrgDesc] [varchar](250) NULL,
    [AprDrgWeight] [float] NOT NULL,
    [AprDrgMDC] [varchar](10) NOT NULL,
    [AprDrgGLOS] [float] NULL,
    [AprDrgALOS] [float] NULL,
    [Soi] [int] NULL,
    [Rom] [int] NULL,
    [AdmitDate] [varchar](25) NULL,
    [DischargeDate] [varchar](25) NULL,
    [Gender] [varchar](2) NULL,
    [DOB] [varchar](25) NULL,
    [Age] [int] NULL,
    [DxCodes] [varchar](1000) NULL,
    [PcsCodes] [varchar](1000) NULL,
    [DischargeDisposition] [int] NULL,
    [GrouperType] [varchar](25) NULL,
    [MsGrouperVersion] [int] NULL,
    [AprGrouperVersion] [int] NULL,
    [PrimaryDxCode] [varchar](10) NULL,
    [PrimaryPcsCode] [varchar](10) NULL,
    [UserName] [varchar](50) NULL,
    [TargetTable] [varchar](15) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_Drg] PRIMARY KEY CLUSTERED 
(
    [LogDrgId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_NLP_DRG] ADD  CONSTRAINT [DF_Log_Drg_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_NLP_DRG] ADD  CONSTRAINT [DF_Log_Drg_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_NLP_DXCode¶

Description:¶

It describes the History information about the table NLP_DXCode.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_NLP_DXCode]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_NLP_DXCode](
    [LogDxCodeId] [int] IDENTITY(1,1) NOT NULL,
    [DxCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [DxCode] [varchar](10) NULL,
    [DxDesc] [varchar](250) NULL,
    [Poa] [varchar](10) NULL,
    [DxType] [varchar](50) NULL,
    [DxPriority] [int] NOT NULL,
    [CcMcc] [varchar](20) NULL,
    [PhysicianId] [varchar](30) NULL,
    [DxDate] [datetime] NULL,
    [UserName] [varchar](50) NULL,
    [DxCodeSource] [varchar](100) NULL,
    [DxExclusionTypeId] [tinyint] NOT NULL,
    [SourceInsertedDate] [datetime] NOT NULL,
    [SourceModifiedDate] [datetime] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_NLP_DxCode] PRIMARY KEY CLUSTERED 
(
    [LogDxCodeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_NLP_DXCode] ADD  CONSTRAINT [DF_Log_NLP_DxCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_NLP_DXCode] ADD  CONSTRAINT [DF_Log_NLP_DxCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_NLP_DXCode_Audit¶

Description:¶

It describes the History information about the table NLP_DXCode_Audit.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_NLP_DXCode_Audit]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_NLP_DXCode_Audit](
    [LogDxCodeAuditId] [int] IDENTITY(1,1) NOT NULL,
    [DxCodeAuditId] [int] NOT NULL,
    [DxCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DxCode] [varchar](10) NULL,
    [DXCodeWeight] [float] NULL,
    [AuditType] [tinyint] NOT NULL,
    [AuditorId] [int] NOT NULL,
    [Reason] [varchar](250) NULL,
    [Note] [varchar](250) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_NLP_DxCode_Audit] PRIMARY KEY CLUSTERED 
(
    [LogDxCodeAuditId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_NLP_DXCode_Audit] ADD  CONSTRAINT [DF_Log_NLP_DxCode_Audit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_NLP_DXCode_Audit] ADD  CONSTRAINT [DF_Log_NLP_DxCode_Audit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_NLP_DXCodeByDocument¶

Description:¶

It describes the History information about the table NLP_DXCodeByDocument.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_NLP_DXCodeByDocument]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_NLP_DXCodeByDocument](
    [DxCodeByDocumentId] [int] IDENTITY(1,1) NOT NULL,
    [DxCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [DxCode] [varchar](10) NULL,
    [AnnotationString] [varchar](250) NULL,
    [Poa] [varchar](5) NULL,
    [SectionHeader] [varchar](200) NULL,
    [Finding] [varchar](20) NULL,
    [History] [varchar](10) NULL,
    [UserName] [varchar](50) NULL,
    [AnnotationId] [int] NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [RStatus] [tinyint] NOT NULL,
    [DxCodeSource] [varchar](50) NULL,
    [Codable] [varchar](2) NULL,
    [SourceInsertedDate] [datetime] NOT NULL,
    [SourceModifiedDate] [datetime] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_NLP_DxCodeByDocument] PRIMARY KEY CLUSTERED 
(
    [DxCodeByDocumentId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_NLP_DXCodeByDocument] ADD  CONSTRAINT [DF_Log_NLP_DxCodeByDocument_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_NLP_DXCodeByDocument] ADD  CONSTRAINT [DF_Log_NLP_DxCodeByDocument_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_NLP_PCSCode_Audit¶

Description:¶

It describes the History information about the table NLP_PCSCode_Audit.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_NLP_PCSCode_Audit]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_NLP_PCSCode_Audit](
    [LogPCSCodeAuditId] [int] IDENTITY(1,1) NOT NULL,
    [PCSCodeAuditId] [int] NOT NULL,
    [PCSCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [AuditType] [tinyint] NOT NULL,
    [AuditorId] [int] NOT NULL,
    [Reason] [varchar](250) NULL,
    [Note] [varchar](250) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_NLP_PCSCode_Audit] PRIMARY KEY CLUSTERED 
(
    [PCSCodeAuditId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_NLP_PCSCode_Audit] ADD  CONSTRAINT [DF_Log_NLP_PCSCode_Audit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_NLP_PCSCode_Audit] ADD  CONSTRAINT [DF_Log_NLP_PCSCode_Audit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_USER_AccountNote¶

Description:¶

It describes the History information about the table USER_AccountNote.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_AccountNote]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_AccountNote](
    [NoteId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [NoteBy] [int] NOT NULL,
    [PreviousNote] [varchar](150) NULL,
    [CurrentNote] [varchar](150) NULL,
    [NoteStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_AccountNote] PRIMARY KEY CLUSTERED 
(
    [NoteId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_AccountNote] ADD  CONSTRAINT [DF_Log_AccountNote_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_AccountNote] ADD  CONSTRAINT [DF_Log_AccountNote_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_USER_AllICDDRG¶

Description:¶

It describes the History information about the table USER_ALLICDDRG.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_AllICDDRG]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_AllICDDRG](
    [AllICDDRGLogId] [int] IDENTITY(1,1) NOT NULL,
    [AllICDDRGID] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MSDRG] [varchar](10) NULL,
    [MSDRGDesc] [varchar](250) NULL,
    [MSDRGWeight] [float] NULL,
    [MSDRGMDC] [varchar](10) NULL,
    [MSDRGGLOS] [float] NULL,
    [MSDRGALOS] [float] NULL,
    [APRDRG] [varchar](10) NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NULL,
    [APRDRGMDC] [varchar](10) NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NULL,
    [ROM] [int] NULL,
    [TotalCharge] [varchar](20) NULL,
    [TotalCost] [varchar](20) NULL,
    [VarianceCharge] [varchar](20) NULL,
    [VarianceCost] [varchar](20) NULL,
    [ExpectedReimbursement] [varchar](20) NULL,
    [TotalExpected] [varchar](20) NULL,
    [PrimaryDxCode] [varchar](10) NULL,
    [PrimaryPcsCode] [varchar](10) NULL,
    [ApplicationUserId] [int] NOT NULL,
    [DischargePosition] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_User_AllICDDRG_1] PRIMARY KEY CLUSTERED 
(
    [AllICDDRGLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_AllICDDRG]  WITH CHECK ADD  CONSTRAINT [CHECK_Log_User_AllICDDRG_ApplicationUserId] CHECK  (([dbo].[CheckApplicationUserId]([ApplicationUserId])=(1)))
GO
ALTER TABLE [dbo].[LOG_USER_AllICDDRG] CHECK CONSTRAINT [CHECK_Log_User_AllICDDRG_ApplicationUserId]
GO
ALTER TABLE [dbo].[LOG_USER_AllICDDRG] ADD  CONSTRAINT [DF_Log_User_AllICDDRG_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_AllICDDRG] ADD  CONSTRAINT [DF_Log_User_AllICDDRG_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:LOG_USER_AssignedAccount¶

Description:¶

It describes the History information about the table USER_AssignedAccount.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_AssignedAccount]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_AssignedAccount](
    [AssignedId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [AssignedBy] [int] NOT NULL,
    [AssignTo] [int] NOT NULL,
    [AssignmentStatus] [tinyint] NOT NULL,
    [Note] [varchar](250) NULL,
    [Active] [bit] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_AssignedAccount] PRIMARY KEY CLUSTERED 
(
    [AssignedId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_AssignedAccount] ADD  CONSTRAINT [DF_Log_AssignedAccount_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[LOG_USER_AssignedAccount] ADD  CONSTRAINT [DF_Log_AssignedAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_AssignedAccount] ADD  CONSTRAINT [DF_Log_AssignedAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

AccountStatus:

1 means Insert an AssignAccount and 2 means delete an AssignAccount.

Active:

0 means old and 1 means current record.

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

Table Name:LOG_USER_BlockedAccount¶

Description:¶

It describes the History information about the table USER_BlockedAccount.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_BlockedAccount]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_BlockedAccount](
    [BlockedId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [BlockedBy] [int] NOT NULL,
    [Note] [varchar](250) NULL,
    [BlockedStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_BlockedAccount] PRIMARY KEY CLUSTERED 
(
    [BlockedId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_BlockedAccount] ADD  CONSTRAINT [DF_Log_BlockedAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_BlockedAccount] ADD  CONSTRAINT [DF_Log_BlockedAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

BlockedStatus:

1 means To Block an Account and 2 means to Unblock an Account.

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

Table Name:LOG_USER_CDSAuditorSuggestions¶

Description:¶

It describes the History information about the table USER_CDSAuditorSuggestions.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_CDSAuditorSuggestions]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_CDSAuditorSuggestions](
    [LCDSADSID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [LogMessage] [varchar](250) NULL,
    [InsertedBy] [int] NOT NULL,
    [MessageTo] [int] NULL,
    [ChangeType] [varchar](100) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [SuggestionID] [int] NOT NULL,
 CONSTRAINT [PK_LOG_CDSAuditorSuggestions] PRIMARY KEY CLUSTERED 
(
    [LCDSADSID] 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].[LOG_USER_CDSAuditorSuggestions] ADD  CONSTRAINT [DF_LOG_CDSAuditorSuggestions_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO

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

Table Name:LOG_USER_ClosedAccount¶

Description:¶

It describes the History information about the table USER_ClosedAccount.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_ClosedAccount]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_ClosedAccount](
    [ClosedId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [ClosedBy] [int] NOT NULL,
    [ClosedStatus] [tinyint] NOT NULL,
    [Note] [varchar](250) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_ClosedAccount] PRIMARY KEY CLUSTERED 
(
    [ClosedId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_ClosedAccount] ADD  CONSTRAINT [DF_Log_ClosedAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_ClosedAccount] ADD  CONSTRAINT [DF_Log_ClosedAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_HoldAccount]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_HoldAccount](
    [HoldId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [HoldBy] [int] NOT NULL,
    [Note] [varchar](150) NULL,
    [HoldStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_HoldAccount] PRIMARY KEY CLUSTERED 
(
    [HoldId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_HoldAccount] ADD  CONSTRAINT [DF_Log_HoldAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_HoldAccount] ADD  CONSTRAINT [DF_Log_HoldAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

HoldStatus:

USE [HRCM]
GO
/****** Object:  Table [dbo].[LOG_USER_QueryExport]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LOG_USER_QueryExport](
    [QueryExportLogId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [QueryId] [int] NOT NULL,
    [ExportBy] [int] NOT NULL,
    [QueryTemplateId] [int] NOT NULL,
    [QuerySource] [varchar](30) NULL,
    [ExportFormat] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_LOG_USER_QueryExport_Log] PRIMARY KEY CLUSTERED 
(
    [QueryExportLogId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[LOG_USER_QueryExport] ADD  CONSTRAINT [DF_LOG_USER_QueryExport_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[LOG_USER_QueryExport] ADD  CONSTRAINT [DF_LOG_USER_QueryExport_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:Metrics_CDSMetrics¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[Metrics_CDSMetrics]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Metrics_CDSMetrics](
    [CDSMetricsID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [AdmitDate] [datetime] NOT NULL,
    [DischargeDate] [datetime] NULL,
    [CDS] [varchar](50) NULL,
    [FinClassGroupName] [varchar](50) NULL,
    [FinClassCode] [int] NULL,
    [FinClassName] [varchar](120) NULL,
    [DrgGrouperType] [varchar](50) NULL,
    [QueryId] [int] NULL,
    [QueryName] [varchar](150) NULL,
    [QueryTypeId] [int] NULL,
    [QueryType] [varchar](150) NULL,
    [QueryDiagnosisId] [int] NULL,
    [QueryDiagnosis] [varchar](150) NULL,
    [QueryBy] [varchar](50) NULL,
    [QueryTo] [varchar](120) NULL,
    [QueryToPhysicianId] [varchar](50) NULL,
    [QueryStatus] [varchar](50) NULL,
    [ResponseOutcome] [varchar](50) NULL,
    [PrimaryImpact] [varchar](50) NULL,
    [SecondaryImpact1] [varchar](50) NULL,
    [SecondaryImpact2] [varchar](50) NULL,
    [SecondaryImpact3] [varchar](50) NULL,
    [PreMSDRG] [int] NULL,
    [PreMSDRGWt] [varchar](20) NULL,
    [PostMSDRG] [int] NULL,
    [PostMSDRGWt] [varchar](20) NULL,
    [MSDrgWeightVariance] [varchar](10) NULL,
    [PreAPRDRG] [int] NULL,
    [PreAPRDRGWt] [varchar](20) NULL,
    [PostAPRDRG] [int] NULL,
    [PostAPRDRGWt] [varchar](20) NULL,
    [APRDrgWeightVariance] [varchar](10) NULL,
    [PreSOI] [int] NULL,
    [PostSOI] [int] NULL,
    [PreROM] [int] NULL,
    [PostROM] [int] NULL,
    [RespondedBy] [varchar](80) NULL,
    [QueryDate] [datetime] NULL,
    [RespondedDate] [datetime] NULL,
    [UserMSDRG] [int] NULL,
    [UserMSDRGDesc] [varchar](180) NULL,
    [UserMSDRGWT] [varchar](10) NULL,
    [UserAPRDRG] [int] NULL,
    [UserAPRDRGDesc] [varchar](180) NULL,
    [UserAPRDRGWT] [varchar](10) NULL,
    [UserAPRDRGSOI] [int] NULL,
    [UserAPRDRGROM] [int] NULL,
    [FacilityMSDRG] [int] NULL,
    [FacilityMSDRGDesc] [varchar](180) NULL,
    [FacilityMSDRGWT] [varchar](10) NULL,
    [FacilityAPRDRG] [int] NULL,
    [FacilityAPRDRGDesc] [varchar](180) NULL,
    [FacilityAPRDRGWT] [varchar](10) NULL,
    [FacilityAPRDRGSOI] [int] NULL,
    [FacilityAPRDRGROM] [int] NULL,
    [CCMCC] [varchar](50) NULL,
    [MedicalServiceType] [varchar](100) NULL,
    [FinancialImpact] [varchar](20) NULL,
    [FinalLos] [varchar](20) NULL,
    [FacilityCharges] [varchar](20) NULL,
    [PhysicianSpecialty] [varchar](100) NULL,
    [QueryResponse] [varchar](500) NULL,
    [CDSID] [varchar](100) NULL,
    [ReReviewStatus] [tinyint] NOT NULL,
    [OUStay] [varchar](10) NULL,
    [ReReviewedCount] [tinyint] NOT NULL,
    [MSDRGServiceType] [varchar](25) NULL,
    [InitialReviewDate] [datetime] NULL,
    [AssignedDate] [datetime] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Metrics_CDSMetrics] PRIMARY KEY CLUSTERED 
(
    [CDSMetricsID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Metrics_CDSMetrics] ADD  CONSTRAINT [DF_Metrics_CDSMetrics_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[Metrics_CDSMetrics] ADD  CONSTRAINT [DF_Metrics_CDSMetrics_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_APRDRGInfo¶

Description:¶

Standard table which describes complete information about APRDRG data and maintaining versioning based on yearly from CMS website.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_APRDRGInfo]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_APRDRGInfo](
    [APRDRGInfoID] [int] IDENTITY(1,1) NOT NULL,
    [APRDRG] [varchar](10) NOT NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NOT NULL,
    [APRDRGMDC] [varchar](10) NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NOT NULL,
    [ROM] [int] NULL,
    [APRDRGType] [varchar](30) NULL,
    [APRDRGVersion] [int] NOT NULL,
    [EffectiveFrom] [datetime] NOT NULL,
    [EffectiveTo] [datetime] NOT NULL,
    [CurrentVersion] [bit] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_APRDRGInfo] PRIMARY KEY CLUSTERED 
(
    [APRDRGInfoID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_APRDRGInfo] ADD  CONSTRAINT [DF_MST_APRDRGInfo_CurrentVersion]  DEFAULT ((1)) FOR [CurrentVersion]
GO
ALTER TABLE [dbo].[MST_APRDRGInfo] ADD  CONSTRAINT [DF_MST_APRDRGInfo_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_APRDRGInfo] ADD  CONSTRAINT [DF_MST_APRDRGInfo_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_ClinicalElementType¶

Description:¶

Standard table which describes complete information about ClinicalElement's and where we are getting feed and type of feed to these ClinicalElements.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_ClinicalElementType]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ClinicalElementType](
    [ClinicalElementTypeId] [int] IDENTITY(1,1) NOT NULL,
    [ClinicalElementType] [varchar](50) NOT NULL,
    [Source] [varchar](50) NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_ClinicalElementType] PRIMARY KEY CLUSTERED 
(
    [ClinicalElementTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ClinicalElementType] ADD  CONSTRAINT [DF_MST_ClinicalElementType_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_ClinicalElementType] ADD  CONSTRAINT [DF_MST_ClinicalElementType_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_ClinicalElementType] ADD  CONSTRAINT [DF_MST_ClinicalElementType_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_DocumentCompletionStatus¶

Description:¶

Standard table which describes status information about patient document transcription whether transcription is complete or incomplete.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_DocumentCompletionStatus]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DocumentCompletionStatus](
    [DocumentCompletionStatusID] [int] IDENTITY(1,1) NOT NULL,
    [DocumentCompletionStatus] [varchar](100) NULL,
    [FinalStatus] [bit] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_DocumentCompletionStatus] PRIMARY KEY CLUSTERED 
(
    [DocumentCompletionStatusID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DocumentCompletionStatus] ADD  CONSTRAINT [DF_MST_DocumentCompletionStatus_FinalStatus]  DEFAULT ((0)) FOR [FinalStatus]
GO
ALTER TABLE [dbo].[MST_DocumentCompletionStatus] ADD  CONSTRAINT [DF_MST_DocumentCompletionStatus_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentCompletionStatus] ADD  CONSTRAINT [DF_MST_DocumentCompletionStatus_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

FinalStatus:

0 means Document Transcription Incomplete and 1 means Document Transcription completed.

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

Table Name:MST_DocumentRunningStatus¶

Description:¶

Standard table which describes information about patient document Analysis status.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_DocumentRunningStatus]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DocumentRunningStatus](
    [DocumentRunningStatusID] [int] NOT NULL,
    [DocumentRunningDesc] [varchar](100) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_DocumentRunningStatus] PRIMARY KEY CLUSTERED 
(
    [DocumentRunningStatusID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DocumentRunningStatus] ADD  CONSTRAINT [DF_MST_DocumentRunningStatus_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentRunningStatus] ADD  CONSTRAINT [DF_MST_DocumentRunningStatus_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

DocumentRunningStatusId:

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_FinancialClass]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_FinancialClass](
    [FinancialClassID] [varchar](30) NOT NULL,
    [FinancialClassName] [varchar](150) NULL,
    [FinancialClassAliasName] [varchar](150) NULL,
    [FinancialClassGroupName] [varchar](50) NULL,
    [PrimaryDRGGrouperID] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_FinancialClass] PRIMARY KEY CLUSTERED 
(
    [FinancialClassID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_FinancialClass]  WITH CHECK ADD  CONSTRAINT [FK_MST_FinancialClass_MST_PrimaryDRGGrouper] FOREIGN KEY([PrimaryDRGGrouperID])
REFERENCES [dbo].[MST_PrimaryDRGGrouper] ([PrimaryDRGGrouperID])
GO
ALTER TABLE [dbo].[MST_FinancialClass] CHECK CONSTRAINT [FK_MST_FinancialClass_MST_PrimaryDRGGrouper]
GO
ALTER TABLE [dbo].[MST_FinancialClass] ADD  CONSTRAINT [DF_MST_FinancialClass_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_FinancialClass] ADD  CONSTRAINT [DF_MST_FinancialClass_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

PrimaryDRGGrouperId:

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_QueryAlertCriteriaElement]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QueryAlertCriteriaElement](
    [CriteriaElementId] [int] IDENTITY(1,1) NOT NULL,
    [CriteriaElementType] [varchar](50) NOT NULL,
    [CriteriaElementName] [varchar](150) NOT NULL,
    [Source_UniqueId] [int] NOT NULL,
    [Source_Table] [varchar](80) NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_QueryAlertCriteriaElement] PRIMARY KEY CLUSTERED 
(
    [CriteriaElementId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElement] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElement_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElement] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElement_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElement] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElement_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

Source_UniqueId:

This id reprasents UniqueId of QueryAlert CriteriaElements Source table.

Active:

1 means Active and 0 menas InActive.

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

Table Name:MST_QueryAlertCriteriaElementMapping¶

Description:¶

Standard, relational and mapping table which describes relation between QueryAlerts ,QueryAlertCriteriaElements and QueryAlertLogicGroup.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_QueryAlertCriteriaElementMapping]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QueryAlertCriteriaElementMapping](
    [CriteriaElementMappingId] [int] IDENTITY(1,1) NOT NULL,
    [QueryAlertId] [int] NOT NULL,
    [CriteriaElementId] [int] NOT NULL,
    [ConditionType] [varchar](50) NULL,
    [GroupId] [int] NOT NULL,
    [MinValue] [float] NULL,
    [MaxValue] [float] NULL,
    [Route] [varchar](50) NULL,
    [Finding] [varchar](50) NULL,
    [History] [varchar](50) NULL,
    [HospitalDay] [int] NULL,
    [PDX] [tinyint] NULL,
    [POA] [varchar](5) NULL,
    [DocumentType] [varchar](50) NULL,
    [AgeFrom] [int] NULL,
    [AgeTo] [int] NULL,
    [Gender] [varchar](10) NULL,
    [TimePeriod] [int] NULL,
    [TimePeriodUnits] [varchar](10) NULL,
    [ConditionSpecificity] [varchar](50) NULL,
    [Priority] [int] NULL,
    [QueryCriteriaType] [varchar](50) NULL,
    [Frequency] [int] NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_QueryAlertCriteriaElementMapping] PRIMARY KEY CLUSTERED 
(
    [CriteriaElementMappingId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping]  WITH CHECK ADD  CONSTRAINT [FK_MST_QueryAlertCriteriaElementMapping_MST_QueryAlert] FOREIGN KEY([QueryAlertId])
REFERENCES [dbo].[MST_QueryAlert] ([QueryAlertId])
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] CHECK CONSTRAINT [FK_MST_QueryAlertCriteriaElementMapping_MST_QueryAlert]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping]  WITH CHECK ADD  CONSTRAINT [FK_MST_QueryAlertCriteriaElementMapping_MST_QueryAlertCriteriaElement] FOREIGN KEY([CriteriaElementId])
REFERENCES [dbo].[MST_QueryAlertCriteriaElement] ([CriteriaElementId])
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] CHECK CONSTRAINT [FK_MST_QueryAlertCriteriaElementMapping_MST_QueryAlertCriteriaElement]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElementMapping_GroupId]  DEFAULT ((0)) FOR [GroupId]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElementMapping_PDX]  DEFAULT ((0)) FOR [PDX]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElementMapping_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElementMapping_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_QueryAlertCriteriaElementMapping] ADD  CONSTRAINT [DF_MST_QueryAlertCriteriaElementMapping_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

QueryCriteriaType:

It describes a value like Threshold, Suggesive and Target.yet finally we only triger QueryAlerts to Threshold.

Active:

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_QueryAlertLogicGroup]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QueryAlertLogicGroup](
    [GroupId] [int] IDENTITY(1,1) NOT NULL,
    [QueryAlertId] [int] NOT NULL,
    [GroupName] [varchar](150) NOT NULL,
    [ParentId] [int] NULL,
    [ConditionCount] [int] NOT NULL,
    [Mandetory] [tinyint] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_QueryAlertLogicGroup] PRIMARY KEY CLUSTERED 
(
    [GroupId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QueryAlertLogicGroup] ADD  CONSTRAINT [DF_MST_QueryAlertLogicGroup_Mandetory]  DEFAULT ((1)) FOR [Mandetory]
GO
ALTER TABLE [dbo].[MST_QueryAlertLogicGroup] ADD  CONSTRAINT [DF_MST_QueryAlertLogicGroup_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_QueryAlertLogicGroup] ADD  CONSTRAINT [DF_MST_QueryAlertLogicGroup_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_QueryAlertLogicGroup] ADD  CONSTRAINT [DF_MST_QueryAlertLogicGroup_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

ConditionCount:

This count reprasents no of childs to Parent node and each and every node have a groupId.

Active:

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_Query_Template_Mapping]    Script Date: 08/22/2019 15:51:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MST_Query_Template_Mapping](
    [QTMappingId] [int] IDENTITY(1,1) NOT NULL,
    [QueryTypeId] [int] NOT NULL,
    [QueryDiagnosisId] [int] NOT NULL,
    [QueryTemplateId] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Query_Template_Mapping] PRIMARY KEY CLUSTERED 
(
    [QTMappingId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping]  WITH CHECK ADD  CONSTRAINT [FK_Query_Template_Mapping_MST_QueryDiagnosis] FOREIGN KEY([QueryDiagnosisId])
REFERENCES [dbo].[MST_QueryDiagnosis] ([QueryDiagnosisId])
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] CHECK CONSTRAINT [FK_Query_Template_Mapping_MST_QueryDiagnosis]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping]  WITH CHECK ADD  CONSTRAINT [FK_Query_Template_Mapping_MST_QueryTemplate] FOREIGN KEY([QueryTemplateId])
REFERENCES [dbo].[MST_QueryTemplate] ([QueryTemplateId])
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] CHECK CONSTRAINT [FK_Query_Template_Mapping_MST_QueryTemplate]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping]  WITH CHECK ADD  CONSTRAINT [FK_Query_Template_Mapping_MST_QueryType] FOREIGN KEY([QueryTypeId])
REFERENCES [dbo].[MST_QueryType] ([QueryTypeId])
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] CHECK CONSTRAINT [FK_Query_Template_Mapping_MST_QueryType]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] ADD  CONSTRAINT [DF_Query_Template_Mapping_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] ADD  CONSTRAINT [DF_Query_Template_Mapping_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_Query_Template_Mapping] ADD  CONSTRAINT [DF_Query_Template_Mapping_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_QueryTemplateParams¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_QueryTemplateParams]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QueryTemplateParams](
    [QTParamId] [int] IDENTITY(1,1) NOT NULL,
    [QueryTemplateId] [int] NOT NULL,
    [GeneralParam] [varchar](50) NULL,
    [PDFParam] [varchar](50) NULL,
    [DOCParam] [varchar](50) NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_QueryTemplateParams] PRIMARY KEY CLUSTERED 
(
    [QTParamId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QueryTemplateParams]  WITH CHECK ADD  CONSTRAINT [FK_MST_QueryTemplateParams_MST_QueryTemplate] FOREIGN KEY([QueryTemplateId])
REFERENCES [dbo].[MST_QueryTemplate] ([QueryTemplateId])
GO
ALTER TABLE [dbo].[MST_QueryTemplateParams] CHECK CONSTRAINT [FK_MST_QueryTemplateParams_MST_QueryTemplate]
GO
ALTER TABLE [dbo].[MST_QueryTemplateParams] ADD  CONSTRAINT [DF_MST_QueryTemplateParams_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_QueryTemplateParams] ADD  CONSTRAINT [DF_MST_QueryTemplateParams_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_QueryTemplateParams] ADD  CONSTRAINT [DF_MST_QueryTemplateParams_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_QueryType¶

Description:¶

Standard table which describes types of QueryAlert Names.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_QueryType]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_QueryType](
    [QueryTypeId] [int] IDENTITY(1,1) NOT NULL,
    [QueryTypeName] [varchar](150) NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_QueryType] PRIMARY KEY CLUSTERED 
(
    [QueryTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_QueryType] ADD  CONSTRAINT [DF_MST_QueryType_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[MST_QueryType] ADD  CONSTRAINT [DF_MST_QueryType_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_QueryType] ADD  CONSTRAINT [DF_MST_QueryType_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_ReminderType¶

Description:¶

Standard table which describes types of Reminders.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_ReminderType]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_ReminderType](
    [ReminderTypeId] [int] IDENTITY(1,1) NOT NULL,
    [ReminderType] [varchar](70) NOT NULL,
    [ReminderShortName] [varchar](50) NULL,
    [Score] [tinyint] NOT NULL,
    [Priority] [tinyint] NOT NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_ReminderType] PRIMARY KEY CLUSTERED 
(
    [ReminderTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_ReminderType] ADD  CONSTRAINT [DF_MST_ReminderType_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[MST_ReminderType] ADD  CONSTRAINT [DF_MST_ReminderType_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_ReminderType] ADD  CONSTRAINT [DF_MST_ReminderType_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_RoomInfo¶

Description:¶

Standard table no data yet.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_RoomInfo]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_RoomInfo](
    [RoomInfoID] [int] IDENTITY(1,1) NOT NULL,
    [RoomNo] [varchar](30) NULL,
    [BedNo] [varchar](30) NULL,
    [BuildingName] [varchar](80) NULL,
    [FloorName] [varchar](80) NULL,
    [NursingStationID] [varchar](30) NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_RoomInfo] PRIMARY KEY CLUSTERED 
(
    [RoomInfoID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_RoomInfo]  WITH CHECK ADD  CONSTRAINT [FK_MST_RoomInfo_MST_NursingStation] FOREIGN KEY([NursingStationID])
REFERENCES [dbo].[MST_NursingStation] ([NursingStationID])
GO
ALTER TABLE [dbo].[MST_RoomInfo] CHECK CONSTRAINT [FK_MST_RoomInfo_MST_NursingStation]
GO
ALTER TABLE [dbo].[MST_RoomInfo] ADD  CONSTRAINT [DF_MST_RoomInfo_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_RoomInfo] ADD  CONSTRAINT [DF_MST_RoomInfo_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_SectionHeader¶

Description:¶

Standard table which describes All Patient Document headings.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_SectionHeader]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_SectionHeader](
    [SectionHeaderID] [int] IDENTITY(1,1) NOT NULL,
    [SectionHeader] [varchar](200) NULL,
    [AliasName] [varchar](200) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_SectionHeader] PRIMARY KEY CLUSTERED 
(
    [SectionHeaderID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_SectionHeader] ADD  CONSTRAINT [DF_MST_SectionHeader_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_SectionHeader] ADD  CONSTRAINT [DF_MST_SectionHeader_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_VitalSignDictionary¶

Description:¶

Standard table which describes infromation about All VitalSigns and its related data.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_VitalSignDictionary]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_VitalSignDictionary](
    [VitalSignDictionaryId] [int] IDENTITY(1,1) NOT NULL,
    [UniqueId] [int] NOT NULL,
    [LoincCode] [varchar](50) NULL,
    [VitalSignMnemonic] [varchar](100) NULL,
    [VitalSignAbbrevation] [varchar](100) NULL,
    [VitalSign] [varchar](100) NULL,
    [Department] [varchar](50) NULL,
    [Units] [varchar](25) NULL,
    [Gender] [varchar](10) NULL,
    [MinRange] [float] NULL,
    [MaxRange] [float] NULL,
    [PanicMinRange] [float] NULL,
    [PanicMaxRange] [float] NULL,
    [AgeFrom] [int] NOT NULL,
    [AgeTo] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_VitalSignDictionary] PRIMARY KEY CLUSTERED 
(
    [VitalSignDictionaryId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_VitalSignDictionary] ADD  CONSTRAINT [DF_MST_VitalSignDictionary_AgeFrom]  DEFAULT ((0)) FOR [AgeFrom]
GO
ALTER TABLE [dbo].[MST_VitalSignDictionary] ADD  CONSTRAINT [DF_MST_VitalSignDictionary_AgeTo]  DEFAULT ((54750)) FOR [AgeTo]
GO
ALTER TABLE [dbo].[MST_VitalSignDictionary] ADD  CONSTRAINT [DF_MST_VitalSignDictionary_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_VitalSignDictionary] ADD  CONSTRAINT [DF_MST_VitalSignDictionary_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_VitalSignReference¶

Description:¶

Standard table which describes information about VitalSigns and its Reference ranges.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_VitalSignReference]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_VitalSignReference](
    [VitalSignReferenceID] [int] IDENTITY(1,1) NOT NULL,
    [VitalSign] [varchar](150) NOT NULL,
    [LOINCCode] [varchar](50) NULL,
    [AlphaReferenceRange] [varchar](50) NULL,
    [LowThreshold] [float] NULL,
    [HighThreshold] [float] NULL,
    [PanicLowThreshold] [float] NULL,
    [PanicHighThreshold] [float] NULL,
    [Gender] [varchar](10) NULL,
    [AgeFrom] [int] NOT NULL,
    [AgeTo] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_VitalSignReference] PRIMARY KEY CLUSTERED 
(
    [VitalSignReferenceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_VitalSignReference] ADD  CONSTRAINT [DF_MST_VitalSignReference_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_VitalSignReference] ADD  CONSTRAINT [DF_MST_VitalSignReference_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:MST_VitalSignSynonym¶

Description:¶

Standard table which describes Synonyms of all VitalSigns and its related data.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[MST_VitalSignSynonym]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_VitalSignSynonym](
    [VitalSignSynonymId] [int] IDENTITY(1,1) NOT NULL,
    [UniqueId] [int] NOT NULL,
    [VitalSignSynonym] [varchar](100) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_VitalSignSynonym] PRIMARY KEY CLUSTERED 
(
    [VitalSignSynonymId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_VitalSignSynonym] ADD  CONSTRAINT [DF_MST_VitalSignSynonym_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_VitalSignSynonym] ADD  CONSTRAINT [DF_MST_VitalSignSynonym_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_Allergy¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_Allergy]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_Allergy](
    [AllergyId] [int] IDENTITY(1,1) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [Content] [varchar](250) NULL,
    [Medicine] [varchar](250) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_Allergy] PRIMARY KEY CLUSTERED 
(
    [AllergyId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_Allergy] ADD  CONSTRAINT [DF_NLP_Allergy_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Allergy] ADD  CONSTRAINT [DF_NLP_Allergy_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_AllICDDRG¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_AllICDDRG]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_AllICDDRG](
    [AllICDDRGID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MSDRG] [varchar](10) NULL,
    [MSDRGDesc] [varchar](250) NULL,
    [MSDRGWeight] [float] NULL,
    [MSDRGMDC] [varchar](10) NULL,
    [MSDRGGLOS] [float] NULL,
    [MSDRGALOS] [float] NULL,
    [APRDRG] [varchar](10) NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NULL,
    [APRDRGMDC] [varchar](10) NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NULL,
    [ROM] [int] NULL,
    [TotalCharge] [varchar](20) NULL,
    [TotalCost] [varchar](20) NULL,
    [VarianceCharge] [varchar](20) NULL,
    [VarianceCost] [varchar](20) NULL,
    [ExpectedReimbursement] [varchar](20) NULL,
    [TotalExpected] [varchar](20) NULL,
    [PrimaryDxCode] [varchar](10) NULL,
    [PrimaryPcsCode] [varchar](10) NULL,
    [ApplicationUserId] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DischargePosition] [int] NOT NULL,
 CONSTRAINT [PK_NLP_AllICDDRG] PRIMARY KEY CLUSTERED 
(
    [AllICDDRGID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_AllICDDRG] ADD  CONSTRAINT [DF_NLP_AllICDDRG_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_AllICDDRG] ADD  CONSTRAINT [DF_NLP_AllICDDRG_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DRG¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DRG]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DRG](
    [DRGID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [MSDRG] [varchar](10) NOT NULL,
    [MSDRGDesc] [varchar](250) NULL,
    [MSDRGWeight] [float] NOT NULL,
    [MSDRGMDC] [varchar](10) NOT NULL,
    [MSDRGGLOS] [float] NOT NULL,
    [MSDRGALOS] [float] NOT NULL,
    [APRDRG] [varchar](10) NULL,
    [APRDRGDesc] [varchar](250) NULL,
    [APRDRGWeight] [float] NOT NULL,
    [APRDRGMDC] [varchar](10) NOT NULL,
    [APRDRGGLOS] [float] NULL,
    [APRDRGALOS] [float] NULL,
    [SOI] [int] NULL,
    [ROM] [int] NULL,
    [TotalCharge] [varchar](20) NULL,
    [TotalCost] [varchar](20) NULL,
    [VarianceCharge] [varchar](20) NULL,
    [VarianceCost] [varchar](20) NULL,
    [ExpectedReimbursement] [varchar](20) NULL,
    [TotalExpected] [varchar](20) NULL,
    [PrimaryDxCode] [varchar](10) NULL,
    [PrimaryPcsCode] [varchar](10) NULL,
    [UserName] [varchar](30) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DRG] PRIMARY KEY CLUSTERED 
(
    [DRGID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_DRG] 
(
    [AccountNumber] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_DRG] ADD  CONSTRAINT [DF_NLP_DRG_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DRG] ADD  CONSTRAINT [DF_NLP_DRG_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DXAnnotation¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXAnnotation]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXAnnotation](
    [DxAnnotationId] [int] IDENTITY(1,1) NOT NULL,
    [AnnotationId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [Disorder] [varchar](100) NULL,
    [Cause] [varchar](100) NULL,
    [Manifestation] [varchar](100) NULL,
    [Site] [varchar](50) NULL,
    [Site1] [varchar](50) NULL,
    [Site2] [varchar](50) NULL,
    [TConcept1] [varchar](100) NULL,
    [TConcept2] [varchar](100) NULL,
    [Type] [varchar](100) NULL,
    [Stage] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [Modifieddate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DxAnnotation] PRIMARY KEY CLUSTERED 
(
    [DxAnnotationId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_DXAnnotation] 
(
    [AccountNumber] ASC,
    [TConcept1] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_DXAnnotation] ADD  CONSTRAINT [DF_NLP_DxAnnotation_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXAnnotation] ADD  CONSTRAINT [DF_NLP_DxAnnotation_ModifiedDate]  DEFAULT (getutcdate()) FOR [Modifieddate]
GO

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

Table Name:NLP_DXCode¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXCode]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXCode](
    [DxCodeId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [DxCode] [varchar](10) NULL,
    [DxDesc] [varchar](250) NULL,
    [Poa] [varchar](10) NULL,
    [DxType] [varchar](50) NULL,
    [DxPriority] [int] NOT NULL,
    [CcMcc] [varchar](20) NULL,
    [PhysicianId] [varchar](30) NULL,
    [DxDate] [datetime] NULL,
    [UserName] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [DxCodeSource] [varchar](100) NULL,
    [DxExclusionTypeId] [tinyint] NOT NULL,
 CONSTRAINT [PK_NLP_DxCode] PRIMARY KEY CLUSTERED 
(
    [DxCodeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_DXCode] 
(
    [AccountNumber] ASC,
    [DxCode] ASC,
    [DxExclusionTypeId] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_DXCode] ADD  CONSTRAINT [DF_NLP_DxCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXCode] ADD  CONSTRAINT [DF_NLP_DxCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[NLP_DXCode] ADD  DEFAULT ((0)) FOR [DxExclusionTypeId]
GO

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

Table Name:NLP_DXCode_Audit¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXCode_Audit]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXCode_Audit](
    [DxCodeAuditId] [int] IDENTITY(1,1) NOT NULL,
    [DxCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DxCode] [varchar](10) NULL,
    [DXCodeWeight] [float] NULL,
    [AuditType] [tinyint] NOT NULL,
    [AuditorId] [int] NOT NULL,
    [Reason] [varchar](250) NULL,
    [Note] [varchar](250) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DxCode_Audit] PRIMARY KEY CLUSTERED 
(
    [DxCodeAuditId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DXCode_Audit] ADD  CONSTRAINT [DF_NLP_DxCode_Audit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXCode_Audit] ADD  CONSTRAINT [DF_NLP_DxCode_Audit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DXCodeByDocument¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXCodeByDocument]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXCodeByDocument](
    [DxCodeId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [DxCode] [varchar](10) NULL,
    [AnnotationString] [varchar](250) NULL,
    [Poa] [varchar](5) NULL,
    [SectionHeader] [varchar](200) NULL,
    [Finding] [varchar](20) NULL,
    [History] [varchar](10) NULL,
    [UserName] [varchar](50) NULL,
    [AnnotationId] [int] NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [RStatus] [tinyint] NOT NULL,
    [DxCodeSource] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [Codable] [varchar](2) NULL,
 CONSTRAINT [PK_NLP_DxCodeByDocument] PRIMARY KEY CLUSTERED 
(
    [DxCodeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_DXCodeByDocument] 
(
    [AccountNumber] ASC,
    [DxCode] ASC,
    [Finding] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_DXCodeByDocument] ADD  CONSTRAINT [DF_NLP_DxCodeByDocument_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_DXCodeByDocument] ADD  CONSTRAINT [DF_NLP_DxCodeByDocument_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXCodeByDocument] ADD  CONSTRAINT [DF_NLP_DxCodeByDocument_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DXCodeCombination¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXCodeCombination]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXCodeCombination](
    [DxCodeCombinationId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [CombinationCode] [varchar](10) NULL,
    [RootCode] [varchar](10) NULL,
    [CombinationType] [varchar](50) NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DxCodeCombination] PRIMARY KEY CLUSTERED 
(
    [DxCodeCombinationId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DXCodeCombination] ADD  CONSTRAINT [DF_NLP_DxCodeCombination_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_DXCodeCombination] ADD  CONSTRAINT [DF_NLP_DxCodeCombination_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXCodeCombination] ADD  CONSTRAINT [DF_NLP_DxCodeCombination_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DXCodeEvidence¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXCodeEvidence]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXCodeEvidence](
    [DxCodeEvidenceId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [DxCode] [varchar](10) NULL,
    [AnnotationString] [varchar](250) NULL,
    [AnnotationType] [varchar](50) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [UserName] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DxCodeEvidance] PRIMARY KEY CLUSTERED 
(
    [DxCodeEvidenceId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DXCodeEvidence] ADD  CONSTRAINT [DF_NLP_DxCodeEvidence_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXCodeEvidence] ADD  CONSTRAINT [DF_NLP_DxCodeEvidence_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_DXFactor¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_DXFactor]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_DXFactor](
    [DxFactorId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [FactorName] [varchar](200) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_DxFactor] PRIMARY KEY CLUSTERED 
(
    [DxFactorId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_DXFactor] 
(
    [AccountNumber] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_DXFactor] ADD  CONSTRAINT [DF_NLP_DxFactor_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DXFactor] ADD  CONSTRAINT [DF_NLP_DxFactor_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_FXAnnotations¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_FXAnnotations]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_FXAnnotations](
    [FXAnnotationId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [FDX] [varchar](200) NULL,
    [FBPart1] [varchar](100) NULL,
    [FBPart2] [varchar](100) NULL,
    [FBLoc1] [varchar](100) NULL,
    [FBLoc2] [varchar](100) NULL,
    [Position] [varchar](50) NULL,
    [FTNT] [varchar](100) NULL,
    [Effect] [varchar](100) NULL,
    [ForeignBody] [varchar](100) NULL,
    [FDermis] [varchar](100) NULL,
    [FDnd] [varchar](100) NULL,
    [FStage] [varchar](100) NULL,
    [FType] [varchar](100) NULL,
    [FType2] [varchar](100) NULL,
    [ICD10Code] [varchar](100) NULL,
    [Encounter] [varchar](100) NULL,
    [Reason] [varchar](200) NULL,
    [FType3] [varchar](100) NULL,
    [RStatus] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_FXAnnotations] PRIMARY KEY CLUSTERED 
(
    [FXAnnotationId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_FXAnnotations] ADD  CONSTRAINT [DF_NLP_FXAnnotations_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_FXAnnotations] ADD  CONSTRAINT [DF_NLP_FXAnnotations_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_FXAnnotations] ADD  CONSTRAINT [DF_NLP_FXAnnotations_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_FXValues¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_FXValues]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_FXValues](
    [FXValueId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [FBPart1] [varchar](200) NULL,
    [FDX] [varchar](200) NULL,
    [ElementType] [varchar](100) NULL,
    [ElementName] [varchar](100) NULL,
    [RStatus] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_FXValues] PRIMARY KEY CLUSTERED 
(
    [FXValueId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_FXValues] ADD  CONSTRAINT [DF_NLP_FXValues_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_FXValues] ADD  CONSTRAINT [DF_NLP_FXValues_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_FXValues] ADD  CONSTRAINT [DF_NLP_FXValues_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_Habit¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_Habit]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_Habit](
    [HabitId] [int] IDENTITY(1,1) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [Content] [varchar](250) NULL,
    [HabitType] [varchar](250) NULL,
    [Condition] [varchar](100) NULL,
    [History] [varchar](10) NULL,
    [Finding] [varchar](20) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_Habit] PRIMARY KEY CLUSTERED 
(
    [HabitId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_Habit] ADD  CONSTRAINT [DF_NLP_Habit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Habit] ADD  CONSTRAINT [DF_NLP_Habit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_Lab¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_Lab]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_Lab](
    [LabID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [TestName] [varchar](150) NULL,
    [Result] [varchar](150) NULL,
    [NumericResult] [float] NULL,
    [Unit] [varchar](50) NULL,
    [ReferenceRange] [varchar](30) NULL,
    [LabTestDate] [datetime] NULL,
    [LOINCCode] [varchar](50) NULL,
    [SectionHeader] [varchar](200) NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [Deviation] [float] NULL,
    [DeviationType] [varchar](15) NULL,
    [MinRange] [float] NULL,
    [MaxRange] [float] NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_NLP_Lab] PRIMARY KEY CLUSTERED 
(
    [LabID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_Lab]  WITH CHECK ADD  CONSTRAINT [FK_NLP_Lab_HIM_Document] FOREIGN KEY([DocumentID])
REFERENCES [dbo].[HIM_Document] ([DocumentID])
GO
ALTER TABLE [dbo].[NLP_Lab] CHECK CONSTRAINT [FK_NLP_Lab_HIM_Document]
GO
ALTER TABLE [dbo].[NLP_Lab] ADD  CONSTRAINT [DF_NLP_Lab_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Lab] ADD  CONSTRAINT [DF_NLP_Lab_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_MedicalConcept¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_MedicalConcept]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_MedicalConcept](
    [MedicalConceptId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [SectionHeader] [varchar](150) NULL,
    [MedicalConcept] [varchar](250) NULL,
    [MedicalConceptType] [varchar](50) NULL,
    [Finding] [varchar](50) NULL,
    [History] [varchar](10) NULL,
    [StartId] [int] NOT NULL,
    [EndId] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_MedicalConcept] PRIMARY KEY CLUSTERED 
(
    [MedicalConceptId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_MedicalConcept] ADD  CONSTRAINT [DF_NLP_MedicalConcept_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_MedicalConcept] ADD  CONSTRAINT [DF_NLP_MedicalConcept_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_PCSCode¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_PCSCode]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_PCSCode](
    [PCSCodeID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [PCSDesc] [varchar](250) NULL,
    [PCSType] [varchar](10) NULL,
    [PCSPriority] [int] NOT NULL,
    [PhysicianID] [varchar](30) NULL,
    [PCSDate] [datetime] NULL,
    [UserName] [varchar](50) NULL,
    [PcsExclusionTypeId] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_PCSCode] PRIMARY KEY CLUSTERED 
(
    [PCSCodeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_PCSCode] 
(
    [AccountNumber] ASC,
    [PCSCode] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD  CONSTRAINT [DF_NLP_PCSCode_RStatus]  DEFAULT ((0)) FOR [PcsExclusionTypeId]
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD  CONSTRAINT [DF_NLP_PCSCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD  CONSTRAINT [DF_NLP_PCSCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_PCSCode_Audit¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_PCSCode_Audit]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_PCSCode_Audit](
    [PCSCodeAuditId] [int] IDENTITY(1,1) NOT NULL,
    [PCSCodeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [AuditType] [tinyint] NOT NULL,
    [AuditorId] [int] NOT NULL,
    [Reason] [varchar](250) NULL,
    [Note] [varchar](250) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_PCSCode_Audit] PRIMARY KEY CLUSTERED 
(
    [PCSCodeAuditId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_PCSCode_Audit] ADD  CONSTRAINT [DF_NLP_PCSCode_Audit_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCode_Audit] ADD  CONSTRAINT [DF_NLP_PCSCode_Audit_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_PCSCodeByDocument¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_PCSCodeByDocument]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_PCSCodeByDocument](
    [PCSCodeID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [PCSDesc] [varchar](250) NULL,
    [PhysicianID] [varchar](30) NULL,
    [PCSDate] [datetime] NULL,
    [UserName] [varchar](50) NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [SectionHeader] [varchar](200) NULL,
    [Finding] [varchar](20) NULL,
    [History] [varchar](10) NULL,
 CONSTRAINT [PK_NLP_PCSCodeByDocument] PRIMARY KEY CLUSTERED 
(
    [PCSCodeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_AccountNumber] ON [dbo].[NLP_PCSCodeByDocument] 
(
    [AccountNumber] ASC,
    [PCSCode] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_PCSCodeByDocument] ADD  CONSTRAINT [DF_NLP_PCSCodeByDocument_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_PCSCodeByDocument] ADD  CONSTRAINT [DF_NLP_PCSCodeByDocument_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCodeByDocument] ADD  CONSTRAINT [DF_NLP_PCSCodeByDocument_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_PCSCodeEvidance¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_PCSCodeEvidance]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_PCSCodeEvidance](
    [PCSCodeEvidanceID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [PCSCode] [varchar](10) NULL,
    [PCSTerm] [varchar](100) NULL,
    [PCSType] [varchar](20) NULL,
    [StartId] [int] NOT NULL,
    [EndId] [int] NOT NULL,
    [UserName] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_PCSCodeEvidance] PRIMARY KEY CLUSTERED 
(
    [PCSCodeEvidanceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_PCSCodeEvidance] ADD  CONSTRAINT [DF_NLP_PCSCodeEvidance_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCodeEvidance] ADD  CONSTRAINT [DF_NLP_PCSCodeEvidance_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_QueryAlert_MedicalConcept¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_QueryAlert_MedicalConcept]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_QueryAlert_MedicalConcept](
    [QAMedicalConceptId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [MedicalConcept] [varchar](150) NULL,
    [Finding] [varchar](25) NULL,
    [History] [varchar](25) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_QueryAlert_MedicalConcept] PRIMARY KEY CLUSTERED 
(
    [QAMedicalConceptId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_Finding] ON [dbo].[NLP_QueryAlert_MedicalConcept] 
(
    [Finding] ASC
)
INCLUDE ( [QAMedicalConceptId],
[AccountNumber],
[DocumentId],
[MedicalConcept]) 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]
GO
ALTER TABLE [dbo].[NLP_QueryAlert_MedicalConcept] ADD  CONSTRAINT [DF_NLP_QueryAlert_MedicalConcept_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[NLP_QueryAlert_MedicalConcept] ADD  CONSTRAINT [DF_NLP_QueryAlert_MedicalConcept_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_QueryAlert_MedicalConcept] ADD  CONSTRAINT [DF_NLP_QueryAlert_MedicalConcept_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_QueryDOCKeyword¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_QueryDOCKeyword]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_QueryDOCKeyword](
    [QueryDocKeywordId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [AnnotationString] [varchar](500) NULL,
    [Result] [varchar](50) NULL,
    [Unit] [varchar](50) NULL,
    [Route] [varchar](50) NULL,
    [SemanticType] [varchar](50) NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_QueryDocKeyword] PRIMARY KEY CLUSTERED 
(
    [QueryDocKeywordId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_QueryDOCKeyword] ADD  CONSTRAINT [DF_QueryDocKeyword_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_QueryDOCKeyword] ADD  CONSTRAINT [DF_NLP_QueryDocKeyword_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_QueryDOCKeyword] ADD  CONSTRAINT [DF_NLP_QueryDocKeyword_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_RadiologyImpression¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_RadiologyImpression]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_RadiologyImpression](
    [RadiologyImpressionId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](25) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [RadiologyImpression] [varchar](1500) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_RadiologyImpression] PRIMARY KEY CLUSTERED 
(
    [RadiologyImpressionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_RadiologyImpression] ADD  CONSTRAINT [DF_NLP_RadiologyImpression_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_RadiologyImpression] ADD  CONSTRAINT [DF_NLP_RadiologyImpression_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_SectionHeader¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_SectionHeader]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_SectionHeader](
    [SectionHeaderID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [SectionHeader] [varchar](100) NULL,
    [StartId] [int] NOT NULL,
    [EndId] [int] NOT NULL,
    [RStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_SectionHeader] PRIMARY KEY CLUSTERED 
(
    [SectionHeaderID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_SectionHeader] ADD  CONSTRAINT [DF_NLP_SectionHeader_StartId]  DEFAULT ((0)) FOR [StartId]
GO
ALTER TABLE [dbo].[NLP_SectionHeader] ADD  CONSTRAINT [DF_NLP_SectionHeader_EndId]  DEFAULT ((0)) FOR [EndId]
GO
ALTER TABLE [dbo].[NLP_SectionHeader] ADD  CONSTRAINT [DF_NLP_SectionHeader_RStatus]  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_SectionHeader] ADD  CONSTRAINT [DF_NLP_SectionHeader_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_SectionHeader] ADD  CONSTRAINT [DF_NLP_SectionHeader_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_VitalSign¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_VitalSign]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_VitalSign](
    [VitalSignID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentID] [int] NOT NULL,
    [VitalSign] [varchar](150) NULL,
    [Result] [varchar](150) NULL,
    [NumericResult] [float] NULL,
    [NumericResult2] [float] NULL,
    [Unit] [varchar](30) NULL,
    [VitalSignDate] [datetime] NULL,
    [LOINCCode] [varchar](50) NULL,
    [SectionHeader] [varchar](200) NULL,
    [StartId] [int] NULL,
    [EndId] [int] NULL,
    [HospitalDay] [int] NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [UniqueId] [int] NULL,
 CONSTRAINT [PK_NLP_VitalSign] PRIMARY KEY CLUSTERED 
(
    [VitalSignID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [Ncix_DocumentId] ON [dbo].[NLP_VitalSign] 
(
    [DocumentID] ASC,
    [Result] ASC,
    [NumericResult] 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, FILLFACTOR = 80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NLP_VitalSign] ADD  CONSTRAINT [DF_NLP_VitalSign_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_VitalSign] ADD  CONSTRAINT [DF_NLP_VitalSign_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_VSeriesCode¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_VSeriesCode]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_VSeriesCode](
    [VSeriesCodeId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NULL,
    [DocumentId] [int] 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] NOT NULL,
    [UserName] [varchar](50) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_VSeriesCode] PRIMARY KEY CLUSTERED 
(
    [VSeriesCodeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_VSeriesCode] ADD  CONSTRAINT [DF_NLP_VSeriesCode_Rstatus]  DEFAULT ((0)) FOR [Rstatus]
GO
ALTER TABLE [dbo].[NLP_VSeriesCode] ADD  CONSTRAINT [DF_NLP_VSeriesCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_VSeriesCode] ADD  CONSTRAINT [DF_NLP_VSeriesCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:NLP_WSeriesCode¶

Description:¶

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[NLP_WSeriesCode]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NLP_WSeriesCode](
    [WSeriesCodeId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NULL,
    [DocumentId] [int] NOT NULL,
    [Keyterm] [varchar](100) NULL,
    [Keytype] [varchar](50) NULL,
    [Action] [varchar](50) NULL,
    [State] [varchar](10) NULL,
    [UserName] [varchar](20) NULL,
    [Code] [varchar](10) NULL,
    [RStatus] [tinyint] NOT NULL,
    [StandardDisorder] [varchar](100) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NLP_WSeriesCode] PRIMARY KEY CLUSTERED 
(
    [WSeriesCodeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_WSeriesCode] ADD  DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_WSeriesCode] ADD  CONSTRAINT [DF_NLP_WSeriesCode_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_WSeriesCode] ADD  CONSTRAINT [DF_NLP_WSeriesCode_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:OTR_SyncProcess¶

Description:¶

Synchronization table which describes synchronization of data between HL7 and Hrcm to Patient Documents and its ADT information.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[OTR_SyncProcess]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OTR_SyncProcess](
    [SyncProcessID] [int] IDENTITY(1,1) NOT NULL,
    [SyncProcess] [varchar](100) NULL,
    [SyncProcessDesc] [varchar](250) NULL,
    [StartDate] [datetime] NOT NULL,
    [EndDate] [datetime] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_OTR_SyncProcess] PRIMARY KEY CLUSTERED 
(
    [SyncProcessID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[OTR_SyncProcess] ADD  CONSTRAINT [DF_OTR_SyncProcess_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[OTR_SyncProcess] ADD  CONSTRAINT [DF_OTR_SyncProcess_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:TMP_DRG¶

Description:¶

This is the backup table for Reimbursement data like MSDRG,APRDRG,ChargesInfo,DXCodes and PCSCodes which are from FTP.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[TMP_DRG]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TMP_DRG](
    [AccountNo] [varchar](50) NOT NULL,
    [TotalCharges] [varchar](50) NULL,
    [TotalCost] [varchar](50) NULL,
    [VarianceCharges] [varchar](50) NULL,
    [VarianceCosts] [varchar](50) NULL,
    [ExpectedReimbursement] [varchar](50) NULL,
    [TotalExpected] [varchar](50) NULL,
    [ActualPrimary] [varchar](50) NULL,
    [ActualSecondary] [varchar](50) NULL,
    [CompleteForBilling] [datetime] NULL,
    [DRG] [varchar](50) NULL,
    [DRGDesc] [varchar](250) NULL,
    [MDC] [varchar](50) NULL,
    [MDCDesc] [varchar](250) NULL,
    [DRGWeight] [varchar](50) NULL,
    [AMLOS] [varchar](50) NULL,
    [GMLOS] [varchar](50) NULL,
    [LOS] [varchar](50) NULL,
    [APR] [varchar](50) NULL,
    [APRDesc] [varchar](120) NULL,
    [APRWeight] [varchar](50) NULL,
    [SvrtyCode] [varchar](50) NULL,
    [SvrtyDesc] [varchar](100) NULL,
    [MortalityCode] [varchar](50) NULL,
    [MortalityDesc] [varchar](100) NULL,
    [DiagCode] [varchar](50) NULL,
    [DiagDesc] [varchar](250) NULL,
    [DiagType] [varchar](50) NULL,
    [PresentAtAdmit] [varchar](10) NULL,
    [ProCode] [varchar](50) NULL,
    [ProDesc] [varchar](250) NULL,
    [APR_MDC] [varchar](50) NULL,
    [APR_MDC_Desc] [varchar](150) NULL,
    [APR_AM_LOS] [varchar](50) NULL,
    [APR_GM_LOS] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

Table Name:TMP_IPMedication¶

Description:¶

This is the Backup table for IPMedications which are from FTP

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[TMP_IPMedication]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TMP_IPMedication](
    [Encounter] [varchar](20) NOT NULL,
    [MedicationDate] [datetime] NULL,
    [Dose] [varchar](100) NULL,
    [Route] [varchar](150) NULL,
    [MedicationMnemonic] [varchar](150) NULL,
    [MedicationName] [varchar](350) NULL,
    [Brand] [varchar](50) NULL,
    [OrderType] [varchar](150) NULL,
    [Category] [varchar](50) NULL,
    [MedStopDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

Table Name:TMP_Lab¶

Description:¶

It is a Backup table for Laboratory data which are from FTP.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[TMP_Lab]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TMP_Lab](
    [Encounter] [varchar](20) NOT NULL,
    [LabDateTime] [datetime] NULL,
    [TestMnemonic] [varchar](50) NULL,
    [TestName] [varchar](150) NULL,
    [Result] [varchar](150) NULL,
    [ReferenceRange] [varchar](200) NULL,
    [Unit] [varchar](50) NULL,
    [Department] [varchar](50) NULL,
    [LabOrder] [varchar](50) NULL,
    [LastActivity] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

Table Name:TMP_NurseNote¶

Description:¶

It is a Backup table for NurseNote data and which are from FTP.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[TMP_NurseNote]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TMP_NurseNote](
    [AccNo] [varchar](50) NOT NULL,
    [DocumentDateTime] [datetime] NULL,
    [NursingDateTime] [datetime] NULL,
    [VSQuery] [varchar](50) NULL,
    [VSQueryDescription] [varchar](max) NULL,
    [VSQueryValue] [varchar](500) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

Table Name:TMP_VitalSign¶

Description:¶

It is a Backup table for VitalSign data and which are from FTP.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[TMP_VitalSign]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TMP_VitalSign](
    [AccountNo] [varchar](20) NOT NULL,
    [VitalDate] [datetime] NULL,
    [VitalName] [varchar](50) NULL,
    [Result] [varchar](250) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

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

Table Name:USER_AccountNote¶

Description:¶

User table which describes information about user notes provided by User.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_AccountNote]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_AccountNote](
    [NoteId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [NoteBy] [int] NOT NULL,
    [Note] [varchar](150) NULL,
    [InitialNoteStatus] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_AccountNote] PRIMARY KEY CLUSTERED 
(
    [NoteId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_AccountNote] ADD  CONSTRAINT [DF_USER_AccountNote_InitialNoteStatus]  DEFAULT ((0)) FOR [InitialNoteStatus]
GO
ALTER TABLE [dbo].[USER_AccountNote] ADD  CONSTRAINT [DF_User_AccountNote_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_AccountNote] ADD  CONSTRAINT [DF_User_AccountNote_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

InitialNoteStatus:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_AssignedAccount]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_AssignedAccount](
    [AssignedId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [AssignedBy] [int] NOT NULL,
    [AssignTo] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_AssignedAccount] PRIMARY KEY CLUSTERED 
(
    [AssignedId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_AssignedAccount] ADD  CONSTRAINT [DF_User_AssignedAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_AssignedAccount] ADD  CONSTRAINT [DF_User_AssignedAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

AssignBy:

User it self an Account to Assigned.

AssignTo:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_Discussion]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_Discussion](
    [DiscussionID] [int] IDENTITY(1,1) NOT NULL,
    [ParentId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [Note] [varchar](250) NULL,
    [CreatedBy] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_Discussion] PRIMARY KEY CLUSTERED 
(
    [DiscussionID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_Discussion] ADD  CONSTRAINT [DF_User_Discussion_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[USER_Discussion] ADD  CONSTRAINT [DF_User_Discussion_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_Discussion] ADD  CONSTRAINT [DF_User_Discussion_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

Active:

1 means Current record and 0 means old record.

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

Table Name:USER_DocumentReview¶

Description:¶

User table which describes log information about documents reviewed by user.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_DocumentReview]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_DocumentReview](
    [DocumentReviewId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [DocumentId] [int] NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [ApplicationUserId] [int] NOT NULL,
    [ApplicationRoleId] [int] NOT NULL,
    [ReviewStatus] [bit] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Log_DocumentReview] PRIMARY KEY CLUSTERED 
(
    [DocumentReviewId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_DocumentReview] ADD  CONSTRAINT [DF_Log_DocumentReview_ReviewStatus]  DEFAULT ((1)) FOR [ReviewStatus]
GO
ALTER TABLE [dbo].[USER_DocumentReview] ADD  CONSTRAINT [DF_Log_DocumentReview_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_DocumentReview] ADD  CONSTRAINT [DF_Log_DocumentReview_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

ReviewStatus:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_DQView]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_DQView](
    [DqViewId] [int] IDENTITY(1,1) NOT NULL,
    [ViewName] [varchar](50) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [ApplicationUserId] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [SysDefault] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_DqView] PRIMARY KEY CLUSTERED 
(
    [DqViewId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_DQView] ADD  CONSTRAINT [DF_User_DqView_SysDefault]  DEFAULT ((0)) FOR [SysDefault]
GO
ALTER TABLE [dbo].[USER_DQView] ADD  CONSTRAINT [DF_User_DqView_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_DQView] ADD  CONSTRAINT [DF_User_DqView_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

SysDefault:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_FollowupAccount]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_FollowupAccount](
    [FollowupId] [int] IDENTITY(1,1) NOT NULL,
    [FollowupTypeId] [int] NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [ModuleId] [int] NOT NULL,
    [PageId] [int] NOT NULL,
    [FollowupBy] [int] NOT NULL,
    [FollowupDate] [date] NOT NULL,
    [Priority] [varchar](50) NULL,
    [Note] [varchar](500) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
    [Active] [tinyint] NOT NULL,
 CONSTRAINT [PK_User_FollowupAccount] PRIMARY KEY CLUSTERED 
(
    [FollowupId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_FollowupAccount]  WITH CHECK ADD  CONSTRAINT [FK_User_FollowupAccount_MST_FollowupType] FOREIGN KEY([FollowupTypeId])
REFERENCES [dbo].[MST_FollowupType] ([FollowupTypeId])
GO
ALTER TABLE [dbo].[USER_FollowupAccount] CHECK CONSTRAINT [FK_User_FollowupAccount_MST_FollowupType]
GO
ALTER TABLE [dbo].[USER_FollowupAccount] ADD  CONSTRAINT [DF_User_FollowupAccount_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_FollowupAccount] ADD  CONSTRAINT [DF_User_FollowupAccount_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[USER_FollowupAccount] ADD  CONSTRAINT [DF__USER_Foll__Activ__65B6F546]  DEFAULT ((1)) FOR [Active]
GO

Columns:¶

Active:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_Notification]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_Notification](
    [NotificationId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [NotificationTo] [int] NOT NULL,
    [Notification] [varchar](350) NULL,
    [NotificationType] [varchar](50) NOT NULL,
    [Active] [bit] NOT NULL,
    [Source] [varchar](50) NULL,
    [SourceId] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_Notification] PRIMARY KEY CLUSTERED 
(
    [NotificationId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_Notification] ADD  CONSTRAINT [DF_User_Notification_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[USER_Notification] ADD  CONSTRAINT [DF_User_Notification_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_Notification] ADD  CONSTRAINT [DF_User_Notification_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

Active:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_Query]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_Query](
    [QueryId] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [QueryTypeId] [int] NOT NULL,
    [QueryDiagnosisId] [int] NOT NULL,
    [QueryName] [varchar](150) NOT NULL,
    [CreatedDate] [datetime] NOT NULL,
    [CreatedBy] [int] NOT NULL,
    [QueryTo] [varchar](30) NOT NULL,
    [Priority] [varchar](25) NOT NULL,
    [QAFinalResultId] [int] NOT NULL,
    [QueryStatusId] [int] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [SourceType] [varchar](50) NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_User_Query] PRIMARY KEY CLUSTERED 
(
    [QueryId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_Query]  WITH CHECK ADD  CONSTRAINT [FK_User_Query_MST_Physician] FOREIGN KEY([QueryTo])
REFERENCES [dbo].[MST_Physician] ([PhysicianID])
GO
ALTER TABLE [dbo].[USER_Query] CHECK CONSTRAINT [FK_User_Query_MST_Physician]
GO
ALTER TABLE [dbo].[USER_Query]  WITH CHECK ADD  CONSTRAINT [FK_User_Query_MST_QueryDiagnosis] FOREIGN KEY([QueryDiagnosisId])
REFERENCES [dbo].[MST_QueryDiagnosis] ([QueryDiagnosisId])
GO
ALTER TABLE [dbo].[USER_Query] CHECK CONSTRAINT [FK_User_Query_MST_QueryDiagnosis]
GO
ALTER TABLE [dbo].[USER_Query]  WITH CHECK ADD  CONSTRAINT [FK_User_Query_MST_QueryType] FOREIGN KEY([QueryTypeId])
REFERENCES [dbo].[MST_QueryType] ([QueryTypeId])
GO
ALTER TABLE [dbo].[USER_Query] CHECK CONSTRAINT [FK_User_Query_MST_QueryType]
GO
ALTER TABLE [dbo].[USER_Query]  WITH CHECK ADD  CONSTRAINT [CHECK_User_Query_ApplicationUserId] CHECK  (([dbo].[CheckApplicationUserId]([CreatedBy])=(1)))
GO
ALTER TABLE [dbo].[USER_Query] CHECK CONSTRAINT [CHECK_User_Query_ApplicationUserId]
GO
ALTER TABLE [dbo].[USER_Query] ADD  CONSTRAINT [DF_User_Query_CreatedDate]  DEFAULT (getutcdate()) FOR [CreatedDate]
GO
ALTER TABLE [dbo].[USER_Query] ADD  CONSTRAINT [DF_User_Query_QueryStatusId]  DEFAULT ((1)) FOR [QueryStatusId]
GO
ALTER TABLE [dbo].[USER_Query] ADD  CONSTRAINT [DF_User_Query_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[USER_Query] ADD  CONSTRAINT [DF_User_Query_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_Query] ADD  CONSTRAINT [DF_User_Query_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Column:¶

QueryStatusId:

1 means No Response and 2 means Response from Physician.

Active:

1 means Active Query and 2 means InActive Query.

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

Table Name:USER_QueryCustomeResult¶

Description:¶

User table which describes information about custome query creation using user's own templates.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_QueryCustomeResult]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_QueryCustomeResult](
    [UQCRID] [int] IDENTITY(1,1) NOT NULL,
    [AccountNumber] [varchar](30) NOT NULL,
    [QueryID] [int] NOT NULL,
    [Result] [varchar](max) NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_USER_QueryCustomeResult] PRIMARY KEY CLUSTERED 
(
    [UQCRID] 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].[USER_QueryCustomeResult] ADD  CONSTRAINT [DF_USER_QueryCustomeResult_InsertDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_QueryCustomeResult] ADD  CONSTRAINT [DF_USER_QueryCustomeResult_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

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

Table Name:USER_QueryDeletion¶

Description:¶

User table which describes information about deleted user queries.

Table Schema:¶

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_QueryDeletion]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_QueryDeletion](
    [QueryDeletionId] [int] IDENTITY(1,1) NOT NULL,
    [QueryId] [int] NOT NULL,
    [QuerySource] [varchar](50) NOT NULL,
    [ReasonForDelete] [varchar](250) NULL,
    [DeletedBy] [int] NOT NULL,
    [RStatus] [tinyint] NOT NULL,
    [Active] [tinyint] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_USER_QueryDeletion] PRIMARY KEY CLUSTERED 
(
    [QueryDeletionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_QueryDeletion] ADD  CONSTRAINT [DF_USER_QueryDeletion_Active]  DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[USER_QueryDeletion] ADD  CONSTRAINT [DF_USER_QueryDeletion_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_QueryDeletion] ADD  CONSTRAINT [DF_USER_QueryDeletion_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO

Columns:¶

RStatus:

1 means user query deletion and 2 means KPAI queries deletion and 3 means sub part of user query deletion.

Active:

USE [HRCM]
GO
/****** Object:  Table [dbo].[USER_WorkQueue_Count]    Script Date: 08/22/2019 15:51:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USER_WorkQueue_Count](
    [WorkQueueId] [int] IDENTITY(1,1) NOT NULL,
    [PageId] [int] NOT NULL,
    [PageName] [varchar](50) NULL,
    [QueueCount] [int] NOT NULL,
    [InsertedDate] [datetime] NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_MST_WorkQueue_Count] PRIMARY KEY CLUSTERED 
(
    [WorkQueueId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 80) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[USER_WorkQueue_Count] ADD  CONSTRAINT [DF_MST_WorkQueue_Count_InsertedDate]  DEFAULT (getutcdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[USER_WorkQueue_Count] ADD  CONSTRAINT [DF_MST_WorkQueue_Count_ModifiedDate]  DEFAULT (getutcdate()) FOR [ModifiedDate]
GO