ALTER TABLE UACI_CHStaging ADD RTSelectionMethod int NULL
go

ALTER TABLE UACI_RHStaging ADD RTSelectionMethod int NULL
go

ALTER TABLE HH_CHStaging ADD RTSelectionMethod int NULL
go

ALTER TABLE HH_RHStaging ADD RTSelectionMethod int NULL
go

insert into UACI_IdsByType (TypeID, NextID) (select 2, 
	IDENT_CURRENT('UACI_RHStaging') + IDENT_CURRENT('HH_RHStaging') 
	+ IDENT_INCR( 'UACI_RHStaging' ))
go

select * into UACI_RHStaging_COPY from UACI_RHStaging
go

select * into HH_RHStaging_COPY from HH_RHStaging
go

DROP TABLE UACI_RHStaging
go

CREATE TABLE UACI_RHStaging (
       SeqNum               bigint NOT NULL,
       TreatmentCode        varchar(512) NULL,
       CustomerID           bigint NULL,
       ResponseDate         datetime NULL,
       ResponseType         int NULL,
       ResponseTypeCode     varchar(64) NULL,
       Mark                 bigint NOT NULL
                                          DEFAULT 0,
       UserDefinedFields    char(18) NULL,
	 RTSelectionMethod    int NULL,
       CONSTRAINT iRHStaging_PK 
              PRIMARY KEY (SeqNum ASC)
)
go

insert into UACI_RHStaging (SeqNum, TreatmentCode, CustomerID, ResponseDate, 
	ResponseType, ResponseTypeCode, Mark, UserDefinedFields, RTSelectionMethod) 
  (select SeqNum, TreatmentCode, CustomerID, ResponseDate, ResponseType, 
		ResponseTypeCode, Mark, UserDefinedFields, RTSelectionMethod from 
		UACI_RHStaging_COPY)
go

DROP TABLE UACI_RHStaging_COPY
go

DROP TABLE HH_RHStaging
go

CREATE TABLE HH_RHStaging (
       SeqNum               bigint NOT NULL,
       TreatmentCode        varchar(512) NULL,
       HouseholdID           bigint NULL,
       ResponseDate         datetime NULL,
       ResponseType         int NULL,
       ResponseTypeCode     varchar(64) NULL,
       Mark                 bigint NOT NULL
                                          DEFAULT 0,
       UserDefinedFields    char(18) NULL,
	 RTSelectionMethod    int NULL,
       CONSTRAINT iRHStaging_PK 
              PRIMARY KEY (SeqNum ASC)
)
go

insert into HH_RHStaging (SeqNum, TreatmentCode, HouseHoldID, ResponseDate, 
	ResponseType, ResponseTypeCode, Mark, UserDefinedFields, RTSelectionMethod) 
  (select SeqNum, TreatmentCode, HouseHoldID, ResponseDate, ResponseType, 
		ResponseTypeCode, Mark, UserDefinedFields, RTSelectionMethod from 
		HH_RHStaging_COPY)
go

DROP TABLE HH_RHStaging_COPY
go

INSERT into UACI_IdsByType (TypeID, NextID)  
	(select 2, COALESCE(max(a.seqnum)+1,1)  
	+ COALESCE(max(b.seqnum)+1,1) 
	from UACI_RHSTAGING a, ACCT_UACI_RHSTAGING b );

ALTER TABLE HH_ScoreOverride  ADD 
        OverrideTypeID       int NULL,
        CellCode             varchar(64) NULL,
        Zone                 varchar(64) NULL
go

ALTER TABLE HH_ScoreOverride  ADD
        Predicate            varchar(4000) NULL,
        FinalScore           float NULL,
        EnableStateID        int NULL
go

CREATE INDEX iScoreOverride_IX1 ON HH_ScoreOverride
(
       HouseHoldID                     ASC
)
go