business logic query WorkClassByDescr

Parameters

icWorkClassDescription

character

each WorkClass where

WorkClass.WorkClassDescription = icWorkClassDescription

first BusActivity (conditional-join) where

BusActivity.BusActivity_ID = WorkClass.BusActivity_ID AND

first BusComponent (conditional-join) where

BusComponent.BusComponent_ID = WorkClass.BusComponent_ID AND

first ObjectFlexStatus (conditional-join) where

ObjectFlexStatus.ObjectFlexStatus_ID = WorkClass.ObjectFlexStatus_ID AND

first Role (conditional-join) where

Role.Role_ID = WorkClass.Role_ID AND

first Usr (conditional-join) where

Usr.Usr_ID = WorkClass.Usr_ID AND

field name	data type	db field	description
tiBusActivity_ID	integer	BusActivity.BusActivity_ID	Record ID
tcBusActivityCode	character	BusActivity.BusActivityCode	Code
tcBusActivityLabel	character	BusActivity.BusActivityLabel	Activity
tiBusComponent_ID	integer	BusComponent.BusComponent_ID	BusComponent_ID
tcBusComponentCode	character	BusComponent.BusComponentCode	Component
tcBusComponentLabel	character	BusComponent.BusComponentLabel	Label
	api annotation:		test annotation for BusComponentLabel
tiObjectFlexStatus_ID	integer	WorkClass.ObjectFlexStatus_ID	Custom Object Status
tcObjectFlexStatusCode	character	ObjectFlexStatus.ObjectFlexStatusCode	Code
tiRole_ID	integer	WorkClass.Role_ID	Role
tcRoleName	character	Role.RoleName	Role Name
tiUsr_ID	integer	WorkClass.Usr_ID	User
tcUsrName	character	Usr.UsrName	User Name
tiWorkClass_ID	integer	WorkClass.WorkClass_ID	Record ID
tcWorkClassDescription	character	WorkClass.WorkClassDescription	Description
tcWorkClassInstruction	character	WorkClass.WorkClassInstruction	Instruction
tlWorkClassIsActive	logical	WorkClass.WorkClassIsActive	Active
tlWorkClassIsReturnToSender	logical	WorkClass.WorkClassIsReturnToSender	Return to Sender
tlWorkClassIsSendMail	logical	WorkClass.WorkClassIsSendMail	E-mail Notification
tcWorkClassScopeBusinessFld	character	WorkClass.WorkClassScopeBusinessFld	Business Field

BLF