Table Description
DADetermination Delivery: Determination Delivery holds details of an instance of a Determination Configuration .

Determination Delivery holds details of an instance of a Determination Configuration.
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::DeterminationDelivery::Entity::DeterminationDelivery
Controlling File: DecisionAssist\model\Packages\Service Layer\DeterminationDelivery\Entity\DeterminationDelivery_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (8)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
determinationDeliveryIDkeynoSystem generated unique identifier for a Determination Delivery.DA_DETERMINATION_DELIVERY_ID SVR_INT64
assessmentCaseIDdetailsyesCaseID of the Assessment Delivery entity.CASE_ID SVR_INT64
determinationConfigIDdetailsnoThe system generated unique identifier for the Determination Configuration on which the Determination Delivery is based.DA_DETERMINATIONCONFIG_ID SVR_INT64
determinationPackageVersionIDdetailsyesThe system generated unique identifier for the Determination Package Version used in that Determination Delivery.DA_DP_VERSION_ID SVR_INT64
statusdetails The status of the Determination Delivery.DA_DETERMINATION_DELIVERY_STATUS_CODEDADeterminationDelStatusSVR_STRING<10>
effectiveDatedetails The effective date for the Determination Delivery.CURAM_DATE SVR_DATE
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
createdDateTimedetails  CURAM_DATETIME SVR_DATETIME
Foreign Keys (8)
ChildParent
DeterminationDelivery.assessmentCaseIDAssessmentDelivery.caseID
DeterminationDelivery.determinationConfigIDDeterminationConfig.determinationConfigID
DeterminationDelivery.determinationPackageVersionIDDeterminationPackageVersion.determinationPackageVersionID
DeterminationAnswer.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
DeterminationExecution.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
DeterminationQuestionnaire.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
DeterminationStatusHistory.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
ThirdPartyRequest.determinationDeliveryIDDeterminationDelivery.determinationDeliveryID
Indices (3)
Index NameAttributes
CaseIDIndexassessmentCaseID, createdDateTime
IND_1458562936determinationConfigID
IND__226622744determinationPackageVersionID
Operations (27)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: determinationDeliveryID
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
searchInProgressDDIDAndVersionNosByAssessmentnsreadmulti   
readLatestDCDPAndDDIDsByAssessmentns  SQL
countByAssessmentKeyns  SQL
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
  
cancelDetermination    
validateCancel    
readStatusnsread To read the status of the determination delivery 
modifyStatusnsmodifyOPTIMISTIC_LOCKING: yes
To modify the status of the determination delivery 
readIDByStatusEffectiveDateTypeAndAssessmentns To search for the completed determination delivery which has same effective date for the assessmentSQL
readVersionNonsread To read the versionNo for the determination 
countByStatusEffectiveDateTypeAndAssessmentns  SQL
readDCDPCaseAndDDIDByDDnsread   
readDCAndStatusByDDKeynsread   
searchByDeterminationDeliveryIDnsreadmulti   
searchQuestionnaireVersionsByDDKeynsmulti  SQL
readDeterminationDtlsForRecordCoCns  SQL
countByStatusTypens  SQL
searchAnswersnsmulti  SQL
readLatestCreatedDDByAssessmentns  SQL
searchAllDeterminationsByAssessmentnsmulti Gets the List of Status, Effective Date form Determination Delivery, Name, Type form Determination ConfigurationSQL
readInitialDCDPAndDDIDsByAssessmentns  SQL
searchInProgressAndCompleDDsByAssessmentnsmulti  SQL
countDMCumulativeScoreByAssessmentns  SQL
Related Pages (102)
- (CDAApplication_viewDeterminationMultiSourceMC)
CDAApplication_viewDeterminationMultiSourceMCDecisionList
CDAApplication_viewDeterminationMultiSourceMCThirdPartyRequestList
- (DecisionAssistApplication_answerQuestionnaire)
Cancel Assessment (DecisionAssistApplication_cancelAssessment)
Cancel Determination (DecisionAssistApplication_cancelDetermination)
Cancel Third Party Request (DecisionAssistApplication_cancelThirdPartyRequest)
Clone Assessment (DecisionAssistApplication_cloneAssessment)
- (DecisionAssistApplication_compareDecisionFromListDecisionHistory)
DecisionAssistApplication_compareDecisionFromViewAssessment
- (DecisionAssistApplication_compareDecisionFromViewAssessmentNoCoC)
- (DecisionAssistApplication_compareDecisionFromViewDetermination)
Complete Assessment (DecisionAssistApplication_completeAssessment)
Complete Determination (DecisionAssistApplication_completeDetermination)
Consolidate Answers (DecisionAssistApplication_consolidatedAnswers)
New Third Party (DecisionAssistApplication_createThirdParty)
New Third Party Request (DecisionAssistApplication_createThirdPartyRequests)
Edit Third Party Answers (DecisionAssistApplication_editThirdPartyAnswer)
Edit Third Party Request Details (DecisionAssistApplication_editThirdPartyRequest)
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)
- (DecisionAssistApplication_listDeterminationDecisionHistory)
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)
Record Third Party Answers (DecisionAssistApplication_recordThirdPartyAnswer)
- (DecisionAssistApplication_saveAnswers)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromListDecisionHistory)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewAssessment)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewAssessmentNoCoC)
Select Decision For Comparison (DecisionAssistApplication_selectDecisionFromViewDetermination)
Send Third Party Request (DecisionAssistApplication_sendThirdPartyRequest)
- (DecisionAssistApplication_viewAnswers)
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_viewAssessmentWithCOCTabDetails)
- (DecisionAssistApplication_viewAssessmentWithCOCWithTotalScore)
DecisionAssistApplication_viewConsolidatedAnswers
DecisionAssistApplication_viewDecisionAnswerDetails
DecisionAssistApplication_viewDecisionDetails
DecisionAssistApplication_viewDetermination
- (DecisionAssistApplication_viewDeterminationMultiSourceAC)
- (DecisionAssistApplication_viewDeterminationMultiSourceACDecisionList)
DecisionAssistApplication_viewDeterminationMultiSourceACThirdPartyRequestList
- (DecisionAssistApplication_viewDeterminationMultiSourceMC)
- (DecisionAssistApplication_viewDeterminationSingleSource)
- (DecisionAssistApplication_viewDeterminationSingleSourceDecisionList)
Determination History (DecisionAssistApplication_viewDeterminationStatusHistory)
- (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)
View Third Party Request Details (DecisionAssistApplication_viewThirdPartyRequest)