Modules are small stand-alone query strings that solve a single need. They can be copied and incorporated as-is into larger query projects for a pre-built solution to obtain the specific data that the module provides.
This query module handles finding and summarizing the detailed credit score history from the CRBCSH table. The final output of this query module provides you with a database table containing an easy-to-use list of members (by Social Security Number) with columns for their most recent credit score, the date of that score, and more.
Typical delivery of this query module is within 2-5 business days. Rush orders available on request, for a fee.
The Query
You will receive several queries that are placed in your QUERYxx library and connected to your data. Once they are established in your library, they are yours to use, manage, maintain, and delete later if you wish. You also receive documentation of how the query string is defined and criteria it uses to find and define the member’s most recent score.
Data Note: This query string pulls live data so all information is updated as of the time it is processed by you. It will not pull end-of-month data.
Once the query is set up by the Asterisk Intelligence Team, they will also process the entire query string so that the final output file is created.
| Query | Source Tables | Output Table |
|---|---|---|
| MQCRBCSH01 | CRBCSH, MASTER | MQCRBCSH01 |
| MQCRBCSH02 | MQCRBCSH01, CRBCSH, DATELOOKUP | CRBSCORE1 |
The File
This query module will produce a file named MQSCORE1 in your QUERYxx library. The file will contain a list of Social Security Numbers that meet the following criteria as of the time the query is processed:
- 1 row/record per Social Security Number
- Social Security Numbers of open and primary memberships only.
- No closed memberships or joint owners/coborrowers
- Social Security Numbers must have had at least 1 credit pull recorded in the CRBCSH table
- Not all open memberships have credit history with the credit union. Some memberships legitimately will not have a most recent score on file and will not be include in the output file of this query module.
Data fields included in the output file of this query module are:
| Social Security Number |
| Credit Score |
| Date of Score |
| Time of Score |
| Report Number |
| Bureau Code |
| Method (Ex. Full Pull, Soft Pull, Manual) |
| Days Since Score Was Recorded |
| Count of Credit Pulls on this SSN, Full History |
Once the query summary and instructions are provided to you – the query is yours to use, keep, and maintain moving forward. If adjustments or customizations are ever needed and you would prefer that we make them, please use the request to Change a Custom Query or Report.
Reviews
There are no reviews yet.