Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMLABDISTX

                            GMLABDISTX 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

ET530     PR195     PR197     PR82.1    PR85.1

UPDATED BY

AC300     AC310     AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMA-HR-COMPANY         Numeric 4
Element: Company Hr

GMA-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.

GMA-JOB-CODE           Alpha 9
Element: Job Code      Contains a user-defined code that
                       represents a type of job. Optional,
                       permitted only if position rules are not
                       in effect.

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

GMA-POSITION           Alpha 12
Element: Position      Contains the user-defined code that
                       represents a position in the company.
                       Optional, permitted only if position
                       rules are in effect.

GMA-EFFECT-DATE        Numeric 8  (yyyymmdd)
Element: Effect Date   Effective date for labor distribution
                       record.

GMA-ACTIVITY           Alpha 15
Element: Activity      Posting level activity that identifies
                       the grant to which a percentage of the
                       salary should be encumbered and
                       distributed.


GMA-ACCT-CATEGORY      Alpha 5
Element: Acct Category Valid account category for posting
                       level activity.  Must be a detail level
                       account category.


GMA-COMPANY            Numeric 4
Element: Company       Required, GL company for commitment
                       transactions.

GMA-ACCT-UNIT          Alpha 15
Element: Acct Unit     Required, GL accounting unit for
                       commitment transactions.

GMA-ACCOUNT            Numeric 6
Element: Account       Required, GL account for commitment
                       transactions.

GMA-SUB-ACCOUNT        Numeric 4
Element: Sub Acct      GL sub account for commitment
                       transactions.

GMA-SEQUENCE-NBR       Numeric 4
Element: Sequence Nbr  The user-assigned sequence number to
                       keep the records unique and to determine
                       order.

GMA-END-DATE           Numeric 8  (yyyymmdd)
Element: End Date      Identifies the end date for labor
                       distribution records, when activity is
                       present, defaults period of performance
                       end date for system PR.  When activity
                       is not present, defaults to current GL
                       year end date.

GMA-GM-SALARY-PCT      Signed 13.6
Element: Gm Salary Pct Percentage of salary funded by the
                       distribution.

GMA-EFFORT-PCT         Signed 13.6
Element: Effort Pct    Percentage of planned effort to be
                       transferred to the activity and GL
                       account specified; negatives are not
                       permitted.

GMA-SEGMENT-FLAG       Alpha 1
Element: Segment Flag  Indicates whether user analysis values
                       (SL segment) have been populated for the
                       distribution line.

GMA-OBJ-ID             Numeric 12
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

GMA-GML-OBJ-ID         Numeric 12
Element: Obj Id        Object ID of the header (GMLABDIST)
                       record for the detail (GMLABDISTX)
                       record.

GMA-EST-MONTH-AMT      Signed 18.2
Element: Intl Amt      Estimated amount monthly gross pay;
                       determined from EMPLOYEE.PRO-RATE-A-SAL
                       (prorated annual salary), divided by 12.
                       Estimated amounts in GMLABDISTX are for
                       informational purposes only.  They are
                       determined and stored in at the time the
                       record is created, and are not
                       recalculated on subsequent changes to
                       the record.

GMA-EST-TOTAL-AMT      Signed 18.2
Element: Intl Amt      Estimated amount of gross pay for grant
                       period; multiply EST-MONTH-AMT times the
                       number of months between start and end
                       date (number of days between start and
                       end date divided by 30 days).

GMA-EST-GRANT-AMT      Signed 18.2
Element: Intl Amt      Estimated amount of gross pay for
                       grant; multiply EST-TOTAL-AMT times
                       salary percentage split (SALARY-PCT).

GMA-LN-STATUS          Alpha 1
Element: Ln Status     Identifies labor distribution line's
                       approval status.

                       U - Unreleased
                       R - Released
                       A - Approved
                       H - Hold
                       U = Unreleased
                       R = Released
                       A = Approved
                       H = Hold

GMA-LN-APPR-LEVEL      Alpha 20
Element: Ln Appr Level Optional, identifies current level of
                       approval when multiple approvals are
                       used.

                       Captured automatically to identify who
                       initiated current status.

GMA-LN-STATUS-DATE     Numeric 8  (yyyymmdd)
Element: Ln Status DateCaptured automatically; identifies
                       system date on which current status
                       occurred.

GMA-LN-STATUS-TIME     Numeric 6  (hhmmss)
Element: Ln Status TimeCaptured automatically; identifies
                       system time when current status
                       occurred.

GMA-LN-STATUS-USER     Alpha 10  (Lower Case)
Element: Ln Status UserCaptured automatically to identify who
                       initiated the current status.

GMA-FRNG-RATE          Signed 14.7
Element: Curr Rate     A default fringe rate that can be used
                       by the GM110 program to create
                       commitments for fringe amounts.  There
                       is a parameter choice on the GM110
                       program that allows the user to default
                       the fringe rate, post-to account and
                       account category information from the
                       activity or the employee.

GMA-FRNG-ACCT-CAT      Alpha 5
Element: Frng Acct Cat A default post-to fringe account
                       category that can be used by GM110
                       program to create commitments for fringe
                       amounts.  There is a parameter choice on
                       the GM110 program that allows the user
                       to default the rate, post-to account and
                       account category information from the
                       activity or employee.

GMA-FRNG-ACCOUNT       Numeric 6
Element: Frng Account  A default post-to fringe account that
                       can be used by the GM110 program to
                       create commitments for fringe amounts.
                       There is a parameter choice on the GM110
                       program that allows the user to default
                       the fringe rate, post-to account and
                       account category information from the
                       activity or employee.

GMA-FRNG-SUB-ACCT      Numeric 4
Element: Frng Sub Acct A default post-to fringe sub account
                       that can be used by the GM110 program to
                       create commitments for fringe amounts.
                       There is a parameter choice on the GM110
                       program that allows the user to default
                       the fringe rate, post-to account and
                       account category information from the
                       activity or employee.

GMA-CALC-FRNG          Alpha 1
Element: Calc Frng     Determines whether distiribution line is
                       subject to fringe calculation during
                       salary encumbrance processing (GM110);
                       if set to N, no fringe is calculated on
                       labor encumbrance.
                       Y = Yes
                       N = No

GMA-CAP-APPLIED        Alpha 1
Element: Flag

GMA-CAP-EMPL-SAL       Signed 18.2
Element: Intl Amt

GMA-CAP-ALLOW-SAL      Signed 18.2
Element: Intl Amt

GMA-CAP-SAL-OVER       Signed 18.2
Element: Intl Amt

GMA-CAP-ORIG-PCT       Signed 13.6
Element: Effort Pct    Percentage of planned effort to be
                       transferred to the activity and GL
                       account specified; negatives are not
                       permitted.

GMA-CAP-OVER-PCT       Signed 13.6
Element: Effort Pct    Percentage of planned effort to be
                       transferred to the activity and GL
                       account specified; negatives are not
                       permitted.

GMA-CAP-PCT            Signed 13.6
Element: Effort Pct    Percentage of planned effort to be
                       transferred to the activity and GL
                       account specified; negatives are not
                       permitted.

GMA-ORIG-EMP-SAL       Signed 18.2
Element: Intl Amt

GMA-ORIG-SAL-CAP       Signed 18.2
Element: Intl Amt

GMA-OVERAGE-OBJ-ID     Numeric 12
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

                         GMLABDISTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMASET1   OBJ-ID

GMASET2   GML-OBJ-ID    KeyChange                                ET530   PR195
          SEQUENCE-NBR                                           PR197   PR82.1
          OBJ-ID                                                 PR85.1

GMASET3   GML-OBJ-ID    KeyChange
          ACTIVITY
          ACCT-CATEGORY
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID

GMASET4   ACTIVITY      KeyChange                                AC10.1  AC300
          ACCT-CATEGORY                                          AC310
          COMPANY
          ACCT-UNIT
          ACCOUNT
          EFFECT-DATE
          GML-OBJ-ID
          OBJ-ID

GMASET5   ACTIVITY      KeyChange, Subset
          ACCT-CATEGORY Where ACTIVITY != Spaces
          EFFECT-DATE
          OBJ-ID

GMASET6   HR-COMPANY    KeyChange
          EMPLOYEE
          JOB-CODE
          POSITION
          PAY-CODE
          EFFECT-DATE
          SEQUENCE-NBR
          OBJ-ID

                         GMLABDISTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            GMA-ACCT-CATEGORY     -> -ACCT-CATEGORY  (XXXXXXXXXX)

Acacctcat Frng ACACCTCAT    Not Required

                            GMA-FRNG-ACCT-CAT     -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Not Required

                            GMA-ACTIVITY          -> ACV-ACTIVITY

Acactseg       ACACTSEG     Not Required

                            ACV-OBJ-ID            -> CSG-OBJ-ID

Employee       EMPLOYEE     Required

                            GMA-HR-COMPANY        -> EMP-COMPANY
                            GMA-EMPLOYEE          -> EMP-EMPLOYEE

Glnames        GLNAMES      Not Required

                            GMA-COMPANY           -> GLN-COMPANY
                            GMA-ACCT-UNIT         -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            GMA-COMPANY           -> GLS-COMPANY

Gmgmaseg       GMGMASEG     Not Required

                            GMA-OBJ-ID            -> GMS-GMA-OBJ-ID

Gmlabdist      GMLABDIST    Required

                            GMA-GML-OBJ-ID        -> GML-OBJ-ID

Gmlabdistx Ovr GMLABDISTX   Not Required

                            GMA-OVERAGE-OBJ-ID    -> GMA-OBJ-ID

Prsystem Comp  PRSYSTEM     Required

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