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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMA-HR-COMPANYHR_COMPANY | Numeric 4 | — | — |
GMA-EMPLOYEEEMPLOYEE | 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-CODEJOB_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-CODEPAY_CODE | Alpha 4 | Contains the pay code. A pay code is a user-defined code that identifies a kind of pay. | — |
GMA-POSITIONPOSITION | 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-DATEEFFECT_DATE | Numeric 8 (yyyymmdd) | Effective date for labor distribution record. | — |
GMA-ACTIVITYACTIVITY | Alpha 15 | Posting level activity that identifies the grant to which a percentage of the salary should be encumbered and distributed. | — |
GMA-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | Valid account category for posting level activity. Must be a detail level account category. | — |
GMA-COMPANYCOMPANY | Numeric 4 | Required, GL company for commitment transactions. | — |
GMA-ACCT-UNITACCT_UNIT | Alpha 15 | Required, GL accounting unit for commitment transactions. | — |
GMA-ACCOUNTACCOUNT | Numeric 6 | Required, GL account for commitment transactions. | — |
GMA-SUB-ACCOUNTSUB_ACCOUNT | Numeric 4 | GL sub account for commitment transactions. | — |
GMA-SEQUENCE-NBRSEQUENCE_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-IDGML_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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMASET1 | OBJ-ID | Primary | — | |
GMASET2 | GML-OBJ-ID, SEQUENCE-NBR, OBJ-ID | KeyChange | PR195, PR197, PR582, PR82.1, PR85.1 | |
GMASET3 | GML-OBJ-ID, ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-ID | KeyChange | — | |
GMASET4 | ACTIVITY, ACCT-CATEGORY, COMPANY, ACCT-UNIT, ACCOUNT, EFFECT-DATE, GML-OBJ-ID, OBJ-ID | KeyChange | AC10.1, AC300 | |
GMASET5 | ACTIVITY, ACCT-CATEGORY, EFFECT-DATE, OBJ-ID | KeyChange, Subset | Where ACTIVITY != Spaces | — |
GMASET6 | HR-COMPANY, EMPLOYEE, JOB-CODE, POSITION, PAY-CODE, EFFECT-DATE, SEQUENCE-NBR, OBJ-ID | KeyChange | — |
Relations
One to one (11) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Acacctcat | ACACCTCAT | Not Required | GMA-ACCT-CATEGORY → AAX-ACCT-CATEGORY (AAXSET1) | |
| 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 |