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.

* VSCALC-CUSTOM-ATTR: Custom attribute code to create SD files needed for member attributes.
* (c) Copyright Vital Soft, 2007-2009
* ===================================

<< Create a file that will hold service entries for all Member Level Flags >>

NEWREG MBRSRVS1:X100
MAKETEMP #MBRSRVS1

FIND PRIMARY=MEMBER-FILE;OUTSEL=(@);
%VS-ACTIVE-MBR
END

SAVE
OUT=#MBRSRVS1, SD, DELETE, OPEN

S1, MEMBER-FILE.ACCOUNT
NEWREG MBR-ACTIVE-SRVC-CNT:I2
#MBR-ACTIVE-SRVC-CNT = 0, G1
<< Count the Services for
   Online Banking   : cf(61)=1
   Direct Deposit   : cf(71)=1
   E-Statements     : cf(76)=1
   Add More As Needed >>
#MBR-ACTIVE-SRVC-CNT = #MBR-ACTIVE-SRVC-CNT + 1, if (MEMBER-FILE.CONTROL-FLAGS(61)=1)
#MBR-ACTIVE-SRVC-CNT = #MBR-ACTIVE-SRVC-CNT + 1, if (MEMBER-FILE.CONTROL-FLAGS(71)=1)
#MBR-ACTIVE-SRVC-CNT = #MBR-ACTIVE-SRVC-CNT + 1, if (MEMBER-FILE.CONTROL-FLAGS(76)=1)
T1, MEMBER-FILE.ACCOUNT, TAB1
T1, #MBR-ACTIVE-SRVC-CNT, TAB2
END

<< Create a file that will hold debit card counts for all members >>

FIND PRIMARY=MEMBER-FILE;OUTSEL=(@);
%VS-ACTIVE-MBR AND
ATM-FILE.TYPE-CODE = "D" AND 
ATM-FILE.MEMBER-STATUS = 1
END
SAVE
OUT=#MBRSRVS1, SD, APPEND, OPEN
S1, MEMBER-FILE.ACCOUNT
NEWREG MBR-ACTIVE-SRVC-CNT:I2
#MBR-ACTIVE-SRVC-CNT = 0, G1
#MBR-ACTIVE-SRVC-CNT = #MBR-ACTIVE-SRVC-CNT + 1, T1
T1, MEMBER-FILE.ACCOUNT, TAB1
T1, #MBR-ACTIVE-SRVC-CNT, TAB2
END

NEWREG MBRSRVS:X100
MAKETEMP #MBRSRVS

find primary=MBRSRVS1.MBRSRVS1;
end

SAVE
OUT=#MBRSRVS, SD, DELETE, OPEN
S1, MBRSRVS1.MBRSRVS1.ACCOUNT
T1, MBRSRVS1.MBRSRVS1.ACCOUNT,TAB1
T1, MBRSRVS1.MBRSRVS1.MBR-ACTIVE-SRVC-CNT, TAB2, COUNT
END

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 :
*
*
<< 3 or more services >>
#ATTR(1)=( (MBRSRVS.MBR-ACTIVE-SRVC-CNT >= 3 OR SHLNTOTS.MBR-ACTIVE-SH-CNT >= 3 OR SHLNTOTS.MBR-ACTIVE-LN-CNT >= 3) OR
           (MBRSRVS.MBR-ACTIVE-SRVC-CNT = 2 AND (SHLNTOTS.MBR-ACTIVE-SH-CNT = 1 OR SHLNTOTS.MBR-ACTIVE-LN-CNT = 1)) OR
           (MBRSRVS.MBR-ACTIVE-SRVC-CNT = 1 AND (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 AND SHLNTOTS.MBR-ACTIVE-LN-CNT = 1) OR
           (SHLNTOTS.MBR-ACTIVE-SH-CNT = 1 AND SHLNTOTS.MBR-ACTIVE-LN-CNT = 2) OR
           (SHLNTOTS.MBR-ACTIVE-SH-CNT = 2 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.

Example of the Modified ATTRFILE

NBR__IDX__CNT__PRIMARY.TOPIC_________________INCLUDE___FIELD-NAME__________Attribute Description_________X
1    1         SHLNTOTS.SHLNTOTS             ITOTATTR  SINGLE-SERVICE      Single Service                X
2    1         MEMBRS.SHARE-FILE             ISHRATTR  ACCT-FUNDED         Sfx 0 Funded                  X
3    1         MEMBRS.MEMBER-FILE            IMBRATTR  EMPLOYEE            Employee                      X
4    2         MEMBRS.MEMBER-FILE            IMBRATTR  CHGOFF              Charged Off                   X
5    3         MEMBRS.MEMBER-FILE            IMBRATTR  OK-TO-MAIL          OK to Mail                    X
6    1         MBRSRVS.MBRSRVS               ICUSATTR  TRIPLE-SERVICE      Three or more Services        X

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