ACCONSOL

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
ACTA.1 AC65.1 AC65.2 BR65.1 BR65.2 BR65.3
ACDL.1 BR12.2 SNAC.1


UPDATED BY
AC121 AC123 AC127 AC130 AC165 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.6 AC20.7
AC21.5 AC22.1 AC297 AC300 AC32.1 AC37.1
AC40.1 AC40.4 AC41.1 AC41.4 AC42.1 AC45.4
AC46.1 AC472 AC473 AC490 AC493 AC93.4
AC93.5 ACAC.1 ACDR.1 AP125 AP126 AP131
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP30.4 AP520 API1.1
API2.1 BR130 BR165 BR41.1 BR41.4 BR43.1
BR430 BR530 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 CXCP.1 EE11.1 EE135 EE20.3 EE35.1
EE35.2 EE520 GL146 GL165 GL170 GL197
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL70.1 GL70.2 GL70.3 GL70.5 GL70.6
GL75.1 GL76.1 DR100 IC140 IC66.1 IC83.1
EX545 IFEB.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO100
PO101 PO122 PO131 PO136 PO150 PO190
PO20.1 PO20.6 PO20.9 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 PO54.5 POCP.1 POI3.1 POID.1 POIG.1
POII.1 POIJ.1 POIK.1 RQ10.1 RQ10.2 RQ10.4
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1
WH130 WH132 WH190 WH20.2 WH20.7 WH222
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
WH32.5 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.8 WH33.9 WH34.1 WH34.2 WH34.3
WH34.4 WH40.1 WH40.2 WH520 WH830 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CSL-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Required key. This is the fiscal year for the consolidation.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-BUDGET-NBR
Element: Budget Number
Numeric 3
Required key. This is the budget number for the consolidation, as defined in the Activity Management system.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-ACTIVITY-GRP
Element: Activity Group
Alpha 15
This is the activity group for the consolidation.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-ACTIVITY
Element: Activity
Alpha 15
Required key. This is the activity for the consolidation.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-ACCT-CATEGORY
Element: Account Category
Alpha 5
Required key. This is the account category for the consolidation.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the base currency code for the activity group. It must have been defined already in AC00.1 (Activity Group).
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-LEVEL-DEPTH
Element: Level Depth
Numeric 1
This field indicates the number of variable levels pertaining to this record.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-VAR-LEVELS
Element: Variable Levels
Alpha 30
Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-PARENT-ACTV
Element: Parent Actv
Alpha 15
The parent activity field contains the activity name of the member parent.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-BALANCE-AMOUNT
Element: Amount Balance
Signed 18.2
This is the amount balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-BALANCE-UNIT
Element: Unit Balance
Signed 17.2
This is the unit balance for the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-BEGIN-BAL-AMT
Amount Beginning
Balance
Signed 18.2
This is the life-to-date amount up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-BEGIN-BAL-UNT
Unit Beginning
Balance
Signed 15.2
This is the life-to-date units up until the start of the current year.
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-LTD-AMOUNT
Element: Life-to-Date Amount
Derived
This is the sum of the Amount Balance and the Amount Beginning Balance fields for the fiscal year.
CSL-LTD-UNIT
Element: Life-to-Date Units
Derived
This is the sum of the Unit Balance and the Unit Beginning Balance fields for the fiscal year.
CSL-ACCT-CAT-TYPE
Element: Acct Cat Type
Derived
This is the account category type: cost, revenue, or accrual.
CSL-PERIOD-AMT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1
CSL-PERIOD-UNIT
Element: Unit
Signed 15.2 Occurs 13 Times
AC121 AC123
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
ACDR.1


ACCONSOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CSLSET1 FISCAL-YEAR
BUDGET-NBR
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
ACCT-CATEGORY
AC121 AC123
AC127 AC130
AC165 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC297 AC32.1
AC37.1 AC473
AC490 AC65.1
AC65.2 ACDR.1
ACTA.1 BR165
BR65.1 BR65.2
BR65.3
CSLSET2 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR
...
AC121 AC123
AC127 AC165
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
AC22.1 AC297
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 ACAC.1
ACDR.1 AP125
AP126 AP131
AP170 AP193
AP20.1 AP20.2
CSLSET3 ACTIVITY-GRP
PARENT-ACTV
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
ACTIVITY
KeyChange
CSLSET4 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
BUDGET-NBR
ACCT-CATEGORY
FISCAL-YEAR*
KeyChange
...
AC121 AC123
AC127 AC130
AC165 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.5 AC22.1
AC297 AC32.1
AC37.1 AC472
AC473 AC490
AC65.1 AC65.2
ACDL.1 ACDR.1
ACTA.1 BR12.2
BR130 BR165
BR430 BR530
CSLSET5 ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
ACCT-CATEGORY
BUDGET-NBR
FISCAL-YEAR*
AC300 AC493
AC93.4 AC93.5
CSLSET6 FISCAL-YEAR
ACTIVITY-GRP
ACTIVITY
CURRENCY-CODE
ACCT-CATEGORY
BUDGET-NBR
SNAC.1


ACCONSOL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
CSL-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
CSL-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Not Required
CSL-ACTIVITY->ACV-ACTIVITY


ACCONSOL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acbuddtl Child ACBUDDTL
Valid When CSL-CURRENCY-CODE =CSL-CURRENCY-CODE
CSL-ACTIVITY-GRP->BDT-ACTIVITY-GRP
CSL-ACTIVITY->BDT-PARENT-ACTV
CSL-BUDGET-NBR->BDT-BUDGET-NBR
CSL-ACCT-CATEGORY->BDT-ACCT-CATEGORY
CSL-FISCAL-YEAR->BDT-FISCAL-YEAR
  BDT-ACTIVITY
Accntract ACCNTRACT
CSL-ACTIVITY->CNT-ACTIVITY
  CNT-CONTRACT
Accommit ACCOMMIT
CSL-ACTIVITY-GRP->MIT-ACTIVITY-GRP
CSL-ACTIVITY->MIT-ACTIVITY
CSL-ACCT-CATEGORY->MIT-ACCT-CATEGORY
CSL-FISCAL-YEAR->MIT-FISCAL-YEAR
  MIT-PERIOD
  MIT-SYSTEM
  MIT-COMPANY
  MIT-CURRENCY-CODE
Accommitx ACCOMMITX
CSL-ACTIVITY-GRP->MIX-ACTIVITY-GRP
CSL-ACTIVITY->MIX-ACTIVITY
CSL-ACCT-CATEGORY->MIX-ACCT-CATEGORY
CSL-FISCAL-YEAR->MIX-FISCAL-YEAR
  MIX-PERIOD
  MIX-SYSTEM
  MIX-COMPANY
  MIX-CURRENCY-CODE
  MIX-ATN-OBJ-ID
Acconsol Child ACCONSOL
Valid When CSL-ACTIVITY !=Spaces
CSL-ACTIVITY-GRP->CSL-ACTIVITY-GRP
CSL-ACTIVITY->CSL-PARENT-ACTV
CSL-CURRENCY-CODE->CSL-CURRENCY-CODE
CSL-BUDGET-NBR->CSL-BUDGET-NBR
CSL-ACCT-CATEGORY->CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR->CSL-FISCAL-YEAR
  CSL-ACTIVITY
Accuamt Child ACCUAMT
CSL-ACTIVITY-GRP->ACU-ACTIVITY-GRP
CSL-ACTIVITY->ACU-PARENT-ACTV
CSL-CURRENCY-CODE->ACU-CURRENCY-CODE
CSL-BUDGET-NBR->ACU-BUDGET-NBR
CSL-ACCT-CATEGORY->ACU-ACCT-CATEGORY
CSL-FISCAL-YEAR->ACU-FISCAL-YEAR
  ACU-ACTIVITY
Acmaster Child ACMASTER
Valid When CSL-CURRENCY-CODE =CSL-CURRENCY-CODE
CSL-ACTIVITY-GRP->MST-ACTIVITY-GRP
CSL-ACTIVITY->MST-PARENT-ACTV
CSL-ACCT-CATEGORY->MST-ACCT-CATEGORY
CSL-FISCAL-YEAR->MST-FISCAL-YEAR
  MST-ACTIVITY
Actrans ACTRANS
CSL-ACTIVITY->ATN-ACTIVITY
CSL-ACCT-CATEGORY->ATN-ACCT-CATEGORY
CSL-FISCAL-YEAR->ATN-FISCAL-YEAR
  ATN-PERIOD
  ATN-OBJ-ID


File created: Thu Jun 09 11:04:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.