| APP-1470 |
Update to the Business Application Review & Sign page to show all beneficial ownership information. For beneficial owners who are not the current applicant, the page will only display Name, Title, Organization Role, and Percentage Owned (if an owner). This does not show the last 4 of the SSN or other details like DOB, Residency Status, or Address.
|
|
Upcoming Direct SQL update
DENG-3403
|
Update to DirectSQL Reports PII and Non-PII to match the included fields already available in Console Reports
- Simplified Acquisitions Report:
- Added a new field 'funded_amount' to track the amount of funding for each acquisition.
- Simplified Business Applications Report:
- Added a new field 'state_bar_info' to capture information related to state bar memberships for business applicants.
- Simplified Consumer Applications Report:
- Added 'application_last_executed_at' to track when an application was last executed.
- Added 'primary_officer_name' and `primary_officer_code` to capture the primary officer associated with the application.
- Added 'funding_transaction_kyc_summary_tags' to store KYC summary tags related to funding transactions.
- Added 'primary_address_country' to capture the country of the primary address.
- Added 'occupation_description', 'current_employer', and 'member_eligibility_criteria' fields to provide more detailed information about the applicant's occupation and eligibility.
- Added 'referral_source' to track the source of the application referral.
- Added 'backup_withholding' to indicate if backup withholding applies to the applicant.
- Simplified Funding Report:
- Added 'funding_source_account_type', 'funding_source_institution_name', 'funding_source_institution_id', and 'funding_source_external_id' to provide more details about the funding source.
- Simplified Product Services Report:
- Added 'application_created_at' to track when the associated application was created.
- Added 'application_id' to link the product service to its corresponding application.
- Added 'assignee_id' to capture the unique identifier of the assignee associated with the product service.
These enhancements to the DirectSQL Reports schemas will provide more comprehensive and detailed data for analysis and reporting purposes. The additional fields will enable better tracking of application execution, funding sources, applicant details, and the relationship between product services and applications.
This will be released to UAT on 5/6 and to Production on 5/7
|
|
Upcoming Console Reports & Direct SQL update
DENG-2716
|
As our product has grown, our way of determining if a customer is new or existing had become stale. We are deploying an update that will more accurately categorize an applicant as a new or existing customer. There are three main changes to our existing customer fields:
- We are using a more accurate check to validate that the person or organization exists in the banking core
- We are only considering the application an existing customer if the primary person on an application exists in the banking core (as opposed to any person on the application).
- For business applications, we will only check if the organization is in the banking core to determine if they are an existing customer (we will no longer consider the primary person).
The net impact on this varies, but expect consumer applications to now have more "new customers" as a result of secondary applicants no longer being considered and business applications to have less "new customers" thanks to the improved process to check the organization isn't in the banking core.
This change will impact the following fields in our console reports and Direct-SQL Tables:
- Acquisitions: `is_existing_customer`
- Business_applications: `is_application_with_existing_customer`
- Consumer_applications: `is_application_with_existing_customer`
- Decisioning: `is_existing_customer`
- Funding: `is_existing_customer`
- Product_services: `is_application_with_existing_customer`
This will be released to UAT on 5/13 and to Production on 5/14
|
