HRCM Table Design Schema
DataBase Name:HRCM
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:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36 | USE [HRCM]
GO
/****** Object: Table [dbo].[CDA_Allergy] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Allergy] ADD CONSTRAINT [DF_CDA_Allergy_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:CDA_Habit
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39 | USE [HRCM]
GO
/****** Object: Table [dbo].[CDA_Habit] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Habit] ADD CONSTRAINT [DF_CDA_Habit_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:CDA_HomeMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43 | USE [HRCM]
GO
/****** Object: Table [dbo].[CDA_HomeMedication] Script Date: 06/21/2018 10:52:43 ******/
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](50) NULL,
[Route] [varchar](50) NULL,
[Frequency] [varchar](50) 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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_HomeMedication] ADD CONSTRAINT [DF_CDA_HomeMedication_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:CDA_IPMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39 | USE [HRCM]
GO
/****** Object: Table [dbo].[CDA_IPMedication] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_IPMedication] ADD CONSTRAINT [DF_CDA_IPMedication_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:CDA_Lab
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41 | USE [HRCM]
GO
/****** Object: Table [dbo].[CDA_Lab] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[CDA_Lab] ADD CONSTRAINT [DF_CDA_Lab_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:DBError
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 | USE [HRCM]
GO
/****** Object: Table [dbo].[DBError] Script Date: 06/21/2018 10:52:43 ******/
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) 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 (getdate()) FOR [ErrorDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_DRG
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_DRG] Script Date: 06/21/2018 10:52:43 ******/
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] 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,
[UserName] [varchar](30) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_DRG] ADD CONSTRAINT [DF_FTP_DRG_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_DRG] ADD CONSTRAINT [DF_FTP_DRG_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_DXCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_DXCode] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_DXCode] ADD CONSTRAINT [DF_FTP_DXCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_DXCode] ADD CONSTRAINT [DF_FTP_DXCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_IPMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_IPMedication] Script Date: 06/21/2018 10:52:43 ******/
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](50) NULL,
[Route] [varchar](50) NULL,
[Frequency] [varchar](50) NULL,
[StartDate] [datetime] NOT 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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[ReportDate] [datetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD CONSTRAINT [DF_FTP_IPMedication_StartDate] DEFAULT (getdate()) FOR [StartDate]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD CONSTRAINT [DF_FTP_IPMedication_EndDate] DEFAULT (getdate()) FOR [EndDate]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD CONSTRAINT [DF_FTP_IPMedication_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_IPMedication] ADD CONSTRAINT [DF_FTP_IPMedication_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_Lab
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_Lab] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[ReportDate] [datetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_Lab] ADD CONSTRAINT [DF_FTP_Lab_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_Lab] ADD CONSTRAINT [DF_FTP_Lab_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_NurseNote
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_NurseNote] Script Date: 06/21/2018 10:52:43 ******/
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,
[EventType] [varchar](150) NULL,
[EventDesc] [varchar](250) NULL,
[EventResult] [varchar](500) NULL,
[NurseNoteDate] [datetime] NOT NULL,
[HospitalDay] [int] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[ReportDate] [datetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_NurseNote] ADD CONSTRAINT [DF_FTP_NurseNote_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_NurseNote] ADD CONSTRAINT [DF_FTP_NurseNote_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_PCSCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_PCSCode] Script Date: 06/21/2018 10:52:43 ******/
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] NOT NULL,
[PhysicianID] [varchar](30) NULL,
[PCSDate] [datetime] NULL,
[UserName] [varchar](30) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_PCSCode] ADD CONSTRAINT [DF_FTP_PCSCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_PCSCode] ADD CONSTRAINT [DF_FTP_PCSCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:FTP_VitalSign
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 | USE [HRCM]
GO
/****** Object: Table [dbo].[FTP_VitalSign] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[ReportDate] [datetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[FTP_VitalSign] ADD CONSTRAINT [DF_FTP_VitalSign_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[FTP_VitalSign] ADD CONSTRAINT [DF_FTP_VitalSign_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Document
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Document] Script Date: 06/21/2018 10:52:43 ******/
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,
[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] [smalldatetime] NULL,
[LastRunDate] [smalldatetime] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[HospitalDay] [int] NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [NCIX_Formatted] ON [dbo].[HIM_Document]
(
[Formatted] 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
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_DocumentInfo_InitialRunDate] DEFAULT (getdate()) FOR [InitialRunDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD CONSTRAINT [DF_HIM_DocumentInfo_LastRunDate] DEFAULT (getdate()) FOR [LastRunDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD CONSTRAINT [DF_HIM_DocumentInfo_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD CONSTRAINT [DF_HIM_DocumentInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[HIM_Document] ADD CONSTRAINT [DF__HIM_Docum__Forma__10AB74EC] DEFAULT ((0)) FOR [Formatted]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_DocumentData
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_DocumentData] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_DocumentData](
[DocumentDataID] [int] IDENTITY(1,1) NOT NULL,
[DocumentID] [int] NOT NULL,
[Document] [varchar](max) NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_DocumentData] PRIMARY KEY CLUSTERED
(
[DocumentDataID] 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].[HIM_DocumentData] WITH CHECK ADD CONSTRAINT [FK_HIM_DocumentData_HIM_Document] FOREIGN KEY([DocumentID])
REFERENCES [dbo].[HIM_Document] ([DocumentID])
GO
ALTER TABLE [dbo].[HIM_DocumentData] CHECK CONSTRAINT [FK_HIM_DocumentData_HIM_Document]
GO
ALTER TABLE [dbo].[HIM_DocumentData] ADD CONSTRAINT [DF_HIM_Document_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_DocumentData] ADD CONSTRAINT [DF_HIM_Document_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_DRG
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_DRG] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_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,
[UserName] [varchar](30) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_DRG] ADD CONSTRAINT [DF_HIM_DRG_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_DRG] ADD CONSTRAINT [DF_HIM_DRG_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_DXCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_DXCode] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_DXCode] ADD CONSTRAINT [DF_HIM_DXCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_DXCode] ADD CONSTRAINT [DF_HIM_DXCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_HomeMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_HomeMedication] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_HomeMedication](
[HomeMedicationID] [int] IDENTITY(1,1) NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[MedicationName] [varchar](150) NULL,
[MedicationType] [varchar](150) NULL,
[Dose] [varchar](50) NULL,
[Route] [varchar](50) NULL,
[Frequency] [varchar](50) NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[PRN] [varchar](10) NULL,
[Administration] [varchar](10) NULL,
[GenericName] [varchar](150) NULL,
[BrandName] [varchar](150) NULL,
[DrugID] [varchar](50) NULL,
[HospitalDay] [int] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_HomeMedication] ADD CONSTRAINT [DF_HIM_HomeMedication_StartDate] DEFAULT (getdate()) FOR [StartDate]
GO
ALTER TABLE [dbo].[HIM_HomeMedication] ADD CONSTRAINT [DF_HIM_HomeMedication_EndDate] DEFAULT (getdate()) FOR [EndDate]
GO
ALTER TABLE [dbo].[HIM_HomeMedication] ADD CONSTRAINT [DF_HIM_HomeMedication_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_HomeMedication] ADD CONSTRAINT [DF_HIM_HomeMedication_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Insurance
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Insurance] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Insurance](
[InsuranceID] [int] NOT NULL,
[PatientID] [int] NOT NULL,
[VisitID] [int] NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[SetID] [int] NOT NULL,
[InsurancePlanID] [varchar](30) NULL,
[InsuranceCompanyID] [varchar](30) NULL,
[InsuranceCompanyName] [varchar](250) NULL,
[PlanEffectiveDate] [datetime] NULL,
[PlanEndDate] [datetime] NULL,
[FinalStatus] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_Insurance] PRIMARY KEY CLUSTERED
(
[InsuranceID] 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].[HIM_Insurance] WITH CHECK ADD CONSTRAINT [FK_HIM_Insurance_HIM_Patient] FOREIGN KEY([PatientID])
REFERENCES [dbo].[HIM_Patient] ([PatientId])
GO
ALTER TABLE [dbo].[HIM_Insurance] CHECK CONSTRAINT [FK_HIM_Insurance_HIM_Patient]
GO
ALTER TABLE [dbo].[HIM_Insurance] WITH CHECK ADD CONSTRAINT [FK_HIM_Insurance_HIM_Visit] FOREIGN KEY([VisitID])
REFERENCES [dbo].[HIM_Visit] ([VisitID])
GO
ALTER TABLE [dbo].[HIM_Insurance] CHECK CONSTRAINT [FK_HIM_Insurance_HIM_Visit]
GO
ALTER TABLE [dbo].[HIM_Insurance] ADD CONSTRAINT [DF_HIM_Insurance_FinalStatus] DEFAULT ((0)) FOR [FinalStatus]
GO
ALTER TABLE [dbo].[HIM_Insurance] ADD CONSTRAINT [DF_HIM_Insurance_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Insurance] ADD CONSTRAINT [DF_HIM_Insurance_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_IPMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_IPMedication] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_IPMedication](
[IPMedicationID] [int] IDENTITY(1,1) NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[MedicationName] [varchar](150) NULL,
[MedicationType] [varchar](150) NULL,
[Dose] [varchar](50) NULL,
[Route] [varchar](50) NULL,
[Frequency] [varchar](50) NULL,
[StartDate] [datetime] NOT 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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_IPMedication] ADD CONSTRAINT [DF_HIM_IPMedication_StartDate] DEFAULT (getdate()) FOR [StartDate]
GO
ALTER TABLE [dbo].[HIM_IPMedication] ADD CONSTRAINT [DF_HIM_IPMedication_EndDate] DEFAULT (getdate()) FOR [EndDate]
GO
ALTER TABLE [dbo].[HIM_IPMedication] ADD CONSTRAINT [DF_HIM_IPMedication_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_IPMedication] ADD CONSTRAINT [DF_HIM_IPMedication_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Lab
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Lab] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_Lab] ADD CONSTRAINT [DF_HIM_Lab_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Lab] ADD CONSTRAINT [DF_HIM_Lab_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_NurseNote
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_NurseNote] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_NurseNote](
[NurseNoteID] [int] IDENTITY(1,1) NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[EventType] [varchar](150) NULL,
[EventDesc] [varchar](250) NULL,
[EventResult] [varchar](500) NULL,
[NurseNoteDate] [datetime] NOT NULL,
[HospitalDay] [int] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_NurseNote] ADD CONSTRAINT [DF_HIM_NurseNote_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_NurseNote] ADD CONSTRAINT [DF_HIM_NurseNote_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Patient
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Patient] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Patient](
[PatientId] [int] NOT NULL,
[MRN] [varchar](30) NOT NULL,
[FirstName] [varchar](80) NOT NULL,
[MiddleName] [varchar](80) NULL,
[LastName] [varchar](80) NOT NULL,
[PatientAddress] [varchar](500) NULL,
[RaceID] [varchar](30) NULL,
[Race] [varchar](100) NULL,
[DOB] [datetime] NULL,
[Gender] [varchar](10) NOT NULL,
[PrimaryLanguage] [varchar](100) NULL,
[MaritalStatus] [varchar](10) NULL,
[Religion] [varchar](10) NULL,
[SSNNumber] [varchar](30) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_Patient] PRIMARY KEY CLUSTERED
(
[PatientId] 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].[HIM_Patient] ADD CONSTRAINT [DF_HIM_Patient_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Patient] ADD CONSTRAINT [DF_HIM_Patient_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_PCSCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_PCSCode] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_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] NOT NULL,
[PhysicianID] [varchar](30) NULL,
[PCSDate] [datetime] NULL,
[UserName] [varchar](30) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_PCSCode] ADD CONSTRAINT [DF_HIM_PCSCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_PCSCode] ADD CONSTRAINT [DF_HIM_PCSCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Physician
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Physician] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Physician](
[PhysicianID] [varchar](30) NOT NULL,
[FirstName] [varchar](80) NULL,
[LastName] [varchar](80) NULL,
[MiddleName] [varchar](80) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_Physician] PRIMARY KEY CLUSTERED
(
[PhysicianID] 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].[HIM_Physician] ADD CONSTRAINT [DF_HIM_PhysicianRoster_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Physician] ADD CONSTRAINT [DF_HIM_PhysicianRoster_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Physician_Visit
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Physician_Visit] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Physician_Visit](
[PhysicianVisitID] [int] IDENTITY(1,1) NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[PhysicianID] [varchar](30) NOT NULL,
[PhysicianTypeID] [tinyint] NOT NULL,
[PhysicianTypeDesc] [varchar](80) NULL,
[Active] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_Physician_Visit] PRIMARY KEY CLUSTERED
(
[PhysicianVisitID] 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].[HIM_Physician_Visit] WITH CHECK ADD CONSTRAINT [FK_HIM_Physician_Visit_HIM_Physician] FOREIGN KEY([PhysicianID])
REFERENCES [dbo].[HIM_Physician] ([PhysicianID])
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] CHECK CONSTRAINT [FK_HIM_Physician_Visit_HIM_Physician]
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] WITH NOCHECK ADD CONSTRAINT [CHECK_AccountNumber_HIM_Physician_Visit] CHECK NOT FOR REPLICATION (([dbo].[Check_AccountNumberReference]([AccountNumber])=(1)))
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] NOCHECK CONSTRAINT [CHECK_AccountNumber_HIM_Physician_Visit]
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] WITH CHECK ADD CONSTRAINT [CHECK_PhysicianID_HIM_Physician_Visit] CHECK (([dbo].[Check_PhysicianIDReference]([PhysicianID])=(1)))
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] CHECK CONSTRAINT [CHECK_PhysicianID_HIM_Physician_Visit]
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] ADD CONSTRAINT [DF_HIM_Physician_Visit_Active] DEFAULT ((1)) FOR [Active]
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] ADD CONSTRAINT [DF_HIM_Physician_Visit_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Physician_Visit] ADD CONSTRAINT [DF_HIM_Physician_Visit_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_Visit
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_Visit] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HIM_Visit](
[VisitID] [int] NOT NULL,
[PatientID] [int] NOT NULL,
[AccountNumber] [varchar](30) NOT NULL,
[MRN] [varchar](30) NOT NULL,
[PatientClass] [varchar](10) NULL,
[AdmitDate] [datetime] NULL,
[DischargeDate] [datetime] NULL,
[LocationID] [varchar](30) NULL,
[LocationRoom] [varchar](30) NULL,
[LocationBed] [varchar](30) NULL,
[AdmissionType] [varchar](10) NULL,
[HospitalService] [varchar](50) NULL,
[AdmitSource] [varchar](30) NULL,
[PatientType] [varchar](10) NULL,
[VIPIndicator] [varchar](10) NULL,
[FinancialClass] [varchar](10) NULL,
[CancelVisit] [bit] NOT NULL,
[DischargeDisposition] [varchar](10) NULL,
[ReasonForVisit] [varchar](250) NULL,
[AdmissionDay] [datetime] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_HIM_Visit] PRIMARY KEY CLUSTERED
(
[VisitID] 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].[HIM_Visit] WITH CHECK ADD CONSTRAINT [FK_HIM_Visit_HIM_Patient] FOREIGN KEY([PatientID])
REFERENCES [dbo].[HIM_Patient] ([PatientId])
GO
ALTER TABLE [dbo].[HIM_Visit] CHECK CONSTRAINT [FK_HIM_Visit_HIM_Patient]
GO
ALTER TABLE [dbo].[HIM_Visit] ADD CONSTRAINT [DF_HIM_Visit_CancelVisit] DEFAULT ((0)) FOR [CancelVisit]
GO
ALTER TABLE [dbo].[HIM_Visit] ADD CONSTRAINT [DF_HIM_Visit_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_Visit] ADD CONSTRAINT [DF_HIM_Visit_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:HIM_VitalSign
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[HIM_VitalSign] Script Date: 06/21/2018 10:52:43 ******/
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] NOT NULL,
[LOINCCode] [varchar](50) NULL,
[HospitalDay] [int] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[HIM_VitalSign] ADD CONSTRAINT [DF_HIM_VitalSign_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[HIM_VitalSign] ADD CONSTRAINT [DF_HIM_VitalSign_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_APRDRGInfo
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_APRDRGInfo] Script Date: 06/21/2018 10:52:43 ******/
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) NOT NULL,
[APRDRGGLOS] [float] NOT NULL,
[APRDRGALOS] [float] NOT NULL,
[SOI] [int] NOT NULL,
[ROM] [int] NOT NULL,
[APRDRGType] [varchar](30) NULL,
[APRDRGVersion] [int] NOT NULL,
[EffectiveFrom] [datetime] NOT NULL,
[EffectiveTo] [datetime] NOT NULL,
[CurrentVersion] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_APRDRGInfo] ADD CONSTRAINT [DF_MST_APRDRGInfo_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_APRDRGInfo] ADD CONSTRAINT [DF_MST_APRDRGInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_DocumentCompletionStatus
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_DocumentCompletionStatus] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentCompletionStatus] ADD CONSTRAINT [DF_MST_DocumentCompletionStatus_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_DocumentRunningStatus
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_DocumentRunningStatus] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DocumentRunningStatus] ADD CONSTRAINT [DF_MST_DocumentRunningStatus_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentRunningStatus] ADD CONSTRAINT [DF_MST_DocumentRunningStatus_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_DocumentSource
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_DocumentSource] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DocumentSource](
[DocumentSourceID] [tinyint] IDENTITY(1,1) NOT NULL,
[DocumentSource] [varchar](20) NULL,
[DocumentSourceDesc] [varchar](250) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_DocumentSource] PRIMARY KEY CLUSTERED
(
[DocumentSourceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DocumentSource] ADD CONSTRAINT [DF_MST_DocumentSource_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentSource] ADD CONSTRAINT [DF_MST_DocumentSource_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_DocumentType
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_DocumentType] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DocumentType](
[DocumentTypeID] [int] IDENTITY(1,1) NOT NULL,
[InternalDocumentTypeID] [int] NOT NULL,
[DocumentName] [varchar](200) NULL,
[DocumentAliasName] [varchar](200) NULL,
[DocumentMnemonic] [varchar](200) NULL,
[DocumentSourceID] [tinyint] NOT NULL,
[Activation] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_DocumentType] PRIMARY KEY CLUSTERED
(
[DocumentTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DocumentType] WITH CHECK ADD CONSTRAINT [FK_MST_DocumentType_MST_DocumentSource] FOREIGN KEY([DocumentSourceID])
REFERENCES [dbo].[MST_DocumentSource] ([DocumentSourceID])
GO
ALTER TABLE [dbo].[MST_DocumentType] CHECK CONSTRAINT [FK_MST_DocumentType_MST_DocumentSource]
GO
ALTER TABLE [dbo].[MST_DocumentType] WITH CHECK ADD CONSTRAINT [FK_MST_DocumentType_MST_InternalDocumentType] FOREIGN KEY([InternalDocumentTypeID])
REFERENCES [dbo].[MST_InternalDocumentType] ([InternalDocumentTypeID])
GO
ALTER TABLE [dbo].[MST_DocumentType] CHECK CONSTRAINT [FK_MST_DocumentType_MST_InternalDocumentType]
GO
ALTER TABLE [dbo].[MST_DocumentType] ADD CONSTRAINT [DF_MST_DocumentType_Activation] DEFAULT ((1)) FOR [Activation]
GO
ALTER TABLE [dbo].[MST_DocumentType] ADD CONSTRAINT [DF_MST_DocumentType_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DocumentType] ADD CONSTRAINT [DF_MST_DocumentType_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_DXCodeInfo
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_DXCodeInfo] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_DXCodeInfo](
[DXCodeInfoID] [int] IDENTITY(1,1) NOT NULL,
[DXCode] [varchar](10) NOT NULL,
[DXCodeWODecimal] [varchar](10) NULL,
[DXShortDesc] [varchar](250) NULL,
[DXLongDesc] [varchar](250) NULL,
[Active] [bit] NOT NULL,
[ChronicStatus] [bit] NOT NULL,
[EffectiveFrom] [datetime] NOT NULL,
[EffectiveTo] [datetime] NOT NULL,
[CurrentVersion] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_DXCodeInfo] PRIMARY KEY CLUSTERED
(
[DXCodeInfoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_DXCodeInfo] ADD CONSTRAINT [DF_MST_DXCodeInfo_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_DXCodeInfo] ADD CONSTRAINT [DF_MST_DXCodeInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_FinancialClass
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_FinancialClass] Script Date: 06/21/2018 10:52:43 ******/
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,
[PrimaryDRGGrouperID] [int] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_FinancialClass] ADD CONSTRAINT [DF_MST_FinancialClass_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_HospitalService
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_HospitalService] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_HospitalService](
[HospitalServiceCode] [varchar](30) NOT NULL,
[ServiceName] [varchar](120) NULL,
[ServiceAliasName] [varchar](120) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_HospitalService] PRIMARY KEY CLUSTERED
(
[HospitalServiceCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_HospitalService] ADD CONSTRAINT [DF_MST_HospitalService_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_HospitalService] ADD CONSTRAINT [DF_MST_HospitalService_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_Insurance_PrimaryDRGGrouper
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_Insurance_PrimaryDRGGrouper] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_Insurance_PrimaryDRGGrouper](
[InsuranceDRGGrouperID] [int] IDENTITY(1,1) NOT NULL,
[InsurancePlanID] [varchar](30) NULL,
[CarrierName] [varchar](250) NULL,
[PrimaryDRGGrouperID] [int] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_Insurance_DRGGrouper] PRIMARY KEY CLUSTERED
(
[InsuranceDRGGrouperID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_Insurance_PrimaryDRGGrouper] WITH CHECK ADD CONSTRAINT [FK_MST_Insurance_PrimaryDRGGrouper_MST_PrimaryDRGGrouper] FOREIGN KEY([PrimaryDRGGrouperID])
REFERENCES [dbo].[MST_PrimaryDRGGrouper] ([PrimaryDRGGrouperID])
GO
ALTER TABLE [dbo].[MST_Insurance_PrimaryDRGGrouper] CHECK CONSTRAINT [FK_MST_Insurance_PrimaryDRGGrouper_MST_PrimaryDRGGrouper]
GO
ALTER TABLE [dbo].[MST_Insurance_PrimaryDRGGrouper] ADD CONSTRAINT [DF_MST_Insurance_DRGGrouper_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_Insurance_PrimaryDRGGrouper] ADD CONSTRAINT [DF_MST_Insurance_DRGGrouper_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:
Description:
Table Schema:
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_InternalDocumentType
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_InternalDocumentType] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_InternalDocumentType](
[InternalDocumentTypeID] [int] NOT NULL,
[InternalDocumentName] [varchar](200) NOT NULL,
[InternalDocumentAliasName] [varchar](200) NULL,
[InternalDocumentMnemonic] [varchar](200) NULL,
[Priority] [int] NOT NULL,
[Activation] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_InternalDocumentType] PRIMARY KEY CLUSTERED
(
[InternalDocumentTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_InternalDocumentType] ADD CONSTRAINT [DF_MST_InternalDocumentType_Activation] DEFAULT ((1)) FOR [Activation]
GO
ALTER TABLE [dbo].[MST_InternalDocumentType] ADD CONSTRAINT [DF_MST_InternalDocumentType_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_InternalDocumentType] ADD CONSTRAINT [DF_MST_InternalDocumentType_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_LabReference
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_LabReference] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_LabReference](
[LabReferenceID] [int] IDENTITY(1,1) NOT NULL,
[TestName] [varchar](150) NULL,
[LOINCCode] [varchar](50) NULL,
[AlphaReferenceRange] [varchar](50) NULL,
[LowThreshold] [float] NULL,
[HighThreshold] [float] NULL,
[Gender] [varchar](10) NULL,
[AgeFrom] [int] NOT NULL,
[AgeTo] [int] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_LabReference] PRIMARY KEY CLUSTERED
(
[LabReferenceID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_LabReference] ADD CONSTRAINT [DF_MST_LabReference_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_LabReference] ADD CONSTRAINT [DF_MST_LabReference_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_MSDRGInfo
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_MSDRGInfo] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_MSDRGInfo](
[MSDRGInfoID] [int] IDENTITY(1,1) 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,
[PostAcuteDRG] [varchar](10) NULL,
[SpecialPayDRG] [varchar](250) NULL,
[MSDRGType] [varchar](30) NULL,
[TransferDRG] [varchar](30) NULL,
[MSDRGVersion] [int] NOT NULL,
[EffectiveFrom] [datetime] NOT NULL,
[EffectiveTo] [datetime] NOT NULL,
[CurrentVersion] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_MSDRGInfo] PRIMARY KEY CLUSTERED
(
[MSDRGInfoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_MSDRGInfo] ADD CONSTRAINT [DF_MST_MSDRGInfo_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_MSDRGInfo] ADD CONSTRAINT [DF_MST_MSDRGInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_NursingStation
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_NursingStation] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_NursingStation](
[NursingStationID] [varchar](30) NOT NULL,
[StationName] [varchar](120) NULL,
[StationAliasName] [varchar](120) NULL,
[Service] [varchar](120) NULL,
[BedCount] [int] NOT NULL,
[BedRange] [varchar](80) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_NursingStation] PRIMARY KEY CLUSTERED
(
[NursingStationID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_NursingStation] ADD CONSTRAINT [DF_MST_NursingStation_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_NursingStation] ADD CONSTRAINT [DF_MST_NursingStation_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_PatternType
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_PatternType] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PatternType](
[PatternTypeID] [int] IDENTITY(1,1) NOT NULL,
[PatternType] [varchar](100) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_PatternType] PRIMARY KEY CLUSTERED
(
[PatternTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PatternType] ADD CONSTRAINT [DF_MST_PatternType_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_PatternType] ADD CONSTRAINT [DF_MST_PatternType_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_PCSCodeInfo
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_PCSCodeInfo] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PCSCodeInfo](
[PCSCodeInfoID] [int] IDENTITY(1,1) NOT NULL,
[PCSCode] [varchar](10) NOT NULL,
[PCSShortDesc] [varchar](250) NULL,
[PCSLongDesc] [varchar](250) NULL,
[Active] [bit] NOT NULL,
[EffectiveFrom] [datetime] NOT NULL,
[EffectiveTo] [datetime] NOT NULL,
[CurrentVersion] [bit] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_PCSCodeInfo] PRIMARY KEY CLUSTERED
(
[PCSCodeInfoID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PCSCodeInfo] ADD CONSTRAINT [DF_MST_PCSCodeInfo_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_PCSCodeInfo] ADD CONSTRAINT [DF_MST_PCSCodeInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_Physician
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_Physician] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_Physician](
[PhysicianID] [varchar](30) NOT NULL,
[FirstName] [varchar](80) NULL,
[LastName] [varchar](80) NULL,
[MiddleName] [varchar](80) NULL,
[Designation] [varchar](80) NULL,
[Phone] [varchar](80) NULL,
[Fax] [varchar](80) NULL,
[Address] [varchar](250) NULL,
[Speciality] [varchar](80) NULL,
[Speciality2] [varchar](80) NULL,
[Speciality3] [varchar](80) NULL,
[Department] [varchar](80) NULL,
[NPI] [varchar](80) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_Physician] PRIMARY KEY CLUSTERED
(
[PhysicianID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_Physician] ADD CONSTRAINT [DF_MST_PhysicianRoster_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_Physician] ADD CONSTRAINT [DF_MST_PhysicianRoster_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_PrimaryDRGGrouper
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_PrimaryDRGGrouper] Script Date: 06/21/2018 10:52:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MST_PrimaryDRGGrouper](
[PrimaryDRGGrouperID] [int] IDENTITY(1,1) NOT NULL,
[PrimaryDRGGrouperName] [varchar](80) NULL,
[PrimaryDRGGrouperAliasName] [varchar](80) NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
CONSTRAINT [PK_MST_DRGGrouper] PRIMARY KEY CLUSTERED
(
[PrimaryDRGGrouperID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_PrimaryDRGGrouper] ADD CONSTRAINT [DF_MST_DRGGrouper_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_PrimaryDRGGrouper] ADD CONSTRAINT [DF_MST_DRGGrouper_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_RoomInfo
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_RoomInfo] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_RoomInfo] ADD CONSTRAINT [DF_MST_RoomInfo_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_SectionHeader] Script Date: 06/21/2018 10:52:43 ******/
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,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_SectionHeader] ADD CONSTRAINT [DF_MST_SectionHeader_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_SectionHeader] ADD CONSTRAINT [DF_MST_SectionHeader_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:MST_VitalSignReference
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[MST_VitalSignReference] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[MST_VitalSignReference] ADD CONSTRAINT [DF_MST_VitalSignReference_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[MST_VitalSignReference] ADD CONSTRAINT [DF_MST_VitalSignReference_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_Allergy
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_Allergy] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_Allergy] ADD CONSTRAINT [DF_NLP_Allergy_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Allergy] ADD CONSTRAINT [DF_NLP_Allergy_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxAnnotation
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxAnnotation] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[Modifieddate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DxAnnotation] ADD CONSTRAINT [DF_NLP_DxAnnotation_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxAnnotation] ADD CONSTRAINT [DF_NLP_DxAnnotation_Modifieddate] DEFAULT (getdate()) FOR [Modifieddate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxCode] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT NULL,
[Source] [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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DxCode] ADD CONSTRAINT [DF_NLP_DxCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxCode] ADD CONSTRAINT [DF_NLP_DxCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
ALTER TABLE [dbo].[NLP_DxCode] ADD DEFAULT ((0)) FOR [DxExclusionTypeId]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxCodeByDocument
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxCodeByDocument] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxCodeByDocument] ADD CONSTRAINT [DF_NLP_DxCodeByDocument_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxCodeCombination
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxCodeCombination] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxCodeCombination] ADD CONSTRAINT [DF_NLP_DxCodeCombination_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxCodeEvidence
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxCodeEvidence] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DxCodeEvidence] ADD CONSTRAINT [DF_NLP_DxCodeEvidance_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxCodeEvidence] ADD CONSTRAINT [DF_NLP_DxCodeEvidance_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_DxFactor
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_DxFactor] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_DxFactor] ADD CONSTRAINT [DF_NLP_DxFactor_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_DxFactor] ADD CONSTRAINT [DF_NLP_DxFactor_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_Habit
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_Habit] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_Habit] ADD CONSTRAINT [DF_NLP_Habit_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Habit] ADD CONSTRAINT [DF_NLP_Habit_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_Lab
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_Lab] Script Date: 06/21/2018 10:52:43 ******/
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] NOT NULL,
[LOINCCode] [varchar](50) NULL,
[SectionHeader] [varchar](200) NULL,
[HospitalDay] [int] NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_Lab] ADD CONSTRAINT [DF_NLP_Lab_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_PCSCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_PCSCode] Script Date: 06/21/2018 10:52:43 ******/
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,
[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,
[RStatus] [tinyint] NOT NULL,
[InsertedDate] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD CONSTRAINT [DF_NLP_PCSCode_RStatus] DEFAULT ((0)) FOR [RStatus]
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD CONSTRAINT [DF_NLP_PCSCode_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCode] ADD CONSTRAINT [DF_NLP_PCSCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_PCSCodeByDocument
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_PCSCodeByDocument] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCodeByDocument] ADD CONSTRAINT [DF_NLP_PCSCodeByDocument_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_PCSCodeEvidance
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_PCSCodeEvidance] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_PCSCodeEvidance] ADD CONSTRAINT [DF_NLP_PCSCodeEvidance_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_PCSCodeEvidance] ADD CONSTRAINT [DF_NLP_PCSCodeEvidance_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_QueryDocKeyword
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_QueryDocKeyword] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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_QueryDocKeyword_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_QueryDocKeyword] ADD CONSTRAINT [DF_QueryDocKeyword_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_VitalSign
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_VitalSign] Script Date: 06/21/2018 10:52:43 ******/
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] [varchar](50) NULL,
[NumericResult2] [varchar](50) 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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] NOT 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[NLP_VitalSign] ADD CONSTRAINT [DF_Table_1_InsertedDay] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_VitalSign] ADD CONSTRAINT [DF_NLP_VitalSign_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_VSeriesCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_VSeriesCode] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_VSeriesCode] ADD CONSTRAINT [DF_NLP_VSeriesCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:NLP_WSeriesCode
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37 | USE [HRCM]
GO
/****** Object: Table [dbo].[NLP_WSeriesCode] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) 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 (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[NLP_WSeriesCode] ADD CONSTRAINT [DF_NLP_WSeriesCode_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:OTR_SyncProcess
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29 | USE [HRCM]
GO
/****** Object: Table [dbo].[OTR_SyncProcess] Script Date: 06/21/2018 10:52:43 ******/
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] [smalldatetime] NOT NULL,
[ModifiedDate] [smalldatetime] 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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[OTR_SyncProcess] ADD CONSTRAINT [DF_OTR_SyncProcess_InsertedDate] DEFAULT (getdate()) FOR [InsertedDate]
GO
ALTER TABLE [dbo].[OTR_SyncProcess] ADD CONSTRAINT [DF_OTR_SyncProcess_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]
GO
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:TMP_DRG
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49 | USE [HRCM]
GO
/****** Object: Table [dbo].[TMP_DRG] Script Date: 06/21/2018 10:52:43 ******/
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
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:TMP_IPMedication
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 | USE [HRCM]
GO
/****** Object: Table [dbo].[TMP_IPMedication] Script Date: 06/21/2018 10:52:43 ******/
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
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:TMP_Lab
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 | USE [HRCM]
GO
/****** Object: Table [dbo].[TMP_Lab] Script Date: 06/21/2018 10:52:43 ******/
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
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:TMP_NurseNote
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20 | USE [HRCM]
GO
/****** Object: Table [dbo].[TMP_NurseNote] Script Date: 06/21/2018 10:52:43 ******/
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
|
ChangeLog:
======================================================
DataBase Name:HRCM
Table Name:TMP_VitalSign
Description:
Table Schema:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18 | USE [HRCM]
GO
/****** Object: Table [dbo].[TMP_VitalSign] Script Date: 06/21/2018 10:52:43 ******/
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
|
ChangeLog:
======================================================