ACMILESTN FILE

                          Activity Milestones

This file contains milestone information from the AC16 (Milestone) forms. It
includes activity, account category, milestone type, and the current balance
for the activity.

REFERENCED BY

AC115     AC216     AC416

UPDATED BY

AC10.1    AC16.2    AC16.3    AC16.4    AC16.5    AC300
AC310

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MLS-ACTIVITY         Alpha 15                                    AC16.2  AC16.3
Activity             Required key. This is the activity for      AC16.4  AC16.5
                     the milestone information.

MLS-ACCT-CATEGORY    Alpha 5                                     AC16.2  AC16.3
Account Category     This is the account category for the        AC16.4  AC16.5
                     milestone information.

MLS-MILESTN-TYPE     Numeric 1                                   AC16.2  AC16.3
Milestone Type       Required. This field indicates the type     AC16.4  AC16.5
                     of milestone this is: days, date,
                     percent complete, or manual. Manual
                     milestones are tracked by the manager.
                     1 = Days
                     2 = Date
                     3 = % Complete
                     4 = Manual

MLS-BALANCE          Signed 17.2                                 AC16.2  AC16.3
Balance              This is the current balance for the         AC16.4  AC16.5
                     activity.

                         ACMILESTN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLSSET1   ACTIVITY                                               AC10.1  AC115
          ACCT-CATEGORY                                          AC16.1  AC16.2
                                                                 AC16.3  AC16.4
                                                                 AC16.5  AC216
                                                                 AC300   AC310
                                                                 AC416

MLSSET2   MILESTN-TYPE                                           AC16.2  AC16.3
          ACTIVITY                                               AC16.4  AC16.5
          ACCT-CATEGORY

                         ACMILESTN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Required

                            MLS-ACTIVITY    -> ACV-ACTIVITY