Table Description
Online Appeal Request: A request submitted by a citizen from the Universal Access portal to create an appeal against an eligibility decision.

This entity stores the details of the request submitted by a citizen from the citizen's account in Universal Access.

Example

A citizen has submitted a health care application but eligibility processing has deemed the citizen ineligible to use the healthcare exchange. The citizen submits a request to appeal this decision from the Universal Access citizen account.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::OnlineAppealRequest::OnlineAppealRequest
Controlling File: core\model\Packages\Reference Model\Service Layer\OnlineAppealRequest\OnlineAppealRequest.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
onlineAppealRequestIDkeynoRecord identifer.INTERNAL_ID SVR_INT64
datastoreRootEntityIDdetails Root entity ID of the assocaited datastore.INTERNAL_ID SVR_INT64
schemaNamedetailsyesThe name of the associated datastore schema.DATASTORE_SCHEMA_NAME SVR_STRING<40>
submittedDateTimedetails The date and time that the appeal request was submitted.CURAM_DATETIME SVR_DATETIME
createdBydetailsnoThe identifier of the user who created the record.INTERNAL_ID SVR_INT64
primaryAppellantIDdetailsyesThe identifier of the person selected as the primary appellant.INTERNAL_ID SVR_INT64
statusdetailsnoThe status of the record.ONLINE_APPEAL_REQUEST_STATUSOnlineAppealRequestStatusSVR_STRING<10>
attachmentIDdetailsyesThe identifier of the associated AttachmentLink record.INTERNAL_ID SVR_INT64
iegExecutionIDdetailsyesThe identifier of the associated IEG execution contextINTERNAL_ID SVR_INT64
createdDateTimedetailsnoThe date and time that the record was created.CURAM_DATETIME SVR_DATETIME
Indices (2)
Index NameAttributes
createdByIdxcreatedBy
priApplntIdxprimaryAppellantID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: onlineAppealRequestID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByCreatedByreadmulti   
searchByPrimaryAppellantreadmulti   
searchSubmittedRequestByCreatedByreadmultiORDER_BY: submittedDateTime DESC
WHERE: status != 'OARS30000' AND status != 'OARS30001' AND createdBy = :createdBy
  
searchSubmittedRequestByPrimaryAppellantreadmultiORDER_BY: submittedDateTime DESC
WHERE: status != 'OARS30000' AND status != 'OARS30001' AND primaryAppellantID = :primaryAppellantID
  
readread Standard Operation 
Related Pages (7)