|
|
GMLABDISTX 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
ET530 PR195 PR197 PR82.1 PR85.1
UPDATED BY
AC300 AC310 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMA-HR-COMPANY Numeric 4
Element: Company Hr
GMA-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.
GMA-JOB-CODE Alpha 9
Element: Job Code Contains a user-defined code that
represents a type of job. Optional,
permitted only if position rules are not
in effect.
GMA-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.
GMA-POSITION Alpha 12
Element: Position Contains the user-defined code that
represents a position in the company.
Optional, permitted only if position
rules are in effect.
GMA-EFFECT-DATE Numeric 8 (yyyymmdd)
Element: Effect Date Effective date for labor distribution
record.
GMA-ACTIVITY Alpha 15
Element: Activity Posting level activity that identifies
the grant to which a percentage of the
salary should be encumbered and
distributed.
GMA-ACCT-CATEGORY Alpha 5
Element: Acct Category Valid account category for posting
level activity. Must be a detail level
account category.
GMA-COMPANY Numeric 4
Element: Company Required, GL company for commitment
transactions.
GMA-ACCT-UNIT Alpha 15
Element: Acct Unit Required, GL accounting unit for
commitment transactions.
GMA-ACCOUNT Numeric 6
Element: Account Required, GL account for commitment
transactions.
GMA-SUB-ACCOUNT Numeric 4
Element: Sub Acct GL sub account for commitment
transactions.
GMA-SEQUENCE-NBR Numeric 4
Element: Sequence Nbr The user-assigned sequence number to
keep the records unique and to determine
order.
GMA-END-DATE Numeric 8 (yyyymmdd)
Element: End Date Identifies the end date for labor
distribution records, when activity is
present, defaults period of performance
end date for system PR. When activity
is not present, defaults to current GL
year end date.
GMA-GM-SALARY-PCT Signed 13.6
Element: Gm Salary Pct Percentage of salary funded by the
distribution.
GMA-EFFORT-PCT Signed 13.6
Element: Effort Pct Percentage of planned effort to be
transferred to the activity and GL
account specified; negatives are not
permitted.
GMA-SEGMENT-FLAG Alpha 1
Element: Segment Flag Indicates whether user analysis values
(SL segment) have been populated for the
distribution line.
GMA-OBJ-ID Numeric 12
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
GMA-GML-OBJ-ID Numeric 12
Element: Obj Id Object ID of the header (GMLABDIST)
record for the detail (GMLABDISTX)
record.
GMA-EST-MONTH-AMT Signed 18.2
Element: Intl Amt Estimated amount monthly gross pay;
determined from EMPLOYEE.PRO-RATE-A-SAL
(prorated annual salary), divided by 12.
Estimated amounts in GMLABDISTX are for
informational purposes only. They are
determined and stored in at the time the
record is created, and are not
recalculated on subsequent changes to
the record.
GMA-EST-TOTAL-AMT Signed 18.2
Element: Intl Amt Estimated amount of gross pay for grant
period; multiply EST-MONTH-AMT times the
number of months between start and end
date (number of days between start and
end date divided by 30 days).
GMA-EST-GRANT-AMT Signed 18.2
Element: Intl Amt Estimated amount of gross pay for
grant; multiply EST-TOTAL-AMT times
salary percentage split (SALARY-PCT).
GMA-LN-STATUS Alpha 1
Element: Ln Status Identifies labor distribution line's
approval status.
U - Unreleased
R - Released
A - Approved
H - Hold
U = Unreleased
R = Released
A = Approved
H = Hold
GMA-LN-APPR-LEVEL Alpha 20
Element: Ln Appr Level Optional, identifies current level of
approval when multiple approvals are
used.
Captured automatically to identify who
initiated current status.
GMA-LN-STATUS-DATE Numeric 8 (yyyymmdd)
Element: Ln Status DateCaptured automatically; identifies
system date on which current status
occurred.
GMA-LN-STATUS-TIME Numeric 6 (hhmmss)
Element: Ln Status TimeCaptured automatically; identifies
system time when current status
occurred.
GMA-LN-STATUS-USER Alpha 10 (Lower Case)
Element: Ln Status UserCaptured automatically to identify who
initiated the current status.
GMA-FRNG-RATE Signed 14.7
Element: Curr Rate A default fringe rate that can be used
by the GM110 program to create
commitments for fringe amounts. There
is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or the employee.
GMA-FRNG-ACCT-CAT Alpha 5
Element: Frng Acct Cat A default post-to fringe account
category that can be used by GM110
program to create commitments for fringe
amounts. There is a parameter choice on
the GM110 program that allows the user
to default the rate, post-to account and
account category information from the
activity or employee.
GMA-FRNG-ACCOUNT Numeric 6
Element: Frng Account A default post-to fringe account that
can be used by the GM110 program to
create commitments for fringe amounts.
There is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or employee.
GMA-FRNG-SUB-ACCT Numeric 4
Element: Frng Sub Acct A default post-to fringe sub account
that can be used by the GM110 program to
create commitments for fringe amounts.
There is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or employee.
GMA-CALC-FRNG Alpha 1
Element: Calc Frng Determines whether distiribution line is
subject to fringe calculation during
salary encumbrance processing (GM110);
if set to N, no fringe is calculated on
labor encumbrance.
Y = Yes
N = No
GMA-CAP-APPLIED Alpha 1
Element: Flag
GMA-CAP-EMPL-SAL Signed 18.2
Element: Intl Amt
GMA-CAP-ALLOW-SAL Signed 18.2
Element: Intl Amt
GMA-CAP-SAL-OVER Signed 18.2
Element: Intl Amt
GMA-CAP-ORIG-PCT Signed 13.6
Element: Effort Pct Percentage of planned effort to be
transferred to the activity and GL
account specified; negatives are not
permitted.
GMA-CAP-OVER-PCT Signed 13.6
Element: Effort Pct Percentage of planned effort to be
transferred to the activity and GL
account specified; negatives are not
permitted.
GMA-CAP-PCT Signed 13.6
Element: Effort Pct Percentage of planned effort to be
transferred to the activity and GL
account specified; negatives are not
permitted.
GMA-ORIG-EMP-SAL Signed 18.2
Element: Intl Amt
GMA-ORIG-SAL-CAP Signed 18.2
Element: Intl Amt
GMA-OVERAGE-OBJ-ID Numeric 12
Element: Obj Id This is the object identifier. It is
used to relate commitments or posted
transactions back to the originating
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
GMLABDISTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMASET1 OBJ-ID
GMASET2 GML-OBJ-ID KeyChange ET530 PR195
SEQUENCE-NBR PR197 PR82.1
OBJ-ID PR85.1
GMASET3 GML-OBJ-ID KeyChange
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
GMASET4 ACTIVITY KeyChange AC10.1 AC300
ACCT-CATEGORY AC310
COMPANY
ACCT-UNIT
ACCOUNT
EFFECT-DATE
GML-OBJ-ID
OBJ-ID
GMASET5 ACTIVITY KeyChange, Subset
ACCT-CATEGORY Where ACTIVITY != Spaces
EFFECT-DATE
OBJ-ID
GMASET6 HR-COMPANY KeyChange
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
EFFECT-DATE
SEQUENCE-NBR
OBJ-ID
GMLABDISTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
GMA-ACCT-CATEGORY -> -ACCT-CATEGORY (XXXXXXXXXX)
Acacctcat Frng ACACCTCAT Not Required
GMA-FRNG-ACCT-CAT -> AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
GMA-ACTIVITY -> ACV-ACTIVITY
Acactseg ACACTSEG Not Required
ACV-OBJ-ID -> CSG-OBJ-ID
Employee EMPLOYEE Required
GMA-HR-COMPANY -> EMP-COMPANY
GMA-EMPLOYEE -> EMP-EMPLOYEE
Glnames GLNAMES Not Required
GMA-COMPANY -> GLN-COMPANY
GMA-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GMA-COMPANY -> GLS-COMPANY
Gmgmaseg GMGMASEG Not Required
GMA-OBJ-ID -> GMS-GMA-OBJ-ID
Gmlabdist GMLABDIST Required
GMA-GML-OBJ-ID -> GML-OBJ-ID
Gmlabdistx Ovr GMLABDISTX Not Required
GMA-OVERAGE-OBJ-ID -> GMA-OBJ-ID
Prsystem Comp PRSYSTEM Required
GMA-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
