Difference between revisions of "Vitalsigns.xls"
>Kevint |
>Johno (→GlobalVars Sheet) |
||
| Line 5: | Line 5: | ||
== GlobalVars Sheet == | == GlobalVars Sheet == | ||
| − | ''' | + | {| class="wikitable" |
| − | + | | '''VS_VARNAME''' | |
| + | | '''VS_VARVALUE''' | ||
| + | | '''Description (Note)''' | ||
| + | |- | ||
| + | | vCUNAME | ||
| + | | VS Employees Credit Union | ||
| + | | The Credit Union name displayed in various documents. | ||
| + | |- | ||
| + | | vMaxDisplayRows | ||
| + | | 30000 | ||
| + | | The maximum number of rows to display in the View Details tables. | ||
| + | |- | ||
| + | | vUseAcctXref | ||
| + | | 1 | ||
| + | | Must be equal to '''1''' in versions 1.5 and higher. | ||
| + | |- | ||
| + | | vReportFrequencies | ||
| + | | Daily, Weekly, Monthly | ||
| + | | A comma separated list of possible reporting frequencies. (1). | ||
| + | |- | ||
| + | | vTB_Exclude_LoanAction | ||
| + | | O, T, A | ||
| + | | A comma separated list of loan actions to be excluded from the Trial Balance report. | ||
| + | |- | ||
| + | | vTB_Exclude_Collateral | ||
| + | | 0 | ||
| + | | A comma separated list of collateral codes to be excluded from the Trial Balance report. | ||
| + | |- | ||
| + | | vTB_Exclude_DescAbrv | ||
| + | | O, T, A | ||
| + | | A comma separated list of share DESC-ABRVs to be excluded from the Trial Balance report. | ||
| + | |- | ||
| + | |} | ||
| − | + | :# 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 frequencies referenced here, must exist as worksheets in the DocumentDistribution spreadsheet, or a load error will occur. For example, "Daily, Weekly, Monthly, BoardReports, Finance, Tuesday" would add three additional reporting frequencies for report distribution. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | : 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 | ||
| − | |||
== Membership Sheet == | == Membership Sheet == | ||
Revision as of 20:07, 1 December 2015
Overview
The Vital Signs spreadsheet defined variables used in Vital Signs
GlobalVars Sheet
| VS_VARNAME | VS_VARVALUE | Description (Note) |
| vCUNAME | VS Employees Credit Union | The Credit Union name displayed in various documents. |
| vMaxDisplayRows | 30000 | The maximum number of rows to display in the View Details tables. |
| vUseAcctXref | 1 | Must be equal to 1 in versions 1.5 and higher. |
| vReportFrequencies | Daily, Weekly, Monthly | A comma separated list of possible reporting frequencies. (1). |
| vTB_Exclude_LoanAction | O, T, A | A comma separated list of loan actions to be excluded from the Trial Balance report. |
| vTB_Exclude_Collateral | 0 | A comma separated list of collateral codes to be excluded from the Trial Balance report. |
| vTB_Exclude_DescAbrv | O, T, A | A comma separated list of share DESC-ABRVs to be excluded from the Trial Balance report. |
- 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 frequencies referenced here, must exist as worksheets in the DocumentDistribution spreadsheet, or a load error will occur. For example, "Daily, Weekly, Monthly, BoardReports, Finance, Tuesday" would add three additional reporting frequencies for report distribution.
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
