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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GML-OBJ-ID PKOBJ_ID | Numeric 12 | Parent object ID for GMLABDISTX file. | — |
GML-HR-COMPANYHR_COMPANY | Numeric 4 | — | — |
GML-EMPLOYEEEMPLOYEE | Numeric 9 | 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. | — |
GML-JOB-CODEJOB_CODE | Alpha 9 | Contains a user-defined code that represents a type of job. Optional, not permitted if position rules are in effect. | — |
GML-PAY-CODEPAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
GML-POSITIONPOSITION | Alpha 12 | Contains the user-defined code that represents a position in the company. Optional, not permitted if job code is used. | — |
GML-EFFECT-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | Effective date for the labor distribution record. | — |
GML-DFLT-ENCUM-FLDFLT_ENCUM_FL | Alpha 1 | Determines which distribution to use for salary encumbrance processing when mulitiple distributions exist for the same employee and effective date.
| — |
GML-SALARY-PCT-TOTSALARY_PCT_TOT | Signed 13.6 | Total salary distributions from GMLABDISTX, can be less than or equal to 100%. | — |
GML-EFFORT-PCT-TOTEFFORT_PCT_TOT | Signed 13.6 | Total planned effort distributions from GMLABDISTX, must equal 100% to be eligible for processing. | — |
GML-LAST-SEQ-NBRLAST_SEQ_NBR | Numeric 6 | Identifies the last sequence number used. Ensures the record is unique. | — |
GML-ENCUM-STATUSENCUM_STATUS | Alpha 1 | " " = Not Approved
| — |
Indexes (4)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMLSET1 | OBJ-ID | Primary | — | |
GMLSET3 | HR-COMPANY, EMPLOYEE, EFFECT-DATE*, JOB-CODE, POSITION, PAY-CODE | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source) | ||
GMLSET4 | HR-COMPANY, EMPLOYEE, JOB-CODE, POSITION, PAY-CODE, EFFECT-DATE | — | ||
GMLSET5 | HR-COMPANY, EMPLOYEE, JOB-CODE, POSITION, PAY-CODE, EFFECT-DATE* | — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Employee | EMPLOYEE | Required | GML-HR-COMPANY → EMP-COMPANY (EMPSET1), GML-EMPLOYEE → EMP-EMPLOYEE | |
| Prsystem Comp | PRSYSTEM | Required | GML-HR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Gmlabdistx | GMLABDISTX | 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.