USP_DATALIST_NETCOMMUNITYDEFAULTCODEMAP

CREATE procedure dbo.USP_DATALIST_NETCOMMUNITYDEFAULTCODEMAP
as
    set nocount on;

  select top 1
      [BUSINESSPHONECODEID]
      ,[FAXPHONECODEID]
      ,[RELATIONSHIPTYPECODEID]
      ,[PRIMARYBUSINESSRELATIONSHIPTYPECODEID]
      ,[PRIMARYBUSINESSRECIPROCALTYPECODEID]
      ,[BUSINESSADDRESSTYPECODEID]
      ,[MGCONDITIONTYPECODEID]
      ,[REVENUENOTETYPECODEID]
      ,[CONSTITUENTLINKPAGEID]
      ,[CONTACTTYPECODEID]
      ,[SPOUSEREMOVEDRELATIONSHIPTYPECODEID]
      ,[PRIMARYADDRESSTYPECODEID]
      ,[ORGANIZATIONPRIMARYADDRESSTYPECODEID]
      ,[CHANNELCODEID]
      ,[MGALIASTYPECODEID]
      ,[AUTOMATCHUSELASTNAME]
      ,[AUTOMATCHUSEFIRSTNAME]
      ,[AUTOMATCHUSEMAIDENNAME]
      ,[AUTOMATCHUSEBIRTHDATE]
      ,[AUTOMATCHUSEGENDER]
      ,[AUTOMATCHEXACTMATCHONLY]
      ,[AUTOMATCHINCLUDEINACTIVE]
      ,[AUTOMATCHINCLUDEDECEASED]
      ,[AUTOMATCHUSEMIDDLENAME]
      ,[AUTOMATCHUSEADDRESS]
      ,[AUTOMATCHUSECITY]
      ,[AUTOMATCHUSECOUNTRY]
      ,[AUTOMATCHUSECOUNTY]
      ,[AUTOMATCHUSENZCITY]
      ,[AUTOMATCHUSENZSUBURB]
      ,[AUTOMATCHUSESTATE]
      ,[AUTOMATCHUSEZIP]
      ,[AUTOMATCHUSEPHONE]
      ,[AUTOMATCHUSELOOKUPID]
      ,[DONOTEMAILSOLICITCODEID]
      ,[INFOSOURCECODEID]
      ,[FORMERADDRESSTYPECODEID]      
      ,dbo.UFN_ADDRESSTYPECODE_GETDESCRIPTION([FORMERADDRESSTYPECODEID]) as FORMERADDRESSTYPE
      ,[EMAILADDRESSTYPECODEID] 
      ,[AUTOMATCHUSESUFFIX]
      ,[DONOTEMAILCONSENTSOLICITCODEID]
      ,[DATAPROTECTIONEVIDENCESOURCECODEID]
  from [dbo].[NETCOMMUNITYDEFAULTCODEMAP]