business logic query BusCompByRole

Description

Input RoleID and BusComponent.
Give all activities on this Component for this role

iiRole_ID	integer
icBusComponentCode	character

each BusComponent where

BusComponent.BusComponentCode = icBusComponentCode

each BusActivity (inner-join) where

BusActivity.BusComponent_ID = BusComponent.BusComponent_ID AND

each Resources (inner-join) where

Resources.BusActivity_ID = BusActivity.BusActivity_ID AND

each RoleResource (inner-join) where

RoleResource.Resource_ID = Resources.Resource_ID AND
RoleResource.Role_ID = iiRole_ID

field name	data type	db field	description
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tlBusActivityDisableForWF	logical	BusActivity.BusActivityDisableForWF	Flag indicates if the activity should be disabled when the database object to perform the activity on is in external control (external workflow).
tlBusActivityIsDefault	logical	BusActivity.BusActivityIsDefault	Default
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tiRole_ID	integer	RoleResource.Role_ID	Role
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(BusComponent),rowid(BusActivity),rowid(Resources),rowid(RoleResource)

BLF