Clinical Data Source
- Safwat Eleish (Unlicensed)
ER Diagram
Main Tables
ClientBehavior
Database Table - Field | Type | Description | |
|---|---|---|---|
| 1 | AccountInfoID | Number | Unique ID for the provider account |
| 2 | BehaviorID | Number | Unique ID for the behavior program |
| 3 | ClientID | Number | Unique ID for the client profile |
| 4 | BehaviorName | String | Name of the behavior program |
| 5 | BehaviorDefinition | String | Definition String for behavior |
| 6 | BehaviorWillChange | String | A text will show if the behavior will increase or decrease |
| 7 | DataCollectionMethod | String | Method of data collection (e.g Opportunity Based, Duration, Task Analysis, etc.) |
| 8 | WhereWhen |
|
|
| 9 | Goal | String |
|
| 10 | TrackingProgress | String |
|
| 11 | GoalDirection | String |
|
| 12 | GoalTo | String |
|
| 13 | GoalNoOfSessions | Number |
|
| 14 | GoalConsecutiveType | String |
|
| 15 | IsBehaviorArchived | String |
|
| 16 | BehaviorDateMastered | Date |
|
| 17 | BehaviorDateDeleted | Date |
|
| 18 | AccountLogin | String |
|
ClientBehaviorPlans
Database Table - Field | Type | Description |
|---|---|---|
AccountInfoID | Number |
|
BehaviorID | Number |
|
BehaviorPlanID | Number |
|
IsPlanBaseline | String |
|
BehaviorPlanName | String |
|
BehaviorPlanStartDate | Date |
|
BehaviorPlanCreated | Date |
|
BaselineBegan | Date |
|
BaselineEnded | Date |
|
BaselineSummaryToDate | String |
|
RawData | Number |
|
GoalFrom |
|
|
AccountLogin |
|
|
ClientBehaviorPlanClinicalData
Database Table - Field | Type | Description |
|---|---|---|
AccountInfoID | Number |
|
ClientBehaviorPlanClinicalDataID | Number | The primary key of this table. Unique ID for this data point (trialset) |
BehaviorPlanID | Number | A reference to the behavior plan this data point is connected to |
AppointmentID | Number | If the data point is linked to an appointment, this would be the appointment ID |
ObjectiveSeq | Number | The objective sequence # this data point is connected to |
ObjectiveName | String | Name of the objective this data point is connected to |
TargetName | String | Name of the target this data point is connected to |
DateCreated | Datetime | Datetime timestamp of when this data point was created |
DateDeleted | Datetime | if this data point is deleted, this field will have a value of when it is deleted |
Date | Datetime | This will be the date of the data point. It can be different than the datecreated if the user backdates this data point manually |
CollectedBy | String | User who added this data point |
Notes | String | If the user added a note with the data point, this will be the field that holds the note |
NoOfCorrectOpBased | Number | If the behavior program is an opportunity based program, this will capture the number of correct opportunities |
NoOfIncorrectOpBased | Number | If the behavior program is an opportunity based program, this will capture the number of incorrect opportunities |
PercentageCorrectOpBased | Number | This is a calculated field based on the number of correct opportunities against all opportunities |
NoOfTimesOccurredFr | Number |
|
NoOfHoursObservedFrDur | Number |
|
NoOfMinOccurredDur | Number |
|
NoOfIntervalsOccurredInt | Number |
|
NoOfIntervalsObservedInt | Number |
|
PercentageOfIntervalsInt | Number |
|
AccountLogin | String |
|
DateLastModified | Datetime |
|