1. Administrator's Guide
  2. Validating Data and Metadata
  3. Validation Process

Validation Process

During the validation process, the system performs these checks:

Equity Reversal Accounts

For Equity Reversal accounts, you must specify the corresponding reversal account.

If the account containing the EqRevN keyword for Equity Perm/Temp Reversal is National, then the corresponding reversal account must be a descendant of the CurrentAddtlCalcTotal account.

If the account containing the EqRevR keyword for Equity Perm/Temp Reversal is Regional, then the corresponding reversal account must be a descendant of the RCurrentAddtlCalcTotal account.

The reversal account should be set as Calculated.

Account Members ClassSign Property

ClassSign property should be allowed only if ClassLevel is defined.

Tax accounts that contain the ClassSign property in the UD field must have only the ClassLevel property defined as Yes.

Account Members ClassLevel Property

Accounts with ClassLevel property in the UD field must adhere to these rules:

  • If multiple parents exist for the account with ClassLevel property, the Default Parent field must be specified for the account, because the Default Parent information is used for the parent check.

  • All siblings of the account with ClassLevel property must have the same ClassLevel property value. <Blank> is the same as the value Yes.

  • For the parents of the account with ClassLevel property, some parent members should have ClassLevel:Yes.

Tax AccountTop Member

The TopMember of all Tax Accounts should have the following information:

RollForward dimension—Must be ClosingPlusTaxMovement

DataCategory dimension—Must be one of the following members:

  • PreTaxCETR

  • PreTaxNational

  • PreTaxNationalCETR

  • PreTaxNationalCurrent

  • PreTaxNationalNonCurrent

  • PreTaxNationalRegional

  • PreTaxNationalRegionalCETR

  • PreTaxNationalRegionalCurrent

  • PreTaxNationalRegionalNonCurrent

  • PreTaxRegional

  • PreTaxRegionalCurrent

  • PreTaxRegionalNonCurrent

  • TaxNational

  • TaxNationalCurrent

  • TaxNationalNonCurrent

  • TaxRegional

  • TaxRegionalCurrent

  • TaxRegionalNonCurrent

  • AppRegional

  • AppRegionalCurrent

Children of Net Income Before Tax

DataCategoryTopMember assignment for the following accounts:

  • Base members of A#NIBTAdjusted - Must be PreTaxNationalRegional

  • Children of A#PermSTTotal - Must be PreTaxNationalRegional

  • Children of A#PermGSTotal - Must be PreTaxNationalRegional

  • Children of A#TempSTTotal - Must be either PreTaxNationalRegionalCurrent or PreTaxNationalRegionalCurrent

  • Children of A#TempGSTotal - Must be either PreTaxNationalRegionalCurrent or PreTaxNationalRegionalCurrent

Netting Properties for Entities

When Netting properties are defined for the Entity member, these rules must be validated:

  • The NettingNat and NettingReg keywords must have a value of Yes or No.

  • The NettingNat and NettingReg keywords are allowed only at parent entity level.

  • When NettingNat is Yes, all base children of the parent entity should have the same Domicile.

  • When NettingNat is Yes, no other descendant member should have NettingNat set to Yes.

  • When NettingNat is No, no other descendant member should have NettingNat set to Yes.

Entity Base Members

Every base entity member must contain a Domicile keyword in the UD field, and the Domicile country specified must be a valid member of JD#AllNational.

Regional Jurisdiction

For the members of the Regional hierarchy in the Jurisdiction dimension, the parent member must have the label with the format of "<country_code>_Region", for example, US_Region.

This parent member must contain at least one child member named "<country code>_Blended", for example, US_Blended.

Additional Jurisdiction members must have the label of "<country code>_xx", for example, US_CT.