Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GMRETDISTX


                            GMRETDISTX FILE

THe GMRETDISTX file stores labor distribution and planned effort percentages
for labor cost transfer templates.  Percentages are stored by GL account and
activity.

UPDATED BY

AC300     AC310     AC10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GMH-HR-COMPANY         Numeric 4
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

GMH-JOB-CODE           Alpha 9
Element: Job Code      Optional, not permitted if position is
                       used.

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

GMH-POSITION           Alpha 12
Element: Position      Optional, not permitted if job code is
                       populated.

GMH-START-DATE         Numeric 8  (yyyymmdd)
Element: Start Date

GMH-END-DATE           Numeric 8  (yyyymmdd)
Element: End Date      The end date for this effort period.

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

GMH-ACTIVITY           Alpha 15
Element: Activity      Posting level activity that identifies
                       the grant to which costs should be
                       transferred.


GMH-ACCT-CATEGORY      Alpha 5
Element: Acct Category Identifies account category to which
                       labor costs should be transferred. Must
                       be a detail account category.


GMH-COMPANY            Numeric 4
Element: Company       Required, identifies the GL company to
                       which labor costs should be transferred.

GMH-ACCT-UNIT          Alpha 15
Element: Acct Unit     Required, identifies the GL posting
                       level accounting unit to which labor
                       costs should be transferred.

GMH-ACCOUNT            Numeric 6
Element: Account       Required, identifies the GL account to
                       which labor costs should be transferred.

GMH-SUB-ACCOUNT        Numeric 4
Element: Sub Acct      Optional, identifies the GL sub account
                       to which labor costs should be
                       transferred.

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

GMH-SALARY-PCT         Signed 13.6
Element: Effort Pct    Percentage of gross earnings to be
                       transferred to the activity and GL
                       account specified; negatives are not
                       permitted.

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

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

GMH-OBJ-ID             Numeric 12
Element: Obj Id        Object ID for the GMRETDISTX record.

GMH-GMI-OBJ-ID         Numeric 12
Element: Obj Id        Object identifier number for GM detail
                       record's header GMRETDIST.

GMH-LN-STATUS          Alpha 1
Element: Ln Status     Identifies line approval status for the
                       template distribution line. Valid values
                       include:
                       U - Unreleased
                       R - Released
                       A - Approved
                       H - Hold
                       U = Unreleased
                       R = Released
                       A = Approved
                       H = Hold

GMH-LN-APPR-LEVEL      Alpha 20
Element: Ln Appr Level Identifies current level or approval
                       when multiple approvals are used.

GMH-LN-STATUS-USER     Alpha 10  (Lower Case)
Element: Ln Status UserCaptured automatically; identifies user
                       who initiated current status.

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

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

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

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

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

                         GMRETDISTX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GMHSET1   OBJ-ID

GMHSET2   GMI-OBJ-ID    KeyChange
          SEQUENCE-NBR
          OBJ-ID

GMHSET3   GMI-OBJ-ID    KeyChange
          ACTIVITY
          ACCT-CATEGORY
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID

GMHSET4   ACTIVITY      KeyChange                                AC10.1  AC300
          ACCT-CATEGORY                                          AC310
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          GMI-OBJ-ID
          OBJ-ID

GMHSET5   HR-COMPANY    KeyChange
          EMPLOYEE
          JOB-CODE
          POSITION
          PAY-CODE
          START-DATE
          END-DATE
          GMI-SEQ-NBR
          SEQUENCE-NBR
          OBJ-ID

                         GMRETDISTX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Not Required

                            GMH-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY  (AAXSET1)

Acactivity     ACACTIVITY   Not Required

                            GMH-ACTIVITY         -> ACV-ACTIVITY

Employee       EMPLOYEE     Required

                            GMH-HR-COMPANY       -> EMP-COMPANY
                            GMH-EMPLOYEE         -> EMP-EMPLOYEE

Glnames        GLNAMES      Not Required

                            GMH-COMPANY          -> GLN-COMPANY
                            GMH-ACCT-UNIT        -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            GMH-COMPANY          -> GLS-COMPANY

Gmgmhseg       GMGMHSEG     Not Required

                            GMH-OBJ-ID           -> GSG-GMH-OBJ-ID

Gmretdist      GMRETDIST    Required

                            GMH-GMI-OBJ-ID       -> GMI-OBJ-ID

Prsystem Comp  PRSYSTEM     Required

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