 	[alaskan_native_servicing_institution] [bit] NULL,
 	[native_hawaiian_servicing_institution] [bit] NULL,
 	[sba_certified_8a_joint_venture] [bit] NULL,
-	[dot_certified_disadvantage] [bit] NULL
+	[dot_certified_disadvantage] [bit] NULL,
+	[CSIStiebreakerID] [int] IDENTITY(1,1) NOT NULL,
+	[contract_transaction_unique_key] [varchar](74) NULL,
+	[contract_award_unique_key] [varchar](74) NULL,
+	[current_total_value_of_award] [decimal](19, 4) NULL,
+	[potential_total_value_of_award] [decimal](19, 4) NULL,
+	[award_or_idv_flag] [varchar](5) NULL,
+	[inherently_governmental_functions] [varchar](10) NULL,
+	[total_dollars_obligated] [decimal](19, 4) NULL,
+	[solicitation_date] [date] NULL,
+	[treasury_accounts_funding_this_award] [varchar](4000) NULL,
+	[federal_accounts_funding_this_award] [varchar](1000) NULL,
+	[usaspending_permalink] [varchar](150) NULL,
+	[awarding_agency_code] [smallint] NULL,
+	[recipient_county_name] [varchar](25) NULL,
+	[disaster_emergency_fund_codes_for_overall_award] [varchar](500) NULL,
+	[object_classes_funding_this_award] [varchar](1000) NULL,
+	[program_activities_funding_this_award] [varchar](4000) NULL,
+	[obligated_amount_funded_by_COVID19_supplementals_for_overall_award] [decimal](19, 4) NULL,
+	[outlayed_amount_funded_by_COVID19_supplementals_for_overall_award] [decimal](19, 4) NULL,
+	[IsMissingFromUpdate] [bit] NOT NULL
 ) ON [PRIMARY]
 GO
+ALTER TABLE [ErrorLogging].[FPDSdeleted] ADD  CONSTRAINT [df_CSISmodifiedDate]  DEFAULT (getdate()) FOR [CSISModifiedDate]
+GO
+ALTER TABLE [ErrorLogging].[FPDSdeleted] ADD  DEFAULT ((1)) FOR [IsMissingFromUpdate]
+GO
+ALTER TABLE [ErrorLogging].[FPDSdeleted]  WITH CHECK ADD  CONSTRAINT [fk_errorlogging_fpdsduplicates_csistransctionid] FOREIGN KEY([CSIStransactionID])
+REFERENCES [Contract].[CSIStransactionID] ([CSIStransactionID])
+GO
+ALTER TABLE [ErrorLogging].[FPDSdeleted] CHECK CONSTRAINT [fk_errorlogging_fpdsduplicates_csistransctionid]
+GO

	[numberofemployees] [bigint] NULL,
	[annualrevenue] [decimal](19, 4) NULL,
	[CSIStransactionID] [int] NOT NULL,
	[CSISUniqueIndexID] [uniqueidentifier] NULL,
	[CSISUniqueIndexIdentity] [uniqueidentifier] NOT NULL,
	[PlaceofPerformanceCity] [varchar](100) NULL,
	[prime_awardee_executive1] [varchar](100) NULL,
	[prime_awardee_executive2] [varchar](100) NULL,

GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [ErrorLogging].[FPDSdeleted](
	[unique_transaction_id] [varchar](36) NULL,
	[transaction_status] [varchar](6) NULL,
	[obligatedamount] [decimal](19, 4) NULL,
