Page Comparison

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

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.