|
|
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
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMI-OBJ-ID Numeric 12
Element: Obj Id This is the object identifier. Parent
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: Pay 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: End 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: Maint Time The time last changed.
GMI-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Maint Date The date last changed.
GMI-SEQUENCE-NBR Numeric 4
Element: Sequence Nbr The user-assigned sequence number to
keep the records unique and to determine
order.
GMI-REASON-CODE Alpha 15
Element: Gm Code 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 BN305 HR11.1
EMPLOYEE HR11.2 HR511
START-DATE* PA02.1 PA100
END-DATE* PA102 PA115
JOB-CODE PA13.1 PA13.2
POSITION PA502 PA513
PAY-CODE PA52.1 PA52.3
SEQUENCE-NBR PA52.4 PA52.5
PR110 PR113
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
|
