USE [Patient_DATA]
GO
/****** Object:  Table [dbo].[tbpatient_Revoke]    Script Date: 10/31/2012 15:07:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tbpatient_Revoke](
	[HospNum] [varchar](8) NOT NULL,
	[IdNum] [varchar](10) NOT NULL,
	[AccountNum] [varchar](15) NULL,
	[HospPlan] [varchar](1) NULL,
	[MedicareType] [varchar](3) NULL,
	[AdmType] [varchar](1) NULL,
	[AdmDate] [datetime] NULL,
	[DcrDate] [datetime] NULL,
	[ServiceID] [varchar](3) NULL,
	[ResultID] [varchar](1) NULL,
	[DispositionID] [varchar](1) NULL,
	[AttendingDr1] [varchar](4) NULL,
	[AttendingDr2] [varchar](4) NULL,
	[AdmittingDr] [varchar](4) NULL,
	[ReferringDr] [varchar](4) NULL,
	[AdmittingClerk] [varchar](8) NULL,
	[ReferredFrom] [varchar](2) NULL,
	[DischargeClerk] [varchar](8) NULL,
	[Age] [varchar](3) NULL,
	[BillingDate] [datetime] NULL,
	[RoomID] [varchar](8) NULL,
	[BillingClerk] [varchar](8) NULL,
	[RoomRate] [float] NULL,
	[RecordStatus] [varchar](1) NULL,
	[OPDIdNum] [varchar](10) NULL,
	[MedicoLegal] [varchar](1) NULL,
	[Claim1] [float] NULL,
	[ArDate] [datetime] NULL,
	[WithWatcher] [bit] NOT NULL,
	[AdditionalBed] [varchar](1) NOT NULL,
	[WatcherRate] [float] NULL,
	[PharmaSeniorDiscounted] [bit] NOT NULL,
	[LastUpdatedAR] [datetime] NULL,
	[ZeroDet] [datetime] NULL,
	[AttendingDr5] [varchar](4) NULL,
	[AttendingDr6] [varchar](4) NULL,
	[AttendingDr7] [varchar](4) NULL,
	[AttendingDr8] [varchar](4) NULL,
	[AttendingDr9] [varchar](4) NULL,
	[AttendingDr10] [varchar](4) NULL,
	[TransferredDate] [datetime] NULL,
	[Room-In] [bit] NOT NULL,
	[UserID] [varchar](10) NULL,
	[HostName] [varchar](30) NOT NULL,
	[iswellbaby] [bit] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE CLUSTERED INDEX [tbpatientRevoke_1] ON [dbo].[tbpatient_Revoke] 
(
	[DcrDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_2] ON [dbo].[tbpatient_Revoke] 
(
	[HospNum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_3] ON [dbo].[tbpatient_Revoke] 
(
	[RoomID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_4] ON [dbo].[tbpatient_Revoke] 
(
	[HospNum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_5] ON [dbo].[tbpatient_Revoke] 
(
	[IdNum] ASC,
	[HospNum] ASC,
	[DcrDate] ASC,
	[BillingDate] ASC,
	[OPDIdNum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_6] ON [dbo].[tbpatient_Revoke] 
(
	[IdNum] ASC,
	[HospNum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [tbpatientRevoke_7] ON [dbo].[tbpatient_Revoke] 
(
	[BillingDate] ASC,
	[IdNum] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

 USE [Patient_DATA]
GO
/****** Object:  Table [dbo].[tbpatient2_Revoke]    Script Date: 10/31/2012 15:12:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO





CREATE TABLE [dbo].[tbpatient2_Revoke](
	[IDNum] [varchar](10) NOT NULL,
	[VIP] [bit] NOT NULL,
	[Confidential] [bit] NOT NULL,
	[HowAdmitted] [varchar](1) NULL,
	[PatientClass] [varchar](1) NULL,
	[AccomodationID] [varchar](1) NULL,
	[AskCashBasis] [bit] NOT NULL,
	[OkeyLab] [bit] NOT NULL,
	[OkeyRTS] [bit] NOT NULL,
	[OkeyXray] [bit] NOT NULL,
	[OkeyUltra] [bit] NOT NULL,
	[OkeyCT] [bit] NOT NULL,
	[OkeyPT] [bit] NOT NULL,
	[OkeyNU] [bit] NOT NULL,
	[Remarks] [varchar](2000) NULL,
	[CreditLine] [float] NULL,
	[ApprovedByID] [varchar](8) NULL,
	[OkeyAU] [bit] NOT NULL,
	[OkeyHS] [bit] NOT NULL,
	[DietID] [varchar](4) NULL,
	[DietRemarks] [varchar](1000) NULL,
	[WithDrOrder] [bit] NOT NULL,
	[OkeyPH] [bit] NOT NULL,
	[OkeyCS] [bit] NOT NULL,
	[OkeyEndo] [bit] NOT NULL,
	[WithOpenCR] [varchar](1) NULL,
	[OkeyNursery] [bit] NOT NULL,
	[WithPromisoryNote] [bit] NOT NULL,
	[AdmRemarks] [varchar](1000) NULL,
	[AdmissionTypeID] [varchar](5) NULL,
	[PackageID] [varchar](5) NULL,
	[DialysisID] [varchar](12) NULL,
	[SpecimenID] [varchar](12) NULL,
	[TransplantID] [varchar](2) NULL,
	[OkeyICU] [bit] NOT NULL,
	[OkeyDiet] [bit] NOT NULL,
	[OkeyER] [bit] NOT NULL,
	[OkeyDR] [bit] NOT NULL,
	[OkeyDI] [bit] NOT NULL,
	[CashUserID] [varchar](10) NULL,
	[PatientsMed] [bit] NULL,
	[OkeyNICU] [bit] NOT NULL,
	[OptionalMedicareComputation] [bit] NOT NULL,
	[FirstNotice] [bit] NOT NULL,
	[SecondNotice] [bit] NOT NULL,
	[FinalNotice] [bit] NOT NULL,
	[Check] [money] NULL,
	[Card] [money] NULL,
	[LOA] [money] NULL,
	[OkeyOL] [bit] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO