Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMAUDIT


                              GMAUDIT FILE

The GM audit file tracks when labor distribution record status changes occur
and when labor distribution records are deleted.  During Salary Encumbrance
Processing (GM110), users can opt to process encumbrances only for those
employees for whom labor distribution records were changed or deleted during a
specified date range.

REFERENCED BY

BN305     HR11.1    HR11.2    HR511     PA02.1    PA100
PA102     PA115     PA13.1    PA13.2    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GIT-HR-COMPANY         Numeric 4
Element: Company Hr

GIT-EMPLOYEE           Numeric 9
Element: Employee      Contains the employee number. Each
                       person employed by the company is
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

GIT-DATE-STAMP         Numeric 8  (yyyymmdd)
Element: Date          This field displays the system date
                       when this was created.

GIT-TIME-STAMP         Numeric 6  (hhmmss)
Element: Sys Time

GIT-USER-ID            Alpha 10  (Lower Case)
Element: User

                         GMAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GITSET1   HR-COMPANY                                             BN305   HR11.1
          EMPLOYEE                                               HR11.2  HR511
          DATE-STAMP                                             PA02.1  PA100
          TIME-STAMP                                             PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         GMAUDIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            GIT-HR-COMPANY    -> EMP-COMPANY
                            GIT-EMPLOYEE      -> EMP-EMPLOYEE

Prsystem Comp  PRSYSTEM     Required

                            GIT-HR-COMPANY    -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL