ACPERCMPLX FILE

                       AC Percent Complete Detail

This file contains activity and account category percent complete information
from AC65.1 (Activity Percentage of Completion) and AC65.2 (Percent Complete
by Account Category). It includes activity, account category, amount type,
percent complete, total budget, date, cost-to-date, and
cost-to-complete.

REFERENCED BY

AC265

UPDATED BY

AC10.1    AC165     AC300     AC310     AC65.2    AC701

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PEX-ACTIVITY         Alpha 15                                    AC165   AC65.2
Activity             Required key. This is the activity for
                     the percent complete information.

PEX-DATE             Numeric 8  (yyyymmdd)                       AC165   AC65.2
Date                 Required key. This is the date as of
                     which the percentage complete was
                     calculated.

PEX-ACCT-CATEGORY    Alpha 5                                     AC165   AC65.2
Account Category     Required key. This is the account
                     category for the percent complete
                     information.

PEX-AMOUNT-TYPE      Alpha 1                                     AC165   AC65.2
Amount Type          This field indicates the type for the
                     budget: Amount or Units.
                     A = Amount
                     U = Unit

PEX-PERC-COMPLETE    Signed 7.3                                  AC165   AC65.2
Percent Complete     This is the percentage complete for the
                     account category.

PEX-TOTAL-BUDGET     Signed 15.2                                 AC165   AC65.2
Total Budget         This is the total budget for the
                     account category.

PEX-COST-TO-DATE     Signed 15.2                                 AC165   AC65.2
Cost-to-Date         This is the cost-to-date amount for the
                     account category.

PEX-COST-TO-CMPLT    Signed 15.2                                 AC165   AC65.2
Cost-to-Complete     This is the cost to complete, or the
                     amount remaining to be expended, for the
                     account category.

PEX-BUDGET-TYPE      Alpha 1                                     AC165   AC65.2
Budget Type          This field indicates the budget type:       AC701
                     Amount or Units.

                         ACPERCMPLX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PEXSET1   ACTIVITY                                               AC10.1  AC165
          BUDGET-TYPE                                            AC265   AC300
          DATE*                                                  AC310   AC65.2
          ACCT-CATEGORY                                          AC701

                         ACPERCMPLX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            PEX-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Required

                            PEX-ACTIVITY         -> ACV-ACTIVITY