Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACAUDIT


                              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
Element: Activity      Required key. This is the new or          AC11.1  AC110
                       changed activity.

AUD-PROCESS-DATE       Numeric 8  (yyyymmdd)                     AC10.1  AC10.5
Element: 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
Element: 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
Element: Date Changed  This is the date the activity record      AC11.1  AC110
                       was changed.

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

AUD-NEW-LEVELS         Alpha 30                                  AC10.1  AC10.5
Element: 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
Element: Change DescripThis 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
Element: Long DescriptiOccurs 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
Element: 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
Element: Activity      This is the original activity.            AC110

AUD-POSTING-FLAG       Alpha 1                                   AC10.5  AC11.1
Element: 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
Element: 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
Element: Au Flag       This field indicates the number of        AC110
                       levels in the new level structure.

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

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

AUD-COPY-TO-AG-DES     Alpha 30                                  AC10.5  AC11.1
Element: Item DescriptiThis is the new activity group            AC110
                       description.

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

AUD-MOVE-FR-ACTV       Alpha 15                                  AC10.5
Element: Activity

AUD-MOVE-TO-AG         Alpha 15                                  AC10.5
Element: Activity Group

AUD-MOVE-TO-ACTV       Alpha 15                                  AC10.5
Element: Activity

AUD-MOVE-TOP-LVL       Alpha 1                                   AC10.5  AC120
Element: All Flag      Y = Yes
                       N = No

AUD-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC11.1  AC110
Element: Begin Date    The begin date for the new activity
                       being created.

AUD-END-DATE           Numeric 8  (yyyymmdd)                     AC11.1  AC110
Element: Ending Date   The end date for the new activity being
                       created.

AUD-FROM-CONTRACT      Alpha 10                                  AC10.1  AC10.5
Element: From Contract

AUD-TO-CONTRACT        Alpha 10                                  AC10.1  AC10.5
Element: To Contract

AUD-PARENT-ACTV        Alpha 15
Element: Parent Actv   The parent activity field contains the
                       activity name of the member parent.

                         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

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