GMRETDIST – Grant Retro Labor Distribution
- System
- GM (GM)
- Prefix
GMI- Primary key
OBJ-ID- Fields
- 16
- Updated by
- 0 programs
- Referenced by
- 0 programs
GMRETDIST is the Grant Retro Labor Distribution table in Lawson GM (prefix GMI). It is indexed by OBJ-ID (GMISET1); alternate indexes: GMISET3 and GMISET4. It is related 1:1 to EMPLOYEE and PRSYSTEM and 1:M to GMRETDISTX. The table has 16 fields, 3 indexes and 3 documented relations.
About GMRETDIST
The Retro Labor Distribution files (GMRETDIST and GMRETDISTX) are templates that store distribution splits used for after-the-fact labor cost transfers. These templates drive changes to labor cost distributions during Labor Cost Transfer Processing (GM170). This allows users to reverse distributions that were in effect at the time payroll was processed and reapply new distributions based on after-the-fact time studies, effort certification, funding changes and so on.
Fields (16)
Column = COBOL field name without the GMI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMI-OBJ-ID PKOBJ_ID | Numeric 12 | This is the object identifier. Parent object identifier for GMRETDISTX file. | — |
GMI-HR-COMPANYHR_COMPANY | Numeric 4 | Human Resources company number. | — |
GMI-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. | — |
GMI-JOB-CODEJOB_CODE | Alpha 9 | Contains a user-defined code that represents a type of job. | — |
GMI-PAY-CODEPAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
GMI-POSITIONPOSITION | Alpha 12 | Contains the user-defined code that represents a position in the company. | — |
GMI-START-DATESTART_DATE | Numeric 8 (yyyymmdd) | Effective (start) date for the template; payroll distributions dated on or after the START-DATE and on or before the END-DATE are eligible for cost transfer during GM170. | — |
GMI-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | End date for the template; payroll distributions dated on or after the START-DATE and or before the END-DATE are eligible for cost transfer during GM170. | — |
GMI-SALARY-PCT-TOTSALARY_PCT_TOT | Signed 13.6 | Total salary percentage. Must equal 100% for record to be eligible for processing. | — |
GMI-EFFORT-PCT-TOTEFFORT_PCT_TOT | Signed 13.6 | Total planned effort percentage. Must be equal to 100% to be eligible for processing. | — |
GMI-LAST-SEQ-NBRLAST_SEQ_NBR | Numeric 6 | Identifies the last sequence number used. Ensures the record is unique. | — |
GMI-STATUSSTATUS | Numeric 1 | Identifies posting status for template. Status is 0 if template has not been processed through GM170 in update mode. Status is 1 when template has been selected and processed through GM170 in update mode.
| — |
GMI-MAINT-TIMEMAINT_TIME | Numeric 6 (hhmmss) | The time last changed. | — |
GMI-MAINT-DATEMAINT_DATE | Numeric 8 (yyyymmdd) | The date last changed. | — |
GMI-SEQUENCE-NBRSEQUENCE_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
GMI-REASON-CODEREASON_CODE | Alpha 15 | This field contains the reason code, which indicates the cause for a labor cost transfer. | — |
Indexes (3)
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 |
|---|---|---|---|---|
GMISET1 | OBJ-ID | Primary | — | |
GMISET3 | HR-COMPANY, EMPLOYEE, START-DATE*, END-DATE*, JOB-CODE, POSITION, PAY-CODE, SEQUENCE-NBR | BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source) | ||
GMISET4 | HR-COMPANY, EMPLOYEE, JOB-CODE, POSITION, PAY-CODE, START-DATE, END-DATE, SEQUENCE-NBR* | — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Employee | EMPLOYEE | Required | GMI-HR-COMPANY → EMP-COMPANY (EMPSET1), GMI-EMPLOYEE → EMP-EMPLOYEE | |
| Prsystem Comp | PRSYSTEM | Required | GMI-HR-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Gmretdistx | GMRETDISTX | GMI-OBJ-ID → GMH-GMI-OBJ-ID, GMH-SEQUENCE-NBR, GMH-OBJ-ID |
Programs
No Lawson programs are documented as updating or referencing this table.