Medical Necessity DS
- Safwat Eleish (Unlicensed)
Table Dictionary
Every completed assessment in Rethink will be added to the table “ClientAssessmentMedicalNecessityResults” with a status “Completed” and further details described in the below dictionary
Every question answered in the assessment process will be stored in the table “ClientAssessmentMedicalNecessityDetails” along with the details described in the below dictionary
ClientAssessmentMedicalNecessityResults
This table is used to capture the high-level medical necessity assessment information including when it was done, the final recommended hours, and any comments.
Database Table - Field | Type | Description | |
|---|---|---|---|
| 1 | 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 |
| 2 | AssessmentResponseId | Number | Id of the response |
| 3 | AssessmentID | Number | First Name of the client |
| 4 | ClientID | Number | This is the client ID to which this assessment record was performed |
| 5 | AssessmentDate | Datetime | The date and time when the assessment was performed. |
| 6 | CreatedBy | String | The staff member who filled the assessment |
| 7 | AssessmentType | String | Type of assessment, whether it is initial service authorization or service re-authorization |
| 8 | Recommendation | String |
|
| 9 | IsCurrentAssessment | String | A flag indicating if this assessment is the most recent assessment |
| 10 | Status | String | Whether the assessment is completed or not |
| 11 | Category | String | The recommended hours of the assesdment result will be grouped under 5 categories
|
| 12 | CategoryDescription | String | A description of each category fo the recommended hours |
| 13 | RecommendValue | Number | Recommended hours of treatment for this category |
| 14 | CategoryValue | Number | Recommended hours of treatment for this category |
| 15 | AccountLogin | String | For Internal use by Rethink |
| 16 | isAgreewithRecommendation | String | A flag indicating if the clinical user agrees with the recommendation by the tool |
| 17 | AgreementRecommendedHours | Number | The number of hours asked or recommended bu the user |
| 18 | AgreementComments | String | Comment from the user |
ClientAssessmentMedicalNecessityDetails
Database Table - Field | Type | Description |
|---|---|---|
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 |
AssessmentResponseId | Number |
|
AssessmentID | Number | First Name of the client |
ClientID | Number | This is the client ID to which this assessment record was performed |
CreatedBy | String | User who created the assessment record |
AccountLogin | String | For internal use by Rethink |
AssessmentDate | Datetime | The datetime when the assessment record was created |
AssessmentType | String | Type of the assessment. Options are:
|
Section | String | Questions are organized into sections. This field has the section under which the question is located |
Question | String | The text of the question in the MNA tool |
Response | String | The answer that was given to a specific question by the user |
QuestionOrder | Number | The order of the question with the questionnaire |
SectionOrder | Number | The order of the section within the questionnaire |