Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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     AC01.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  (Lower Case)                      AC10.5  AC11.1
Long Description     Occurs 4 Times                              AC110
                     This is a long description of the
                     change to the activity level structure
                     (work breakdown structure).

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

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 15                                    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         Y = Yes
                     N = No

                         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
          REORG-OR-COPY

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

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

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

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