ASAM integration and configuration

Last updated
Save as PDF

After Netsmart assists your organization in ensuring both the required product updates are installed and the CareFabric Connection is configured successfully, the only myAvatar configuration needed is to update any relevant user roles and user definitions to provide access to the following forms and tables:

myAvatar Forms

myAvatar Tables

► ASAM_ComprehensiveAssessment_Header

Column Name	#	Data Type	Length	Description
ID	1	VARCHAR	254	ID
AssessmentScoringID	2	VARCHAR	255	AssessmentScoringID
CategoryIdentifier	3	VARCHAR	255	CategoryIdentifier
CreatedDate	4	VARCHAR	50	CreatedDate
CreatedDate_Date	5	DATE	10	CreatedDate_Date
CreatedDate_Time	6	VARCHAR	50	CreatedDate_Time
FACILITY	7	INTEGER	10	FACILITY
MeaningIdentifier	8	VARCHAR	255	MeaningIdentifier
PATID	9	VARCHAR	50	PATID
Score	10	VARCHAR	255	Score
ScoredDate	11	VARCHAR	50	ScoredDate
ScoredDate_Date	12	DATE	10	ScoredDate_Date
ScoredDate_Time	13	VARCHAR	50	ScoredDate_Time
UpdatedDate	14	VARCHAR	50	UpdatedDate
UpdatedDate_Date	15	DATE	10	UpdatedDate_Date
UpdatedDate_Time	16	VARCHAR	50	UpdatedDate_Time
data_entry_by	17	VARCHAR	40	data_entry_by
data_entry_by_option	18	VARCHAR	50	data_entry_by_option
data_entry_date	19	DATE	10	data_entry_date
data_entry_order	20	INTEGER	10	data_entry_order
data_entry_source	21	VARCHAR	255	data_entry_source
data_entry_time	22	VARCHAR	50	data_entry_time
data_entry_user_id	23	VARCHAR	50	data_entry_user_id
data_entry_user_name	24	VARCHAR	50	data_entry_user_name
documentID	25	VARCHAR	255	documentID
option_id	26	VARCHAR	50	option_id
planID	27	VARCHAR	255	planID

► ASAM_ComprehensiveAssessment_Responses

Column Name	#	Data Type	Length	Description
ID	1	VARCHAR	254	ID
FACILITY	2	INTEGER	10	FACILITY
PATID	3	VARCHAR	50	PATID
documentID	4	VARCHAR	255	documentID

► ASAM_ComprehensiveAssessment_Scorings

Column Name	#	Data Type	Length	Description
ID	1	VARCHAR	254	ID
AssessmentScoringID	2	VARCHAR	255	AssessmentScoringID
CategoryIdentifier	3	VARCHAR	255	CategoryIdentifier
CreatedDate	4	VARCHAR	50	CreatedDate
CreatedDate_Date	5	DATE	10	CreatedDate_Date
CreatedDate_Time	6	VARCHAR	50	CreatedDate_Time
FACILITY	7	INTEGER	10	FACILITY
MeaningIdentifier	8	VARCHAR	255	MeaningIdentifier
PATID	9	VARCHAR	50	PATID
Score	10	VARCHAR	255	Score
ScoredDate	11	VARCHAR	50	ScoredDate
ScoredDate_Date	12	DATE	10	ScoredDate_Date
ScoredDate_Time	13	VARCHAR	50	ScoredDate_Time
UpdatedDate	14	VARCHAR	50	UpdatedDate
UpdatedDate_Date	15	DATE	10	UpdatedDate_Date
UpdatedDate_Time	16	VARCHAR	50	UpdatedDate_Time
data_entry_by	17	VARCHAR	40	data_entry_by
data_entry_by_option	18	VARCHAR	50	data_entry_by_option
data_entry_date	19	DATE	10	data_entry_date
data_entry_order	20	INTEGER	10	data_entry_order
data_entry_source	21	VARCHAR	255	data_entry_source
data_entry_time	22	VARCHAR	50	data_entry_time
data_entry_user_id	23	VARCHAR	50	data_entry_user_id
data_entry_user_name	24	VARCHAR	50	data_entry_user_name
documentID	25	VARCHAR	255	documentID
option_id	26	VARCHAR	50	option_id
planID	27	VARCHAR	255	planID

► ASAM_ComprehensiveDrugandAlcohol_Responses

ASAM_ComprehensiveEmployment_Responses
ASAM_ComprehensiveFamilyAndSocialHistory_Responses
ASAM_ComprehensiveLegal_Responses
ASAM_ComprehensiveMedical_Responses
ASAM_ComprehensivePsychological_Responses
ASAM_ComprehensiveReview_Responses
ASAM_TriageAssessment_Header
ASAM_TriageAssessment_Responses
ASAM_TriageAssessment_Scorings