ACLEVEL FILE
Activity Levels
This file contains information on variable levels from AC10.1 (Activity). It
includes level, level depth, activity level detail, and posting flag.
REFERENCED BY
AC01.1 AC105 AC11.1 AC112 AC121 AC123
AC127 AC13.2 AC13.3 AC130 AC135 AC160
AC165 AC170 AC190 AC191 AC192 AC196
AC198 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.7 AC203 AC206 AC207 AC210 AC213
AC218 AC22.1 AC220 AC240 AC256 AC258
AC261 AC265 AC27.1 AC29.1 AC290 AC295
AC297 AC298 AC30.1 AC30.2 AC30.3 AC30.4
AC32.1 AC34.1 AC35.1 AC36.1 AC40.1 AC40.4
AC400 AC401 AC41.1 AC41.4 AC410 AC412
AC42.1 AC420 AC421 AC440 AC45.1 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC50.1 AC530 AC54.1 AC54.2 AC54.3
AC540 AC541 AC542 AC55.1 AC550 AC551
AC65.1 AC65.2 AC66.1 AC70.1 AC70.4 AC90.1
AC90.2 AC90.4 AC90.6 AC90.8 AC92.1 AC92.2
AC92.4 AC92.6 AC93.1 AC93.2 AC93.3 AC93.4
AC93.5 AC94.1 AC94.2 AC94.4 AC94.6 AC95.1
AC95.2 AC95.4 AC95.6 AC97.1 AC97.2 AC97.4
AC97.6 ACAC.1 ACBA.1 ACDL.1 ACDR.1 ACVW.1
DA233 DA240 GR240 SE90.1 AR250 AR251
AR30.1 AR30.2 AR30.3 AR30.5 DA90.1 DA91.1
BR00.1 BR00.2 BR00.3 BR01.2 BR01.3 BR02.1
BR02.3 BR03.1 BR03.2 BR03.3 BR05.1 BR05.2
BR05.3 BR05.4 BR05.5 BR10.1 BR120 BR121
BR130 BR131 BR142 BR165 BR200 BR202
BR204 BR205 BR210 BR220 BR265 BR40.3
BR40.4 BR400 BR405 BR41.1 BR420 BR430
BR450 BR65.1 BR65.2 BRCC.1 MX123 MX223
MX500 AC58.1
UPDATED BY
AC10.1 AC110 AC120 AC300 AC310 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LVL-ACTIVITY-GRP Alpha 15 AC10.1 AC110
Activity Group Required key. This is the activity AC120 AC500
group for the activity.
LVL-VAR-LEVELS Alpha 30 AC10.1 AC110
Variable Levels Required key. Levels define an AC120 AC500
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.
LVL-ACTIVITY Alpha 15 AC10.1 AC110
Activity This is the activity for the levels. AC500
LVL-POSTING-FLAG Alpha 1 AC10.1 AC110
Posting Flag This field indicates whether this level AC400 AC493
is the posting or the summary level. AC494 AC500
Posting should be done at the lowest
level and summary at the higher levels.
P = Posting
S = Summary
C = Contract
LVL-VAR-LEVEL-DISP Alpha 34 AC10.1 AC110
Variable Level The level structure for the activity AC120 AC500
Display displays.
LVL-LEVEL-DEPTH Numeric 1 AC10.1 AC110
Level Depth This is the number of variable levels AC120 AC500
pertaining to this activity.
LVL-LEVEL-DETAIL Numeric 15 Occurs 5 Times AC10.1 AC110
Level Detail Each occurrence of this field describes AC120 AC500
detail for one of the Activity
Management variable levels.
ACLEVEL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LVLSET1 ACTIVITY-GRP KeyChange AC01.1 AC10.1
VAR-LEVELS AC10.3 AC10.5
AC105 AC11.1
AC110 AC112
AC120 AC121
AC123 AC127
AC13.2 AC13.3
AC130 AC135
AC160 AC165
AC170 AC190
AC191 AC192
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
...
LVLSET2 ACTIVITY-GRP KeyChange BR00.1 BR00.2
VAR-LEVELS
LEVEL-DEPTH*
LVLSET3 ACTIVITY-GRP KeyChange AC01.1 AC10.5
LEVEL-DEPTH ACDL.1
VAR-LEVELS*
LVLSET4 POSTING-FLAG KeyChange AC190 AC191
ACTIVITY-GRP AC198 AC290
VAR-LEVELS AC471 AC490
AC550 AC58.1
BR120 BR121
BR130 BR131
BR165 BR420
BR450
ACLEVEL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
LVL-ACTIVITY-GRP -> ACV-ACTIVITY-GRP
LVL-VAR-LEVELS -> ACV-VAR-LEVELS
ACLEVEL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
LVL-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
LVL-VAR-LEVELS -> ATN-VAR-LEVELS
ATN-STATUS
ATN-ACCT-CATEGORY
ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
|
