ACCONSOL FILE
Activity Consolidation
This file maintains consolidation balances for the Activity Master and
Activity Budget files, as well as activity group total amounts. It includes
amounts and units beginning balances, amount and units current balances, and
life-to-date amount and units totals. Consolidation records are kept for
summary level activities if the Consolidate option is selected in AC00.1
(Activity Group). This file reports summary balances in activity group
currency.
REFERENCED BY
AC130 AC30.2 AC30.3 AC32.1 AC702 AC165
AC170 AC295 AC297 AC65.1 AC65.2 AC90.1
AC95.1 AC95.2 AC97.1 AC97.2 AC410 AC473
UPDATED BY
AC120 AC121 AC123 AC127 AC190 AC20.1
AC20.2 AC20.3 AC20.4 AC20.6 AC22.1 AC300
AC310 AC580 AC701 AC980
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSL-FISCAL-YEAR Numeric 4 AC120 AC121
Fiscal Year Required key. This is the fiscal year AC123 AC127
for the consolidation. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC580
AC701 AC980
CSL-BUDGET-NBR Numeric 3 AC120 AC121
Budget Number Required key. This is the budget number AC123 AC127
for the consolidation, as defined in the AC190 AC20.1
Activity Management system. AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC580
AC701 AC980
CSL-ACTIVITY-GRP Alpha 15 AC120 AC121
Activity Group This is the activity group for the AC123 AC127
consolidation. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC580
AC701 AC980
CSL-ACTIVITY Alpha 15 AC120 AC121
Activity Required key. This is the activity for AC123 AC127
the consolidation. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC580
AC701 AC980
CSL-ACCT-CATEGORY Alpha 5 AC120 AC121
Account Category Required key. This is the account AC123 AC127
category for the consolidation. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC580
AC701 AC980
CSL-LEVEL-DEPTH Numeric 1 AC120 AC190
Level Depth This field indicates the number of AC20.1 AC20.2
variable levels pertaining to this AC20.3 AC20.4
record. AC20.6 AC580
AC980
CSL-VAR-LEVELS Alpha 30 AC120 AC121
Variable Levels Levels define an addressing system that AC123 AC127
organizes activities into a reporting AC190 AC20.1
hierarchy. Level names are defined for AC20.2 AC20.3
an activity group and should be able to AC20.4 AC20.6
be used across all activities in an AC22.1 AC580
activity group. Levels facilitate rollup AC701 AC980
or consolidation of budgets, costs, and
revenues from activities at lower levels
to macro activities at a higher level
within the hierarchy.
CSL-BALANCE-AMOUNT Signed 17.2 AC120 AC121
Amount Balance This is the amount balance for the AC123 AC127
current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC310
AC580 AC701
AC980
CSL-BALANCE-UNIT Signed 17.2 AC120 AC121
Unit Balance This is the unit balance for the AC123 AC127
current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC310
AC580 AC701
AC980
CSL-BEGIN-BAL-AMT Signed 15.2 AC120 AC121
Amount Beginning This is the life-to-date amount up AC123 AC127
Balance until the start of the current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC310
AC580 AC701
AC980
CSL-BEGIN-BAL-UNT Signed 15.2 AC120 AC121
Unit Beginning This is the life-to-date units up until AC123 AC127
Balance the start of the current year. AC190 AC20.1
AC20.2 AC20.3
AC20.4 AC20.6
AC22.1 AC310
AC580 AC701
AC980
CSL-LTD-AMOUNT Derived
Life-to-Date Amount This is the sum of the Amount Balance
and the Amount Beginning Balance fields
for the fiscal year.
CSL-LTD-UNIT Derived
Life-to-Date Units This is the sum of the Unit Balance and
the Unit Beginning Balance fields for
the fiscal year.
CSL-ACCT-CAT-TYPE Derived
Acct Cat Type This is the account category type:
cost, revenue, or accrual.
ACCONSOL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSLSET1 FISCAL-YEAR AC120 AC121
BUDGET-NBR AC123 AC127
ACTIVITY-GRP AC130 AC190
ACTIVITY AC20.1 AC20.2
ACCT-CATEGORY AC20.3 AC20.4
AC20.6 AC22.1
AC30.2 AC30.3
AC32.1 AC580
AC701 AC702
AC980
CSLSET2 FISCAL-YEAR Duplicates
ACTIVITY-GRP
VAR-LEVELS
ACCT-CATEGORY
BUDGET-NBR
CSLSET3 FISCAL-YEAR KeyChange, Duplicates
ACTIVITY-GRP
VAR-LEVELS
ACCT-CATEGORY
BUDGET-NBR
LEVEL-DEPTH*
CSLSET4 ACTIVITY Duplicates AC121 AC123
BUDGET-NBR AC127 AC130
ACCT-CATEGORY AC165 AC170
FISCAL-YEAR* AC20.1 AC20.2
AC20.3 AC20.4
AC22.1 AC295
AC297 AC30.2
AC30.3 AC32.1
AC65.1 AC65.2
AC90.1 AC95.1
AC95.2 AC97.1
AC97.2
CSLSET5 ACTIVITY-GRP AC120 AC121
ACTIVITY AC123 AC127
ACCT-CATEGORY AC190 AC20.1
BUDGET-NBR AC20.2 AC20.3
FISCAL-YEAR* AC20.4 AC20.6
AC22.1 AC300
AC310 AC410
AC473 AC580
AC701 AC90.1
AC980
CSLSET6 FISCAL-YEAR
ACTIVITY-GRP
ACTIVITY
ACCT-CATEGORY
BUDGET-NBR
ACCONSOL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
CSL-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactgrp ACACTGRP Required
CSL-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
CSL-ACTIVITY -> ACV-ACTIVITY
Aclevel ACLEVEL Required
When CSL-VAR-LEVELS != Spaces
CSL-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
CSL-VAR-LEVELS -> LVL-VAR-LEVELS
ACCONSOL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acconsolx ACCONSOLX
CSL-FISCAL-YEAR -> CSX-FISCAL-YEAR
CSL-BUDGET-NBR -> CSX-BUDGET-NBR
CSL-ACTIVITY-GRP -> CSX-ACTIVITY-GRP
CSL-ACTIVITY -> CSX-ACTIVITY
CSL-ACCT-CATEGORY -> CSX-ACCT-CATEGORY
CSX-PERIOD
|