Trello

id

The ID card

63344d98ffc83a02eddba453

card_name

The name of the card

Trello-ETL-Test

study_id

Custom Fields → Study ID

33

instance

What instance is the study on

Possible value: CORE or LGH

card_column

The column the card is found on the OPS board

Prospects

members

Comma separated list of users on this card

Me, you, us, them, everyone

stalled

Label available on the card.

Possible values: Yes or No

analysis

Label available on the card.

Possible values: Yes or No

research

Label available on the card.

Possible values: Yes or No

clinical

Label available on the card.

Possible values: Yes or No

on_website

Label available on the card.

Possible values: Yes or No

billing_complete

Label available on the card.

Possible values: Yes or No

coredev

Label available on the card.

Possible values: Yes or No

not_on_website

Label available on the card.

Possible values: Yes or No

project_manager

Comma separated list of project managers. Found under card Description.

Jack, Jill

w2h_features

?????

two_way_texting

List item found under W2H Features.

Possible values: Yes or No

ivr

List item found under W2H Features.

Possible values: Yes or No

email

List item found under W2H Features.

Possible values: Yes or No

patient_portal_messaging

List item found under W2H Features.

Possible values: Yes or No

schedule_based_messaging

List item found under W2H Features.

Possible values: Yes or No

criteria_based_rules

List item found under W2H Features.

Possible values: Yes or No

survey_administration

List item found under W2H Features.

Possible values: Yes or No

ehr_integration

List item found under W2H Features.

Possible values: Yes or No

photo_messaging

List item found under W2H Features.

Possible values: Yes or No

multiple_languages

List item found under W2H Features.

Possible values: Yes or No

dashboard_view

List item found under W2H Features.

Possible values: Yes or No

remote_patient_monitoring

List item found under W2H Features.

Possible values: Yes or No

device_integration

List item found under W2H Features.

Possible values: Yes or No

patient_reported_outcomes_capture

List item found under W2H Features.

Possible values: Yes or No

gamification

List item found under W2H Features.

Possible values: Yes or No

incentives

List item found under W2H Features.

Possible values: Yes or No

econsent

List item found under W2H Features.

Possible values: Yes or No

enrollment

List item found under W2H Features.

Possible values: Yes or No

arms_and_randomization

List item found under W2H Features.

Possible values: Yes or No

pi_clinical_lead

Custom Fields → PI/Clinical Lead

Sally Somewheres

device_integrations

Custom Fields → Device Integrations

Can be one of:

• blank

• Fitbit

• Withings

• Omron

• TrueMotion

• Hidrate Spark

• AdhereTech

• Propeller

• Wisepill

• Custom Data Source

ehr_integrations

Custom Fields → EHR Integrations

Can be one of:

• blank

• API

• Clarity

• HL7

• RWB

• PennChart X

• Switchboard

start_date

Custom Fields → Start Date

2022-09-19T16:00:00.000Z

effort

Custom Fields → Effort

Can be one of:

• blank

• Low

• Medium

• High

billing_status

Custom Fields → Billing Status

Can be one of:

• blank

• Ready to Bill

• Actively Billing

• Billing Complete

• No Fee

• Included in Dept Projects

• On Hold

• Query End of Project

one_time_fees

Custom Fields → One-Time Fees

13,788

recurring_fees_monthly

Custom Fields → Recurring Fees (Monthly)

922

contract_terms_months

Custom Fields → Contract Term (Months)

11

internal_affiliate

Custom Fields → Internal Affiliate

Bob Barker

external_institution

Custom Fields → External Institution

The Price Is Right