Table Description
DADetermination Package Version: The Determination Package Version entity enables the Administrator to set up the Questionnaires, possibleOutcomes and other details for a Determination Configuration. There can be multiple versions of determination packages over time.

The Determination Package entity enables the Administrator to set up the questionnaires, possible outcomes and other details for a Determination Configuration. There can be multiple versions of determination packages over 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::DeterminationPackage::Entity::DeterminationPackageVersion
Controlling File: DecisionAssist\model\Packages\Service Layer\DeterminationPackage\Entity\DeterminationPackage_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (17)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
determinationPackageVersionIDkeynoSystem generated unique identifier for a Determination Package Version.DA_DP_VERSION_ID SVR_INT64
determinationPackageIDdetailsnoSystem generated unique identifier for a Determination Package, this is used to group determination packages over multiple versions.DA_DP_ID SVR_INT64
namedetails The name of the Determination Package Version.DA_DP_NAME SVR_STRING<25>
determinationPkgVersionNumberdetails The Version number of the Determination Package.DA_DP_VERSION_NUMBER SVR_INT16
versionStatusdetails The status of the Determination Package version.DA_DP_VERSION_STATUSDPVersionStatusSVR_STRING<10>
fromDatedetails The date and time that this version was released.DA_DP_FROM_DATE SVR_DATETIME
toDatedetails The date and time the subsequent version replacing this one was released or the date and time that this version was removed from the associated Determination Configuration.DA_DP_TO_DATE SVR_DATETIME
commentsdetails Comments relating to the determination package version.DA_DP_COMMENTS SVR_STRING<200>
dateCreateddetails The date and time on which the determination package version was created.CURAM_DATETIME SVR_DATETIME
createdBydetails Username of the user who created the determination package version.USER_NAME SVR_STRING<64>
recordStatusdetails  RECORD_STATUS_CODERecordStatusSVR_STRING<10>
genderdetails Gender of claimant to which the determination package applies.GENDER_CODEGenderSVR_STRING<10>
minAgedetailsyesMinimum Age of claimant to which the determination package applies.DA_DP_AGE SVR_INT16
maxAgedetailsyesMaximum Age of claimant to which the determination package applies.DA_DP_AGE SVR_INT16
productIDdetailsyesID of the related Product to which the determination package applies.DA_DP_PRODUCT_NAMEProductNameSVR_STRING<10>
determinationConfigIDdetailsyesSystem generated unique identifier for a Determination Configuration.DA_DETERMINATIONCONFIG_ID_FK SVR_INT64
flagdetails  DA_DP_FLAG SVR_INT8
Foreign Keys (5)
ChildParent
DeterminationPackageVersion.determinationConfigIDDeterminationConfig.determinationConfigID
DeterminationPackageVersion.determinationPackageIDDeterminationPackage.determinationPackageID
DPDecisionMatrixLink.determinationPackageVersionIDDeterminationPackageVersion.determinationPackageVersionID
DPQuestionnaireLink.determinationPackageVersionIDDeterminationPackageVersion.determinationPackageVersionID
DeterminationDelivery.determinationPackageVersionIDDeterminationPackageVersion.determinationPackageVersionID
Indices (2)
Index NameAttributes
IND__1310275466determinationConfigID
IND_642699880determinationPackageID
Operations (34)
OperationStereotypeOptionsDescriptionSQL
insertinsertPRE_DATA_ACCESS: yes
Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
removeremove Standard Operation 
countByDeterminationPackageNamens  SQL
searchPackageForDeterminationreadmultiORDER_BY: name
  
searchEquivalentPackagesnsmulti  SQL
readDeterminationPackageByVersionNumbernsread   
searchAllLatestReleasedDeterminationPackagesForDCnsmulti  SQL
searchAllInEditDeterminationPackagesForDCnsmulti  SQL
readLatestDeterminationPackageVersionns  SQL
modifyToDateForDeterminationnsmodifyOPTIMISTIC_LOCKING: yes
  
modifyDeterminationPackageToReleasensmodifyOPTIMISTIC_LOCKING: yes
  
searchPackagesForQuestionnairensmulti  SQL
readVersionDetailsForDPVns  SQL
searchPackagesForDecisionMatrixnsmulti  SQL
searchByPackageIDreadmultiORDER_BY: determinationPkgVersionNumber, createdBy
  
cancelLatestDPVersionFromDeterminationnsmodify   
searchAllDPsAssociatedToDecisionMatrixnsmulti  SQL
searchAllDPsAssociatedToDeterminationConfignsmulti  SQL
insertPackageWithNoMinAgensinsert   
insertPackageWithNoMaxAgensinsert   
insertPackageWithNoMinAgeAndMaxAgensinsert   
modifyPackageWithNoMinAgensmodify   
modifyPackageWithNoMaxAgensmodify   
modifyPackageWithNoMinAndMaxAgensmodify   
readEarliestFromDateForDeterminationConfigns  SQL
readLatestToDateForDeterminationConfigns  SQL
readLatestFromDateForDeterminationConfigns  SQL
searchCurrentReleasedPackagesForDCnsmulti  SQL
countMatchingDPCriterans  SQL
searchByDeterminationConfigKeyreadmulti List&nbsp;all determination config records for a configuration&nbsp;ID.&nbsp; 
insertDeterminationPackageVersioninsert Standard Operation 
searchDPVersionIDByStatusnsreadmulti Reads DPVersionID by given status. 
Related Pages (64)
New Version (DAAssessmentConfiguration_createNewQuestionScriptVersion)
IEG Editor: (DAAssessmentConfiguration_IEGEditorContextPanel)
Add Condition: (DecisionAssistAdmin_addCondition)
Add Existing Questionnaire (DecisionAssistAdmin_addExistingQuestionnaire)
New Condition (DecisionAssistAdmin_assignConditionToDC)
Clone Decision Matrix (DecisionAssistAdmin_cloneDecisionMatrix)
New Decision Matrix (DecisionAssistAdmin_createDecisionMatrix)
New Decision Matrix Version (DecisionAssistAdmin_createDecisionMatrixVersion)
New Determination Package (DecisionAssistAdmin_createDeterminationPackage)
New Version (DecisionAssistAdmin_createNewPackageVersion)
New Presentation Data (DecisionAssistAdmin_createPresentationData)
New Questionnaire (DecisionAssistAdmin_createQuestionnaireFromPackage)
- (DecisionAssistAdmin_createQuestionnaireFromPresentation)
New Version (DecisionAssistAdmin_createQuestionnaireVersion)
New Version (DecisionAssistAdmin_createQuestionnaireVersionForDP)
- (DecisionAssistAdmin_DecisionMatrix)
Remove Condition (DecisionAssistAdmin_deleteConditionLink)
Delete Determination Configuration (DecisionAssistAdmin_deleteDeterminationConfig)
Remove Determination Configuration (DecisionAssistAdmin_deleteDeterminationForConditionLink)
Delete Version (DecisionAssistAdmin_deleteDeterminationPackage)
- (DecisionAssistAdmin_deletePresentationData)
Delete Questionnaire (DecisionAssistAdmin_deleteQuestionnaireVersion)
- (DecisionAssistAdmin_DMView)
Edit Matrix (DecisionAssistAdmin_editDecisionMatrixData)
Edit Typical Answer (DecisionAssistAdmin_editTypicalAnswersForQuestion)
- (DecisionAssistAdmin_editTypicalAnswersForQuestionForDP)
Conditions (DecisionAssistAdmin_listConditionForDetermination)
Decision Matrix (DecisionAssistAdmin_listDecisionMatricesForDP)
Decision Matrix (DecisionAssistAdmin_listDecisionMatricesForDPVersion)
Decision Matrix Version History : (DecisionAssistAdmin_listDMVersionHistory)
In Edit Packages (DecisionAssistAdmin_listInEditPackages)
Determination Packages: (DecisionAssistAdmin_listPackagesForDetermination)
DecisionAssistAdmin_listPackageVersionsHistory
- (DecisionAssistAdmin_listQuestionnairePresentationDetails)
Questionnaires: (DecisionAssistAdmin_listQuestionnairesForDeterminationPackage)
Released Packages (DecisionAssistAdmin_listReleasedPackages)
Typical Pictures (DecisionAssistAdmin_listTPForQuestionnaireForDP)
Typical Picture Version History : (DecisionAssistAdmin_listTPVersionHistoryForDP)
Edit Decision Matrix Details (DecisionAssistAdmin_modifyDecisionMatrix)
Edit Determination Configuration : (DecisionAssistAdmin_modifyDeterminationConfig)
Edit Determination Configuration : (DecisionAssistAdmin_modifyDeterminationConfigWithFutureDates)
Edit Determination Configuration (DecisionAssistAdmin_modifyDeterminationConfigWithFutureEndDate)
Edit Determination Configuration : (DecisionAssistAdmin_modifyDeterminationConfigWithPastDates)
Edit Determination Package Details (DecisionAssistAdmin_modifyDeterminationPackage)
- (DecisionAssistAdmin_modifyPresentationData)
Version History (DecisionAssistAdmin_questionnaireVersionHistory)
Version History (DecisionAssistAdmin_questionnaireVersionHistoryForDP)
Release Version (DecisionAssistAdmin_releasePackageVersion)
Release Questionnaire Version (DecisionAssistAdmin_releaseQuestionnaireVersion)
Remove Decision Matrix (DecisionAssistAdmin_removeDecisionMatrixFromPackage)
Remove Determination Package (DecisionAssistAdmin_removePackageFromDetermination)
Remove Questionnaire (DecisionAssistAdmin_removeQuestionnaireFromPackage)
- (DecisionAssistAdmin_viewDecisionMatrix)
Home (DecisionAssistAdmin_viewDeterminationConfig)
- (DecisionAssistAdmin_viewDeterminationConfigTabDetails)
- (DecisionAssistAdmin_viewDeterminationPackage)
View Determination Package Version (DecisionAssistAdmin_viewDeterminationPackageVersion)
View Outcome Details : (DecisionAssistAdmin_viewOutcomeForDP)
- (DecisionAssistAdmin_viewPresentationData)
Home (DecisionAssistAdmin_viewQuestionnaireForDP)
DecisionAssistAdmin_viewQuestionnaireVersionHistoryForDP
- (DecisionAssistAdmin_viewTypicalPictureForDP)
Clone Assessment (DecisionAssistApplication_cloneAssessment)
Record Change of Circumstance (DecisionAssistApplication_recordChangeOfCircumstance)