|
|
GMRETDIST FILE
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.
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMI-OBJ-ID Numeric 12
Object This is the object identifier. Parent
Identification object identifier for GMRETDISTX file.
GMI-HR-COMPANY Numeric 4
Element: Company Human Resources company number.
GMI-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.
GMI-JOB-CODE Alpha 9
Element: Job Code Contains a user-defined code that
represents a type of job.
GMI-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.
GMI-POSITION Alpha 12
Element: Position Contains the user-defined code that
represents a position in the company.
GMI-START-DATE Numeric 8 (yyyymmdd)
Element: Start Date 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 Numeric 8 (yyyymmdd)
Element: Ending Date 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 Signed 13.6
Element: Salary Pct TotTotal salary percentage. Must equal
100% for record to be eligible for
processing.
GMI-EFFORT-PCT-TOT Signed 13.6
Element: Effort Pct TotTotal planned effort percentage. Must
be equal to 100% to be eligible for
processing.
GMI-LAST-SEQ-NBR Numeric 6
Element: Last Seq Nbr Identifies the last sequence number
used. Ensures the record is unique.
GMI-STATUS Numeric 1
Element: Status 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 Numeric 6 (hhmmss)
Element: Maintenance TiThe time last changed.
GMI-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Maintenance DaThe date last changed.
GMI-SEQUENCE-NBR Numeric 4
Element: Sequence NumbeThe user-assigned sequence number to
keep the records unique and to determine
order.
GMRETDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMISET1 OBJ-ID
GMISET2 HR-COMPANY
START-DATE*
END-DATE*
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
SEQUENCE-NBR
GMISET3 HR-COMPANY HR11.1 HR11.2
EMPLOYEE HR511 PA02.1
START-DATE* PA100 PA102
END-DATE* PA115 PA502
JOB-CODE PA52.1 PA52.3
POSITION PA52.4 PA52.5
PAY-CODE PR110 PR113
SEQUENCE-NBR PR120 PR13.1
PR13.5 PR13.6
PR13.8
GMISET4 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
START-DATE
END-DATE
SEQUENCE-NBR*
GMRETDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Gmretdistx GMRETDISTX
GMI-OBJ-ID -> GMH-GMI-OBJ-ID
GMH-SEQUENCE-NBR
GMH-OBJ-ID
|
