Nostradamus: Configure Criteria (4 - Activity Attributes 1)

Screen ID: 

Screen Title: 

Panel Number:

UCFGNOST-06

Configure Nostradamus Criteria

7261

Click here to magnify

 

Access this screen by selecting Tool #1676 Nostradamus Predictor Configuration and selecting to Add (F6) a new profile or view/edit the criteria of an existing profile.

View-Only Options for this tool are available in Tool #1677 View Nostradamus Predictor Configuration.

General Notes About the Attributes Configuration

This configuration allows you to evaluate both if a member has something, but also if they don't have something. As an example, you may want to score a member if they don't have a checking account, for a profile that assumes that the member doesn't use your credit union as their primary financial institution. This means that are three options to choose from when selecting how to score an attribute:

  • Don't score: do no consider this attribute when scoring a member against a profile.

  • Score if the member DOES have: this will include the attribute as a YES when scoring against a profile.

  • Score if the member does NOT have: this will include the attribute as a NO when scoring against a profile.

Note that if you choose items via the Select button, if you change the "Score This" option, the multi-select choices will only clear once you finish and exist back to the main screen using Save/Done (F10).

Criteria

Except where noted, data will be as of the most recent EOM file, if applicable, or from the previous day’s FILExxSS file, in cases where a month-end file doesn’t apply (such as for eStatement enrollments and similar statuses).

In cases where a range is specified, the member will score a hit if the count/amount matches within the specified range (including the low and high values themselves).

Score This

Attribute

Between xxx and xxx transactions in past x months

Count all transactions in ETRmmyy1-3, filtered according to the SH / SD / CD / IR / TX / LN / OC setting (must choose at least one). Will score a hit if the count matches within the specified range. Maximum six months.

Total # of trans for previous calendar month x% higher/lower than prior month

Counts all transactions (any type, any account) for the previous calendar month as well as the month prior to that (so if running this in September, will compare August and July) and score based on the percent difference between the totals. (TIP: This is similar to how the Tool #132 Losing the Love/Mbr Behavior Patterns dashboard works.)

Total withdrawals from savings/checking accounts for previous month exceeds deposits

Adds all credit and debit transactions from ETRmmyy1 (AplTyp SH/SD only, any origin) and scores if debits are higher than credits.

Total deposits to savings/checking accounts for previous month exceeds withdrawals

Adds all credit and debit transactions from ETRmmyy1 (AplTyp SH/SD only, any origin) and scores if credits are higher than debits.

Between xxx and xxx teller transactions in previous calendar month

Counts transactions in ETRmmyy1 with Origin 01, any code/type, for the previous calendar month. Will score a hit if the count matches within the specified range.

Between xxx and xxx shared branch teller transactions in previous calendar month

Counts transactions in ETRmmyy1 for the previous calendar month, filtered as follows:

  • For CU*BASE/Xtend shared branching: Origin code 01, with characters SHB in the first 3 positions of the primary trans description (TRDESC in ETRmmyy1).

  • For CO-OP National Shared Branching: Origin 11, with characters SB/ in the first 3 positions of the primary trans description (TRDESC in ETRmmyy1).

Between xxx and xxx cash withdrawals in previous calendar month

Includes both teller and ATM cash withdrawals (savings/ checking and LOCs), filters as follows:

  • For teller, looks in the Teller Cash/Check Audit table (CSHCHK) where SCKTPL = 2 (Cash Out) in the previous month and year.

  • For ATM, looks in ETRmmyy1 and ETRmmyy2 for transactions in the prior month where TRORIG=13 and where the characters ATM/WDR appear in the first 7 positions of the primary transaction description (TRDESC).

Between xxx and xxx checks cashed in previous calendar month

Look in the Teller Cash/Check Audit table (CSHCHK) for transactions of the same amount that were posted with the same date/timestamp. Member will get a hit if SCKTPL=3 (Outside Check) and SCKTPL=4 (Inhouse Check) items are equal to SCKTPL=2 (Cash Out) items for that same date/timestamp.Will score a hit if the count matches within the specified range.

Between xxx and xxx checks cleared (via share drafts/ACH) in previous calendar month

Counts transactions from the previous calendar month in ETRmmyy1 where TRORIG = 02 or 11 and the DFTNO field <> 0.

Between xxx and xxx ATM transactions in previous calendar month

Counts transactions from the previous calendar month in ETRmmyy1 with origin code 13 (ATM)

Between xxx and xxx debit card transactions in previous calendar month

Counts transactions from the previous calendar month in ETRmmyy1 according to the Include PIN-based... filter.

Include PIN-based point-of-sale transactions

If unchecked, will count transactions where the origin code (TRORIG) is 16 and tran type (TRTYPE) is an odd number (meaning a debit).

If checked, will count transactions where the origin code (TRORIG) is 16 and tran type (TRTYPE) is an odd number (meaning a debit) plus transactions where origin code is 13, tran type is an odd number, and the first three characters in the primary transaction description (TRDESC in ETRmmyy1) are POS or EDB.

Between xxx and xxx online credit card transactions in previous calendar month

Counts transactions from the previous calendar month in ETRmmyy2 where process type (PRTYPE) in MEMBER6 is V, origin code (TRORIG) is 22, and tran type (TRTYPE) is an odd number (meaning a debit).

Between xxx and xxx LOC (non-credit card) disbursements in previous calendar month

Counts transactions from the previous calendar month in ETRmmyy2 where the AplTyp in MEMBER6 is OC and the process type (PRTYPE) in MEMBER6 is not V (meaning it’s not an online credit card account), and where tran type (TRTYPE) is an odd number (meaning a debit).

Between xxx and xxx loan skip-pays (life of loan)

Compares to the value in the Payments Skipped Life of Loan field (PSKLL) on MEMBER5 or MEMBER6.

Between xxx and xxx NSF transactions in past x months

Compares to monthly counts in the ENAmmyy table where the origin of NSFs (NSFORG) code is anything other than 82, 83, or 86. Maximum six months.

Between xxx and xxx ANR transactions in past x months

Compares to monthly counts in the ENAmmyy table where the origin of NSFs (NSFORG) code is 82, 83, or 86.Maximum six months.

Between xxx and xxx ODP transactions in past x months

Counts transactions in ETRmmyy1 over the specified period with a primary tran description (TRDESC) of ‘OVERDRAFT TRANSFER’ and tran code (TRCODE) of 26. (This is so we only include the deposit side of the transaction and don’t count them all twice.) Maximum six months.