USP_REGISTRANTBATCH_LOAD

CREATE procedure dbo.USP_REGISTRANTBATCH_LOAD
(
  @ID uniqueidentifier
)
as

    set nocount on;

    select
     ID, BATCHID, REGISTRANTROLECODE, EVENTID, SEQUENCE, USERID, PASSWORD, FIRSTNAME, LASTNAME, EMAILADDRESS, ADDRESSTYPECODEID,
      COUNTRYID, ADDRESS, CITY, STATEID, POSTCODE, MIDDLENAME, TITLECODEID, SUFFIXCODEID, NICKNAME, MAIDENNAME, BIRTHDATE,
      GENDERCODE, MARITALSTATUSCODEID, PHONETYPECODEID, PHONENUMBER, DONOTMAIL, DONOTMAILREASONCODEID, FUNDRAISINGGROUPNAME, TEAMFUNDRAISINGTEAMID,
      SAVETRIBUTEEASCONSTITUENT, TRIBUTEEFIRSTNAME, TRIBUTEELASTNAME, TRIBUTEEEMAIL, TRIBUTEEADDRESS, TRIBUTEECITY, TRIBUTEEPOSTCODE,
      TRIBUTEESTATEID, TRIBUTETYPECODEID, TRIBUTETEXT, TRIBUTEANONYMOUS, SAVEASDEFAULTTRIBUTEE, SENDTOACKNOWLEDGEE,
      ACKNOWLEDGEEFIRSTNAME, ACKNOWLEDGEELASTNAME, ACKNOWLEDGEEEMAIL, MESSAGETOACKNOWLEDGEE, 

      PARTICIPANTPAGEURL, TEAMPAGEURL, COMPANYPAGEURL, HOUSEHOLDPAGEURL, REGISTRATIONOPTIONID, WAIVERACCEPTED, 

      FUNDRAISINGGOAL, TARGETFUNDRAISINGGOAL, PARTICIPANTGOAL, (DONORRETENTIONGOAL*100) as DONORRETENTIONGOAL, COMMUNICATIONGOAL, 
      TEAMFUNDRAISINGGOAL, TEAMMEMBERGOAL, (TEAMMEMBERRETENTIONGOAL*100) as TEAMMEMBERRETENTIONGOAL, TEAMCOMMUNICATIONGOAL, TEAMPARTICIPANTGOAL,
      COFUNDRAISINGGOAL, COTEAMSGOAL, (COTEAMRETENTIONGOAL*100) as COTEAMRETENTIONGOAL, COMEMBERGOAL, (COMEMBERRETENTIONGOAL*100) as COMEMBERRETENTIONGOAL, COPARTICIPANTGOAL, COCOMMUNICATIONGOAL,
      HOFUNDRAISINGGOAL, HOTARGETFUNDRAISINGGOAL, HOPARTICIPANTGOAL, (HODONORRETENTIONGOAL*100) as HODONORRETENTIONGOAL, HOCOMMUNICATIONGOAL,

      ADDITIONALDONATIONAMOUNT, PAYMENTMETHODCODE, CREDITCARDHOLDER,
      CREDITCARDNUMBER, CREDITCARDTYPE, EXPIRATIONDATE, CHECKDATE, CHECKNUMBER, BANKACCOUNTTYPECODE, BANKACCOUNTHOLDER, BANKACCOUNTNUMBER, 
      BANKACCOUNTROUTINGCODE, SAMEASPRIMARYADDRESS,
      BILLING_COUNTRYID, BILLING_ADDRESSBLOCK, BILLING_CITY, BILLING_STATEID, BILLING_POSTCODE,
        ISORGANIZATION, ORGANIZATIONID, ORGANIZATION_NAME, ORGANIZATION_WEBADDRESS, ORGANIZATION_ADDRESSTYPECODEID, ORGANIZATION_COUNTRYID,
        ORGANIZATION_ADDRESSBLOCK, ORGANIZATION_CITY, ORGANIZATION_STATEID, ORGANIZATION_POSTCODE, ORGANIZATION_DONOTMAIL, ORGANIZATION_DONOTMAILREASONCODEID,
      ORGANIZATION_PHONETYPECODEID, ORGANIZATION_NUMBER, ORGANIZATION_EMAILADDRESS,
      ORIGINALCLIENTUSERID, ORIGINALCONSTITUENTID, PHONEID, ADDRESSID, EMAILADDRESSID

   from REGISTRANTBATCH (nolock)
  where ID = @ID