Table Description
DAQuestionnaireVersion: The questionnaire version entity holds details of Questionnaire Versions. There can be multiple versions of a Questionnaire over a period of time.

The questionnaire version entity holds details of questionnaire versions. There can be multiple versions of a Questionnaire over a period of time.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Decision Assist::Service Layer::Questionnaries::Entity::QuestionnaireVersion
Controlling File: DecisionAssist\model\Packages\Service Layer\Questionnaires\Entity\Questionnaire Version_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (13)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
questionnaireVersionIDkeynoSystem generated unique identifier for a questionnaire version.DA_QUESTIONNAIRE_VERSION_ID SVR_INT64
questionnaireIDdetailsno DA_QUESTIONNAIRE_ID SVR_INT64
namedetails The name of the questionnaire version.DA_QUESTIONNAIRE_NAME SVR_STRING<50>
typedetails The type of questionnaire version.DA_QUESTIONNAIRE_TYPEDAQuestionnaireTypeSVR_STRING<10>
questionnaireVersionNumberdetails The number of that questionnaire version.DA_QUESTIONNAIRE_VERSION_NUMBER SVR_INT32
versionStatusdetails The status of that questionnaire version. This may be in edit or released.DA_QUESTIONNAIRE_VERSION_STATUSDAQuestionnaireStatusSVR_STRING<10>
fromDatedetails Date and time from which that version of the questionnaire is released.CURAM_DATETIME SVR_DATETIME
toDatedetails The date and time a subsequent version is released and that version is therefore no longer used.CURAM_DATETIME SVR_DATETIME
dateCreateddetails The date that that version of the questionnaire was created.CURAM_DATETIME SVR_DATETIME
createdBydetails The full name of the user who created the questionnaire version.DA_CREATED_BY_USER SVR_STRING<64>
commentsdetails Comments relating to the questionnaire version.COMMENTS SVR_STRING<300>
iegScriptIDdetailsyesThe ID of the related IEG script for the questionnaire version.DA_QUESTIONNAIRE_SCRIPT_ID SVR_STRING<100>
datastoreSchemadetails The name of the data store schema for the related IEG script.DA_DATASTORE_SCHEMA_NAME SVR_STRING<40>
Foreign Keys (5)
ChildParent
QuestionnaireVersion.questionnaireIDQuestionnaire.questionnaireID
DPQuestionnaireLink.questionnaireVersionIDQuestionnaireVersion.questionnaireVersionID
DeterminationQuestionnaire.questionnaireVersionIDQuestionnaireVersion.questionnaireVersionID
Question.questionnaireVersionIDQuestionnaireVersion.questionnaireVersionID
TPQuestionnaireLink.questionnaireVersionIDQuestionnaireVersion.questionnaireVersionID
Indices (4)
Index NameAttributes
questionnaireIDNameIndexname, questionnaireID
questionnaireIDVersionNoIndexquestionnaireID, questionnaireVersionNumber
questionnaireNameIndexname
IND_1360848807iegScriptID
Operations (26)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: questionnaireVersionID
AUTO_ID_KEY: QUESNRVRSN
PRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyPRE_DATA_ACCESS: yes
Standard Operation 
removeremove Standard Operation 
validateInsert  Groups all necessary validation that needs to be performed before creating questionnaire version 
countByQuestionnaireVersionNamens This method give count of questionnaire with name same as one being created or modifiedSQL
validateModify  Groups all necessary validation that needs to be performed before modifying questionnaire version 
searchByQuestionnaireIDAndMaxVersionNumbernsmulti Reads list of most recent released version of questionnairesSQL
validateDetails  Groups all generic validation that needs to be performed for creating/modifying questionnaire version 
readQuestionnaireVersionStatusnsread Reads status of a specified questionnaire version 
countByQuestionnaireNamens This method give count of questionnaire version with name same as one being created or modifiedSQL
readSpecifiedVersionDetailsnsread Reads details of a specified questionnaire version based on questionnaire identifier id and version number 
searchByQuestionnaireIDreadmultiORDER_BY: questionnaireVersionNumber
Reads details of all versions of a specified questionnaire 
readLatestVersionNumberns Reads details of most recent version of a questionnaireSQL
searchQuestionnaireForDeterminationPackagensmulti Reads details of most recent versions of all questionnaires associated with a specified version of a determination packageSQL
modifyQuestionnaireVersionnsmodify Method releases a specified questionnaire version, status of questionnaire version is changed to released 
modifyPreviousVersionnsmodify Set to date to current business date for the previous version of questionnaire that is been released 
searchQuestionnnaireVersionDetailsForTPnsmulti Reads questionnaire version details for a specified typical picture versionSQL
searchLatestReleasedQuestionnairesByDPnsmulti Reads details of latest questionnaire version associated to a specified determination packageSQL
searchQuestionnaireForPackageByStatusnsmulti Reads questionnaire version ID and name based on determination package and statusSQL
readStatusByIEGScriptIDnsread   
readScriptKeyForQuestionnaireVersionnsread Reads IEG Script Id for a specified questionnaire version 
searchQuestionnaireForPresentationDatansmulti Reads details of most recent versions of all questionnaires associated with a specified version of a determination packageSQL
readByIEGScriptKeyAndVersionDtlsnsread This method is used to read the Questionnaire version details by IEG script ID, questionnaire version number and questionnaire version status. 
insertQuestionnaireVersioninsert Inserts record to questionnaire version entity. This method expects questionnaire version ID to be set by the caller, if not set it delegates the call to insert() which is modeled to auto generate primary key field (questionnaire version ID). It's preferred to call this method only in scenario's where caller wants to set the value of primary key (questionnaire version ID) by itself. 
modifyQuestionnaireVersionDetailsmodify Standard Operation 
Related Pages (155)
- (CDAApplication_viewDeterminationMultiSourceMC)
CDAApplication_viewDeterminationMultiSourceMCDecisionList
CDAApplication_viewDeterminationMultiSourceMCThirdPartyRequestList
New CDA Assessment Configuration (DAAssessmentConfiguration_create)
New Version (DAAssessmentConfiguration_createNewQuestionScriptVersion)
Add Questions (DAAssessmentConfiguration_decisionMatrixQuestionPopup)
Edit CDA Assessment Configuration (DAAssessmentConfiguration_editFromList)
Edit CDA Assessment Configuration (DAAssessmentConfiguration_editFromView)
IEG Editor: (DAAssessmentConfiguration_IEGEditorContextPanel)
DAAssessmentConfiguration_list
DAAssessmentConfiguration_questionScriptContextPanel
DAAssessmentConfiguration_questionScriptHome
Decision Assist Assessment Configuration (DAAssessmentConfiguration_view)
Choose a Questionnaire (DAAssessmentConfigurationDecisionMatrixQuestionPopup)
New Typical Picture Version (DecisionAssistAdmin_createNewTypicalPictureVersion)
New Typical Picture Version (DecisionAssistAdmin_createNewTypicalPictureVersionForDP)
New Questionnaire (DecisionAssistAdmin_createQuestionnaire)
New Questionnaire (DecisionAssistAdmin_createQuestionnaireFromPackage)
- (DecisionAssistAdmin_createQuestionnaireFromPresentation)
New Version (DecisionAssistAdmin_createQuestionnaireVersion)
New Version (DecisionAssistAdmin_createQuestionnaireVersionForDP)
New Typical Picture (DecisionAssistAdmin_createTypicalPicture)
New Typical Picture (DecisionAssistAdmin_createTypicalPictureForDP)
- (DecisionAssistAdmin_DecisionMatrix)
Add Questions (DecisionAssistAdmin_decisionMatrixQuestionPopup)
Remove Decision Outcome (DecisionAssistAdmin_deleteDecisionOutcome)
Remove Decision Outcome (DecisionAssistAdmin_deleteDecisionOutcomeForDP)
Delete Version (DecisionAssistAdmin_deleteDeterminationPackage)
Delete Questionnaire (DecisionAssistAdmin_deleteQuestionnaireVersion)
Delete Version (DecisionAssistAdmin_deleteTypicalPicture)
Delete Version (DecisionAssistAdmin_deleteTypicalPictureForDP)
- (DecisionAssistAdmin_DMView)
Edit Matrix (DecisionAssistAdmin_editDecisionMatrixData)
Edit Typical Answers (DecisionAssistAdmin_editTypicalAnswers)
Edit Typical Answers (DecisionAssistAdmin_editTypicalAnswersForDP)
Edit Typical Answer (DecisionAssistAdmin_editTypicalAnswersForQuestion)
- (DecisionAssistAdmin_editTypicalAnswersForQuestionForDP)
Decision Matrix (DecisionAssistAdmin_listDecisionMatricesForDP)
Decision Matrix (DecisionAssistAdmin_listDecisionMatricesForDPVersion)
Decision Matrix Version History : (DecisionAssistAdmin_listDMVersionHistory)
DecisionAssistAdmin_listPackageVersionsHistory
DecisionAssistAdmin_listQuestionnaire
- (DecisionAssistAdmin_listQuestionnairePresentationDetails)
Questionnaires: (DecisionAssistAdmin_listQuestionnairesForDeterminationPackage)
Typical Pictures (DecisionAssistAdmin_listTPForQuestionnaire)
Typical Pictures (DecisionAssistAdmin_listTPForQuestionnaireForDP)
Typical Picture Version History : (DecisionAssistAdmin_listTPVersionHistory)
Typical Picture Version History : (DecisionAssistAdmin_listTPVersionHistoryForDP)
Edit Questionnaire (DecisionAssistAdmin_modifyQuestionnaire)
Edit Typical Picture (DecisionAssistAdmin_modifyTypicalPictureDetails)
Edit Typical Picture Details (DecisionAssistAdmin_modifyTypicalPictureDetailsForDP)
Version History (DecisionAssistAdmin_questionnaireVersionHistory)
Version History (DecisionAssistAdmin_questionnaireVersionHistoryForDP)
Release Version (DecisionAssistAdmin_releasePackageVersion)
Release Questionnaire Version (DecisionAssistAdmin_releaseQuestionnaireVersion)
Release Typical Picture (DecisionAssistAdmin_releaseTypicalPicture)
Release Typical Picture Version (DecisionAssistAdmin_releaseTypicalPictureForDP)
Remove Typical Picture (DecisionAssistAdmin_removeTypicalPictureFromQuestionnaireVersion)
DecisionAssistAdmin_resolveValidateQuestionScript
Questionnaires (DecisionAssistAdmin_searchQuestionnaire)
Synchronize Typical Pictures (DecisionAssistAdmin_synchronizeTypicalPicture)
Validate Question Script: (DecisionAssistAdmin_validateQuestionScript)
- (DecisionAssistAdmin_viewDecisionMatrix)
- (DecisionAssistAdmin_viewDeterminationPackage)
View Determination Package Version (DecisionAssistAdmin_viewDeterminationPackageVersion)
- (DecisionAssistAdmin_viewLatestQuestionnaire)
View Outcome Details : (DecisionAssistAdmin_viewOutcomeForDP)
- (DecisionAssistAdmin_viewPresentationData)
Home (DecisionAssistAdmin_viewQuestionnaire)
Home (DecisionAssistAdmin_viewQuestionnaire1)
Home (DecisionAssistAdmin_viewQuestionnaireForDP)
- (DecisionAssistAdmin_viewQuestionnairePop)
v (DecisionAssistAdmin_viewQuestionnaireTabDetails)
DecisionAssistAdmin_viewQuestionnaireVersionHistory
DecisionAssistAdmin_viewQuestionnaireVersionHistoryForDP
- (DecisionAssistAdmin_viewTypicalPicture)
- (DecisionAssistAdmin_viewTypicalPictureForDP)
Cancel Assessment (DecisionAssistApplication_cancelAssessment)
Clone Assessment (DecisionAssistApplication_cloneAssessment)
DecisionAssistApplication_compareDecisionFromViewAssessment
Complete Assessment (DecisionAssistApplication_completeAssessment)
Complete Determination (DecisionAssistApplication_completeDetermination)
Consolidate Answers (DecisionAssistApplication_consolidatedAnswers)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistory)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCMultiSourceAC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCMultiSourceMC)
Decision History (DecisionAssistApplication_listAssessmentDecisionHistoryNoCOCSingleSource)
DecisionAssistApplication_listClientRoleNoCOC
DecisionAssistApplication_listClientRoleNoCOCMultiSourceAC
DecisionAssistApplication_listClientRoleNoCOCMultiSourceMC
DecisionAssistApplication_listClientRoleNoCOCSingleSource
DecisionAssistApplication_listClientRoleWithCOC
Communications (DecisionAssistApplication_listCommunicationNoCOC)
Communications (DecisionAssistApplication_listCommunicationNoCOCMultiSourceAC)
Communications (DecisionAssistApplication_listCommunicationNoCOCMultiSourceMC)
Communications (DecisionAssistApplication_listCommunicationNoCOCSingleSource)
Communications (DecisionAssistApplication_listCommunicationWithCOC)
Determinations (DecisionAssistApplication_listDeterminations)
Events (DecisionAssistApplication_listEventNoCOC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceAC)
Events (DecisionAssistApplication_listEventNoCOCMultiSourceMC)
Events (DecisionAssistApplication_listEventNoCOCSingleSource)
Events (DecisionAssistApplication_listEventWithCOC)
Notes (DecisionAssistApplication_listNoteNoCOC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceAC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceMC)
Notes (DecisionAssistApplication_listNoteNoCOCSingleSource)
Notes (DecisionAssistApplication_listNoteWithCOC)
Tasks (DecisionAssistApplication_listTaskNoCOC)
Tasks (DecisionAssistApplication_listTaskNoCOCMultiSourceAC)
Tasks (DecisionAssistApplication_listTaskNoCOCMultiSourceMC)
Tasks (DecisionAssistApplication_listTaskNoCOCSingleSource)
Tasks (DecisionAssistApplication_listTaskWithCOC)
User Roles (DecisionAssistApplication_listUserRoleNoCOC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCMultiSourceAC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCMultiSourceMC)
User Roles (DecisionAssistApplication_listUserRoleNoCOCSingleSource)
User Roles (DecisionAssistApplication_listUserRoleWithCOC)
Make Decision (DecisionAssistApplication_makeDecisionForAssessment)
Make Decision (DecisionAssistApplication_makeDecisionForDeterminationDelivery)
Record Change of Circumstance (DecisionAssistApplication_recordChangeOfCircumstance)
- (DecisionAssistApplication_saveAnswers)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewAssessment)
DecisionAssistApplication_viewAnswersForQuestionnaire
DecisionAssistApplication_viewAnswersForQuestionnaireMultiSource
DecisionAssistApplication_viewAnswersForQuestionnaireMultiSourceTabDetails
DecisionAssistApplication_viewAnswersForQuestionnaireTabDetails
Home (DecisionAssistApplication_viewAssessmentNoCOCMultiSourceAC)
Home (DecisionAssistApplication_viewAssessmentNoCOCMultiSourceMC)
Home (DecisionAssistApplication_viewAssessmentNoCOCSingleSource)
- (DecisionAssistApplication_viewAssessmentNoCOCTabDetails)
Assessment History (DecisionAssistApplication_viewAssessmentStatusHistory)
- (DecisionAssistApplication_viewAssessmentWithCOC)
Home (DecisionAssistApplication_viewAssessmentWithCOCNoTotalScore)
- (DecisionAssistApplication_viewAssessmentWithCOCWithTotalScore)
DecisionAssistApplication_viewConsolidatedAnswers
DecisionAssistApplication_viewDetermination
- (DecisionAssistApplication_viewDeterminationMultiSourceAC)
- (DecisionAssistApplication_viewDeterminationMultiSourceACDecisionList)
DecisionAssistApplication_viewDeterminationMultiSourceACThirdPartyRequestList
- (DecisionAssistApplication_viewDeterminationMultiSourceMC)
- (DecisionAssistApplication_viewDeterminationSingleSource)
- (DecisionAssistApplication_viewDeterminationSingleSourceDecisionList)
- (DecisionAssistApplication_viewMemberHomeForDetermination)
- (DecisionAssistApplication_viewMemberHomeNoCOC)
- (DecisionAssistApplication_viewMemberHomeThirdParty)
- (DecisionAssistApplication_viewMemberHomeWithCOC)
- (DecisionAssistApplication_viewQuestionAnswer)
- (DecisionAssistApplication_viewQuestionAnswers)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceAC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceMC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCSingleSource)
Choose a Questionnaire (DecisionMatrixQuestionPopup)