Configuration/Functionality
True or False - Bertha Gonzalez (0000018746) has a loan. When adding an Loan Transfer Record to her L0052 for Automatic Loan Payments, the CU must remember to change the Payment Method from Cash to Automatic Transfer. Vice Versa, if the CU deletes or expires the Loan Transfer records, they must change the Payment Method to Cash otherwise they will get an exception on their Loan Transfers Exceptions returns.
False - In 2024_02 Release, there was an enhancement to the core. Keystone will now change the Payment Method to Automatic Transfer when a Loan Transfer record is insert or when an existing transfer has it's effective/expiration date modified. Likewise, if the Loan Transfer is deleted or expired, the system will not change the Payment Method to Cash. No batch job is needed for this and it only does this for records that are manually file maintained.
What is a batch job and how does it play a part into EOD sequence? Provide some examples of batch jobs that go in EOD.
A batch job is a program that can perform postings/file maintenance/other related tasks on the system. Every day, the system runs an EOD sequence which consists of several batch jobs that complete nightly processes before and after the systems switches dates. Some examples are Share/Loan Transfers, Nightly Purge, System Backup, Certificate Maturity Posting & Renewal Notices, Collections Queues Updates and Notices.
What are the names of the 4 Credit Bureaus that a CU can report to and where does the CU enter the Header Record Program Identifier for each bureau?
Experian, Transunion, Equifax, Innovis.
Credit Reporting Cutoff
Under the Person Fix Report Sample, what exception had 202 count?
What is the exception trying to say and what level of risk would you consider it to be for Go Live Weekend?
Person score updated, category Equifax Beacon 09-->TransUnion FICO 08
This exception is informational and it read that the Person Score Category field was changed. This is low risk/informational and does not affect any functionality within Keystone.
What is an Account Index Record and when should one be used/mapped?
Account Index Records are used to cross reference an "old" legacy value to the "new" Keystone value for Shares/Loans. It should be used/mapped when the CU is changing Share/Loan IDs, if there's been a change to account numbers, or if there's been a change to MICRs.
What batch job was last ran under Bertha Gonzalez (18746) and what does it do?
Under Bertha Gonzalez's Person Record, OFAC Check was ran. This batch program performs a check to see if Bertha is on the Office of Foreign Asset Control's list of sanctioned individuals, companies, entities or countries.
Under the Account record, Dividend Posting was last ran. This program calculates and posts a monetary transactions of dividends that the member earned for a given period under a specified share. It's listed under the Account FM because one of the shares/loan under the account was last affected by this batch job.
What is a L1 Segment and when is it generated in Keystone?
L1 segments notify the bureaus of the old account number from your previous core and the new account number in KeyStone. The bureaus update their records based on the L1 segments. L1 segments are only included in the first file produced out of KeyStone after a conversion run, and are not needed after the bureaus update their databases.
True or False - Conversion Defaults Share/Loan Report should be reviewed after your preliminary database has been delivered.
False - You would not have any Share/Loan Defaults created yet. This report should be reviewed after they've been built out and a conversion run has been completed. Likely DCC Conversion Run.
Cathy Loera (99162) has an account that is showing dormant. Her shares and loans are also dormant. Please explain why everything is reflecting as dormant.
Account Level Dormancy was introduced in the 2023_02 release.
"I'm looking for a batch job that will automatically perform recoveries/right of offsets on negative shares or delinquent loans after they have been 30 days negative/delinquent. Preferably, I would like the funds to be taken from their Primary Checking first, followed by Secondary Checking, then Primary Savings, and lastly Secondary Savings."
Is this custom or is there a standard batch program that can perform this function?
The Credit Reporting ECOA code is determined by the ____________ Category when the ___________ runs.
Loan Person Link Category and Credit Reporting Batch Program
Is this exception found on the Conv Review Report an issue:
654372 Share with courtesy pay option=Y with no courtesy pay limit
Why or why not?
It is not an issue if they plan to run a script to add in Courtesy Pay Limits at conversion. It may be beneficial to map them in in order to minimize the report that get generated when the script runs.
CU should still review this exception to ensure that the Courtesy Pay Option was set accurately.
John Landis, an MSR at the Corelation Point Loma Branch, is trying to fund Goofy Disney's new 12 Month Certificate S3001 with $50,000.00. However, as he attempts this transaction, he keeps getting an exception and cannot post it. What is the exception and why is it being caused?
Deposit exceed Share Balance Limit.
This is new functionality that was introduced in the 2024_02 Release. The system can limit the aggregate balance a member can have for a specific product under one account or across multiple accounts where they are primary owners.
New configuration tables include:
Share Balance Limit and Share Balance Limit List
New Security Events and Privileges include:
Deposit exceeds share balance limit and Withdrawal adjustment exceeds share balance limit
What field was added in the 2024_03 Release under the IRS File Maintenance batch program and what Keystone table/fields are being used to output information using these options?
Box 10 Other Option is the new field added to the batch program.
Overflow Address - Overflow of the loan collateral record's Description + Property Description if it exceeds 39 characters
Property Tax - Loan YTD Property Tax
Insurance - Loan YTD Flood Insurance, Fire Insurance, Other Insurance
Property Tax and Insurance - Loan YTD Property Tax, Flood Insurance, Fire Insurance, Other Insurance
Which Keystone field is used to report the Highest Balance on a line of credit loan?
A. Credit Limit/Approved Amount
B. Acquisition Balance
C. Original Balance
D. Highest Transaction History Balance since open date
C. Original Balance
Explain these exceptions found on the Conv Review Report and why are they an issue:
Account number matches draft lookup on different account
Account number matches ach lookup on different account
These exceptions are calling out instances where an ACH Lookup or a Draft Lookup are setup with matching formatting to another account number. This can cause posting issues for ACH Posting and/or Share Draft Posting.
Ex) Item comes in with DFI Account 123456.
ACH Lookup of 123456 is tied to Account Number 12345
There is a valid account with account number 123456
Because of this, all items coming in with a DFI Account Number = 123456 will be posted to 12345. Account Number 123456 may not get any ACH credits or debits posted.
Henry Gonzalez (210263) would like to payoff his L0051 by 06/30/2025. What is the payoff and explain what happens when with the pending ACH future dated payment once the loan is paid off.
$25,074.02 and the pending ACH payment will get posted to the loan once the CL transaction is ran.
True or False - The CSS will create the Payroll Posting Program only when the CU has actual Paper Payroll.
False. The CSS does not handle the Payroll Posting Program. This is handled by the CS and it will only be setup when the CU has Paper Payroll or Payroll via a csv/comma delimited/fixed length file.
Michelle Obama (10001001) has an auto loan L0003 that is 60 days past due today (6/30/2023). She wants to make a payment to bring the loan current. If she does, how will the system report Michelle Obama when Credit Reporting is ran at the end of the night on 06/30/2023?
The loan will be reported with a Credit Reporting Account Status = 11 Current Account since the loan was brought current before Credit Reporting Cutoff was ran. Credit reporting cutoff is a status snapshot of the loan. It is not a reporting of the highest level of delinquency in that month.
Explain the following exception found on the Conv Review Report:
Account with redundant mail person address link, should be blank
Discuss how it relates to statement mailing address functionality in Keystone.
The exception is calling out instances where the account mail person address link does not need to be filled since it may be the only mailing address for the primary member. Keystone will first look for a share/loan mail person address link, then an account mail person address link, followed by a person address in the order of the setting in the default address method under the environment table.
Explain the difference between an Interest Only Loan vs a Daily Interest Loan vs a Monthly Interest Loan vs a Credit Card Interest.
A Daily Interest Loan collect interest since last payment. The system stores interest in the interest unpaid field and it calculates accrued interest using the interest calculation date. When a payment is made, the interest unpaid + interest accrued from the interest calculation date to today is what is collected. This is generally seen as the option selected for consumer loans.
An Interest Only Loan collect interest that is stored in the Interest Only Unpaid Field. It will not collect accrued interest. The Interest Only Unpaid field is updated at Statement Cutoff or via a Payment Calculation batch. This option is often found as a selection for HELOCs or LOCs.
A Monthly Interest loan collects interest in arrears (previous month's interest only). It will not collect accrued interest. This is generally seen as the option selected for mortgage products.
Credit Card Interest will calculate interest based on the different buckets that a transaction falls under (purchase, balance transfer, and cash advance). The Subcategory in the Monetary Source will guide the transaction to the appropriate balance bucket thus ensuring to be charged the correct interest rate.