Creating Custom Attributes

Summary

This document will present in detail how Custom Member Attributes can be created in Vital Signs. The following files will be modified on HPUX: - /ASKPLUS/vsdata/scripts/VSCALC-CUSTOM-ATTR - /ASKPLUS/vsdata/custom/live/ICUSATTR - /ASKPLUS/vsdata/custom/live/ATTRFILE - /ASKPLUS/vsdata/custom/live/vsmacdef

Gather Required Criteria

The first step in creating an Attribute is to know precisely the criteria for the attribute and the datasets involved. For this example we want to report members who have 3 or more Services.

There already exists a common count of active shares and loans from

Modify VSCALC-CUSTOM-ATTR

On HPUX in /ASKPLUS/vsdata/scripts exists a file named VSCALC-CUSTOM-ATTR. The Custom Attribute scripting will be handled within this file. The end result should be an SD or SD Indexed file that contains fields that will be available to query in the ICUSATTR file.

Modify ICUSATTR FILE

This file will contain the Attribute criteria based on the SD file built in VSCALC-CUSTOM-ATTR.

* Calculate Custom MEMBER-FILE Attributes :
*
*
<< 2 or more Services >>
#ATTR(1)=( (MBRSRVS.MBR-ACTIVE-SRVC-CNT >= 2 OR SHLNTOTS.MBR-ACTIVE-SH-CNT >= 2 OR SHLNTOTS.MBR-ACTIVE-LN-CNT >= 2) OR
           (MBRSRVS.MBR-ACTIVE-SRVC-CNT = 1 AND (SHLNTOTS.MBR-ACTIVE-SH-CNT = 1 OR SHLNTOTS.MBR-ACTIVE-LN-CNT = 1)) OR
           (SHLNTOTS.MBR-ACTIVE-SH-CNT = 1 AND SHLNTOTS.MBR-ACTIVE-LN-CNT = 1) )

Modify ATTRFILE

Now that the Attribute has been setup, the ATTRFILE must be updated so that the new Attribute is available in Vital Signs.

Enable Custom Attribute Macro

Once the custom attribute files are all in place and updated, the Vital Signs custom macro must be turned on.

This macro is named Macro VS-CUSTOM-ATTR-XEQ and is found in /ASKPLUS/vsdata/custom/live/vsmacdef.

Example of macro enabled:

** The following Macro is only set to 1 if custom code is to be used for this specific client.
** Custom code is added to the /ASKPLUS/vsdata/scripts/VSCALC-CUSTOM-ATTR
** Macro VS-CUSTOM-ATTR-XEQ = 1
Macro VS-CUSTOM-ATTR-XEQ = 1

Verify Attributes

To verify the attributes, a full EOM extract should be run. Once it has finished, login to Vital Signs and review the Membership_Analysis_by_ACCOUNT application Mbr Attributes tab. If the attributes look correct, go ahead and run the Daily extract or wait for the evening run.

EOM example :

Note that the CCCYYMMDD should be the last day of the prior month

login bolive
cd /var/summit/spectrum/live
/VSJOBS/JVSLOAD_MBRSHLN eom CCYYMMDD

Example Daily:

login bolive
cd /var/summit/spectrum/live
/VSJOBS/JVSLOAD_MBRSHLN