GMAUDIT – The GM audit file tracks when labor distribution record status changes occur and when labor distribution records are…

System
GM (GM)
Prefix
GIT
Primary key
HR-COMPANY, EMPLOYEE, DATE-STAMP, TIME-STAMP
Fields
5
Updated by
0 programs
Referenced by
0 programs

GMAUDIT is the The GM audit file tracks when labor distribution record status changes occur and when labor distribution records are… table in Lawson GM (prefix GIT). It is indexed by HR-COMPANY, EMPLOYEE, DATE-STAMP, TIME-STAMP (GITSET1). It is related 1:1 to EMPLOYEE and PRSYSTEM. The table has 5 fields, 1 index and 2 documented relations.

About GMAUDIT

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.

Fields (5)

Column = COBOL field name without the GIT- 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
#GIT-HR-COMPANY PK
HR_COMPANY		Numeric 4——
#GIT-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
DATE_STAMP		Numeric 8 (yyyymmdd)This field displays the system date when this was created.—
#GIT-TIME-STAMP PK
TIME_STAMP		Numeric 6 (hhmmss)——
#GIT-USER-ID
USER_ID		Alpha 10 (Lower Case)——

Indexes (1)

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
GITSET1
  1. HR-COMPANY
  2. EMPLOYEE
  3. DATE-STAMP
  4. TIME-STAMP
PrimaryBN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
EMPLOYEEPRSYSTEMGMAUDIT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
GIT-HR-COMPANY→EMP-COMPANY
GIT-EMPLOYEE→EMP-EMPLOYEE
Prsystem CompPRSYSTEMRequired
GIT-HR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

Programs

No Lawson programs are documented as updating or referencing this table.