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 AC160 AC165
AC170 AC190 AC191 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 AC720 AC741 AC750
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 GR741 SE90.1 AR250 AR251 AR30.1
AR30.2 AR30.3 AR30.5 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 BR142 BR200 BR202
BR204 BR205 BR210 BR220 BR265 BR40.3
BR400 BR405 BR41.1 BR420 BR430 BR450
BR65.1 BR65.2 BRCC.1 MX123 MX223 MX500
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 AC160
AC165 AC170
AC190 AC191
AC196 AC198
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.7
AC203 AC206
...
LVLSET2 ACTIVITY-GRP KeyChange BR00.1 BR00.2
VAR-LEVELS
LEVEL-DEPTH*
LVLSET3 ACTIVITY-GRP KeyChange AC01.1 AC10.5
LEVEL-DEPTH AC550 AC750
VAR-LEVELS* ACDL.1
LVLSET4 POSTING-FLAG KeyChange AC750
ACTIVITY-GRP
VAR-LEVELS
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
|