add a constituent name table to the BBDW

I would like to request a new table DM_CNST_ALL_NM in BBDW in the future release. We have to create a customization for constituent names.

The sql for this name table should be:
SELECT
n.ID AS USR_CNST_ALL_NM_SYS_KEY,
n.CONSTITUENTID AS CONSTITUENTSYSTEMID,
t.DESCRIPTION AS USR_NM_TYP_DES,
n.PRIMARYADDRESSEE AS USR_PRMRY_ADDRSEE_IND,
n.PRIMARYSALUTATION AS USR_PRMRY_SLTTN_IND,
n.FORMATTEDNAME AS USR_CNST_NM,
n.SITEID AS SITE_SYS_ID,
1 AS ISINCLUDED
FROM dbo.NAMEFORMAT n
inner join dbo.[NAMEFORMATTYPECODE] t on n.[NAMEFORMATTYPECODEID] = t.[ID]

Thanks!
  • Guest
  • Nov 9 2015
Organization Name (Please enter full organization name)
Reported Version
  • Attach files