Table Description
Request: Details of the request created through external user access.

Details of the request created through external user access.

Example

A provider who has an external user account, can create and submit requests to update the address, payment details etc.,. through the external user access.
Model Details
Location in Model: Logical View::MetaModel::Curam::CPM::Service Layer::External User Access::Request::Entity::Request
Controlling File: CPM\model\Packages\Service Layer\External User Access\Request\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (10)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
requestIDkeynoThe unique system generated identifier for the request record.INTERNAL_ID SVR_INT64
requestCategorydetailsnoThe category to which the request belongs to. For example, 'Address Request'.REQUEST_CATEGORYRequestCategorySVR_STRING<10>
requestTypedetailsnoType of request. For example, 'Create', 'Edit' and 'Delete' Category for a Provider.REQUEST_TYPERequestTypeSVR_STRING<10>
requestStatusdetailsnoStatus of the request. For example, when the request is created, the status is 'Open'.REQUEST_STATUSRequestStatusSVR_STRING<10>
concernRoleIDdetailsyesThe unique system generated identifier for the provider record.This is the identifier for whom the request has been created.CONCERN_ROLE_ID SVR_INT64
dateCreateddetailsnoDate the request was created.CURAM_DATE SVR_DATE
dateSubmitteddetailsyesDate the request was submitted.CURAM_DATE SVR_DATE
rejectionReasondetails Reason for rejecting the request.REQUEST_REJECTION_REASON SVR_STRING<200>
commentsdetails Comments recorded by the external user relating to the request.COMMENTS SVR_STRING<300>
createdBydetails The user who created the request.USER_NAME SVR_STRING<64>
Indices (1)
Index NameAttributes
RequestConcernRoleIDIdxconcernRoleID
Operations (9)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: requestID
Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
readread Standard Operation 
searchByRequestTypeOwnerAndCreationDatensmulti Returns a list of request details based on request type, user name and creation date specified.SQL
searchByConcernRoleIDreadmultiORDER_BY: dateCreated
Retrieves a list of request details based on concern role specified. 
searchByRequestOwnerAndStatusnsmulti Returns a list of request details based on request status and user name specified.SQL
searchByRequestTypeAndOwnernsmulti Returns a list of request details based on request type and user name specified.SQL
searchByCreationDateAndOwnernsmulti Returns a list of request details based on request creation date and user name specified.SQL
searchByOwnerAndDateRangensmulti Method searches the requests between the date ranges for the owner. This is accessed by <span lang="EN-IE" style="FONT-SIZE: 11pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Calibri','sans-serif'; mso-fareast-font-family: Calibri; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-IE; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">resource manager and resource manager supervisor</span>SQL
Related Pages (4)