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
AC130 AC165 AC297 AC32.1 AC37.1 AC473
AC490 AC65.1 AC65.2 ACTA.1 BR165 BR65.1
BR65.2 BR65.3 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC45.4 AC46.1 AC540 ACAC.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
AP510 AP520 API1.1 API2.1 BR41.1 BR41.4
BR43.1 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 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 EX545 IFEB.1 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 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 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.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 AC472 ACDL.1 BR12.2
BR130 BR430 BR530 AC493 AC93.4 AC93.5
SNAC.1


UPDATED BY
AC10.1 AC121 AC123 AC127 AC20.1 AC20.2
AC20.3 AC20.4 AC20.5 AC20.6 AC20.7 AC21.5
AC22.1 AC300 ACDR.1

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
...
AC10.1 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
AC540 ACAC.1
ACDR.1 AP125
AP126 AP131
AP170 AP193
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 02:03:02 2016

Home
Contact Us



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