Table Description

Fund User Role

: An assigned responsibility that a user has in respect of a fund.

An assigned responsibility that a user has in respect of a fund.

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::FundPM::Service Layer::Fund User Role::Entity::FundUserRole
Controlling File: FundPM\model\Packages\Service Layer\Fund User Role\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (9)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
fundUserRoleIDkeynoUnique reference number assigned by the system to a Fund User Role record.INTERNAL_ID SVR_INT64
fromDatedetailsnoDate on which fund administration by a Fund User Role commenced.CURAM_DATE SVR_DATE
toDatedetails Date on which fund administration by a Fund User Role ceased.CURAM_DATE SVR_DATE
typedetailsnoCode value to denote the type of the Fund User Role.FUND_USER_ROLE_TYPEFundUserRoleTypeSVR_STRING<10>
reasondetails Code table value to indicate why a user role changed.FUND_USER_ROLE_CHANGE_REASONFundUserRoleChangeReasonSVR_STRING<10>
recordStatusdetailsnoThe status of the fund user role is used to indicate if the fund user role has been logically deleted.RECORD_STATUSRecordStatusSVR_STRING<10>
commentsdetails Comments recorded by Fund Administrator relating to the fund user role.COMMENTS SVR_STRING<300>
orgObjectLinkIDdetailsnoUnique reference number assigned by the system to a Org Object Link record.ORG_OBJECT_LINK_ID SVR_INT64
programFundIDdetailsnoUnique reference number assigned by the system to a Program Fund record.INTERNAL_ID SVR_INT64
Foreign Keys (2)
ChildParent
FundUserRole.orgObjectLinkIDOrgObjectLink.orgObjectLinkID
FundUserRole.programFundIDProgramFund.programFundID
Indices (2)
Index NameAttributes
IND__533055829programFundID
IND_805398111orgObjectLinkID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: fundUserRoleID
AUTO_ID_KEY: FUNDPMKS
Inserts a Fund User Role record. 
readread Retrieves a Fund User Role record. 
searchByProgramFundAndOrgObjectLinknsreadmultiWHERE: programFundID = :programFundID and orgObjectLinkID = :orgObjectLinkID
  
removeremove Removes a Fund User Role record. 
searchByProgramFundreadmulti This method is used to fetch the fund user role records based on the program fund ID. 
modifymodifyOPTIMISTIC_LOCKING: yes
Modifies a Fund User Role record. 
Related Pages (0)