Current Opportunities Report - Data Specifications

Current Opportunities Report - Data Specification Document

File Name

Current Opportunities Report

File Accessibility

Available through the Outcomes Client Reporting Platform to authorized Client users and Pharmacy Administrators with PHI access. Field visibility varies by role.

Last Updated

11/2/2026

Data Refresh Frequency

Near Real Time

Purpose

Provide visibility into currently available CMR, TIP, and Task opportunities, including patient, program, policy, service, pharmacy, expiration, and potential revenue information.

Intended Use

Support opportunity monitoring, operational follow-up, patient and pharmacy outreach, and analysis of open work using work-item-level and client-only opportunity-level extracts.

Element Number

Element name on report

Business Definitions

Example

Role Access

1

NCPDP

NCPDP identifier for the pharmacy where the work item is available.

AA99B688ZZ

Pharmacy Administrator, Client, and Internal.

2

Pharmacy Name

Name of the pharmacy where the work item is available.

Outcomes Center

Pharmacy Administrator, Client, and Internal.

3

Member ID

Identifier for the eligible member.

OC4242

Pharmacy Administrator, Client, and Internal.

4

First Name

Patient first name.

THOMAS

Pharmacy Administrator, Client, and Internal.

5

Last Name

Patient last name.

HUNTER

Pharmacy Administrator, Client, and Internal.

6

DOB

Patient date of birth.

1/21/1966

Pharmacy Administrator, Client, and Internal.

7

Address 1

Patient primary street address.

123 ALPHA ST

Pharmacy Administrator, Client, and Internal.

8

Address 2

Additional patient address information, when applicable.

APT 67

Pharmacy Administrator, Client, and Internal.

9

City

Patient city.

YUMA

Pharmacy Administrator, Client, and Internal.

10

State

Patient state.

AZ

Pharmacy Administrator, Client, and Internal.

11

ZIP Code

Patient ZIP Code.

85365

Pharmacy Administrator, Client, and Internal.

12

Phone

Patient phone number.

555-333-1122

Pharmacy Administrator, Client, and Internal.

13

Program Name

Program associated with the opportunity.

Example Program

Pharmacy Administrator, Client, and Internal.

14

Client Name

Client associated with the opportunity.

Outcomes Health, INC.

Pharmacy Administrator and Internal. Not displayed in Client Work Item Details.

15

Policy Name

Policy associated with the opportunity.

OC - Mercury Medicare - M616

Pharmacy Administrator, Client, and Internal.

16

Primary Pharmacy

Indicates whether the pharmacy is the patient’s primary pharmacy.

FALSE

Pharmacy Administrator, Client, and Internal.

17

Percent Fill at Chain

Percentage of applicable fills associated with the pharmacy chain. Source data may be discontinued or unavailable.

0

Pharmacy Administrator and Internal.

18

Percent Fill at Center

Percentage of applicable fills associated with the pharmacy center. Source data may be discontinued or unavailable.

0

Pharmacy Administrator and Internal.

19

Opportunity Date

Date the opportunity was created or made available.

46259

Internal only.

20

Work Start Date

Date the work item became available.

46259

Pharmacy Administrator, Client, and Internal.

21

Service Type

Service associated with the opportunity.

CMR

Pharmacy Administrator, Client, and Internal.

22

Service Category

Service grouping associated with the opportunity.

CMR

Pharmacy Administrator, Client, and Internal.

23

Reason Code

Code representing the reason for the opportunity.

100

Pharmacy Administrator, Client, and Internal.

24

Reason Description

Description of the reason for the opportunity.

CMR - Complex drug therapy

Pharmacy Administrator, Client, and Internal.

25

Action Code

Code representing the recommended action.

200

Pharmacy Administrator, Client, and Internal.

26

Action Description

Description of the recommended action.

Comprehensive Medication Review

Pharmacy Administrator, Client, and Internal.

27

Opportunity Title

Title of the available opportunity.

Comprehensive Medication Review (CMR)

Pharmacy Administrator, Client, and Internal.

28

Primary Language

Patient primary language when available. Populated only for CMR opportunities.

ENG

Pharmacy Administrator and Internal; CMR only.

29

Currently Flagged for CMR?

Indicates whether the patient is currently flagged for CMR. Populated only for CMR opportunities.

Yes

Pharmacy Administrator and Internal; CMR only.

30

Patient CMR Eligibility Start Date

Date the patient became eligible for a CMR. Populated only for CMR opportunities.

46023

Pharmacy Administrator and Internal; CMR only.

31

Pharmacy CMR Eligibility Start Date

Date the pharmacy became eligible to complete the CMR. Populated only for CMR opportunities.

46023

Pharmacy Administrator and Internal; CMR only.

32

Last CMR Completed Date

Most recent date a CMR was completed for the patient.

45945

Pharmacy Administrator and Internal; CMR only.

33

Last CMR Result Date

Date of the most recent CMR result.

45945

Pharmacy Administrator and Internal; CMR only.

34

Last CMR Result Name

Name or description of the most recent CMR result.

Successful Service

Pharmacy Administrator and Internal; CMR only.

35

Last CMR Result Center NCPDP

NCPDP of the center associated with the most recent CMR result.

424242

Pharmacy Administrator and Internal; CMR only.

36

Last CMR Result Center Name

Name of the center associated with the most recent CMR result.

Semoctuo Pharmacy

Pharmacy Administrator and Internal; CMR only.

37

CMR Scheduled Date

Scheduled date for the CMR, when applicable.

11/10/2026

Pharmacy Administrator and Internal; CMR only.

38

CMR Scheduled Center NCPDP

NCPDP of the center where the CMR is scheduled.

BB99B688YY

Pharmacy Administrator and Internal; CMR only.

39

CMR Scheduled Center Name

Name of the center where the CMR is scheduled.

Semoctuo Pharmacy

Pharmacy Administrator and Internal; CMR only.

40

Pharmacy Organization Name

Name of the pharmacy organization associated with the work item.

Semoctuo

Pharmacy Administrator, Client, and Internal.

41

Chain Name

Name of the pharmacy chain associated with the work item.

Semoctuo

Pharmacy Administrator, Client, and Internal.

42

Pharmacy Organization Type

Classification of the pharmacy organization.

Network

Internal only.

43

Pharmacy NPI

National Provider Identifier for the pharmacy.

1142116711

Pharmacy Administrator, Client, and Internal.

44

Pharmacy Address 1

Primary street address of the pharmacy.

1 SUN WAY

Pharmacy Administrator, Client, and Internal.

45

Pharmacy Address 2

Additional pharmacy address information, when applicable.

SUITE 100

Pharmacy Administrator, Client, and Internal.

46

Pharmacy City

City of the pharmacy.

SAINT LOUIS

Pharmacy Administrator, Client, and Internal.

47

Pharmacy State

State of the pharmacy.

MO

Pharmacy Administrator, Client, and Internal.

48

Pharmacy ZIP

ZIP Code of the pharmacy.

63121

Pharmacy Administrator, Client, and Internal.

49

Opportunity Expiration Date

Date through which the opportunity remains available. Current opportunities have an expiration date equal to or later than today.

46387

Pharmacy Administrator, Client, and Internal.

50

Potential Service Fee Revenue

Potential service-fee revenue associated with the opportunity.

50

Pharmacy Administrator and Internal.

51

Potential Validation Revenue

Potential validation revenue associated with the opportunity.

5

Pharmacy Administrator and Internal.

52

Total Potential Revenue

Potential Service Fee Revenue plus Potential Validation Revenue.

55

Pharmacy Administrator and Internal.

53

Opportunity Create Date

Date the opportunity was created.

46260

Client only.

54

Opportunity Title

Title of the available opportunity.

Adherence - Needs 100-day Fill

Client only.

55

Primary Pharmacy NPI

NPI of the patient’s primary pharmacy.

1326141086

Client only.

56

Service Type

Service associated with the opportunity.

TIP

Client only.

57

Service Category

Service grouping associated with the opportunity.

Adherence - Needs 100-day Fill

Client only.

58

Reason Code

Code representing the opportunity reason.

200

Client only.

59

Reason Description

Description of the opportunity reason.

Adherence - Needs 100-day or 90-day fill

Client only.

60

Action Code

Code representing the recommended action.

215

Client only.

61

Action Description

Description of the recommended action.

Patient Consultation

Client only.

62

Pharmacy Count

Count of distinct pharmacies at which the opportunity is available.

3

Client only.

63

Primary NCPDP

NCPDP of the patient’s primary pharmacy.

1142116711

Client only.

64

Primary Pharmacy Name

Name of the patient’s primary pharmacy.

Semoctuo Pharmacy

Client only.

65

Primary Pharmacy Organization Type

Classification of the primary pharmacy organization.

Network

Internal only.

66

Primary Chain Name

Chain name of the patient’s primary pharmacy.

Semoctuo

Client only.

67

Primary Pharmacy Organization Name

Organization name of the patient’s primary pharmacy.

Semoctuo

Client only.

68

Opportunity Expiration Date

Date through which the opportunity remains available.

46387

Client only.

69

Flagged for CMRs

Indicates whether the member is currently flagged as needing a CMR.

TRUE

Client only.