Table 49. Calculated Fields for PCD Business Components
|
|
|
|
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. |