GMLABDIST – Grant Labor Distribution

System
GM (GM)
Prefix
GML
Primary key
OBJ-ID
Fields
12
Updated by
0 programs
Referenced by
0 programs

GMLABDIST is the Grant Labor Distribution table in Lawson GM (prefix GML). It is indexed by OBJ-ID (GMLSET1); alternate indexes: GMLSET3, GMLSET4 and GMLSET5. It is related 1:1 to EMPLOYEE and PRSYSTEM and 1:M to GMLABDISTX. The table has 12 fields, 4 indexes and 3 documented relations.

About GMLABDIST

The Labor Distribution files (GMLABDIST and GMLABDISTX) store distribution splits for employee salaries and planned effort. Labor distributions are used in the following business processes: GM110 - Processing salary encumbrances for activities. PR197 - Applying AC/GL distributions during payroll processing. GM165 - Tracking planned effort for effort reporting.

Fields (12)

Column = COBOL field name without the GML- 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
#GML-OBJ-ID PK
OBJ_ID		Numeric 12Parent object ID for GMLABDISTX file.—
#GML-HR-COMPANY SET3 SET4 SET5
HR_COMPANY		Numeric 4——
#GML-EMPLOYEE SET3 SET4 SET5
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.—
#GML-JOB-CODE SET3 SET4 SET5
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job. Optional, not permitted if position rules are in effect.—
#GML-PAY-CODE SET3 SET4 SET5
PAY_CODE		Alpha 4Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.—
#GML-POSITION SET3 SET4 SET5
POSITION		Alpha 12Contains the user-defined code that represents a position in the company. Optional, not permitted if job code is used.—
#GML-EFFECT-DATE SET3 SET4 SET5
EFFECT_DATE		Numeric 8 (yyyymmdd)Effective date for the labor distribution record.—
#GML-DFLT-ENCUM-FL
DFLT_ENCUM_FL		Alpha 1Determines which distribution to use for salary encumbrance processing when mulitiple distributions exist for the same employee and effective date.
  • Y Yes
  • N No
—
#GML-SALARY-PCT-TOT
SALARY_PCT_TOT		Signed 13.6Total salary distributions from GMLABDISTX, can be less than or equal to 100%.—
#GML-EFFORT-PCT-TOT
EFFORT_PCT_TOT		Signed 13.6Total planned effort distributions from GMLABDISTX, must equal 100% to be eligible for processing.—
#GML-LAST-SEQ-NBR
LAST_SEQ_NBR		Numeric 6Identifies the last sequence number used. Ensures the record is unique.—
#GML-ENCUM-STATUS
ENCUM_STATUS		Alpha 1" " = Not Approved
  • 1 Auto Approved
  • 2 User Approved
—

Indexes (4)

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
GMLSET1
  1. OBJ-ID
Primary—
GMLSET3
  1. HR-COMPANY
  2. EMPLOYEE
  3. EFFECT-DATE ↓
  4. JOB-CODE
  5. POSITION
  6. PAY-CODE
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
GMLSET4
  1. HR-COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. POSITION
  5. PAY-CODE
  6. EFFECT-DATE
—
GMLSET5
  1. HR-COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. POSITION
  5. PAY-CODE
  6. EFFECT-DATE ↓
—

Relations

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

One to one (2) — lookups and parents

RelationTableRulesConditionField map
EmployeeEMPLOYEERequired
GML-HR-COMPANY→EMP-COMPANY (EMPSET1)
GML-EMPLOYEE→EMP-EMPLOYEE
Prsystem CompPRSYSTEMRequired
GML-HR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL

One to many (1) — child tables

RelationTableRulesConditionField map
GmlabdistxGMLABDISTX
GML-OBJ-ID→GMA-GML-OBJ-ID
—→GMA-SEQUENCE-NBR
—→GMA-OBJ-ID

Programs

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