Vital Signs Macro Definitions

From Vital Soft Wiki
Revision as of 18:22, 1 December 2015 by >Johno (Johno moved page Vsmacdef to Vital Signs Macro Definitions)
Jump to: navigation, search

Overview

The vsmacdef file contains macros that define criteria that makes the data extracted by Vital Signs meaningful to each specific Credit Union


Macros

Example of default vsmacdef:

 ** vsmacdef - Custom macro definitions to create VSDATA tables.  
 
 ** The following two macros are used to gather the member level credit ratings.
 ** Macro VSMBR-CALC-LN-CR = "1"
 ** Macro VSMBR-CREDIT-RATING = (LNCRSCORE.LN-LAST-CRSCORE)
 ** Macro VSMBR-CALC-LN-CR = "0" 
 ** Macro VSMBR-CREDIT-RATING = (MEMBER-FILE.CREDIT-RATING)
 Macro VSMBR-CALC-LN-CR     = "0"
 Macro VSMBR-CREDIT-RATING  = (MEMBER-FILE.CREDIT-RATING)
 
 ** The following Macro can be modified on a site to site basis for the Member Relate.
 ** CURRENT-CODE is the default value
 ** macro VS-MBR-RELATE-FLAG   = (MEMBER-FILE.DEPARTMENT)
 Macro VS-MBR-RELATE-FLAG   = (MEMBER-RELATE.CURRENT-CODE)
 
 ** 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 = 0
 
 Macro VSMBR-DORMANT        = (MEMBER-FILE.REST-FLAG-11 = 79)
 Macro VSMBR-NOMAIL         = (MEMBER-FILE.CONTROL-FLAGS(21) = 1)
 Macro VSMBR-BAD-ADDR       = (MEMBER-FILE.CONTROL-FLAGS(24) = 1)
 Macro VSMBR-CHGOFF-SHARE   = (MEMBER-FILE.CONTROL-FLAGS(34) = 1)
 Macro VSMBR-CHGOFF-LOAN    = (MEMBER-FILE.CONTROL-FLAGS(31) = 1)
 Macro VSMBR-CHGOFF         = (%VSMBR-CHGOFF-SHARE OR %VSMBR-CHGOFF-LOAN)
 Macro VSMBR-SFX0-MIN-BAL   = "500"
 Macro VSMBR-UNIQUE-ID      = "SSN"
 
 Macro VS-ACTIVE-MBR        = (MEMBER-FILE.REST-FLAG-11 <> 80 AND MEMBER-FILE.REST-FLAG-12 <> 80)
 Macro VS-ACTIVE-SHARE      = (SHARE-FILE.REST-FLAG-11 <> 80 AND SHARE-FILE.REST-FLAG-12 <> 80)
 Macro VS-ACTIVE-LOAN       = (LOAN-FILE.REST-FLAG-11 <> 80 AND LOAN-FILE.REST-FLAG-12 <> 80)
 Macro VS-CHGOFF-SHARE      = (SHARE-FILE.DESC-ABRV="COS")
 Macro VS-CHGOFF-LOAN       = (LOAN-FILE.ACTION = "O")
 
 ** Added for Trial Balance extracts:
 Macro VS-TRBAL-SHARE    = (SHARE-FILE.BALANCE <> 0 OR SHARE-FILE.CONTROL-FLAGS(21) <> " ")
 Macro VS-TRBAL-LOAN     = (LOAN-FILE.BALANCE <> 0 OR LOAN-FILE.CREDIT-LIM > 0)
 
 *** Use the following macros if you want to include non-zero escrow balance loans in the trial bal chart
 *** - The macros with the same names (below) MUST be disabled with comments.
 *Macro VS-TRBAL-INC-ESCTOTS = 1
 *Macro VS-TRBAL-ESCROW-LINK = link l1, account splice "-" splice !format("99", suffix) :: esctots.acct-sfx-key
 *Macro VS-TRBAL-ESCROW-MBR = (!range((LOAN-ADDENDUM.BALANCE <> 0, $MISSING), "1/"))
 *Macro VS-TRBAL-ESCROW-LN = (ESCTOTS.ESCROW_BALANCE <> 0, $MISSING)
 
 *** Use the following macros if zero balance escrow loans Should NOT be included
 *** - The macros with the same names (above) MUST be disabled with comments.
 Macro VS-TRBAL-INC-ESCTOTS = 0
 Macro VS-TRBAL-ESCROW-LINK = * No Link
 Macro VS-TRBAL-ESCROW-MBR = ($FALSE)
 Macro VS-TRBAL-ESCROW-LN = ($FALSE)
 
 Macro VS-DAYS-LOAN-DELQ    = "7"
 
 Macro VS-SH-OPEN-DATE      = (SHARE-FILE.OPEN-DATE)
 Macro VS-LOAN-OPEN-DATE    = (LOAN-FILE.ENTRY-DATE)
 
 Macro VS-MBR-COUNT         = (SFX0..SHARE-FILE.SSN)
 Macro VS-SH-COUNT          = (%VS-ACTIVE-SHARE AND NOT %VS-CHGOFF-SHARE)
 Macro VS-OPEN-LOAN         = (%VS-ACTIVE-LOAN AND (LOAN-FILE.BALANCE > 0 OR LOAN-FILE.CREDIT-LIM > 0) AND LOAN-FILE.ACTION = "D","3")
 
 Macro VS-JO-SH-CODE        = "J"
 Macro VS-JO-AI-CODE        = "JO","C"
 
 Macro VS-MBR-BRANCH        = (MEMBER-FILE.CURR-BRANCH)
 Macro VS-MBR-ORIG-BRANCH   = (MEMBER-FILE.ORIG-BRANCH)
 Macro VS-SH-BRANCH         = (SHARE-FILE.CURR-BRANCH)
 Macro VS-SH-ORIG-BRANCH    = (SHARE-FILE.ORIG-BRANCH)
 Macro VS-LN-BRANCH         = (LOAN-FILE.CURR-BRANCH)
 Macro VS-LN-ORIG-BRANCH    = (LOAN-FILE.ORIG-BRANCH)
 Macro VS-MBR-CLOSED-DATE   = MEMBER-FILE.CLOSED-DATE
 Macro VS-SH-CLOSED-DATE    = SHARE-FILE.CLOSED-DATE
 Macro VS-LN-CLOSED-DATE    = LOAN-FILE.CLOSED-DATE
 ** Set the following to 1 if you want to extract VISA-INFO data.
 Macro VS-EXTRACT-VISAINFO = 0
 ** Set the following to 1 if you want to extract OANR information.
 Macro VS-EXTRACT-OANR = 0
 ** Set the following to 1 if you use Lender.
 Macro VS-EXTRACT-LOANAP = 1