GMLABDISTX – Grant Labor Distribution Dtl
- System
- GM (GM)
- Prefix
GMA- Primary key
OBJ-ID- Fields
- 42
- Updated by
- 7 programs
- Referenced by
- 0 programs
GMLABDISTX is the Grant Labor Distribution Dtl table in Lawson GM (prefix GMA). It is indexed by OBJ-ID (GMASET1); alternate indexes: GMASET2, GMASET3, GMASET4, GMASET5 and GMASET6. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACACTSEG, EMPLOYEE, GLNAMES, GLSYSTEM, GMGMASEG, GMLABDIST and 2 more. It is updated by AC10.1, AC300, PR195, PR197, PR582, PR82.1 and PR85.1. The table has 42 fields, 6 indexes and 11 documented relations.
About GMLABDISTX
No description in the Lawson data dictionary.
Fields (42)
Column = COBOL field name without the GMA- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#GMA-HR-COMPANY SET6HR_COMPANY | Numeric 4 | — | — |
#GMA-EMPLOYEE SET6EMPLOYEE | 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. | — |
#GMA-JOB-CODE SET6JOB_CODE | Alpha 9 | Contains a user-defined code that represents a type of job. Optional, permitted only if position rules are not in effect. | — |
#GMA-PAY-CODE SET6PAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
#GMA-POSITION SET6POSITION | Alpha 12 | Contains the user-defined code that represents a position in the company. Optional, permitted only if position rules are in effect. | — |
#GMA-EFFECT-DATE SET4 SET5 SET6EFFECT_DATE | Numeric 8 (yyyymmdd) | Effective date for labor distribution record. | — |
#GMA-ACTIVITY SET3 SET4 SET5ACTIVITY | Alpha 15 | Posting level activity that identifies the grant to which a percentage of the salary should be encumbered and distributed. | — |
#GMA-ACCT-CATEGORY SET3 SET4 SET5ACCT_CATEGORY | Alpha 5 | Valid account category for posting level activity. Must be a detail level account category. | — |
#GMA-COMPANY SET3 SET4COMPANY | Numeric 4 | Required, GL company for commitment transactions. | — |
#GMA-ACCT-UNIT SET3 SET4ACCT_UNIT | Alpha 15 | Required, GL accounting unit for commitment transactions. | — |
#GMA-ACCOUNT SET3 SET4ACCOUNT | Numeric 6 | Required, GL account for commitment transactions. | — |
#GMA-SUB-ACCOUNT SET3SUB_ACCOUNT | Numeric 4 | GL sub account for commitment transactions. | — |
#GMA-SEQUENCE-NBR SET2 SET6SEQUENCE_NBR | Numeric 4 | The user-assigned sequence number to keep the records unique and to determine order. | — |
#GMA-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | 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-PCTGM_SALARY_PCT | Signed 13.6 | Percentage of salary funded by the distribution. | — |
#GMA-EFFORT-PCTEFFORT_PCT | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
#GMA-SEGMENT-FLAGSEGMENT_FLAG | Alpha 1 | Indicates whether user analysis values (SL segment) have been populated for the distribution line. | — |
#GMA-OBJ-ID PKOBJ_ID | Numeric 12 | 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 SET2 SET3 SET4GML_OBJ_ID | Numeric 12 | Object ID of the header (GMLABDIST) record for the detail (GMLABDISTX) record. | — |
#GMA-EST-MONTH-AMTEST_MONTH_AMT | Signed 18.2 | 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-AMTEST_TOTAL_AMT | Signed 18.2 | 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-AMTEST_GRANT_AMT | Signed 18.2 | Estimated amount of gross pay for grant; multiply EST-TOTAL-AMT times salary percentage split (SALARY-PCT). | — |
#GMA-LN-STATUSLN_STATUS | Alpha 1 | Identifies labor distribution line's approval status. U - Unreleased R - Released A - Approved H - Hold
| — |
#GMA-LN-APPR-LEVELLN_APPR_LEVEL | Alpha 20 | Optional, identifies current level of approval when multiple approvals are used. Captured automatically to identify who initiated current status. | — |
#GMA-LN-STATUS-DATELN_STATUS_DATE | Numeric 8 (yyyymmdd) | Captured automatically; identifies system date on which current status occurred. | — |
#GMA-LN-STATUS-TIMELN_STATUS_TIME | Numeric 6 (hhmmss) | Captured automatically; identifies system time when current status occurred. | — |
#GMA-LN-STATUS-USERLN_STATUS_USER | Alpha 10 (Lower Case) | Captured automatically to identify who initiated the current status. | — |
#GMA-FRNG-RATEFRNG_RATE | Signed 14.7 | 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-CATFRNG_ACCT_CAT | Alpha 5 | 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-ACCOUNTFRNG_ACCOUNT | Numeric 6 | 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-ACCTFRNG_SUB_ACCT | Numeric 4 | 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-FRNGCALC_FRNG | Alpha 1 | 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.
| — |
#GMA-CAP-APPLIEDCAP_APPLIED | Alpha 1 | — | — |
#GMA-CAP-EMPL-SALCAP_EMPL_SAL | Signed 18.2 | — | — |
#GMA-CAP-ALLOW-SALCAP_ALLOW_SAL | Signed 18.2 | — | — |
#GMA-CAP-SAL-OVERCAP_SAL_OVER | Signed 18.2 | — | — |
#GMA-CAP-ORIG-PCTCAP_ORIG_PCT | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
#GMA-CAP-OVER-PCTCAP_OVER_PCT | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
#GMA-CAP-PCTCAP_PCT | Signed 13.6 | Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted. | — |
#GMA-ORIG-EMP-SALORIG_EMP_SAL | Signed 18.2 | — | — |
#GMA-ORIG-SAL-CAPORIG_SAL_CAP | Signed 18.2 | — | — |
#GMA-OVERAGE-OBJ-IDOVERAGE_OBJ_ID | Numeric 12 | 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. | — |
Indexes (6)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMASET1 |
| Primary | — | |
GMASET2 |
| KeyChange | PR195, PR197, PR582, PR82.1, PR85.1 | |
GMASET3 |
| KeyChange | — | |
GMASET4 |
| KeyChange | AC10.1, AC300 | |
GMASET5 |
| KeyChange, Subset | Where ACTIVITY != Spaces | — |
GMASET6 |
| KeyChange | — |
Relations
One to one (11) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required |
| |||||||
| Acacctcat Frng | ACACCTCAT | Not Required |
| |||||||
| Acactivity | ACACTIVITY | Not Required |
| |||||||
| Acactseg | ACACTSEG | Not Required |
| |||||||
| Employee | EMPLOYEE | Required |
| |||||||
| Glnames | GLNAMES | Not Required |
| |||||||
| Glsystem | GLSYSTEM | Not Required |
| |||||||
| Gmgmaseg | GMGMASEG | Not Required |
| |||||||
| Gmlabdist | GMLABDIST | Required |
| |||||||
| Gmlabdistx Ovr | GMLABDISTX | Not Required |
| |||||||
| Prsystem Comp | PRSYSTEM | Required |
|