business logic query RoleByNameActiveDescr

Description

RoleByNameActiveDescr; Query returning the

each Role where

Role.RoleDescription = icRoleDescription AND
Role.RoleIsActive = ilRoleIsActive AND
Role.RoleName = icRoleName

first BusComponent (outer-join) where

BusComponent.BusComponent_ID = Role.BusComponent_ID AND

field name	data type	db field	description
tiRole_ID	integer	Role.Role_ID	Record ID
tcRoleName	character	Role.RoleName	Role Name
tcRoleDescription	character	Role.RoleDescription	RoleDescription
tlRoleIsActive	logical	Role.RoleIsActive	Act
tiBusComponent_ID	integer	BusComponent.BusComponent_ID	BusComponent_ID
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tcBusComponentLabel	character	BusComponent.BusComponentLabel	Label
	api annotation:		test annotation for BusComponentLabel
tcRoleBusComponentConcept	character	Role.RoleBusComponentConcept	(unused)
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Role),rowid(BusComponent)

BLF