Vitalsigns.xls

Overview

The Vital Signs spreadsheet defined variables used in Vital Signs

GlobalVars Sheet

vCUNAME

   The name of the Credit Union that will be displayed in Vital Signs

vMaxDisplayRows

   The maximum number of rows that should be displayed in the View Details tables

vUseAcctXref

   0 or 1 flag on whether Vital Signs should use the Account cross reference feature

vReportFrequencies

  Daily, Weekly, Monthly

vReportFrequencies contains a list of the valid report frequencies. If new custom frequencies are added, they must also be listed here. Case is important. All sheets listed must exist in the DocumentDistribution spreadsheet, or a load error will occur.

  Daily, Weekly, Monthly, BoardReports, Finance, Tuesday

Membership Sheet

vDefaultDaysDelq

   The number of days past due when a loan should be considered delinquent (Default 16)

vTB_Exclude_LoanAction

   A comma separated list of Loan actions to exclude from the Loan Trial Balance counts and balances (Default O,T)

vTB_Exclude_Collateral

   A comma separated list of collateral codes that should be excluded from the Loan Trial Balance counts and balances (Default 0)

vTB_Exclude_DescAbrv

   A comma separated list of share description abbreviations to exclude from the Share Trial Balance counts and balances (Default None)

vLoadMbrSellerSfx0

vDefaultStatus

   The default status in the Membership_Analysis and Membership Summary applications for the selection on the left hand side (Default Open)

vSelectMbrStatus

   The default Member status to include in the vDefaultStatus (Default (Open|Dormant)
   

vDefaultMbrSelect

   This value must correspond to what is set for vSelectMbrStatus
   Example:
   if vSelectMbrStatus = (Open|Dormant) then set to 5
   if vSelectMbrStatus = (Open) then set to 1