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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GMI-OBJ-ID PK
OBJ_ID		Numeric 12This is the object identifier. Parent object identifier for GMRETDISTX file.—
#GMI-HR-COMPANY SET3 SET4
HR_COMPANY		Numeric 4Human Resources company number.—
#GMI-EMPLOYEE SET3 SET4
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.—
#GMI-JOB-CODE SET3 SET4
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.—
#GMI-PAY-CODE SET3 SET4
PAY_CODE		Alpha 4Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.—
#GMI-POSITION SET3 SET4
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.—
#GMI-START-DATE SET3 SET4
START_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-DATE SET3 SET4
END_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-TOT
SALARY_PCT_TOT		Signed 13.6Total salary percentage. Must equal 100% for record to be eligible for processing.—
#GMI-EFFORT-PCT-TOT
EFFORT_PCT_TOT		Signed 13.6Total planned effort percentage. Must be equal to 100% to be eligible for processing.—
#GMI-LAST-SEQ-NBR
LAST_SEQ_NBR		Numeric 6Identifies the last sequence number used. Ensures the record is unique.—
#GMI-STATUS
STATUS		Numeric 1Identifies 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.
  • 1 Not Updated
  • 2 Updated
—
#GMI-MAINT-TIME
MAINT_TIME		Numeric 6 (hhmmss)The time last changed.—
#GMI-MAINT-DATE
MAINT_DATE		Numeric 8 (yyyymmdd)The date last changed.—
#GMI-SEQUENCE-NBR SET3 SET4
SEQUENCE_NBR		Numeric 4The user-assigned sequence number to keep the records unique and to determine order.—
#GMI-REASON-CODE
REASON_CODE		Alpha 15This field contains the reason code, which indicates the cause for a labor cost transfer.—

Indexes (3)

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
GMISET1
  1. OBJ-ID
Primary—
GMISET3
  1. HR-COMPANY
  2. EMPLOYEE
  3. START-DATE ↓
  4. END-DATE ↓
  5. JOB-CODE
  6. POSITION
  7. PAY-CODE
  8. SEQUENCE-NBR
BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +22 more (list truncated in source)
GMISET4
  1. HR-COMPANY
  2. EMPLOYEE
  3. JOB-CODE
  4. POSITION
  5. PAY-CODE
  6. START-DATE
  7. END-DATE
  8. SEQUENCE-NBR ↓
—

Relations

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

One to one (2) — lookups and parents

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

One to many (1) — child tables

RelationTableRulesConditionField map
GmretdistxGMRETDISTX
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.