CU Customization
Overview
The CU Customization spreadsheet contains several sheets: Overview, Extraction Macros, Custom Ranges and Member Attributes.
The Overview sheet explains the rest of the CU Customization document and has several fields of input, specifically the Credit Union Name will be what is entered into Vital Signs.
The Extraction Macros sheet contains core definitions for attributes of the member set during the extraction of core data on the HPUX machine.
The Custom Ranges sheet contains the customizable ranges used in Vital Signs.
The Member Attributes sheet contains the 30 possible Custom Attributes that are defined by the Credit Union.
Overview
Contains a brief overview of the spreadsheet and entries for the Credit Union name and primary contact information.
Extraction Macros
The following are core member attributes in Vital Signs defined by the Credit Union
Member Record Status Open
How should Vital Signs determine that a member is open?
Default Criteria: (MEMBER-FILE.REST-FLAG-11 <> 80, 81 AND MEMBER-FILE.REST-FLAG-12 <> 80, 81)
Member PSA Funded
What is the minimum required balance in a primary savings account?
Default Criteria: (SHARE-FILE.BALANCE >= 500)
Member Charged Off Loan
How should Vital Signs determine that a member has a charged off loan?
Default Criteria: (MEMBER-FILE.CONTROL-FLAG(31) = 1)
Member Charged Off Share
How should Vital Signs determine that a member has a charged off share?
Default Criteria: (MEMBER-FILE.CONTROL-FLAG(34) = 1)
Member Dormant
How should Vital Signs determine that a member is dormant?
Default Criteria: (MEMBER-FILE.REST-FLAG-11 = 79)
Member Do Not Mail
How should Vital Signs determine that a member should not receive mail?
Default Criteria: MEMBER-FILE.CONTROL-FLAGS(21) = 1
Member Bad Address
How should Vital Signs determine that a member has a Bad Address?
Default Criteria: MEMBER-FILE.CONTROL-FLAGS(24) = 1
Member Credit Rating
How should Vital Signs gather the credit FICO score for a member?
Available Options:
Default (MEMBER-FILE.CREDIT-RATING)
The alternative is to gather this information from the most recent loan. (LNCRSCORE.LN-LAST-CRSCORE)
Member Relate Code
How should Vital Signs gather the MEMBER RELATE code?
Available Options:
Default (MEMBER-RELATE.CURRENT-CODE)
A common alternative is to gather this information from (MEMBER-FILE.DEPARTMENT)
Share Record Status Open
How should Vital Signs determine that a share is open?
Default Criteria:
(SHARE-FILE.REST-FLAG-11 <> 80, 81 AND
SHARE-FILE.REST-FLAG-12 <> 80, 81)
Share Record Countable
How should Vital Signs determine that a share can be counted in the total shares?
Default Criteria:
(SHARE-FILE.REST-FLAG-11 <> 80, 81 AND
SHARE-FILE.REST-FLAG-12 <> 80, 81 AND
SHARE-FILE.DESC-ABRV="COS")
Share Charged Off
How should Vital Signs determine that a share is charged off?
Default Criteria: (SHARE-FILE.DESC-ABRV="COS")
Loan Record Status Open
How should Vital Signs determine that a loan is open?
Default Criteria:
(LOAN-FILE.REST-FLAG-11 <> 80, 81 AND
LOAN-FILE.REST-FLAG-12 <> 80, 81)
Loan Record Countable
How should Vital Signs determine that a loan can be counted in the total loans?
Default Criteria: (LOAN-FILE.REST-FLAG-11 <> 80, 81 AND LOAN-FILE.REST-FLAG-12 <> 80, 81 AND (LOAN-FILE.BALANCE > 0 OR LOAN-FILE.CREDIT-LIM > 0) AND LOAN-FILE.ACTION = "D")
Loan Charged Off
How should Vital Signs determine that a loan is charged off?
Default Criteria: (LOAN-FILE.COLLATERAL = 999 OR LOAN-FILE.ACTION = "O")
Custom Ranges
The customizable ranges used in Vital Signs
Credit Tiers
Credit Tiers for the FICO score that can be displayed in Vital Signs. A max of 10 tiers is allowed.
Example: Tier Min Value Description U 0 U (Undefined No Score) E 1 E (Less than 520) D 520 D (520 – 580) C 581 C ( 581 – 620) B 621 B (621 – 700) A 701 A (701-730) A+ 730 A+ (Over 730)
Member Age Range
Grouping by Members age
Example: Range Description 0 No Age 1 – 15 15 or Less 16 – 21 16 – 21 22 – 29 22 – 29 30 – 39 30 – 39 40 – 49 40 – 49 50 – 65 50 – 65 66+ Over 65
Account Age Range
Grouping by Account age
Example:
Range Description
0 < 1 Year
1 1 Years
2 2 Years
3 – 5 3 – 5 Years
6 – 10 6 – 10 Years
10+ Over 10 Years
Share Balance Tiers
Grouping by individual Share balances
Example:
Min Value Description
- Negative
$0.00 Zero
$0.01 $0.01 - $4.99
$5.00 $5 - $49.99
$50.00 $50 – $99.99
$100.00 $100 - $499.99
$500.00 $500 - $999.99
$1,000.00 $1K - $9,999.99
$10,000.00 $10K - $99,999.99
$100,000.00 $100K and Over
Loan Balance Tiers
Grouping by individual Loan balances
Example:
Min Value Description
- Negative
$0.00 Zero
$0.01 $0.01 - $4.99
$5.00 $5 - $49.99
$50.00 $50 – $99.99
$100.00 $100 - $499.99
$500.00 $500 - $999.99
$1,000.00 $1K - $9,999.99
$10,000.00 $10K - $99,999.99
$100,000.00 $100K and Over
Rates
Apr grouping for both Share dividends and Loan aprs
Example:
Min Value Description
0.00% Zero
0.00% <= 0.50%
0.50% >= 0.50% < 1.00%
1.00% >= 1.00% < 1.50%
1.50% >= 1.50% < 2.00%
2.00% >= 2.00% < 2.50%
2.50% >= 2.50% < 3.00%
3.00% >= 3.00% < 3.50%
3.50% >= 3.50% < 3.75%
3.75% >= 3.75% < 4.00%
4.00% >= 4.00% < 4.25%
4.25% >= 4.25% < 4.50%
4.50% >= 4.50% < 4.75%
4.75% >= 4.75% < 5.00%
5.00% >= 5.00% < 5.25%
5.25% >= 5.25% < 5.50%
5.50% >= 5.50% < 5.75%
5.75% >= 5.75% < 6.00%
6.00% >= 6.00% < 6.25%
6.25% >= 6.25% < 6.50%
6.50% >= 6.50% < 6.75%
6.75% >= 6.75% < 7.00%
7.00% >= 7.00% < 7.25%
7.25% >= 7.25% < 7.50%
7.50% >= 7.50%
Loan To Value
Range for Loan to Value percentages
Example:
Min Value Description
Negative
0.00% Zero
0.01% <= 80%
80.01% 80.01% - 90%
90.01% 90.01% - 100%
100.01% Over 100%
Maturity Date
Day ranges for Maturing Shares and Loans
Example:
Min Value Description
1-30 Days
31 31-60 Days
61 61-90 Days
91 91-120 Days
121 121-180 Days
181 6 Mths - 1 Year
366 1 – 2 Years
731 2 – 3 Years
1,096 3 – 4 Years
1,461 4 – 5 Years
1,826 Over 5 Years
Delinquent Days
Day ranges for Delinquent Loans
Example:
Min Value Description
Current
1 1-15 Days
16 16-30 Days
31 31-60 Days
61 61-90 Days
91 91-120 Days
121 121-180 Days
181 6 Mths - 1 Year
366 Over 1 Year
