project BLF > class BRole > business logic query RoleBusActivityByActivityRole
Description
Find RoleBusActivity based on Activity-ID and Role-ID (or Code)
Parameters
| iiBusActivityID | integer | Bus Activity ID |
| iiRoleID | integer | RoleId |
| icRoleName | character | Role Name |
query condition
each RoleResource where
RoleResource.Role_ID = iiRoleID
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
Resources.BusActivity_ID = iiBusActivityID
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
Role.RoleName = icRoleName
query resultset tqRoleBusActivityByActivityRole
| field name | data type | db field | description |
|---|
| tiBusActivity_ID | integer | Resources.BusActivity_ID | Business Activity |
| tiResource_ID | integer | RoleResource.Resource_ID | Resource |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tiRole_ID | integer | RoleResource.Role_ID | Role |
| tcRoleName | character | Role.RoleName | Role Name |
| tiRoleResource_ID | integer | RoleResource.RoleResource_ID | Record ID |
| tiSODcategory_ID | integer | Resources.SODcategory_ID | Segregation of Duties Category reference |
Internal usage
BLF