Table Description
Report User Link: Details of a report that can be recorded for an organization.

Reports are created for the organization and can be associated with a users users and Security Role security role. When a user logs into the system, any report can associated with their role and can be displayed on their favorite list of reports at their home page.

Example

For example, an administrator may decide for a case worker security role a report called CR7 may be available, so he creates a link between a case worker and the report. So a caseworker users always have access to this report and possible to add it to the favorite list of documents on the home page.

"
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::Service Layer::Report User Link::Entity::ReportUserLink
Controlling File: core\model\Packages\Reference Model\Service Layer\Report User Link\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (4)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
dateCreateddetails  CURAM_DATE SVR_DATE
reportUserLinkIDkeyno REPORT_USER_LINK_ID SVR_INT64
userIDdetailsno USER_ID SVR_INT64
reportIDdetailsno REPORT_ID SVR_INT64
Foreign Keys (2)
ChildParent
ReportUserLink.reportIDReport.reportID
ReportUserLink.userIDUserLink.userID
Indices (2)
Index NameAttributes
RptUsrLnkIdxuserID
IND__1918627083reportID
Operations (7)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: reportUserLinkID
PRE_DATA_ACCESS: yes
Inserts a report into user's favorite list. 
readread Reads a user report link record. 
removeremove Removes a quick link security role link record. 
searchUsersByReportIDnsmulti Retrieves a list of user for a report.SQL
searchByReportIDUserIDnsmulti Retrieves user's report detailsSQL
searchByUsernsmulti Retrieves a list of reports for a user.SQL
searchUnassociatedReportForUsernsmulti Retrieves a list of unassociated reports for a user.SQL
Related Pages (4)