Table Description
DADetermination Answer: The Answer entity holds the answer details for a particularQuestion used in a specificDetermination Delivery.

The Answer entity holds the answer details for a particular question used in a specific Determination Delivery.
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::QuestionAnswer::Entity::DeterminationAnswer
Controlling File: DecisionAssist\model\Packages\Service Layer\QuestionAnswer\Entity\QuestionAnswer_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
determinationAnswerIDkeynoSystem generated unique identifier for the determination answer.DA_DETERMINATION_ANSWER_ID SVR_INT64
determinationDeliveryIDdetailsnoSystem generated unique identifier for the Determination Delivery in which the answer is being used.DA_DETERMINATION_DELIVERY_ID SVR_INT64
questionIDdetailsyesSystem generated unique identifier for the Question to which the answer relates.DA_QUESTION_ID SVR_INT64
answerdetails The details of the answer.DA_ANSWER SVR_STRING<4000>
sourceIDdetails The ID of the source from which the answer has been obtained.DA_ANSWER_SOURCE_ID SVR_INT64
thirdPartyInddetails Indicator to determine whether the answer has been provided by a third party.CURAM_INDICATOR SVR_BOOLEAN
consolidationInddetails Indicator to show whether the answer has been selected as the consolidated answer.DA_CONSOLIDATION_IND SVR_BOOLEAN
recordStatusdetails  RATE_STATUS_CODERateStatusSVR_STRING<10>
lastUpdatedDateTimedetails  CURAM_DATETIME SVR_DATETIME
Foreign Keys (2)
ChildParent
DeterminationAnswer.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
DeterminationAnswer.questionIDQuestion.questionID
Indices (2)
Index NameAttributes
DDQuestionIdxdeterminationDeliveryID, questionID
IND__17123436sourceID
Operations (43)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: determinationAnswerID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
countAnsweredQuestionsForDeterminationns Counts the number of questions answered for the determinationSQL
searchUnConsolidatedAnswersnsmulti This is for multi source determination. Returns questionnaire name and question text of the answers provided and not selected as part of consolidationSQL
searchAnswersByMatrixnsmulti Reads answers specific to one decision matrix of a determination delivery. (If the determination is multi source only consolidated answers are returned)SQL
searchByDeterminationnsreadmulti Read answers provided to the questions associated to DeterminationsDelivery (Via DeterminationPackage) 
searchQuestionAnswernsreadmulti   
searchByDeterminationDeliveryKeynsreadmulti   
searchUnAnsweredMandatoryQuestionnaireNameByDDnsmulti Read Mandatory Questionnaire Names which has no answer providedSQL
searchByDeterminationDeliveryAndQuestionKeynsreadmulti   
countConsolidatedAnswersns  SQL
searchByDDQuestionnaireVersionKeynsmulti  SQL
countAnsweredQuestionsns  SQL
searchTPRQuestionAnswersnsmulti This method retrieves third party question answer details for the given determination delivery ID and third party request idSQL
searchUnAnsweredQuestionsByDDnsmulti This method retrieves unanswered question details for the given determination delivery IDSQL
searchConsolidatedQuestionsByDDnsmulti This method retrieves Consolidated/UnConsolidated question answer details for the given determination delivery IDSQL
searchAnswerDetailsnsreadmulti   
readConsolidatedAnswerDetailsns  SQL
searchAllAnswersByDDAndQVIDnsmulti Read all the answers provided for the questionnaire version and determination deliverySQL
modifyConsolidationIndbatchmodify Modify the consolidationInd when the answer is consolidated 
readVersionNonsread Read the determinationAnswerID and versionNo by DeterminationDeliveryID and QuestionnaireVersionID 
modifyConsolidationIndForQuestionnaire  Modifies consolidation Indicator for Questionnaire. 
readAnswerByQuestionKeyns  SQL
searchClaimantQuestionAnswersByDDIDAndAliasTypensmulti This method retrieves claimant question answer details for the given determination delivery IDSQL
addThirdPartyAnswerbatchinsert Create new records in DeterminationAnswer entity 
modifyAnswerbatchmodify Modify answers for given Determination Delivery ID, Source ID and Question ID 
readAnswerByDDIDSourceIDAndQuesIDnsread Read answer for given Determination Delivery ID, Source ID and Question ID 
modifyConsolidateIndbatchmodify Modify the ConsolidateInd forThird Party Answer 
removeByDetDeliverySrcAndQuesIDnsremove   
readVersionNoByDDSrcAndQuedIDnsread   
copyAnswersbatchinsert   
searchUnConsolidatedQuestionsByDDnsmulti  SQL
modifyToResetConsolidationIndicators  Updates ConsolidationIndicators for given Questionnaire version ID and Determination Delivery ID. 
modifyToSetConsolidationIndictors  Sets the consolidation indicator for all the answers for the given determination delivery and the questionnaire version.  
searchThirdPartyAnswersByDeterminationnsmulti  SQL
modifyAnswerByAnswerKeybatchmodify   
searchConsolidatedQuestionAnswersByDDnsmulti  SQL
modifyConsolidationIndicatornsmodifyOPTIMISTIC_LOCKING: no
Modify consolidation indicator. 
searchDAIDByDDIDAndQuestionnaireVersionIDnsmulti Reads the determination answer ID by determination delivery ID and questionnaire versionID.SQL
searchByDeterminationQuestionnaireVersionKeynsmulti Returns determination answer identifier for the records for the given determination delivery ID and questionnaire version ID on Question entity.SQL
searchDAIDsByDDIDAndQVIDnsmulti Gets all the answer IDs for the given determination delivery and the questionnaire version. SQL
Related Pages (25)
Clone Assessment (DecisionAssistApplication_cloneAssessment)
Complete Assessment (DecisionAssistApplication_completeAssessment)
Complete Determination (DecisionAssistApplication_completeDetermination)
Consolidate Answers (DecisionAssistApplication_consolidatedAnswers)
New Third Party Request (DecisionAssistApplication_createThirdPartyRequests)
Edit Third Party Answers (DecisionAssistApplication_editThirdPartyAnswer)
Edit Third Party Request Details (DecisionAssistApplication_editThirdPartyRequest)
Make Decision (DecisionAssistApplication_makeDecisionForAssessment)
Make Decision (DecisionAssistApplication_makeDecisionForDeterminationDelivery)
Record Change of Circumstance (DecisionAssistApplication_recordChangeOfCircumstance)
Record Third Party Answers (DecisionAssistApplication_recordThirdPartyAnswer)
- (DecisionAssistApplication_saveAnswers)
- (DecisionAssistApplication_viewAnswers)
DecisionAssistApplication_viewAnswersForQuestionnaire
DecisionAssistApplication_viewAnswersForQuestionnaireMultiSource
DecisionAssistApplication_viewAnswersForQuestionnaireMultiSourceTabDetails
DecisionAssistApplication_viewAnswersForQuestionnaireTabDetails
DecisionAssistApplication_viewConsolidatedAnswers
- (DecisionAssistApplication_viewQuestionAnswer)
- (DecisionAssistApplication_viewQuestionAnswers)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceAC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCMultiSourceMC)
Questions & Answers (DecisionAssistApplication_viewQuestionAnswersNoCOCSingleSource)
View Third Party Request Details (DecisionAssistApplication_viewThirdPartyRequest)