Staff Data Source

AccountInfoID

Number

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

StaffID

Number

This is the unique staff ID automatically assigned by Rethink system when the staff member is initially created. It is also used to join this table with all child tables such as staffAgeGroups, StaffCertifications, staffFacilities, etc. This ID is also unique in the system across all accounts and staff.

FirstName

String

First Name of the Staff Member

MiddleName

String

Middle Name of the Staff Member

LastName

String

Last Name of the Staff Member.

FullName

String

Full Name of the Staff Member.

Title

String

Title assigned to the Staff Member in their Staff Profile

AccountLogin

String

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

CompanyStaffID

String

Custom Staff ID that the Company has assigned to the Staff Member in their profile.

UserName

String

Username of the Staff Member

Status

String

Status of Staff Member

DateOfBirth

Date

Date of Birth of the Staff Member

Address

String

Address Line 1 of the Staff Member

City

String

Address City of the Staff Member

StateAbbreviation

String

State Abbreviation of the Staff Member

State

String

State (Full Name) of the Staff Member

ZipCode

Number

Zip Code of the Staff Member

TimeZone

String

Time Zone assigned to the Staff Profile

Facilities

String

Facilities/ Company Location(s) assigned to the Staff Member

EmployeeType

String

Type of Employee indicated by the Employee type field of the Staff Member

Email

String

Email of the Staff Member

NPINumber

Number

NPI of the Staff Member

TaxonomyCode

Number

Taxonomy Code of the Staff Member

Supervisor

String

Supervisor assigned to the Staff Member

ServiceLine

String

Service Line assigned to the Staff Member

Gender

String

Gender of the Staff Member

Experience

String

Experience of the Staff Member captured in their profile

StartDate

Date

Start Date/ Hire Date of the Staff Member captured in their profile

OverallExperience

Number

Current Date - Start Date + Months added in the Months field of the Staff Profile > Attributed

CanHandleAgression

String

CanHandleAgression will be set to Yes if the field is checked in the Staff Profile.

AgeGroups

String

Field that indicates age groups the staff member can work with.

LanguagesSpoken

String

Field that indicates languages the staff member can speak.

MaximumCaseload

Number

Field that indicates the maximum caseload the Staff Member can be assigned.

ShowRBT

String

A flag indicating whether the clinical feature is turned on for this staff member.

ShowScheduling

String

A flag indicating whether the scheduling feature is turned on for this staff member

Role

String

Role assigned to the Staff Member based on the Staff Member Title.

RoleDescription

String

Role Description of the Role assigned to the Staff Member.

IsActive

String

A flag indicating whether the status assigned to the Staff is an active status

RolePermissions

String

Permissions of the Staff Member based on the Role assigned to the Staff Member

DateCreated

Date

Date when the Staff Member Profile was created in the system

CreatedBy

String

Staff Name of the user that created the Staff Member Profile

DateLastModified

Date

Date when the Staff Member Profile was Last Modified

ModifiedBy

String

Staff Name of the user that last modified the Staff Member Profile

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

StaffAvailabilityID

Number

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

StaffID

This is the unique staff ID automatically assigned by Rethink system when the staff member is initially created. It is also used to join this table with all child tables such as staffAgeGroups, StaffCertifications, staffFacilities, etc. This is also unique in the system across all accounts and staff members.

AvailableDayofWeek

String

Day of the Week the Staff 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 Staff Member is available based on the Start and End Time added to each unique availability record.

AvailableHours

Number

Hours the Staff Member 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 staff belongs. This is a common field across all tables in the DWH

StaffCertificationID

Number

This is a unique Staff Certification ID automatically assigned by Rethink to the Staff Credential Record.

StaffID

Number

This is the unique staff ID automatically assigned by Rethink system when the staff is initially created. It is also used to join this table with all child tables like staffAgeGroups, StaffCertifications, staffFacilities, etc. This is also unique in the system across all accounts and staff.

LicenseCredential

String

License/ Credential added to the Licenses/ Credential(s)

CredentialType

String

Credential Type associated with the License/ Credential based on the configuration

IssueDate

Date

Issue Date added to the Staff License/ Credential

ExpiredDate

Date

Expiration Date added to the Staff License/ Credential

Status

String

Status of the Credential i.e., Active or Expired based on the Expiration Date added to the License Credential

IsDefault

String

A flag indicating if the credential is a default credential.

LicenseCertificationNo

String

License/ Credential Number associated with the Credential

Notes

String

Text added in Notes field of the License/ Credential record.

Attachment

String

File name of the file that is attached to the Credential record

AccountLogin

String

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

AccountInfoID

Number

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

StaffFileCabinetFileID

Number

This is the unique identifier for the document uploaded in the Staff File Cabinet

StaffID

Number

This is the unique staff ID automatically assigned by Rethink system when the staff member is initially created. It is also used to join this table with all child tables such as staffAgeGroups, StaffCertifications, staffFacilities, etc. This is also unique in the system across all accounts and staff.

FolderName

String

Name of the Folder the file is a part of.

FileName

String

Name of the File uploaded in the File Cabinet

FileExtension

String

Extension of the file uploaded in the Folder e.g., .pdf, .jpeg, etc.

FileAddedBy

String

Email of the User that added the File

FileSizeKB

Number

Size of the File Uploaded in KiloBytes (KB)

FileSizeMB

Number

Size of the File Uploaded in MegaBytes(MB)

FileDateCreated

Date

Date of Creation of the File

FileDateLastModified

Date

Last Modified Date of the File

FileDateDeleted

Date

Date the File was deleted

FolderCreatedBy

String

Name of the Staff Member who created the Folder that contains the file being referenced.

FolderDateCreated

Date

Creation Date of the Folder that contains the file being referenced.

FolderDateLastModified

Date

Last Modified Date of the Folder that contains the file being referenced.

FolderDateDeleted

Date

Date the Folder was deleted

FolderOrder

Number

Ranking/Order of the Folder in the Staff File Cabinet in the order it appears on Staff Member Profile > File Cabinet section

isFolderShared

String

A flag indicating if the File Cabinet folder containing the file record is marked as a Shared Folder.

FolderSharedWithMembers

String

[NEED DESCRIPTION, BUT APPEARS TO CONTAIN ONLY NULL]

AccountLogin

String

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

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

StaffNoteID

Number

This is a unique ID assigned to the Note record.

StaffID

Number

This is the unique staff ID automatically assigned by Rethink system when the staff member is initially created. It is also used to join this table with all child tables such as staffAgeGroups, StaffCertifications, staffFacilities, etc. This is also unique in the system across all accounts and staff.

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

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

StaffPayrollID

Number

This is a unique ID assigned to the Pay Code record added to the Staff Member Payroll.

StaffID

Number

This is the unique staff ID automatically assigned by Rethink system when the staff is initially created. It is also used to join this table with all child tables such as staffAgeGroups, StaffCertifications, staffFacilities, etc. This is also unique in the system across all accounts and staff.

PayCodeName

String

Full Name of the PayCode assigned to the Staff Member

PayCode

String

Abbreviated name of the PayCode assigned to the Staff Member

HourlyRate

Number

Hourly Rate assigned to the Pay Code

StartDate

Date

Start Date when the Pay Code should be applied

EndDate

Date

End Date of the Pay Code

isDefaultBillableAppointment

String

A flag indicating whether the Pay Code is set as default for Billable Appointments

isDefaultNonBillableAppointment

String

A flag indicating whether the Pay Code is set as default for Billable Appointments

isDefaultTravelAppointment

String

A flag indicating whether the Pay Code is set as default for Billable Appointments

DefaultFor

String

List of Appointment Types for which the PayCode is the default

ApplyOvertimeCalculations

String

[CHECK DESCRIPTION - USES PAYCODE TWICE] A flag indicating whether the Paycode assigned to the Staff Member should have Over Time Calculations applied in Payroll calculations.

AccountLogin

String

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