Note: This content is automatically generated by the ETL tool. Last build time is 2024-03-19 13:44:37. Please contact MWS Insights Data Infrastructure for the query.

PartnerMapSpecEnroll

Data source: GPSMart

SELECT
pm.PartnerOneId,
pm.PartnerOneName,
p.PartnerID,
p.PartnerName,
p.VOrgPartnerID,
p.VOrgPartnerName,
ase.PartnerGlobalID,
ase.Area,
ase.Program,
ase.AnniversaryDate,
ase.EnrollmentDate,
ase.EnrollmentStatus,
ase.ClubbedEnrollmentStatus,
ase.VorgProg,
ase.PartnerGlobalProg,
ase.HighestClubbedEnrollmentStatus
FROM [partner].[vw_MapSpecEnroll] ase
INNER JOIN [partner].[vw_Dim_Partner] p on p.vorgpartnerid = ase.vorgpartnerid
INNER JOIN [pm].[vw_Dim_PartnerOne] AS pm on pm.PartnerOneKey = p.PartnerOneKey