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.
• Contains a Product that is in the personal list of the sales representative.
• Does not have inactive messages.
• Is verified.

CanLoadInPlanner

Y

Load all messaging plans into PCD Planner, that is the Create Messaging Plan window.

IsVerified

IIF (Count(VerificationFailedMessages) >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.

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.

IsDetailContentVerified

IIF (Count(Verified Detail Content) > 0,"N","Y")

Checks if all detail content associated with the presentation item is verified.

IsRelatedContentVerified

IIF (Count(Verified Related Content) > 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.

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.

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.

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.

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.