GMRETDISTX

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
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.


GMRETDISTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GMHSET1 OBJ-ID
GMHSET2 GMI-OBJ-ID
SEQUENCE-NBR
OBJ-ID
KeyChange
GMHSET3 GMI-OBJ-ID
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
KeyChange
GMHSET4 ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GMI-OBJ-ID
OBJ-ID
KeyChange
AC10.1
GMHSET5 HR-COMPANY
EMPLOYEE
JOB-CODE
POSITION
PAY-CODE
START-DATE
END-DATE
GMI-SEQ-NBR
SEQUENCE-NBR
OBJ-ID
KeyChange


GMRETDISTX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Gmretdist GMRETDIST Required
GMH-GMI-OBJ-ID->GMI-OBJ-ID
Prsystem Comp PRSYSTEM Required
GMH-HR-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL


File created: Wed Jun 08 20:49:00 2016

Home
Contact Us



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