SELECT
    _ContactID AS ContactID,
    _DeviceID AS DeviceID,
    _APID AS APID,
    _Status AS Status,
    _CreatedDate AS CreatedDate,
    _ModifiedDate AS ModifiedDate,
    'MUDAR' AS BusinessUnit

FROM
    _PushAddress