View source for Spectrum Member Reports

{{SampleContext|
name=Member Counts|
h1=Member counts by age and account age.|
link=COUNTS-BY-MEM-AGE-AND-ACCT-AGE.ctx|
created=2016/09/01|
results={{Results_MemberCounts|}}
}}
 
[[https://vital-soft.com/?page_id=1479&ctx={{PAGENAMEE:Member Counts}}&file=COUNTS-BY-MEM-AGE-AND-ACCT-AGE.ctx|Download Member Counts]]

{{SampleContext|
name=Totals by ACC and Collateral|
h1=Created in REPORT. SHARE-FILE Totals by ACC and LOAN-FILE Totals by Col.|
h2=SHARE-FILE Totals by ACC counts and totals all open Shares by ACC code.LOAN-FILE Totals by COLLATERAL counts and totals all open Loans by Collateral code.|
link=TOTS-BY-ACC-COL.ctx|
created=2016/09/01|
results={{Results_TotalsByAccCol|}}
}}
 
{{SampleContext|
name=FLAG-DESCRIPTION-LIST|
h1=Created in REPORT.  Displays all Member, Share and Loan level control flags defined on your system|
link=FLAG-DESCRIPTION-LIST.ctx|
created=2016/09/01|
results={{Results_FLAG-DESCRIPTION-LIST|}}
}}
 
{{SampleContext|
name=MEMBER-TWO-COLUMN-LISTING|
h1=Created in REPORT.  Uses multipass reporting and contains 2 REPORTS.  Sorts open member accounts|
h2=The first REPORT sorts all open member account numbers in account number order.  Each ACCOUNT number will be given an index.  The information is sent to a HOST file called MEMORDER.  The second REPORT uses the MEMORDER file to report the first 55 ACCOUNTÎs in account order in column 1 and the next 55 ACCOUNTS in account order in column two.|
link=MEMBER-TWO-COLUMN-LISTING.ctx|
created=2016/09/01|
results={{Results_MEMBER-TWO-COLUMN-LISTING|}}
}}
 
{{SampleContext|
name=MULTIPLE-SSN|
h1=Created in REPORT.  Uses multipass reporting and contains 2 REPORTS.|
h2=The first pass will select ALL share accounts (open and closed) and outputs those ACCOUNT numbers where not all SSN numbers match.  A host file, MULTISSN is created and used in the final Report.  The final report displays all of the suffixÎs and SSNÎs for each ACCOUNT.|
link=MULTIPLE-SSN.ctx|
created=2016/09/01|
results={{Results_MULTIPLE-SSN|}}
}}
 
{{SampleContext|
name=TOTAL-MEMBERSHIP|
h1=Created in REPORT.  Selects all members who have one open SHARE or LOAN.|
h2=Selects all members who have at least one open SHARE or one open LOAN with a balance that is not charged off and then reports all SHAREs and LOANs per member.|
link=TOTAL-MEMBERSHIP.ctx|
created=2016/09/01|
results={{Results_TOTAL-MEMBERSHIP|}}
}}
 
{{SampleContext|
name=TOTAL-MEMBER-SHARE-LOAN|
h1=Created in REPORT.  Displays the total number and total balance of both SHARES and LOANS per membe|
h2=Displays the total number and total balance of both SHARES and LOANS per member.  It will also display the total number of SHAREs and LOANs as well as the total BALANCE for all SHAREs and LOANs for the entire Credit Union. (The report in this context is the same as the SHARE-AND-LOAN-DETAIL report.  The method used to create this report is the only difference between the two.)|
link=TOTAL-MEMBER-SHARE-LOAN.ctx|
created=2016/09/01|
results={{Results_TOTAL-MEMBER-SHARE-LOAN|}}
}}
 
{{SampleContext|
name=NO-CHECKING-ACCOUNT|
h1=Created in REPORT.  Finds all members who are 18 years of age or older.|
h2=Finds all members who are 18 years of age or older, have a suffix 0 record with a balance that is not closed (rest-flag-11 ne 80) and do not have a checking account (suffix 90).|
link=NO-CHECKING-ACCOUNT.ctx|
created=2016/09/01|
results={{Results_NO-CHECKING-ACCOUNT|}}
}}
 
{{SampleContext|
name=SHARE-AND-LOAN-DETAIL|
h1=Created in REPORT.  Uses multipass reporting.|
h2=The first pass will select all open Shares and create a host file, SHRLNDET.  The second REPORT will select all open Loans and append the records to the SHRLNDET file.  The final REPORT will report from the SHRLNDET file.  This REPORT will display the total number and total balance of both SHARES and LOANS per member.  It will also display the total number of SHAREs and LOANs as well as the total BALANCE for all SHAREs and LOANs for the entire Credit Union.  (The final report in this context
link=SHARE-AND-LOAN-DETAIL.ctx|
created=2016/09/01|
results={{Results_SHARE-AND-LOAN-DETAIL|}}
}}
 
{{SampleContext|
name=CARD-NAMES-GT-19-LONG|
h1=Report every ATM/DEBIT card which will have a name longer than 19 characters.|
h2=Some ATM/DEBIT card processors do not allow for the cardholder|s name to be longer than 19 characters.  This report finds the cards that are being ordered for a specific day or month in the case of a reissue and reports cards that have a name longer than 19 characters.|
link=CARD-NAMES-GT-19-LONG.ctx|
created=2016/09/01|
results={{Results_CARD-NAMES-GT-19-LONG|}}
}}
 
{{SampleContext|
name=ESCHEAT-REPORT-LT-250|
h1=Escheated Accounts with balance < 250.00.|
h2=When the state-mandated limit on a dormant account is reached, it needs to be escheated to the state.  You need to confirm which dormant accounts are eligible for escheating.  This report will help you determine which accounts qualify to be escheated.  The criteria for this report looks for suffix = 0 and rest-flag-11 <> 80 and rest-flag-12 <> 80 and balance < 250.00 and balance > 0 and escheat-date < user input date.|
link=ESCHEAT-REPORT-LT-250.ctx|
created=2016/09/01|
results={{Results_ESCHEAT-REPORT-LT-250|}}
}}

[[Spectrum Context Library | Back to Context Library]]