Grant Retro Labor Dist Detail

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

AC10.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GMH-HR-COMPANY Element: Company	Numeric 4 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 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.
GMH-JOB-CODE Element: Job Code	Alpha 9 Optional, not permitted if position is used.
GMH-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.
GMH-POSITION Element: Position	Alpha 12 Optional, not permitted if job code is populated.
GMH-START-DATE Element: Start Date	Numeric 8 (yyyymmdd)
GMH-END-DATE Element: End Date	Numeric 8 (yyyymmdd) The end date for this effort period.
GMH-GMI-SEQ-NBR Element: Sequence Nbr	Numeric 4 The user-assigned sequence number to keep the records unique and to determine order.
GMH-ACTIVITY Element: Activity	Alpha 15 Posting level activity that identifies the grant to which costs should be transferred.
GMH-ACCT-CATEGORY Element: Acct Category	Alpha 5 Identifies account category to which labor costs should be transferred. Must be a detail account category.
GMH-COMPANY Element: Company	Numeric 4 Required, identifies the GL company to which labor costs should be transferred.
GMH-ACCT-UNIT Element: Acct Unit	Alpha 15 Required, identifies the GL posting level accounting unit to which labor costs should be transferred.
GMH-ACCOUNT Element: Account	Numeric 6 Required, identifies the GL account to which labor costs should be transferred.
GMH-SUB-ACCOUNT Element: Sub Acct	Numeric 4 Optional, identifies the GL sub account to which labor costs should be transferred.
GMH-SEQUENCE-NBR Element: Sequence Nbr	Numeric 4 The user-assigned sequence number to keep the records unique and to determine order.
GMH-SALARY-PCT Element: Effort Pct	Signed 13.6 Percentage of gross earnings to be transferred to the activity and GL account specified; negatives are not permitted.
GMH-EFFORT-PCT Element: Effort Pct	Signed 13.6 Percentage of planned effort to be transferred to the activity and GL account specified; negatives are not permitted.
GMH-SEGMENT-FLAG Element: Segment Flag	Alpha 1 Indicates whether user analysis values (SL segment) have been populated for the distribution line.
GMH-OBJ-ID Element: Obj Id	Numeric 12 Object ID for the GMRETDISTX record.
GMH-GMI-OBJ-ID Element: Obj Id	Numeric 12 Object identifier number for GM detail record's header GMRETDIST.
GMH-LN-STATUS Element: Ln Status	Alpha 1 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 Element: Ln Appr Level	Alpha 20 Identifies current level or approval when multiple approvals are used.
GMH-LN-STATUS-USER Element: Ln Status User	Alpha 10 (Lower Case) Captured automatically; identifies user who initiated current status.
GMH-LN-STATUS-DATE Element: Ln Status Date	Numeric 8 (yyyymmdd) Captured automatically; identifies system date on which current status occurred.
GMH-LN-STATUS-TIME Element: Ln Status Time	Numeric 6 (hhmmss) Captured automatically; identifies system time when current status occurred.
GMH-FRNG-ACCOUNT Element: Frng Account	Numeric 6 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 Element: Frng Sub Acct	Numeric 4 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 Element: Frng Acct Cat	Alpha 5 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.
GMH-EST-MONTH-AMT Element: Intl Amt	Signed 18.2
GMH-EST-TOTAL-AMT Element: Intl Amt	Signed 18.2
GMH-EST-GRANT-AMT Element: Intl Amt	Signed 18.2
GMH-CAP-APPLIED Element: Flag	Alpha 1
GMH-CAP-EMPL-SAL Element: Intl Amt	Signed 18.2
GMH-CAP-ALLOW-SAL Element: Intl Amt	Signed 18.2
GMH-CAP-SAL-OVER Element: Intl Amt	Signed 18.2
GMH-CAP-ORIG-PCT Element: Effort Pct	Signed 13.6
GMH-CAP-OVER-PCT Element: Effort Pct	Signed 13.6
GMH-CAP-PCT Element: Effort Pct	Signed 13.6
GMH-ORIG-EMP-SAL Element: Intl Amt	Signed 18.2
GMH-ORIG-SAL-CAP Element: Intl Amt	Signed 18.2
GMH-OVERAGE-OBJ-ID Element: Obj Id	Numeric 12

GMRETDISTX FILE INDEX

GMRETDISTX FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.