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

Possible Values:

• Prospects

• Quote Delivered

• Gathering Requirements

• Building

• Testing

• Ready to Launch

• Iterating

• Maintenance

• Completed

• Lost

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