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