Medical Necessity Data Source

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 Communications Reinforcer Effectivenesss Repetitive and Restrictive Behavior Sensory (Response to Treatment) Social
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: Initial Service Authorization Service Re-Authorization
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