Table Description
CREOLE Program Recommendation : Stores the results of CREOLE Program Recommendation. Stores the results of CREOLE Program Recommendation.

Example
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::CREOLEProgramRecommendation::Entity::CREOLEProgramRecommendation
Controlling File: CREOLEProgramRecommendation\model\Packages\Entity.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
creoleProgramRecommendationIDkeyno INTERNAL_ID SVR_INT64
caseIDdetailsno INTERNAL_ID SVR_INT64
dateTimedetailsno CURAM_DATETIME SVR_DATETIME
createdByUserdetailsyes USER_NAME SVR_STRING<64>
creoleProgRecommendationDataIDdetailsyes INTERNAL_ID SVR_INT64
evidenceUseddetailsno CPR_EVIDENCE_USEDProgRecEvidenceUsedSVR_STRING<10>
applicationIDdetailsyes INTERNAL_ID SVR_INT64
hashcodedetailsyes CPR_HASHCODE SVR_INT64
ruleObjectSnapshotDataIDdetailsyes INTERNAL_ID SVR_INT64
progRecommendationResultDataIDdetailsyes INTERNAL_ID SVR_INT64
Foreign Keys (8)
ChildParent
CREOLEProgramRecommendation.applicationIDApplication.applicationID
CREOLEProgramRecommendation.creoleProgRecommendationDataIDCREOLEProgRecommendationData.creoleProgRecommendationDataID
CREOLEProgramRecommendation.ruleObjectSnapshotDataIDCREOLEProgRecommendationData.creoleProgRecommendationDataID
CREOLEProgramRecommendation.progRecommendationResultDataIDCREOLEProgRecommendationData.creoleProgRecommendationDataID
CREOLEProgramRecSummary.creoleProgramRecommendationIDCREOLEProgramRecommendation.creoleProgramRecommendationID
CompactSimDetermination.creoleProgramRecommendationIDCREOLEProgramRecommendation.creoleProgramRecommendationID
SimDeterminationAuthorization.creoleProgramRecommendationIDCREOLEProgramRecommendation.creoleProgramRecommendationID
SimDeterminationDeclination.creoleProgramRecommendationIDCREOLEProgramRecommendation.creoleProgramRecommendationID
Indices (6)
Index NameAttributes
CREOLEProgRecCaseIDIdxcaseID
CREOLEProgRecAppIDIdxapplicationID
CREOProgRecCREOProgRecDtIDIdxcreoleProgRecommendationDataID
IND__1325664305hashcode
IND__1998358728ruleObjectSnapshotDataID
IND_1774564073progRecommendationResultDataID
Operations (8)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: creoleProgramRecommendationID
Standard Operation 
readread Standard Operation 
searchByCaseIDreadmultiORDER_BY: dateTime
Search CREOLEProgramRecommendation by the case ID 
readLatestCREOLEProgramRecommendationIDns Retrieve the latest CREOLE Program Recommendation IDSQL
searchByApplicationIDreadmultiORDER_BY: dateTime
Search CREOLEProgramRecommendation by the application ID 
readLatestCREOLEProgramRecommendationIDForApplicationns Retrieve the latest CREOLE Program Recommendation IDSQL
modifymodify Standard Operation 
searchByCaseIDAndHashcodereadmulti   
Related Pages (93)
Age Blind Disabled Decision (ABDDecision_contextPanel)
) (Application_participantNewReferral)
Work Eligibility (Application_workEligibility)
History (Application_workEligibilityHistory)
History (Application_WorkEligibilityHistoryDetails)
Home (ApplicationSummary)
Breast and Cervical Cancer Decision (BCCDecision_contextPanel)
Cash Assistance Decision (CADecision_contextPanel)
CGISSApplicationContextPanel1
Children Decision (ChildrenDecision_contextPanel)
Children's Health Insurance Program (CHIPDecision_contextPanel)
CREOLEFAProductHomeDetails
Authorize (CREOLEProgramRecommendation_confirmAuthorize)
Decline (CREOLEProgramRecommendation_decline)
Eligible Results (CREOLEProgramRecommendation_listEligibleSimulatedDeterminations)
Decision Periods (CREOLEProgramRecommendation_listIneligiblePeriodsForSimulatedDetermination)
Ineligible Results (CREOLEProgramRecommendation_listIneligibleSimulatedDeterminations)
Decision Periods (CREOLEProgramRecommendation_listPeriodsForLatestSimulatedDetermination)
Coverage Periods (CREOLEProgramRecommendation_listPeriodsForSimulatedDetermination)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendations)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendations1)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendationsForApplication)
Eligibility Checks (CREOLEProgramRecommendation_listProgramRecommendationsForApplication1)
Review Eligibility Results (CREOLEProgramRecommendation_readLatestForApplication)
Check Eligibility (CREOLEProgramRecommendation_selectPrograms)
Status Details (CREOLEProgramRecommendation_viewAuthorizationDetails)
Status Details (CREOLEProgramRecommendation_viewDeclinationDetails)
Emergency Age Blind Disabled Decision (EmergencyABDDecision_contextPanel)
Emergency Children Decision (EmergencyChildrenDecision_contextPanel)
Emergency LIFC Decision (EmergencyLIFCDecision_contextPanel)
Emergency Medically Needy Children Decision (EmergencyMNChildrenDecision_contextPanel)
Emergency Newborn Decision (EmergencyNewBornDecision_contextPanel)
Emergency Pregnant Woman Decision (EmergencyPWDecision_contextPanel)
Emergency Title IV E Adoption Decision (EmergencyTitleIVEAdoptionDecision_contextPanel)
Emergency Title IV E Foster Care Decision (EmergencyTitleIVEFosterCareDecision_contextPanel)
Apply Changes (Evidence_applyChanges1)
Food Assistance Decision (FADecision_contextPanel)
Work Eligibility (IntegratedCase_caParticipationWorkEligibility)
Work Eligibility (IntegratedCase_faParticipationWorkEligibility)
Referrals (InternalReferralWizard_clients)
) (InternalReferralWizard_office)
Application Details (ISPApplicationISCompletePreviewPanel)
Application Details (ISPApplicationISDisposedPreviewPanel)
Low Income Families with Children Decision (LIFCDecision_contextPanel)
Medically Needy Long Term Care (LTCDecision_contextPanel)
Medically Needy Children Decision (MNChildrenDecision_contextPanel)
Medically Needy Pregnant Woman Decision (MNPWDecision_contextPanel)
Medically Needy Pregnant Woman with Spend Down Decision (MNPWWithSDDecision_contextPanel)
Medically Needy Long Term Care with Spend Down (MNSLTCDecision_contextPanel)
Medically Needy Children with Spend Down Decision (MNWithSDChildrenDecision_contextPanel)
Newborn Decision (NewBornDecision_contextPanel)
Apply Update (ProgramRecommendation_confirmApplyToExistingPD)
Authorize (ProgramRecommendation_confirmAuthorize)
Decline (ProgramRecommendation_decline)
Eligible Results (ProgramRecommendation_futureEligibleSimulatedDeterminations)
Eligible Results (ProgramRecommendation_futureEligibleSimulatedDeterminationsForIC)
Eligible Results (ProgramRecommendation_listEligibleSimulatedDeterminations)
Eligible Results (ProgramRecommendation_listEligibleSimulatedDeterminationsForIC)
Coverage Periods (ProgramRecommendation_listFutureEligiblePeriodsForSimulatedDetermination)
Authorize (ProgramRecommendation_listHouseholdMembersForCHIP)
Authorize (ProgramRecommendation_listHouseholdMembersForMA)
Decision Periods (ProgramRecommendation_listIneligiblePeriodsForSimulatedDetermination)
Ineligible Results (ProgramRecommendation_listIneligibleSimulatedDeterminations)
Ineligible Results (ProgramRecommendation_listIneligibleSimulatedDeterminationsForIC)
Decision Periods (ProgramRecommendation_listPeriodsForLatestSimulatedDetermination)
Coverage Periods (ProgramRecommendation_listPeriodsForRetroactiveSimulatedDetermination)
Coverage Periods (ProgramRecommendation_listPeriodsForSimulatedDetermination)
Eligibility Checks (ProgramRecommendation_listProgramRecommendations)
Eligibility Checks (ProgramRecommendation_listProgramRecommendations1)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication1)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForApplication2)
Eligibility Checks (ProgramRecommendation_listProgramRecommendationsForRetroactiveApplication)
Eligible Results (ProgramRecommendation_listRetoactiveResults)
Eligible Results (ProgramRecommendation_listRetroactiveEligibleSimulatedDeterminations)
Decision Periods (ProgramRecommendation_listRetroactiveIneligiblePeriodsForSimulatedDetermination)
Ineligible Results (ProgramRecommendation_listRetroactiveIneligibleSimulatedDeterminations)
Authorize (ProgramRecommendation_PremiumCoPaymentDetails)
Review Eligibility Results (ProgramRecommendation_readLatest)
Authorize (ProgramRecommendation_readLatestForApplication)
Retroactive (ProgramRecommendation_retroactiveEligibility)
Check Eligibility (ProgramRecommendation_selectPrograms)
Status Details (ProgramRecommendation_viewAuthorizationDetails)
Status Details (ProgramRecommendation_viewDeclinationDetails)
Pregnant Woman Decision (PWDecision_contextPanel)
Qualified Disabled Working Individual Decision (QDWIDecision_contextPanel)
Qualified Individual Decision (QIDecision_contextPanel)
Qualified Medicare Beneficiaries Decision (QMBDecision_contextPanel)
Refugee Decision (RefugeeDecision_contextPanel)
Long Term Care (SILLTCDecision_contextPanel)
Specified Low-Income Medicare Beneficiaries Decision (SLMBDecision_contextPanel)
Title IV E Adoption Decision (TitleIVEAdoptionDecision_contextPanel)
Title IV E Foster Care Decision (TitleIVEFosterCareDecision_contextPanel)