Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMLABDIST


                             GMLABDIST FILE

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.

REFERENCED BY

HR11.1    HR11.2    HR511     PA02.1    PA100     PA102
PA115     PA502     PA52.1    PA52.3    PA52.4    PA52.5
PR110     PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    PR197     PR82.1    PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GML-OBJ-ID             Numeric 12
Object                 Parent object ID for GMLABDISTX file.
Identification

GML-HR-COMPANY         Numeric 4
Element: Company Hr

GML-EMPLOYEE           Numeric 9
Element: Employee      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-CODE           Alpha 9
Element: Job Code      Contains a user-defined code that
                       represents a type of job.  Optional, not
                       permitted if position rules are in
                       effect.

GML-PAY-CODE           Alpha 4
Element: Payment Code  Contains the pay code. A pay code is a
                       user-defined code that identifies a kind
                       of pay.

GML-POSITION           Alpha 12
Element: Position      Contains the user-defined code that
                       represents a position in the company.
                       Optional, not permitted if job code is
                       used.

GML-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Effective DateEffective date for the labor
                       distribution record.

GML-DFLT-ENCUM-FL      Alpha 1
Element: Dflt Encum Fl Determines 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     Signed 13.6
Element: Salary Pct TotTotal salary distributions from
                       GMLABDISTX, can be less than or equal to
                       100%.

GML-EFFORT-PCT-TOT     Signed 13.6
Element: Effort Pct TotTotal planned effort distributions from
                       GMLABDISTX, must equal 100% to be
                       eligible for processing.

GML-LAST-SEQ-NBR       Numeric 6
Element: Last Seq Nbr  Identifies the last sequence number
                       used.  Ensures the record is unique.

GML-ENCUM-STATUS       Alpha 1
Element: Encum Status  " " = Not Approved
                       1 = Auto Approved
                       2 = User Approved

                         GMLABDIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMLSET1   OBJ-ID

GMLSET2   HR-COMPANY
          EFFECT-DATE*
          EMPLOYEE
          JOB-CODE
          POSITION
          PAY-CODE

GMLSET3   HR-COMPANY                                             HR11.1  HR11.2
          EMPLOYEE                                               HR511   PA02.1
          EFFECT-DATE*                                           PA100   PA102
          JOB-CODE                                               PA115   PA502
          POSITION                                               PA52.1  PA52.3
          PAY-CODE                                               PA52.4  PA52.5
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

GMLSET4   HR-COMPANY
          EMPLOYEE
          JOB-CODE
          POSITION
          PAY-CODE
          EFFECT-DATE

GMLSET5   HR-COMPANY                                             PR197   PR82.1
          EMPLOYEE                                               PR85.1
          JOB-CODE
          POSITION
          PAY-CODE
          EFFECT-DATE*

                         GMLABDIST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee       EMPLOYEE     Required

                            GML-HR-COMPANY    -> EMP-COMPANY
                            GML-EMPLOYEE      -> EMP-EMPLOYEE

Prsystem Comp  PRSYSTEM     Required

                            GML-HR-COMPANY    -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

                         GMLABDIST FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Gmlabdistx     GMLABDISTX

                            GML-OBJ-ID        -> GMA-GML-OBJ-ID
                                                 GMA-SEQUENCE-NBR
                                                 GMA-OBJ-ID