Livoa LogoLivoa
VYEPTI_CUSTOMER_INFO_VIEW


LUNDBECK_ID PK

COMPANY

HCP_SEGMENT

HCP_FIRST_NAME

HCP_LAST_NAME

HCP_ADDRESS

CUSTOMER_PHONE

CUSTOMER_STATUS

LU_NO_CONTACT_FLAG

PDRP_IND

HYPERFOCUSED_TARGET

MY_TARGET

NEW_VYEPTI_WRITER_LAST_60_DAYS

VYEPTI_EXCLUSION_IND

SPECIALTY_GROUP

SPECIALTY

HCP_TERRITORY_ID

HCP_TERRITORY_NAME

REP_EMAIL_ADDRESS

REP_ID

REP_FIRST_NAME

REP_LAST_NAME

MGR_REP_ID

MGR_FIRST_NAME

MGR_LAST_NAME

REGION_NAME

CALL_PLAN_START

CALL_PLAN_END

AREA_ID

VYEPTI_CALL_HISTORY_VIEW


CALL_ID PK

CALL_DATE

LUNDBECK_ID FK

USER_ID

INTERACTION_TYPE

PRODUCT_GROUP_NAME

KM_1

KM_2

KM_3

SUB_TAB_1

SUB_TAB_2

SUB_TAB_3

VYEPTI_CLAIM_HISTORY_VIEW


INFUSION_DATE_KEY

LUNDBECK_ID FK

MAIN_SOURCE

SOURCE_TYPE

REFERRAL_DATE_KEY

PRODUCT_NAME

PRIMARY_PAYMENT_TYPE

PRIMARY_PAYER_NAME

TRX

QTY_DISPENSED

NEW_PATIENT_FLAG

NEW_WRITER_FLAG

VYEPTI_VIN_SP_HISTORY_VIEW


INFUSION_DATE_KEY

LUNDBECK_ID FK

MAIN_SOURCE

SOURCE_TYPE

REFERRAL_DATE_KEY

PRODUCT_NAME

PRIMARY_PAYMENT_TYPE

PRIMARY_PAYER_NAME

TRX

VYEPTI_EMAIL_ENGAGEMENT_VIEW


LUNDBECK_ID FK

USER_ID

EMAIL_SENT_DATE

EMAIL_TEMPLATE_NAME

STATUS

TOTAL_OPENS

TOTAL_CLICKS

VYEPTI_HCO_CGRP_TRX_VIEW


DATE_KEY

ACCOUNT_NAME

ACCOUNT_LUNDBECK_ID FK

TERRITORY_ID

PRODUCT_GROUP_NAME

SITE_OF_CARE

TRX

VYEPTI_UPCOMING_VISITS_VIEW


LUNDBECK_ID FK

USER_ID

ACCOUNT_TYPE

CUSTOMER_TYPE

CUSTOMER_NAME

CUSTOMER_ADDRESS

CALL_DATETIME

TERRITORY_ID

PRODUCT_GROUP_NAME

INTERACTION_TYPE

ER FCA

by Akhil

0
0 uses