Download HIPAA Authorizer

Database Integration
106
The fields in error are now unchecked.
5.6
SQL Table scripts
Below are the scripts for Microsoft SQL Server. If you have a different database, you will have to slighty
alter the scripts.
Both tables have an 'ID' column that is self incrementing.
The field 'HeaderID' in the child table is the foreign key and points to the ID in the header table.
CREATE TABLE [edi_AuthorizerHeader](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[TradingPartnerID] [char](15) NULL,
[TradingPartnerIDQual] [char](2) NULL,
[FileDate] [date] NULL,
[FileTime] [char](10) NULL,
[FileName] [varchar](100) NULL,
[ProcessDate] [date] NULL,
[ProcessTime] [char](10) NULL,
[Status] [tinyint] NULL,
[Version] [char](12) NULL,
[TransactionID] [varchar](30) NULL,
[Purpose] [char](2) NULL,
[UMOName] [varchar](35) NULL,
[UMOIDQual] [char](2) NULL,
[UMOID] [varchar](30) NULL,
[UMOContact] [varchar](60) NULL,
[UMOPhone] [varchar](20) NULL,
[UMOExtension] [varchar](10) NULL,
[UMOFax] [varchar](20) NULL,
© <2013> Martin Scholl Consulting, Inc.