|
|
GMTRANEFRT FILE
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 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
UPDATED BY
PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GEF-OBJ-ID Numeric 12 PR197
Element: Obj Id 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 Alpha 1 PR197
Element: Record Type 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 Numeric 8 (yyyymmdd) PR197
Element: Tran Date Updated from the original transaction.
Timerecord date.
GEF-HR-COMPANY Numeric 4 PR197
Element: Company Hr
GEF-EMPLOYEE Numeric 9 PR197
Element: Employee 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 Alpha 15 PR197
Element: Activity Not required, updated from the
employee's time record.
GEF-ACCT-CATEGORY Alpha 5 PR197
Element: Acct Category Not required, updated from time record's
account category.
GEF-COMPANY Numeric 4 PR197
Element: Company Required, updated from time record's GL
company (DIST-COMPANY).
GEF-ACCT-UNIT Alpha 15 PR197
Element: Acct Unit 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 Numeric 6 PR197
Element: Account 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 Numeric 4 PR197
Element: Sub Acct 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 Signed 18.2 PR197
Element: Intl Amt 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 Signed 18.2 PR197
Element: Intl Amt Identifies the calculated effort amount.
Calculated as follows: Time record wage
amount multiplied times the GM labor
distribution effort percentage.
GEF-CURRENCY-CODE Alpha 5 PR197
Element: Currency Code Required, identifies currenty for
SAL-AMT and EFFORT-AMT. Updated from
the employee's time record.
GEF-CURRENCY-ND Numeric 1 PR197
Element: Currency Nd Required, identifies number of decimals
for SAL-AMT and EFFORT-AMT.
GEF-SAL-RPT-AMT Signed 18.2 PR197
Element: Intl Amt Salary amount exchanged to effort
reporting currency.
GEF-EFFORT-RPT-AMT Signed 18.2 PR197
Element: Intl Amt Planned effort amount exchanged to the
effort reporting currency.
GEF-RPT-CURR Alpha 5 PR197
Element: Currency Code Identifies the effort reporting
currency. Effort reporting currency is
defined in the employee file.
GEF-RPT-CURR-ND Numeric 1 PR197
Element: Currency Nd Required, identifies number of decimals
for SAL-RPT-AMT and EFFORT-RPT-AMT.
GEF-PER-END-DATE Numeric 8 (yyyymmdd) PR197
Element: Per End Date Identifies the pay period end date for
the effort transaction. Updated during
PR197 via the effort update API
(GMET90).
GEF-JOB-CODE Alpha 9 PR197
Element: Job Code Identifies the a user-defined code that
represents a type of job code from the
timerecord.
GEF-PAY-CODE Alpha 4 PR197
Element: Pay Code Contains the pay code from the
timerecord. A pay code is a
user-defined code that identifies a
kind of pay.
GEF-POSITION Alpha 12 PR197
Element: Position Contains the user-defined code that
represents a position in the company
from the time card.
GEF-CHECK-ID Numeric 12 PR197
Element: Check Id Contains the payment identification
number (unique payment identifier used
in tracking payment information).
GEF-OT-PLAN-CODE Alpha 4 PR197
Element: Ot Plan Code Identifies pay plan in effect for
employee when PRDISTRIB record was
created from PR197 (PRPRD).
GEF-GM-ADJ-TYPE Alpha 1 PR197
Element: Gm Adj Type Identifies labor cost transfer
adjustment type for PRDISTRIB adjustment
records created by GM170.
GEF-GMI-OBJ-ID-1 Numeric 12 PR197
Element: Obj Id 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 Numeric 12 PR197
Element: Obj Id 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 Numeric 12 PR197
Element: Obj Id 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.
GMTRANEFRT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GEFSET1 OBJ-ID
GEFSET2 HR-COMPANY KeyChange BN305 HR11.1
EMPLOYEE HR11.2 HR511
ACTIVITY PA02.1 PA100
ACCT-CATEGORY PA102 PA115
COMPANY PA13.1 PA13.2
ACCT-UNIT PA502 PA513
ACCOUNT PA52.1 PA52.3
SUB-ACCT PA52.4 PA52.5
OBJ-ID PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
GEFSET3 ACTIVITY KeyChange
ACCT-CATEGORY
OBJ-ID
GMTRANEFRT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
