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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
GMHSET1 |
OBJ-ID |
|
|||||||||
GMHSET2 |
GMI-OBJ-ID SEQUENCE-NBR OBJ-ID |
|
|||||||||
GMHSET3 |
GMI-OBJ-ID ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT OBJ-ID |
|
|||||||||
GMHSET4 |
ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT GMI-OBJ-ID OBJ-ID |
|
| ||||||||
GMHSET5 |
HR-COMPANY EMPLOYEE JOB-CODE POSITION PAY-CODE START-DATE END-DATE GMI-SEQ-NBR SEQUENCE-NBR OBJ-ID |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Not Required
| ||||||
Acactivity | ACACTIVITY |
Not Required
| ||||||
Employee | EMPLOYEE |
Required
| ||||||
Glnames | GLNAMES |
Not Required
| ||||||
Glsystem | GLSYSTEM |
Not Required
| ||||||
Gmretdist | GMRETDIST |
Required
| ||||||
Prsystem Comp | PRSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.