|
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
|