Table Description
Case Note: A link between a note and a case.
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::Core::Reference Model::Service Layer::Case Note::Entity::CaseNote
Controlling File: core\model\Packages\Reference Model\Service Layer\Case Note\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
caseNoteIDkeynoA unique id for a case note.CASE_NOTE_ID SVR_INT64
caseIDdetailsnoUnique ID of the associated case. Links the case note to the related case. CASE_ID SVR_INT64
noteIDdetailsnoUnique ID of the associated note. Links the case note to the related note. NOTE_ID SVR_INT64
recordStatusdetailsnoCurrent record status of the case note.RECORD_STATUS_CODERecordStatusSVR_STRING<10>
Foreign Keys (3)
ChildParent
CaseNote.caseIDCaseHeader.caseID
CaseNote.noteIDNote.noteID
FactorNoteLink.caseNoteIDCaseNote.caseNoteID
Indices (2)
Index NameAttributes
caseNoteIndexcaseID
CaseNoteIdxnoteID
Operations (21)
OperationStereotypeOptionsDescriptionSQL
insert  Inserts the details of a case note. 
validate  Validates the details of a case note prior to insert. 
modify  Modifies the details of a case note. @deprecated - replaced by {@link #modify1()} @deprecated-since Version 6.0 
readNotens Retrieves the details of a case note @deprecated - replaced by {@link #readNote1()} @deprecated-since Version 6.0SQL
searchByCaseIDnsmulti Retrieves a list of case notes for a case.SQL
cancelnsmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Cancels the details of a case note 
validateCancel  Validates a case note prior to cancellation. 
validateModify  Validates the details of a case note prior to modification. 
readRecordStatusnsread Retrieves the current status of the case note. 
insertinsertAUTO_ID: caseNoteID
PRE_DATA_ACCESS: yes
Inserts the details of a case note. 
modifyCaseAndNotensmodifyOPTIMISTIC_LOCKING: yes
PRE_DATA_ACCESS: yes
Modifies the details of a case note. 
readCaseIDAndNoteIDnsread Retrieves the case id and sensitivity code of the note specified in the key. 
read  @superseded - replaced by readNote 
modify  @superseded - replaced by modifyCaseAndNote 
readCaseIDnsread Read case ID by case note ID. 
readNoteForExternalUserns @deprecated - replaced by {@link #readNoteForExternalUser1()} @deprecated-since Version 6.0SQL
modify1  Modifies the details of a case note. 
readNote1ns Retrieves the details of a case noteSQL
searchByCaseID1nsmulti Retrieves a list of case notes for a case.SQL
readNoteForExternalUser1ns  SQL
searchByNoteIDnsmulti Retrieves a list of case notes the note is associated to.SQL
Related Pages (309)
Acknowledge Receipts (Appeal_acknowledgeReceipts)
Acknowledge Receipts (Appeal_acknowledgeReceiptsAppellant)
Add Case to Hearing Case (Appeal_addHearingCase)
Add Case to Hearing Case (Appeal_addHearingCaseIC)
Add Case to Hearing Case (Appeal_addHearingCaseObject)
Add Hearing Review (Appeal_addHearingReviewCase)
Add Hearing Review (Appeal_addHearingReviewCaseIC)
Add Hearing Review (Appeal_addHearingReviewIssueCase)
Add Hearing Review (Appeal_addHearingReviewIssueCaseIC)
Add Hearing Review (Appeal_addHearingReviewObjectCase)
Add Issue to Hearing Case (Appeal_addIssueToHearingCase)
Add Issue to Hearing Review (Appeal_addIssueToHearingReview)
Add Issue to Judicial Review (Appeal_addIssueToJudicialReview)
Add Case to Judicial Review (Appeal_addJudicialReviewCase)
Add Case to Judicial Review (Appeal_addJudicialReviewCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCase)
Add Case to Judicial Review (Appeal_addJudicialReviewIssueCaseIC)
Add Case to Judicial Review (Appeal_addJudicialReviewObjectCase)
Adjourn Hearing (Appeal_adjournHearing)
Adjourn Hearing (Appeal_adjournHearingForIC)
Adjourn Hearing (Appeal_adjournHearingReview)
Approve Resolution (Appeal_approveDecision)
Cancel Appeal Hearing (Appeal_cancelHearingCase)
Cancel Hearing Case (Appeal_cancelHearingIssueCase)
Cancel Hearing Review (Appeal_cancelHearingReview)
Cancel Judicial Review (Appeal_cancelJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview)
Close Judicial Review (Appeal_closeJudicialReview1)
Confirm Location Hearing (Appeal_confirmExternalLocationHearingIC)
Confirm Hearing Review (Appeal_confirmHearing_HearingReviewForIC)
Confirm Hearing Review (Appeal_confirmHearingReviewHearing)
Confirm Hearing Review (Appeal_confirmHearingReviewHearingForIC)
Confirm Home Hearing (Appeal_confirmHomeHearing)
Confirm Home Hearing (Appeal_confirmHomeHearingIC)
Confirm Home Hearing (Appeal_confirmHomeHearingType)
Confirm Home Hearing (Appeal_confirmHomeHearingTypeIC)
Confirm Location Hearing (Appeal_confirmIssueExternalLocationHearingIC)
Confirm Location Hearing (Appeal_confirmIssueLocationHearingIC)
Confirm Location Hearing (Appeal_confirmLocationHearing)
Confirm Location Hearing (Appeal_confirmLocationHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearing)
Confirm Phone Hearing (Appeal_confirmPhoneHearingIC)
Confirm Phone Hearing (Appeal_confirmPhoneHearingType)
Confirm Phone Hearing (Appeal_confirmPhoneHearingTypeIC)
Confirm Reschedule External Location Hearing (Appeal_ConfirmReScheduleExternalLocationHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearing)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleHearingReviewHearingForIC)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearing)
Confirm Reschedule Home Hearing (Appeal_confirmRescheduleHomeHearingIC)
Confirm Reschedule Location Hearing (Appeal_confirmRescheduleLocationHearing)
Reschedule Hearing (Appeal_confirmRescheduleLocationHearingIC)
Confirm Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearing)
Reschedule Telephone Hearing (Appeal_confirmReschedulePhoneHearingIC)
Confirm Reschedule Hearing Review Hearing (Appeal_confirmRescheduleReviewHearingDateTimeForIC)
Continue Hearing (Appeal_continueHearing)
Continue Hearing (Appeal_continueHearingReviewHearing)
New Appellant (Appeal_createAppellant)
New Hearing (Appeal_createHearingCaseMultipleCases)
New Hearing (Appeal_createHearingCaseMultipleCasesIC)
New Hearing (Appeal_createHearingCaseObjectMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCases)
New Hearing Review (Appeal_createHearingReviewMultipleCasesIC)
New Hearing Review (Appeal_createHearingReviewObjectMultipleCases)
New Interpreter (Appeal_createInterpreter)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCases)
New Hearing Case (Appeal_createIssueHearingCaseMultipleCasesIC)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCases)
New Hearing Review (Appeal_createIssueHearingReviewMultipleCasesIC)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCases)
New Judicial Review (Appeal_createIssueJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewMultipleCases)
New Judicial Review (Appeal_createJudicialReviewMultipleCasesIC)
New Judicial Review (Appeal_createJudicialReviewObjectMultipleCases)
New Case Appeal (Appeal_createProductAppeal)
Attach Statement (Appeal_createStatement)
New Third Party (Appeal_createThirdParty)
New Witness (Appeal_createWitness)
New Case Appeal (Appeal_createWizard)
Remove Appellant (Appeal_deleteAppellant)
Edit Hearing Representative Fee (Appeal_IC_modifyHearingReviewRepresentativeFee)
Edit Fee (Appeal_IC_modifyRepresentativeFee)
Notes (Appeal_listHearingCaseIssueNoteForIC)
Notes (Appeal_listHearingCaseNote)
Notes (Appeal_listHearingCaseNoteForIC)
Notes (Appeal_listHearingReviewIssueNoteForIC)
Notes (Appeal_listHearingReviewNote)
Notes (Appeal_listHearingReviewNoteForIC)
Notes (Appeal_listJudicialReviewIssueNoteForIC)
Notes (Appeal_listJudicialReviewNote)
Notes (Appeal_listJudicialReviewNoteForIC)
Edit Appeal Case Closure Details (Appeal_modifyClosureDetails)
Edit Hearing Representative Fee (Appeal_modifyRepresentativeFee)
Edit Witness (Appeal_modifyWitnessFromList)
Edit Witness (Appeal_modifyWitnessFromListIC)
Edit Witness (Appeal_modifyWitnessFromView)
Edit Witness (Appeal_modifyWitnessFromViewIC)
New Case Appeal (Appeal_newCaseAppeal)
New Appeal (Appeal_nextStageAppeal)
Remove Third Party (Appeal_removeThirdParty)
Reschedule Desk-Based Hearing (Appeal_rescheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleDeskHearing)
New Desk-Based Hearing (Appeal_scheduleIssueDeskHearing)
Submit Resolution (Appeal_submitDecision)
Reject Appealed Case (AppealedCase_rejectCase)
New Program Appeal (AppealWizard_createAppeal)
New Determination Appeal (AppealWizard_DeterminationCreateAppeal)
New Pro Forma Communication (Application_createProFormaCommunication)
Add Note: (AssessmentDelivery_addFactorNote)
Notes (AssessmentDelivery_listNote)
Add Note: (AssessmentDelivery_updateFactorNote)
Sample Benefit Home (BenefitSample_home)
Notes (BenefitSample_listNote)
Home (BenefitSampleOverpayment_home)
Notes (BenefitSampleOverpayment_listNote)
Delete Note (Case_cancelNote)
New Email Communication (Case_createEmailCommunication)
New Free Form Communication (Case_createFreeFormCommunication)
New Note (Case_createNote)
New Note (Case_createNote1)
Create Pro Forma Communication: (Case_createProForma)
New Pro Forma Communication (Case_createProFormaCommunication)
New Pro Forma Communication (Case_createProFormaCommunication1)
New Referral (Case_createReferral)
Edit Note (Case_modifyNoteFromList)
Edit Note (Case_modifyNoteFromView)
Edit Referral (Case_modifyReferralFromList)
Edit Referral (Case_modifyReferralFromView)
Record Communication (Case_recordCommunication)
View Attachment (Case_viewAttachment)
Issue Home (Case_viewIssuesTransaction)
View Note: (Case_viewNote)
View Note (Case_viewNote1)
Note (Case_viewNoteModal)
View Note: (Case_viewNoteTransaction)
Home (CashAssistance_productDeliveryHome)
Home (CHIPPremiums_productHome)
Notes (CHIPPremiumsProduct_listNote)
Add Member (CHIPProduct_addAssistanceGroupMember)
Add Member (CHIPProduct_addBenefitGroupMember)
Confirm Benefit Group Member (CHIPProduct_confirmAddBenefitGroupMember)
Assistance (CHIPProduct_listAssistanceGroupMember)
Assistance (CHIPProduct_listBenefitGroupMember)
Notes (CHIPProduct_listNote)
Remove Member (CHIPProduct_removeAssistanceGroupMember)
Remove Member (CHIPProduct_removeBenefitGroupMember)
Modify Case Closure (CHIPProductDelivery_modifyClose)
Reactivate Case (CHIPProductDelivery_reactivate)
Suspend Case (CHIPProductDelivery_suspend)
View Case Closure (CHIPProductDelivery_viewClose)
Notes (CommonIntake_listApplicationCaseNotes)
Home (CREOLECA_productDeliveryHome)
Home (CREOLEFA_productDeliveryHome)
Home (CREOLEMA_productDeliveryHome)
Notes (DecisionAssistApplication_listNoteNoCOC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceAC)
Notes (DecisionAssistApplication_listNoteNoCOCMultiSourceMC)
Notes (DecisionAssistApplication_listNoteNoCOCSingleSource)
Notes (DecisionAssistApplication_listNoteWithCOC)
Home (DefaultIC_home)
Related Cases (DefaultIC_listCaseRelationship)
Notes (DefaultIC_listNote)
Home (DefaultICProduct_home)
Notes (DefaultICProduct_listNote)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (ExternalParty_confirmModifyPrintForProFormaCommunication1)
Edit External Party (ExternalParty_modifyExternalParty)
Edit Pro Forma Communication (ExternalParty_modifyProFormaCommunicationFromView1)
Register External Party (ExternalParty_register)
Cancel Payment (Financial_cancelPayment)
Cancel Payment (Financial_cancelPayment1)
Cancel Issued Payment (Financial_cancelPaymentInstrument)
Reverse Instruction (Financial_createInstructionReversal)
Reverse Details (Financial_createLineItemReversal)
Invalidate Payment (Financial_invalidatePayment)
Home (FoodStamps_productDeliveryHome)
Home (HCRChildrenHealthInsurancePlan)
Home (HCREmergencyMedicaidHome)
Home (HCREmployerSponsoredInsuraceHome)
Home (HCRExemptionHome)
Home (HCRIC_home)
Home (HCRInsuranceAssistance)
Check Retroactive Medicaid Eligibility (HCRRetroactiveMedicaid_confirmCheckEligibilty)
Home (HCRStateBasicHealthPlanPDHome)
Home (HCRUnassistedQualifiedHealthPlanHome)
Home (ICBenefitUnderPayment_home)
Notes (ICBenefitUnderPayment_listNote)
Home (ICInvestigationSample_home)
Notes (ICInvestigationSample_listNote)
Home (ICProductSample_home)
Notes (ICProductSample_listNote)
Notes (ICSample_listNote)
Notes (ICSampleSportingGrant_listNote)
Home (ICSportingGrantSample_home)
Notes (ICSportingGrantSample_listNote)
Confirm Appointment: (IncomeScreening_confirmAppointment)
Notes (IncomeScreening_listNote)
Close Case: (IncomeSupportScreening_close)
Confirm Appointment: (IncomeSupportScreening_createAppointment)
Eligibility Summary Communication: (IncomeSupportScreening_generateEligibilitySummaryComm)
Notes: (IncomeSupportScreening_listNote)
New Program Appeal (IntakeAppealWizard_createAppeal)
New Referral (IntegratedCase_createReferral)
Edit Referral (IntegratedCase_modifyReferralFromList)
Edit Referral (IntegratedCase_modifyReferralFromView)
- (Investigation_homeTabDetails)
Investigation_homeTabDetailsPreview
Close Investigation (InvestigationDelivery_close)
Change Closure Details (InvestigationDelivery_modifyClose)
View Case Closure (InvestigationDelivery_viewClose)
Home (InvestigationSample_home)
Notes (InvestigationSample_listNote)
Cancel Sanction (ISP_cancelSanctionEvidence)
Cancel Disregard (ISP_cancelSanctionOverride)
Retroactive Program Summary (ISP_createRetroactiveProgram)
New Sanction (ISP_createSanctionEvidence)
New Disregard (ISP_createSanctionOverride)
Notes (ISP_listNote)
Edit Sanction (ISP_modifySanctionEvidence_fromList)
Edit Sanction (ISP_modifySanctionEvidence_fromView)
Edit Disregard (ISP_modifySanctionOverride_fromList)
Modify Sanction Override Details: (ISP_modifySanctionOverride_fromView)
Case Home (ISP_productHome)
Deny Spend Down Period (ISP_reasonSpendDownNotMet)
Check Retroactive Medical Assistance Eligibility (ISPCheckRetroactiveEligibilityPDHomeFromMenu)
Notes (ISPListNote)
Notes (ISPProduct_listNote)
Close Case (ISPSpendDown_closeProgram)
Medical Assistance with Spend Down Program Summary (ISPSpendDown_createProgram)
Create Program (ISPSpendDown_createRetroactiveProgram)
Reuse Program (ISPSpendDown_reuseProgram)
Reuse Program (ISPSpendDown_reuseRetroactiveProgram)
Notes (ISPSpendDownProduct_listNote)
Home (IssueDelivery_home)
Issue Home (IssueDelivery_homeForAppeal)
Notes: (IssueDelivery_listNote)
Notes (IssueDelivery_listNote1)
Notes (IssueDelivery_listNoteForAppeal)
Change Closure Details (IssueDelivery_modifyClosureDetails)
Issue Closure Details (IssueDelivery_viewClosureDetails)
Issue Closure Details (IssueDelivery_viewClosureDetailsViewOnly)
Notes (LegalAction_listNote)
Schedule Hearing (LegalAction_scheduleHearing)
Liability Overbilling Home (LiabilityOverbilling_home)
Notes (LiabilityOverbilling_listNote)
Sample Liability Home (LiabilitySample_home)
Notes (LiabilitySample_listNote)
Sample Liability Home: (LiabilitySample_tabDetails)
Notes (LIFCProduct_listNote)
Notes (LTCProduct_listNote)
Notes (MAMProduct_listNote)
Notes (OutcomePlan_listNotes)
New Note (OutcomePlanFactor_addNote)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmModifyPrintForProFormaCommunication1)
Preview Pro Forma Communication (Participant_confirmPreviewForProFormaCommunication)
Print Pro Forma Communication (Participant_confirmPrintForProFormaCommunication)
New Free Form Communication (Participant_createFreeFormCommunication)
Reverse Line Item (Participant_createLineItemReversal)
New Pro Forma Communication (Participant_createProFormaCommunication)
New Pro Forma Communication (Participant_createProFormaCommunication1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromList1)
Edit Pro Forma Communication (Participant_modifyProFormaCommunicationFromView1)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromList)
Edit Pro Forma Communication (Participant_modifySentProFormaCommunicationFromView)
View Pro Forma Communication (Participant_viewProFormaCommunication)
Home (PaymentCorrection_home)
Notes (PaymentCorrection_listNote)
Benefit Underpayment Home (PDBenefitUnderPayment_home)
Notes (PDBenefitUnderPayment_listNote)
Edit Case Closure (ProductDelivery_modifyClose)
Case Closure Details (ProductDelivery_pendingClosureDetailsTransaction)
Reactivate Case (ProductDelivery_reactivate)
Reassess (ProductDelivery_reassessBenefit)
View Case Closure (ProductDelivery_viewClose)
View Case Closure (ProductDelivery_viewCloseInline)
View Case Closure (ProductDelivery_viewCloseViewOnly)
Notes: (ProviderInvestigation_listNote)
Home (ProviderManagement_investigationHome)
- (ProviderManagement_viewProviderInvestigationTabDetails)
Notes (RefugeeProduct_listNote)
Register External Party (RegisterExternalParty_registerWizard)
New Disregard (SanctionAssessment_createDisregard_CREOLE)
New Sanction (SanctionAssessment_createSanction_CREOLE)
Edit Sanction (SanctionAssessment_modifySanction)
Edit Recommendation Disregard (SanctionAssessment_modifySanctionOverride)
Close Case (Screening_closeCase)
Clone Service Plan (ServicePlanDelivery_clone)
Close Service Plan (ServicePlanDelivery_close)
Notes (ServicePlanDelivery_listNote)
Modify Plan Closure Details (ServicePlanDelivery_modifyClose)
Modify Plan Closure Details (ServicePlanDelivery_modifyClose1)
Close Service Plans (ServicePlanGroupDelivery_close)
Print Pro Forma Communication (SocalEnterpriseFolder_confirmPrintProFormaCommunication)
Delete Note (SocialEnterpriseFolder_cancelNote)
New Note (SocialEnterpriseFolder_createNote)
New Pro Forma Communication (SocialEnterpriseFolder_createProFormaCommunication)
Notes (SocialEnterpriseFolder_listCaseNote)
Notes (SocialEnterpriseFolder_listNote)
Edit Note (SocialEnterpriseFolder_modifyNoteFromList)
Edit Note (SocialEnterpriseFolder_modifyNoteFromView)
Edit Pro Forma Communication (SocialEnterpriseFolder_modifyProFormaCommunication)
Modify Pro Forma Communication: (SocialEnterpriseFolder_modifyProFormaCommunicationFromView)
View Note: (SocialEnterpriseFolder_viewNote)
Home (StreamlinedMedicaid_home)
Notes (TBBCC_listNote)
Modify Case Closure (TBBCCProductDelivery_modifyClose)
Reactivate Case (TBBCCProductDelivery_reactivate)
Suspend Case (TBBCCProductDelivery_suspend)
View Case Closure (TBBCCProductDelivery_viewClose)