USE [CMSQL] GO /****** Object: User [Admin] Script Date: 03/23/2011 09:30:59 ******/ CREATE USER [Admin] FOR LOGIN [Admin] WITH DEFAULT_SCHEMA=[Admin] GO /****** Object: Schema [Admin] Script Date: 03/23/2011 09:30:59 ******/ CREATE SCHEMA [Admin] AUTHORIZATION [Admin] GO /****** Object: Table [dbo].[InsOverrides] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InsOverrides]( [ins] [nvarchar](15) NOT NULL, [tag] [nvarchar](35) NOT NULL, [value] [nvarchar](255) NULL, CONSTRAINT [PK_InsOverrides] PRIMARY KEY CLUSTERED ( [ins] ASC, [tag] 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 /****** Object: Table [dbo].[rate] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rate]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [rateflag] [nchar](1) NULL, [match1] [nvarchar](50) NOT NULL, [match2] [nvarchar](50) NULL, [match3] [nvarchar](50) NULL, [match4] [nvarchar](50) NULL, [match5] [nvarchar](50) NULL, [rate] [nvarchar](5) NULL, CONSTRAINT [PK_rate] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[taxctl] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[taxctl]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [ins] [nvarchar](50) NOT NULL, [prov] [nvarchar](50) NOT NULL, [facility] [nvarchar](50) NOT NULL, [tax_source] [nchar](2) NULL, CONSTRAINT [PK_taxctl] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[rplval] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rplval]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [repl_list] [nvarchar](30) NOT NULL, [match_val1] [nvarchar](50) NULL, [match_val2] [nvarchar](50) NULL, [match_val3] [nvarchar](50) NULL, [rplvalue1] [nvarchar](50) NULL, [rplvalue2] [nvarchar](50) NULL, [rplvalue3] [nvarchar](50) NULL, CONSTRAINT [PK_rplval] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[rplctl] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rplctl]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [function] [nvarchar](50) NOT NULL, [field1] [nvarchar](50) NULL, [field2] [nvarchar](50) NULL, [field3] [nvarchar](50) NULL, [repl_list] [nvarchar](30) NULL, [repl_no] [int] NULL, [error_if_not_found] [nchar](1) NULL, CONSTRAINT [PK_rplctl] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[rpl_lists] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[rpl_lists]( [code] [nvarchar](30) NOT NULL, [desc] [nvarchar](254) NULL, CONSTRAINT [PK_rpl_lists] PRIMARY KEY CLUSTERED ( [code] 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 /****** Object: Table [dbo].[no_npi] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[no_npi]( [schedule] [nvarchar](50) NOT NULL, [medicaid_id] [nvarchar](8) NOT NULL, [description] [nvarchar](254) NULL, CONSTRAINT [PK_no_npi] PRIMARY KEY CLUSTERED ( [schedule] ASC, [medicaid_id] 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 /****** Object: Table [dbo].[CmIns] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CmIns]( [Ins] [nvarchar](35) NULL, [Description] [nvarchar](100) NULL, [Type] [nvarchar](35) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[facility] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[facility]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [facility] [nvarchar](20) NULL, [locator] [nchar](3) NULL, [clinic_pos] [nchar](2) NULL, [desc] [nvarchar](254) NULL, CONSTRAINT [PK_facility] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: Table [dbo].[MaintCategory] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[MaintCategory]( [maintCategory] [nvarchar](35) NULL, [description] [nvarchar](100) NULL, [sortorder] [int] NULL, [help] [nvarchar](255) NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[ConfigTag] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ConfigTag]( [tag] [nvarchar](35) NOT NULL, [prompt] [nvarchar](100) NULL, [length] [int] NULL, [valkey] [nvarchar](35) NULL, [browseFlag] [bit] NULL, [mandatory] [bit] NULL, [configGroup] [nvarchar](35) NULL, [help] [nvarchar](255) NULL, [tagorder] [int] NULL, CONSTRAINT [PK_ConfigTag] PRIMARY KEY CLUSTERED ( [tag] 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 /****** Object: Table [dbo].[SystemOverrides] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SystemOverrides]( [tag] [nvarchar](35) NOT NULL, [value] [nvarchar](255) NULL, CONSTRAINT [PK_SystemOverrides] PRIMARY KEY CLUSTERED ( [tag] 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 /****** Object: Table [dbo].[Practice] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Practice]( [Practice] [nvarchar](35) NOT NULL, [Description] [nvarchar](100) NULL, [practiceFolder] [nvarchar](50) NULL, [lastIns] [nvarchar](35) NULL, [defaultPractice] [nchar](10) NULL, [npi] [nchar](11) NULL, [noCrossover] [nchar](1) NULL, [sqlCatalog] [nvarchar](100) NULL, CONSTRAINT [PK_Practice] PRIMARY KEY CLUSTERED ( [Practice] 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 /****** Object: Table [dbo].[ConfigValues] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ConfigValues]( [ins] [nchar](15) NOT NULL, [practice] [nchar](35) NOT NULL, [tag] [nchar](35) NOT NULL, [value] [nvarchar](255) NULL, CONSTRAINT [PK_PracticeValues] PRIMARY KEY CLUSTERED ( [ins] ASC, [practice] ASC, [tag] 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 /****** Object: Table [dbo].[ValidValues] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ValidValues]( [valkey] [nvarchar](35) NOT NULL, [value] [nvarchar](35) NOT NULL, [desc] [nvarchar](50) NULL, CONSTRAINT [PK_ValidValues] PRIMARY KEY CLUSTERED ( [valkey] ASC, [value] 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 /****** Object: Table [dbo].[ConfigGroup] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ConfigGroup]( [configGroup] [nvarchar](35) NOT NULL, [sortorder] [int] NULL, [description] [nvarchar](100) NULL, [help] [nvarchar](255) NULL, [oneinsurancetype] [nvarchar](35) NULL, [maintCategory] [nvarchar](35) NULL, CONSTRAINT [PK_Group] PRIMARY KEY CLUSTERED ( [configGroup] 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 /****** Object: StoredProcedure [dbo].[sp_generate_inserts2] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROC [dbo].[sp_generate_inserts2] ( @table_name varchar(776), -- The table/view for which the INSERT statements will be generated using the existing data @target_table varchar(776) = NULL, -- Use this parameter to specify a different table name into which the data will be inserted @include_column_list bit = 1, -- Use this parameter to include/ommit column list in the generated INSERT statement @from varchar(800) = NULL, -- Use this parameter to filter the rows based on a filter condition (using WHERE) @include_timestamp bit = 0, -- Specify 1 for this parameter, if you want to include the TIMESTAMP/ROWVERSION column's data in the INSERT statement @debug_mode bit = 0, -- If @debug_mode is set to 1, the SQL statements constructed by this procedure will be printed for later examination @owner varchar(64) = NULL, -- Use this parameter if you are not the owner of the table @ommit_images bit = 0, -- Use this parameter to generate INSERT statements by omitting the 'image' columns @ommit_identity bit = 0, -- Use this parameter to ommit the identity columns @top int = NULL, -- Use this parameter to generate INSERT statements only for the TOP n rows @cols_to_include varchar(8000) = NULL, -- List of columns to be included in the INSERT statement @cols_to_exclude varchar(8000) = NULL, -- List of columns to be excluded from the INSERT statement @disable_constraints bit = 0, -- When 1, disables foreign key constraints and enables them after the INSERT statements @ommit_computed_cols bit = 0 -- When 1, computed columns will not be included in the INSERT statement ) AS BEGIN /*********************************************************************************************************** Procedure: sp_generate_inserts (Build 22) (Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.) Purpose: To generate INSERT statements from existing data. These INSERTS can be executed to regenerate the data at some other location. This procedure is also useful to create a database setup, where in you can script your data along with your table definitions. Written by: Narayana Vyas Kondreddi http://vyaskn.tripod.com Acknowledgements: Divya Kalra -- For beta testing Mark Charsley -- For reporting a problem with scripting uniqueidentifier columns with NULL values Artur Zeygman -- For helping me simplify a bit of code for handling non-dbo owned tables Joris Laperre -- For reporting a regression bug in handling text/ntext columns Tested on: SQL Server 7.0 and SQL Server 2000 and SQL Server 2005 Date created: January 17th 2001 21:52 GMT Date modified: May 1st 2002 19:50 GMT Email: vyaskn@hotmail.com NOTE: This procedure may not work with tables with too many columns. Results can be unpredictable with huge text columns or SQL Server 2000's sql_variant data types Whenever possible, Use @include_column_list parameter to ommit column list in the INSERT statement, for better results IMPORTANT: This procedure is not tested with internation data (Extended characters or Unicode). If needed you might want to convert the datatypes of character variables in this procedure to their respective unicode counterparts like nchar and nvarchar ALSO NOTE THAT THIS PROCEDURE IS NOT UPDATED TO WORK WITH NEW DATA TYPES INTRODUCED IN SQL SERVER 2005 / YUKON Example 1: To generate INSERT statements for table 'titles': EXEC sp_generate_inserts 'titles' Example 2: To ommit the column list in the INSERT statement: (Column list is included by default) IMPORTANT: If you have too many columns, you are advised to ommit column list, as shown below, to avoid erroneous results EXEC sp_generate_inserts 'titles', @include_column_list = 0 Example 3: To generate INSERT statements for 'titlesCopy' table from 'titles' table: EXEC sp_generate_inserts 'titles', 'titlesCopy' Example 4: To generate INSERT statements for 'titles' table for only those titles which contain the word 'Computer' in them: NOTE: Do not complicate the FROM or WHERE clause here. It's assumed that you are good with T-SQL if you are using this parameter EXEC sp_generate_inserts 'titles', @from = "from titles where title like '%Computer%'" Example 5: To specify that you want to include TIMESTAMP column's data as well in the INSERT statement: (By default TIMESTAMP column's data is not scripted) EXEC sp_generate_inserts 'titles', @include_timestamp = 1 Example 6: To print the debug information: EXEC sp_generate_inserts 'titles', @debug_mode = 1 Example 7: If you are not the owner of the table, use @owner parameter to specify the owner name To use this option, you must have SELECT permissions on that table EXEC sp_generate_inserts Nickstable, @owner = 'Nick' Example 8: To generate INSERT statements for the rest of the columns excluding images When using this otion, DO NOT set @include_column_list parameter to 0. EXEC sp_generate_inserts imgtable, @ommit_images = 1 Example 9: To generate INSERT statements excluding (ommiting) IDENTITY columns: (By default IDENTITY columns are included in the INSERT statement) EXEC sp_generate_inserts mytable, @ommit_identity = 1 Example 10: To generate INSERT statements for the TOP 10 rows in the table: EXEC sp_generate_inserts mytable, @top = 10 Example 11: To generate INSERT statements with only those columns you want: EXEC sp_generate_inserts titles, @cols_to_include = "'title','title_id','au_id'" Example 12: To generate INSERT statements by omitting certain columns: EXEC sp_generate_inserts titles, @cols_to_exclude = "'title','title_id','au_id'" Example 13: To avoid checking the foreign key constraints while loading data with INSERT statements: EXEC sp_generate_inserts titles, @disable_constraints = 1 Example 14: To exclude computed columns from the INSERT statement: EXEC sp_generate_inserts MyTable, @ommit_computed_cols = 1 ***********************************************************************************************************/ SET NOCOUNT ON --Making sure user only uses either @cols_to_include or @cols_to_exclude IF ((@cols_to_include IS NOT NULL) AND (@cols_to_exclude IS NOT NULL)) BEGIN RAISERROR('Use either @cols_to_include or @cols_to_exclude. Do not use both the parameters at once',16,1) RETURN -1 --Failure. Reason: Both @cols_to_include and @cols_to_exclude parameters are specified END --Making sure the @cols_to_include and @cols_to_exclude parameters are receiving values in proper format IF ((@cols_to_include IS NOT NULL) AND (PATINDEX('''%''',@cols_to_include) = 0)) BEGIN RAISERROR('Invalid use of @cols_to_include property',16,1) PRINT 'Specify column names surrounded by single quotes and separated by commas' PRINT 'Eg: EXEC sp_generate_inserts titles, @cols_to_include = "''title_id'',''title''"' RETURN -1 --Failure. Reason: Invalid use of @cols_to_include property END IF ((@cols_to_exclude IS NOT NULL) AND (PATINDEX('''%''',@cols_to_exclude) = 0)) BEGIN RAISERROR('Invalid use of @cols_to_exclude property',16,1) PRINT 'Specify column names surrounded by single quotes and separated by commas' PRINT 'Eg: EXEC sp_generate_inserts titles, @cols_to_exclude = "''title_id'',''title''"' RETURN -1 --Failure. Reason: Invalid use of @cols_to_exclude property END --Checking to see if the database name is specified along wih the table name --Your database context should be local to the table for which you want to generate INSERT statements --specifying the database name is not allowed IF (PARSENAME(@table_name,3)) IS NOT NULL BEGIN RAISERROR('Do not specify the database name. Be in the required database and just specify the table name.',16,1) RETURN -1 --Failure. Reason: Database name is specified along with the table name, which is not allowed END --Checking for the existence of 'user table' or 'view' --This procedure is not written to work on system tables --To script the data in system tables, just create a view on the system tables and script the view instead IF @owner IS NULL BEGIN IF ((OBJECT_ID(@table_name,'U') IS NULL) AND (OBJECT_ID(@table_name,'V') IS NULL)) BEGIN RAISERROR('User table or view not found.',16,1) PRINT 'You may see this error, if you are not the owner of this table or view. In that case use @owner parameter to specify the owner name.' PRINT 'Make sure you have SELECT permission on that table or view.' RETURN -1 --Failure. Reason: There is no user table or view with this name END END ELSE BEGIN IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @table_name AND (TABLE_TYPE = 'BASE TABLE' OR TABLE_TYPE = 'VIEW') AND TABLE_SCHEMA = @owner) BEGIN RAISERROR('User table or view not found.',16,1) PRINT 'You may see this error, if you are not the owner of this table. In that case use @owner parameter to specify the owner name.' PRINT 'Make sure you have SELECT permission on that table or view.' RETURN -1 --Failure. Reason: There is no user table or view with this name END END --Variable declarations DECLARE @Column_ID int, @Column_List varchar(8000), @Column_Name varchar(128), @Start_Insert varchar(786), @Data_Type varchar(128), @Actual_Values varchar(8000), --This is the string that will be finally executed to generate INSERT statements @IDN varchar(128) --Will contain the IDENTITY column's name in the table --Variable Initialization SET @IDN = '' SET @Column_ID = 0 SET @Column_Name = '' SET @Column_List = '' SET @Actual_Values = '' IF @owner IS NULL BEGIN SET @Start_Insert = 'INSERT INTO ' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']' END ELSE BEGIN SET @Start_Insert = 'INSERT ' + '[' + LTRIM(RTRIM(@owner)) + '].' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']' END --To get the first column's ID SELECT @Column_ID = MIN(ORDINAL_POSITION) FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK) WHERE TABLE_NAME = @table_name AND (@owner IS NULL OR TABLE_SCHEMA = @owner) --Loop through all the columns of the table, to get the column names and their data types WHILE @Column_ID IS NOT NULL BEGIN SELECT @Column_Name = QUOTENAME(COLUMN_NAME), @Data_Type = DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK) WHERE ORDINAL_POSITION = @Column_ID AND TABLE_NAME = @table_name AND (@owner IS NULL OR TABLE_SCHEMA = @owner) IF @cols_to_include IS NOT NULL --Selecting only user specified columns BEGIN IF CHARINDEX( '''' + SUBSTRING(@Column_Name,2,LEN(@Column_Name)-2) + '''',@cols_to_include) = 0 BEGIN GOTO SKIP_LOOP END END IF @cols_to_exclude IS NOT NULL --Selecting only user specified columns BEGIN IF CHARINDEX( '''' + SUBSTRING(@Column_Name,2,LEN(@Column_Name)-2) + '''',@cols_to_exclude) <> 0 BEGIN GOTO SKIP_LOOP END END --Making sure to output SET IDENTITY_INSERT ON/OFF in case the table has an IDENTITY column IF (SELECT COLUMNPROPERTY( OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name),SUBSTRING(@Column_Name,2,LEN(@Column_Name) - 2),'IsIdentity')) = 1 BEGIN IF @ommit_identity = 0 --Determing whether to include or exclude the IDENTITY column SET @IDN = @Column_Name ELSE GOTO SKIP_LOOP END --Making sure whether to output computed columns or not IF @ommit_computed_cols = 1 BEGIN IF (SELECT COLUMNPROPERTY( OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name),SUBSTRING(@Column_Name,2,LEN(@Column_Name) - 2),'IsComputed')) = 1 BEGIN GOTO SKIP_LOOP END END --Tables with columns of IMAGE data type are not supported for obvious reasons IF(@Data_Type in ('image')) BEGIN IF (@ommit_images = 0) BEGIN RAISERROR('Tables with image columns are not supported.',16,1) PRINT 'Use @ommit_images = 1 parameter to generate INSERTs for the rest of the columns.' PRINT 'DO NOT ommit Column List in the INSERT statements. If you ommit column list using @include_column_list=0, the generated INSERTs will fail.' RETURN -1 --Failure. Reason: There is a column with image data type END ELSE BEGIN GOTO SKIP_LOOP END END --Determining the data type of the column and depending on the data type, the VALUES part of --the INSERT statement is generated. Care is taken to handle columns with NULL values. Also --making sure, not to lose any data from flot, real, money, smallmomey, datetime columns SET @Actual_Values = @Actual_Values + CASE WHEN @Data_Type IN ('char','varchar','nchar','nvarchar') THEN 'COALESCE('''''''' + REPLACE(RTRIM(' + @Column_Name + '),'''''''','''''''''''')+'''''''',''NULL'')' WHEN @Data_Type IN ('datetime','smalldatetime') THEN 'COALESCE('''''''' + RTRIM(CONVERT(char,' + @Column_Name + ',109))+'''''''',''NULL'')' WHEN @Data_Type IN ('uniqueidentifier') THEN 'COALESCE('''''''' + REPLACE(CONVERT(char(255),RTRIM(' + @Column_Name + ')),'''''''','''''''''''')+'''''''',''NULL'')' WHEN @Data_Type IN ('text','ntext') THEN 'COALESCE('''''''' + REPLACE(CONVERT(char(8000),' + @Column_Name + '),'''''''','''''''''''')+'''''''',''NULL'')' WHEN @Data_Type IN ('binary','varbinary') THEN 'COALESCE(RTRIM(CONVERT(char,' + 'CONVERT(int,' + @Column_Name + '))),''NULL'')' WHEN @Data_Type IN ('timestamp','rowversion') THEN CASE WHEN @include_timestamp = 0 THEN '''DEFAULT''' ELSE 'COALESCE(RTRIM(CONVERT(char,' + 'CONVERT(int,' + @Column_Name + '))),''NULL'')' END WHEN @Data_Type IN ('float','real','money','smallmoney') THEN 'COALESCE(LTRIM(RTRIM(' + 'CONVERT(char, ' + @Column_Name + ',2)' + ')),''NULL'')' ELSE 'COALESCE(LTRIM(RTRIM(' + 'CONVERT(char, ' + @Column_Name + ')' + ')),''NULL'')' END + '+' + ''',''' + ' + ' --Generating the column list for the INSERT statement SET @Column_List = @Column_List + @Column_Name + ',' SKIP_LOOP: --The label used in GOTO SELECT @Column_ID = MIN(ORDINAL_POSITION) FROM INFORMATION_SCHEMA.COLUMNS (NOLOCK) WHERE TABLE_NAME = @table_name AND ORDINAL_POSITION > @Column_ID AND (@owner IS NULL OR TABLE_SCHEMA = @owner) --Loop ends here! END --To get rid of the extra characters that got concatenated during the last run through the loop SET @Column_List = LEFT(@Column_List,len(@Column_List) - 1) SET @Actual_Values = LEFT(@Actual_Values,len(@Actual_Values) - 6) IF LTRIM(@Column_List) = '' BEGIN RAISERROR('No columns to select. There should at least be one column to generate the output',16,1) RETURN -1 --Failure. Reason: Looks like all the columns are ommitted using the @cols_to_exclude parameter END --Forming the final string that will be executed, to output the INSERT statements IF (@include_column_list <> 0) BEGIN SET @Actual_Values = 'SELECT ' + CASE WHEN @top IS NULL OR @top < 0 THEN '' ELSE ' TOP ' + LTRIM(STR(@top)) + ' ' END + '''' + RTRIM(@Start_Insert) + ' ''+' + '''(' + RTRIM(@Column_List) + '''+' + ''')''' + ' +''VALUES(''+ ' + @Actual_Values + '+'')''' + ' ' + COALESCE(@from,' FROM ' + CASE WHEN @owner IS NULL THEN '' ELSE '[' + LTRIM(RTRIM(@owner)) + '].' END + '[' + rtrim(@table_name) + ']' + '(NOLOCK)') END ELSE IF (@include_column_list = 0) BEGIN SET @Actual_Values = 'SELECT ' + CASE WHEN @top IS NULL OR @top < 0 THEN '' ELSE ' TOP ' + LTRIM(STR(@top)) + ' ' END + '''' + RTRIM(@Start_Insert) + ' '' +''VALUES(''+ ' + @Actual_Values + '+'')''' + ' ' + COALESCE(@from,' FROM ' + CASE WHEN @owner IS NULL THEN '' ELSE '[' + LTRIM(RTRIM(@owner)) + '].' END + '[' + rtrim(@table_name) + ']' + '(NOLOCK)') END --Determining whether to ouput any debug information IF @debug_mode =1 BEGIN PRINT '/*****START OF DEBUG INFORMATION*****' PRINT 'Beginning of the INSERT statement:' PRINT @Start_Insert PRINT '' PRINT 'The column list:' PRINT @Column_List PRINT '' PRINT 'The SELECT statement executed to generate the INSERTs' PRINT @Actual_Values PRINT '' PRINT '*****END OF DEBUG INFORMATION*****/' PRINT '' END PRINT '--INSERTs generated by ''sp_generate_inserts'' stored procedure written by Vyas' PRINT '--Build number: 22' PRINT '--Problems/Suggestions? Contact Vyas @ vyaskn@hotmail.com' PRINT '--http://vyaskn.tripod.com' PRINT '' PRINT 'SET NOCOUNT ON' PRINT '' --Determining whether to print IDENTITY_INSERT or not IF (@IDN <> '') BEGIN PRINT 'SET IDENTITY_INSERT ' + QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + QUOTENAME(@table_name) + ' ON' PRINT 'GO' PRINT '' END IF @disable_constraints = 1 AND (OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name, 'U') IS NOT NULL) BEGIN IF @owner IS NULL BEGIN SELECT 'ALTER TABLE ' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' NOCHECK CONSTRAINT ALL' AS '--Code to disable constraints temporarily' END ELSE BEGIN SELECT 'ALTER TABLE ' + QUOTENAME(@owner) + '.' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' NOCHECK CONSTRAINT ALL' AS '--Code to disable constraints temporarily' END PRINT 'GO' END PRINT '' PRINT 'PRINT ''Inserting values into ' + '[' + RTRIM(COALESCE(@target_table,@table_name)) + ']' + '''' --All the hard work pays off here!!! You'll get your INSERT statements, when the next line executes! EXEC (@Actual_Values) PRINT 'PRINT ''Done''' PRINT '' IF @disable_constraints = 1 AND (OBJECT_ID(QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + @table_name, 'U') IS NOT NULL) BEGIN IF @owner IS NULL BEGIN SELECT 'ALTER TABLE ' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' CHECK CONSTRAINT ALL' AS '--Code to enable the previously disabled constraints' END ELSE BEGIN SELECT 'ALTER TABLE ' + QUOTENAME(@owner) + '.' + QUOTENAME(COALESCE(@target_table, @table_name)) + ' CHECK CONSTRAINT ALL' AS '--Code to enable the previously disabled constraints' END PRINT 'GO' END PRINT '' IF (@IDN <> '') BEGIN PRINT 'SET IDENTITY_INSERT ' + QUOTENAME(COALESCE(@owner,USER_NAME())) + '.' + QUOTENAME(@table_name) + ' OFF' PRINT 'GO' END PRINT 'SET NOCOUNT OFF' SET NOCOUNT OFF RETURN 0 --Success. We are done! END GO /****** Object: Table [dbo].[ConfigLevel] Script Date: 03/23/2011 09:30:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ConfigLevel]( [configLevel] [nchar](1) NOT NULL, [descr] [nvarchar](50) NULL, [sortOrder] [int] NULL, CONSTRAINT [PK_ConfigLevel] PRIMARY KEY CLUSTERED ( [configLevel] 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 /****** Object: Table [dbo].[pay] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[pay]( [id] [int] IDENTITY(1,1) NOT NULL, [schedule] [nvarchar](50) NOT NULL, [match1] [nvarchar](50) NOT NULL, [match2] [nvarchar](50) NULL, [match3] [nvarchar](50) NULL, [match4] [nvarchar](50) NULL, [match5] [nvarchar](50) NULL, [allowed] [money] NULL, [paid] [money] NULL, CONSTRAINT [PK_pay] PRIMARY KEY CLUSTERED ( [id] 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 /****** Object: StoredProcedure [dbo].[Insert_Or_Update_Ins_Overrides] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[Insert_Or_Update_Ins_Overrides] @ins varchar(50), @tag varchar(50), @val varchar(50) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM InsOverrides WHERE tag = @tag AND ins = @ins END ELSE BEGIN IF EXISTS(SELECT * FROM InsOverrides WITH (UPDLOCK, HOLDLOCK) WHERE ins = @ins AND tag = @tag) BEGIN UPDATE InsOverrides SET [value] = @val WHERE ins = @ins AND tag = @tag END ELSE BEGIN INSERT INTO InsOverrides (ins, tag, [value]) VALUES (@ins, @tag, @val) END END COMMIT RETURN @@ERROR GO /****** Object: View [dbo].[viewInsOverrides] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewInsOverrides] as select ins, insurancebase.tag, prompt, length, valkey, browseflag, mandatory, configgroup, help, tagorder, case when systemoverrides.tag is not null then 'S' else insurancebase.lvlbase end as lvl, case when systemoverrides.tag is null then insurancebase.valuebase else systemoverrides.value end as value from ( select configtagwithins.*, case when insoverrides.tag is null then 'C' else 'I' end as lvlbase, insoverrides.value as valuebase from ( select * from cmins, configtag ) as configtagwithins left outer join insoverrides on configtagwithins.tag = insoverrides.tag and configtagwithins.ins = insoverrides.ins ) as insurancebase left outer join systemoverrides on systemoverrides.tag = insurancebase.tag GO /****** Object: View [dbo].[viewConfigWithoutEmpty] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create view [dbo].[viewConfigWithoutEmpty] as select configvalues.ins, configvalues.practice, configvalues.tag, configvalues.value, 'C' as lvl from configvalues left join insOverrides on configvalues.ins = insOverrides.ins and configvalues.tag = insoverrides.tag left join systemOverrides on systemOverrides.tag = configvalues.tag where ( systemOverrides.value is null or ltrim(systemOverrides.value) = ' ' ) and ( insoverrides.value is null or ltrim(insoverrides.value) = ' ' ) union select configvalues1.ins, configvalues1.practice, insoverrides.tag, insoverrides.value, 'I' from (select distinct ins, practice from configvalues) as configvalues1 left outer join insOverrides on configvalues1.ins = insOverrides.ins left join systemOverrides on systemOverrides.tag = insOverrides.tag where ( systemOverrides.value is null or ltrim(systemOverrides.value) = ' ' ) and ( insoverrides.value is not null and ltrim(insoverrides.value) != ' ' ) union select configvalues1.ins, configvalues1.practice, systemoverrides.tag, systemoverrides.value, 'S' from (select distinct ins, practice from configvalues) as configvalues1 , systemOverrides where ( systemOverrides.value is not null and ltrim(systemOverrides.value) != ' ' ) GO /****** Object: View [dbo].[viewConfigWithGroupstoedit] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE view [dbo].[viewConfigWithGroupstoedit] as SELECT dbo.ConfigTag.tag, dbo.ConfigTag.prompt, dbo.ConfigTag.length, dbo.ConfigTag.valkey, dbo.ConfigTag.browseFlag, dbo.ConfigTag.mandatory, dbo.ConfigTag.configGroup, dbo.ConfigTag.help, dbo.ConfigTag.tagorder, dbo.ConfigGroup.sortorder AS groupSortOrder, dbo.ConfigGroup.description AS groupDescr, dbo.ConfigGroup.help AS groupHelp, dbo.ConfigGroup.oneinsurancetype, dbo.MaintCategory.description AS categoryDescr, dbo.MaintCategory.sortorder AS categorySortOrder, dbo.MaintCategory.help AS categoryHelp FROM dbo.ConfigTag LEFT OUTER JOIN dbo.ConfigGroup ON dbo.ConfigGroup.configGroup = dbo.ConfigTag.configGroup LEFT OUTER JOIN dbo.MaintCategory ON dbo.ConfigGroup.maintCategory = dbo.MaintCategory.maintCategory where ConfigGroup.maintCategory = 'STD' GO /****** Object: View [dbo].[viewConfigWithGroups] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewConfigWithGroups] as SELECT dbo.ConfigTag.tag, dbo.ConfigTag.prompt, dbo.ConfigTag.length, dbo.ConfigTag.valkey, dbo.ConfigTag.browseFlag, dbo.ConfigTag.mandatory, dbo.ConfigTag.configGroup, dbo.ConfigTag.help, dbo.ConfigTag.tagorder, dbo.ConfigGroup.sortorder AS groupSortOrder, dbo.ConfigGroup.description AS groupDescr, dbo.ConfigGroup.help AS groupHelp, dbo.ConfigGroup.oneinsurancetype, dbo.MaintCategory.description AS categoryDescr, dbo.MaintCategory.sortorder AS categorySortOrder, dbo.MaintCategory.help AS categoryHelp FROM dbo.ConfigTag LEFT OUTER JOIN dbo.ConfigGroup ON dbo.ConfigGroup.configGroup = dbo.ConfigTag.configGroup LEFT OUTER JOIN dbo.MaintCategory ON dbo.ConfigGroup.maintCategory = dbo.MaintCategory.maintCategory GO /****** Object: View [dbo].[viewSystemOverrides] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewSystemOverrides] as select configtag.*, case when systemoverrides.tag is null then 'C' else 'S' end as lvl, systemoverrides.value from configtag left outer join systemoverrides on configtag.tag = systemoverrides.tag GO /****** Object: StoredProcedure [dbo].[Insert_Or_Update_System_Overrides] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[Insert_Or_Update_System_Overrides] @tag varchar(50), @val varchar(50) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM SystemOverrides WHERE tag = @tag END ELSE BEGIN IF EXISTS(SELECT * FROM SystemOverrides WITH (UPDLOCK, HOLDLOCK) WHERE tag = @tag) BEGIN UPDATE SystemOverrides SET [value] = @val WHERE tag = @tag END ELSE BEGIN INSERT INTO SystemOverrides (tag, [value]) VALUES (@tag, @val) END END COMMIT RETURN @@ERROR GO /****** Object: StoredProcedure [dbo].[Insert_Or_Update_Config_Values] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[Insert_Or_Update_Config_Values] @prac varchar(50), @ins varchar(50), @tag varchar(50), @val varchar(50) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM ConfigValues WHERE practice = @prac AND tag = @tag AND ins = @ins END ELSE BEGIN IF EXISTS(SELECT * FROM ConfigValues WITH (UPDLOCK, HOLDLOCK) WHERE ins = @ins AND tag = @tag AND practice = @prac) BEGIN UPDATE ConfigValues SET [value] = @val WHERE ins = @ins AND tag = @tag AND practice = @prac END ELSE BEGIN INSERT INTO ConfigValues (ins, practice, tag, [value]) VALUES (@ins, @prac, @tag, @val) END END COMMIT RETURN @@ERROR GO /****** Object: View [dbo].[viewUnfilledTagsBase] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewUnfilledTagsBase] as select configuration.ins, configuration.practice, '' as value2, 'C' as lvl, ConfigTag.*, configgroup.sortorder as groupSortOrder, configgroup.description as groupDescr, configgroup.help as groupHelp, configgroup.oneinsurancetype, maintcategory.description as categoryDescr, maintcategory.sortorder as categorySortOrder, maintcategory.help as categoryHelp from (select distinct ins , practice from viewConfigWithoutEmpty) as configuration , configTag left outer join ConfigGroup on ConfigGroup.configGroup = configtag.configgroup left outer join maintCategory on configgroup.maintcategory = maintcategory.maintcategory GO /****** Object: View [dbo].[viewConfigEdit] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewConfigEdit] AS SELECT top 100 categoryDescr, groupDescr, tag, prompt, length, valkey, mandatory, help, tagorder, configGroup, groupSortOrder, groupHelp, categoryHelp, oneinsurancetype, browseFlag FROM dbo.viewConfigWithGroups WHERE (groupDescr IS NOT NULL) ORDER BY categorySortOrder, groupSortOrder, tagorder GO /****** Object: View [dbo].[viewUnfilledTags] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewUnfilledTags] as select viewunfilledtagsbase.* from viewUnfilledTagsBase left outer join cmins on cmins.ins = viewunfilledtagsbase.ins where (viewunfilledtagsbase.oneinsurancetype is null) or viewunfilledtagsbase.oneinsurancetype = cmins.type GO /****** Object: View [dbo].[viewFinalConfig] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewFinalConfig] AS SELECT dbo.viewUnfilledTags.ins, dbo.viewUnfilledTags.practice, dbo.viewUnfilledTags.tag, CASE WHEN (viewconfigwithoutempty.value IS NULL OR ltrim(viewconfigwithoutempty.value) = ' ') THEN '' ELSE viewconfigwithoutempty.value END AS value, CASE WHEN (viewconfigwithoutempty.lvl IS NULL OR ltrim(viewconfigwithoutempty.lvl) = ' ') THEN 'C' ELSE viewconfigwithoutempty.lvl END AS lvl, dbo.viewUnfilledTags.prompt, dbo.viewUnfilledTags.length, dbo.viewUnfilledTags.valkey, dbo.viewUnfilledTags.browseFlag, dbo.viewUnfilledTags.mandatory, dbo.viewUnfilledTags.configGroup, dbo.viewUnfilledTags.help, dbo.viewUnfilledTags.tagorder, dbo.viewUnfilledTags.groupSortOrder, dbo.viewUnfilledTags.groupDescr, dbo.viewUnfilledTags.groupHelp, dbo.viewUnfilledTags.categoryDescr, dbo.viewUnfilledTags.categorySortOrder, dbo.viewUnfilledTags.categoryHelp FROM dbo.viewUnfilledTags LEFT OUTER JOIN dbo.viewConfigWithoutEmpty ON dbo.viewUnfilledTags.ins = dbo.viewConfigWithoutEmpty.ins AND dbo.viewUnfilledTags.practice = dbo.viewConfigWithoutEmpty.practice AND dbo.viewUnfilledTags.tag = dbo.viewConfigWithoutEmpty.tag GO /****** Object: View [dbo].[viewSystemOverridesOLD] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO create view [dbo].[viewSystemOverridesOLD] as SELECT dbo.viewUnfilledTags.ins, dbo.viewUnfilledTags.practice, dbo.viewUnfilledTags.tag, CASE WHEN (viewconfigwithoutempty.value IS NULL OR ltrim(viewconfigwithoutempty.value) = ' ') THEN '' ELSE viewconfigwithoutempty.value END AS value, CASE WHEN (viewconfigwithoutempty.lvl IS NULL OR ltrim(viewconfigwithoutempty.lvl) = ' ') THEN 'C' ELSE viewconfigwithoutempty.lvl END AS lvl, dbo.viewUnfilledTags.prompt, dbo.viewUnfilledTags.length, dbo.viewUnfilledTags.valkey, dbo.viewUnfilledTags.browseFlag, dbo.viewUnfilledTags.mandatory, dbo.viewUnfilledTags.configGroup, dbo.viewUnfilledTags.help, dbo.viewUnfilledTags.tagorder, dbo.viewUnfilledTags.groupSortOrder, dbo.viewUnfilledTags.groupDescr, dbo.viewUnfilledTags.groupHelp, dbo.viewUnfilledTags.categoryDescr, dbo.viewUnfilledTags.categorySortOrder, dbo.viewUnfilledTags.categoryHelp FROM dbo.viewUnfilledTags LEFT OUTER JOIN (SELECT ins, practice, tag, value, lvl FROM dbo.viewConfigWithoutEmpty AS viewConfigWithoutEmpty_1 WHERE (lvl IN ('S'))) AS viewconfigwithoutempty ON dbo.viewUnfilledTags.ins = viewconfigwithoutempty.ins AND dbo.viewUnfilledTags.practice = viewconfigwithoutempty.practice AND dbo.viewUnfilledTags.tag = viewconfigwithoutempty.tag GO /****** Object: View [dbo].[viewInsOverridesOLD] Script Date: 03/23/2011 09:31:00 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[viewInsOverridesOLD] AS SELECT dbo.viewUnfilledTags.ins, dbo.viewUnfilledTags.practice, dbo.viewUnfilledTags.tag, CASE WHEN (viewconfigwithoutempty.value IS NULL OR ltrim(viewconfigwithoutempty.value) = ' ') THEN '' ELSE viewconfigwithoutempty.value END AS value, CASE WHEN (viewconfigwithoutempty.lvl IS NULL OR ltrim(viewconfigwithoutempty.lvl) = ' ') THEN 'C' ELSE viewconfigwithoutempty.lvl END AS lvl, dbo.viewUnfilledTags.prompt, dbo.viewUnfilledTags.length, dbo.viewUnfilledTags.valkey, dbo.viewUnfilledTags.browseFlag, dbo.viewUnfilledTags.mandatory, dbo.viewUnfilledTags.configGroup, dbo.viewUnfilledTags.help, dbo.viewUnfilledTags.tagorder, dbo.viewUnfilledTags.groupSortOrder, dbo.viewUnfilledTags.groupDescr, dbo.viewUnfilledTags.groupHelp, dbo.viewUnfilledTags.categoryDescr, dbo.viewUnfilledTags.categorySortOrder, dbo.viewUnfilledTags.categoryHelp FROM dbo.viewUnfilledTags LEFT OUTER JOIN (SELECT ins, practice, tag, value, lvl FROM dbo.viewConfigWithoutEmpty AS viewConfigWithoutEmpty_1 WHERE (lvl IN ('I', 'S'))) AS viewconfigwithoutempty ON dbo.viewUnfilledTags.ins = viewconfigwithoutempty.ins AND dbo.viewUnfilledTags.practice = viewconfigwithoutempty.practice AND dbo.viewUnfilledTags.tag = viewconfigwithoutempty.tag GO use cmsql go INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('allowinsminadj','Allowed is charged minus pay and adj?',1,'YN',0,0,'SQLPAY','Y = claimmaster can calculate allowed as charge minus payments and adjustments and writeoffs.',60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ansicomponent','component separator (usually *)',1,'SEP',0,1,'SYSTEM','used for internal file control; specified by the insurance company',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ansielement','element separator (usually :)',1,'SEP',0,1,'SYSTEM','used for internal file control; specified by the insurance company',2) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ansilineend','end of line indicator(usually ~)',1,'SEP',0,1,'SYSTEM','used for internal file control; specified by the insurance company',3) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('billfiledir','Lytec billing file folder',256,NULL,1,1,'GEN','enter the folder that holds the lytec billing file. It is usually your lytec program folder',33) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('claimsfilename','transmission folder and filename',256,NULL,1,0,'INTERNET','Enter the filename and path that you want ClaimMaster to place your claim file that you will send to the insurance company',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('clm01value','CLM01 Value',50,'CLM01',0,1,'AUTOPOST','If medicaid, then MCAIDREFEA, otherwise PATCODE; If paper EOB, select what you want to see on your EOB.',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('cmbasepath','claimsdata path (including claimsdata folder)',256,NULL,1,1,'GEN','Enter the claimsdata folder path including the claimsdata folder',998) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('contactname','Contact Name',25,NULL,0,1,'GEN','The name the insurance should contact if there are any problems with the claims',40) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('contactphone','Contact Phone',40,NULL,0,1,'GEN','The phone number the insurance should contact if there are any problems with the claims.',50) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('dlinkpay','Get payment from SQL Link?',1,'YN',0,0,'SQLPAY','Y = Use an SQL link to get exact payment information directly from Lytec',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('downloaddir','download folder',256,NULL,1,0,'INTERNET','Enter the folder you want to use for saving downloads from the insurance company',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('downloadprotocol','modem download protocol',256,'PROTOCOL',0,0,'MODEM','insurance company''s modem protocol',5) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('errctl','error control filename',50,'ERRORCTL',0,1,'SYSTEM','The error control filename',90) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ETIN','not used',10,NULL,0,0,'none',NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('extracrlf','ERA gets extra linefeed',1,'',0,0,'REMIT','1 = ClaimMaster should remove the extra carriage return that is sent by the insurance because Lytec ERA does not want it',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('factbl','facility tablename',50,'FACSCHEDULE',0,0,'MCAID','facility table to help define locator code. Only used for atypical providers with no npi license',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('GHIMCAREONLY','not used',NULL,NULL,0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ins_payor_name','Lytec report filename',30,'INPFILE',0,1,'CONTROL','The filename that Lytec produces for this insurance',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('insdir','insurance folder name',10,'INSDIR',0,1,'CONTROL','The folder that will hold all the output files from claimmaster',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('insgrppract','not used',10,NULL,0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('inspayorid','insurance payor id',15,'INSPAYORID',0,1,'CONTROL','Insurance payor id',19) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('inspayrate','normal primary pay rate',4,'PAYRATE',0,1,'SEC','rate that the primary usually pays',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('instype','cm insurance type',4,'CMINSTYPE',0,1,'CONTROL','ClaimMaster control insurance type',2) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('keepcasco','Remittance keep CAS CO record',1,'YESNO',0,0,'REMIT','Keep the CAS segment''s CO value',2) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('levelID','not used',1,NULL,0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('loc','medicaid locator code',3,NULL,0,0,'MCAID','default locator used only for atypical providers with no npi licenses',40) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('medicaidid','not used',1,'YN',0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('MEDICAIDONLY','not used',NULL,NULL,0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('modphone','modem phone number',40,'MODPHONE',0,0,'MODEM','insurance company''s number to dial',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('modretries','number of times for modem to retry',2,NULL,0,0,'MODEM','Usually set to 20',15) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('modwait','modem connection wait time i',2,NULL,0,0,'MODEM','Usually set to 10',16) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('name','config name for screen',15,NULL,0,1,'GEN','This name will appear at the top of the screen when you choose this config',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('newlinetbl','new line table name',100,NULL,0,0,'SYSTEM','New line tablename',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('NEWTAG','not used',NULL,NULL,0,0,NULL,NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ninetyday','90 day default indicator',1,'90DAY',0,0,'MCAID','default 90 day indicator. This will be stamped for all claims over 90 days. Override on claim for a different indicator',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('nogroup','clear patient group id',1,'YN',0,0,'GENOP','Y = do not send a group ID even if it is entered in the billing system.',5) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('nonpitbl','Tablename to handle nonpi',100,'NONPISCHEDULE',0,0,'MCAID','No NPI table; requires license',25) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('npi','Use NPI',1,'YN',0,1,'NPI','Y= Use NPI (should always be Y)',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('npinm109','Put NPI in nm109',1,'YN',0,1,'NPI','Y = Put NPI in NM109; should always be Y',2) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('npiref','Put NPI in ref02',1,'NPIREF',0,1,'NPI','T = NPI & tax id (should always be T)',3) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('onebatch','send only one batch per transmission',2,'YESNO',0,0,'CONTROL','Should always be yes. If no, then new testing must be done. Send as one batch (one BHT)',150) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('onlyproc','not used',4,NULL,0,0,'none','This is not usually used',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('onlyrate','the only medicaid clinic rate you use',4,NULL,0,0,'MCAIDCLINIC','Enter a rate code here if you only ever use one rate code. Otherwise leave it blank',40) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paymatch1','pay table match field 1',50,'VFIELDS',0,0,'SECPAYTABLE','first code that must match the pay table',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paymatch2','pay table match field 2',50,'VFIELDS',0,0,'SECPAYTABLE','second code that must match the pay table',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paymatch3','pay table match field 3',50,'VFIELDS',0,0,'SECPAYTABLE','third code that must match the pay table',40) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paymatch4','pay table match field 4',50,'VFIELDS',0,0,'SECPAYTABLE','fourth code that must match the pay table',50) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paymatch5','pay table match field 5',50,'VFIELDS',0,0,'SECPAYTABLE','fifth code that must match the pay table',60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('paytbl','pay table name',20,'PAYSCHEDULE',0,0,'SECPAYTABLE','use a payment table of normal payment amounts to determine allowed and paid unless overridden by claim; requires license',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('pos','medicaid clinic default place of service',2,NULL,0,0,'MCAIDCLINIC','Enter the medicaid place of service for this location. 73 is a free standing clinic.',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('practice_tax_type','default practice tax type',2,'TAXTYPE',0,0,'GENOP','34 = the practice tax type in Lytec is the doctor''s social security',80) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('practicename','portion of Lytec Practice Name',100,NULL,0,0,'GEN','If you leave this blank, CM wont validate that you are processing the correct practice. You can enter only a portion of the Lytec practice name. Do not include any special characters.',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('practicetaxalt','not used',1,NULL,0,0,'none',NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('practicetaxalttype','not used',1,NULL,0,0,'none',NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('prefix','payor id prefix',15,NULL,0,0,'CONTROL','prefix to insert before payor id',160) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('primpayorid','payor id of insurance that is always primary',15,'INSPAYORID',0,0,'SEC','enter the insurance that is always primary when this config''s insurance is secondary',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('primwocontpttype','patient type that can have no contract',20,NULL,0,0,'MCAIDCLINIC','The clinic is not contracted with any other insurance for this patient type. Please verify with Medicaid that all patients of this type should have adjustment reason 38.',130) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('primwocontyn','can primary have no contract?',1,'YN',0,0,'MCAIDCLINIC','Check this box if a certain patient type has secondary claims for Medicaid do not have a contract with a primary insurance. (This only takes effect when you also fill in the patient type next to the check mark.)',120) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('procreplace','procedure replacement table',50,'PROCSCHEDULE',0,0,'GENOP','procedure replacement table is often used for physical therapy claims since Medicaid wants different procedure codes than medicare',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('proctbl','rate replacement table',50,'RATESCHEDULE',0,0,'MCAIDCLINIC','If you use more than one rate code, you need to use this table',50) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('providtype','default provider id type',2,NULL,0,0,'CONTROL','ex: medicaid 1D',170) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('provlictypectl','provider license type control file',50,NULL,0,0,'CONTROL','not currently used',900) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('provtbl','provider table file',50,NULL,0,0,'CONTROL','not currently used',910) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ratematch1','medicaid clinic rate match field 1',50,'VFIELDS',0,0,'MCAIDCLINIC','first field that the rate has to match to choose a rate code',60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ratematch2','medicaid clinic rate match field 2',50,'VFIELDS',0,0,'MCAIDCLINIC','second field that the rate has to match to choose a rate code',70) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ratematch3','medicaid clinic rate match field 3',50,'VFIELDS',0,0,'MCAIDCLINIC','third field that the rate has to match to choose a rate code',80) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ratematch4','medicaid clinic rate match field 4',50,'VFIELDS',0,0,'MCAIDCLINIC','fourth field that the rate has to match to choose a rate code',90) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ratematch5','medicaid clinic rate match field 5',50,'VFIELDS',0,0,'MCAIDCLINIC','fifth field that the rate has to match to choose a rate code',100) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('reasonsec','reason medicare is secondary',3,'MCARESEC',0,0,'MCARESEC','Enter the default reason that medicare is secondary',NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('recname_gs03','receiver name for GS03',15,NULL,0,1,'CONTROL','value provided by insurance company',40) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('recname_isa08','receiver name for ISA08',15,NULL,0,1,'CONTROL','value provided by insurance company',50) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('recname_short','receiver short name',15,NULL,0,1,'CONTROL','value provided by insurance company',60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('rectype','receiver type',2,NULL,0,1,'CONTROL','value provided by insurance company',70) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('ref6rvalue','REF6R value (usually ref6r2006)',50,'REF6R',0,1,'AUTOPOST','Lytec2006 and above use REF6R2006, otherwise use REF6RNORMAL; If paper EOB, select what you want to see on your eob',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('refeavalue','REFEA value (billno)',50,'REFEA',0,1,'AUTOPOST','usually this is set to billno',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('remitchartreplace','replace chart number for remit',1,'YN',0,0,'REMIT','Replace chart number using custom chart number logic',3) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('revenuecode','Revenue code',4,NULL,0,0,'MCAIDCLINIC','enter your contracted revenue code',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('rplctltbl','replacement control tablename',256,'RPLSCHEDULE',0,0,'ADVRPL','This is often used for zerofill',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('rplvaluestbl','replacement control values name',256,'RPLSCHEDULE',0,0,'ADVRPL','This is often used for zerofill',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('rptctl','Report control file',50,'RPTCTL',0,1,'SYSTEM','Valid Report control file',100) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('rptname','Name to appear at the top of reports',100,NULL,0,0,'GEN','This name will appear at the top of reports',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('saexcp','SA exception code (used with SA7)',1,NULL,0,0,'MCAID','When insurance custom field 2 is SA7, the SA Exception code entered here will be used on every claim.',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sendid_isa06','Your electronic submitter ID',15,NULL,0,1,'GEN','assigned by insurance company to identify your submission for ISA06 and GS02',5) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sendname_gs02','not used',15,NULL,0,0,'none',NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sendtype_isa05','sender type isa05',2,NULL,0,1,'CONTROL','value provided by insurance company',80) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sentbyclaimmaster','Sent by modem?',1,'YN',0,1,'GEN','Y = Claim is sent via modem; N = Claim sent via internet',200) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('soft','Billling software',20,'BILLSOFT',0,0,'SOFT','Billing software name',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('softvrs','Billing software version',20,NULL,0,0,'SOFT','Billing software version number (ex: 2010, XE)',2) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('specid','Specification ID',15,'SPECID',0,1,'CONTROL','Specification id number',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sqlcat','SQL catalog',100,NULL,0,0,'SQLPAY','practice database name',70) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sqldatasource','SQL data source',100,NULL,0,0,'SQLPAY','practice datasource which is often your computer name\\LYTEC_SQL',80) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sqlpass','SQL password',50,NULL,0,0,'SQLPAY','find this on Lytec''s settings / server passwords. Enter the Report password',90) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('submitter_name','Submitter name',35,NULL,0,1,'GEN','must match your license',35) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('taxidtbl','tax id tablename',100,'TAXSCHEDULE',0,0,'GENOP','Use this table only when you want to use a different tax id than the system would normally use',90) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('taxonomy','taxonomy code',15,NULL,0,0,'CONTROL','not used by claimmaster at this time',940) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('test','test flag',1,'TESTFLAG',0,1,'TEST','If this is set to test, your claims will not be paid and you will receive no EOB',NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('uploadprotocol','upload protocol',6,'PROTOCOL',0,0,'MODEM','modem upload protocol',6) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('useacceptassign','Always accept assignment?',1,'YN',0,0,'GENOP','Y = Accept assignment always; N = use billing system''s accept assignment flag; The default is N.',1) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('useinspayorid','Use the insurance payor ID entered?',1,'YN',0,1,'CONTROL','Y = Use this insurance payor id instead of the one entered in the billing system.',10) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('useprimpayorid','Use the primary payor id?',1,'YN',0,1,'SEC','Y = only one insurance is ever primary; N = medical billing system will determine primary insurance',20) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('useprovss','not used',1,'YN',0,0,'none',NULL,NULL) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('versionsetting','ClaimMaster Version',5,'CMVERSION',0,1,'GEN','This controls where CM will expect your Lytec information',300) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('webconnect','web site to send claims',256,'WEBCONNECT',0,0,'INTERNET','Enter the website that you will use to upload claims. For Ivans, you don''t need to enter anything.',30) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sqltranovr','When ADJ applied, allowed must be overridden?',50,'YN',0,0,'SQLPAY','Y = When ADJ applied, allowed must be overridden',90) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder])VALUES('sqldeductnote','Get Deductible from inside Note?',50,'YN',0,0,'SQLPAY','Y = search note to find deductible; N = use custom deductible field',90) INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','CLAIMSFILENAME','C:\ASEND_BLUE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','CLM01VALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','CONTACTNAME','ENTER CONTACT NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','CONTACTPHONE','ENTER PHONE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','ETIN','12345') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INS_PAYOR_NAME','BLUE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INSDIR','BLUE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INSGRPPRACT','P2345') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INSPAYORID','00803') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','MODPHONE','15168614005') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','NAME',' BLUEX') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','PROVIDTYPE','0B') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RECNAME_GS03','BS803') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RECNAME_ISA08','BS803') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RECNAME_SHORT','BS803') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','RPTNAME',' BLUE CROSS') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SENDNAME_GS02','12345') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('BLUE','default','WEBCONNECT','32.84.203.195:3101/') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','CONTACTNAME','ENTER CONTACT NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','CONTACTPHONE','ENTER PHONE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','ETIN','ENTER') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','INS_PAYOR_NAME','CARECORE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','INSDIR','CARECORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','INSPAYORID','00803') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','INSTYPE','COM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','NAME',' CORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','NPI','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','PROVIDTYPE','G2') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RECNAME_GS03','CARECORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RECNAME_ISA08','CARECORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RECNAME_SHORT','CARECORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','RPTNAME',' CARECORE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','USEINSPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CARECORE','default','WEBCONNECT','www.CARECORENATIONAL.COM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','ETIN','ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','EXTRACRLF','0') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','INSDIR','CLINICMCAID1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','INSPAYORID','141797357') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','INSTYPE','MCDC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','LOC','03') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','MEDICAIDID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','MODPHONE','15184635974') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','MODRETRIES','25') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','NAME',' CMCAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','NINETYDAY','9') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','NOGROUP','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','POS','73') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','PROVIDTYPE','1D') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RECNAME_GS03','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RECNAME_ISA08','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RECNAME_SHORT','NYSDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','REVENUECODE','0240') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RPTCTL','RPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','RPTNAME',' MEDICAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SENDID_ISA06','ENTER ETIN HERE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SENDNAME_GS02','ENTER ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SPECID','004010X096A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','SUBMITTER_NAME','ENTER BILLING CO') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAID1','default','WEBCONNECT','WWW.EMEDNY.ORG') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','ETIN','ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','EXTRACRLF','0') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','INSDIR','CLINICMCAIDM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','INSPAYORID','141797357') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','INSTYPE','MCDC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','LOC','03') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','MEDICAIDID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','MODPHONE','15184635974') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','MODRETRIES','25') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','NAME',' CMCAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','NINETYDAY','9') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','POS','73') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','PROVIDTYPE','1D') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','PROVTBL','PROVMEDICAID.TBL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RECNAME_GS03','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RECNAME_ISA08','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RECNAME_SHORT','NYSDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','REVENUECODE','0240') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RPTCTL','CLINIC_MULT_DATES_RPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','RPTNAME',' MEDICAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SENDID_ISA06','ENTER ETIN HERE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SENDNAME_GS02','ENTER ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SPECID','004010X096A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','SUBMITTER_NAME','ENTER BILLING CO') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('CLINICMCAIDM','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','ETIN','ENTER SUB#') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','INS_PAYOR_NAME','EMP_MEDICARE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','INSDIR','EMPMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','INSPAYORID','13202') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','MODPHONE','15168614005') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','NAME',' EMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','NEWLINETBL','NEWLINETBL.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','PROVIDTYPE','1C') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RECNAME_GS03','13202') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RECNAME_ISA08','13202') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RECNAME_SHORT','13202') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RECTYPE','27') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','RPTNAME',' EMPIRE MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SENDNAME_GS02','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('EMPMCARE','default','WEBCONNECT','32.84.203.195:3101/') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','ETIN','ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','INSDIR','MEDICAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','INSPAYORID','141797357') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','INSTYPE','MCDP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','LOC','03') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','MEDICAIDID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','MODPHONE','15184635974') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','NAME',' MCAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','NINETYDAY','9') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','NOGROUP','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','PROVIDTYPE','1D') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RECNAME_GS03','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RECNAME_ISA08','MMISNYDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RECNAME_SHORT','NYSDOH') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','RPTNAME',' MEDICAID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SENDID_ISA06','ENTER ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SENDNAME_GS02','ENTER ETIN') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','UPLOADPROTOCOL','KERMIT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICAID','default','WEBCONNECT','WWW.EMEDNY.ORG') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','CONTACTPHONE','ENTER PHONE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','DOWNLOADDIR','C:\CLAIMS_GHIMCARE\DOWNLOADS') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','ETIN','SUB') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','INS_PAYOR_NAME','GHI_MEDICARE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','INSDIR','MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','INSPAYORID','13292') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','LOC','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','MODPHONE','18882937037') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','NAME',' GMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','PROVIDTYPE','1C') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RECNAME_GS03','13292') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RECNAME_ISA08','13292') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RECNAME_SHORT','13292') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RECTYPE','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','RPTNAME',' GHI MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SENDNAME_GS02','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SENTBYCLAIMMASTER','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','UPLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('MEDICARE','default','WEBCONNECT','32.90.117.34:9964') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ETIN','ENTER SUB#') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','INS_PAYOR_NAME','NJ_MEDICARE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','INSDIR','NJMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','INSPAYORID','12402') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','MODPHONE','17172147376') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','NAME',' NJCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','ONEBATCH','YES') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','PROVIDTYPE','1C') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','PROVTBL','PROVMEDICARE.TBL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RECNAME_GS03','12402') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RECNAME_ISA08','12402') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RECNAME_SHORT','EMPIRE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RECTYPE','27') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','RPTNAME',' NJ MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SENDNAME_GS02','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SENTBYCLAIMMASTER','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','UPLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('NJMCARE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ETIN','ENTER SUB#') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','INS_PAYOR_NAME','PA_MEDICARE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','INSDIR','PAMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','INSPAYORID','12502') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','MODPHONE','17172147376') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','NAME',' PACARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','ONEBATCH','YES') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','PROVIDTYPE','1C') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','PROVTBL','PROVMEDICARE.TBL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RECNAME_GS03','12502') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RECNAME_ISA08','12502') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RECNAME_SHORT','HGSA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RECTYPE','27') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','RPTNAME',' PA MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SENDNAME_GS02','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SENDTYPE_ISA05','ZZ') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SENTBYCLAIMMASTER','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','UPLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('PAMCARE','default','USEPRIMPAYORID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ANSICOMPONENT','*') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ANSIELEMENT',':') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ANSILINEEND','~') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','BILLFILEDIR','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','CONTACTNAME','ENTER CONTACT') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','CONTACTPHONE','ENTER PHON') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ETIN','ENTER SUB#') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','EXTRACRLF','23') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','INS_PAYOR_NAME','RR_MEDICARE.INP') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','INSDIR','RRMCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','INSPAYORID','C00882') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','INSPAYRATE','0.8') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','INSTYPE','MCAR') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','LOC','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','MEDICAIDID','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','MODPHONE','18037889860') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','MODRETRIES','20') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','MODWAIT','10') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NAME',' RRCARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NEWLINETBL','NEWLINETBL.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NINETYDAY','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NOGROUP','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NPI','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NPINM109','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','NPIREF','T') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','ONEBATCH','YES') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','POS','NA') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','PRACTICE_TAX_TYPE','24') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','PRIMWOCONTYN','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','PROVIDTYPE','1C') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RECNAME_GS03','C00882') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RECNAME_ISA08','C00882') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RECNAME_SHORT','C00882') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RECTYPE','27') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','REF6RVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','REFEAVALUE','') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','REVENUECODE','N/A') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','RPTNAME',' RAILROAD MEDICARE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SAEXCP','1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SENDID_ISA06','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SENDNAME_GS02','ENTER SUB ID') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SENDTYPE_ISA05','27') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SENTBYCLAIMMASTER','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SOFT','LYTEC') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SOFTVRS','XE') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SPECID','004010X098A1') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','SUBMITTER_NAME','ENTER BILLING CO NAME') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','TEST','P') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','UPLOADPROTOCOL','ZMODEM') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','USEACCEPTASSIGN','N') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','USEINSPAYORID','Y') INSERT INTO [ConfigValues] ([ins],[practice],[tag],[value])VALUES('RRMCARE','default','USEPRIMPAYORID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','RECNAME_GS03','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','RECNAME_ISA08','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','RECNAME_SHORT','NYSDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','WEBCONNECT','WWW.EMEDNY.ORG') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','EXTRACRLF','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','INS_PAYOR_NAME','GHI_MEDICARE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','INSDIR','MEDICARE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','INSPAYORID','13292') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','INSTYPE','MCAR') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','MODPHONE','18882937037') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','PROVIDTYPE','1C') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','RECNAME_GS03','13292') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','RECNAME_ISA08','13292') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','RECNAME_SHORT','13292') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','UPLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICARE','WEBCONNECT','32.90.117.34:9964') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','INSDIR','CLINICMCAID1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','INSPAYORID','141797357') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','INSTYPE','MCDC') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','MEDICAIDID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','MODPHONE','15184635974') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','MODRETRIES','25') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','PROVIDTYPE','1D') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','RECNAME_GS03','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','RECNAME_ISA08','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','RECNAME_SHORT','NYSDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','RPTCTL','RPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','SPECID','004010X096A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','WEBCONNECT','WWW.EMEDNY.ORG') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','INSDIR','CLINICMCAIDM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','INSPAYORID','141797357') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','INSTYPE','MCDC') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','MEDICAIDID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','MODPHONE','15184635974') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','MODRETRIES','25') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','PROVIDTYPE','1D') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','RECNAME_GS03','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','RECNAME_ISA08','MMISNYDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','RECNAME_SHORT','NYSDOH') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','RPTCTL','CLINIC_MULT_DATES_RPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','SPECID','004010X096A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAIDM','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','INS_PAYOR_NAME','EMP_MEDICARE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','PROVIDTYPE','1C') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','RECNAME_GS03','12502') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','RECNAME_ISA08','12502') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','RECNAME_SHORT','HGSA') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','RECTYPE','27') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','SENTBYCLAIMMASTER','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','UPLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','INS_PAYOR_NAME','RR_MEDICARE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','INSDIR','RRMCARE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','INSPAYORID','C00882') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','INSTYPE','MCAR') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','MODPHONE','18037889860') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','PROVIDTYPE','1C') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','RECNAME_GS03','C00882') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','RECNAME_ISA08','C00882') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','RECNAME_SHORT','C00882') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','RECTYPE','27') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','SENDTYPE_ISA05','27') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','SENTBYCLAIMMASTER','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','UPLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('RRMCARE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','INS_PAYOR_NAME','BLUE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','INSDIR','BLUE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','INSPAYORID','00803') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','INSTYPE','BLUE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','MODPHONE','15168614005') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','PROVIDTYPE','0B') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','RECNAME_GS03','BS803') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','RECNAME_ISA08','BS803') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','RECNAME_SHORT','BS803') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('BLUE','WEBCONNECT','32.84.203.195:3101/') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','INS_PAYOR_NAME','CARECORE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','INSDIR','CARECORE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','INSPAYORID','00803') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','INSTYPE','COM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','PROVIDTYPE','G2') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','RECNAME_GS03','CARECORE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','RECNAME_ISA08','CARECORE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','RECNAME_SHORT','CARECORE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','RECTYPE','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','USEINSPAYORID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CARECORE','WEBCONNECT','www.CARECORENATIONAL.COM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('CLINICMCAID1','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','INS_PAYOR_NAME','NJ_MEDICARE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','INSDIR','NJMCARE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','INSPAYORID','12402') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','INSTYPE','MCAR') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','MODPHONE','17172147376') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','PROVIDTYPE','1C') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','RECNAME_GS03','12402') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','RECNAME_ISA08','12402') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','RECNAME_SHORT','EMPIRE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','RECTYPE','27') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','SENTBYCLAIMMASTER','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','UPLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('NJMCARE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','DOWNLOADPROTOCOL','ZMODEM') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','ERRCTL','ERR_MEDICARE.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','EXTRACRLF','0') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','INS_PAYOR_NAME','PA_MEDICARE.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','INSDIR','PAMCARE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','INSPAYORID','12502') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','INSTYPE','MCAR') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','MODPHONE','17172147376') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('PAMCARE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','INSDIR','EMPMCARE') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','INSPAYORID','13202') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','INSTYPE','MCAR') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','LOC','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','MEDICAIDID','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','MODPHONE','15168614005') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','POS','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','PROVIDTYPE','1C') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','RECNAME_GS03','13202') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','RECNAME_ISA08','13202') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','RECNAME_SHORT','13202') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','RECTYPE','27') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','REF6RVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','REFEAVALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','REVENUECODE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','RPTCTL','PHYSICIANRPT.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','SENDTYPE_ISA05','ZZ') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','SENTBYCLAIMMASTER','N') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','SPECID','004010X098A1') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','TEST','P') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','UPLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','USEINSPAYORID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('EMPMCARE','WEBCONNECT','32.84.203.195:3101/') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','CLM01VALUE','') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','DOWNLOADPROTOCOL','KERMIT') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','ERRCTL','ERR_MEDICAID.CTL') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','INS_PAYOR_NAME','MEDICAID.INP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','INSDIR','MEDICAID') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','INSPAYORID','141797357') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','INSTYPE','MCDP') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','MEDICAIDID','Y') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','MODPHONE','15184635974') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','MODRETRIES','20') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','MODWAIT','10') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','ONEBATCH','YES') INSERT INTO [InsOverrides] ([ins],[tag],[value])VALUES('MEDICAID','PROVIDTYPE','1D') INSERT INTO [MaintCategory] ([maintCategory],[description],[sortorder],[help])VALUES('OP','Optional',2,'Some practices need to change these values') INSERT INTO [MaintCategory] ([maintCategory],[description],[sortorder],[help])VALUES('PR','Practice',1,'Needs to be set for every practice') INSERT INTO [MaintCategory] ([maintCategory],[description],[sortorder],[help])VALUES('STD','Standard',3,'Almost never changes') INSERT INTO [MaintCategory] ([maintCategory],[description],[sortorder],[help])VALUES('TST','Test',4,'Test flag') INSERT INTO [Practice] ([Practice],[Description],[practiceFolder],[lastIns],[defaultPractice],[npi],[noCrossover],[sqlCatalog])VALUES('default','default','default','MEDICAID',NULL,NULL,NULL,NULL) INSERT INTO [SystemOverrides] ([tag],[value])VALUES('ANSICOMPONENT','*') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('ANSIELEMENT',':') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('ANSILINEEND','~') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('BILLFILEDIR','C:\Program Files\Lytec 2010') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('CMBASEPATH','C:\claimsdata') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('NPI','Y') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('NPINM109','Y') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('NPIREF','T') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('SOFT','LYTEC') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('SOFTVRS','2010') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('SQLDATASOURCE','kris02\LYTEC_SQL') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('SQLPASS','password') INSERT INTO [SystemOverrides] ([tag],[value])VALUES('VERSIONSETTING','SET11') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('90DAY','1',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('90DAY','2',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('90DAY','3',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('BILLSOFT','LYTEC',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CLM01','','BILL2LINE Bill number plus 2 digit line number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CLM01','','BILLNO Bill number alone') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CLM01','','BILLPATFIRST Bill number plus patient first name') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CLM01','','MCAIDREFEA Autopost value for medicaid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CLM01','','PATCODE autopost value for all other ins') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMINSTYPE','BLUE','Blue Cross') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMINSTYPE','COMM','Commercial') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMINSTYPE','MCAR','Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMINSTYPE','MCDC','Medicaid Clinic') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMINSTYPE','MCDP','Medicaid Physician') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET05','XE, 2006 & 2007 ins cust 1 for group NPI') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET06','XE, 2006 & 2007 prov cust 1 for group NPI') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET07','XE, 2004 & 2005 ins cust 1 for group NPI') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET08','2001') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET09','XE, 2004 & 2005 prov cust 1 for group NPI') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET10','2006-2009') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('CMVERSION','SET11','2010+') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('ERRORCTL','ERR_MEDICAID.CTL',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('ERRORCTL','ERR_MEDICARE',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('FACSCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','BLUE.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','EMP_MEDICARE.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','GHI_MEDICARE.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','MEDICAID.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','NJ_MEDICARE.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INPFILE','PA_MEDICARE.INP',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','BLUE','Blue cross') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','CARECORE','Care core') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','CLINMCAID','Clinic Medicaid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','EMPMCARE','Downstate Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','MEDICAID','Physician Medicaid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','MEDICARE','Queens Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','NJMCARE','New Jersey Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','PAMCARE',' PA Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSDIR','RRMCARE','Railroad Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','00803','Blue Cross') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','12402','NJ Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','12502','PA Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','13202','Downstate Medicare (formerly Empire)') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','13292','Queens Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','141797357','NY Medicaid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('INSPAYORID','C00882','Railroad Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MCARESEC','12','working aged beneficiary or spouse') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MCARESEC','13','end staged renal diseased beneficiary') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MCARESEC','14','no fault insurance including auto') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MCARESEC','15','worker''s compensation') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MODPHONE','17172147376','NJ Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MODPHONE','18037889860','RR Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('MODPHONE','18778796471','Queens Medicare') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NONPISCHEDULE','DEFAULT','to be setup by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NONPISCHEDULE','SPECIAL1','special 1') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCUST6','Insurance custom field 6') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCUST8','Insurance custom field 8') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','MCAIDREFEA',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','MOD1','Claim Detail modifier 1') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','MOD2','Claim Detail modifier 2') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','MOD3','Claim Detail modifier 3') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','MOD4','Claim Detail modifier4') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','NDCCODE','NDC Code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','OVRALLOW','Overridden allowed') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','OVRPAID','Overridden paid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PATCODE',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PINSCODE','Primary insurance code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PRIMFLAG','Primary flag (P = Primary and S = Secondary)') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PROV','Provider Code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PROVCUST1','Provider custom field 1') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PROVCUST8','Provider custom field 8') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PROVTAXONOMY','Provider Taxonomy') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PTCODE','Patient code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','PTTYPE','Patient type') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','RPROV','Referring provider') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','SPECPROC','Insurance custom field 2') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','SVCDAY','Service Day') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','SVCMONTH','Service Month') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','SVCYEAR','Service Year') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','UNITS','Claim Detail units') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('WEBCONNECT','WWW.EMEDNY.ORG','Medicaid') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YESNO','NO','NO') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YESNO','YES','YES') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YN','N','N') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YN','Y','Y') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YN2','N','N') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('YN2','Y','Y') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NPIREF','A','NPI, Legacy and Tax Id') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NPIREF','B','NPI and legacy') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NPIREF','I','Legacy Only') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NPIREF','O','NPI only') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('NPIREF','T','NPI and tax id') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PAYRATE','.5','50 percent usually for mental health') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PAYRATE','.8','80 percent') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PAYSCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PROCSCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PROTOCOL','KERMIT',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PROTOCOL','NOPROTOCOL',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PROTOCOL','XMODEM',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('PROTOCOL','ZMODEM',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('RATESCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','BILL2LINE Bill number plus 2 digit line number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','BILLNO Bill number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','BILLPATFIRST Bill number plus patient first name') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','PATCODE patient chart number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','REF6R2006 Autopost for Lytec 2006 or newer') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REF6R','','REF6RNORMAL Autopost value if Lytec 2005 or older') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REFEA','','BILL2LINE Bill number plus 2 digit line number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REFEA','','BILLNO Autopost value') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REFEA','','BILLPATFIRST Bill number plus patient first name') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('REFEA','','PATCODE Patient chart number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('RPLSCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('RPTCTL','PHYSICIANRPT.CTL','Not Medicaid Clinic') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('RPTCTL','RPT.CTL','Medicaid Clinic') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('SEP','*','*') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('SEP',':',':') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('SEP','~','~') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('SPECID','004010X096A1','Institutional') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('SPECID','004010X098A1','Professional') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('TAXSCHEDULE','TBD','To be set up by user') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('TAXTYPE','24','Employer ID') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('TAXTYPE','34','Social Security') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('TESTFLAG','P','Production') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('TESTFLAG','T','Test') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','ANASTHMIN','Anasthesia minutes') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','BILLNO','Bill number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','BILLPATFIRST','Bill number plus patient first name') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','BILLPLUS2LINE','Bill number plus 2 digit line number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','CLASSFINDINGS','Class Findings') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','CLIAPROV','Provider clia number') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','CPT',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','DETCUST5',NULL) INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','DIAG1','Diagnosis 1') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','FACCODE','Facility code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','FEESCHED','Fee Schedule') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCODE','Insurance Code') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCUST1','Insurance custom field 1') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCUST10','Insurance custom field 10') INSERT INTO [ValidValues] ([valkey],[value],[desc])VALUES('VFIELDS','INSCUST15','Insurance custom field 15') INSERT INTO [ConfigLevel] ([configLevel],[descr],[sortOrder])VALUES('C','Ins & Practice',10) INSERT INTO [ConfigLevel] ([configLevel],[descr],[sortOrder])VALUES('I','Insurance',20) INSERT INTO [ConfigLevel] ([configLevel],[descr],[sortOrder])VALUES('S','System',30) INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('ADVRPL',11,'Advanced replacement control',NULL,NULL,'OP') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('AUTOPOST',45,'Auto Posting ERA Settings',NULL,NULL,'PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('CONTROL',10,'Insurance Control',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('GEN',10,'General Settings',NULL,NULL,'PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('GENOP',10,'General Optional settings',NULL,NULL,'OP') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('INTERNET',20,'Claims Sent through the internet',NULL,NULL,'PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('MCAID',50,'Medicaid Settings',NULL,'Medicaid','PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('MCAIDCLINIC',60,'Medicaid Clinic Settings',NULL,'Medicaid','PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('MCARESEC',40,'Medicare Secondary only',NULL,'Medicare','PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('MODEM',910,'Claims Sent through a modem',NULL,NULL,'OP') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('NPI',900,'NPI Settings',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('REMIT',100,'Remittance System Control',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SEC',30,'Secondary claim Settings',NULL,NULL,'PR') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SECPAYTABLE',50,'Secondary Payments',NULL,NULL,'OP') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SOFT',120,'Billing Software',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SPECIAL',20,'Advanced Options',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SQLPAY',60,'SQL Payment settings',NULL,NULL,'OP') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('SYSTEM',300,'System Control',NULL,NULL,'STD') INSERT INTO [ConfigGroup] ([configGroup],[sortorder],[description],[help],[oneinsurancetype],[maintCategory])VALUES('TEST',10,'Test',NULL,NULL,'TST') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('CARECORE','carecore','commercial') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('CLINICMCAID1','Clinic Medicaid One Bill per date','medicaid') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('CLINICMCAIDM','Clinic Medicaid Many Dates per bill','medicaid') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('NJMCARE','New Jersey Medicare','medicare') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('PAMCARE','PA Medicare','medicare') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('RRMCARE','RR Medicare','medicare') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('MEDICARE','GHI Medicare','medicare') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('MEDICAID','physician mcaid','medicaid') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('EMPMCARE','Empire Medicare','medicare') INSERT INTO [CmIns] ([Ins],[Description],[Type])VALUES('BLUE','blue cross','blue') go use cmsql go update validvalues set validvalues.[desc] = value where validvalues.[desc] is null; update validvalues set value = '<' + value + '>' where valkey = 'VFIELDS'; insert into validvalues values('RPTCTL','clinic_mult_dates_rpt.ctl','Medicaid Clinic Multi Date'); use cmsql go insert into validvalues values( 'SPECID' , '005010X222A1', 'Professional 5010') insert into validvalues values( 'SPECID' , '005010X223A2', 'Institutional 5010') update validvalues set validvalues.[desc] = value where validvalues.[desc] is null update validvalues set value = '<' + value + '>' where valkey = 'VFIELDS' insert into configtag values( 'faccodequalif' ,'Facility Code Qualifier' ,'5' ,'' , 0 , 0 , 'GEN' , 'B for physician and A for clinic. B = Place of service from FAO record of EMCNSF A = Uniform Billing Claim Form Bill Type' ,0) insert into configtag values( 'patsigsource' ,'Patient Signature Source' ,'2' ,'' , 0 , 0 , 'GEN' , 'P = signature generated by provider because patient was not physically present for services.' ,0) go CREATE FUNCTION [dbo].[getDataSourceName] (@udlin text ) returns nvarchar(250) AS BEGIN DECLARE @returnPracticeSource nvarchar(500) -- extract practice source from middle of udl set @returnPracticeSource = substring (@udlin,charindex('Catalog=',@udlin )+8 , ( case when charindex(';',@udlin, charindex('Catalog=',@udlin )) > 0 then (charindex(';',@udlin,charindex('Catalog=',@udlin )) - charindex('Catalog=',@udlin ) -8 ) else datalength ( @udlin) - charindex('Catalog=',@udlin )-7 end) ) RETURN @returnPracticeSource END go CREATE view [dbo].[view_lytec_practice_list] as select lytecpractice.[practice name] as practice_name, cast ([DATABASE name] as nvarchar(254))as practice_source from [Lytec SharedData].dbo.[practice list] as lytecpractice go create view [dbo].[view_practices_used_and_available] as select * from view_lytec_practice_list union select 'Does not exist: ' + sqlcatalog as practice_name, sqlcatalog as practice_source from practice p left outer join view_lytec_practice_list v on p.sqlcatalog = v.practice_source where v.practice_source is null go use cmsql go insert into validvalues values ('MCARESEC','16','Medicare Secondary PHS or Other Federal Agency') insert into validvalues values ('MCARESEC','41','Medicare Secondary Black Lung') insert into validvalues values ('MCARESEC','42','Medicare Secondary Veteran’s Administration') insert into validvalues values ('MCARESEC','43','Medicare Secondary Disabled Benef 65 with Large') insert into validvalues values ('MCARESEC','47', 'Medicare Secondary, Other Liability Ins Primary') -- note : may need to effect security also ; may need to run as dba USE [CMSQL] GO /****** Object: StoredProcedure [dbo].[Insert_Or_Update_Config_Values] Script Date: 10/29/2011 01:41:42 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TABLE [dbo].[ConfigValues] ALTER COLUMN [value] [nvarchar](999) NULL ; go aLTER PROCEDURE [dbo].[Insert_Or_Update_Config_Values] @prac varchar(999), @ins varchar(999), @tag varchar(999), @val varchar(999) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM ConfigValues WHERE practice = @prac AND tag = @tag AND ins = @ins END ELSE BEGIN IF EXISTS(SELECT * FROM ConfigValues WITH (UPDLOCK, HOLDLOCK) WHERE ins = @ins AND tag = @tag AND practice = @prac) BEGIN UPDATE ConfigValues SET [value] = @val WHERE ins = @ins AND tag = @tag AND practice = @prac END ELSE BEGIN INSERT INTO ConfigValues (ins, practice, tag, [value]) VALUES (@ins, @prac, @tag, @val) END END COMMIT RETURN @@ERROR go ALTER PROCEDURE [dbo].[Insert_Or_Update_Ins_Overrides] @ins varchar(999), @tag varchar(999), @val varchar(999) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM InsOverrides WHERE tag = @tag AND ins = @ins END ELSE BEGIN IF EXISTS(SELECT * FROM InsOverrides WITH (UPDLOCK, HOLDLOCK) WHERE ins = @ins AND tag = @tag) BEGIN UPDATE InsOverrides SET [value] = @val WHERE ins = @ins AND tag = @tag END ELSE BEGIN INSERT INTO InsOverrides (ins, tag, [value]) VALUES (@ins, @tag, @val) END END COMMIT RETURN @@ERROR go ALTER PROCEDURE [dbo].[Insert_Or_Update_System_Overrides] @tag varchar(999), @val varchar(999) AS SET NOCOUNT, XACT_ABORT ON BEGIN TRAN IF LTRIM(RTRIM(@val)) = '' BEGIN DELETE FROM SystemOverrides WHERE tag = @tag END ELSE BEGIN IF EXISTS(SELECT * FROM SystemOverrides WITH (UPDLOCK, HOLDLOCK) WHERE tag = @tag) BEGIN UPDATE SystemOverrides SET [value] = @val WHERE tag = @tag END ELSE BEGIN INSERT INTO SystemOverrides (tag, [value]) VALUES (@tag, @val) END END COMMIT RETURN @@ERROR go select top 10 * from configtag where configgroup like '%SEC%' INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder]) VALUES('secpayzeroisdeduct' ,'Primary paid 0 without custom allowed means a deductible was applied' ,1,'YN',0,0,'SEC', 'Y = Whenever the primary pays zero assume a deductible was the cause; N = pay zero does not imply deductible' ,60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder]) VALUES('totpayasline1' ,'Use claim payment as first line payment unless overridden' ,1,'YN',0,0,'SEC', 'Y = If no override on the claim payment, use the total claim payment as the first line payment' ,60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder]) VALUES('incclaimlvlpay' ,'Include claim level payments in total pay?' ,1,'YN',0,0,'SQLPAY', 'Y = claim level payments will be included in total paid; N = they will not be included' ,60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder]) VALUES('priminspayonly' ,'Only include primary insurance payment types?' ,1,'YN',0,0,'SQLPAY', 'Y = Secondary type payments will be ignored; N = all insurance payment types will be included in paid' ,60) INSERT INTO [ConfigTag] ([tag],[prompt],[length],[valkey],[browseFlag],[mandatory],[configGroup],[help],[tagorder]) VALUES('sqlclaimpayonly' ,'Only get claim payments from Lytec SQL, not detail payments?' ,1,'YN',0,0,'SQLPAY', 'Y = detail payments will not come from Lytec SQL; N = If SQL payment is used, it is used for detail and claim level payments' ,60) insert into validvalues values('CMVERSION','SET12','2011+') go update validvalues set [desc] = '2010' where value = 'SET11' go create view [dbo].[view_practices_used_and_available] as select * from view_lytec_practice_list union select 'Does not exist: ' + sqlcatalog as practice_name, sqlcatalog as practice_source from practice p left outer join view_lytec_practice_list v on p.sqlcatalog = v.practice_source where v.practice_source is null go use cmsql go insert into cmsql.dbo.Practice select left([practice name],35),left([practice name],100), left([Practice name],50) , ' ' ,'N' ,' ' , 'N' ,[DATABASE name] from [Lytec SharedData].dbo.[practice list]