ACCOMMENTS FILE

                           Activity Comments

This file contains comments from AC01.1 (Comments). It includes the following
kinds of comments: activity group, activity, change order, budget, invoice,
and all (general). It also contains comment type, comment narrative,
expiration date, and comment date.

REFERENCED BY

AC115     AC20.1    AC20.2    AC20.3    AC20.4    AC200
AC21.1    AC21.2    AC21.3    AC210     AC220     AC421

UPDATED BY

AC00.1    AC01.1    AC10.1    AC120     AC300     AC310
AC580     AC952     AC980

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CMN-ACTIVITY-GRP     Alpha 15                                    AC01.1  AC120
Activity Group       Required key. This is the activity          AC952
                     group for the comment.

CMN-ACTIVITY         Alpha 15                                    AC01.1  AC952
Activity             Required key. This is the activity for
                     the comment.

CMN-COMMENT-TYP      Alpha 1                                     AC01.1  AC952
Comment Type         Required key. This field tells the type
                     of comment this is.

                     Valid values are

                     G = Activity Group Comment
                     V = Activity Comment
                     B = Budget Comment
                     C = Change Order Comment
                     I  = Invoice
                     A = Applies to All

CMN-SEQ-NBR          Numeric 4                                   AC01.1  AC952
Sequence Number      Required key. This is the sequence
                     number used to order comments.

CMN-COMMENT          Alpha 40  (Lower Case)                      AC01.1  AC952
Comment              This field contains the comment
                     narrative.

CMN-EXPIRE-DATE      Numeric 8  (yyyymmdd)                       AC01.1  AC952
Expiration Date      This is the date that this comment no
                     longer applies.

CMN-COMMENT-DATE     Numeric 8  (yyyymmdd)                       AC01.1  AC952
Comment Date         This is the date this comment was
                     created.

                         ACCOMMENTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMNSET1   ACTIVITY-GRP                                           AC01.1  AC10.1
          ACTIVITY                                               AC115   AC120
          COMMENT-TYP                                            AC20.1  AC20.2
          SEQ-NBR                                                AC20.3  AC20.4
                                                                 AC200   AC21.1
                                                                 AC21.2  AC21.3
                                                                 AC210   AC220
                                                                 AC300   AC310
                                                                 AC421   AC580
                                                                 AC980

CMNSET3   ACTIVITY-GRP  KeyChange
          EXPIRE-DATE
          ACTIVITY
          COMMENT-TYP
          SEQ-NBR

CMNSET4   ACTIVITY-GRP  KeyChange
          ACTIVITY
          EXPIRE-DATE
          COMMENT-TYP
          SEQ-NBR

CMNSET5   ACTIVITY-GRP                                           AC00.1  AC421
          COMMENT-TYP
          ACTIVITY
          SEQ-NBR

                         ACCOMMENTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            CMN-ACTIVITY-GRP    -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            CMN-ACTIVITY        -> ACV-ACTIVITY