D:AdministrationCaseRole

Table Description

Administration Case Role: The assignment of administration personnel to a case.

This includes the case owner and the case users as they work on a case.

Technical Notes

Please Note: This entity is no longer part of the default flow in the Curam Application, as such it is neither written to nor read from by the Curam Application. It continues to be shipped with the Curam model as customer may have custom logic which uses this entity, however it should be noted that if you are implementing custom logic which references this entity then you must also ensure that it is written to as needed. The information that was originally stored in this entity is now stored in case user role.

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::Case::Entity Objects::AdministrationCaseRole::AdministrationCaseRole
Controlling File:	core\model\Packages\Case\Administration Case Role_cat.efx

Table Options

ALLOW_OPTIMISTIC_LOCKING

yes

Attributes (9)

Attribute	Stereotype	Nullable	Description	Domain Definition	Codetable	DDL Type
caseID	details	no	CaseID of the case in respect of which this AdministrationCaseRole was entered	CASE_ID		SVR_INT64
userName	details	no	UserName of the User in respect of which this AdministractionCaseRole was entered	USER_NAME		SVR_STRING<64>
startDate	details		Date on which case administration by a Case Administrator commenced	CURAM_DATE		SVR_DATE
endDate	details		Date on which case administration by a Case Administrator ceased	CURAM_DATE		SVR_DATE
typeCode	details		Code value to denote the case administration type provided by the User.	CASE_ADMIN_TYPE_CODE	CaseAdminTypeCode	SVR_STRING<10>
statusCode	details		Code value to denote the status of the Case Administration for a Case Administrator.	CASE_ADMIN_STATUS_CODE	CaseAdminStatusCode	SVR_STRING<10>
reasonCode	details		Code value to explain why the Case has been reassigned to a new owner.	CODETABLE_CODE		SVR_STRING<10>
comments	details		Free text that can be added when a Case is being reassigned to a new owner.	COMMENTS		SVR_STRING<300>
administrationCaseRoleID	key	no	Unique reference number assigned by the system to this AdministrationCaseRole	ADMIN_CASE_ROLE_ID		SVR_INT64

Foreign Keys (2)

Child	Parent
AdministrationCaseRole.caseID	CaseHeader.caseID
AdministrationCaseRole.userName	Users.userName

Indices (3)

Index Name	Attributes
AdminCaseRoleIndex	caseID
AdminCRUserIdx	userName
usrStatTypeIdx	userName, caseID, statusCode, typeCode

Operations (14)

Operation	Stereotype	Options	Description	SQL
insert	insert		Standard Operation
modify	modify	OPTIMISTIC_LOCKING: yes	Standard Operation
read	read		Standard Operation
searchByCaseID	readmulti		returns a list of all matching Administration case roles
updateCaseRoleByStatus			Method that updates all administration case roles with a status of PENDING or ACTIVE for a specific case identifier
searchByCaseStatusType	readmulti		Method that is used to retrieve a single admin case role record based on case identifier, status and role type.
readByUserName	nsread		returns a single admin. role based on case ID, user name, role status and role type
searchByUserAndStatus	readmulti		returns a list of roles based on a user name and role status
searchByUserName	readmulti		returns all admin roles for a user
searchByUserStatusAndEndDate	nsmulti		returns list of admin case roles by user ID, type code and end date	SQL
readByCaseStatusType	nsread		Method that retrieves a single admin case role record based on case identifier, status and role type.
modifyByCaseIDAndStatus	nsmodify	OPTIMISTIC_LOCKING: yes	This method updates the Administration Case Roles for a given case, of a given status. To have a new status and set the end date.
searchByCaseRoleAndStatus	nsmulti		Method that reads all administration case roles for the specified case identifier and status values.	SQL
modifyCaseIDAndStatus	nsmodify	OPTIMISTIC_LOCKING: no	This method updates the status and end date of specified Administration Case Role.

Related Pages (0)

Database Table: AdministrationCaseRole