ACAUDIT – Activity Audit

System
Activity Management (AC)
Prefix
AUD
Primary key
ACTIVITY, PROCESS-DATE, PROCESS-TIME, COPY-FR-AG, COPY-TO-AG, REORG-OR-COPY
Fields
26
Updated by
11 programs
Referenced by
3 programs

ACAUDIT is the Activity Audit table in Lawson Activity Management (prefix AUD). It is indexed by ACTIVITY, PROCESS-DATE, PROCESS-TIME, COPY-FR-AG, COPY-TO-AG, REORG-OR-COPY (AUDSET1); alternate indexes: AUDSET2, AUDSET3, AUDSET4 and AUDSET6. It is updated by AC00.1, AC00.3, AC01.1, AC10.1, AC10.5, AC11.1, AC110, AC120 and 3 more and referenced by AC19.1, AC56.1 and AC560. The table has 26 fields, 5 indexes and 0 documented relations.

About ACAUDIT

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.

Fields (26)

Column = COBOL field name without the AUD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#AUD-ACTIVITY PK
ACTIVITY		Alpha 15Required key. This is the new or changed activity.AC10.1, AC10.5, AC11.1, AC110
#AUD-PROCESS-DATE PK
PROCESS_DATE		Numeric 8 (yyyymmdd)This is the date the activity record was processed.AC10.1, AC10.5, AC11.1, AC110, AC120
#AUD-PROCESS-TIME PK
PROCESS_TIME		Numeric 6 (hhmmss)This is the time the activity record was processed.AC10.1, AC10.5, AC11.1, AC110, AC120
#AUD-DATE-CHANGED
DATE_CHANGED		Numeric 8 (yyyymmdd)This is the date the activity record was changed.AC10.1, AC10.5, AC11.1, AC110
#AUD-OLD-LEVELS
OLD_LEVELS		Alpha 30This is the old variable level definition for the activity.AC10.1, AC10.5, AC11.1, AC110
#AUD-NEW-LEVELS SET3 SET4
NEW_LEVELS		Alpha 30This is the new variable level definition for the activity.AC10.1, AC10.5, AC11.1, AC110
#AUD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is a description of the change to the activity level structure (work breakdown structure).AC10.5, AC11.1, AC110
#AUD-LONG-DESC
LONG_DESC		Alpha 60 (Lower Case)Occurs 4 Times This is a long description of the change to the activity level structure (work breakdown structure).AC10.5, AC11.1, AC110
#AUD-REORG-OR-COPY PK
REORG_OR_COPY		Alpha 1This field indicates whether the new activity level structure definition is a copy or a reorganization. Use C for copy, and R for reorganization.
  • R Reorg
  • C Copy
  • M Move
AC10.1, AC10.5, AC11.1, AC110
#AUD-COPY-FR-ACTV SET2
COPY_FR_ACTV		Alpha 15This is the original activity.AC10.5, AC11.1, AC110
#AUD-POSTING-FLAG
POSTING_FLAG		Alpha 1This field indicates whether the new activity is posting-level or summary-level. Use P for posting and S for summary.
  • P Posting
  • S Summary
AC10.5, AC11.1, AC110
#AUD-COPY-FR-DEPTH
COPY_FR_DEPTH		Numeric 1This field indicates the number of levels in the original level structure.AC10.5, AC11.1, AC110
#AUD-COPY-TO-DEPTH
COPY_TO_DEPTH		Numeric 1This field indicates the number of levels in the new level structure.AC10.5, AC11.1, AC110
#AUD-COPY-FR-AG PK
COPY_FR_AG		Alpha 15Key field. This is the original activity group.AC10.1, AC10.5, AC11.1, AC110
#AUD-COPY-TO-AG PK
COPY_TO_AG		Alpha 15Key field. This is the new or changed activity group.AC10.1, AC10.5, AC11.1, AC110
#AUD-COPY-TO-AG-DES
COPY_TO_AG_DES		Alpha 30This is the new activity group description.AC10.5, AC11.1, AC110
#AUD-RUN-GROUP SET2 SET4
RUN_GROUP		Alpha 15This is the run group for the level changes.AC10.5, AC11.1, AC110
#AUD-MOVE-FR-ACTV SET6
MOVE_FR_ACTV		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC10.5
#AUD-MOVE-TO-AG SET6
MOVE_TO_AG		Alpha 15The activity group is the overall project.AC10.5
#AUD-MOVE-TO-ACTV SET6
MOVE_TO_ACTV		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AC10.5
#AUD-MOVE-TOP-LVL SET6
MOVE_TOP_LVL		Alpha 1—
  • Y Yes
  • N No
AC10.5, AC120
#AUD-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)The begin date for the new activity being created.AC11.1, AC110
#AUD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The end date for the new activity being created.AC11.1, AC110
#AUD-FROM-CONTRACT
FROM_CONTRACT		Alpha 15Activity Management contract.AC10.1, AC10.5
#AUD-TO-CONTRACT
TO_CONTRACT		Alpha 15Activity Management contract.AC10.1, AC10.5
#AUD-PARENT-ACTV
PARENT_ACTV		Alpha 15The parent activity field contains the activity name of the member parent.AC10.1, AC10.5, AC120

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AUDSET1
  1. ACTIVITY
  2. PROCESS-DATE
  3. PROCESS-TIME
  4. COPY-FR-AG
  5. COPY-TO-AG
  6. REORG-OR-COPY
PrimaryAC10.1, AC10.5, AC11.1, AC110, AC120, AC19.1, AC300, AC50.1 +3 more
AUDSET2
  1. RUN-GROUP
  2. COPY-FR-AG
  3. COPY-TO-AG
  4. COPY-FR-ACTV
  5. ACTIVITY
KeyChange, SubsetWhere (REORG-OR-COPY = "C")AC01.1, AC11.1, AC110
AUDSET3
  1. NEW-LEVELS
  2. ACTIVITY
  3. PROCESS-DATE
  4. PROCESS-TIME
  5. COPY-FR-AG
  6. COPY-TO-AG
  7. REORG-OR-COPY
KeyChangeAC01.1, AC10.1, AC10.5, AC11.1, AC110, AC120, AC50.1, AC500
AUDSET4
  1. RUN-GROUP
  2. REORG-OR-COPY
  3. NEW-LEVELS
  4. ACTIVITY
  5. COPY-TO-AG
  6. COPY-FR-AG
  7. PROCESS-TIME
KeyChangeAC10.5, AC11.1, AC110, AC120
AUDSET6
  1. MOVE-TOP-LVL
  2. MOVE-FR-ACTV
  3. MOVE-TO-AG
  4. MOVE-TO-ACTV
KeyChange, SubsetWhere MOVE-TOP-LVL = "Y"AC00.1, AC00.3, AC10.1, AC10.5

Programs

Updated by (11)

Referenced by (3)