Grant Labor Distribution Dtl

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.
UPDATED BY

AC300	PR195	PR197	PR582	PR82.1	PR85.1
AC10.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GMA-HR-COMPANY Element: Company Hr	Numeric 4
GMA-EMPLOYEE Element: Employee	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 Element: Job 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 Element: Pay Code	Alpha 4 Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
GMA-POSITION Element: Position	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 Element: Effect Date	Numeric 8 (yyyymmdd) Effective date for labor distribution record.
GMA-ACTIVITY Element: Activity	Alpha 15 Posting level activity that identifies the grant to which a percentage of the salary should be encumbered and distributed.
GMA-ACCT-CATEGORY Element: Acct Category	Alpha 5 Valid account category for posting level activity. Must be a detail level account category.
GMA-COMPANY Element: Company	Numeric 4 Required, GL company for commitment transactions.
GMA-ACCT-UNIT Element: Acct Unit	Alpha 15 Required, GL accounting unit for commitment transactions.
GMA-ACCOUNT Element: Account	Numeric 6 Required, GL account for commitment transactions.
GMA-SUB-ACCOUNT Element: Sub Acct	Numeric 4 GL sub account for commitment transactions.
GMA-SEQUENCE-NBR Element: Sequence Nbr	Numeric 4 The user-assigned sequence number to keep the records unique and to determine order.
GMA-END-DATE Element: End 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-PCT Element: Gm Salary Pct	Signed 13.6 Percentage of salary funded by the distribution.
GMA-EFFORT-PCT Element: Effort Pct	Signed 13.6 Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted.
GMA-SEGMENT-FLAG Element: Segment Flag	Alpha 1 Indicates whether user analysis values (SL segment) have been populated for the distribution line.
GMA-OBJ-ID Element: 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.
GMA-GML-OBJ-ID Element: Obj Id	Numeric 12 Object ID of the header (GMLABDIST) record for the detail (GMLABDISTX) record.
GMA-EST-MONTH-AMT Element: Intl 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-AMT Element: Intl 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-AMT Element: Intl Amt	Signed 18.2 Estimated amount of gross pay for grant; multiply EST-TOTAL-AMT times salary percentage split (SALARY-PCT).
GMA-LN-STATUS Element: Ln Status	Alpha 1 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 Element: Ln 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-DATE Element: Ln Status Date	Numeric 8 (yyyymmdd) Captured automatically; identifies system date on which current status occurred.
GMA-LN-STATUS-TIME Element: Ln Status Time	Numeric 6 (hhmmss) Captured automatically; identifies system time when current status occurred.
GMA-LN-STATUS-USER Element: Ln Status User	Alpha 10 (Lower Case) Captured automatically to identify who initiated the current status.
GMA-FRNG-RATE Element: Curr 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-CAT Element: Frng 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-ACCOUNT Element: Frng 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-ACCT Element: Frng 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-FRNG Element: Calc 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. Y = Yes N = No
GMA-CAP-APPLIED Element: Flag	Alpha 1
GMA-CAP-EMPL-SAL Element: Intl Amt	Signed 18.2
GMA-CAP-ALLOW-SAL Element: Intl Amt	Signed 18.2
GMA-CAP-SAL-OVER Element: Intl Amt	Signed 18.2
GMA-CAP-ORIG-PCT Element: Effort 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-PCT Element: Effort Pct	Signed 13.6 Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted.
GMA-CAP-PCT Element: Effort 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-SAL Element: Intl Amt	Signed 18.2
GMA-ORIG-SAL-CAP Element: Intl Amt	Signed 18.2
GMA-OVERAGE-OBJ-ID Element: 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.

GMLABDISTX FILE INDEX

GMLABDISTX FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.