GMLABDIST

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
BN305 HR11.1 HR11.2 HR511 PA02.1 PA100
PA102 PA115 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR195 PR197 PR582 PR82.1 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GML-OBJ-ID
Element: Obj Id
Numeric 12
Parent object ID for GMLABDISTX file.
GML-HR-COMPANY
Element: Company Hr
Numeric 4
GML-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.
GML-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job. Optional, not permitted if position rules are in effect.
GML-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.
GML-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company. Optional, not permitted if job code is used.
GML-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Effective date for the labor distribution record.
GML-DFLT-ENCUM-FL
Element: Dflt Encum Fl
Alpha 1
Determines which distribution to use for salary encumbrance processing when mulitiple distributions exist for the same employee and effective date.
Y = Yes
N = No
GML-SALARY-PCT-TOT
Element: Salary Pct Tot
Signed 13.6
Total salary distributions from GMLABDISTX, can be less than or equal to 100%.
GML-EFFORT-PCT-TOT
Element: Effort Pct Tot
Signed 13.6
Total planned effort distributions from GMLABDISTX, must equal 100% to be eligible for processing.
GML-LAST-SEQ-NBR
Element: Last Seq Nbr
Numeric 6
Identifies the last sequence number used. Ensures the record is unique.
GML-ENCUM-STATUS
Element: Encum Status
Alpha 1

" " = Not Approved
1 = Auto Approved
2 = User Approved


GMLABDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMLSET1 OBJ-ID
GMLSET3 HR-COMPANY
EMPLOYEE
EFFECT-DATE*
JOB-CODE
POSITION
PAY-CODE
BN305 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR195 PR197
PR582 PR82.1
PR85.1
GMLSET4 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE
GMLSET5 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE*


GMLABDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
GML-HR-COMPANY->EMP-COMPANY (EMPSET1)
GML-EMPLOYEE->EMP-EMPLOYEE
Prsystem Comp PRSYSTEM Required
GML-HR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


GMLABDIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gmlabdistx GMLABDISTX
GML-OBJ-ID->GMA-GML-OBJ-ID
  GMA-SEQUENCE-NBR
  GMA-OBJ-ID


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

Home
Contact Us



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