GMTRANEFRT

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


GMTRANEFRT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GEFSET1 OBJ-ID
PR85.1
GEFSET2 HR-COMPANY
EMPLOYEE
ACTIVITY
ACCT-CATEGORY
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCT
OBJ-ID
KeyChange
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
PR85.1
GEFSET3 ACTIVITY
ACCT-CATEGORY
OBJ-ID
KeyChange


GMTRANEFRT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
GEF-ACCT-CATEGORY->AAX-ACCT-CATEGORY (AAXSET1)
Acactivity ACACTIVITY Not Required
GEF-ACTIVITY->ACV-ACTIVITY
Cucodes CUCODES Not Required
GEF-CURRENCY-CODE->CUC-CURRENCY-CODE
Cucodes Rpt CUCODES Not Required
GEF-RPT-CURR->CUC-CURRENCY-CODE
Employee EMPLOYEE Required
GEF-HR-COMPANY->EMP-COMPANY
GEF-EMPLOYEE->EMP-EMPLOYEE
Glnames GLNAMES Not Required
GEF-COMPANY->GLN-COMPANY
GEF-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Not Required
GEF-COMPANY->GLS-COMPANY
Gmlabdist GMLABDIST Not Required
GEF-GML-OBJ-ID->GML-OBJ-ID
Gmretdist1 GMRETDIST Not Required
GEF-GMI-OBJ-ID-1->GMI-OBJ-ID
Gmretdist2 GMRETDIST Not Required
GEF-GMI-OBJ-ID-2->GMI-OBJ-ID
Prsystem Comp PRSYSTEM Required
GEF-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.