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 HR28.1 HR511 LT101
ZH510 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PR110 PR113 PR12.6 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR195 PR197
PR30.2 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 HR28.1
HR511 LT101
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR12.6
PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR13.9
PR195 PR197
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: Thu Jun 09 11:14:24 2016

Home
Contact Us



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