Extract Definitions

From Vital Soft Wiki
Revision as of 23:51, 23 August 2012 by >Jeremyb
Jump to: navigation, search

VSMACDEF

On the HPUX system in /ASKPLUS/vsdata/custom/live there is a file named vsmacdef

This file contains macros which are defined with criteria that Vital Signs uses during the nightly extracts.

The following is an example of a working setup

** 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")
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 = 0