Grant Effort Transaction

The GMTRANEFRT file stores effort transaction used to calculate effort percentages during effort reporting. If a labor cost transfer occurs and the original transaction was subject to effort reporting, a cost transfer adjustment needs to be made in the effort file. The pay period end date is added to the effort transaction file so effort adjustmetns are properly calculated and created when GM170 is urn with the pro-rate distributions option.

REFERENCED BY

BN305	HR11.1	HR11.2	HR11.4	HR28.1	HR511
LT101	LT111	ZH510	PA02.1	PA100	PA102
PA115	PA13.1	PA13.2	PA502	PA513	PA52.1
PA52.3	PA52.4	PA52.5	PR110	PR113	PR12.6
PR120	PR13.1	PR13.5	PR13.6	PR13.8	PR13.9
PR30.2	PR512

UPDATED BY

PR197

PR85.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
GEF-OBJ-ID Element: Obj Id	Numeric 12 Object Identifier. Ensures transaction is unique. Note: This does not track back to the ACTRANS or the PRDISTRIB object id's. It is possible to have an effort transaction with a zero salary amount and a planned effort amount. A zero amount transaction are not permitted in the ACTRANS or PRDISTRIB.	PR197 PR85.1
GEF-RECORD-TYPE Element: Record Type	Alpha 1 This field identifies the type of record defined. Valid values are: S = Summary D = Detail " " = Record created by PR197 1 = Record created by GM500	PR197
GEF-TRAN-DATE Element: Tran Date	Numeric 8 (yyyymmdd) Updated from the original transaction. Timerecord date.	PR197
GEF-HR-COMPANY Element: Company Hr	Numeric 4	PR197
GEF-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.	PR197
GEF-ACTIVITY Element: Activity	Alpha 15 Not required, updated from the employee's time record.	PR197
GEF-ACCT-CATEGORY Element: Acct Category	Alpha 5 Not required, updated from time record's account category.	PR197
GEF-COMPANY Element: Company	Numeric 4 Required, updated from time record's GL company (DIST-COMPANY).	PR197
GEF-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	PR197
GEF-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	PR197
GEF-SUB-ACCT Element: Sub Acct	Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	PR197
GEF-SALARY-AMT Element: Intl Amt	Signed 18.2 Identifies the calculated salary amount from PR197 distribution. Calculated as follows: Time record wage amount multiplied times the GM labor distribution salary percentage.	PR197 PR85.1
GEF-EFFORT-AMT Element: Intl Amt	Signed 18.2 Identifies the calculated effort amount. Calculated as follows: Time record wage amount multiplied times the GM labor distribution effort percentage.	PR197 PR85.1
GEF-CURRENCY-CODE Element: Currency Code	Alpha 5 Required, identifies currenty for SAL-AMT and EFFORT-AMT. Updated from the employee's time record.	PR197
GEF-CURRENCY-ND Element: Currency Nd	Numeric 1 Required, identifies number of decimals for SAL-AMT and EFFORT-AMT.	PR197
GEF-SAL-RPT-AMT Element: Intl Amt	Signed 18.2 Salary amount exchanged to effort reporting currency.	PR197 PR85.1
GEF-EFFORT-RPT-AMT Element: Intl Amt	Signed 18.2 Planned effort amount exchanged to the effort reporting currency.	PR197 PR85.1
GEF-RPT-CURR Element: Currency Code	Alpha 5 Identifies the effort reporting currency. Effort reporting currency is defined in the employee file.	PR197
GEF-RPT-CURR-ND Element: Currency Nd	Numeric 1 Required, identifies number of decimals for SAL-RPT-AMT and EFFORT-RPT-AMT.	PR197
GEF-PER-END-DATE Element: Per End Date	Numeric 8 (yyyymmdd) Identifies the pay period end date for the effort transaction. Updated during PR197 via the effort update API (GMET90).	PR197
GEF-JOB-CODE Element: Job Code	Alpha 9 Identifies the a user-defined code that represents a type of job code from the timerecord.	PR197
GEF-PAY-CODE Element: Pay Code	Alpha 4 Contains the pay code from the timerecord. A pay code is a user-defined code that identifies a kind of pay.	PR197
GEF-POSITION Element: Position	Alpha 12 Contains the user-defined code that represents a position in the company from the time card.	PR197
GEF-CHECK-ID Element: Check Id	Numeric 12 Contains the payment identification number (unique payment identifier used in tracking payment information).	PR197 PR85.1
GEF-OT-PLAN-CODE Element: Ot Plan Code	Alpha 4 Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).	PR197
GEF-GM-ADJ-TYPE Element: Gm Adj Type	Alpha 1 Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170.	PR197 PR85.1
GEF-GMI-OBJ-ID-1 Element: Obj Id	Numeric 12 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.	PR197
GEF-GMI-OBJ-ID-2 Element: Obj Id	Numeric 12 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.	PR197
GEF-GML-OBJ-ID Element: Obj Id	Numeric 12 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.	PR197
GEF-UPDT-DATE Element: Date	Numeric 8 (yyyymmdd)	PR197
GEF-UPDT-TIME Element: Time	Numeric 8	PR197
GEF-OPERATOR Element: Operator	Alpha 10	PR197

GMTRANEFRT FILE INDEX

GMTRANEFRT FILE RELATIONS

ONE TO ONE RELATIONS

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