System for using metadata to identify and extract specific upstream data, provisioning data batches, and providing dynamic downstream data access

A computer program product for executing identification and extraction of specific upstream data, provisioning data batches, and providing dynamic downstream data access, wherein the computer program product comprises at least one non-transitory computer readable medium comprising computer readable instructions, the instructions comprising:

• transmit instructions to an upstream business process management application requesting party data tables;
• receive the party data tables comprising party data, each party data table having a plurality of corresponding parameters from a plurality of workflow applications;
• determine the corresponding parameters for each of the party data tables;
• based on the corresponding parameters for each of the party data tables, create a staging table for each workflow application;
• transmit a graphical user onboarding interface to a requestor, wherein the graphical user onboarding interface provides an interface for entering and transmitting a request for access to party data from the requestor;
• receive the request for access to party data from the requester via the graphical user onboarding interface, the request comprising requester authentication credentials, subset or type of data requested, a use-case or justification for the party data, and one or more parties for which the party data is requested;
• determine a party data portion comprising some or all of the party data, wherein the party data portion is a user-specific subcategorization of party data determined based on information from a metadata repository and the requestor authentication credentials;
• based on information from the metadata repository and the requester authentication credentials, communicate to the requester the party data portion;
• receive a selection from the requester of some or all of the party data portion, resulting in a party data selection;
• based on the party data selection from the requester, compile a schema file for staging of the party data selection, wherein the schema file comprises instructions for accessing and using the workflow application staging tables to stage the party data selection;
• using the compiled schema file to access and use the workflow application staging tables, stage the party data selection in an accessible format;
• and
• communicate, to the requester, the party data selection in the accessible format.

A computer implemented method for executing an enterprise framework for executing identification and extraction of specific upstream data, provisioning data batches, and providing dynamic downstream data access, the computer implemented method comprising:

• transmitting instructions to an upstream business process management application requesting party data tables;
• receiving the party data tables comprising party data, each party data table having a plurality of corresponding parameters from a plurality of workflow applications;
• determining the corresponding parameters for each of the party data tables;
• based on the corresponding parameters for each of the party data tables, creating a staging table for each workflow application;
• transmitting a graphical user onboarding interface to a requestor, wherein the graphical user onboarding interface provides an interface for entering and transmitting a request for access to party data from the requestor;
• receiving the request for access to party data from the requester via the graphical user onboarding interface, the request comprising requester authentication credentials, subset or type of data requested, a use-case or justification for the party data, and one or more parties for which the party data is requested;
• determining a party data portion comprising some or all of the party data, wherein the party data portion is a user-specific subcategorization of party data determined based on information from a metadata repository and the requestor authentication credentials;
• based on information from the metadata repository and the requester authentication credentials, communicating to the requester the party data portion;
• receiving a selection from the requester of some or all of the party data portion, resulting in a party data selection;
• based on the party data selection from the requester, compiling a schema file for staging of the party data selection, wherein the schema file comprises instructions for accessing and using the workflow application staging tables to stage the party data selection;
• using the compiled schema file to access and use the workflow application staging tables, staging the party data selection in an accessible format;
• and
• communicating, to the requester, the party data selection in the accessible format.