Extract Definitions - Revision history

>Johno: Blanked the page

2015-12-01T19:06:46Z

Blanked the page

>Jeremyb at 23:51, 23 August 2012

2012-08-23T23:51:52Z

>Jeremyb: Created page with "==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..."

2012-08-23T23:51:21Z

Created page with "==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..."

New page

==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

<pre>

</pre>

← Older revision		Revision as of 19:06, 1 December 2015
Line 1:		Line 1:
−	~~==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~~
−
−	~~<pre>~~
−	** 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~~
−
−	~~</pre>~~

← Older revision		Revision as of 23:51, 23 August 2012
Line 8:		Line 8:

	<pre>		<pre>
		+	** 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

	</pre>		</pre>