GMRETDIST

The Retro Labor Distribution files (GMRETDIST and GMRETDISTX) are templates that store distribution splits used for after-the-fact labor cost transfers. These templates drive changes to labor cost distributions during Labor Cost Transfer Processing (GM170). This allows users to reverse distributions that were in effect at the time payroll was processed and reapply new distributions based on after-the-fact time studies, effort certification, funding changes and so on.
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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMI-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. Parent object identifier for GMRETDISTX file.
GMI-HR-COMPANY
Element: Company
Numeric 4
Human Resources company number.
GMI-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.
GMI-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job.
GMI-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.
GMI-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
GMI-START-DATE
Element: Start Date
Numeric 8 (yyyymmdd)
Effective (start) date for the template; payroll distributions dated on or after the START-DATE and on or before the END-DATE are eligible for cost transfer during GM170.
GMI-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
End date for the template; payroll distributions dated on or after the START-DATE and or before the END-DATE are eligible for cost transfer during GM170.
GMI-SALARY-PCT-TOT
Element: Salary Pct Tot
Signed 13.6
Total salary percentage. Must equal 100% for record to be eligible for processing.
GMI-EFFORT-PCT-TOT
Element: Effort Pct Tot
Signed 13.6
Total planned effort percentage. Must be equal to 100% to be eligible for processing.
GMI-LAST-SEQ-NBR
Element: Last Seq Nbr
Numeric 6
Identifies the last sequence number used. Ensures the record is unique.
GMI-STATUS
Element: Status
Numeric 1
Identifies posting status for template. Status is 0 if template has not been processed through GM170 in update mode. Status is 1 when template has been selected and processed through GM170 in update mode.
1 = Not Updated
2 = Updated
GMI-MAINT-TIME
Element: Maint Time
Numeric 6 (hhmmss)
The time last changed.
GMI-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
GMI-SEQUENCE-NBR
Element: Sequence Nbr
Numeric 4
The user-assigned sequence number to keep the records unique and to determine order.
GMI-REASON-CODE
Element: Gm Code
Alpha 15
This field contains the reason code, which indicates the cause for a labor cost transfer.


GMRETDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMISET1 OBJ-ID
GMISET3 HR-COMPANY
EMPLOYEE
START-DATE*
END-DATE*
JOB-CODE
POSITION
PAY-CODE
SEQUENCE-NBR
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
GMISET4 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
START-DATE
END-DATE
SEQUENCE-NBR*


GMRETDIST FILE RELATIONS


ONE TO ONE RELATIONS

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


GMRETDIST FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gmretdistx GMRETDISTX
GMI-OBJ-ID->GMH-GMI-OBJ-ID
  GMH-SEQUENCE-NBR
  GMH-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.