Data Integration
The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 185.
See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100"
Data Integration - Overview
There are several options for data integration between the core Financial Model and the Tax Provision Blueprint Cube data. The integration design for each implementation will vary, but could include:
- Data Management Export Sequences plus related Transformation Rules.
- Data Management Copy Sequences
- Use of Business Rules to copy/clear data within the Tax Cube, for example, copy from National to a Local Jurisdiction, which is included with Tax Provision Blueprint (see the next section below).
- File upload or direct Connectors for data loading of tax schedule data.
- Other data integration techniques.
Data Management - Copy National jurisdiction to National or Local jurisdictions
Several Data Copy options are included:
Actual scenarios (Scenario Type - Tax):
- Copy National to National Group Filer Provision data – DM 10aAdmin
- Copy National (Group Filing: Yes or No) to Local (No Group Filing) Provision data – DM 20aAdmin
- Copy National (Group Filing: Yes or No) to Local (No Group Filing) Provision data – DM 20a
- Copy National (No Group Filing) to Local (No Group Filing) Return data – DM 20bAdmin
- Copy National (No Group Filing) to Local (No Group Filing) Return data – DM 20b
- Copy National Group Filer to Local (no Group Filing) Return data – DM 20b2Admin
- Copy National Group Filer to Local (no Group Filing) Return data – DM 20b2
- Copy National (Group Filing: Yes or No) by Local (Group Filing) Provision data – DM 30aAdmin
- Copy National (Group Filing: Yes or No) by Local (Group Filing) Provision data – DM 30a
- Copy National (No Group Filing) by Local (Group Filing) Return data – DM 30bAdmin
- Copy National (No Group Filing) by Local (Group Filing) Return data – DM 30b
- Copy National Group Filer to Local Group Filer Return data – DM 30b1Admin
- Copy National Group Filer to Local Group Filer Return data – DM 30b1
Forecast scenarios (Scenario Type - ScenarioType8):
- Copy National to National Group Filer Provision data – DM 10aAdmin FC
- Copy National (Group Filing: Yes or No) to Local (No Group Filing) Provision data – DM 20aAdmin FC
- Copy National (Group Filing: Yes or No) to Local (No Group Filing) Provision data – DM 20a FC
- Copy National (Group Filing: Yes or No) by Local (Group Filing) Provision data – DM 30aAdmin FC
- Copy National (Group Filing: Yes or No) by Local (Group Filing) Provision data – DM 30a FC
- Set the Opening Scenario - DM 40 Admin FC
- Copy Actual Data into a Forecast scenario – DM 45 Admin FC
- Copy Actual Data into a Forecast scenario – DM 45 FC
Data Management - Copy Tax Rates
Actual scenarios (Scenario Type - Tax):
- Copy Prior Year M12 CY Tax Rates into Period M1 - 01c1Admin CY Tax Rates
- Copy Prior Year M12 Deferred Tax Rates into Period M1 - 01c2Admin Deferred Tax Rates
These two dashboard allows the admin to copy prior year's ending tax rates into period M1 of the current year. Then the tax rates flow forward until the end of the year or until a user changes them in a period. These two dashboards are only available in the first time period and only on the XFW_TXP_GLTaxAdmin workflow. These dashboards are optional and are not required too be used.
Data Management - Copy Group Filing Definitions (Cell Text / Annotations)
Actual scenarios (Scenario Type - Tax):
- Copy Definitions - Actual Nat GF - DM 01a
- Copy Definitions - Actual local GF - DM 02a
- Copy Definitions - ActualRTP Nat GF - DM 11a
- Copy Definitions - ActualRTP Local GF - DM 12a
These dashboards allow the admin to copy the group filing definitions from a prior period into the current period. The copy can be used as a starting point and then the admin can modify the copy for any changes. These dashboards are optional and are not required too be used.
There are several supplied Dashboards (10aAdmin, 10aAdmin FC, 20a, 20a FC, 20aAdmin, 20aAdmin FC, 20b, 20bAdmin, 20b2, 20b2Admin, 30a, 30a FC, 30aAdmin, 30aAdmin FC, 30b, 30bAdmin, 30b1, 30b1Admin, DM45Admin FC, DM45 FC) that can be used to copy/clear data.
When a data copy dashboard has the word “Admin” in its name, it means that there is the functionality to do “bulk” data copy or clear.
Here are some sample Actual scenario workflow schedules:
There are several Data Management jobs attached to the icons in each data copy dashboard that then call Business Rules to execute the clear or copy functions.