|
|
GMRETDISTX FILE
THe GMRETDISTX file stores labor distribution and planned effort percentages
for labor cost transfer templates. Percentages are stored by GL account and
activity.
UPDATED BY
AC300 AC310 AC10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GMH-HR-COMPANY Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
GMH-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.
GMH-JOB-CODE Alpha 9
Element: Job Code Optional, not permitted if position is
used.
GMH-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.
GMH-POSITION Alpha 12
Element: Position Optional, not permitted if job code is
populated.
GMH-START-DATE Numeric 8 (yyyymmdd)
Element: Start Date
GMH-END-DATE Numeric 8 (yyyymmdd)
Element: End Date The end date for this effort period.
GMH-GMI-SEQ-NBR Numeric 4
Element: Sequence Nbr The user-assigned sequence number to
keep the records unique and to determine
order.
GMH-ACTIVITY Alpha 15
Element: Activity Posting level activity that identifies
the grant to which costs should be
transferred.
GMH-ACCT-CATEGORY Alpha 5
Element: Acct Category Identifies account category to which
labor costs should be transferred. Must
be a detail account category.
GMH-COMPANY Numeric 4
Element: Company Required, identifies the GL company to
which labor costs should be transferred.
GMH-ACCT-UNIT Alpha 15
Element: Acct Unit Required, identifies the GL posting
level accounting unit to which labor
costs should be transferred.
GMH-ACCOUNT Numeric 6
Element: Account Required, identifies the GL account to
which labor costs should be transferred.
GMH-SUB-ACCOUNT Numeric 4
Element: Sub Acct Optional, identifies the GL sub account
to which labor costs should be
transferred.
GMH-SEQUENCE-NBR Numeric 4
Element: Sequence Nbr The user-assigned sequence number to
keep the records unique and to determine
order.
GMH-SALARY-PCT Signed 13.6
Element: Effort Pct Percentage of gross earnings to be
transferred to the activity and GL
account specified; negatives are not
permitted.
GMH-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.
GMH-SEGMENT-FLAG Alpha 1
Element: Segment Flag Indicates whether user analysis values
(SL segment) have been populated for the
distribution line.
GMH-OBJ-ID Numeric 12
Element: Obj Id Object ID for the GMRETDISTX record.
GMH-GMI-OBJ-ID Numeric 12
Element: Obj Id Object identifier number for GM detail
record's header GMRETDIST.
GMH-LN-STATUS Alpha 1
Element: Ln Status Identifies line approval status for the
template distribution line. Valid values
include:
U - Unreleased
R - Released
A - Approved
H - Hold
U = Unreleased
R = Released
A = Approved
H = Hold
GMH-LN-APPR-LEVEL Alpha 20
Element: Ln Appr Level Identifies current level or approval
when multiple approvals are used.
GMH-LN-STATUS-USER Alpha 10 (Lower Case)
Element: Ln Status UserCaptured automatically; identifies user
who initiated current status.
GMH-LN-STATUS-DATE Numeric 8 (yyyymmdd)
Element: Ln Status DateCaptured automatically; identifies
system date on which current status
occurred.
GMH-LN-STATUS-TIME Numeric 6 (hhmmss)
Element: Ln Status TimeCaptured automatically; identifies
system time when current status
occurred.
GMH-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.
GMH-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.
GMH-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.
GMRETDISTX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMHSET1 OBJ-ID
GMHSET2 GMI-OBJ-ID KeyChange
SEQUENCE-NBR
OBJ-ID
GMHSET3 GMI-OBJ-ID KeyChange
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
GMHSET4 ACTIVITY KeyChange AC10.1 AC300
ACCT-CATEGORY AC310
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GMI-OBJ-ID
OBJ-ID
GMHSET5 HR-COMPANY KeyChange
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
START-DATE
END-DATE
GMI-SEQ-NBR
SEQUENCE-NBR
OBJ-ID
GMRETDISTX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
GMH-ACCT-CATEGORY -> AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Not Required
GMH-ACTIVITY -> ACV-ACTIVITY
Employee EMPLOYEE Required
GMH-HR-COMPANY -> EMP-COMPANY
GMH-EMPLOYEE -> EMP-EMPLOYEE
Glnames GLNAMES Not Required
GMH-COMPANY -> GLN-COMPANY
GMH-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GMH-COMPANY -> GLS-COMPANY
Gmgmhseg GMGMHSEG Not Required
GMH-OBJ-ID -> GSG-GMH-OBJ-ID
Gmretdist GMRETDIST Required
GMH-GMI-OBJ-ID -> GMI-OBJ-ID
Prsystem Comp PRSYSTEM Required
GMH-HR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
|
