GMLABDISTX

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMASET1 OBJ-ID
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
GMASET5 ACTIVITY
ACCT-CATEGORY
EFFECT-DATE
OBJ-ID
KeyChange, Subset
WhereACTIVITY !=Spaces
GMASET6 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE
SEQUENCE-NBR
OBJ-ID
KeyChange


GMLABDISTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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
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


File created: Wed Jun 08 20:49:00 2016

Home
Contact Us



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