Client Data Source

AccountInfoId

Number

This is the unique identifier to the company account to which the client belongs. This is a common field across all tables in the DWH

ClientID

Number

This is the unique client ID automatically assigned by Rethink system when the client is initially created. It is also used to join this table with all child tables such as ClientAssessment, CientFunders, ClientContacts, etc. This is also unique in the system across all accounts and clients.

FirstName

String

First Name of the client

LastName

String

Last Name of the client

FullName

String

Full Name of the client

MiddleName

String

Middle Name of the client

DateOfBirth

Date

Client Date of Birth

Gender

String

Gender of the client.

Status

String

The account specific status assigned to the client. For example, if there is an account status called “onboarding”, and it is assigned to the client, it will show here.

Address

String

Address Line 1 of the client

State

String

Address State of the client

City

String

Address City of the client

Zip Code

String

Address Zip Code of the client

CompanyClientID

String

A placeholder in the system allowing company accounts to add their own internal client ID. This can be manipulated by the company account; therefore, there is no unique constraint defined.

Facility

String

The facility/location to which the client is assigned.

ServiceIntensity

String

Whether or not the client is assigned intensive service or not. This has implications for the number of clinical programs that can be assigned to the client.

Notes

String

A free text field on Rethink UI that captures any notes related to this client.

HasAggressiveBehavior

String

A flag indicating whether or the client has aggressive behavior

AccountLogin

String

This is a technical field for INTERNAL Rethink use. Please ignore

UCI No

String

A placeholder that captures the UCI number, used mainly by California providers

ClientOrder

Number

[NEED DESCRIPTION]

NoticeOfPrivacy

Date

[Date of Privacy Notice]

KareoPatientID

String

When the client is synced to Kareo for the first time, the Kareo ID assigned to this client is saved here for future integrations.

ReasonForReferral

String

[Text field indicating reason for referral]

IsActiveClient

String

[CHECK - DOES NOT APPEAR TO BE THE CORRECT FIELD NAME] A flag indicating whether the status assigned to the client is an active or inactive

FullStatus

String

A full status combining the user-defined status with the flag indicating whether the client is active or inactive

ShowClinical

A flag indicating whether or not the clinical feature is turned on for this client

ShowScheduling

String

A flag indicating whether or not the scheduling feature is turned on for this client

IsDemo

String

A flag indicating whether or not the client is a demo client (used for training purposes only)

AccountInfoId

Number

This is the unique identifier to the company account to which the client belongs. This is a common field across all tables in the DWH

ClientContactID

Number

This is the unique client contact ID automatically assigned by Rethink system when the contact is initially created.

ClientID

Number

This is the client ID to which this guardian is related.

FirstName

String

Parent/Guardian First Name

LastName

String

Parent/Guardian Last Name

ContactRelationShip

String

Relationship with the child/client.

Phone

String

Phone number of the parent

Phone2

String

2nd phone number

Phone3

String

3rd phone number

Email

String

Email of the parent

Address

String

Address Line of the parent

City

String

Address City

State

String

Address State

ZipCode

String

Address Zip Code

TimeZone

String

Which time zone the parent lives in. This will impact the calendar they will see when this parent logs into Rethink

IsInvited

String

This is a flag indicating whether this parent is invited to create a Rethink login

AccountLogin

String

For Internal Use by Rethink

VerificationCode

Number

A code that will be sent to the parent to verify during the signup process.

ContactUsername

String

If the parent has completed the registration process, this is the username entered during the process.

IsRegisteredTW

String

A flag showing whether this parent/guardian is invited to TheraWe portal

AccountInfoId

Number

This is the unique identifier to the company account to which the client belongs. This is a common field across all tables in the DWH

ClientStaffMappingID

Number

Auto-generated primary key for this relationship between client and staff

ClientID

Number

Client ID of the client in this relationship record

StaffID

Number

Staff ID of the client in this relationship record

IsSubstitute

String

A flag indicating whether or not the staff assigned to the client based on this record is a substitute

AccountLogin

String

For Internal Use by Rethink

AccountInfoId

Number

This is the unique identifier to the company account to which the client belongs. This is a common field across all tables in the DWH

ClientFunderID

Number

Auto-generated primary key for this funder policy record

ServiceLineID

Number

Each Funder policy can cover one or more service lines. This field is a reference to the service line this funder policy covers.

ClientID

Number

A reference to the client ID to which this policy belongs

Funder Sequence

String

A field that shows if this policy record is for primary, secondary, or tertiary funder

Funder Name

String

Name of the funder (e.g., insurance company name) under which this policy is created

ServiceLine

String

Name of the service line (e.g., ABA, Speech) covered by this policy

Plan Name

String

Name of the funder plan under which this policy is created

AuthorizedReleaseofInfo

String

A flag indicating whether there’s a signature on file or not for Authorized Release of Information

AuthorizationDate

Date

Authorization Date added to the Client Funder

CaseManager

String

Case Manager assigned to the Client Policy

ClientMedicalRecordNo

String

Client’s Medical Record Number in the Policy

AuthorizedPayment

String

A flag indicating whether there’s signature on file or not for Authorized Payment

RelationshipToInsured

String

Relationship of the client to the person covered under the insurance policy

InsuredFirstName

String

First Name of the person covered under insurance policy

InsuredLastName

String

Last Name of the person covered under insurance policy

InsuredAddress

String

Street Address of the person covered under insurance policy

InsuredCity

String

City of the person covered under insurance policy

InsuredState

String

State of the person covered under insurance policy

InsuredZipCode

String

Zip Code of the person covered under insurance policy

InsuredPhone

String

Contact Number of the person covered under insurance policy

InsuredEmail

String

Email of the person covered under insurance policy

InsuredDateOfBirth

Date

Date of Birth of the person covered under insurance policy

InsuredGender

String

Gender of the person covered under insurance policy

InsuredMaritalStatus

String

Marital Status of the person covered under insurance policy

InsuredIDNo

String

Insurance ID assigned to the policy holder

PolicyStartDate

Date

Start Date of the insurance policy

PolicyEndDate

Date

End Date of the insurance policy

PolicyGroup

String

Alphanumeric identifier assigned to a patient claiming work-related condition(s)

Employer

String

Name of the Employer

IndividualDeductible

Number

Amount of Insurance deductible to be paid by the policy holder

FamilyDeductible

Number

Amount of Family deductible to be paid by the policy holder

IndividualMaxOOP

Number

Amount of Individual Maximum out of the pocket to be paid by policy holder for covered services in a plan year

FamilyMaxOOP

Number

Amount of Family Maximum out of the pocket to be paid by policy holder for covered services in a plan year

Copay

Number

Amount of copayment required by insurance policy

Coinsurance

Number

Percentage of cost covered by the insurance policy

AccountLogin

String

For Internal Use by Rethink

AccountInfoID

Number

This is the unique identifier to the company account to which the client belongs. This is a common field across all tables in the DWH

ClientAuthorizationID

Number

A unique identifier associated to the client authorization record.

ServiceID

Number

A unique identifier associated to the service added to the authorization

ClientID

Number

A unique identifier assigned to the client

AuthorizationReceived

String

A flag indicating whether or not the Authorization has been received from the Funder

Funder

String

Funder associated to the client authorization record

ServiceLine

String

Service Line associated to the client authorization

AuthorizationNo

String

Authorization Number attached to the client authorization

StartDate

Date

Start Date of the authorization

EndDate

Date

End Date of the authorization

Status

String

Status of the authorization i.e. Active or Expired

DiagnosisCode

String

Diagnosis Code assigned to the authorization

RenderingProvider

String

Rendering Provider assigned to the authorization

BillingCode

String

Service Code/ Billing Code assigned to the authorization

ServiceName

String

Name of the Service associated to the billing code

UnitType

String

Unit Type assigned to the service added in the authorization

AuthorizedNumberOfUnits

Number

Number of units authorized for a service added to the authorization

FrequencyType

String

Frequency of the units allocated to the service

SchedulingGoal

Number

Scheduling goal of units authorized for a service added to the authorization

FrequencySchedulingGoal

String

Frequency of scheduling goal of the units authorized for a service added to the authorization

AccountLogin

String

For Internal Use by Rethink

BillingCodeID

Number

A unique internal identifier assigned to the Billing Code added to the authorization

ServiceDescription

String

Service Description associated to the Service added to the authorization

AccountInfoID

Number

This is the unique identifier to the company account to which the staff member belongs. This is a common field across all tables in the DWH

ClientAvailabilityID

Number

This is a unique ID assigned by Rethink System to identify an Availability record.

ClientID

This is the unique client ID automatically assigned by Rethink system when the client is initially created. It is also used to join this table with all child tables such as ClientAssessment, ClientFunders, ClientContacts, etc. This is also unique in the system across all accounts and clients.

AvailableDayofWeek

String

Day of the Week the Client is Available

StartTime

String

Availability Start Time for the Day

EndTime

String

Availability End Time for the Day

AccountLogin

String

For Internal Use of Rethink

AvailableMin

Number

Minutes the Client is available based on the Start and End Time added to each unique availability record.

AvailableHours

Number

Hours the Client is available based on the Start and End Time added to each unique availability record.

AccountInfoID

Number

This is the unique identifier to the company account to which the Client member belongs. This is a common field across all tables in the DWH

ClientNoteID

Number

This is a unique ID assigned to the Note record.

ClientID

Number

This is the unique client ID automatically assigned by Rethink system when the client is initially created. It is also used to join this table with all child tables such as ClientAssessment, ClientFunders, ClientContacts, etc. This is also unique in the system across all accounts and clients.

NoteType

String

Note Type assigned to the Note

Title

String

Title of the Note

IsPrivate

String

A flag indicating whether the Note is Private

Notes

String

Text / Information added to the Note

CreatedBy

String

Name of the Staff Member that created the Note.

CreatedOn

Date

Creation Date of the Note

LastUpdatedBy

String

Name of the Staff Member who last updated the Note.

LastUpdatedOn

Date

Last Updated Date of the Note

DeletedBy

String

Name of the Staff Member who deleted the Note

DeletedOn

Date

Date when the Note was deleted

AccountLogin

String

This is a technical field for INTERNAL Rethink use. Please ignore