Dimension - Flow

The following has been taken from the Tax Provision Blueprint "Instruction Guide" starting at page 84.

See KB article: "Tax Provision Blueprint Instruction Guide - PV7.3.0 SV100" 

See KB article: "Dimension Member Names - Renaming and Deleting"

See KB article: "Dimension Text Fields - Summary"

Flow

XFW_TXP_Flow is the Tax Provision Blueprint Flow Dimension that holds the flow structure for the tax provision calculations, including the Deferred Tax Roll Forward Gross Closing and Tax Closing rollups.

Flow Notes

• Text 1 Property is used to identify Discrete flow members.
  • Any base level flow member that is classified as Discrete must have the Text 1 property of Discrete=Yes.
  • Parent flow members where all children are Discrete should also have Text 1 Discrete=Yes.
  • This is used to drive Parameters, BR’s, etc.
• Switch Type for activity type data.
• Alternate hierarchies are used.
• Aggregation weights are used.
• No Member Formulas are used. See the Finance BR TXP_BusinessRules.
• All parent members must have the word Total in the description.
  • This will help in the formatting of the Cube Views: When referencing TXP_TopTax for Flow, TXP_TaxClosing will be the subtotal that is displayed.
  • TXP_GrossClosing and TXP_OtherFlow have an Aggregation Weight of zero assigned.

The screen shot below is a partially collapsed view of the Flow Dimension with the Schedules listed that are associated with members.

Do not change any of the Flow Member names included with Tax Provision Blueprint.

 TXP_GrossClosing & TXP_TaxClosing Setup Notes

 

• TXP_GrossClosing contains the Gross activity data for the Deferred Tax Roll Forward. TXP_TaxClosing contains the Tax Effected activity data for the Deferred Tax Roll Forward. This is also differentiated via the UD2 member.
• The only difference between the Gross and Tax Flow hierarchies is the TXP_RCTotal Parent and Children. These members hold the Rate Change Impact data which does not exist for Gross data.
• TXP_OtherOpenAdj_Dscr, TXP_TotalDefOther_NonDscr, TXP_TotalDefOther_Dscr and TXP_TotalDefBSO:
  • Base members may be added.
  • If the expected calculations for a new base member are the same as the siblings, no business rule modifications are required.
  • A new base member for any of these parents will also require a similar member to be added to the TXP_TaxLCTotalCF hierarchy. E.g.:
    • Add TXP_DefOther3 as a child of TXP_DefOther_NonDscr.
    • Add TXP_TLCDefOther3 as a child of TXP_TLCDefOther_NonDscr.
• TXP_AdjOpeningBal_NonDscr:
• Add new base member (e.g., TXP_DiscAdj with a Non-Discrete classification) requires updates to metadata, BR’s CV’s, etc.
  • New Flow Member required for TXP_TaxLCTotalCF
    • Add TXP_TLCDiscAdj as a child of TXP_TLCOpeningAdj_NonDscr.
    • Rules for Schedule 06 will need to be updated.
  • Update alternate flow hierarchies referenced in Business Rules:
    • Add TXP_DiscAdj as a child of TXP_ActivityTax, TXP_ETRNatBenOther, TXP_ETRLocalDefExpOther, TXP_ETRLocalVA.
    • Add TXP_TLCDiscAdj as a child of TXP_ActivityTLC.
  • No Input business rules may need to be modified.
  • Update Business Rules in section Schedule05_06_PartB (this is related to the National Benefit and Schedule 6b TXP_DefLocal account tax calculation).
  • New account required for Tax Account Reconciliation (TXP_TxRAccountRecon).
    • Most likely this should be added as a child of TXP_TxRAdjustedOpeningBal (e.g., TXP_TxRDiscAdj).
    • Rules for Schedule 07 will need to be updated.
  • Add new account required in the alternate hierarchy TXP_ETRVATotal as a child of TXP_ETRVA_NonDscr (e.g., TXP_ETRVADiscAdj).
    • Business Rules for Schedule 08 & Schedule 09 will need to be updated.
  • Add new account required in the alternate hierarchy TXP_ETRDeferredTotal as a child of TXP_ETRDeferred_NonDscr (e.g., TXP_ETRDiscAdj).
    • Business Rules for Schedule 08 & Schedule 09 will need to be updated.
• TXP_CYPL:
  • Add new base member (e.g., TXP_CYOther with a non-discrete classification as a sibling to TXP_CYProvision).
    • New Flow Member required for TXP_TaxLCTotalCF as a sibling of TXP_TLCExpiration (e.g., TXP_TLCCYOther).
      • Business Rules for Schedule 06 will need to be updated.
    • Update alternate flow hierarchies referenced in Business Rules:
      • Add TXP_CYOther as a child of TXP_ETRNatBenOther, TXP_ETRLocalDefExpOther.
      • Add TXP_TLCCYOther as a child of TXP_ActivityTLC.
    • New account required for Tax Account Reconciliation (TXP_TxRAccountRecon).
      • Most likely this should be added as a child of TXP_TxRDefProvision (e.g., TXP_TxRCYOther).
      • The Business Rules for Schedule 07 will need to be updated.
    • New account required in the alternate hierarchy TXP_ETRVATotal as a child of TXP_ETRVA_NonDscr (e.g., TXP_ETRVACYOther).
      • Business Rules for Schedule 08 & Schedule 09 will need to be updated.
    • New account required in the alternate hierarchy TXP_ETRDeferredTotal as a child of TXP_ETRVA_NonDscr (e.g., TXP_ETRCYOther).
      • Business Rules for Schedule 08 & Schedule 09 will need to be updated.
    • No Input business rules may need to be modified.
    • Metadata, BR’s, CV’s, and other objects will need to be updated.

Total Tax Loss/Credit Detail (TXP_TaxLCTotalCF)

This alternate hierarchy contains data related to Tax Attributes: Losses and Credits. This data can be tracked by the year that the Attribute was created. The Total of each Loss and Credit account is copied to the TXP_GrossClosing equivalent member via Business Rules.