We know that understanding your comprehensive compliance software is critical – so, when you have a question, we have the answers you need. Check out our Frequently Asked Questions below for insights including File Name requirements, filtering loans with a Reportable Rate Spread, and even Mapping techniques.
Banks & Files
What are the File Name requirements in File Manager?
There are no File Name requirements in File Manager.
In File Manager, what does the “Year” represent?
The Edit Year of the file tells the system which census data to use during geocode and the creation of maps, which CRA & HMDA edits apply and which demographic information to use when calculating borrower income levels.
Data Collection & Importing
What is the Lookup Manager?
The Lookup Manager is used to set up the translation between the original data, which is usually a code, and a longer more useful description. Some examples are Compensating Factors, Purpose codes, and User Denial Reasons.
What is a UDF?
UDFs (User Defined Fields) are institution–specific customized fields used to bring or hold data where a standard CenTrax field is not provided. UDFs can be numeric, character, date or logical format.
Can I change my UDFs?
Yes, UDFs can be changed in Settings/UDFs. It is best to keep your Bank Configuration updated and to create files with consistent UDF information. Before initiating any changes, however, discuss with Marquis support due to the impact this will have on your data.
Why can’t I type an “NA” in the income, rate spread or MSA fields as is required for the HMDA LAR?
The income and rate spread are numeric fields that do not allow letters, however, each of these fields may be identified as “NA” by clicking their respective checkboxes within Data Entry. All of these fields are automatically populated with “NA” as required when you create the HMDA LAR.
How is Loan Term calculated in CenTrax NEXT?
CenTrax NEXT does not calculate loan term. You must import the term information.
What is the difference between the Account Number and the ULI/NULI?
The Account Number is required for all records as part of the CRA LR Micro-Data and any other records outside of HMDA. The ULI/NULI is an alphanumeric identifier assigned to each loan for which data must be reported under HMDA.
Does CenTrax NEXT provide an audit trail?
CenTrax NEXT provides the User Audit report, which displays a list of all User and user related information, such as last login and when the password was most recently changed. Features such as import definitions, filters and assessment areas in CenTrax NEXT capture the Last Used Date, but do not show who used the feature or how it was used. Individual records in your data file contain the Entry Date (when the record was added to the file), and the Maintenance Date (last time the record was modified in any way). While this only shows the last activity, we do not capture all activity for each data field at the record level.
Can I manually enter a record?
Yes, you can manually enter a record by navigating to Data Entry/Add New. Within the new record, enter the transaction information and click save.
How do I locate a specific record?
Use the Quick search tool (magnifying glass), located within Discovery or Data Entry. When using the tool, enter in any combination of the ULI, Account Number, Name, or Address. Fast Filters or Three Step filters (within Discovery or Data Entry) may also be used to locate a specific record.
What does the “Validate” button do?
The Validate feature, located at the bottom of every record in Data Entry, allows you to check your data for Validity, Syntactical, Quality and CenTrax edits and to check the geocode for this record.
What does the “ReplacePro” tool do?
Located within Data Processing/Data Pro, ReplacePro tool is useful for changing the value of a field once it is part of the CenTrax NEXT data file. For example, if you import your data but are unable to collect certain fields, you may be able to populate the data with a Replace command. You can also use Replace commands to move data from one field to another.
Can I undo a ReplacePro command?
No, there is no undo for the ReplacePro command. Be very careful and call for assistance if you are not sure!
What does Update Derived Fields do?
Update Derived Fields allows you to update derived data (such as demographic data) or recalculate data (such as rate spread) after it was initially collected, or to fill in any data gaps if the information was not brought over during the import process.
Should my Import Definition be year-specific?
No, your Import Definitions should be specific to the source system and the layout of the file, not the year.
How do I import a CRA/HMDA Submission file?
From the Data Processing tab, choose Data Pro. From the left-hand menu, select Import and choose submission file.
Where can I find a list of available fields in CenTrax NEXT?
For more information on available fields, click here.
What file types can CenTrax NEXT import?
CenTrax NEXT can accept five file formats: Fixed Width, Delimited, Excel, Submission File, and CenTrax File.
Do the fields in my import file need to be in a certain order?
No, your import file can be in any order. You will simply tell CenTrax NEXT where to look for the individual fields during the Import Definition process. Once the order is established, it should remain the same moving forward.
What is a Header Row?
A Header Row is a descriptive row at the top of an extract file from another system. This optional row is strongly recommended in Delimited and Excel format files.
Can I collect non-reportable fields or data in CenTrax NEXT?
Yes, you can collect non-reportable fields in CenTrax NEXT. You can also collect any records that you wish whether they are reportable or not, such as consumer loans and deposit data.
I want to import both Front-End and Back-End DTI (Debt-to-Income). Can I import both?
Yes, one can be imported directly to the DTI field and the other can be placed in a User Defined Field.
What is a Data System ID?
The Data System ID is a letter code which identifies where your data was imported from (such as LaserPro). The Data System ID can be found within the CRA tab of all records in Data Entry.
What constitutes a Duplicate Account Number?
A Duplicate Account Number is when you have two or more records with identical Account Numbers.
What is Data Conversion?
Data Conversion allows you to replace a specified character string/value with another value during the import process. For example, a small business loan should have a code of 01 for CRA Type. If the file contains a designation of “SMALL BUSINESS” instead, Data Conversion can change the SMALL BUSINESS to 01 during the import process.
What information can be converted in Data Conversion?
Most (but not all) character fields can be modified using Data Conversion. Date and numeric fields will be formatted during the import routine and cannot be converted. You cannot convert an incoming blank value using Data Conversion but this can be accomplished using Replace commands.
What is DataPro?
DataPro is a collection of functions that can be run independently or together. This tool helps to streamline many of the processes in your data collection efforts.
How can I delete records within a file?
Records may deleted within a file in several ways:
Within Data Entry, select the record from the grid and choose Delete from the menu. Or, select the record from the grid and choose the delete button at the top of the screen. This marks the record for deletion. To permanently remove records marked for deletion, you’ll need to purge the deleted records within File Manager.
Within Data Processing/Data Pro, a DeletePro template may be set up, to delete multiple records at a time.
How can I remove records that have been marked for deletion?
To permanently remove records marked for deletion, you’ll need to purge the deleted records within File Manager. To purge the records marked for deletion, click the Purge button, located at the bottom of the File Manager page. Click YES to the prompt. Be careful when using this, there’s no way to undo this function.
Can I recall deleted records?
Records marked for deletion can be recalled within Settings/File manager. Alternatively, records may also be restored within Data Entry, by clicking the Restore button, then selecting the desired record to restore. Click the desired record from the list, then click Restore again.
Can I use a filter to locate deleted records?
No, to locate and recall any records which have been unintentionally deleted, click the Recall button within the File Manager.
What is a Syntactical Edit?
These edits check whether the loan/application register is in the correct format and whether the data covers the correct filing year. A syntactical edit occurs, for example, if none of the rows in the loan/application register begin with the number two (2) to indicate that the following data fields contain information relating to the reported loan or application. The loan/application register cannot be submitted until the filer corrects all syntactical edit errors and reuploads the updated loan/application register to the HMDA Platform. These edits are rare in CenTrax NEXT. They prevent your data from being uploaded after submission. If you have a Syntactical edit, you must correct it for both HMDA and CRA.
What is a CenTrax Edit?
These edits are written by Marquis and are specific to how the software operates. Some will need to be corrected; some will need to be verified.
What is a Validity Edit?
Validity Edits are edits that check whether there are valid values in each data field. A validity edit occurs, for example, if the contact person’s telephone number does not follow the format “999-999-9999.” The loan/application register cannot be submitted until the filer corrects all validity edit errors and reuploads the updated loan/application register to the HMDA Platform. Additionally, you must correct validity edits within your CRA LR prior to submission to the FFIEC. Validity edits represent factual errors. The field is either blank or conflicts with the data in another field. For example, HOEPA only applies to loans that are funded, so if you say a denied application is subject to HOEPA, you will get a validity edit.
What is a Quality Edit?
These edits show you information that is statistically unusual. These edits check whether entries in the individual data fields or combinations of data fields conform to expected values. The loan/application register cannot be submitted until the filer either confirms the accuracy of all values flagged by quality edits in the CFPB HMDA Platform or corrects the flagged values and reuploads the updated loan/application register to the CFPB HMDA Platform. CRA records should not be submitted with any outstanding edits.
What information is required for CenTrax NEXT to calculate Rate Spread?
To calculate the Rate Spread, CenTrax NEXT must have the following information: Term/Introductory Rate Term, APR, Rate Lock Date, and the Fixed / Variable Rate indicator. If any of these fields are blank or invalid, the spread will not calculate.
What does Spread Source represent?
The Spread Source designation (displayed for every record in Data Entry) indicates where the spread came from. For example, was it manually entered, imported or did CenTrax NEXT calculate it?
What does the source “Permanent” mean for Rate Spread?
When the Spread Source is set to Permanent, it indicates that the user agrees with the spread and it will not be recalculated by CenTrax NEXT or allowed to be overwritten during data collection or importing.
How often is the Rate Table updated?
The Rate Table is updated weekly but CenTrax NEXT checks for an updated table each time you log into CenTrax NEXT.
When should I check the “Not Reg Z” box?
You should check the “Not Reg Z” box when a record is not subject to the Reg Z requirements. CenTrax NEXT cannot determine whether a record is subject to these rules, it can only bring to your attention the possibility that these rules may or may not apply based on validity and quality edits.
What does Geocode Source represent?
The Geocode Source indicates where the geocode came from. For example, was it manually entered, imported or did CenTrax NEXT geocode it?
What does the source “Permanent” mean for Geocode?
A geocode source of “Permanent” allows CenTrax NEXT to skip past this record, and not attempt to Geocode it again. A designation of Permanent also means that CenTrax NEXT will not attempt to overwrite during import. This should only be used if the geocode has been verified as correct, or obtained from an outside source and documentation is available to prove accuracy.
Can I import geocode?
Yes, you can import geocode information provided it is included on your extract and the fields are mapped on the import definition.
How is demographic information assigned?
When records are geocoded by CenTrax NEXT the demographic information is automatically applied at the time the geocode is applied. When geocode is imported, demographic information is added for all records with valid geocode for the year of the active file. Borrower Income levels require that the record contain both a valid geocode and an annual income.
What is the purpose of the manual geocode feature?
The manual geocoder will allow you to try and obtain a valid geocode where CenTrax NEXT was unable to automatically geocode the record.
What options do I have if my addresses will not geocode in CenTrax NEXT or on the FFIEC website?
Your best option would be to locate the address using a mapping site such as Google Maps, Google Earth, or MapQuest and then match that to the maps in FFIEC to determine the geocode information.
If my address is outside of an MSA, should I enter 99999 as the MSA?
No, if your address is located outside of an MSA, the MSA field should be blank.
What is the difference between a geocode error and a geocode exception?
A geocode exception is when an address cannot be geocoded based on the address provided. A geocode error indicates that the geocode combination (state/county/tract/MSA) entered in CenTrax NEXT is not a possible combination for the year of the active data file.
What is the difference between a Tract Group and an Assessment Area?
Assessment Areas are reported on your CRA LR and will be the area on which your examiner will rate your institution. Tract Groups are not reported, therefore they can be anything you want. They are created the same way and you distinguish one from the other by checking the Reportable CRA Assessment Area box on the setup form.
Should I check the Reportable CRA Assessment Area box when I create a combined Assessment Area?
You should only check the Reportable CRA Assessment Area box if you want to designate this Assessment Area as CRA reportable. This then generates an Area ID, which is used to identify duplicate geographies. Be advised that combined Assessment Areas do not meet the regulatory definition as they consist of multiple Assessment Areas. These should be created as Tract Groups and be used for analytical purposes only.