Trello

This will create a table named “trello_card". These are fields found on a Trello card.

Column

Description

Example Data

Column

Description

Example Data

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