|
|
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
BN305 ET530 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
PR195 PR197 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GML-OBJ-ID Numeric 12
Element: Obj Id Parent object ID for GMLABDISTX file.
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: Pay 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: Effect Date Effective 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
GMLSET3 HR-COMPANY BN305 ET530
EMPLOYEE HR11.1 HR11.2
EFFECT-DATE* HR511 PA02.1
JOB-CODE PA100 PA102
POSITION PA115 PA13.1
PAY-CODE PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR195 PR197
PR82.1 PR85.1
GMLSET4 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE
GMLSET5 HR-COMPANY ET530 PR195
EMPLOYEE PR197 PR82.1
JOB-CODE PR85.1
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
|
