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

HR11.1    HR11.2    HR511     PA02.1    PA100     PA102
PA115     PA502     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 contains the server date
                       (month, date, and year) of the last
                       change to this record.

GIT-TIME-STAMP         Numeric 6  (hhmmss)
Element: Sys Time      Contains the server time (hour, minute,
                       and second) when the record was last
                       changed.

GIT-USER-ID            Alpha 10  (Lower Case)
Element: User          Contains the user ID of the person who
                       last changed this record.

                         GMAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GITSET1   HR-COMPANY                                             HR11.1  HR11.2
          EMPLOYEE                                               HR511   PA02.1
          DATE-STAMP                                             PA100   PA102
          TIME-STAMP                                             PA115   PA502
                                                                 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