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 AC105 AC11.1 AC112 AC115 AC121 AC123 AC127 AC13.2 AC13.3 AC130 AC14.1 AC15.1 AC15.4 AC16.2 AC16.3 AC16.4 AC16.5 AC160 AC165 AC170 AC190 AC191 AC196 AC20.1 AC20.2 AC20.3 AC20.4 AC20.6 AC203 AC206 AC207 AC210 AC214 AC215 AC216 AC22.1 AC220 AC240 AC256 AC265 AC27.1 AC29.1 AC290 AC295 AC297 AC30.1 AC30.2 AC30.3 AC30.4 AC32.1 AC40.1 AC401 AC41.1 AC410 AC412 AC415 AC416 AC42.1 AC420 AC421 AC440 AC450 AC460 AC470 AC471 AC472 AC473 AC480 AC490 AC50.1 AC530 AC54.1 AC540 AC55.1 AC580 AC65.1 AC65.2 AC70.3 AC79.1 AC90.1 AC90.2 AC94.1 AC94.2 AC94.3 AC94.4 AC94.5 AC94.6 AC95.1 AC95.2 AC952 AC97.1 AC97.2 AC980 ACAC.1 ACBA.1 ACDL.1 MX123 UPDATED BY AC10.1 AC110 AC120 AC300 AC310 AC500 AC700 AC730 AC950 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. AC700 AC730 AC950 LVL-VAR-LEVELS Alpha 30 AC10.1 AC110 Variable Levels Required key. Levels define an AC120 AC500 addressing system that organizes AC730 AC950 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 AC730 AC950 LVL-POSTING-FLAG Alpha 1 AC10.1 AC110 Posting Flag This field indicates whether this level AC500 AC730 is the posting or the summary level. AC950 Posting should be done at the lowest level and summary at the higher levels. P = Posting S = Summary LVL-VAR-LEVEL-DISP Alpha 34 AC10.1 AC110 Variable Level The level structure for the activity AC120 AC500 Display displays. AC730 AC950 LVL-LEVEL-DEPTH Numeric 1 AC10.1 AC110 Level Depth This is the number of variable levels AC120 AC500 pertaining to this activity. AC730 AC79.1 AC950 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 AC730 AC950 Management variable levels. ACLEVEL FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN LVLSET1 ACTIVITY-GRP KeyChange AC10.1 AC10.3 VAR-LEVELS AC10.5 AC105 AC11.1 AC110 AC112 AC115 AC120 AC121 AC123 AC127 AC13.2 AC13.3 AC130 AC14.1 AC15.1 AC15.4 AC16.2 AC16.3 AC16.4 AC16.5 AC160 AC165 AC170 AC190 AC191 AC196 AC20.1 AC20.2 ... LVLSET2 ACTIVITY-GRP KeyChange AC50.1 AC500 VAR-LEVELS LEVEL-DEPTH* LVLSET3 ACTIVITY-GRP KeyChange AC10.5 AC79.1 LEVEL-DEPTH 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 Aclevel ACLEVEL LVL-ACTIVITY-GRP -> LVL-ACTIVITY-GRP LVL-VAR-LEVELS LVL-LEVEL-DEPTH Actrans ACTRANS LVL-ACTIVITY-GRP -> ATN-ACTIVITY-GRP LVL-VAR-LEVELS -> ATN-VAR-LEVELS ATN-ACCT-CATEGORY ATN-OBJ-ID |