|
|
GMLABDIST FILE
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.
REFERENCED BY
HR11.1 HR11.2 HR511 PA02.1 PA100 PA102
PA115 PA502 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR197 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GML-OBJ-ID Numeric 12
Object Parent object ID for GMLABDISTX file.
Identification
GML-HR-COMPANY Numeric 4
Element: Company Hr
GML-EMPLOYEE Numeric 9
Element: Employee 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 Alpha 9
Element: Job Code Contains a user-defined code that
represents a type of job. Optional, not
permitted if position rules are in
effect.
GML-PAY-CODE Alpha 4
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
GML-POSITION Alpha 12
Element: Position Contains the user-defined code that
represents a position in the company.
Optional, not permitted if job code is
used.
GML-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effective DateEffective date for the labor
distribution record.
GML-DFLT-ENCUM-FL Alpha 1
Element: Dflt Encum Fl 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 Signed 13.6
Element: Salary Pct TotTotal salary distributions from
GMLABDISTX, can be less than or equal to
100%.
GML-EFFORT-PCT-TOT Signed 13.6
Element: Effort Pct TotTotal planned effort distributions from
GMLABDISTX, must equal 100% to be
eligible for processing.
GML-LAST-SEQ-NBR Numeric 6
Element: Last Seq Nbr Identifies the last sequence number
used. Ensures the record is unique.
GML-ENCUM-STATUS Alpha 1
Element: Encum Status " " = Not Approved
1 = Auto Approved
2 = User Approved
GMLABDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMLSET1 OBJ-ID
GMLSET2 HR-COMPANY
EFFECT-DATE*
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
GMLSET3 HR-COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
EFFECT-DATE* PA100 PA102
JOB-CODE PA115 PA502
POSITION PA52.1 PA52.3
PAY-CODE PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
GMLSET4 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE
GMLSET5 HR-COMPANY PR197 PR82.1
EMPLOYEE PR85.1
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE*
GMLABDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
GML-HR-COMPANY -> EMP-COMPANY
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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Gmlabdistx GMLABDISTX
GML-OBJ-ID -> GMA-GML-OBJ-ID
GMA-SEQUENCE-NBR
GMA-OBJ-ID
|
