USP_DATAFORMTEMPLATE_VIEW_ADDRESSDETAIL

The load procedure used by the view dataform template "Address Detail View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@COUNTRYID	uniqueidentifier	INOUT	Country ID
@COUNTYCODE	nvarchar(200)	INOUT	County
@REGIONCODE	nvarchar(200)	INOUT	Region
@DPC	nvarchar(8)	INOUT	DPC
@CART	nvarchar(10)	INOUT	CART
@LOT	nvarchar(5)	INOUT	LOT
@CONGRESSIONALDISTRICTCODE	nvarchar(200)	INOUT	Congressional district
@STATEHOUSEDISTRICTCODE	nvarchar(200)	INOUT	State house district
@STATESENATEDISTRICTCODE	nvarchar(200)	INOUT	State senate district
@LOCALPRECINCTCODE	nvarchar(200)	INOUT	Local precinct
@OMITFROMVALIDATION	bit	INOUT	Omit from validation
@LASTVALIDATIONATTEMPTDATE	datetime	INOUT	Last attempt
@VALIDATIONMESSAGE	nvarchar(200)	INOUT	Validation message
@NCOALASTSUBMITDATE	datetime	INOUT	Last submit date
@NCOAMOVEDATE	UDT_FUZZYDATE	INOUT	Move date
@NCOADMASUPPRESSION	bit	INOUT	DMA suppression
@NCOARETURN	nvarchar(150)	INOUT	Return code
@NCOADPVFOOTNOTE	nvarchar(150)	INOUT	DPV footnote
@NCOAFOOTNOTE	nvarchar(150)	INOUT	Footnote
@NCOAMAILGRADE	nvarchar(150)	INOUT	Mail grade

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ADDRESSDETAIL
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @COUNTRYID uniqueidentifier = null output,
  @COUNTYCODE nvarchar(200) = null output,
  @REGIONCODE nvarchar(200) = null output,
  @DPC nvarchar(8) = null output,
  @CART nvarchar(10) = null output,
  @LOT nvarchar(5) = null output,
  @CONGRESSIONALDISTRICTCODE nvarchar(200) = null output,
  @STATEHOUSEDISTRICTCODE nvarchar(200) = null output,
  @STATESENATEDISTRICTCODE nvarchar(200) = null output,
  @LOCALPRECINCTCODE nvarchar(200) = null output,
  @OMITFROMVALIDATION bit = null output,
  @LASTVALIDATIONATTEMPTDATE datetime = null output,
  @VALIDATIONMESSAGE nvarchar(200) = null output,
  @NCOALASTSUBMITDATE datetime = null output,
  @NCOAMOVEDATE UDT_FUZZYDATE = null output,
  @NCOADMASUPPRESSION bit = null output,
  @NCOARETURN nvarchar(150) = null output,
  @NCOADPVFOOTNOTE nvarchar(150) = null output,
  @NCOAFOOTNOTE nvarchar(150) = null output,
  @NCOAMAILGRADE nvarchar(150) = null output
) as
  set nocount on;

  set @DATALOADED = 0;

  select
    @DATALOADED = 1,
    @COUNTRYID = ADDRESS.COUNTRYID,
    @COUNTYCODE = dbo.UFN_COUNTYCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.COUNTYCODEID),
    @REGIONCODE = dbo.UFN_REGIONCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.REGIONCODEID),
    @DPC = ADDRESS.DPC,
    @CART = ADDRESS.CART,
    @LOT = ADDRESS.LOT,
    @CONGRESSIONALDISTRICTCODE = dbo.UFN_CONGRESSIONALDISTRICTCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.CONGRESSIONALDISTRICTCODEID),
    @STATEHOUSEDISTRICTCODE = dbo.UFN_STATEHOUSEDISTRICTCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.STATEHOUSEDISTRICTCODEID),
    @STATESENATEDISTRICTCODE = dbo.UFN_STATESENATEDISTRICTCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.STATESENATEDISTRICTCODEID),
    @LOCALPRECINCTCODE = dbo.UFN_LOCALPRECINCTCODE_GETDESCRIPTION(ADDRESSVALIDATIONUPDATE.LOCALPRECINCTCODEID),
    @OMITFROMVALIDATION = ADDRESSVALIDATIONUPDATE.OMITFROMVALIDATION,
    @LASTVALIDATIONATTEMPTDATE = ADDRESSVALIDATIONUPDATE.LASTVALIDATIONATTEMPTDATE,
    @VALIDATIONMESSAGE = ADDRESSVALIDATIONUPDATE.VALIDATIONMESSAGE,
    @NCOALASTSUBMITDATE = ADDRESSVALIDATIONUPDATE.NCOALASTSUBMITDATE,
    @NCOAMOVEDATE = ADDRESSVALIDATIONUPDATE.NCOAMOVEDATE,
    @NCOADMASUPPRESSION = ADDRESSVALIDATIONUPDATE.NCOADMASUPPRESSION,
    @NCOARETURN = ADDRESSVALIDATIONUPDATE.NCOARETURN,
    @NCOADPVFOOTNOTE = ADDRESSVALIDATIONUPDATE.NCOADPVFOOTNOTE,
    @NCOAFOOTNOTE = ADDRESSVALIDATIONUPDATE.NCOAFOOTNOTE,
    @NCOAMAILGRADE = ADDRESSVALIDATIONUPDATE.NCOAMAILGRADE
  from
    dbo.ADDRESS
  left join
    dbo.ADDRESSVALIDATIONUPDATE on ADDRESSVALIDATIONUPDATE.ID = ADDRESS.ID
  where 
    ADDRESS.ID = @ID;

return 0;