PCD Business Component Calculated Fields

The following table describes the calculated fields that apply to PCD business components.

Calculated Fields for PCD Business Components

Business component	Calculated Field	Values	Description
LS Admin Messaging Plans	CanLoadInDetailer	IIF (([Max Version Num] = [Version] AND [Product Owner Id] = LoginId() AND [HasInactiveMessages] = "N" AND [IsVerified] = "Y"),'Y','N')	Messaging plans can be loaded in to the PCD Viewer if the messaging plan: Is the highest, active version. Does not have inactive messages. Is verified.
LS Admin Messaging Plans	CanLoadInPlanner	Y	Load all messaging plans into PCD Planner, that is the Create Messaging Plan window.
LS Admin Messaging Plans	IsVerified	IIF (Count(VerificationFailedMessages) greater than 0,"N","Y")	If messaging plan has verification failed presentation items, set verification status to failed. That is, IsVerified is equal to N.
LS MP Items	IsVerified	IIf([Verification Status] = LookupValue('VERIFICATION_ STATUS','Successful') AND [IsSupportedFormat] = "Y" AND [IsRelatedContentVerified] = "Y" AND [IsDetailContentVerified] = "Y",'Y','N')	If the verification status (obtained from the join to the S_LIT_LSX table) of Message is Successful, and Message is of supported file type, and all the related and detail content associated with this presentation item is verified, then for this presentation item IsVerified is equal to Y.
LS MP Items	IsSupportedFormat	IIF(([LitFileExt] = 'SWF' OR [LitFileExt] = 'swf' OR [LitFileExt] = 'jpg' OR [LitFileExt] = 'JPG' OR [LitFileExt] = 'GIF' OR [LitFileExt] = 'gif' OR [LitFileExt] = 'png' OR [LitFileExt] = 'PNG'), 'Y','N')	Checks if the file type of the presentation item is supported.
LS MP Items	IsDetailContentVerified	IIF (Count(Verified Detail Content) is greater than 0,"N","Y")	Checks if all detail content associated with the presentation item is verified.
LS MP Items	IsRelatedContentVerified	IIF (Count(Verified Related Content) is greater than 0,"N","Y")	Checks if all related content associated with presentation item is verified.
LS Detail Messages	IsVerified	IIf([Verification Status] = LookupValue('VERIFICATION_ STATUS','Successful')AND [IsSupportedFormat] = "Y" ,'Y','N')	If the verification status (obtained from the join to the S_LIT_LSX table) of Message is Successful, and Message is of supported file type, then for this related item IsVerified is equal to Y.
LS Detail Messages	IsSupportedFormat	IIF(([LitFileExt] = 'SWF' OR [LitFileExt] = 'swf' OR [LitFileExt] = 'jpg' OR [LitFileExt] = 'JPG' OR [LitFileExt] = 'GIF' OR [LitFileExt] = 'gif' OR [LitFileExt] = 'png' OR [LitFileExt] = 'PNG'), 'Y','N')	Checks if the file type is supported.
LS Related Messages	IsVerified	IIf([Verification Status] = LookupValue('VERIFICATION_STATUS', 'Successful') AND [IsSupportedFormat] = "Y" ,'Y','N')	If the verification status (obtained from the join to the S_LIT_LSX table) of Message is Successful, and Message is of a supported file type, then for this related item, IsVerified is equal to Y.
LS Related Messages	IsSupportedFormat	IIF(([LitFileExt] = 'SWF' OR [LitFileExt] = 'swf' OR [LitFileExt] = 'jpg' OR [LitFileExt] = 'JPG' OR [LitFileExt] = 'GIF' OR [LitFileExt] = 'gif' OR [LitFileExt] = 'png' OR [LitFileExt] = 'PNG'), 'Y','N')	Checks if the file type is supported.
Admin Sales Tool	CanLoadInPlanner	IIF (([Sales Tool Type] = LookupValue ("SALES_TOOL_TYPE", "Message") AND [IsActive] = "Y" AND [IsSupportedFormat] = "Y"),'Y','N')	Literature item can be loaded in PCD Planner if: The type is equal to Message. Is active (release date is before or is today’s date and is before the expiration date). Is of supported file type.
Admin Sales Tool	CanLoadInDetailer	IIF (([Sales Tool Type] = LookupValue ("SALES_TOOL_TYPE", "Message") AND [IsSupportedFormat] = "Y"),'Y','N')	Literature Item can be verified if type is equal to Message and is of supported file type.
Admin Sales Tool	IsSupportedFormat	IIF(([LitFileExt] = 'SWF' OR [LitFileExt] = 'swf' OR [LitFileExt] = 'jpg' OR [LitFileExt] = 'JPG' OR [LitFileExt] = 'GIF' OR [LitFileExt] = 'gif' OR [LitFileExt] = 'png' OR [LitFileExt] = 'PNG'), 'Y','N')	Checks if the file type is supported.