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.
UPDATED BY
| PR197 | PR85.1 | BN305 | HR11.1 | HR11.2 | HR511 |
| PA02.1 | PA100 | PA102 | PA115 | PA13.1 | PA13.2 |
| PA502 | PA513 | PA52.1 | PA52.3 | PA52.4 | PA52.5 |
| PR110 | PR113 | PR120 | PR13.1 | PR13.5 | PR13.6 |
| PR13.8 | PR13.9 |
| 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. |
|
||
| 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 |
|
||
| GEF-TRAN-DATE Element: Tran Date | Numeric 8 (yyyymmdd) Updated from the original transaction. Timerecord date. |
|
||
| GEF-HR-COMPANY Element: Company Hr | Numeric 4 |
|
||
| 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. |
|
||
| GEF-ACTIVITY Element: Activity | Alpha 15 Not required, updated from the employee's time record. |
|
||
| GEF-ACCT-CATEGORY Element: Acct Category | Alpha 5 Not required, updated from time record's account category. |
|
||
| GEF-COMPANY Element: Company | Numeric 4 Required, updated from time record's GL company (DIST-COMPANY). |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
||
| GEF-CURRENCY-CODE Element: Currency Code | Alpha 5 Required, identifies currenty for SAL-AMT and EFFORT-AMT. Updated from the employee's time record. |
|
||
| GEF-CURRENCY-ND Element: Currency Nd | Numeric 1 Required, identifies number of decimals for SAL-AMT and EFFORT-AMT. |
|
||
| GEF-SAL-RPT-AMT Element: Intl Amt | Signed 18.2 Salary amount exchanged to effort reporting currency. |
|
||
| GEF-EFFORT-RPT-AMT Element: Intl Amt | Signed 18.2 Planned effort amount exchanged to the effort reporting currency. |
|
||
| GEF-RPT-CURR Element: Currency Code | Alpha 5 Identifies the effort reporting currency. Effort reporting currency is defined in the employee file. |
|
||
| GEF-RPT-CURR-ND Element: Currency Nd | Numeric 1 Required, identifies number of decimals for SAL-RPT-AMT and EFFORT-RPT-AMT. |
|
||
| 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). |
|
||
| GEF-JOB-CODE Element: Job Code | Alpha 9 Identifies the a user-defined code that represents a type of job code from the timerecord. |
|
||
| 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. |
|
||
| GEF-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company from the time card. |
|
||
| GEF-CHECK-ID Element: Check Id | Numeric 12 Contains the payment identification number (unique payment identifier used in tracking payment information). |
|
||
| 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). |
|
||
| GEF-GM-ADJ-TYPE Element: Gm Adj Type | Alpha 1 Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170. |
|
||
| 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. |
|
||
| 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. |
|
||
| 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. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GEFSET1 |
OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
| GEFSET2 |
HR-COMPANY EMPLOYEE ACTIVITY ACCT-CATEGORY COMPANY ACCT-UNIT ACCOUNT SUB-ACCT OBJ-ID |
|
| ||||||||||||||||||||||||||||||||
| GEFSET3 |
ACTIVITY ACCT-CATEGORY OBJ-ID |
|
|||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
|---|---|---|---|---|---|---|---|---|
| Acacctcat | ACACCTCAT |
Not Required
| ||||||
| Acactivity | ACACTIVITY |
Not Required
| ||||||
| Cucodes | CUCODES |
Not Required
| ||||||
| Cucodes Rpt | CUCODES |
Not Required
| ||||||
| Employee | EMPLOYEE |
Required
| ||||||
| Glnames | GLNAMES |
Not Required
| ||||||
| Glsystem | GLSYSTEM |
Not Required
| ||||||
| Gmlabdist | GMLABDIST |
Not Required
| ||||||
| Gmretdist1 | GMRETDIST |
Not Required
| ||||||
| Gmretdist2 | GMRETDIST |
Not Required
| ||||||
| Prsystem Comp | PRSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.