D:HearingDecisionAttachmentLink

Table Description

Hearing Decision Attachment Link: An attachment to an appeal case decision.

Decision attachments can be either external documents or documents created internally in the system.

Example

Linda Smith applies for sickness benefit with an organization. It is calculated that Linda is entitled to $40 a week. Linda is dissatisfied with this rate of payment and submits a request for appeal to the organization. A user creates an appeal case in the system. A hearing is scheduled. When the hearing is completed, a decision is made by a hearing official on Linda's case. The hearing official creates a decision document for the case outside the system and attaches the decision document to the decision in the system.

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::Appeals::Service Layer::entity::Appeal::HearingDecisionAttachmentLink::HearingDecisionAttachmentLink
Controlling File:	Appeal\model\Packages\Service Layer\entity\Appeal\HearingDecisionAttachmentLink\hearingDecisionAttachmentLink_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (7)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
attachmentLinkID	key	no	Unique ID for the hearing decision attachment link record.	HEARING_DECISION_ATTACHMENT_LINK_ID		SVR_INT64
hearingDecisionID	details	no	Unique ID of the associated hearing decision. Links the hearing decision to the related attachment.	HEARING_DECISION_ID		SVR_INT64
attachmentID	details	no	Unique ID of the associated attachment. Links the attachment to the related hearing decision.	ATTACHMENT_ID		SVR_INT64
attachmentDate	details		Date that the decision attachment was added.	CURAM_DATE		SVR_DATE
documentTemplateID	details		Unique ID for the document template which was used to create the document. This is only relevant to documents created internally via Word integration.	DOCUMENT_TEMPLATE_ID		SVR_STRING<40>
decisionAttachmentType	details		Type of decision attachment document. A decision attachment document can be an internally created Word document or an external document.	DECISION_ATTACHMENT_TYPE_CODE	DecisionAttachmentType	SVR_STRING<10>
recordStatus	details		Status of the hearing decision attachment link record. The values are 'Active' or 'Cancelled'.	RECORD_STATUS_CODE	RecordStatus	SVR_STRING<10>

Foreign Keys (2)

Child	Parent
HearingDecisionAttachmentLink.attachmentID	Attachment.attachmentID
HearingDecisionAttachmentLink.hearingDecisionID	HearingDecision.hearingDecisionID

Indices (2)

Index Name	Attributes
IND__868550791	hearingDecisionID
IND_851534224	attachmentID

Operations (14)

Operation	Stereotype	Options	Description	SQL
insert	insert		Standard Operation
read	read		Standard Operation
searchActiveAttachmentsByDecision	nsreadmulti		@deprecated Since Curam 6.0 SP1, this method has been replaced by searchAttachmentsByDecision. Returns the list of active attachments for an appeal case.
readStatus	nsread		Returns the status of the hearing decision attachment link.
readAttachmentID	nsread		Returns the identifier for the attachment for a hearing decision attachment.
countActiveAttachmentsByDecision	ns	PRE_DATA_ACCESS: yes	Returns the number of active decision attachments for an appeal decision.	SQL
readCaseTemplateAndAttachment	ns		Returns the case identifier, the word template identifier, the template contents and the attachment identifier for a hearing decision attachment. This is intended for use when the attachment is an internally created document.	SQL
readAttachment	ns		Returns the details of the hearing decision attachment.	SQL
readAttachmentForModify	ns		Returns the details of a hearing decision attachment required for modification.	SQL
modifyStatus	nsmodify	OPTIMISTIC_LOCKING: yes	Modifies the record status for the hearing decision attachment.
readAttachmentAndDecisionID	nsread		Returns the identifier of the attachment and the identifier of the associated hearing decision.
readDateStatusAndTemplate	ns		Reads the date, status and template ID of an attachment.	SQL
readForDownload	ns		Reads the attachment name and contents for downloading.	SQL
searchAttachmentsByDecision	nsmulti		Returns the list of attachments for an appeal case.	SQL

Related Pages (54)

Add Resolution to Appealed Items (Appeal_addResolutionToAppealedItems)
Edit Document (Appeal_controlMSWord)
New Decision Attachment (Appeal_createDecisionAttachment)
New Decision Attachment (Appeal_createIssueDecisionAttachment)
Select Microsoft Word Template (Appeal_createMSWord)
Delete Decision Attachment (Appeal_deleteDecisionAttachment)
Items Under Appeal (Appeal_listItemsUnderAppeal)
Appeal Objects (Appeal_listObjectsByAppeal)
Manage Decision (Appeal_manageDecision)
Manage Decision (Appeal_manageHearingCaseDecisionDetailsForIC)
Manage Decision (Appeal_manageHearingCaseDecisionForIC)
Manage Decision (Appeal_manageHearingCaseDecisionViewOnly)
Manage Decision (Appeal_manageHearingCaseIssueDecisionForIC)
Decisions (Appeal_manageHearingReviewDecisionForIC)
Manage Decision (Appeal_manageHearingReviewDecisionViewOnly)
Manage Decision (Appeal_manageHearingReviewIssueDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewDecision)
Manage Decision (Appeal_manageJudicialReviewDecisionForIC)
Manage Decision (Appeal_manageJudicialReviewIssueDecisionForIC)
Edit Decision Attachment (Appeal_modifyDecisionAttachment)
Edit Microsoft Word Decision Attachment (Appeal_modifyInternalAttachment)
Submit Resolution (Appeal_submitDecision)
View Decision Attachment (Appeal_viewDecisionAttachment)
View Decision Attachment (Appeal_viewInternalAttachment)
Appeals (Application_listAppeals)
Items Under Appeal (Application_listItemsUnderAppeal)
ApplicationContextPanel
CAProductHomeDetails
CGISSApplicationContextPanel
CGISSApplicationContextPanel1
CHIPProductHomeDetails
CREOLECAProductHomeDetails
CREOLECHIPProductHomeDetails
CREOLEFAProductHomeDetails
CREOLEMAProductHomeDetails
FAProductHomeDetails
Appeals (ISP_listAppeals)
ISPCaseHomeDetails
New Decision Attachment (LegalAction_createDecisionAttachment)
New Microsoft Word Decision Attachment (LegalAction_createMSWord)
Delete Decision Attachment (LegalAction_deleteDecisionAttachment)
Manage Decision (LegalAction_manageDecision)
Decisions (LegalAction_manageDecision1)
Edit Decision Attachment (LegalAction_modifyDecisionAttachment)
Edit Microsoft Word Decision Attachment (LegalAction_modifyInternalAttachment)
Save Microsoft Word Decision Attachment (LegalAction_saveMSWord)
View Decision Attachment (LegalAction_viewDecisionAttachment)
View Decision Attachment (LegalAction_viewInternalAttachment)
LIFCProductHomeDetails
LTCProductHomeDetails
ProductHomeDetails
RefugeeProductHomeDetails
SpendDownProductHomeDetails
TBBCCProductHomeDetails

Database Table: HearingDecisionAttachmentLink