Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              ACAUDIT FILE

                             Activity Audit

This file contains activity change information from AC10.3 (Activity Levels).
It includes changes in the activity level structure definition, a change
description, process time and date, and last-changed date.

REFERENCED BY

AC50.1    AC500     AC79.1

UPDATED BY

AC10.1    AC10.5    AC11.1    AC110     AC120     AC300
AC310

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AUD-ACTIVITY         Alpha 15                                    AC10.1  AC10.5
Activity             Required key. This is the new or            AC11.1  AC110
                     changed activity.

AUD-PROCESS-DATE     Numeric 8  (yyyymmdd)                       AC10.1  AC10.5
Process Date         This is the date the activity record        AC11.1  AC110
                     was processed.                              AC120

AUD-PROCESS-TIME     Numeric 6  (hhmmss)                         AC10.1  AC10.5
Process Time         This is the time the activity record        AC11.1  AC110
                     was processed.                              AC120

AUD-DATE-CHANGED     Numeric 8  (yyyymmdd)                       AC10.1  AC10.5
Date Changed         This is the date the activity record        AC11.1  AC110
                     was changed.

AUD-OLD-LEVELS       Alpha 30                                    AC10.1  AC10.5
Old Levels           This is the old variable level              AC11.1  AC110
                     definition for the activity.

AUD-NEW-LEVELS       Alpha 30                                    AC10.1  AC10.5
New Levels           This is the new variable level              AC11.1  AC110
                     definition for the activity.

AUD-DESCRIPTION      Alpha 30  (Lower Case)                      AC10.5  AC11.1
Change Description   This is a description of the change to      AC110
                     the activity level structure (work
                     breakdown structure).

AUD-LONG-DESC        Alpha 60 Occurs 4 Times                     AC10.5  AC11.1
Long Description     This is a long description of the           AC110
                     change to the activity level structure
                     (work breakdown structure).

AUD-REORG-OR-COPY    Alpha 1                                     AC10.5  AC11.1
Reorg Or Copy        This field indicates whether the new        AC110
                     activity level structure definition is a
                     copy or a reorganization. Use C for
                     copy, and R for reorganization.
                     R = Reorg
                     C = Copy

AUD-COPY-FR-ACTV     Alpha 15                                    AC10.5  AC11.1
Copy Fr Actv         This is the original activity.              AC110

AUD-POSTING-FLAG     Alpha 1                                     AC10.5  AC11.1
Posting Flag         This field indicates whether the new        AC110
                     activity is posting-level or
                     summary-level. Use P for posting and S
                     for summary.
                     P = Posting
                     S = Summary

AUD-COPY-FR-DEPTH    Numeric 1                                   AC10.5  AC11.1
Copy Fr Depth        This field indicates the number of          AC110
                     levels in the original level structure.

AUD-COPY-TO-DEPTH    Numeric 1                                   AC10.5  AC11.1
Copy To Depth        This field indicates the number of          AC110
                     levels in the new level structure.

AUD-COPY-FR-AG       Alpha 15                                    AC10.1  AC10.5
Copy Fr Ag           Key field. This is the original             AC11.1  AC110
                     activity group.

AUD-COPY-TO-AG       Alpha 15                                    AC10.1  AC10.5
Copy To Ag           Key field. This is the new or changed       AC11.1  AC110
                     activity group.

AUD-COPY-TO-AG-DES   Alpha 30                                    AC10.5  AC11.1
Copy To Ag Des       This is the new activity group              AC110
                     description.

AUD-RUN-GROUP        Alpha 12                                    AC10.5  AC11.1
Run Group            This is the run group for the level         AC110
                     changes.

AUD-MOVE-FR-ACTV     Alpha 15                                    AC10.5
Move Fr Actv

AUD-MOVE-TO-AG       Alpha 15                                    AC10.5
Move To Ag

AUD-MOVE-TO-ACTV     Alpha 15                                    AC10.5
Move To Actv

AUD-MOVE-TOP-LVL     Alpha 1                                     AC10.5  AC120
Move Top Lvl

                         ACAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AUDSET1   ACTIVITY                                               AC10.1  AC10.5
          PROCESS-DATE                                           AC11.1  AC110
          PROCESS-TIME                                           AC120   AC300
          COPY-FR-AG                                             AC310   AC50.1
          COPY-TO-AG                                             AC500   AC79.1

AUDSET2   RUN-GROUP     KeyChange, Duplicates, Subset            AC11.1  AC110
          COPY-TO-AG    Where (REORG-OR-COPY = "C" )             AC79.1
          ACTIVITY

AUDSET3   NEW-LEVELS    KeyChange, Duplicates                    AC10.1  AC10.5
          ACTIVITY                                               AC110   AC120
          PROCESS-DATE                                           AC50.1  AC500
          PROCESS-TIME
          COPY-FR-AG
          COPY-TO-AG

AUDSET4   RUN-GROUP     KeyChange, Duplicates                    AC10.5  AC11.1
          REORG-OR-COPY                                          AC110   AC120
          NEW-LEVELS
          ACTIVITY
          COPY-TO-AG
          COPY-FR-AG

AUDSET5   MOVE-FR-ACTV  KeyChange, Subset
          MOVE-TO-AG    Where MOVE-FR-ACTV != Spaces
          MOVE-TO-ACTV

AUDSET6   MOVE-TOP-LVL  KeyChange, Subset                        AC10.5
          MOVE-FR-ACTV  Where MOVE-TOP-LVL = "Y"
          MOVE-TO-AG
          MOVE-TO-ACTV