Skip to main content

(PFC) Column Descriptions

Author: Graham Eger, Created: 2026-03-27

none

Aging Changes​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • AvgAgingDays

    • Represents the average aging days of a reconciliation's detail items in the current period.

  • AvgAgingDaysDeltaPrevPeriod

    • Represents the change in average aging days of a reconciliation’s detail items compared to the previous period.

  • NumItems

    • Specifies the number of reconciliation detail items in the current period.

  • RollingMean3

    • Represents the average aging days of a reconciliation’s detail items over the past three periods.

  • RollingMean6

    • Represents the average aging days of a reconciliation’s detail items over the past six periods.

  • ZScore

    • Compares the change in average aging days from the prior period against historical values to show if the current period is unusually higher (positive) or lower (negative). Two-tailed critical values are +/- 1.645 (10%), +/- 1.960 (5%), and +/- 2.576 (1%).

  • RollingZScore

    • Compares the change in average aging days from the prior period against the prior three periods to show if the current period is unusually higher (positive) or lower (negative). Two-tailed critical values are +/- 1.645 (10%), +/- 1.960 (5%), and +/- 2.576 (1%).

  • PValue

    • Indicates how likely the current change in average aging days follows historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • IQRFlag

    • Returns True if the current change in average aging days is outside the interquartile range (middle 50%) of historical data.

  • TukeyFenceFlag

    • Returns True if the current change in average aging days falls outside the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • AvgAgingDaysPctChg

    • Represents the percentage change in a reconciliation’s average aging days by comparing the current period to the previous period.

  • AvgAgingDaysMeanPrev

    • Represents the average aging days of the reconciliation across all prior periods.

  • AgingItemsOnlyAvg

    • Represents the average aging days of reconciliation detail items in the current period that have aging > 0 (i.e., only items actually aging).

  • AgingItemsOnlyAvgDeltaPrevPeriod

    • Represents the change in average aging days for the reconciliation's aging items only, comparing the current period to the previous period.

  • AvgAgingDaysDeltaPrevPeriodAbs

    • Represents the absolute change in a reconciliation’s average aging days from the previous period, reported as a positive value regardless of direction.

  • MaxAgingDays

    • Represents the maximum aging days of a detail item in the reconciliation for the current period.

Aged Item Commentary​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • Aged{t}Count

    • Represents the number of reconciliation detail items aged beyond a specified threshold (t) in the current period, providing a baseline for detecting shifts in aging patterns that may signal process or data quality issues.

  • Aged{t}NoComment

    • Represents the number of aged reconciliation detail items beyond the specified threshold (t) that lack commentary in the current period, helping identify reconciliations that are not meeting organizational expectations for documentation.

  • Aged{t}CountLookback

    • Represents the number of aged reconciliation detail items beyond the specified threshold (t) across all periods in the lookback window, providing a historical count of items in the aging bucket.

  • Aged{t}NoCommentLookback

    • Represents the number of aged reconciliation detail items beyond the specified threshold (t) that are missing commentary across all periods in the lookback window, providing a historical count of missing commentary within the aging bucket.

  • PctNoComment{t}Current

    • Represents the percentage of aged items beyond the specified threshold (t) missing commentary in the current period, highlighting reconciliations that lack sufficient commentary on aged items.

  • PctNoComment{t}Prior

    • Represents the percentage of aged items beyond the specified threshold (t) missing commentary across prior periods, providing a historical baseline for documentation coverage to compare with current practices.

  • PctNoComment{t}Diff

    • Represents the difference in commentary coverage rates between the current and prior periods for any aged item beyond a specified threshold (t). Positive values indicate that the current period has a higher percentage of aged items without comments, while negative values indicate a lower percentage of aged items without comments.

  • HasAgedItems{t}

    • Returns True if the reconciliation has any aged items beyond the specified threshold (t) in the current period.

Check Balance I-Items​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • BItemCount

    • Represents the number of B-Items (Balance Check items) in the current period that were automatically balanced without manual intervention.

  • IItemCount

    • Represents the number of I-Items (manual items) in the current period that required manual review or intervention.

  • TotalItems

    • Represents the total number of reconciliation detail items in the current period, calculated as the sum of B-Items and I-Items.

  • BItemPct

    • Indicates the percentage of B-Items relative to the total number of items in the current period, reflecting the degree of automation within the reconciliation.

  • IItemPct

    • Indicates the percentage of I-Items relative to the total number of items in the current period, reflecting the extent of manual intervention that the reconciliation required.

  • BItemMeanPrevPct

    • Represents the mean percentage of B-Items across all prior periods, providing a baseline for the usage of Balance Check in the reconciliation’s history.

  • IItemMeanPrevPct

    • Represents the mean percentage of I-Items across all prior periods, providing a baseline for the usage of manual intervention in the reconciliation's history.

  • BItemPctDiff

    • Indicates the difference between the current period’s B-Item percentage and the mean percentage from prior periods.

  • IItemPctDiff

    • Indicates the difference between the current period’s I-Item percentage and the mean percentage from prior periods.

I-Doc Sparsity​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • NumDetailItems

    • Represents the total number of reconciliation detail items in the current period (I-Items, T-Items, S-Items, and X-Items).

  • IItemCount

    • Represents the number of I-Items (manual items) in the current period that require manual review or intervention.

  • IItemsIDocCount

    • Represents the number of I-Items with I-Docs (supporting documents) attached in the current period.

  • IItemsPctWithIDoc

    • Indicates the percentage of I-Items with I-Docs attached relative to the total number of I-Items in the current period.

  • IItemPctWithIDocPrev

    • Indicates the percentage of I-Items with I-Docs attached in the previous period, providing a baseline for comparison.

  • IItemsPctWithIDocPctChange

    • Indicates the percentage change in the share of I-Items with I-Docs attached, comparing the current period to the previous period.

  • PValue

    • Indicates how likely the current period's percentage of I-Items with I-Docs attached has decreased compared to the historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • IQRFlag

    • Returns True if the current period's percentage of I-Items with I-Docs attached falls below the interquartile range (middle 50%) of historical data.

  • TukeyFenceFlag

    • Returns True if the current period's percentage of I-Items with I-Docs attached falls below the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • ZScore

    • Compares the change in average aging days from the prior period against historical values to show if the current period is unusually lower (negative). The one-tailed critical values for decreases are -1.282 (10%), -1.645 (5%), -2.326 (1%), and -2.576 (0.5%).

  • RollingZScore

    • Compares the percentage of I-Items with I-Docs attached in the current period against the prior three periods to show if the current period is unusually lower (negative).

  • LookbackMean

    • Represents the mean percentage of I-Items with I-Docs attached across all prior periods.

  • RollingMean3

    • Represents the three-period rolling average percentage of I-Items with I-Docs attached.

Manual Auto Rec Ratio​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • AutoRecRuleName

    • The name of the auto-reconciliation/auto-prepared rule linked to the reconciliation.

  • PrepareOnly

    • Returns True if the reconciliation is configured as preparation only.

  • AutoPrepared

    • Returns True if the reconciliation is automatically prepared in the current period.

  • AutoApproved

    • Returns True if the reconciliation is automatically approved in the current period.

  • ManuallyPrepared

    • Returns True if the reconciliation is manually prepared in the current period.

  • ManuallyApproved

    • Returns True if the reconciliation is manually approved in the current period.

  • LookbackAutoCount

    • Represents the total number of periods in the lookback window where the reconciliation was automatically processed.

  • LookbackManualCount

    • Represents the total number of periods in the lookback window where the reconciliation was manually processed.

  • LookbackConsecutiveAuto

    • Represents the number of consecutive periods in the lookback window where the reconciliation was automatically processed.

  • LookbackPctAuto

    • Represents the percentage of periods in the lookback window where the reconciliation was automatically processed.

  • LookbackPctManual

    • Represents the percentage of periods in the lookback window where the reconciliation was manually processed.

  • ZeroBalance

    • Returns True if the auto-reconciliation rule is configured to AutoRec if the reconciliation has a balance of zero (as set in the auto-reconciliation rules).

  • Activity

    • Returns True if the auto-reconciliation rule is configured to AutoRec if the reconciliation has no Activity (as set in the auto-reconciliation rules).

  • BItems

    • Returns True if the auto-reconciliation rule is configured to allow reconciliations to AutoRec if a B-Item is provided and all other criteria are met (as set in the auto-reconciliation rules).

  • IItems

    • Returns True if the auto-reconciliation rule is configured to allow reconciliations to AutoRec if an I-Item created in the current period exists (as set in the auto-reconciliation rules).

  • SItems

    • Returns True if the auto-reconciliation rule is configured to allow reconciliations to AutoRec if multi-period templates, S-Items, are used to support the reconciliation’s balance (as set in the auto-reconciliation rules).

  • PulledItems

    • Returns True if the auto-reconciliation rule is configured to allow any pulled items from prior periods to AutoRec if the balance is within the Unexplained Limit (as set in the auto-reconciliation rules).

  • XItems

    • Returns True if the auto-reconciliation rule is configured to allow X-Items created from Transaction Matching to AutoRec if it ties to the reconciling balance (as set in the auto-reconciliation rules).

Number of Approvers​

  • NumApprovers

    • Represents the reconciliation's number of approvers required in the current period.

  • NumApproversPrev

    • Represents the reconciliation’s number of approvers required in the previous period.

  • ApproverDiff

    • Represents the difference between the current and previous period approver counts, highlighting increases or decreases in approval requirements.

  • ApproverRatio

    • Represents the ratio of current to previous period approver counts, with values less than 1.0 indicating reduced approval requirements.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Number of I-Items​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • IItemCount

    • Represents the number of I-Items (manual items) in the current period.

  • IItemPct

    • Indicates the percentage of I-Items relative to the total number of detail items (I-Items, T-Items, S-Items, and X-Items) in the current period, calculated as IItemCount divided by TotalDetailItemCount.

  • TotalDetailItemCount

    • Represents the total number of reconciliation detail items in the current period (I-Items, T-Items, S-Items, and X-Items).

  • IItemCountPctChg

    • Indicates the percentage change in I-Item count compared to the previous period.

  • IItemCountPctChgAbs

    • Indicates the absolute percentage change in I-Item count compared to the previous period, showing the magnitude of change.

  • PValue

    • Indicates how likely the current period’s number of I-Items follows historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • IQRFlag

    • Returns True if the number of I-Items in the current period is outside the interquartile range (middle 50%) of historical data.

  • TukeyFenceFlag

    • Returns True if the current period’s number of I-Items is outside the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • ZScore

    • Compares the current period's number of I-Items against historical values to show if the current period is unusually higher (positive) or lower (negative). Two-tailed critical values are +/- 1.645 (10%), +/- 1.960 (5%), and +/- 2.576 (1%).

  • RollingZScore

    • Compares the current period's number of I-Items against the prior three periods to show if the current period is unusually higher (positive) or lower (negative). Two-tailed critical values are +/- 1.645 (10%), +/- 1.960 (5%), and +/- 2.576 (1%).

  • IItemCountPrev

    • Represents the number of I-Items in the previous period.

  • IItemCountDiff

    • Represents the difference between the current and previous period I-Item counts, with positive values indicating increases and negative values indicating decreases.

  • IItemCountAbsDiff

    • Represents the absolute difference between the current and previous period I-Item counts, showing the magnitude of change regardless of direction.

  • IItemCountLookbackMean

    • Represents the mean number of I-Items across all prior periods in the lookback window.

  • IItemCountRollingMean3

    • Represents the three-period rolling average number of I-Items to reflect the recent trend.

Number of Reconciliation Detail Items​

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

  • ItemCount

    • Represents the total number of reconciliation detail items in the current period.

  • ItemBalanceTotal

    • Represents the total absolute balance of reconciliation detail items in the current period.

  • ItemBalanceAvg

    • Represents the average absolute balance of reconciliation detail items in the current period.

  • ItemCountPctChg

    • Indicates the percentage change in item count compared to the previous period.

  • ItemCountPctChgAbs

    • Indicates the absolute percentage change in item count compared to the previous period, showing the magnitude of change regardless of direction.

  • ItemCountMeanPrev

    • Represents the mean number of detail items across all prior periods in the lookback window, providing a historical baseline for comparison.

  • PValue

    • Indicates how likely the current period’s number of detail items follows historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • ZScore

    • Compares the current period's number of detail items against historical values to show if the current period is unusually higher (positive) or lower (negative).

  • RollingZScore

    • Compares the change in average aging days from the prior period against the prior three periods to show if the current period is unusually higher (positive) or lower (negative).

  • IQRFlag

    • Returns True if the number of detail items in the current period is outside the interquartile range (middle 50%) of historical data.

  • TukeyFenceFlag

    • Returns True if current period’s number of detail items is outside the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • PrevItemBalanceAvg

    • Represents the average absolute balance of reconciliation detail items in the previous period.

  • PrevItemBalanceTotal

    • Represents the total absolute balance of reconciliation detail items in the previous period.

  • PrevItemCount

    • Represents the number of reconciliation detail items in the previous period.

  • ItemCountDiff

    • Represents the difference between the current and previous period item counts.

  • ItemCountAbsDiff

    • Represents the absolute difference between the current and previous period item counts.

  • AvgItemBalanceMeanPrev

    • Represents the mean item balance across all prior periods in the lookback window.

  • ItemBalanceTotalMeanPrev

    • Represents the mean total item balance across all prior periods in the lookback window.

  • RepetitiveDetailItemsFlag

    • Returns True if the reconciliation contains repetitive detail items that appear in both the current and previous period with matching names, balances, and aging days equal to zero.

R-Doc Sparsity​

  • NumRDocs

    • Represents the number of R-Docs attached to the reconciliation in the current period.

  • HasRDoc

    • Returns True if the reconciliation has any R-Docs attached in the current period.

  • Prior3RDocUsagePct

    • Indicates the percentage of periods with R-Docs attached over the prior three periods.

  • Prior6RDocUsagePct

    • Indicates the percentage of periods with R-Docs attached over the prior six periods.

  • Prior9RDocUsagePct

    • Indicates the percentage of periods with R-Docs attached over the prior nine periods.

  • Prior12RDocUsagePct

    • Indicates the percentage of periods with R-Docs attached over the prior twelve periods.

  • Prior18RDocUsagePct

    • Indicates the percentage of periods with R-Docs attached over the prior eighteen periods.

  • Prior3NumRDocsMean

    • Represents the mean number of R-Docs attached over the prior three periods.

  • RDocRatioCurrentVsPrior3

    • Indicates the ratio of the current period R-Doc count to the prior three-period average, with values greater than 1.0 showing increased usage and less than 1.0 showing decreased usage.

  • TotalRDocUsagePct

    • Indicates the cumulative percentage of periods with R-Docs attached across all historical periods, providing an all-time baseline for comparison.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Reconciliation Balance​

  • Balance

    • Represents the reconciliation balance amount in the current period.

  • BalancePrev

    • Represents the reconciliation balance amount from the previous period.

  • BalancePctChg

    • Indicates the percentage change in balance from the previous period to the current period.

  • BalancePctChgAbs

    • Reports the magnitude of the percentage change as a positive value, even if the actual change is negative.

  • BalanceDiff

    • Represents the difference in balance between the current period and the previous period, with positive values indicating increases and negative values indicating decreases.

  • BalanceAbsDiff

    • Reports the magnitude of the change as a positive value, even if the change is negative.

  • PValue

    • Indicates how likely the current period’s balance follows historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • IQRFlag

    • Returns True if the current period’s balance is outside the interquartile range (middle 50%) of historical data.

  • TukeyFenceFlag

    • Returns True if the current period’s balance is outside the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • ZScore

    • Compares the current balance against historical values to show if the current period is unusually higher (positive) or lower (negative). Two-tailed critical values are +/- 1.645 (10%), +/- 1.960 (5%), and +/- 2.576 (1%).

  • RollingZScore

    • Compares the current period's balance from the prior period against the prior three periods to show if the current period is unusually higher (positive) or lower (negative).

  • LookbackMean

    • Represents the mean balance across all periods in the lookback window for the reconciliation.

  • RollingMean3

    • Represents the three-period rolling average balance for the reconciliation.

  • BalanceDiffStd

    • Represents the standard deviation of balance differences across all periods in the lookback window.

  • BalanceDiffRollingStd

    • Represents the rolling standard deviation of balance differences over a three-period window.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Reconciliation Detail Text Field Length​

  • TotalCharCount

    • Represents the total character count across ItemName, ItemComment, Reference1, and Reference2 for reconciliation detail items in the current period.

  • AvgCharCount

    • Represents the average character count across ItemName, ItemComment, Reference1, and Reference2 per reconciliation detail item in the current period.

  • LookbackTotalCharCountMedian

    • Represents the median total character count across all prior periods in the lookback window.

  • LookbackTotalCharCountMean

    • Represents the mean total character count across all prior periods in the lookback window.

  • LookbackAvgCharCountMedian

    • Represents the median average character count per detail item across all prior periods in the lookback window.

  • LookbackAvgCharCountMean

    • Represents the mean of the reconciliation’s average character count per detail item, calculated across all prior periods within the lookback window.

  • TotalCharCountDeltaPrevPeriod

    • Represents the difference in total character count between the current period and the previous period.

  • TotalCharCountPctChgPrevPeriod

    • Indicates the percentage change in total character count from the previous period to the current period.

  • TotalCharCountTukeyFenceFlag

    • Returns True if the current period’s total character count is less than the lower bound the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • TotalCharCountIQRFlag

    • Returns True if the current period’s total character count is below the lower bound of the interquartile range (middle 50%) of historical data.

  • TotalCharCountRollingMedianWin3

    • Represents the three-period rolling median of total character count for the reconciliation.

  • TotalCharCountMeanWin3

    • Represents the three-period rolling mean of total character count for the reconciliation.

  • TotalCharCountZScore

    • Compares the current period’s total character count against historical values to show if the current period is unusually lower (negative) than prior periods. The one-tailed critical values for decreases are -1.282 (10%), -1.645 (5%), -2.326 (1%), and -2.576 (0.5%).

  • TotalCharCountRollingAvgPctChg

    • Indicates the three-period rolling average of the percentage change in total character count.

  • TotalCharCountRollingZScore

    • Compares the current period’s total character count against prior three periods to show if the current period is unusually lower (negative) than prior periods. The one-tailed critical values for decreases are -1.282 (10%), -1.645 (5%), -2.326 (1%), and -2.576 (0.5%).

  • TotalCharCountPValue

    • Indicates how likely the current period’s total character count decreased compared to the historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • AvgCharCountDeltaPrevPeriod

    • Represents the difference in average character count per detail item between the current period and the previous period.

  • AvgCharCountPctChgPrevPeriod

    • Indicates the percentage change in average character count per detail item from the previous period to the current period.

  • AvgCharCountTukeyFenceFlag

    • Returns True if the current period’s average character count is below the lower bound of the Tukey Fence, which extends the interquartile range (IQR) to set stricter limits and identify more extreme outliers than the IQRFlag.

  • AvgCharCountIQRFlag

    • Returns True if the current period’s average character count is below the lower bound of the interquartile range (middle 50%) of historical data.

  • AvgCharCountRollingMedianWin3

    • Represents the three-period rolling median of average character count per detail item.

  • AvgCharCountRollingMeanWin3

    • Represents the three-period rolling mean of average character count per detail item.

  • AvgCharCountZScore

    • Compares the current period’s average character count against historical values to show if the current period is lower (negative) than prior periods. The one-tailed critical values for decreases are -1.282 (10%), -1.645 (5%), -2.326 (1%), and -2.576 (0.5%).

  • AvgCharCountRollingZScore

    • Compares the change in average aging days from the prior period against the prior three periods to show if the current period is unusually lower (negative) than prior periods. The one-tailed critical values for decreases are -1.282 (10%), -1.645 (5%), -2.326 (1%), and -2.576 (0.5%).

  • AvgCharCountPValue

    • Indicates how likely the current period’s average character count per detail item has decreased compared to the historical patterns. Smaller P-values (e.g., 0.10, 0.05, 0.01) suggest the current period is inconsistent with historical values and more likely anomalous.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Repetitive Rejections​

  • RejectedInCurrentPeriod

    • Returns True if the reconciliation was rejected in the current period.

  • RejectionCountInCurrentPeriod

    • Represents the total number of rejections that occurred in the current period.

  • PctOfPeriodsWithARejection

    • Indicates the percentage of periods that included at least one rejection for the reconciliation.

  • MeanRejectionsPerPeriod

    • Represents the average number of rejections per period for a reconciliation.

  • LookbackConsecutivePeriodsWithARejection

    • Represents the number of consecutive prior periods with at least one rejection.

  • LookbackPctOfPeriodsWithARejection

    • Indicates the percentage of periods with at least one rejection in the lookback window.

  • LookbackCountOfPeriodsWithARejection

    • Represents the total number of periods with at least one rejection in the lookback window.

  • LookbackTotalNumberOfRejections

    • Represents the total number of rejections across all periods in the lookback window.

  • LookbackMeanRejectionsPerPeriod

    • Represents the average number of rejections per period in the lookback window.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Risk Level Fluctuations​

  • RiskLevel

    • Represents the risk level for the reconciliation in the current period, which is either “High,” “Medium,” “Low,” or “Unknown.”

  • RiskLevelPriorPeriod

    • Represents the reconciliation’s risk level from the previous period.

  • RiskLevel2PriorPeriods

    • Represents the reconciliation’s risk level from two periods ago.

  • RiskLevel3PriorPeriods

    • Represents the reconciliation’s risk level from three periods ago.

  • RiskChangeFromPriorPeriodsAbs

    • Represents the absolute change in risk level compared to the previous period (ignores direction).

  • RiskChangeFrom2PriorPeriodsAbs

    • Represents the absolute change in risk level compared to two periods ago (ignores direction).

  • RiskChangeFrom3PriorPeriodsAbs

    • Represents the absolute change in risk level compared to three periods ago (ignores direction).

  • RiskChangeFromPriorPeriod

    • Represents the directional change in risk level compared to the previous period.

  • RiskChangeFrom2PriorPeriods

    • Represents the directional change in risk level compared to two periods ago.

  • RiskChangeFrom3PriorPeriods

    • Represents the directional change in risk level compared to three periods ago.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

S-Doc Sparsity​

  • NumSDocs

    • Represents the number of S-Docs attached to the reconciliation in the current period.

  • HasSDoc

    • Returns True if the reconciliation has any S-Docs attached in the current period.

  • Prior3SDocUsagePct

    • Indicates the percentage of periods with S-Docs attached over the prior three periods.

  • Prior6SDocUsagePct

    • Indicates the percentage of periods with S-Docs attached over the prior six periods.

  • Prior9SDocUsagePct

    • Indicates the percentage of periods with S-Docs attached over the prior nine periods.

  • Prior12SDocUsagePct

    • Indicates the percentage of periods with S-Docs attached over the prior twelve periods.

  • Prior18SDocUsagePct

    • Indicates the percentage of periods with S-Docs attached over the prior eighteen periods.

  • Prior3NumSDocsMean

    • Represents the mean number of S-Docs attached over the prior three periods.

  • SDocRatioCurrentVsPrior3

    • Indicates the ratio of the current period S-Doc count to the prior three-period average, with values greater than 1.0 showing increased usage and less than 1.0 showing decreased usage.

  • TotalSDocUsagePct

    • Indicates the cumulative percentage of periods with S-Docs attached across all historical periods, providing an all-time baseline for comparison.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

Sign Difference​

  • Balance

    • Represents the reconciliation’s balance amount in the current period.

  • ProperSign

    • Represents the assigned proper sign for the reconciliation as labeled by the admin; values are “Positive,” “Negative,” or “Unassigned.”

  • IsProperSignAssigned

    • Returns True if a proper sign has been assigned to the reconciliation.

  • BalanceSign

    • Represents the sign of the current period balance, categorized as “Positive,” “Negative,” or “Zero.”

  • ProperSignPrevious

    • Represents the assigned proper sign from the previous period.

  • BalanceSignPrevious

    • Represents the sign of the balance from the previous period.

  • SignChangedFromPriorPeriod

    • Returns True if the balance sign changes from the prior period, excluding zero balances in either period (e.g., a zero balance in the current period is not flagged even if the prior period was positive or negative).

  • BalanceSignDifferentFromMode

    • Returns True if the current balance sign differs from the historical mode of prior periods, excluding zero values (e.g., a zero balance in the current period is not flagged if the mode of prior periods was positive or negative).

  • BalanceSignDifferentFromAssignedProperSign

    • Returns True if the current balance sign differs from the assigned proper sign.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.

T-Doc Sparsity​

  • NumTDocs

    • Represents the number of T-Docs attached to the reconciliation in the current period.

  • HasTDoc

    • Returns True if the reconciliation has any T-Docs attached in the current period.

  • Prior3TDocUsagePct

    • Indicates the percentage of periods with T-Docs attached over the prior three periods.

  • Prior6TDocUsagePct

    • Indicates the percentage of periods with T-Docs attached over the prior six periods.

  • Prior9TDocUsagePct

    • Indicates the percentage of periods with T-Docs attached over the prior nine periods.

  • Prior12TDocUsagePct

    • Indicates the percentage of periods with T-Docs attached over the prior twelve periods.

  • Prior18TDocUsagePct

    • Indicates the percentage of periods with T-Docs attached over the prior eighteen periods.

  • Prior3NumTDocsMean

    • Represents the mean number of T-Docs attached over the prior three periods.

  • TDocRatioCurrentVsPrior3

    • Indicates the ratio of the current period T-Doc count to the prior three-period average, with values greater than 1.0 showing increased usage and less than 1.0 showing decreased usage.

  • TotalTDocUsagePct

    • Indicates the cumulative percentage of periods with T-Docs attached across all historical periods, providing an all-time baseline for comparison.

  • NumberOfLookbackPeriods

    • Specifies the number of historical periods required (e.g., at least four) before a reconciliation can be flagged as an anomaly.
Last updated on by Nic Napoleone

Was this page helpful?