Home Dashboard Directory Help
Search

SSDT Rebuilds the Same Table Every Time I Publish by David Elish


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 779703
Opened: 2/21/2013 7:12:53 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Every time I publish a particular SSDT SQL Server Project the same table is scripted to be rebuilt. Nothing has changed with this table. Unfortunately it is a somewhat large table so it makes what would be a 20 second publish about 5 minutes.
Details
Sign in to post a comment.
Posted by Microsoft on 2/28/2013 at 12:55 PM
Hey David,

Thanks for passing along the definition, it helped me narrow in on the issue. If you look at a schema comparison between the project and the resulting database, there are 3 differences that are being flagged in the table that are causing the rebuild - the [State_Province_Name], [CreatedDate], and [CreatedUser] columns. The differences are arising due to normalization that the SQL Server engine is doing to the definition of the computed column and default constraints.

The workaround for this issue is to take the engine normalized definitions of these objects from your database and put those definitions back into the database project. This will prevent the difference from continuing to pop up during model comparison and deployment.

Thanks for your feedback,
Adam Mahood
Program Manager
SQL Server Database Systems
Posted by David Elish on 2/25/2013 at 11:22 AM
It's ugly...
CREATE TABLE [dbo].[DragonQuotePolicyTransactionPolicy]
(
[Job_ID]                                                                                                    BIGINT NOT NULL
,[Object_ID]                                                                                                BIGINT NOT NULL
,[AccountAgencyTrackingID]                                                                                 VARCHAR (255) NULL
,[AccountAgencyTrackingStatus]                                                                             VARCHAR (255) NULL
,[addclueservicerequest]                                                                                    VARCHAR (255) NULL
,[AnyPriorLosses_enum]                                                                                     VARCHAR (255) NULL
,[AnyPriorLosses_text]                                                                                     VARCHAR (255) NULL
,[ApplicationAccepted_enum]                                                                                 VARCHAR (255) NULL
,[ApplicationAccepted_text]                                                                                 VARCHAR (255) NULL
,[ApplicationReceivedDate]                                                                                 VARCHAR (255) NULL
,[BindPolicyQuote_enum]                                                                                     VARCHAR (255) NULL
,[BindPolicyQuote_text]                                                                                     VARCHAR (255) NULL
,[ChildCountPolicyTransaction]                                                                             VARCHAR (255) NULL
,[ChoicepointAccount]                                                                                     VARCHAR (255) NULL
,[ChoicePointAccountLookup]                                                                                 VARCHAR (255) NULL
,[ChoicePointAccountSuffixLookup]                                                                         VARCHAR (255) NULL
,[ChoicePointModel]                                                                                         VARCHAR (255) NULL
,[ChoicePointModelLookup]                                                                                 VARCHAR (255) NULL
,[CurrentPaymentProfilebeingentered_enum]                                                                 VARCHAR (255) NULL
,[CurrentPaymentProfilebeingentered_text]                                                                 VARCHAR (255) NULL
,[FloridaHurricaneCATFundFeePolicy]                                                                         VARCHAR (255) NULL
,[GenericObjectCreationDate]                                                                                VARCHAR (255) NULL
,[GenericObjectLastUpdateDate]                                                                             VARCHAR (255) NULL
,[GenericObjectObjectState_enum]                                                                            INT NULL
,[GenericObjectObjectState_text]                                                                            VARCHAR (255) NULL
,[GenericObjectReferenceCreatorDragonUserID]                                                                VARCHAR (255) NULL
,[Hasinsurancebeentransferredwithinagency_enum]                                                             VARCHAR (255) NULL
,[Hasinsurancebeentransferredwithinagency_text]                                                             VARCHAR (255) NULL
,[Isthecompanioncreditinitialized_enum]                                                                     VARCHAR (255) NULL
,[Isthecompanioncreditinitialized_text]                                                                     VARCHAR (255) NULL
,[ParentHouseholdID]                                                                                        BIGINT NULL
,[ParentPolicyTransaction]                                                                                 VARCHAR (255) NULL
,[PolicyAuditableIndicator_enum]                                                                            VARCHAR (255) NULL
,[PolicyAuditableIndicator_text]                                                                            VARCHAR (255) NULL
,[PolicyAuditFrequency_enum]                                                                                VARCHAR (255) NULL
,[PolicyAuditFrequency_text]                                                                                VARCHAR (255) NULL
,[PolicyBillingAddressCalc]                                                                                 VARCHAR (255) NULL
,[PolicyBillingMethod_enum]                                                                                 VARCHAR (255) NULL
,[PolicyBillingMethod_text]                                                                                 VARCHAR (255) NULL
,[PolicyBillingNameandAddressDifferentIndicator_enum]                                                     VARCHAR (255) NULL
,[PolicyBillingNameandAddressDifferentIndicator_text]                                                     VARCHAR (255) NULL
,[PolicyBillingPaymentMethodDONOTUSETOBERETIRED_enum]                                                     VARCHAR (255) NULL
,[PolicyBillingPaymentMethodDONOTUSETOBERETIRED_text]                                                     VARCHAR (255) NULL
,[PolicyBillingPaymentPlanType_enum]                                                                        VARCHAR (255) NULL
,[PolicyBillingPaymentPlanType_text]                                                                        VARCHAR (255) NULL
,[PolicyBillingPaymentPlanTypeDescription]                                                                 VARCHAR (255) NULL
,[PolicyCommissionBasis_enum]                                                                             VARCHAR (255) NULL
,[PolicyCommissionBasis_text]                                                                             VARCHAR (255) NULL
,[PolicyCommissionPercentageFinalCalculated]                                                                VARCHAR (255) NULL
,[PolicyCountofTransactionsRollforwardedinasingledatabasetransaction]                                     VARCHAR (255) NULL
,[PolicyCRMBillsNotificationsDeliveryType_enum]                                                             VARCHAR (255) NULL
,[PolicyCRMBillsNotificationsDeliveryType_text]                                                             VARCHAR (255) NULL
,[PolicyCustomerPUREMarketingGroupstored]                                                                 VARCHAR (255) NULL
,[PolicyCustomerPUREMarketingGroupusedEnumcalculated]                                                     VARCHAR (255) NULL
,[PolicyDateBound]                                                                                         VARCHAR (255) NULL
,[PolicyDateEffective]                                                                                     VARCHAR (255) NULL
,[PolicyDateExpiration]                                                                                     VARCHAR (255) NULL
,[PolicyEmailOrMailingAddressCalc]                                                                         VARCHAR (500) NULL
,[PolicyFlagsIsthereaholdontheNewBusiness]                                                                 VARCHAR (255) NULL
,[PolicyFulltermcostincludeCATFundFee]                                                                     VARCHAR (255) NULL
,[PolicyholderwithLegalEntityCaculated]                                                                     VARCHAR (255) NULL
,[PolicyIdentifierLegacyPolicyGeneration]                                                                 VARCHAR (255) NULL
,[PolicyIdentifierLegacyPolicyNumber]                                                                     VARCHAR (255) NULL
,[PolicyIdentifierLegacyPolicyTypeSymbol]                                                                 VARCHAR (255) NULL
,[PolicyIdentifierPolicyNumber]                                                                             VARCHAR (255) NULL
,[PolicyIndividualBillingAddress]                                                                         VARCHAR (500) NULL
,[PolicyInsuranceLine_enum]                                                                                 INT NULL
,[PolicyInsuranceLine_text]                                                                                 VARCHAR (255) NULL
,[PolicyIssuanceSpecificButtonWorkflowIndicator_enum]                                                     VARCHAR (255) NULL
,[PolicyIssuanceSpecificButtonWorkflowIndicator_text]                                                     VARCHAR (255) NULL
,[PolicyLockedIndicator_enum]                                                                             VARCHAR (255) NULL
,[PolicyLockedIndicator_text]                                                                             VARCHAR (255) NULL
,[PolicyMaxExpirationDatecalculated]                                                                        VARCHAR (255) NULL
,[PolicyMaxProcessedExpirationDatecalculated]                                                             VARCHAR (255) NULL
,[PolicyNeedsUnderwritingInformation_enum]                                                                 VARCHAR (255) NULL
,[PolicyNeedsUnderwritingInformation_text]                                                                 VARCHAR (255) NULL
,[PolicyNumberoftransactionsRolledBackButnotforward]                                                        VARCHAR (255) NULL
,[PolicyNumberTypeProductCalc]                                                                             VARCHAR (255) NULL
,[PolicyOriginalInceptionDate]                                                                             VARCHAR (255) NULL
,[PolicyOriginTransactionType_enum]                                                                         VARCHAR (255) NULL
,[PolicyOriginTransactionType_text]                                                                         VARCHAR (255) NULL
,[PolicyPackageCredit_enum]                                                                                 VARCHAR (255) NULL
,[PolicyPackageCredit_text]                                                                                 VARCHAR (255) NULL
,[PolicyPartnerCommissionPartnerLevel]                                                                     VARCHAR (255) NULL
,[PolicyPartnerCommissionPolicydefaultLevel]                                                                VARCHAR (255) NULL
,[PolicyPartnerCommissionSystemLevel]                                                                     VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentAmount]                                                                     VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentCheckNumber]                                                                 VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentMode_enum]                                                                    VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentMode_text]                                                                    VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentReceived_enum]                                                                VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentReceived_text]                                                                VARCHAR (255) NULL
,[PolicyPaymentPlanDownPaymentSweepConfirmationNumber]                                                     VARCHAR (255) NULL
,[PolicyPaymentPlanSumofInstallmentPaymentsexclInstallmentFees]                                             VARCHAR (255) NULL
,[PolicyPaymentUseOneUseIndividualBillingProfile_enum]                                                     VARCHAR (255) NULL
,[PolicyPaymentUseOneUseIndividualBillingProfile_text]                                                     VARCHAR (255) NULL
,[PolicyPaymentUseOneUseMultipleBillingAddresses_enum]                                                     VARCHAR (255) NULL
,[PolicyPaymentUseOneUseMultipleBillingAddresses_text]                                                     VARCHAR (255) NULL
,[PolicyPremiumCurrentGrandTotal]                                                                         VARCHAR (255) NULL
,[PolicyPremiumRenewalGrandTotalforDisplayCalculated]                                                     VARCHAR (255) NULL
,[PolicyPremiumRenewalProRataCoverageTotal]                                                                 VARCHAR (255) NULL
,[PolicyPrintingTransactionType_enum]                                                                     VARCHAR (255) NULL
,[PolicyPrintingTransactionType_text]                                                                     VARCHAR (255) NULL
,[PolicyProductDefinitionID_enum]                                                                         INT NULL
,[PolicyProductDefinitionID_text]                                                                         VARCHAR (255) NULL
,[PolicyProductDefinitionIDTextCalculated]                                                                 VARCHAR (255) NULL
,[PolicyProductDescription]                                                                                 VARCHAR (255) NULL
,[PolicyQuoteXwind_enum]                                                                                    VARCHAR (255) NULL
,[PolicyQuoteXwind_text]                                                                                    VARCHAR (255) NULL
,[PolicyRatingCapitalContribution]                                                                         VARCHAR (255) NULL
,[PolicyRatingCompany_enum]                                                                                 VARCHAR (255) NULL
,[PolicyRatingCompany_text]                                                                                 VARCHAR (255) NULL
,[PolicyRatingFullTermCommissionsTotal]                                                                     VARCHAR (255) NULL
,[PolicyRatingFullTermFeesTotal]                                                                            VARCHAR (255) NULL
,[PolicyRatingFullTermPremiumTotal]                                                                         VARCHAR (255) NULL
,[PolicyRatingFullTermSurchargesTotal]                                                                     VARCHAR (255) NULL
,[PolicyRatingFullTermTaxesTotal]                                                                         VARCHAR (255) NULL
,[PolicyRatingFullTermTotalandCapitalContribution]                                                         VARCHAR (255) NULL
,[PolicyRatingFullTermTotalCostPremiumFeesSurchargesTaxesCommission]                                        VARCHAR (255) NULL
,[PolicyRatingState_enum]                                                                                 VARCHAR (255) NULL
,[PolicyRatingState_text]                                                                                 VARCHAR (255) NULL
,[PolicyRatingTransactionEffectiveDate]                                                                     VARCHAR (255) NULL
,[PolicyRatingTransactionType_enum]                                                                         VARCHAR (255) NULL
,[PolicyRatingTransactionType_text]                                                                         VARCHAR (255) NULL
,[PolicyRenewalPaymentPlan_enum]                                                                            VARCHAR (255) NULL
,[PolicyRenewalPaymentPlan_text]                                                                            VARCHAR (255) NULL
,[PolicyRenewalReviewRequiredIndicator_enum]                                                                VARCHAR (255) NULL
,[PolicyRenewalReviewRequiredIndicator_text]                                                                VARCHAR (255) NULL
,[PolicySkipRenewalImageCreationIndicator_enum]                                                             VARCHAR (255) NULL
,[PolicySkipRenewalImageCreationIndicator_text]                                                             VARCHAR (255) NULL
,[PolicyTerm_enum]                                                                                         VARCHAR (255) NULL
,[PolicyTerm_text]                                                                                         VARCHAR (255) NULL
,[PolicyTransactionEffectiveDate]                                                                         VARCHAR (255) NULL
,[PolicyTransactionTypeCurrent_enum]                                                                        VARCHAR (255) NULL
,[PolicyTransactionTypeCurrent_text]                                                                        VARCHAR (255) NULL
,[PolicyUnderwritingNotes]                                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingNumberofrelevantandunresolvedtriggers]                                                 VARCHAR (255) NULL
,[PolicyUnderwritingPremiumDisplayIssueTriggered_enum]                                                     VARCHAR (255) NULL
,[PolicyUnderwritingPremiumDisplayIssueTriggered_text]                                                     VARCHAR (255) NULL
,[PolicyUnderwritingReferredTriggered_enum]                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingReferredTriggered_text]                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingRejectionReason_enum]                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingRejectionReason_text]                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingTriggersaccepted_enum]                                                                 VARCHAR (255) NULL
,[PolicyUnderwritingTriggersaccepted_text]                                                                 VARCHAR (255) NULL
,[PolicyXwind_enum]                                                                                         VARCHAR (255) NULL
,[PolicyXwind_text]                                                                                         VARCHAR (255) NULL
,[QuoteEffectiveDate]                                                                                     VARCHAR (255) NULL
,[QuoteEnteredBy]                                                                                         VARCHAR (255) NULL
,[QuoteEnteredByPhoneNumber]                                                                                VARCHAR (255) NULL
,[QuoteExpirationDate]                                                                                     VARCHAR (255) NULL
,[QuoteName]                                                                                                VARCHAR (255) NULL
,[QuoteNotes]                                                                                             VARCHAR (500) NULL
,[QuotePLExtendedFamilyName]                                                                                VARCHAR (255) NULL
,[QuotePLPolicyholderTypes_enum]                                                                            INT NULL
,[QuotePLPolicyholderTypes_text]                                                                            VARCHAR (255) NULL
,[QuotePolicyTermDescription]                                                                             VARCHAR (255) NULL
,[QuotePriorPolicyCompany_enum]                                                                             VARCHAR (255) NULL
,[QuotePriorPolicyCompany_text]                                                                             VARCHAR (255) NULL
,[QuotePriorPolicyEffectiveDate]                                                                            VARCHAR (255) NULL
,[QuotePriorPolicyExpirationDate]                                                                         VARCHAR (255) NULL
,[QuotePriorPolicyInAgencyTransfer_enum]                                                                    VARCHAR (255) NULL
,[QuotePriorPolicyInAgencyTransfer_text]                                                                    VARCHAR (255) NULL
,[QuotePriorPolicyNumber]                                                                                 VARCHAR (255) NULL
,[RateBookFilingID]                                                                                         INT NULL
,[ReferenceAccountDONOTUSEIncludedIncludesBusinessAddressState_enum]                                        VARCHAR (255) NULL
,[ReferenceAccountDONOTUSEIncludedIncludesBusinessAddressState_text]                                        VARCHAR (255) NULL
,[ReferenceAccountInformationAssetsVehiclesOwned_enum]                                                     VARCHAR (255) NULL
,[ReferenceAccountInformationAssetsVehiclesOwned_text]                                                     VARCHAR (255) NULL
,[ReferenceAccountInformationEmailAddress]                                                                 VARCHAR (255) NULL
,[ReferenceAccountInformationHouseholdEmailAddress]                                                         VARCHAR (255) NULL
,[ReferenceAccountInformationHouseholdMobilePhoneNumber]                                                    VARCHAR (255) NULL
,[ReferenceAccountInformationHouseholdPrimaryPhoneNumber]                                                 VARCHAR (255) NULL
,[ReferenceAccountInformationHouseholdWorkPhoneNumber]                                                     VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressApartmentNumber]                                 VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressCity]                                            VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressLine1]                                         VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressLine2]                                         VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressLine3]                                         VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressPostCode]                                        VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressState_enum]                                     VARCHAR (255) NULL
,[ReferenceAccountInformationIncludedLocationAddressAddressState_text]                                     VARCHAR (255) NULL
,[ReferenceAccountInformationObjectLabel]                                                                 VARCHAR (500) NULL
,[ReferenceAccountInformationPersonChoicepointReferenceNumber]                                             VARCHAR (255) NULL
,[ReferenceAccountInformationPersonCreditScore]                                                             VARCHAR (255) NULL
,[ReferenceAccountInformationPersonCreditScoreDate]                                                         VARCHAR (255) NULL
,[ReferenceAccountInformationPersonCreditScoreRatingAgency_enum]                                            VARCHAR (255) NULL
,[ReferenceAccountInformationPersonCreditScoreRatingAgency_text]                                            VARCHAR (255) NULL
,[ReferenceAccountInformationPersonDateofBirth]                                                             VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameFirst]                                                             VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameFull]                                                                VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameLast]                                                                VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameSalutation_enum]                                                     VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameSalutation_text]                                                     VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameSuffix_enum]                                                         VARCHAR (255) NULL
,[ReferenceAccountInformationPersonNameSuffix_text]                                                         VARCHAR (255) NULL
,[ReferenceAccountInformationPersonSocialSecurityNumber]                                                    VARCHAR (255) NULL
,[ReferenceAssociatedScenarioObjectState_enum]                                                             VARCHAR (255) NULL
,[ReferenceAssociatedScenarioObjectState_text]                                                             VARCHAR (255) NULL
,[ReferenceAssociatedScenarioObjectState210153_enum]                                                        VARCHAR (255) NULL
,[ReferenceAssociatedScenarioObjectState210153_text]                                                        VARCHAR (255) NULL
,[ReferenceAssociatedScenarioPolicyPremiumRenewalGrandTotalforDisplayCalculated]                            VARCHAR (255) NULL
,[ReferenceBillingAddressAddresseeFullName]                                                                 VARCHAR (255) NULL
,[ReferenceBillingAddressHouseholdLocationCityStateZip]                                                     VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressCity]                                                VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressCityStateZip]                                        VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressLine1]                                             VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressLine2]                                             VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressLine3]                                             VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressPostCode]                                            VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressState_enum]                                         VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressAddressState_text]                                         VARCHAR (255) NULL
,[ReferenceBillingAddressIncludedLocationAddressDisplayAddressaddline123]                                 VARCHAR (255) NULL
,[ReferenceBillingAddressObjectLabel]                                                                     VARCHAR (500) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressCity]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressLine1]                            VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressLine2]                            VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressLine3]                            VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressPostCode]                         VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressPrimaryPhoneNumber]             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressState_enum]                     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressAddressState_text]                     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofCompanyName]         VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonFirstName]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonLastName]        VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonPrefix_enum]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonPrefix_text]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonType_enum]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingAddressIncludedLocationAddressMailingAttentionofPersonType_text]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileCheckEFTCCAccountHolderFirstName]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileCheckEFTCCAccountHolderLastName]                                VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileCheckEFTCCBankName]                                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTAccountNumber]                                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTAccountType_enum]                                            VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTAccountType_text]                                            VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTEditAccountNumberIndicator_enum]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTEditAccountNumberIndicator_text]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileEFTMaskedAccountNumberCalculated]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressApartmentNumber]                         VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressCity]                                     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressLine1]                                    VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressPostCode]                                 VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressState_enum]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfileIncludedBillingAddressState_text]                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardExpirationDateMonth_enum]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardExpirationDateMonth_text]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardExpirationDateYear_enum]        VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardExpirationDateYear_text]        VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardNumber]                         VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardSecurityCode]                 VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardType_enum]                     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardCreditCardType_text]                     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardEditCreditCardNumberIndicator_enum]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardEditCreditCardNumberIndicator_text]     VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardEditCreditCardSecurityCodeIndicator_enum] VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardEditCreditCardSecurityCodeIndicator_text] VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardMaskedCreditCardNumberCalculated]         VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentCreditDebitCardMaskedCreditCardSecurityCodeCalculated] VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentEFTBankRoutingNumber]                                    VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentMode_enum]                                             VARCHAR (255) NULL
,[ReferenceCapitalContributionBillingProfilePaymentMode_text]                                             VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanObjectLabel]                                                                    VARCHAR (500) NULL
,[ReferenceChosenPaymentPlanPaymentPlanDownPaymentAmount]                                                 VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPaymentPlanFirstInstallmentAmojunt]                                             VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPaymentPlanID]                                                                 VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPaymentPlanNumberofInstalments]                                                 VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPaymentPlanTotal]                                                             VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPolicyRatingTier_enum]                                                         VARCHAR (255) NULL
,[ReferenceChosenPaymentPlanPolicyRatingTier_text]                                                         VARCHAR (255) NULL
,[ReferenceCommonBillingAddressIncludedLocationAddressAddressCity]                                         VARCHAR (255) NULL
,[ReferenceCommonBillingAddressIncludedLocationAddressAddressPostCode]                                     VARCHAR (255) NULL
,[ReferenceCommonBillingAddressIncludedLocationAddressMailingAttentionofPersonFirstName]                    VARCHAR (255) NULL
,[ReferenceCommonBillingAddressIncludedLocationAddressMailingAttentionofPersonLastName]                     VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonCreditReportStatusCode]                                             VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonEmploymentEmployerName]                                             VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonNameFirst]                                                            VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonNameFull]                                                             VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonNameLast]                                                             VARCHAR (255) NULL
,[ReferenceCreditScoreIndividualPersonOccupationClassText]                                                 VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBillingAddressComplete]                                                        VARCHAR (500) NULL
,[ReferenceCurrentBillingPrefBilllPaymentPlanName_enum]                                                     VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBilllPaymentPlanName_text]                                                     VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBillRecipientType_enum]                                                        VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBillRecipientType_text]                                                        VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBilltoMortgageeIndicator_enum]                                                 VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefBilltoMortgageeIndicator_text]                                                 VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefObjectState_enum]                                                             VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefObjectState_text]                                                             VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPolicyIndividualBillingAddressChangedIndicator_enum]                         VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPolicyIndividualBillingAddressChangedIndicator_text]                         VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPreferenceBillDeliveryMethod_enum]                                             VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPreferenceBillDeliveryMethod_text]                                             VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPreferenceConsolidatedorIndividualBillType_enum]                             VARCHAR (255) NULL
,[ReferenceCurrentBillingPrefPreferenceConsolidatedorIndividualBillType_text]                             VARCHAR (255) NULL
,[ReferenceCurrentCoveragePolicyIdentifierPolicyNumber]                                                     VARCHAR (255) NULL
,[ReferenceCurrentCoveragePolicyRatingFullTermTotalCostPremiumFeesSurchargesTaxesCommission]                VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDeliveryMethodforJobCreation_enum]                                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDeliveryMethodforJobCreation_text]                                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDeliveryMethodOnGoing_enum]                                                    VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDeliveryMethodOnGoing_text]                                                    VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDocRecipientType_enum]                                                         VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefDocRecipientType_text]                                                         VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefHowwouldyoulikethedocumentdeliveredForAgentNBonly_enum]                        VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefHowwouldyoulikethedocumentdeliveredForAgentNBonly_text]                        VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefMaketheselectedlocationasMemberlevelPrimaryIndicator_enum]                     VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefMaketheselectedlocationasMemberlevelPrimaryIndicator_text]                     VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBAgentEmailAddress]                                                         VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBDocDeliveryOptionsforMemberOptedoutofEmail_enum]                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBDocDeliveryOptionsforMemberOptedoutofEmail_text]                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBDocRecipientDisplayfield]                                                    VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBDoestheAgentwanttobeinvolvedinnewbusinessdelivery_enum]                     VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBDoestheAgentwanttobeinvolvedinnewbusinessdelivery_text]                     VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBPrintandMailbyPUREOptions_enum]                                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNBPrintandMailbyPUREOptions_text]                                             VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefNewBusinesssenttoCalculated]                                                 VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefOnGoingAddressInformation]                                                     VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefUseMembersPrimaryMailingAddressIndicator_enum]                                 VARCHAR (255) NULL
,[ReferenceCurrentMailingPrefUseMembersPrimaryMailingAddressIndicator_text]                                 VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedBillingAddressCity]                                                        VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedBillingAddressPostCode]                                                    VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedBillingAddressState_enum]                                                 VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedBillingAddressState_text]                                                 VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedMailingAddressPostCode]                                                    VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedMailingAddressState_enum]                                                 VARCHAR (255) NULL
,[ReferenceCurrentProfileIncludedMailingAddressState_text]                                                 VARCHAR (255) NULL
,[ReferenceCurrentProfilePaymentCreditDebitCardCreditCardType_enum]                                         VARCHAR (255) NULL
,[ReferenceCurrentProfilePaymentCreditDebitCardCreditCardType_text]                                         VARCHAR (255) NULL
,[ReferenceCurrentProfilePaymentMode_enum]                                                                 VARCHAR (255) NULL
,[ReferenceCurrentProfilePaymentMode_text]                                                                 VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionBalancePaid]                                                        VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionEffectiveDate]                                                     VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionPaymentMode_enum]                                                 VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionPaymentMode_text]                                                 VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionPaymentReceivedIndicator_enum]                                     VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionPaymentReceivedIndicator_text]                                     VARCHAR (255) NULL
,[ReferenceCurrentTransactionTransactionPremiumCurrentTotal]                                                VARCHAR (255) NULL
,[ReferenceHouseholdID]                                                                                     VARCHAR (255) NULL
,[ReferenceLastPaymentCreationDate]                                                                         VARCHAR (255) NULL
,[ReferenceLastPaymentTransactionBalancePaid]                                                             VARCHAR (255) NULL
,[ReferenceLastTransactionProcessedTransactionEffectiveDate]                                                VARCHAR (255) NULL
,[ReferenceLatestNBRNTransactionCalculatedPaymentPlanName]                                                 VARCHAR (255) NULL
,[ReferenceLatestNBRNTransactionCalculatedPolicyCommissionBasis_enum]                                     VARCHAR (255) NULL
,[ReferenceLatestNBRNTransactionCalculatedPolicyCommissionBasis_text]                                     VARCHAR (255) NULL
,[ReferenceLatestNBRNTransactionCalculatedPolicyIdentifierPolicyNumber]                                     VARCHAR (255) NULL
,[ReferenceLatestProcessedNBorRenewalTransactionPolicyDateExpiration]                                     VARCHAR (255) NULL
,[ReferenceLatestProcessedNBorRenewalTransactionPolicyIdentifierPolicyNumber]                             VARCHAR (255) NULL
,[ReferenceLatestProcessedNBorRenewalTransactionTransactionType_enum]                                     VARCHAR (255) NULL
,[ReferenceLatestProcessedNBorRenewalTransactionTransactionType_text]                                     VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupHouseholdLocationCityStateZip]                                         VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressCity]                                     VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressLine1]                                     VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressLine2]                                     VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressLine3]                                     VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressPostCode]                                 VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressState_enum]                                VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressAddressState_text]                                VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupIncludedLocationAddressDisplayAddressaddline123]                         VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupPlaceholderLocationType_enum]                                            VARCHAR (255) NULL
,[ReferenceListBillingAddressLookupPlaceholderLocationType_text]                                            VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupAddresseeFullName]                                                     VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressCity]                                     VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressCityStateZip]                             VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressLine1]                                     VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressLine2]                                     VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressLine3]                                     VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressPostCode]                                 VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressState_enum]                                VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressAddressState_text]                                VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupIncludedLocationAddressDisplayAddressaddline123]                         VARCHAR (255) NULL
,[ReferenceListMailingAddressLookupObjectLabel]                                                             VARCHAR (500) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressCity]                                         VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressLine1]                                         VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressLine2]                                         VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressLine3]                                         VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressPostCode]                                     VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressState_enum]                                     VARCHAR (255) NULL
,[ReferenceLocalBillingAddressIncludedLocationAddressAddressState_text]                                     VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressCity]                                         VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressLine1]                                         VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressLine2]                                         VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressLine3]                                         VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressPostCode]                                     VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressState_enum]                                     VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressAddressState_text]                                     VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressDisplayAddressaddline123]                             VARCHAR (255) NULL
,[ReferenceLocalMailingAddressIncludedLocationAddressMailingAttentionofPersonFirstName]                     VARCHAR (255) NULL
,[ReferenceMailingAddressAddresseeFullName]                                                                 VARCHAR (255) NULL
,[ReferenceMailingAddressHouseholdLocationCityStateZip]                                                     VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressCity]                                                VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressCityStateZip]                                        VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressLine1]                                             VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressLine2]                                             VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressLine3]                                             VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressPostCode]                                            VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressPrimaryPhoneNumber]                                 VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressState_enum]                                         VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressAddressState_text]                                         VARCHAR (255) NULL
,[ReferenceMailingAddressIncludedLocationAddressDisplayAddressaddline123]                                 VARCHAR (255) NULL
,[ReferenceMailingAddressObjectLabel]                                                                     VARCHAR (500) NULL
,[ReferenceMostRecentProcessedCreatedTransactionTransactionEffectiveDate]                                 VARCHAR (255) NULL
,[ReferenceMostRecentProcessedCreatedTransactionTransactionProcessDate]                                     VARCHAR (255) NULL
,[ReferenceMostRecentSetRenewalFlagTransactionCalculatedPolicyTransactionRenewNonRenewIndicator_enum]     VARCHAR (255) NULL
,[ReferenceMostRecentSetRenewalFlagTransactionCalculatedPolicyTransactionRenewNonRenewIndicator_text]     VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedHouseholdLocationCityStateZip]                                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressCity]                             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressCity27846702]                     VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine1]                            VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine127846302]                    VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine2]                            VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine227846402]                    VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine3]                            VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressLine327846502]                    VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressPostCode]                         VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressPostCode27846802]                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressState_enum]                     VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressState_text]                     VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressState27846602_enum]             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressAddressState27846602_text]             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedIncludedLocationAddressDisplayAddressaddline123]                VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedJurisdiction_enum]                                             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedJurisdiction_text]                                             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedObjectLabel]                                                    VARCHAR (500) NULL
,[ReferenceNeworCurrentTransactionCalculatedObjectLabel211882]                                             VARCHAR (500) NULL
,[ReferenceNeworCurrentTransactionCalculatedObjectState_enum]                                             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedObjectState_text]                                             VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedPaymentPlanName]                                                VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedPolicyDateEffective]                                            VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedPolicyDateExpiration]                                         VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedPolicyIdentifierPolicyNumber]                                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedPolicyIdentifierPolicyNumber231]                                VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionPayoffAmount]                                        VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionPostMarkRequestDate]                                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionPremiumCurrentTotal]                                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionPremiumCurrentTotalAfterCalculated]                 VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionType_enum]                                         VARCHAR (255) NULL
,[ReferenceNeworCurrentTransactionCalculatedTransactionType_text]                                         VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBilllPaymentPlanName_enum]                                             VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBilllPaymentPlanName_text]                                             VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBillRecipientType_enum]                                                 VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBillRecipientType_text]                                                 VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBilltoMortgageeIndicator_enum]                                         VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefBilltoMortgageeIndicator_text]                                         VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPolicyIndividualBillingAddressChangedIndicator_enum]                    VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPolicyIndividualBillingAddressChangedIndicator_text]                    VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPreferenceBillDeliveryMethod_enum]                                     VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPreferenceBillDeliveryMethod_text]                                     VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPreferenceConsolidatedorIndividualBillType_enum]                        VARCHAR (255) NULL
,[ReferenceNewPlaceholderBillingPrefPreferenceConsolidatedorIndividualBillType_text]                        VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefDeliveryMethodforJobCreation_enum]                                     VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefDeliveryMethodforJobCreation_text]                                     VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefDeliveryMethodOnGoing_enum]                                             VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefDeliveryMethodOnGoing_text]                                             VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefMaketheselectedlocationasMemberlevelPrimaryIndicator_enum]             VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefMaketheselectedlocationasMemberlevelPrimaryIndicator_text]             VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefNBDocRecipientDisplayfield]                                             VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefNewBusinesssenttoCalculated]                                            VARCHAR (255) NULL
,[ReferenceNewPlaceholderMailingPrefOnGoingAddressInformation]                                             VARCHAR (255) NULL
,[ReferenceNextPaymentTransactionBalancePaid]                                                             VARCHAR (255) NULL
,[ReferenceNextPaymentTransactionDueDate]                                                                 VARCHAR (255) NULL
,[ReferencePolicyID]                                                                                        VARCHAR (255) NULL
,[ReferencePolicyNumber]                                                                                    VARCHAR (255) NULL
,[ReferencePolicyQuotePaymentMode_enum]                                                                     VARCHAR (255) NULL
,[ReferencePolicyQuotePaymentMode_text]                                                                     VARCHAR (255) NULL
,[ReferencePolicyQuoteProposalDocumentContents]                                                             VARCHAR (255) NULL
,[ReferencePolicyQuoteProposalDocumentFormID_enum]                                                         VARCHAR (255) NULL
,[ReferencePolicyQuoteProposalDocumentFormID_text]                                                         VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressCity]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressLine1]                                        VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressLine2]                                        VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressPostCode]                                     VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressPrimaryPhoneNumber]                         VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressState_enum]                                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressAddressState_text]                                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofCompanyName]                     VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonFirstName]                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonLastName]                    VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonPrefix_enum]                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonPrefix_text]                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonType_enum]                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofPersonType_text]                 VARCHAR (255) NULL
,[ReferencePremiumBillingAddressIncludedLocationAddressMailingAttentionofReferenceNumber]                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfileCheckEFTCCAccountHolderFirstName]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileCheckEFTCCAccountHolderLastName]                                            VARCHAR (255) NULL
,[ReferencePremiumBillingProfileCheckEFTCCBankName]                                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTAccountNumber]                                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTAccountType_enum]                                                        VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTAccountType_text]                                                        VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTEditAccountNumberIndicator_enum]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTEditAccountNumberIndicator_text]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileEFTMaskedAccountNumberCalculated]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressApartmentNumber]                                     VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressCity]                                                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressLine1]                                                VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressPostCode]                                             VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressState_enum]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfileIncludedBillingAddressState_text]                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardExpirationDateMonth_enum]                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardExpirationDateMonth_text]                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardExpirationDateYear_enum]                    VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardExpirationDateYear_text]                    VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardNumber]                                     VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardSecurityCode]                             VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardType_enum]                                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardCreditCardType_text]                                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardEditCreditCardNumberIndicator_enum]                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardEditCreditCardNumberIndicator_text]                 VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardEditCreditCardSecurityCodeIndicator_enum]             VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardEditCreditCardSecurityCodeIndicator_text]             VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardMaskedCreditCardNumberCalculated]                     VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentCreditDebitCardMaskedCreditCardSecurityCodeCalculated]             VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentEFTBankRoutingNumber]                                                VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentMode_enum]                                                         VARCHAR (255) NULL
,[ReferencePremiumBillingProfilePaymentMode_text]                                                         VARCHAR (255) NULL
,[ReferenceProducerUserID]                                                                                 VARCHAR (255) NULL
,[ReferenceProducingAgencyID]                                                                             BIGINT NULL
,[ReferenceRatingWorksheetDocumentContents]                                                                 VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressCity]                             VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressLine1]                             VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressLine2]                             VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressPostCode]                         VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressState_enum]                         VARCHAR (255) NULL
,[ReferenceRefTempMailingAddressCalculatedIncludedLocationAddressAddressState_text]                         VARCHAR (255) NULL
,[ReferenceResultingPolicyPolicyIdentifierPolicyNumber]                                                     VARCHAR (255) NULL
,[ReferenceResultingPolicyTransactionProcessDate]                                                         VARCHAR (255) NULL
,[ReferenceUnderwriterUserID]                                                                             VARCHAR (255) NULL
,[SignedApplicationReceived_enum]                                                                         VARCHAR (255) NULL
,[SignedApplicationReceived_text]                                                                         VARCHAR (255) NULL
,[State_Province_Name] AS CAST(SUBSTRING(PolicyProductDefinitionIDTextCalculated, CHARINDEX('-', PolicyProductDefinitionIDTextCalculated, 1)
                                                             + 2, 99) AS VARCHAR(30)) PERSISTED
,[TestPolicySet_enum]                                                                                     VARCHAR (255) NULL
,[TestPolicySet_text]                                                                                     VARCHAR (255) NULL
,[TestPolicySet2_text]                                                                                     VARCHAR (255) NULL
,[TestPolicySet2_enum]                                                                                     VARCHAR (255) NULL
,[UnderwritingAgentComments]                                                                                VARCHAR (255) NULL
,[UnderwritingRejectionComments]                                                                            VARCHAR (255) NULL
,[UnderwritingRejectionReasonType_text]                                                                     VARCHAR (255) NULL
,[UnderwritingRejectionReasonType_enum]                                                                     VARCHAR (255) NULL
,[UnderwritingUnderwriterCommentstoBroker]                                                                 VARCHAR (255) NULL
,[xxxTotalTerrorismCalculatedPremiumtemp]                                                                 VARCHAR (255) NULL
,[Parent_Object_ID]                                                                                         BIGINT NULL
,[CreatedDate]                                                                                             DATETIME CONSTRAINT [DF_DragonQuotePolicyTransactionPolicy_CreatedDate] DEFAULT (GETDATE()) NOT NULL
,[CreatedUser]                                                                                             VARCHAR (100) CONSTRAINT [DF_DragonQuotePolicyTransactionPolicy_CreatedUser] DEFAULT (USER_NAME()) NOT NULL
,[Rowversion]                                                                                             ROWVERSION NOT NULL,
CONSTRAINT [PK_DragonQuotePolicyTransactionPolicy] PRIMARY KEY ([Job_ID], [Object_ID]),
);

GO

CREATE NONCLUSTERED INDEX [IX_DragonQuotePolicyTransactionPolicy_PolicyProductDefinitionID_text]
ON [dbo].[DragonQuotePolicyTransactionPolicy]([PolicyProductDefinitionID_text] ASC)
INCLUDE([Object_ID], [PolicyDateEffective], [PolicyDateExpiration], [PolicyTransactionEffectiveDate], [Job_ID]);

GO

CREATE INDEX [IX_DragonQuotePolicyTransactionPolicy_Object_ID]
ON [dbo].[DragonQuotePolicyTransactionPolicy] ([Object_ID])

GO

CREATE INDEX [IX_DragonQuotePolicyTransactionPolicy_MailingAddress]
ON [dbo].[DragonQuotePolicyTransactionPolicy] (ReferenceMailingAddressIncludedLocationAddressAddressLine1, ReferenceMailingAddressIncludedLocationAddressAddressCity, ReferenceMailingAddressIncludedLocationAddressAddressLine2, ReferenceMailingAddressIncludedLocationAddressAddressState_text, ReferenceMailingAddressIncludedLocationAddressAddressPostCode)

GO

CREATE INDEX [IX_DragonQuotePolicyTransactionPolicy_BillingAddress]
ON [dbo].[DragonQuotePolicyTransactionPolicy] (ReferenceBillingAddressIncludedLocationAddressAddressLine1, ReferenceBillingAddressIncludedLocationAddressAddressCity, ReferenceBillingAddressIncludedLocationAddressAddressLine2, ReferenceBillingAddressIncludedLocationAddressAddressState_text, ReferenceBillingAddressIncludedLocationAddressAddressPostCode)

GO

CREATE INDEX [IX_DragonQuotePolicyTransactionPolicy_RateBookFilingID]
ON [dbo].[DragonQuotePolicyTransactionPolicy] (RateBookFilingID)
Posted by Microsoft on 2/25/2013 at 11:03 AM
Hey David,

We would like to look into this issue a bit deeper. Would it be possible for you to provide the source for this table so we can see if we get a definitive repro on our side? You can email the source to me at admahood at microsoft dot com.

Thanks,
Adam Mahood
Program Manager
SQL Server Database Systems
Sign in to post a workaround.