USP_COAUPDATESUBMITPROCESS_GETPARAMETERS

CREATE procedure dbo.USP_COAUPDATESUBMITPROCESS_GETPARAMETERS
(
    @ID uniqueidentifier = null
)
as
    set nocount on;

    exec dbo.USP_GET_KEY_ACCESS;

    select
        COAUPDATE.SITEID,
        COAUPDATE.ID as COAUPDATEID,
        COAUPDATE.NAME,
        SUBMIT.IDSETREGISTERID,
        SUBMIT.INCLUDECONSTITUENTDNM,
        SUBMIT.ADDRESSINCLUDECODE,
        SUBMIT.ADDRESSTYPECODEID,
        SUBMIT.INCLUDEADDRESSESDNM,
        SUBMIT.CREATEOUTPUTIDSET,
        SUBMIT.OUTPUTIDSETNAME,
        SUBMIT.OVERWRITEOUTPUTIDSET,
        SUBMIT.OUTPUTIDSETRECORDTYPEID,
        INSTALL.INSTALLATIONNAME,
        INSTALL.SERIALNUMBER,
        COAUPDATE.PRIMARYCONTACTNAME,
        COAUPDATE.PRIMARYCONTACTEMAIL,
        COAUPDATE.PRIMARYCONTACTPHONE,
        COAUPDATE.ALTERNATECONTACTNAME,
        COAUPDATE.ALTERNATECONTACTEMAIL,
        COAUPDATE.ALTERNATECONTACTPHONE,
        COAUPDATE.BATCHID,
        COAUPDATE.BATCHAPPUSERID,
        SUBMIT.CREATENEWBATCH,
        SUBMIT.SUBMITHOUSEHOLD,
        SABOTEN.USERNAME as SABOTENUSERNAME,
        convert(nvarchar(250), DecryptByKey(SABOTEN.SECRETKEY)) as SABOTENSECRETKEY,
        INSTALL.CLARIFYSITEID,
        SABOTEN.NAICS,
        SABOTEN.ADDRESS,
        SABOTEN.CITY,
        SABOTEN.POSTCODE,
        STATE.ABBREVIATION [STATEABBREVIATION],
        TITLECODE.DESCRIPTION [PRIMARYCONTACTTITLE],
        COAUPDATE.CONTACTJOBTITLE [CONTACTJOBTITLE]
    from dbo.COAUPDATESUBMITPROCESS SUBMIT
    inner join dbo.COAUPDATE on COAUPDATE.ID = SUBMIT.COAUPDATEID
    left join dbo.[TITLECODE] on [TITLECODE].[ID] = [COAUPDATE].[PRIMARYCONTACTTITLECODEID]
    cross join dbo.INSTALLATIONINFO INSTALL
    cross join dbo.SABOTEN
    left join dbo.[STATE] on [STATE].[ID] = [SABOTEN].[STATEID]
    where SUBMIT.ID = @ID;

    close symmetric key sym_BBInfinity;